Layer: Waste Water Force Mains (ID:2)

View In: Map Viewer

Name: Waste Water Force Mains

Display Field: SUBDIVISION_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

This geospatial layer is a polyline feature class that contains information about the location and attributes of more than 320 miles of force mains of the City of Houston’s wastewater collection system. According to the City's Infrastructure Design Manual, a force main is a pressure-rated conduit which conveys wastewater from one pump station to one discharge point. This feature class includes force and sludge.

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:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":8}},"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:

Global ID Field: GLOBALID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true)
CREATIONUSER (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)
FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
UFID (type: esriFieldTypeInteger, alias: UFID, SQL Type: sqlTypeOther, 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)
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)
FIELDVERIFYNUM (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)
PLANDATE (type: esriFieldTypeDate, alias: Plan Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
REHABCOMPLETIONDATE (type: esriFieldTypeDate, alias: Rehab Completion 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)
PERMITDATE (type: esriFieldTypeDate, alias: Permit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUBTYPECD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
LIFECYCLESTATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
MEASUREDLENGTH (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
LENGTHSOURCE (type: esriFieldTypeString, alias: Length Source, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
WASTEWATERTRACEWEIGHT (type: esriFieldTypeInteger, alias: Wastewater Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
DISTANCETODOWNSTREAMMANHOLE (type: esriFieldTypeString, alias: Distance To Downstream Manhole, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
STUBLENGTH (type: esriFieldTypeInteger, alias: Stub Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
SIZE2 (type: esriFieldTypeInteger, alias: Size 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
DIAMETER (type: esriFieldTypeInteger, alias: Size, SQL Type: sqlTypeOther, 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)
PERCENTSLOPE (type: esriFieldTypeDouble, alias: Percent Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
GROUNDCOVER (type: esriFieldTypeDouble, alias: Ground Cover, SQL Type: sqlTypeOther, nullable: true, editable: true)
GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
SUBDIVISION_NAME (type: esriFieldTypeString, alias: Subdivision Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
FISCAL_YEAR (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
LIFTSTATION_NUM (type: esriFieldTypeString, alias: Lift Station Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
LS_DIRECTION (type: esriFieldTypeString, alias: Lift Station Direction, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
NOTES2 (type: esriFieldTypeString, alias: Notes 2, SQL Type: sqlTypeOther, length: 255, 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)
ZONE (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 10, 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)
REHABPLANNUMBER (type: esriFieldTypeString, alias: Rehab 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)
COSTPERACRE (type: esriFieldTypeString, alias: Cost Per Acre, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
CREATIONSOURCE (type: esriFieldTypeString, alias: Financial Assets, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
DATASOURCETYPE (type: esriFieldTypeString, alias: Data Source Type, SQL Type: sqlTypeOther, length: 20, 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)
PLANTYPE (type: esriFieldTypeString, alias: Plan Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
REHABMATERIAL (type: esriFieldTypeString, alias: Rehab Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
SOURCEOFFUND (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
WCRNUMBER (type: esriFieldTypeString, alias: WCR Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
PROJECTNUMBER (type: esriFieldTypeString, alias: File Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
REHABPROJECTNUMBER (type: esriFieldTypeString, alias: Rehab Project Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
DOWNSTREAMMANHOLENUMBER (type: esriFieldTypeString, alias: Downstream Manhole Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
UPSTREAMMANHOLENUMBER (type: esriFieldTypeString, alias: Upstream Manhole Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
PROJECTTYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
REHABMETHOD (type: esriFieldTypeString, alias: Rehab Method, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
DATUM_YEAR (type: esriFieldTypeString, alias: Datum Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
LAND_BASE_REVIEWED (type: esriFieldTypeString, alias: Land Base Reviewed, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
GFSORWBS (type: esriFieldTypeString, alias: GFS-WBS Number, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
GFSWBSNUMBER (type: esriFieldTypeString, alias: PROJECTNUMBER2, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
LENGTH (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADDRESS_ID (type: esriFieldTypeDouble, alias: ADDRESS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
MODELINGUSINVERTLEVEL (type: esriFieldTypeDouble, alias: U/S Pipe Invert Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
MODELINGUSINVERTFLAGDESC (type: esriFieldTypeString, alias: Flag for U/S Pipe Invert Elevation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
MODELINGDSINVERTLEVEL (type: esriFieldTypeDouble, alias: D/S Pipe Invert Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
MODELINGDSINVERTFLAGDESC (type: esriFieldTypeString, alias: Flag for D/S Pipe Invert Elevation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
UNITID2 (type: esriFieldTypeString, alias: Unit ID 2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
MAINCOMP1 (type: esriFieldTypeSmallInteger, alias: Main Comp 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
MAINCOMP2 (type: esriFieldTypeSmallInteger, alias: Main Comp 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
COMPTYPE (type: esriFieldTypeSmallInteger, alias: COMPTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
PARLINENO (type: esriFieldTypeString, alias: PARLINENO, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
UNITID (type: esriFieldTypeString, alias: UNITID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
REPLACEMENTYR (type: esriFieldTypeString, alias: Replacement Year, SQL Type: sqlTypeOther, length: 4, 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:

ENABLED: 1
SUBTYPECD: 1
MATERIAL: PVC
LIFECYCLESTATUS: E
MEASUREDLENGTH: 0
LENGTHSOURCE: MS
DIAMETER: 12

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