Name: Waste Water Service Lines
Display Field: SUBDIVISIONNAME
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: This geospatial layer is a polyline feature class that contains information about the locations and related attributes of service leads of the City of Houston’s wastewater collection system. According to the City's Infrastructure Design Manual, a service lead is a sewer pipe that connects a building sewer to a sewer line that is wholly located within the public Right-Of-Way or public easement.
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.
Copyright Text: City of Houston, Houston Public Works, Houston Water, GIS Services
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -10607389.4601505
YMin: 3477865.33516615
XMax: -10605273.8622892
YMax: 3481971.30115764
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,197,255],"width":0.25}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GLOBALID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true)
- EMPLOYEENUMBER (type: esriFieldTypeString, alias: Employee Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- DATEMODIFIED (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LASTUSER (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- UFID (type: esriFieldTypeInteger, alias: UFID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SUBTYPE (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PLANDATE (type: esriFieldTypeDate, alias: PlanDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- FILENUMBER (type: esriFieldTypeString, alias: File Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SIZECD (type: esriFieldTypeInteger, alias: Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- PERCENTSLOPE (type: esriFieldTypeDouble, alias: Percent Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DISTANCETODOWNSTREAMMANHOLE (type: esriFieldTypeString, alias: Distance To Downstream Manhole, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- UPSTREAMINVERT (type: esriFieldTypeDouble, alias: Upstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DOWNSTREAMINVERT (type: esriFieldTypeDouble, alias: Downstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FIELDVERIFIEDNUMBER (type: esriFieldTypeInteger, alias: Field Verified Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LIFECYCLESTATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- FINANCIALASSETS (type: esriFieldTypeString, alias: Financial Assets, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- FISCALYEAR (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- SUBDIVISIONNAME (type: esriFieldTypeString, alias: Subdivision Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- LANDBASEREVIEWED (type: esriFieldTypeString, alias: Land Base Reviewed, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- QCVERIFIED (type: esriFieldTypeInteger, alias: QC Verified, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- COMPKEY (type: esriFieldTypeInteger, alias: COMPKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- KEYMAP (type: esriFieldTypeString, alias: Key Map, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
- COUNCILDISTRICT (type: esriFieldTypeString, alias: Council District, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ZONE (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- INSERVICEDATE (type: esriFieldTypeDate, alias: In Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- IPSSUBTYPE (type: esriFieldTypeString, alias: IPSSUBTYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- IPSFACILITYID (type: esriFieldTypeString, alias: IPSFACILITYID, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
- ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- DATUM (type: esriFieldTypeString, alias: Datum, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PIPESHAPE (type: esriFieldTypeString, alias: Pipe Shape, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PLANNUMBER (type: esriFieldTypeString, alias: Plan Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ILMSNUMBER (type: esriFieldTypeString, alias: ILMS Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- DATASOURCETYPE (type: esriFieldTypeString, alias: Data Source Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PLANTYPE (type: esriFieldTypeString, alias: Plan Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PROJECTTYPE (type: esriFieldTypeString, alias: ProjectType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- DATUMYEAR (type: esriFieldTypeString, alias: Datum Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- SERVICELENGTH (type: esriFieldTypeDouble, alias: Service Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ADDRESS_ID (type: esriFieldTypeDouble, alias: ADDRESS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GFSORWBS (type: esriFieldTypeString, alias: GFS or WBS, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- GFSWBSNUMBER (type: esriFieldTypeString, alias: GFS-WBS Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
- COMPTYPE (type: esriFieldTypeSmallInteger, alias: COMPTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UNITID (type: esriFieldTypeString, alias: UNITID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- QCDATE (type: esriFieldTypeDate, alias: QC Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: Waste Water Service Lines
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- ENABLED: 1
- SUBTYPE: 0
- MATERIAL: PVC
- LIFECYCLESTATUS: E
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/4/2021 3:56:08 PM
Schema Last Edit Date: 1/4/2021 3:56:08 PM
Data Last Edit Date: 1/4/2021 3:56:08 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat