Name: Wastewater Network Structure

Display Field: FACILITYNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This geospatial layer is a point feature class that contains information about the location and attributes of historical network structures of the City of Houston’s wastewater collection system. The network structure layer includes Lift Station, Private Pump Station, Sampling Well, Sludge Plant, Treatment Plant, Unknown Lift Station, Wet Well, and Wet Weather Facility.The GIS Services Group 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.

Definition Expression: N/A

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

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 5000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: true

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 3018821.212050855
YMin: 1.3763273248972699E7
XMax: 3211897.675766945
YMax: 1.3963283480866596E7
Spatial Reference: 102740  (2278)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPECD
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 30
  Label: Lift Station
  Description:
  Symbol:
  
• Value: 31
  Label: Pump Station
  Description:
  Symbol:
  
• Value: 32
  Label: Sludge Plant
  Description:
  Symbol:
  
• Value: 33
  Label: Treatment Plant
  Description:
  Symbol:
  
• Value: 37
  Label: Unknown Lift Station
  Description:
  Symbol:
  
• Value: 29
  Label: Wet Weather Facility
  Description:
  Symbol:
  
• Value: 38
  Label: Wet Well
  Description:
  Symbol:
  
• Value: 39
  Label: Sampling Well
  Description:
  Symbol:
  
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubtypeCD

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger , alias: Ancillary Role , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• 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 )
• NOTES ( type: esriFieldTypeString , alias: Notes , length: 255 )
• QCVERIFIED ( type: esriFieldTypeInteger , alias: QC Verified , Coded Values: [0: No] , [1: Yes] )
• DATASOURCEREFNUM ( type: esriFieldTypeInteger , alias: Field Verified Number )
• INSERVICEDATE ( type: esriFieldTypeDate , alias: In Service Date , length: 8 )
• EXPDATEFORPROPOSED ( type: esriFieldTypeDate , alias: Exp Date For Proposed , length: 8 )
• CONDITIONDATE ( type: esriFieldTypeDate , alias: Condition 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 )
• FACILITYADDRESS ( type: esriFieldTypeString , alias: Facility Address , length: 30 )
• FACILITYNAME ( type: esriFieldTypeString , alias: Facility Name , length: 20 )
• OUTELEV ( type: esriFieldTypeDouble , alias: Out Elevation )
• INSTALLDATE ( type: esriFieldTypeDate , alias: Install Date , length: 8 )
• LIFECYCLESTATUS ( type: esriFieldTypeString , alias: Lifecycle Status , length: 5 , Coded Values: [E: Features Being Used and Maintained] , [P: Proposed] , [A: Abandoned] , ...1 more... )
• SYMBOLROTATION ( type: esriFieldTypeDouble , alias: Symbol Rotation )
• WASTEWATERTRACEWEIGHT ( type: esriFieldTypeInteger , alias: Wastewater Trace Weight )
• DISTANCETODOWNSTREAMMANHOLE ( type: esriFieldTypeInteger , alias: Distance To Downstream Manhole )
• MANHOLENOTE ( type: esriFieldTypeString , alias: Manhole Note , length: 255 )
• SUBTYPECD ( type: esriFieldTypeInteger , alias: Subtype )
• STRUCTURENAME ( type: esriFieldTypeString , alias: Name , length: 20 )
• OPERATIONALDATE ( type: esriFieldTypeDate , alias: Operational Date , length: 8 )
• REFERENCEID ( type: esriFieldTypeString , alias: Reference ID , length: 20 )
• SIZEOFINPIPE1 ( type: esriFieldTypeInteger , alias: Size Of In-Pipe 1 )
• SIZEOFINPIPE2 ( type: esriFieldTypeInteger , alias: Size Of In-Pipe 2 )
• SIZEOFINPIPE3 ( type: esriFieldTypeInteger , alias: Size Of In-Pipe 3 )
• SIZEOFOUTPIPE ( type: esriFieldTypeInteger , alias: Size of Out-Pipe )
• FLOWELEV ( type: esriFieldTypeDouble , alias: Flow Elevation )
• INLETELEVATION ( type: esriFieldTypeDouble , alias: In Elevation )
• INLETELEVATION2 ( type: esriFieldTypeDouble , alias: In Elevation 2 )
• INLETELEVATION3 ( type: esriFieldTypeDouble , alias: In Elevation 3 )
• INLETELEVATION4 ( type: esriFieldTypeDouble , alias: In Elevation 4 )
• GLOBALID ( type: esriFieldTypeGlobalID , alias: GLOBALID , length: 38 )
• SUBDIVISION_NAME ( type: esriFieldTypeString , alias: Subdivision Name , length: 50 )
• NOTES2 ( type: esriFieldTypeString , alias: Notes 2 , length: 60 )
• COMPKEY ( type: esriFieldTypeInteger , alias: COMPKEY )
• 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... )
• ADDRESS_ID ( type: esriFieldTypeDouble , alias: ADDRESS_ID )
• 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 )
• MODELINGGROUNDLEVEL ( type: esriFieldTypeDouble , alias: Top of the Manhole Elevation )
• MODELINGGROUNDLEVELFLAGDESC ( type: esriFieldTypeString , alias: Flag for Top of the Manhole 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] , ...5 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... )
• 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 )
• CONDITION ( type: esriFieldTypeString , alias: Condition , length: 20 )
• COSTPERACRE ( type: esriFieldTypeString , alias: Cost Per Acre , length: 20 )
• CREATIONSOURCE ( type: esriFieldTypeString , alias: Financial Assets , length: 20 )
• DATASOURCETYPE ( type: esriFieldTypeString , alias: Data Source Type , length: 20 , Coded Values: [BM: Block Map] , [P: Plan and Profile] , [AB: As Built] , ...11 more... )
• MATERIAL ( type: esriFieldTypeString , alias: Material , length: 20 , Coded Values: [ABS: Acrylonitrile Butadiene Styrene] , [BRK: Clay or Concrete Brick] , [CI: Cast Iron] , ...8 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: [CONC: Concrete] , [FBGL: Fiberglass] , [RFBG: Reinforced Fiberglass] , ...3 more... )
• SOURCEOFFUND ( type: esriFieldTypeString , alias: Funding Source , length: 20 )
• WCRNUMBER ( type: esriFieldTypeString , alias: WCR Number , length: 20 )
• SIZEOFCOVER ( type: esriFieldTypeString , alias: Cover Diameter , length: 5 )
• PROJECTNUMBER ( type: esriFieldTypeString , alias: File Number , length: 24 )
• REHABPROJECTNUMBER ( type: esriFieldTypeString , alias: Rehab Project Number , length: 24 )
• DOWNSTREAMDIRECTION ( type: esriFieldTypeString , alias: Downstream Direction , length: 5 , Coded Values: [N: North] , [S: South] , [E: East] , ...1 more... )
• MANHOLENUMBER ( type: esriFieldTypeString , alias: Manhole Number , length: 25 )
• FACILITYSTATUS ( type: esriFieldTypeString , alias: Facility Status , length: 50 )
• 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: [ARC: Adjust Ring/Cover] , [AMH: Abandon MH] , [COAT: Coating] , ...11 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] )
• TOPELEV ( type: esriFieldTypeDouble , alias: Top Elevation )
• UNITID ( type: esriFieldTypeString , alias: UNITID , length: 20 )
• COMPTYPE ( type: esriFieldTypeSmallInteger , alias: COMPTYPE )
• FACILITYNUMBER ( type: esriFieldTypeString , alias: Facility Number , length: 10 )
• IMDKEY ( type: esriFieldTypeInteger , alias: IMD Key )
• METERBASIN ( type: esriFieldTypeString , alias: Meter Basin , length: 20 )
• SERVICEAREA ( type: esriFieldTypeString , alias: Service Area , length: 30 )
• QCDATE ( type: esriFieldTypeDate , alias: QC Date , length: 8 )
• LATITUDE ( type: esriFieldTypeDouble , alias: Latitude )
• LONGITUDE ( type: esriFieldTypeDouble , alias: Longitude )
• PSCNUMBER ( type: esriFieldTypeString , alias: PSC Number , length: 20 )
• SHAPE ( type: esriFieldTypeGeometry , alias: Shape )
• ADDRKEY ( type: esriFieldTypeInteger , alias: ADDRKEY )
• IPSEXPIREDATE ( type: esriFieldTypeDate , alias: IPS Expire Date , length: 8 )
• IPSEXPIREDBY ( type: esriFieldTypeString , alias: IPS Expired By , length: 10 )

Types:

ID: 31
Name: Private Pump Station
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ZONE:
  Inherited

---

ID: 33
Name: Treatment Plant
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ZONE:
  Inherited

---

ID: 32
Name: SludgePlant
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ZONE:
  Inherited

---

ID: 30
Name: Lift Station
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ZONE:
  Inherited

---

ID: 29
Name: WetWeatherFacility
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ZONE:
  Inherited

---

ID: 37
Name: Unknown Lift Station
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ZONE:
  Inherited

---

ID: 38
Name: Wet Well
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ZONE:
  Inherited

---

ID: 39
Name: Sampling Well
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ZONE:
  Inherited

---

Supported Operations:   Query   Generate Renderer   Return Updates