Name: Wastewater

Display Field: SUBDIVISION_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: 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. The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset within a Relational Database Management System (RDBMS). 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.

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

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 3014649.2037613094
YMin: 1.3762945270631611E7
XMax: 3211938.466228783
YMax: 1.3966090418051481E7
Spatial Reference: 102740  (2278)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [250, 52, 17, 255]
Width: 2
Label:
Description:
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: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubtypeCD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• CREATIONUSER ( type: esriFieldTypeString, alias: Employee Number, length: 20 )
• DATECREATED ( type: esriFieldTypeDate, alias: Date Created, length: 8 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: Date Modified, length: 8 )
• LASTUSER ( type: esriFieldTypeString, alias: Last User, length: 20 )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 50 )
• UFID ( type: esriFieldTypeInteger, alias: UFID )
• CONDITION ( type: esriFieldTypeString, alias: Condition, length: 20 )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 255 )
• QCVERIFIED ( type: esriFieldTypeInteger, alias: QC Verified , Coded Values: [0: No] , [1: Yes] )
• FIELDVERIFYNUM ( type: esriFieldTypeInteger, alias: Field Verified Number )
• INSERVICEDATE ( type: esriFieldTypeDate, alias: In Service Date, length: 8 )
• PLANDATE ( type: esriFieldTypeDate, alias: Plan Date, length: 8 )
• REHABCOMPLETIONDATE ( type: esriFieldTypeDate, alias: Rehab Completion Date, length: 8 )
• MOTIONDATE ( type: esriFieldTypeDate, alias: Motion Date, length: 8 )
• PERMITDATE ( type: esriFieldTypeDate, alias: Permit Date, length: 8 )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: Subtype )
• MATERIAL ( type: esriFieldTypeString, alias: Material, length: 5 , Coded Values: [BRK: Clay or Concrete Brick] , [CGMP: Corrugated Metal Pipe] , [CI: Cast Iron] , ...26 more... )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Lifecycle Status, length: 5 , Coded Values: [E: Features Being Used and Maintained] , [P: Proposed] , [A: Abandoned] , ...1 more... )
• MEASUREDLENGTH ( type: esriFieldTypeDouble, alias: Measured Length )
• LENGTHSOURCE ( type: esriFieldTypeString, alias: Length Source, length: 5 , Coded Values: [FM: Field Measurement] , [MS: Mapping System] , [USER: User-Derived] , ...1 more... )
• WASTEWATERTRACEWEIGHT ( type: esriFieldTypeInteger, alias: Wastewater Trace Weight )
• DISTANCETODOWNSTREAMMANHOLE ( type: esriFieldTypeString, alias: Distance To Downstream Manhole, length: 20 )
• STUBLENGTH ( type: esriFieldTypeInteger, alias: Stub Length )
• SIZE2 ( type: esriFieldTypeInteger, alias: Size 2 )
• UPSTREAMINVERT ( type: esriFieldTypeDouble, alias: Upstream Invert )
• DOWNSTREAMINVERT ( type: esriFieldTypeDouble, alias: Downstream Invert )
• DIAMETER ( type: esriFieldTypeInteger, alias: Size , Coded Values: [2: 2"] , [3: 3"] , [4: 4"] , ...41 more... )
• PERCENTSLOPE ( type: esriFieldTypeDouble, alias: Percent Slope )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SUBDIVISION_NAME ( type: esriFieldTypeString, alias: Subdivision Name, length: 50 )
• FISCAL_YEAR ( type: esriFieldTypeString, alias: Fiscal Year, length: 10 , Coded Values: [FY10: FY10] , [FY11: FY11] , [FY12: FY12] , ...38 more... )
• RMD_DELIVERY ( type: esriFieldTypeString, alias: RMD Delivery, length: 15 )
• PUMPLINE_NUMBER ( type: esriFieldTypeString, alias: Pumpline Number, length: 15 )
• NOTES2 ( type: esriFieldTypeString, alias: Notes 2, length: 255 )
• VIDEOLINK ( type: esriFieldTypeString, alias: Video Link, length: 255 )
• BASELINESIZE ( type: esriFieldTypeInteger, alias: Baseline Size , Coded Values: [2: 2"] , [3: 3"] , [4: 4"] , ...41 more... )
• BASELINEMATERIAL ( type: esriFieldTypeString, alias: Baseline Material, length: 5 , Coded Values: [BRK: Clay or Concrete Brick] , [CGMP: Corrugated Metal Pipe] , [CI: Cast Iron] , ...26 more... )
• BASELINEAGE ( type: esriFieldTypeDate, alias: Baseline Age, length: 8 )
• BASELINENOTES ( type: esriFieldTypeString, alias: Baseline Notes, length: 255 )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY )
• CLEANTVDATE ( type: esriFieldTypeDate, alias: Clean TV Date, length: 8 )
• CLEANTVMETHOD ( type: esriFieldTypeString, alias: Clean TV Method, length: 25 , Coded Values: [CCTV: Clean & TV] )
• KEYMAP ( type: esriFieldTypeString, alias: Key Map, length: 14 )
• COUNCILDISTRICT ( type: esriFieldTypeString, alias: Council District, length: 10 , Coded Values: [A: A] , [B: B] , [C: C] , ...8 more... )
• ZONE ( type: esriFieldTypeString, alias: Zone, length: 10 , Coded Values: [GNEHSA: GNEHSA] , [IAH: IAH] , [NE: NE] , ...3 more... )
• TVREPORT ( type: esriFieldTypeString, alias: TV Report, length: 255 )
• MODELINGUSINVERTLEVEL ( type: esriFieldTypeDouble, alias: U/S Pipe Invert Elevation )
• MODELINGUSINVERTFLAGDESC ( type: esriFieldTypeString, alias: Flag for U/S Pipe Invert Elevation, length: 50 )
• MODELINGDSINVERTLEVEL ( type: esriFieldTypeDouble, alias: D/S Pipe Invert Elevation )
• MODELINGDSINVERTFLAGDESC ( type: esriFieldTypeString, alias: Flag for D/S Pipe Invert Elevation, length: 50 )
• IPSSUBTYPE ( type: esriFieldTypeString, alias: IPSSUBTYPE, length: 10 )
• IPSFACILITYID ( type: esriFieldTypeString, alias: IPSFACILITYID, length: 11 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 100 )
• DATUM ( type: esriFieldTypeString, alias: Datum, length: 10 , Coded Values: [COHnnnn: City of Houston] , [CORPnnnn: U.S. Army Corps of Engrs] , [HCFnnnn: Harris County Flood Control] , ...4 more... )
• OWNER ( type: esriFieldTypeString, alias: Owner, length: 10 , Coded Values: [C: City Owned/Maintained] , [P: Privately Owned & Maintained] , [CP: City Own & Privately Maintained] , ...1 more... )
• PIPESHAPE ( type: esriFieldTypeString, alias: Pipe Shape, length: 10 , Coded Values: [RND: Round] , [ARCH: Arch] , [BOX: Box] , ...1 more... )
• PLANNUMBER ( type: esriFieldTypeString, alias: Plan Number, length: 10 )
• REHABPLANNUMBER ( type: esriFieldTypeString, alias: Rehab Plan Number, length: 10 )
• ILMSNUMBER ( type: esriFieldTypeString, alias: ILMS Number, length: 15 )
• COSTPERACRE ( type: esriFieldTypeString, alias: Cost Per Acre, length: 20 )
• CREATIONSOURCE ( type: esriFieldTypeString, alias: Financial Assets, length: 20 , Coded Values: [CIP: CAPITAL IMPROVEMENT PROJECT] , [COMMERCIAL: COMMERCIAL] , [DPC: DEVELOPER PARTICIPATION CONTRACTOR] , ...2 more... )
• DATASOURCETYPE ( type: esriFieldTypeString, alias: Data Source Type, length: 20 , Coded Values: [BM: Block Map] , [P: Plan and Profile] , [AB: As Built] , ...11 more... )
• MOTIONNUMBER ( type: esriFieldTypeString, alias: Motion Number, length: 20 )
• PERMITNUMBER ( type: esriFieldTypeString, alias: Permit Number, length: 20 )
• PLANTYPE ( type: esriFieldTypeString, alias: Plan Type, length: 20 , Coded Values: [P: Plan and Profile] , [R: Rehabilitation Drawing] , [RP: Proposed Rehabilitation Drawing] , ...3 more... )
• REHABMATERIAL ( type: esriFieldTypeString, alias: Rehab Material, length: 20 , Coded Values: [PVC: Polyvinyl Chloride] , [CIPP: Cured in Place Pipe] , [PEP: Polyethylene Pipe] , ...2 more... )
• SOURCEOFFUND ( type: esriFieldTypeString, alias: Funding Source, length: 20 , Coded Values: [PSC: Private Service Connection] , [DNT: Do Not Tap] )
• WCRNUMBER ( type: esriFieldTypeString, alias: WCR Number, length: 20 )
• CLEANTVPROJECTNUMBER ( type: esriFieldTypeString, alias: Clean TV Project Number, length: 24 )
• PROJECTNUMBER ( type: esriFieldTypeString, alias: File Number, length: 24 )
• REHABPROJECTNUMBER ( type: esriFieldTypeString, alias: Rehab Project Number, length: 24 )
• DOWNSTREAMMANHOLENUMBER ( type: esriFieldTypeString, alias: Downstream Manhole Number, length: 25 )
• UPSTREAMMANHOLENUMBER ( type: esriFieldTypeString, alias: Upstream Manhole Number, length: 25 )
• PROJECTTYPE ( type: esriFieldTypeString, alias: Project Type, length: 30 , Coded Values: [JOB: City Job] , [WW: Waste Water] , [GFS: Government Financial System] , ...7 more... )
• REHABMETHOD ( type: esriFieldTypeString, alias: Rehab Method, length: 35 , Coded Values: [CIPP: Cured in Place] , [FLDF: Fold and Form] , [BRST: Pipe Burst] , ...4 more... )
• DATUM_YEAR ( type: esriFieldTypeString, alias: Datum Year, length: 4 )
• LAND_BASE_REVIEWED ( type: esriFieldTypeString, alias: Land Base Reviewed, length: 5 , Coded Values: [N: No] , [Y: Yes] )
• GFSORWBS ( type: esriFieldTypeString, alias: GFS Or WBS, length: 5 , Coded Values: [GFS: Government Financial System] , [WBS: Work Business Structure] )
• GFSWBSNUMBER ( type: esriFieldTypeString, alias: GFS-WBS Number, length: 24 )
• ADDRESS_ID ( type: esriFieldTypeDouble, alias: ADDRESS_ID )
• LENGTH ( type: esriFieldTypeDouble, alias: Length )
• UNITID2 ( type: esriFieldTypeString, alias: Unit ID 2, length: 20 )
• MAINCOMP1 ( type: esriFieldTypeSmallInteger, alias: Main Comp 1 )
• MAINCOMP2 ( type: esriFieldTypeSmallInteger, alias: Main Comp 2 )
• COMPTYPE ( type: esriFieldTypeSmallInteger, alias: COMPTYPE )
• PARLINENO ( type: esriFieldTypeString, alias: PARLINENO, length: 2 )
• UNITID ( type: esriFieldTypeString, alias: UNITID, length: 20 )
• IMSWONUM ( type: esriFieldTypeInteger, alias: IMS Work Order Number )
• REHABWBSNUMBER ( type: esriFieldTypeString, alias: Rehab WBS Number, length: 16 )
• REHABDIAMETER ( type: esriFieldTypeDouble, alias: Rehab Size , Coded Values: [2: 2"] , [3: 3"] , [4: 4"] , ...40 more... )
• REPLACEMENTYR ( type: esriFieldTypeString, alias: Replacement Year, length: 4 , Coded Values: [2010: 2010] , [2011: 2011] , [2012: 2012] , ...18 more... )
• SECONDARYLENGTH ( type: esriFieldTypeDouble, alias: Secondary Length )
• SECONDARYMATERIAL ( type: esriFieldTypeString, alias: Secondary Material, length: 5 , Coded Values: [BRK: Clay or Concrete Brick] , [CGMP: Corrugated Metal Pipe] , [CI: Cast Iron] , ...26 more... )
• QCDATE ( type: esriFieldTypeDate, alias: QC Date, length: 8 )
• PSCNUMBER ( type: esriFieldTypeString, alias: PSC Number, length: 20 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• COMMUNITYSEWERINDICATOR ( type: esriFieldTypeString, alias: Community Sewer Indicator, length: 5 )
• MeterBasin ( type: esriFieldTypeString, alias: Meter Basin, length: 30 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Types:

ID: 9
Name: LS Pump Line
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• MATERIAL:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• LENGTHSOURCE:
  Inherited
• DIAMETER:
  Inherited
• FISCAL_YEAR:
  Inherited
• ZONE:
  Inherited
• REHABMATERIAL:
  Inherited
• REHABMETHOD:
  Inherited
• REHABDIAMETER:
  Inherited
• REPLACEMENTYR:
  Inherited

---

ID: 5
Name: Siphon
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• MATERIAL:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• LENGTHSOURCE:
  Inherited
• DIAMETER:
  Inherited
• FISCAL_YEAR:
  Inherited
• ZONE:
  Inherited
• REHABMATERIAL:
  Inherited
• REHABMETHOD:
  Inherited
• REHABDIAMETER:
  Inherited
• REPLACEMENTYR:
  Inherited

---

ID: 3
Name: Small Diameter Main
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• MATERIAL:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• LENGTHSOURCE:
  Inherited
• DIAMETER:
  Inherited
• FISCAL_YEAR:
  Inherited
• BASELINESIZE:
  Inherited
• BASELINEMATERIAL:
  Inherited
• CLEANTVMETHOD:
  Inherited
• COUNCILDISTRICT:
  Inherited
• ZONE:
  Inherited
• DATUM:
  Inherited
• OWNER:
  Inherited
• PIPESHAPE:
  Inherited
• CREATIONSOURCE:
  Inherited
• DATASOURCETYPE:
  Inherited
• PLANTYPE:
  Inherited
• REHABMATERIAL:
  Inherited
• SOURCEOFFUND:
  Inherited
• PROJECTTYPE:
  Inherited
• REHABMETHOD:
  Inherited
• LAND_BASE_REVIEWED:
  Inherited
• GFSORWBS:
  Inherited
• REHABDIAMETER:
  Inherited
• REPLACEMENTYR:
  Inherited
• SECONDARYMATERIAL:
  Inherited

---

ID: 8
Name: Large Diameter Main
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• MATERIAL:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• LENGTHSOURCE:
  Inherited
• DIAMETER:
  Inherited
• FISCAL_YEAR:
  Inherited
• BASELINESIZE:
  Inherited
• BASELINEMATERIAL:
  Inherited
• CLEANTVMETHOD:
  Inherited
• COUNCILDISTRICT:
  Inherited
• ZONE:
  Inherited
• DATUM:
  Inherited
• OWNER:
  Inherited
• PIPESHAPE:
  Inherited
• CREATIONSOURCE:
  Inherited
• DATASOURCETYPE:
  Inherited
• PLANTYPE:
  Inherited
• REHABMATERIAL:
  Inherited
• SOURCEOFFUND:
  Inherited
• PROJECTTYPE:
  Inherited
• REHABMETHOD:
  Inherited
• LAND_BASE_REVIEWED:
  Inherited
• GFSORWBS:
  Inherited
• REHABDIAMETER:
  Inherited
• REPLACEMENTYR:
  Inherited
• SECONDARYMATERIAL:
  Inherited

---

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata