Name: Water Lateral Service

Display Field: SUBDIVISION_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This geospatial layer is a polyline feature class that contains information about the geographic locations and related attributes of lateral service lines of the City of Houston’s water distribution system. The lateral service feature class includes fire line and hydrant lead. The information for the lateral service layer is derived 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. 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.

Definition Expression: N/A

Copyright Text: Originator: City of Houston, Houston Public Works, Houston Water, GIS Services Publication Date: 06/10/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: 3014674.703505501
YMin: 1.3758400677914917E7
XMax: 3205138.4374676645
YMax: 1.3965644928299755E7
Spatial Reference: 102740  (2278)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 197, 255, 255]
Width: 1
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: Project 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 )
• MOTIONDATE ( type: esriFieldTypeDate , alias: Motion Date , length: 8 )
• PERMITDATE ( type: esriFieldTypeDate , alias: Permit Date , length: 8 )
• 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] )
• 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... )
• PRIVATEFUND ( type: esriFieldTypeString , alias: Private Fund , 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... )
• 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... )
• MOTIONNUMBER ( type: esriFieldTypeString , alias: Motion 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... )
• FACILITYNAME ( type: esriFieldTypeString , alias: Facility Name , length: 35 )
• 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 )
• COMPTYPE ( type: esriFieldTypeSmallInteger , alias: COMPTYPE )
• UNITID ( type: esriFieldTypeString , alias: UNITID , length: 20 )
• SPATIALADJUSTNOTE ( type: esriFieldTypeString , alias: Sptatial Adjustment Notes , length: 255 )
• QCDATE ( type: esriFieldTypeDate , alias: QC Date , length: 8 )
• PSCNUMBER ( type: esriFieldTypeString , alias: PSC Number , length: 20 )
• METERED ( type: esriFieldTypeString , alias: METERED , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• 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 )
• SHAPE ( type: esriFieldTypeGeometry , alias: Shape )
• SHAPE.STLength() ( type: esriFieldTypeDouble , alias: SHAPE.STLength() )

Types:

ID: 6
Name: Fire Line
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• MATERIAL:
  Inherited
• WATERTYPE:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• MEASUREDLENGTH:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited
• SOURCEOFFUND:
  Inherited

---

ID: 5
Name: Hydrant Lead
Domains:
• ENABLED:
  Inherited
• QCVERIFIED:
  Inherited
• MATERIAL:
  Inherited
• WATERTYPE:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• MEASUREDLENGTH:
  Inherited
• LAND_BASE_REVIEWED:
  Inherited
• LENGTHSOURCE:
  Inherited
• FISCAL_YEAR:
  Inherited
• OWNER:
  Inherited
• ZONE:
  Inherited
• SOURCEOFFUND:
  Inherited

---

Supported Operations:   Query   Generate Renderer   Return Updates