Name: Water Private Service Connection

Display Field: SUBDIVISION_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: The pump pressure main layer is a polyline feature class that contains information about the locations and attributes of more than 7,130 miles of water lines of the City of Houston's water distribution system. According to the City of Houston Infrastructure Design Manual, water lines are closed conduits designed to distribute potable water for human consumption, and to provide fire protection. The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset in a Relational Database Management System (RDMS). The pump pressure main layer includes Distribution and Transmission Lines, Well Collection Line, and Take Off. The information for the pump pressure main layer is digitized from Plan and Profile Engineering Drawings obtained from 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. 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.

Definition Expression: N/A

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

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 10000

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: 3014497.081228763
YMin: 1.375828754906191E7
XMax: 3207111.9542177618
YMax: 1.3965740149117246E7
Spatial Reference: 102740  (2278)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [230, 0, 169, 255]
Width: 4
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

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: 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 )
• UFID ( type: esriFieldTypeInteger , alias: UFID )
• NOTES ( type: esriFieldTypeString , alias: Notes , length: 255 )
• QCVERIFIED ( type: esriFieldTypeString , alias: QC Verified , length: 255 , Coded Values: [N: No] , [Y: Yes] )
• PROJECTNUMBER ( type: esriFieldTypeString , alias: File Number , length: 24 )
• PLANNUMBER ( type: esriFieldTypeString , alias: Plan Number , length: 10 )
• PLANDATE ( type: esriFieldTypeDate , alias: Plan Date , length: 8 )
• DATASOURCEREFNUM ( type: esriFieldTypeInteger , alias: Field Verified Number )
• INSERVICEDATE ( type: esriFieldTypeDate , alias: In Service Date , length: 8 )
• CONDITIONDATE ( type: esriFieldTypeDate , alias: Condition Date , length: 8 )
• SUBTYPECD ( type: esriFieldTypeInteger , alias: Subtype )
• MATERIAL ( type: esriFieldTypeString , alias: Material , length: 10 , Coded Values: [PVC: PVC] , [DI: Ductile Iron] , [STL: Steel] , ...13 more... )
• WATERTYPE ( type: esriFieldTypeString , alias: Water Type , length: 5 , Coded Values: [POT: Potable] , [NOPC: Non-Potable] , [NOPW: Non-Potable Well Collector] )
• LIFECYCLESTATUS ( type: esriFieldTypeString , alias: Lifecycle Status , length: 10 , Coded Values: [E: Features Being Used and Maintained] , [P: Proposed] , [A: Abandoned] , ...2 more... )
• MEASUREDLENGTH ( type: esriFieldTypeDouble , alias: Measured Length , Range: [1, 1000000000] )
• WATERTRACEWEIGHT ( type: esriFieldTypeInteger , alias: Water Trace Weight )
• GROUNDSURFACETYPE ( type: esriFieldTypeString , alias: Ground Surface Type , length: 20 )
• PIPETYPE ( type: esriFieldTypeString , alias: Pipe Type , length: 10 )
• GLOBALID ( type: esriFieldTypeGlobalID , alias: GLOBALID , length: 38 )
• 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] )
• 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 )
• LENGTH ( type: esriFieldTypeString , alias: Length , length: 50 )
• 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... )
• RMD_DELIVERY ( type: esriFieldTypeString , alias: RMD Delivery , length: 15 )
• BASELINEMATERIAL ( type: esriFieldTypeString , alias: Baseline Material , length: 5 , Coded Values: [PVC: PVC] , [DI: Ductile Iron] , [STL: Steel] , ...13 more... )
• BASELINEAGE ( type: esriFieldTypeDate , alias: Baseline Age , length: 8 )
• BASELINENOTES ( type: esriFieldTypeString , alias: Baseline Notes , length: 255 )
• 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... )
• 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... )
• ADDRESS ( type: esriFieldTypeString , alias: ADDRESS , length: 100 )
• FACILITYID ( type: esriFieldTypeString , alias: Facility ID , length: 11 )
• CONDITION ( type: esriFieldTypeString , alias: Condition , length: 20 )
• CREATIONSOURCE ( type: esriFieldTypeString , alias: Financial Assets , length: 20 , Coded Values: [CIP: CAPITAL IMPROVEMENT PROJECT] , [COMMERCIAL: COMMERCIAL] , [DPC: DEVELOPER PARTICIPATION CONTRACTOR] , ...2 more... )
• FACILITYNAME ( type: esriFieldTypeString , alias: Facility Name , length: 20 )
• MOTIONNUMBER ( type: esriFieldTypeString , alias: Motion Number , length: 20 )
• PCSNUMBER ( type: esriFieldTypeString , alias: PCS Number , length: 20 )
• PERMITNUMBER ( type: esriFieldTypeString , alias: Permit Number , length: 20 )
• SOURCEOFFUND ( type: esriFieldTypeString , alias: Funding Source , length: 20 , Coded Values: [PSC: Private Service Connection] , [NOTAP: Do Not Tap] )
• 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... )
• FACILITYADDRESS ( type: esriFieldTypeString , alias: Facility Address , length: 30 )
• 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 )
• 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 )
• 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 )
• SPATIALADJUSTNOTE ( type: esriFieldTypeString , alias: Sptatial Adjustment Notes , length: 255 )
• BASESIZE ( type: esriFieldTypeDouble , alias: BASESIZE , Coded Values: [-1: Unknown] , [0: Other] , [0.5: 0.5"] , ...40 more... )
• REHABMETHOD ( type: esriFieldTypeString , alias: Rehab Method , length: 35 , Coded Values: [CIPP: Cured in Place] , [FLDF: Fold and Form] , [BRST: Pipe Burst] , ...3 more... )
• REHABCOMPLETEDATE ( type: esriFieldTypeDate , alias: Rehab Completion Date , length: 8 )
• REHABWBSNUMBER ( type: esriFieldTypeString , alias: Rehab WBS Number , length: 16 )
• REHABPLANNUMBER ( type: esriFieldTypeString , alias: Rehab Plan Number , length: 10 )
• REHABMATERIAL ( type: esriFieldTypeString , alias: Rehab Material , length: 20 , Coded Values: [PVC: Polyvinyl Chloride] , [CIPP: Cured in Place Pipe] , [PEP: Polyethylene Pipe] , ...2 more... )
• REHABPROJECTNUMBER ( type: esriFieldTypeString , alias: Rehab Project Number , length: 24 )
• REHABDIAMETER ( type: esriFieldTypeDouble , alias: Rehab Size , Coded Values: [-1: Unknown] , [0: Other] , [0.5: 0.5"] , ...40 more... )
• REPLACEMENTYR ( type: esriFieldTypeString , alias: Replacement Year , length: 4 , Coded Values: [2010: 2010] , [2011: 2011] , [2012: 2012] , ...18 more... )
• QCDATE ( type: esriFieldTypeDate , alias: QC Date , length: 8 )
• DEADENDLENGTH ( type: esriFieldTypeSmallInteger , alias: Dead End Length )
• PSCNUMBER ( type: esriFieldTypeString , alias: PSC Number , length: 20 )
• BASELINESIZE ( type: esriFieldTypeDouble , alias: Baseline Size , Coded Values: [-1: Unknown] , [0: Other] , [0.5: 0.5"] , ...40 more... )
• OVERSIZEDPIPE ( type: esriFieldTypeString , alias: Oversized Pipe Flag , length: 5 , Coded Values: [N: No] , [Y: Yes] )
• RelativeMainLocation ( type: esriFieldTypeString , alias: Relative Main Location , length: 15 , Coded Values: [aerialcrossing: Aerial Crossing] , [tunnel: Tunnel] )
• COATINGTYPE ( type: esriFieldTypeString , alias: Coating Type , length: 10 )
• LININGTYPE ( type: esriFieldTypeString , alias: Lining Type , length: 10 )
• DEADENDTERMINIATIONASSET ( type: esriFieldTypeString , alias: Dead End Termination Asset , length: 20 )
• DEADENDFLUSHINGEXCLUSION ( type: esriFieldTypeString , alias: Dead End Flushing Exclusion , length: 20 )
• DEADENDSEGMENTID ( type: esriFieldTypeDouble , alias: Dead End Segment ID )
• IPSEXPIREDATE ( type: esriFieldTypeDate , alias: IPS Expire Date , length: 8 )
• IPSEXPIREDBY ( type: esriFieldTypeString , alias: IPS Expired By , length: 10 )
• ADDRKEY ( type: esriFieldTypeInteger , alias: ADDRKEY )
• SHAPE ( type: esriFieldTypeGeometry , alias: Shape )
• SHAPE.STLength() ( type: esriFieldTypeDouble , alias: SHAPE.STLength() )

Types:

ID: 8
Name: Well Collection
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• MATERIAL:
  Inherited
• WATERTYPE:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• MEASUREDLENGTH:
  Inherited
• PIPETYPE:
  Coded Values: [P: Pinchable] , [NP: Non-Pinchable]
• LAND_BASE_REVIEWED:
  Inherited
• LENGTHSOURCE:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 2
Name: Transmission Main
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• MATERIAL:
  Inherited
• WATERTYPE:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• MEASUREDLENGTH:
  Inherited
• PIPETYPE:
  Coded Values: [P: Pinchable] , [NP: Non-Pinchable]
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 1
Name: Distribution Main
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• MATERIAL:
  Inherited
• WATERTYPE:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• MEASUREDLENGTH:
  Inherited
• PIPETYPE:
  Coded Values: [P: Pinchable] , [NP: Non-Pinchable]
• LAND_BASE_REVIEWED:
  Inherited
• LENGTHSOURCE:
  Inherited
• FISCAL_YEAR:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited

---

ID: 13
Name: Take Off
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• MATERIAL:
  Inherited
• WATERTYPE:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• MEASUREDLENGTH:
  Inherited
• PIPETYPE:
  Coded Values: [P: Pinchable] , [NP: Non-Pinchable]
• LAND_BASE_REVIEWED:
  Inherited
• LENGTHSOURCE:
  Inherited
• FISCAL_YEAR:
  Inherited
• BASELINEMATERIAL:
  Inherited
• COUNCILDISTRICT:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited
• CREATIONSOURCE:
  Inherited
• SOURCEOFFUND:
  Inherited
• DATASOURCETYPE:
  Inherited
• PLANTYPE:
  Inherited
• PROJECTTYPE:
  Inherited
• DIAMETER:
  Inherited
• GFSORWBS:
  Inherited

---

Supported Operations:   Query   Generate Renderer   Return Updates