Name: Wastewater Manhole

Display Field: SUBDIVISION_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This geospatial layer is a point feature class that contains information about the location and attributes of manholes of the City of Houston’s wastewater collection system. The manhole feature class includes Diversion Box, Junction Box, and Manhole.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.

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: true

Can Modify Layer: true

Can Scale Symbols: true

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 3014649.2037613094
YMin: 1.3762945270631611E7
XMax: 3211938.4662287384
YMax: 1.3966090418051481E7
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: 12
  Label: Manhole
  Description:
  Symbol:
  
• Value: 13
  Label: Junction Box
  Description:
  Symbol:
  
• Value: 14
  Label: Diversion Box
  Description:
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [MANHOLENUMBER]
Use Coded Values: true
Symbol:
Color: [115, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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 )
• 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] )
• FIELDVERIFYNUM ( type: esriFieldTypeInteger , alias: Field Verified Number )
• CONDITIONDATE ( type: esriFieldTypeDate , alias: COndition Date , length: 8 )
• 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 )
• SIZEOFCOVER ( type: esriFieldTypeString , alias: Cover Diameter , length: 255 )
• 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 )
• DOWNSTREAMDIRECTION ( type: esriFieldTypeString , alias: Downstream Direction , length: 255 , Coded Values: [N: North] , [S: South] , [E: East] , ...1 more... )
• MANHOLENOTE ( type: esriFieldTypeString , alias: Manhole Note , length: 255 )
• SUBTYPECD ( type: esriFieldTypeInteger , alias: Subtype )
• RIMELEVATION ( type: esriFieldTypeDouble , alias: Rim Elevation )
• BURIEDDEPTH ( type: esriFieldTypeDouble , alias: Buried Depth )
• 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 )
• DISTANCETODOWNSTREAMMANHOLE ( type: esriFieldTypeDouble , alias: Distance To Downstream Manhole )
• FISCAL_YEAR ( type: esriFieldTypeString , alias: Fiscal Year , length: 10 , Coded Values: [FY10: FY10] , [FY11: FY11] , [FY12: FY12] , ...38 more... )
• NOTES2 ( type: esriFieldTypeString , alias: Notes 2 , length: 60 )
• X_FROMLIDAR ( type: esriFieldTypeDouble , alias: X From Lidar )
• Y_FROMLIDAR ( type: esriFieldTypeDouble , alias: Y From Lidar )
• Z_FROMLIDAR ( type: esriFieldTypeDouble , alias: Z From Lidar )
• 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] , [SNRTV: Sonar 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... )
• GPSPOSITIONED ( type: esriFieldTypeString , alias: GPS Positioned , length: 5 , Coded Values: [Y: Yes] , [N: No] )
• XCOORD ( type: esriFieldTypeDouble , alias: X Coordinate )
• YCOORD ( type: esriFieldTypeDouble , alias: Y Coordinate )
• ZONE ( type: esriFieldTypeString , alias: Zone , length: 10 , Coded Values: [GNEHSA: GNEHSA] , [IAH: IAH] , [NE: NE] , ...3 more... )
• 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 , 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... )
• 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 )
• 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 )
• MANHOLENUMBER ( type: esriFieldTypeString , alias: Manhole Number , length: 25 )
• TYPE ( type: esriFieldTypeString , alias: Type , length: 25 , Coded Values: [1: MH For Standard Pipe Systems] , [2: MH For MRC Pipe Systems] , [3: MH For Shallow Depth] , ...10 more... )
• 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 )
• 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 )
• UNITID ( type: esriFieldTypeString , alias: UNITID , length: 20 )
• COMPTYPE ( type: esriFieldTypeSmallInteger , alias: COMPTYPE )
• IMSWONUM ( type: esriFieldTypeInteger , alias: IMS Work Order Number )
• REPLACEMENTYR ( type: esriFieldTypeString , alias: Replacement Year , length: 4 , Coded Values: [2010: 2010] , [2011: 2011] , [2012: 2012] , ...18 more... )
• SERVICEADDRESS ( type: esriFieldTypeString , alias: Service Address , length: 100 )
• QCDATE ( type: esriFieldTypeDate , alias: QC Date , length: 8 )
• VOLUME ( type: esriFieldTypeDouble , alias: Volume )
• SSOALERT ( type: esriFieldTypeString , alias: SSO Alert , length: 5 , Coded Values: [N: No] , [Y: Yes] )
• LATITUDE ( type: esriFieldTypeDouble , alias: Latitude )
• LONGITUDE ( type: esriFieldTypeDouble , alias: Longitude )
• PSCNUMBER ( type: esriFieldTypeString , alias: PSC Number , length: 20 )
• SHAPE ( type: esriFieldTypeGeometry , alias: Shape )
• LIFTSTATIONID ( type: esriFieldTypeInteger , alias: Lift Station ID )
• LIFTSTATIONNAME ( type: esriFieldTypeString , alias: Lift Station Name , length: 50 )
• TREATMENTPLANTID ( type: esriFieldTypeInteger , alias: WWTP ID )
• TREATMENTPLANTNAME ( type: esriFieldTypeString , alias: WWTP Name , length: 50 )
• METERBASIN ( type: esriFieldTypeString , alias: Meter Basin , length: 30 )
• FLOODPLAIN ( type: esriFieldTypeString , alias: Floodplain , length: 10 , Coded Values: [100: 100-Year Floodplain] , [100FLWE: 100-Year Floodplain with Elevation] , [100FLWO: 100-Year Floodplain with Overflow] , ...4 more... )
• DEMELEV2008 ( type: esriFieldTypeDouble , alias: DEM Elevation 2008 )
• DEMELEV2018 ( type: esriFieldTypeDouble , alias: DEM Elevation 2018 )
• ADDRKEY ( type: esriFieldTypeInteger , alias: ADDRKEY )
• IPSEXPIREDATE ( type: esriFieldTypeDate , alias: IPS Expire Date , length: 8 )
• IPSEXPIREDBY ( type: esriFieldTypeString , alias: IPS Expired By , length: 10 )
• IPSTEMPFLAG ( type: esriFieldTypeString , alias: Temp Flag , length: 10 )

Types:

ID: 12
Name: Manhole
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DOWNSTREAMDIRECTION:
  Inherited
• FISCAL_YEAR:
  Inherited
• GPSPOSITIONED:
  Inherited
• ZONE:
  Inherited
• REPLACEMENTYR:
  Inherited
• FLOODPLAIN:
  Inherited

---

ID: 14
Name: DiversionBox
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DOWNSTREAMDIRECTION:
  Inherited
• GPSPOSITIONED:
  Inherited
• ZONE:
  Inherited
• REPLACEMENTYR:
  Inherited
• FLOODPLAIN:
  Inherited

---

ID: 13
Name: JunctionBox
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DOWNSTREAMDIRECTION:
  Inherited
• GPSPOSITIONED:
  Inherited
• ZONE:
  Inherited
• REPLACEMENTYR:
  Inherited
• FLOODPLAIN:
  Inherited

---

Supported Operations:   Query   Generate Renderer   Return Updates