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.
OBJECTID (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
ENABLED [Enabled] (Type: Int16, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
CREATIONUSER [Employee Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
DATECREATED [Date Created] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
DATEMODIFIED [Date Modified] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
LASTUSER [Last User] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
FACILITYID [Facility ID] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
UFID (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
CONDITION [Condition] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
CONDITIONDATE [Condition Date] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
NOTES [Notes] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
QCVERIFIED [QC Verified] (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
FIELDVERIFYNUM [Field Verified Number] (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
INSERVICEDATE [In Service Date] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
PLANDATE [Plan Date] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
REHABCOMPLETIONDATE [Rehab Completion Date] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
MOTIONDATE [Motion Date] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
PERMITDATE [Permit Date] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
SUBTYPECD [Subtype] (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
MATERIAL [Material] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
LIFECYCLESTATUS [Lifecycle Status] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
MEASUREDLENGTH [Measured Length] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
LENGTHSOURCE [Length Source] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
WASTEWATERTRACEWEIGHT [Wastewater Trace Weight] (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
DISTANCETODOWNSTREAMMANHOLE [Distance To Downstream Manhole] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
STUBLENGTH [Stub Length] (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
SIZE2 [Size 2] (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
DIAMETER [Size] (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
UPSTREAMINVERT [Upstream Invert] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
DOWNSTREAMINVERT [Downstream Invert] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
PERCENTSLOPE [Percent Slope] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
GROUNDCOVER [Ground Cover] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
GLOBALID (Type: Guid, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
SUBDIVISION_NAME [Subdivision Name] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
FISCAL_YEAR [Fiscal Year] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
LIFTSTATION_NUM [Lift Station Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
LS_DIRECTION [Lift Station Direction] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
NOTES2 [Notes 2] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
COMPKEY (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
KEYMAP [Key Map] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
COUNCILDISTRICT [Council District] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
ZONE [Zone] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
IPSSUBTYPE (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
IPSFACILITYID (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
ADDRESS (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
DATUM [Datum] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OWNER [Owner] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
PIPESHAPE [Pipe Shape] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
PLANNUMBER [Plan Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
REHABPLANNUMBER [Rehab Plan Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
ILMSNUMBER [ILMS Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
COSTPERACRE [Cost Per Acre] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
CREATIONSOURCE [Financial Assets] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
DATASOURCETYPE [Data Source Type] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
MOTIONNUMBER [Motion Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
PERMITNUMBER [Permit Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
PLANTYPE [Plan Type] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
REHABMATERIAL [Rehab Material] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
SOURCEOFFUND [Funding Source] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
WCRNUMBER [WCR Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
PROJECTNUMBER [File Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
REHABPROJECTNUMBER [Rehab Project Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
DOWNSTREAMMANHOLENUMBER [Downstream Manhole Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
UPSTREAMMANHOLENUMBER [Upstream Manhole Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
PROJECTTYPE [Project Type] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
REHABMETHOD [Rehab Method] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
DATUM_YEAR [Datum Year] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
LAND_BASE_REVIEWED [Land Base Reviewed] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
GFSORWBS [GFS-WBS Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
GFSWBSNUMBER [PROJECTNUMBER2] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
LENGTH [Length] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
ADDRESS_ID (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
MODELINGUSINVERTLEVEL [U/S Pipe Invert Elevation] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
MODELINGUSINVERTFLAGDESC [Flag for U/S Pipe Invert Elevation] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
MODELINGDSINVERTLEVEL [D/S Pipe Invert Elevation] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
MODELINGDSINVERTFLAGDESC [Flag for D/S Pipe Invert Elevation] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
UNITID2 [Unit ID 2] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
MAINCOMP1 [Main Comp 1] (Type: Int16, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
MAINCOMP2 [Main Comp 2] (Type: Int16, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
COMPTYPE (Type: Int16, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
PARLINENO (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
UNITID (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
REPLACEMENTYR [Replacement Year] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
QCDATE [QC Date] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
PSCNUMBER [PSC Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
SHAPE [Shape] (Type: Object, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
MeterBasin [Meter Basin] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
SHAPE.STLength() (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)