View In:   ArcGIS Online Map Viewer

Name: Sewer Manholes

Display Field: PlanName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Manhole features connect two or more pipes and control the flow of water in the network through pipe elevations. Manhole invert elevations are stored on the pipes, instead of the manholes themselves. Last update date shows the last time each assest was manipulated in any way. Install update source is how the install date was added into GIS. Last editor should show who the last person to manipulate the assest was. Install date gives an estimation of when each asset was actually installed in the ground, not put into GIS. Update source is the accuracy of each asset in our GIS system, GPS-SURVEY-GRADE is the most accurate form of data we have available.

Service Item Id: e33d056057984f0a902d1300f58bc10b

Copyright Text: UNKNOWN

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 3429538.688099896
YMin: 1.0770534059301624E7
XMax: 3913530.6323324186
YMax: 1.089650410080351E7
Spatial Reference: 102739  (2277)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [176, 0, 138, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• HIGHELEV ( type: esriFieldTypeDouble, alias: High Pipe Elevation In, editable: true, nullable: true, defaultValue: null, modelName: HIGHELEV )
• INVERT ( type: esriFieldTypeDouble, alias: Invert, editable: true, nullable: true, defaultValue: null, modelName: INVERT )
• INVERTELEV ( type: esriFieldTypeDouble, alias: Invert Elevation Out, editable: true, nullable: true, defaultValue: null, modelName: INVERTELEV )
• RIMELEV ( type: esriFieldTypeDouble, alias: Rim Elevation, editable: true, nullable: true, defaultValue: null, modelName: RIMELEV )
• CVTYPE ( type: esriFieldTypeString, alias: Cover Type, editable: true, nullable: true, length: 20, defaultValue: Standard, modelName: CVTYPE , Coded Values: [Standard W/ Lock: Standard W/ Lock] , [Standard W/ Ears: Standard W/ Ears] , [Non-District: Non-District] , ...13 more... )
• WALLMAT ( type: esriFieldTypeString, alias: Wall Material, editable: true, nullable: true, length: 25, defaultValue: PCCP, modelName: WALLMAT , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...34 more... )
• MHTYPE ( type: esriFieldTypeString, alias: Manhole Type, editable: true, nullable: true, length: 15, defaultValue: STD, modelName: MHTYPE , Coded Values: [STD: Standard] , [DRP: Drop] , [SPL: Split] , ...7 more... )
• CONDITION ( type: esriFieldTypeString, alias: Manhole Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• CUTDEPTH ( type: esriFieldTypeDouble, alias: Pavement Cut Depth, editable: true, nullable: true, defaultValue: null, modelName: CUTDEPTH )
• FLOWDIR ( type: esriFieldTypeString, alias: Flow Direction, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FLOWDIR , Coded Values: [North: North] , [East: East] , [South: South] , ...5 more... )
• LINED ( type: esriFieldTypeString, alias: Lined, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LINED , Coded Values: [Yes: Yes] , [No: No] )
• GPSDATE ( type: esriFieldTypeDate, alias: GPS Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: Sewage, modelName: WATERTYPE , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...6 more... )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 0, modelName: ENABLED, required: true , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Tyler] , [2: Smith County] , [3: TxDot] , ...22 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• SUMFLOW ( type: esriFieldTypeDouble, alias: Flow Summary, editable: true, nullable: true, defaultValue: null, modelName: SUMFLOW )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• UPDATESOURCE ( type: esriFieldTypeString, alias: Update Source, editable: true, nullable: true, length: 35, defaultValue: null, modelName: UPDATESOURCE , Coded Values: [PDF As-Built HQ w/ Coordinates: PDF As-Built HQ w/ Coordinates] , [PDF As-Built Manually Georeferenced: PDF As-Built Manually Georeferenced] , [GPS Survey Grade: GPS Survey Grade] , ...11 more... )
• X ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Y )
• MAPGRID_ID ( type: esriFieldTypeString, alias: Historic Mapgrid ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: MAPGRID_ID )
• BENCH_CONST ( type: esriFieldTypeString, alias: BENCH_CONST, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BENCH_CONST )
• MH_INSERT ( type: esriFieldTypeString, alias: Sealing Insert, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MH_INSERT , Coded Values: [Yes: Yes] , [No: No] )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 150, defaultValue: null, modelName: COMMENTS )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Infiltration ( type: esriFieldTypeString, alias: Infiltration, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Infiltration , Coded Values: [S: Stain] , [W: Weeper] , [D: Dripper] , ...2 more... )
• Roots ( type: esriFieldTypeString, alias: Roots, editable: true, nullable: true, length: 12, defaultValue: null, modelName: Roots , Coded Values: [Fine: Fine] , [Tap: Tap] , [Medium: Medium] , ...1 more... )
• RootLocation ( type: esriFieldTypeString, alias: Root Location, editable: true, nullable: true, length: 12, defaultValue: null, modelName: RootLocation , Coded Values: [Lateral: Lateral] , [Chimney: Chimney] , [Cone: Cone] , ...3 more... )
• Regrout ( type: esriFieldTypeString, alias: Regrout, editable: true, nullable: true, length: 12, defaultValue: null, modelName: Regrout , Coded Values: [Cover: Cover] , [Frame: Frame] , [Chimney: Chimney] , ...6 more... )
• Deposits ( type: esriFieldTypeString, alias: Deposits, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Deposits , Coded Values: [AE: Attached Encrustations] , [AGS: Attached Grease] , [AR: Attached Ragging] , ...6 more... )
• SedimentAnalysis ( type: esriFieldTypeSmallInteger, alias: SedimentAnalysis, editable: true, nullable: true, defaultValue: null, modelName: SedimentAnalysis )
• Photo ( type: esriFieldTypeString, alias: Photo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Photo )
• INSTALLDATESRC ( type: esriFieldTypeString, alias: Install Update Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSTALLDATESRC , Coded Values: [CAD: CAD] , [Pre-CAD Blueprint: Pre-CAD Blueprint] , [Subdivision Recd Date: Subdivision Recd Date] , ...5 more... )
• OPENS ( type: esriFieldTypeString, alias: Opens, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OPENS , Coded Values: [Yes: Yes] , [No: No] )
• NEARESTADDR ( type: esriFieldTypeString, alias: Nearest Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NEARESTADDR )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: AssetID )
• Phantom ( type: esriFieldTypeString, alias: PhantomForWinCan, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Phantom , Coded Values: [Yes: Yes] , [No: No] )
• StructuralDefect ( type: esriFieldTypeString, alias: StructuralDefect, editable: true, nullable: true, length: 254, defaultValue: null, modelName: StructuralDefect )
• GRIDREF ( type: esriFieldTypeString, alias: GRIDREF, editable: true, nullable: true, length: 7, defaultValue: null, modelName: GRIDREF )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPECTION_DATE )
• MACP_RATING ( type: esriFieldTypeString, alias: MACP Rating, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MACP_RATING )
• ABANDONED ( type: esriFieldTypeString, alias: Abandoned, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ABANDONED , Coded Values: [Yes: Yes] , [No: No] )
• SurfaceMaterial ( type: esriFieldTypeString, alias: SurfaceMaterial, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SurfaceMaterial , Coded Values: [Brick: Brick] , [Paved - Asphalt: Paved - Asphalt] , [Paved - Brick: Paved - Brick] , ...2 more... )
• BarrelDiameter ( type: esriFieldTypeDouble, alias: BarrelDiameter, editable: true, nullable: true, defaultValue: null, modelName: BarrelDiameter , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...36 more... )
• RepairDate ( type: esriFieldTypeDate, alias: RepairDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RepairDate )
• PLANDATE ( type: esriFieldTypeDate, alias: Plan Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLANDATE )
• PlanName ( type: esriFieldTypeString, alias: Plan Name, editable: true, nullable: true, length: 256, defaultValue: null, modelName: PlanName )
• TOGM ( type: esriFieldTypeString, alias: To Gravity Main, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TOGM )

Templates:

• Name: Sewer Manholes
  Description:
  Prototype:
  RIMELEV: null
  CVTYPE: Standard
  WALLMAT: PCCP
  GPSDATE: null
  LOCDESC: null
  ENABLED: 0
  ACTIVEFLAG: 1
  OWNEDBY: 1
  PlanName: null
  FACILITYID: null
  INSTALLDATE: null
  HIGHELEV: null
  INVERT: null
  INVERTELEV: null
  MHTYPE: STD
  CONDITION: null
  CUTDEPTH: null
  FLOWDIR: null
  LINED: null
  WATERTYPE: Sewage
  MAINTBY: 1
  SUMFLOW: null
  PLANDATE: null
  RepairDate: null
  UPDATESOURCE: null
  X: null
  Y: null
  MAPGRID_ID: null
  BENCH_CONST: null
  MH_INSERT: null
  COMMENTS: null
  TOGM: null
  Infiltration: null
  Roots: null
  RootLocation: null
  Regrout: null
  Deposits: null
  SedimentAnalysis: null
  Photo: null
  INSTALLDATESRC: null
  OPENS: null
  NEARESTADDR: null
  AssetID: null
  Phantom: null
  StructuralDefect: null
  GRIDREF: null
  INSPECTION_DATE: null
  MACP_RATING: null
  ABANDONED: null
  SurfaceMaterial: null
  BarrelDiameter: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field:
• Creator Field:
• Edit Date Field: LASTUPDATE
• Editor Field: LASTEDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata