All Layers and Tables (DeadEnds500ft)

Layers:

Layer: DE (0)

Name:

Display Field:

Type:

Geometry Type:

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:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

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

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

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:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: