Layer: DE (ID:0)

View In: Map Viewer

Name: DE

Display Field: FACILITYNAME

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 7130 miles of water lines of the City of Houston's water distribution system. According to the City of Houston 2016 Infrastructure Design Manual, water lines are closed conduits designed to distribute potable water for human consumption, and to provide fire protection. The pump pressure main layer includes Distribution and Transmission Lines, Well Collection Line, and Take Off.

The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset in a Relational Database Management System.

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.

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:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[179,89,51,255],"width":4.2,"type":"esriSLS","style":"esriSLSSolid"}},"transparency":0}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Join_Count (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
TARGET_FID (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: Ancillary Role, SQL Type: sqlTypeOther, nullable: true, editable: true)
ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true)
CREATIONUSER (type: esriFieldTypeString, alias: Employee Number, SQL Type: sqlTypeOther, length: 30, 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: 30, nullable: true, editable: true)
CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
CONDITIONDATE (type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
UFID (type: esriFieldTypeInteger, alias: UFID, SQL Type: sqlTypeOther, nullable: true, editable: true)
NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
QCVERIFIED (type: esriFieldTypeString, alias: QC Verified, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
PLANDATE (type: esriFieldTypeDate, alias: Plan Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DATASOURCEREFNUM (type: esriFieldTypeInteger, alias: Field Verified Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
INSERVICEDATE (type: esriFieldTypeDate, alias: In Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CREATIONSOURCE (type: esriFieldTypeString, alias: Financial Assets, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
SOURCEOFFUND (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
FACILITYNAME (type: esriFieldTypeString, alias: Facility Name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
FACILITYADDRESS (type: esriFieldTypeString, alias: Facility Address, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
LIFECYCLESTATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
SYMBOLROTATION (type: esriFieldTypeDouble, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
WATERTRACEWEIGHT (type: esriFieldTypeInteger, alias: Water Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
SUBTYPECD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
NORMALPOSITION (type: esriFieldTypeInteger, alias: Normal Position, SQL Type: sqlTypeOther, nullable: true, editable: true)
EMERISOLATIONSYSSTATUS (type: esriFieldTypeString, alias: Emergency Isolation System Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
SMALLMAINDIAMETER (type: esriFieldTypeString, alias: Size 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SUBDIVISION_NAME (type: esriFieldTypeString, alias: Subdivision Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
LAND_BASE_REVIEWED (type: esriFieldTypeString, alias: Land Base Reviewed, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
PERMITDATE (type: esriFieldTypeDate, alias: Permit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MOTIONDATE (type: esriFieldTypeDate, alias: Motion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PRIVATEFUND (type: esriFieldTypeString, alias: Private Fund, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ILMSNUMBER (type: esriFieldTypeString, alias: ILMS Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
FISCAL_YEAR (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
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)
PLANNUMBER (type: esriFieldTypeString, alias: Plan Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
PROJECTNUMBER (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
IPSSUBTYPE (type: esriFieldTypeString, alias: IPS Subtype Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ZONE (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
MOTIONNUMBER (type: esriFieldTypeString, alias: Motion Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
PCSNUMBER (type: esriFieldTypeString, alias: PCS Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
PERMITNUMBER (type: esriFieldTypeString, alias: Permit Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
WCRNUMBER (type: esriFieldTypeString, alias: WCR Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
COSTPERACRE (type: esriFieldTypeString, alias: Cost Per Acre, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
DATASOURCETYPE (type: esriFieldTypeString, alias: Data Source Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
PLANTYPE (type: esriFieldTypeString, alias: Plan Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
PROJECTTYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
LARGEMAINDIAMETER (type: esriFieldTypeDouble, alias: Size, 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)
UNITID (type: esriFieldTypeString, alias: UNITID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
COMPTYPE (type: esriFieldTypeSmallInteger, alias: COMPTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SPATIALADJUSTNOTE (type: esriFieldTypeString, alias: Sptatial Adjustment Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

ANCILLARYROLE: 0
ENABLED: 1
LIFECYCLESTATUS: E
WATERTYPE: POT
SYMBOLROTATION: 0
SUBTYPECD: 4
NORMALPOSITION: 1
OWNER: C

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/28/2021 3:05:24 PM

Schema Last Edit Date: 6/28/2021 3:05:24 PM

Data Last Edit Date: 6/28/2021 3:05:24 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat