View In:   ArcGIS Online Map Viewer

Name: Wastewater Tunnel System

Display Field: TUNNEL_SYS

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="text-align:Justify;"><SPAN>The gravity main layer is a polyline feature class that contains information about the location and attributes of more than 5860 miles of sewer lines of the City of Houston’s sewer collection system. According to the City's Infrastructure Design Manual, a sewer line is a public sewer located within public Right-Of-Way or Permanent Access (PAE)/Public Utility Easement (PUE) that is maintained and operated by the City. The gravity main feature class includes LS Pump Line, Collector, Siphon, and Trunk. </SPAN></P><P><SPAN>The GIS Services Group of Houston Water, </SPAN><SPAN>Houston Public Works currently stores and maintains the dataset within a Relational Database Management System (RDBMS). </SPAN></P><P STYLE="text-align:Justify;"><SPAN>The data are derived from Plan and Profile Engineering drawings obtained from Block Map, As Built, Field Book, Taps and Meters, Metro, Autocad Data from GHW Project, Wastewater Reconciliation Project, Other Source (Operator Input), FVFL, FVFD, Field Verified with Control Number, and Construction Layer.</SPAN></P></DIV></DIV></DIV><DIV><P>This layer was last updated: 2022-10-03 00:55:07.947437.</P></DIV><DIV><P>This layer was last updated: 2023-10-04 00:33:09.457643.</P></DIV>

Copyright Text: City of Houston, Houston Public Works, Houston Water, GIS Services

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 3042120.261412546
YMin: 1.3782431630844817E7
XMax: 3188213.606692463
YMax: 1.3916552106369734E7
Spatial Reference: 102740  (2278)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [106, 175, 79, 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• TUNNEL_SYS ( type: esriFieldTypeString, alias: Tunnel System, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TUNNEL_SYS )
• UFID ( type: esriFieldTypeInteger, alias: UFID, editable: true, nullable: true, defaultValue: null, modelName: UFID )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY, editable: true, nullable: true, defaultValue: null, modelName: COMPKEY )
• ADDRESS_ID ( type: esriFieldTypeDouble, alias: Address ID, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS_ID )
• UNIT_ID ( type: esriFieldTypeString, alias: UNITID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UNIT_ID )
• UNITID2 ( type: esriFieldTypeString, alias: Unit ID 2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UNITID2 )
• SUBTYPE_CD ( type: esriFieldTypeInteger, alias: Subtype Code, editable: true, nullable: true, defaultValue: 3, modelName: SUBTYPE_CD )
• LIFECYSTAT ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LIFECYSTAT )
• INSERVICED ( type: esriFieldTypeDate, alias: In-service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSERVICED )
• PLAN_DATE ( type: esriFieldTypeDate, alias: Plan Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLAN_DATE )
• PLANNUMBER ( type: esriFieldTypeString, alias: Plan Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PLANNUMBER )
• DS_MANHOLE ( type: esriFieldTypeString, alias: Downstream Manhole #, editable: true, nullable: true, length: 25, defaultValue: null, modelName: DS_MANHOLE )
• US_MANHOLE ( type: esriFieldTypeString, alias: Upstream Manhole #, editable: true, nullable: true, length: 25, defaultValue: null, modelName: US_MANHOLE )
• US_INVERT ( type: esriFieldTypeDouble, alias: Upstream Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: US_INVERT )
• DS_INVERT ( type: esriFieldTypeDouble, alias: Downstream Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: DS_INVERT )
• PC_SLOPE ( type: esriFieldTypeDouble, alias: Percent Slope, editable: true, nullable: true, defaultValue: null, modelName: PC_SLOPE )
• PIPE_DIAM ( type: esriFieldTypeSmallInteger, alias: Pipe Diameter, editable: true, nullable: true, defaultValue: null, modelName: PIPE_DIAM )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MATERIAL )
• VIDEOLINK ( type: esriFieldTypeString, alias: Video Link, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VIDEOLINK )
• CLEANTV_DT ( type: esriFieldTypeDate, alias: Clean TV Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLEANTV_DT )
• TVREPORT ( type: esriFieldTypeString, alias: TV Report, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TVREPORT )
• CTV_PJTNUM ( type: esriFieldTypeString, alias: Clean TV Project Number, editable: true, nullable: true, length: 24, defaultValue: null, modelName: CTV_PJTNUM )
• CLEANTV_MT ( type: esriFieldTypeString, alias: Clean TV Method, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CLEANTV_MT )
• REHAB_DATE ( type: esriFieldTypeDate, alias: Rehabilitation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REHAB_DATE )
• REHABPLNUM ( type: esriFieldTypeString, alias: Rehab Plan Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: REHABPLNUM )
• REHAB_MAT ( type: esriFieldTypeString, alias: Rehab Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REHAB_MAT )
• REHAB_METH ( type: esriFieldTypeString, alias: Rehab Method, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REHAB_METH )
• REHAB_DIAM ( type: esriFieldTypeString, alias: Rehabilitated Diameter, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REHAB_DIAM )
• REPLACE_YR ( type: esriFieldTypeString, alias: Replacement Year, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REPLACE_YR )
• BASE_SIZE ( type: esriFieldTypeString, alias: Baseline Size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BASE_SIZE )
• BASE_MAT ( type: esriFieldTypeString, alias: Baseline Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BASE_MAT )
• BASE_AGE ( type: esriFieldTypeDate, alias: Baseline Sewer Age, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BASE_AGE )
• FLOODPLAIN ( type: esriFieldTypeString, alias: Flood Plain, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FLOODPLAIN )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• SERVICE_AR ( type: esriFieldTypeString, alias: Service Area, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERVICE_AR )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )
• USELEV2008 ( type: esriFieldTypeDouble, alias: Upstream LIDAR Elevation 2008, editable: true, nullable: true, defaultValue: null, modelName: USELEV2008 )
• DSELEV2008 ( type: esriFieldTypeDouble, alias: Downstream LIDAR Elevation 2008, editable: true, nullable: true, defaultValue: null, modelName: DSELEV2008 )
• USINVBDPTH ( type: esriFieldTypeDouble, alias: US Invert Buried Depth, editable: true, nullable: true, defaultValue: null, modelName: USINVBDPTH )
• DSINVBDPTH ( type: esriFieldTypeDouble, alias: DS Invert Buried Depth, editable: true, nullable: true, defaultValue: null, modelName: DSINVBDPTH )
• US_BDDEPTH ( type: esriFieldTypeDouble, alias: Upstream Buried Depth, editable: true, nullable: true, defaultValue: null, modelName: US_BDDEPTH )
• DS_BDDEPTH ( type: esriFieldTypeDouble, alias: Downstream Buried Depth, editable: true, nullable: true, defaultValue: null, modelName: DS_BDDEPTH )
• MODELUSIVT ( type: esriFieldTypeString, alias: Model US invert elevation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MODELUSIVT )
• MODELDSIVT ( type: esriFieldTypeString, alias: Model DS invert elevation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MODELDSIVT )
• MODELUSELE ( type: esriFieldTypeString, alias: Model US Surface Elevation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MODELUSELE )
• MODELDSELE ( type: esriFieldTypeString, alias: Model DS Surface Elevation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MODELDSELE )
• MODELUSDTH ( type: esriFieldTypeString, alias: Model US Buried Depth, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MODELUSDTH )
• MODELDSDTH ( type: esriFieldTypeString, alias: Model DS Buried Depth, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MODELDSDTH )
• LS_NAME ( type: esriFieldTypeString, alias: Lift Station Name, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LS_NAME )
• LS_FID ( type: esriFieldTypeInteger, alias: Lift Station ID, editable: true, nullable: true, defaultValue: null, modelName: LS_FID )

Templates:

• Name: Wastewater Tunnel System
  Description:
  Prototype:
  LS_NAME: null
  LS_FID: null
  TUNNEL_SYS: null
  UFID: null
  COMPKEY: null
  ADDRESS_ID: null
  UNIT_ID: null
  UNITID2: null
  SUBTYPE_CD: 3
  LIFECYSTAT: null
  INSERVICED: null
  PLAN_DATE: null
  PLANNUMBER: null
  DS_MANHOLE: null
  US_MANHOLE: null
  US_INVERT: null
  DS_INVERT: null
  PC_SLOPE: null
  PIPE_DIAM: null
  MATERIAL: null
  VIDEOLINK: null
  CLEANTV_DT: null
  TVREPORT: null
  CTV_PJTNUM: null
  CLEANTV_MT: null
  REHAB_DATE: null
  REHABPLNUM: null
  REHAB_MAT: null
  REHAB_METH: null
  REHAB_DIAM: null
  REPLACE_YR: null
  BASE_SIZE: null
  BASE_MAT: null
  BASE_AGE: null
  FLOODPLAIN: null
  LONGITUDE: null
  LATITUDE: null
  SERVICE_AR: null
  MODELDSDTH: null
  USELEV2008: null
  DSELEV2008: null
  USINVBDPTH: null
  DSINVBDPTH: null
  US_BDDEPTH: null
  DS_BDDEPTH: null
  MODELUSIVT: null
  MODELDSIVT: null
  MODELUSELE: null
  MODELDSELE: null
  MODELUSDTH: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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