Name: Abandoned Water Pipe

Display Field: FACILITYNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: The abandoned Water Pipe dataset is a polyline feature class that contains information about pipes, including mains and laterals that are still on the ground but not in use within the water distribution system of the City of Houston, Texas. The locations and attributes of the abandoned Water Pipe dataset are digitized from the Plan and Profile Engineering drawings that come from the following sources: Block Map, As-Built, Field Verified with Control Number, Taps and Meters, Metro, Field Verified Fire Department, Field Verified Fire Line, Construction Drawing (Layer), Fire Department, and Capital Improvement Project. The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset in a Relational Database Management System. Geospatial or map data maintained by the Houston Public Works for informational purposes and may not have been prepared for or be suitable for legal, engineering, or surveying purposes. It does not represent an on-the-ground survey and only represents the approximate location of these assets.

Copyright Text: Originator: City of Houston, Houston Public Works, Houston Water, GIS Services Publication Date: 06/14/2021 Contact Person: Kirt Arthur / kirt.arthur@houstontx.gov

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

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: 3020468.1333319694
YMin: 1.3762713650647596E7
XMax: 3202588.054533884
YMax: 1.3956770290769935E7
Spatial Reference: 102740  (2278)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [255, 0, 197, 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: 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 )
• CREATIONUSER ( type: esriFieldTypeString, alias: Employee Number, length: 30 )
• DATECREATED ( type: esriFieldTypeDate, alias: Date Created, length: 8 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: Date Modified, length: 8 )
• LASTUSER ( type: esriFieldTypeString, alias: Last User, length: 30 )
• CONDITION ( type: esriFieldTypeString, alias: Condition, length: 20 )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• UFID ( type: esriFieldTypeInteger, alias: UFID )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 255 )
• QCVERIFIED ( type: esriFieldTypeString, alias: QC Verified, length: 20 , Coded Values: [N: No] , [Y: Yes] )
• PLANDATE ( type: esriFieldTypeDate, alias: Plan Date, length: 8 )
• DATASOURCEREFNUM ( type: esriFieldTypeInteger, alias: Field Verified Number )
• INSERVICEDATE ( type: esriFieldTypeDate, alias: In Service Date, length: 8 )
• CREATIONSOURCE ( type: esriFieldTypeString, alias: Financial Assets, length: 20 , Coded Values: [CIP: CAPITAL IMPROVEMENT PROJECT] , [COMMERCIAL: COMMERCIAL] , [DPC: DEVELOPER PARTICIPATION CONTRACTOR] , ...2 more... )
• COUNCILDISTRICT ( type: esriFieldTypeString, alias: Council District, length: 20 )
• KEYMAP ( type: esriFieldTypeString, alias: Key Map, length: 20 )
• SOURCEOFFUND ( type: esriFieldTypeString, alias: Funding Source, length: 20 )
• FACILITYNAME ( type: esriFieldTypeString, alias: Facility Name, length: 20 )
• FACILITYADDRESS ( type: esriFieldTypeString, alias: Facility Address, length: 30 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Lifecycle Status, length: 10 , Coded Values: [E: Features Being Used and Maintained] , [P: Proposed] , [A: Abandoned] , ...2 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Material, length: 50 )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: Subtype )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• SUBDIVISION_NAME ( type: esriFieldTypeString, alias: Subdivision Name, length: 50 )
• LAND_BASE_REVIEWED ( type: esriFieldTypeString, alias: Land Base Reviewed, length: 25 , Coded Values: [N: No] , [Y: Yes] )
• LENGTH ( type: esriFieldTypeString, alias: Length, length: 50 )
• LENGTHSOURCE ( type: esriFieldTypeString, alias: Length Source, length: 5 , Coded Values: [FM: Field Measurement] , [MS: Mapping System] , [USER: User-Derived] , ...1 more... )
• PERMITDATE ( type: esriFieldTypeDate, alias: Permit Date, length: 8 )
• MOTIONDATE ( type: esriFieldTypeDate, alias: Motion Date, length: 8 )
• PRIVATEFUND ( type: esriFieldTypeString, alias: Private Fund, length: 50 )
• MEASUREDLENGTH ( type: esriFieldTypeDouble, alias: Measured Length , Range: [1, 1000000] )
• ILMSNUMBER ( type: esriFieldTypeString, alias: ILMS Number, length: 30 )
• FISCAL_YEAR ( type: esriFieldTypeString, alias: Fiscal Year, length: 10 , Coded Values: [FY10: FY10] , [FY11: FY11] , [FY12: FY12] , ...38 more... )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY )
• PLANNUMBER ( type: esriFieldTypeString, alias: Plan Number, length: 10 )
• PROJECTNUMBER ( type: esriFieldTypeString, alias: Project Number, length: 24 )
• OWNER ( type: esriFieldTypeString, alias: Owner, length: 10 , Coded Values: [C: City Owned/Maintained] , [P: Privately Owned & Maintained] , [CP: City Own & Privately Maintained] , ...1 more... )
• IPSSUBTYPE ( type: esriFieldTypeString, alias: IPS Subtype Code, length: 10 )
• ZONE ( type: esriFieldTypeString, alias: Zone, length: 10 , Coded Values: [GNEHSA: GNEHSA] , [IAH: IAH] , [NE: NE] , ...3 more... )
• GFSORWBS ( type: esriFieldTypeString, alias: GFSORWBS, length: 5 )
• GFSWBSNUMBER ( type: esriFieldTypeString, alias: GFSWBSNUMBER, length: 24 )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 11 )
• MOTIONNUMBER ( type: esriFieldTypeString, alias: Motion Number, length: 20 )
• PERMITNUMBER ( type: esriFieldTypeString, alias: Permit Number, length: 20 )
• WCRNUMBER ( type: esriFieldTypeString, alias: WCR Number, length: 20 )
• COSTPERACRE ( type: esriFieldTypeString, alias: Cost Per Acre, length: 30 )
• DATASOURCETYPE ( type: esriFieldTypeString, alias: Data Source Type, length: 30 , Coded Values: [BM: Block Map] , [P: Plan and Profile] , [AB: As Built] , ...10 more... )
• PLANTYPE ( type: esriFieldTypeString, alias: Plan Type, length: 30 , Coded Values: [P: Plan and Profile] , [THD: Texas Highway Department] , [WD: Water Drawing] , ...5 more... )
• PROJECTTYPE ( type: esriFieldTypeString, alias: Project Type, length: 30 , Coded Values: [BG: Budgeted Job] , [C: Private Construction] , [JOB: City Job] , ...10 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Size , Coded Values: [-1: Unknown] , [0: Other] , [0.5: 0.5"] , ...40 more... )
• GROUNDCOVER ( type: esriFieldTypeDouble, alias: Ground Cover )
• ADDRESS_ID ( type: esriFieldTypeDouble, alias: ADDRESS_ID )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 100 )
• 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 )
• QCDATE ( type: esriFieldTypeDate, alias: QC Date, length: 8 )
• PSCNUMBER ( type: esriFieldTypeString, alias: PSC Number, length: 20 )
• ABANDONMENTSOURCE ( type: esriFieldTypeString, alias: Abandonment Source, length: 50 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Types:

ID: 7
Name: Casing
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 8
Name: Well Collection
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• LAND_BASE_REVIEWED:
  Inherited
• LENGTHSOURCE:
  Inherited
• MEASUREDLENGTH:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 1
Name: Distribution Main
Domains:
• QCVERIFIED:
  Inherited
• CREATIONSOURCE:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• LAND_BASE_REVIEWED:
  Inherited
• LENGTHSOURCE:
  Inherited
• FISCAL_YEAR:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 2
Name: Transmission Main
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 4
Name: Gravity Main
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 3
Name: Unknown
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 6
Name: Fire Line
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 5
Name: Hydrant Lead
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 7
Name: Casing
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 8
Name: Well Collection
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• LAND_BASE_REVIEWED:
  Inherited
• LENGTHSOURCE:
  Inherited
• MEASUREDLENGTH:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 1
Name: Distribution Main
Domains:
• QCVERIFIED:
  Inherited
• CREATIONSOURCE:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• LAND_BASE_REVIEWED:
  Inherited
• LENGTHSOURCE:
  Inherited
• FISCAL_YEAR:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 2
Name: Transmission Main
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 4
Name: Gravity Main
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 3
Name: Unknown
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 6
Name: Fire Line
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 5
Name: Hydrant Lead
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata