Name: Wastewater Abandoned Device

Display Field: SUBDIVISION_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This geospatial layer contains information about abandoned wastewater devices that are still on the ground but not in use within the wastewater collection system of the City of Houston, Texas.The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset within a Relational Database Management System (RDMS). 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: 3024830.456562981
YMin: 1.3758857993388519E7
XMax: 3206122.4877607524
YMax: 1.3955754612313733E7
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: 5
  Label: EndofLine
  Description:
  Symbol:
  
• Value: 4
  Label: Interconnect
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 255, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [169, 0, 230, 255] Width: 0
• Value: 3
  Label: Plug
  Description:
  Symbol:
  
• Value: 1
  Label: Reducer
  Description:
  Symbol:
  
• Value: 10
  Label: Stack
  Description:
  Symbol:
  
• Value: 2
  Label: Star Tap
  Description:
  Symbol:
  
• Value: 8
  Label: Tee
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [0, 0, 0, 0]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 7
  Label: Wye1
  Description:
  Symbol:
  
• Value: 35
  Label: Wye2
  Description:
  Symbol:
  
• Value: 21
  Label: Valve
  Description:
  Symbol:
  
• Value: 20
  Label: Valve in Manhole
  Description:
  Symbol:
  
• Value: 44
  Label: Plug Valve
  Description:
  Symbol:
  
• Value: 27
  Label: Air Release Valve
  Description:
  Symbol:
  
• Value: 26
  Label: Air Valve
  Description:
  Symbol:
  
• Value: 28
  Label: Vacuum
  Description:
  Symbol:
  
• Value: 45
  Label: Check Valve
  Description:
  Symbol:
  
• 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: 38
  Label: Unknown Lift Station
  Description:
  Symbol:
  
• Value: 29
  Label: Wet Weather Facility
  Description:
  Symbol:
  
• Value: 42
  Label: Wet Well
  Description:
  Symbol:
  
• Value: 43
  Label: Sampling Well
  Description:
  Symbol:
  
• Value: 22
  Label: Cleanout
  Description:
  Symbol:
  
• Value: 23
  Label: Pig Launching Station
  Description:
  Symbol:
  
• Value: 12
  Label: Manhole
  Description:
  Symbol:
  
• Value: 13
  Label: Junction Box
  Description:
  Symbol:
  
• Value: 14
  Label: Diversion Box
  Description:
  Symbol:
  
• Value: 24
  Label: Permanent Flow Meter
  Description:
  Symbol:
  
• Value: 36
  Label: Sanitary Node
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 255, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [169, 0, 230, 255] Width: 0
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 )
• 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 )
• LIFECYCLESTATUS ( type: esriFieldTypeString , alias: Lifecycle Status , length: 5 , Coded Values: [E: Features Being Used and Maintained] , [P: Proposed] , [A: Abandoned] , ...1 more... )
• DIAMETER ( type: esriFieldTypeDouble , alias: Diameter )
• SYMBOLROTATION ( type: esriFieldTypeDouble , alias: Symbol Rotation )
• MANHOLENOTE ( type: esriFieldTypeString , alias: Manhole Note , length: 255 )
• 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 )
• RIMELEVATION ( type: esriFieldTypeDouble , alias: Rim Elevation )
• SIZEOFCOVER ( type: esriFieldTypeDouble , alias: Cover Diameter )
• TOPELEVATION ( type: esriFieldTypeDouble , alias: Top Elevation )
• DOWNSTREAMDIRECTION ( type: esriFieldTypeString , alias: Downstream Direction , length: 5 )
• ENABLED ( type: esriFieldTypeSmallInteger , alias: Enabled , Coded Values: [0: False] , [1: True] )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger , alias: Ancillary Role , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• GLOBALID ( type: esriFieldTypeGlobalID , alias: GLOBALID , length: 38 )
• SUBDIVISION_NAME ( type: esriFieldTypeString , alias: Subdivision Name , length: 50 )
• SIZE1 ( type: esriFieldTypeDouble , alias: Size 1 )
• SIZE2 ( type: esriFieldTypeDouble , alias: Size 2 )
• 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... )
• 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... )
• 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 )
• 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 )
• 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 )
• PROJECTTYPE ( type: esriFieldTypeString , alias: Project Type , length: 30 , Coded Values: [JOB: City Job] , [PN: Permit Number (Private Job)] , [WW: Waste Water] , ...4 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] )
• 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 )
• QCDATE ( type: esriFieldTypeDate , alias: QC Date , length: 8 )
• PSCNUMBER ( type: esriFieldTypeString , alias: PSC Number , length: 20 )
• SHAPE ( type: esriFieldTypeGeometry , alias: Shape )

Types:

ID: 10
Name: Stack
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 26
Name: Air Valve
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 20
Name: Valve in Manhole
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 8
Name: Tee
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 13
Name: Junction Box
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 22
Name: Cleanout
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 7
Name: Wye1
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 4
Name: Interconnect
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 28
Name: Vacuum
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 16
Name: Butterfly
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

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

---

ID: 23
Name: Pig Launching Station
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 29
Name: Wet Weather Facility
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 2
Name: Star Tap
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 3
Name: Plug
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 17
Name: Cone
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

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

---

ID: 5
Name: EndofLine
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 27
Name: Air Release Valve
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 35
Name: Wye2
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 15
Name: Ball
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 18
Name: Gate
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 12
Name: Manhole
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 19
Name: Valve Plug
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

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

---

ID: 21
Name: Valve
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

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

---

ID: 24
Name: Permanent Flow Meter
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 14
Name: Diversion Box
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 1
Name: Reducer
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• FISCAL_YEAR:
  Inherited
• ZONE:
  Inherited

---

ID: 36
Name: Sanitary Node
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

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

---

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

---

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

---

ID: 44
Name: Plug Valve
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 45
Name: Check Valve
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• ZONE:
  Inherited

---

ID: 25
Name: Unknown
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• FISCAL_YEAR:
  Inherited
• COUNCILDISTRICT:
  Inherited
• ZONE:
  Inherited
• DATUM:
  Inherited
• OWNER:
  Inherited
• CREATIONSOURCE:
  Inherited
• DATASOURCETYPE:
  Inherited
• MATERIAL:
  Inherited
• PLANTYPE:
  Inherited
• REHABMATERIAL:
  Inherited
• PROJECTTYPE:
  Inherited
• REHABMETHOD:
  Inherited
• LAND_BASE_REVIEWED:
  Inherited
• GFSORWBS:
  Inherited

---

Supported Operations:   Query   Generate Renderer   Return Updates