Layer: Waste Water Gravity Mains (ID:3)

View In: Map Viewer

Name: Waste Water Gravity Mains

Display Field: SUBDIVISION_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

The gravity main layer is a polyline feature class that contains information about the location and attributes of more than 5860 miles of sewer lines of the City of Houston’s sewer collection system. According to the City's Infrastructure Design Manual, a sewer line is a public sewer located within public Right-Of-Way or Permanent Access (PAE)/Public Utility Easement (PUE) that is maintained and operated by the City. The gravity main feature class includes LS Pump Line, Collector, Siphon, and Trunk.

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":2}},"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)
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)
DIAMETER (type: esriFieldTypeInteger, alias: Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
PERCENTSLOPE (type: esriFieldTypeDouble, alias: Percent Slope, 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)
RMD_DELIVERY (type: esriFieldTypeString, alias: RMD Delivery, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
PUMPLINE_NUMBER (type: esriFieldTypeString, alias: Pumpline Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
NOTES2 (type: esriFieldTypeString, alias: Notes 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
VIDEOLINK (type: esriFieldTypeString, alias: Video Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BASELINESIZE (type: esriFieldTypeInteger, alias: Baseline Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
BASELINEMATERIAL (type: esriFieldTypeString, alias: Baseline Material, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
BASELINEAGE (type: esriFieldTypeDate, alias: Baseline Age, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
BASELINENOTES (type: esriFieldTypeString, alias: Baseline Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
COMPKEY (type: esriFieldTypeInteger, alias: COMPKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
CLEANTVDATE (type: esriFieldTypeDate, alias: Clean TV Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CLEANTVMETHOD (type: esriFieldTypeString, alias: Clean TV Method, SQL Type: sqlTypeOther, length: 25, 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)
TVREPORT (type: esriFieldTypeString, alias: TV Report, SQL Type: sqlTypeOther, length: 255, 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)
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)
CLEANTVPROJECTNUMBER (type: esriFieldTypeString, alias: Clean TV Project Number, SQL Type: sqlTypeOther, length: 24, 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 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)
ADDRESS_ID (type: esriFieldTypeDouble, alias: ADDRESS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
LENGTH (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, 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)
IMSWONUM (type: esriFieldTypeInteger, alias: IMS Work Order Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
REHABWBSNUMBER (type: esriFieldTypeString, alias: Rehab WBS Number, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
REHABDIAMETER (type: esriFieldTypeDouble, alias: Rehab Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
REPLACEMENTYR (type: esriFieldTypeString, alias: Replacement Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
SECONDARYLENGTH (type: esriFieldTypeDouble, alias: Secondary Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
SECONDARYMATERIAL (type: esriFieldTypeString, alias: Secondary Material, SQL Type: sqlTypeOther, length: 5, 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: 3
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