20220716 09483200 FALSE 20240126 14070400 20240126 14070400 sGravityMain 002 3014649.203761 3211938.466229 13762945.270632 13964701.286186 1 Relationship Relationship PUDGIS.HOUSTON.sGravityMain_sOperationsRecord PUDGIS.HOUSTON.Anno_48_126 Relationship PUDGIS.HOUSTON.sGravityMain_sRootControl Relationship Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.8'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,1968500.0],PARAMETER[&quot;False_Northing&quot;,13123333.33333333],PARAMETER[&quot;Central_Meridian&quot;,-99.0],PARAMETER[&quot;Standard_Parallel_1&quot;,28.38333333333333],PARAMETER[&quot;Standard_Parallel_2&quot;,30.28333333333333],PARAMETER[&quot;Latitude_Of_Origin&quot;,27.83333333333333],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2278]]</WKT><XOrigin>-126725700</XOrigin><YOrigin>-77828800</YOrigin><XYScale>34994581.165044703</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.10000000000000001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102740</WKID><LatestWKID>2278</LatestWKID></ProjectedCoordinateSystem> 1.0 FGDC CSDGM Metadata 150000000 5000 ItemDescription Esri ArcGIS 10.2.1.3588 en The gravity main layer is a polyline feature class that contains information about the location and attributes of more than 5,860 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. The gravity main geospatial layer provides quality geospatial data of the City of Houston’s sewer collection system to wastewater Operations. This polyline feature class supports the City’s work management systems (IPS: Infor Public Sector; IMS: Infrastructure Management System), and web application (GIMS: geographic Information Management System). The geospatial dataset was officially published with the Geographic Information Management System (GIMS) on October 31, 1997 (Hudson and Fischer, 1999; Fischer and Hudson, 2000). However, the City of Houston’s effort to create its core geospatial infrastructure database dates back to 1989. Prior to 2009, the geospatial dataset was created and maintained within ArcInfo coverage. This dataset only contains geospatial data for the City’s public water distribution system, with a temporal coverage dating back to 1910. As the city grows and infrastructure ages, the geospatial dataset is being continuously updated with new construction, and ongoing maintenance data. According to the City of Houston Infrastructure Design Manual (Rudick and Lincoln, 2016), all wastewater lines and appurtenances are digitized within the public Right-Of-Way or a dedicated public easement. References Rudick, D. A. and T. J. Lincoln. 2016. Infrastructure Design Manual. City of Houston, Department of Public Works and Engineering. Available at https://edocs.publicworks.houstontx.gov/documents/design_manuals/idm.pdf Fischer, N. and R.E.Hudson, 2000. The City of Houston Infrastructure Management System (IMS): integration of a work order management system with the existing public works and engineering GIS. URISA 2000 Annual Conference Proceeding. Chicago, IL. Available at https://library.esri.com/docs/11740.pdf Hudson, R.E. and N. Fischer. 1999. The Houston Story: GIS Solution for City of Houston Department of Public Works and Engineering. URISA 99 Annual Conference Proceeding. Chicago, IL. Available at https://library.esri.com/docs/6335.pdf City of Houston 19971031 Gravity Main HOUSTON.sGravityMain vector digital data withheld publication date 1997 present In work Daily -95.771793 -95.067631 30.103064 29.535124 2994688.246068 3211955.626667 13762905.069050 13962878.232998 Sewer wastewater None The gravity main layer is prepared and made available for general reference purposes only and should not be used, or relied upon for specific applications, without independent verification. The City of Houston neither represents, nor warrants the data accuracy, or completeness, nor will the City of Houston accept liability of any kind in conjunction with its use. Feature Class Kirt Arthur City of Houston, Houston Public Works, Houston Water, GIS Services GIS Supervisor physical address
611 Walker St.
Houston TX 77002 USA (832) 395-2868 Kirt.Arthur@houstontx.gov City of Houston, Houston Public Works, Houston Water, GIS Services None Unclassified N/A Version 6.2 (Build 9200) ; Esri ArcGIS 10.9.1.28388 Gravity Main John Young City of Houston, Houston Public Works, Houston Water, GIS Services GIS Supervisor Kirt Arthur John Young 2994688.246068 3211955.626667 13962878.232998 13762905.06905 1 -95.771793 -95.067631 30.103064 29.535124 1 1 -95.709028 -95.067491 30.106537 29.535236 The gravity main geospatial layer provides quality geospatial data of the City of Houston’s sewer collection system to wastewater Operations. This polyline feature class supports the City’s work management systems (IPS: Infor Public Sector; IMS: Infrastructure Management System), and web application (GIMS: geographic Information Management System). <DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="text-align:Justify;"><SPAN>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. </SPAN></P><P><SPAN>The GIS Services Group of Houston Water, </SPAN><SPAN>Houston Public Works currently stores and maintains the dataset within a Relational Database Management System (RDBMS). </SPAN></P><P STYLE="text-align:Justify;"><SPAN>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.</SPAN></P></DIV></DIV></DIV> City of Houston, Houston Public Works, Houston Water, GIS Services Wastewater Gravity Main Sewer Line test <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The gravity main layer is prepared and made available for general reference purposes only and should not be used, or relied upon for specific applications, without independent verification. The City of Houston neither represents, nor warrants the data accuracy, or completeness, nor will the City of Houston accept liability of any kind in conjunction with its use.</SPAN></P></DIV></DIV></DIV> The geospatial dataset was officially published with the Geographic Information Management System (GIMS) on October 31, 1997 (Hudson and Fischer, 1999; Fischer and Hudson, 2000). However, the City of Houston’s effort to create its core geospatial infrastructure database dates back to 1989. Prior to 2009, the geospatial dataset was created and maintained within ArcInfo coverage. This dataset only contains geospatial data for the City’s public water distribution system, with a temporal coverage dating back to 1910. As the city grows and infrastructure ages, the geospatial dataset is being continuously updated with new construction, and ongoing maintenance data. According to the City of Houston Infrastructure Design Manual (Rudick and Lincoln, 2016), all wastewater lines and appurtenances are digitized within the public Right-Of-Way or a dedicated public easement. References Rudick, D. A. and T. J. Lincoln. 2016. Infrastructure Design Manual. City of Houston, Department of Public Works and Engineering. Available at https://edocs.publicworks.houstontx.gov/documents/design_manuals/idm.pdf Fischer, N. and R.E.Hudson, 2000. The City of Houston Infrastructure Management System (IMS): integration of a work order management system with the existing public works and engineering GIS. URISA 2000 Annual Conference Proceeding. Chicago, IL. Available at https://library.esri.com/docs/11740.pdf Hudson, R.E. and N. Fischer. 1999. The Houston Story: GIS Solution for City of Houston Department of Public Works and Engineering. URISA 99 Annual Conference Proceeding. Chicago, IL. Available at https://library.esri.com/docs/6335.pdf Kirt Arthur City of Houston, Houston Public Works, Houston Water, GIS Services GIS Supervisor Kirt Arthur John Young Kirt Arthur en FGDC Content Standards for Digital Geospatial Metadata FGDC-STD-001-1998 local time Kirt Arthur City of Houston, Houston Public Works, Houston Water, GIS Services physical address Houston TX 77002
611 Walker St.
USA (832)-395-2868 Kirt.Arthur@houstontx.gov GIS Supervisor 20170323 None None Unclassified N/A None ISO 19115 Geographic Information - Metadata DIS_ESRI1.0 dataset Downloadable Data City of Houston, Houston Public Works, Houston Water, GIS Services Kirt Arthur GIS Supervisor physical address
611 Walker St.
Houston TX 77002 USA (832) 395-2868 Kirt.Arthur@houstontx.gov 002 withheld Local Area Network Feature Class Kirt Arthur City of Houston, Houston Public Works, Houston Water, GIS Services GIS Supervisor Kirt Arthur John Young Kirt Arthur File Geodatabase Feature Class Vector Simple FALSE 0 TRUE FALSE GCS_North_American_1983 NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_Feet coordinate pair survey feet 0.000000 0.000000 North American Datum of 1983 Geodetic Reference System 80 6378137.000000 298.257222 Explicit elevation coordinate included with horizontal coordinates 1.000000 NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_Feet EPSG 6.11(9.0.0) 0 sGravityMain Feature Class 0 A public sewer located within public Right-Of-Way or Permanent Access Easement/Public Utility Easement that is maintained and operated by the City. City of Houston Infrastructure Design Manual, 2016 OBJECTID OBJECTID OID 4 0 0 ESRI-generated primary key number. ESRI Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 0 0 0 Feature geometry. ESRI Coordinates defining the features. Enabled Enabled SmallInteger 2 0 0 CreationUser Employee Number String 20 0 0 Identification of the user who created the feature class. DateCreated Date Created Date 8 0 0 Date the feature class was created. DateModified Date Modified Date 8 0 0 Date the feature class was last modified. LastUser Last User String 20 0 0 Identification of the user who last updated the feature class. FacilityID Facility ID String 50 0 0 Facility identification number. City of Houston Water Distribution System UFID UFID Integer 4 0 0 Unique number identifier initially created for the Fire Department. Condition Condition String 20 0 0 Denotes a specific classification of work. ConditionDate Condition Date Date 8 0 0 Date condition evaluation was made. Notes Notes String 255 0 0 Additional information regarding the feature class. QCVerified QC Verified Integer 4 0 0 Quality Assurance/Control verification. ProjectNumber File Number String 24 0 0 Porject Number ProjectType Project Type String 30 0 0 Project Type Owner Owner String 10 0 0 Ownership of the facility (Public or Private). DataSourceType Data Source Type String 20 0 0 Source of the data. InServiceDate In Service Date Date 8 0 0 Date the asset was put into service. CreationSource Financial Assets String 20 0 0 Denotes a specific classification of work. FIELDVERIFYNUM Field Verified Number Integer 4 0 0 Field Verified Number. CouncilDistrict Council District String 10 0 0 City Council District which the feature falls within. City of Houston Council District KeyMap Key Map String 14 0 0 Key Map page and location (1A-999Z). SourceofFund Funding Source String 20 0 0 Source of Funding. Datum Datum String 10 0 0 Datum for the source plan. Wastewater Plan and Profile Engineering Drawing PlanDate Plan Date Date 8 0 0 Plan Date Wastewater Plan and Profile Engineering Drawing PlanNumber Plan Number String 10 0 0 Plan Number assigned to Feature by Permitting Center. City of Houston Permitting Center PlanType Plan Type String 20 0 0 Plan Type GIMS Data Dictionary, City of Houston, 1999 RehabCompletionDate Rehab Completion Date Date 8 0 0 The date the rehabilitation was completed. Wastewater Rehabilitation Project RehabMaterial Rehab Material String 20 0 0 Pipe material used for the rehabilitation project. Wastewater Rehabilitation Project RehabMethod Rehab Method String 35 0 0 Method of rehabilitation used. Wastewater Rehabilitation Project RehabProjectNumber Rehab Project Number String 24 0 0 Rehabilitation project number. Wastewater Rehabilitation Project RehabPlanNumber Rehab Plan Number String 10 0 0 Rehabilitation plan number. Wastewater Rehabilitation Project WCRNumber WCR Number String 20 0 0 MotionNumber Motion Number String 20 0 0 Number assigned to specific motion when approved. MotionDate Motion Date Date 8 0 0 Date that motion was approved. CostPerAcre Cost Per Acre String 20 0 0 Cost associated with private service connection-defined features. PermitNumber Permit Number String 20 0 0 Number assigned to feature by Permitting Center. City of Houston Permiting Center PermitDate Permit Date Date 8 0 0 Date that permit was assigned. SubtypeCD Subtype Integer 4 0 0 Subset of features. Material Material String 5 0 0 Pipe material Wastewater Plan and Profile Engineering Drawing LifecycleStatus Lifecycle Status String 5 0 0 Pipe status (Proposed, Existing, Abandoned, Status of the project (Proposed, Existing, Abandoned, Rehabilitated). Wastewater Plan and Profile Engineering Drawing MeasuredLength Measured Length Double 8 0 0 Measure Pipe Length in feet. Length measure from Wastewater Plan and Profile Engineering Drawing LengthSource Length Source String 5 0 0 Specifies where the length value was derived. Wastewater Plan and Profile Engineering Drawing VIDEOLINK Video Link String 255 0 0 Hyperlink to the most recent TV inspection video file for a specific feature. TV Inspection BASELINESIZE Baseline Size Integer 4 0 0 Baseline Size Master Size field. BASELINEMATERIAL Baseline Material String 5 0 0 Baseline Material Based on Plan & Profile and/or Rehabilitation documents. BASELINEAGE Baseline Age Date 8 0 0 Baseline Age Based on In service Date and/or Rehabilitation documents. BASELINENOTES Baseline Notes String 255 0 0 Description of non-documented sources. COMPKEY COMPKEY Integer 4 0 0 IPS specific unique identifier linking records from a geodatabase to the IPS database. Used to synchronize values using GeoAdministrator. IPS: Infor Public Sector CLEANTVDATE Clean TV Date Date 8 0 0 Clean TV Date. CLEANTVMETHOD Clean TV Method String 25 0 0 Clean TV method used. WastewaterTraceWeight Wastewater Trace Weight Integer 4 0 0 Represents the cost of traversing a feature in the geometric network. DistanceToDownstreamManhole Distance To Downstream Manhole String 20 0 0 Distance in feet to next manhole downstream. Wastewater Plan and Profile Engineering Drawing ZONE Zone String 10 0 0 Defines the Utility Maintenance Zone that the feature falls within. TVREPORT TV Report String 255 0 0 Hyperlink to the most recent TV inspection report for a specific feature. TV Inspection MODELINGUSINVERTLEVEL U/S Pipe Invert Elevation Double 8 0 0 Upstream water pipe invert elevation modified/adjusted based on datum correction result from InfoWorks modeling software (Alias: U/S Pipe Invert Elevation). Planning and Deveolpment Group MODELINGUSINVERTFLAGDESC Flag for U/S Pipe Invert Elevation String 50 0 0 Upstream water pipe invert elevation modified based on datum correction result from InfoWorks modeling software (Alias: Flag for U/S Pipe Invert Elevation). Planning and Deveolpment Group MODELINGDSINVERTLEVEL D/S Pipe Invert Elevation Double 8 0 0 Downstream water pipe invert elevation modified/adjusted based on datum correction result from InfoWorks modeling software (Alias: D/S Pipe Invert Elevation). Planning and Deveolpment Group MODELINGDSINVERTFLAGDESC Flag for D/S Pipe Invert Elevation String 50 0 0 Downstream water pipe invert elevation modified based on datum correction result from InfoWorks modeling software (Alias: D/S Pipe Invert Elevation). Planning and Deveolpment Group UpstreamManholeNumber Upstream Manhole Number String 25 0 0 Number of the manhole at the beginning of a line segment. IPSSUBTYPE IPSSUBTYPE String 10 0 0 IPS related text type reiteration of the UFID value for a record. IPS: Infor Public Sector IPSFACILITYID IPSFACILITYID String 11 0 0 IPS Facility Identification Number. IPS: Infor Public Sector ADDRESS ADDRESS String 100 0 0 Nearest address to the feature. DownstreamManholeNumber Downstream Manhole Number String 25 0 0 Number of the manhole at the end of a line segment. PipeShape Pipe Shape String 10 0 0 Pipe Shape StubLength Stub Length Integer 4 0 0 Stub Length in feet. Size2 Size 2 Integer 4 0 0 Pipe diameter in inches for Box, Arch, and semi major axis for oval. GIMS Data Dictionary, City of Houston, 1999 UpstreamInvert Upstream Invert Double 8 0 0 Upstream invert elevation. GIMS Data Dictionary, City of Houston, 1999 DownstreamInvert Downstream Invert Double 8 0 0 Downstream invert elevation. GIMS Data Dictionary, City of Houston, 1999 Diameter Size Integer 4 0 0 Pipe Diameter in inches if round. GIMS Data Dictionary, City of Houston, 1999 PercentSlope Percent Slope Double 8 0 0 Slope in percent. GIMS Data Dictionary, City of Houston, 1999 LS Pump Line 9 ENABLED 1 EnabledDomain_7 Coded Value Default value Default value SmallInteger QCVERIFIED sYes/No Indicator - Integer Coded Value Default value Duplicate Integer SUBTYPECD sProject Type Coded Value Default value Duplicate HOUSTON String 7 MATERIAL sWater Line Material Coded Value Default value Duplicate String PVC LIFECYCLESTATUS sLifecycle Status Coded Value Default value Duplicate String E MEASUREDLENGTH sCreation Source Coded Value Default value Duplicate HOUSTON String 0 LENGTHSOURCE sLength Source Coded Value Default value Duplicate String MS DIAMETER sWaste Water Line Diameter Coded Value Default value Duplicate Integer 12 FISCAL_YEAR sFiscalYear Coded Value Default value Duplicate String BASELINESIZE 7 sWaste Water Line Diameter Coded Value Default value Duplicate Integer BASELINEMATERIAL 7 sWater Line Material Coded Value Default value Duplicate String CLEANTVMETHOD 7 sCleanTVMethod Clean TV Method for Wastewater Gravity Mains Coded Value Default value Default value String COUNCILDISTRICT PVC COH Council District City Council Districts Coded Value Default value Default value String ZONE E UM Zones Utility Maintenance Zones Coded Value Default value Default value String DATUM sDatum_2 Coded Value Default value Duplicate String 0 OWNER MS sOwner Coded Value Default value Duplicate String PIPESHAPE 12 sPipe Shape Coded Value Default value Duplicate String CREATIONSOURCE sCreation Source Coded Value Default value Duplicate String 12 DATASOURCETYPE sData Source Type LINE Coded Value Default value Duplicate String PLANTYPE sPlan Type Coded Value Default value Duplicate String REHABMATERIAL sRehabilitation Material LINE Coded Value Default value Duplicate String SOURCEOFFUND sSourceoffund Coded Value Default value Default value String PROJECTTYPE sProject Type Coded Value Default value Duplicate String REHABMETHOD sRehabilitation Method LINE Coded Value Default value Duplicate String LAND_BASE_REVIEWED Yes No Reviewed Coded Value Default value Default value String GFSORWBS sProject Type2 Coded Value Default value Duplicate String COMPTYPE 21 REHABDIAMETER sRehabilitation Diameter Wastewater Rehabilitation Diameter Coded Value Default value Default value Double REPLACEMENTYR ReplacementYear Replacement Year Coded Value Default value Default value String SECONDARYMATERIAL sWater Line Material Coded Value Default value Duplicate String COMMUNITYSEWERINDICATOR Yes/No Indicator Coded Value Default value Default value String Siphon 5 ENABLED 1 EnabledDomain_7 Coded Value Default value Default value SmallInteger QCVERIFIED sYes/No Indicator - Integer Coded Value Default value Duplicate Integer SUBTYPECD sProject Type Coded Value Default value Duplicate HOUSTON String 5 MATERIAL sWater Line Material Coded Value Default value Duplicate String PVC LIFECYCLESTATUS sLifecycle Status Coded Value Default value Duplicate String E MEASUREDLENGTH sCreation Source Coded Value Default value Duplicate HOUSTON String 0 LENGTHSOURCE sLength Source Coded Value Default value Duplicate String MS DIAMETER sWaste Water Line Diameter Coded Value Default value Duplicate Integer 12 FISCAL_YEAR sFiscalYear Coded Value Default value Duplicate String BASELINESIZE 6 sWaste Water Line Diameter Coded Value Default value Duplicate Integer BASELINEMATERIAL 7 sWater Line Material Coded Value Default value Duplicate String CLEANTVMETHOD PVC sCleanTVMethod Clean TV Method for Wastewater Gravity Mains Coded Value Default value Default value String COUNCILDISTRICT E COH Council District City Council Districts Coded Value Default value Default value String ZONE 0 UM Zones Utility Maintenance Zones Coded Value Default value Default value String DATUM sDatum_2 Coded Value Default value Duplicate String MS OWNER 12 sOwner Coded Value Default value Duplicate String PIPESHAPE 12 sPipe Shape Coded Value Default value Duplicate String CREATIONSOURCE sCreation Source Coded Value Default value Duplicate String DATASOURCETYPE sData Source Type LINE Coded Value Default value Duplicate String PLANTYPE sPlan Type Coded Value Default value Duplicate String REHABMATERIAL sRehabilitation Material LINE Coded Value Default value Duplicate String SOURCEOFFUND sSourceoffund Coded Value Default value Default value String PROJECTTYPE sProject Type Coded Value Default value Duplicate String REHABMETHOD sRehabilitation Method LINE Coded Value Default value Duplicate String LAND_BASE_REVIEWED Yes No Reviewed Coded Value Default value Default value String GFSORWBS sProject Type2 Coded Value Default value Duplicate String REHABDIAMETER sRehabilitation Diameter Wastewater Rehabilitation Diameter Coded Value Default value Default value Double REPLACEMENTYR ReplacementYear Replacement Year Coded Value Default value Default value String SECONDARYMATERIAL sWater Line Material Coded Value Default value Duplicate String COMMUNITYSEWERINDICATOR Yes/No Indicator Coded Value Default value Default value String Small Diameter Main 3 ENABLED 1 EnabledDomain_7 Coded Value Default value Default value SmallInteger QCVERIFIED sYes/No Indicator - Integer Coded Value Default value Duplicate Integer SUBTYPECD sProject Type Coded Value Default value Duplicate HOUSTON String 3 MATERIAL sWater Line Material Coded Value Default value Duplicate String PVC LIFECYCLESTATUS sLifecycle Status Coded Value Default value Duplicate String E MEASUREDLENGTH sCreation Source Coded Value Default value Duplicate HOUSTON String 0 LENGTHSOURCE sLength Source Coded Value Default value Duplicate String MS DIAMETER sWaste Water Line Diameter Coded Value Default value Duplicate Integer 12 FISCAL_YEAR sFiscalYear Coded Value Default value Duplicate String BASELINESIZE 4 sWaste Water Line Diameter Coded Value Default value Duplicate Integer BASELINEMATERIAL 6 sWater Line Material Coded Value Default value Duplicate String CLEANTVMETHOD PVC sCleanTVMethod Clean TV Method for Wastewater Gravity Mains Coded Value Default value Default value String COUNCILDISTRICT E COH Council District City Council Districts Coded Value Default value Default value String ZONE 0 UM Zones Utility Maintenance Zones Coded Value Default value Default value String DATUM sDatum_2 Coded Value Default value Duplicate String MS OWNER 12 sOwner Coded Value Default value Duplicate String PIPESHAPE 12 sPipe Shape Coded Value Default value Duplicate String CREATIONSOURCE sCreation Source Coded Value Default value Duplicate String DATASOURCETYPE sData Source Type LINE Coded Value Default value Duplicate String PLANTYPE sPlan Type Coded Value Default value Duplicate String REHABMATERIAL sRehabilitation Material LINE Coded Value Default value Duplicate String SOURCEOFFUND sSourceoffund Coded Value Default value Default value String PROJECTTYPE sProject Type Coded Value Default value Duplicate String REHABMETHOD sRehabilitation Method LINE Coded Value Default value Duplicate String LAND_BASE_REVIEWED Yes No Reviewed Coded Value Default value Default value String GFSORWBS sProject Type2 Coded Value Default value Duplicate String REHABDIAMETER sRehabilitation Diameter Wastewater Rehabilitation Diameter Coded Value Default value Default value Double REPLACEMENTYR ReplacementYear Replacement Year Coded Value Default value Default value String SECONDARYMATERIAL sWater Line Material Coded Value Default value Duplicate String COMMUNITYSEWERINDICATOR Yes/No Indicator Coded Value Default value Default value String Large Diameter Main 8 ENABLED 1 EnabledDomain_7 Coded Value Default value Default value SmallInteger QCVERIFIED sYes/No Indicator - Integer Coded Value Default value Duplicate Integer SUBTYPECD sProject Type Coded Value Default value Duplicate HOUSTON String 8 MATERIAL sWater Line Material Coded Value Default value Duplicate String PVC LIFECYCLESTATUS sLifecycle Status Coded Value Default value Duplicate String E MEASUREDLENGTH sCreation Source Coded Value Default value Duplicate HOUSTON String 0 LENGTHSOURCE sLength Source Coded Value Default value Duplicate String MS DIAMETER sWaste Water Line Diameter Coded Value Default value Duplicate Integer 12 FISCAL_YEAR sFiscalYear Coded Value Default value Duplicate String BASELINESIZE 3 sWaste Water Line Diameter Coded Value Default value Duplicate Integer BASELINEMATERIAL 4 sWater Line Material Coded Value Default value Duplicate String CLEANTVMETHOD PVC sCleanTVMethod Clean TV Method for Wastewater Gravity Mains Coded Value Default value Default value String COUNCILDISTRICT E COH Council District City Council Districts Coded Value Default value Default value String ZONE 0 UM Zones Utility Maintenance Zones Coded Value Default value Default value String DATUM sDatum_2 Coded Value Default value Duplicate String MS OWNER MS sOwner Coded Value Default value Duplicate String PIPESHAPE sPipe Shape Coded Value Default value Duplicate String 12 CREATIONSOURCE 12 sCreation Source Coded Value Default value Duplicate String DATASOURCETYPE sData Source Type LINE Coded Value Default value Duplicate String PLANTYPE sPlan Type Coded Value Default value Duplicate String REHABMATERIAL sRehabilitation Material LINE Coded Value Default value Duplicate String SOURCEOFFUND sSourceoffund Coded Value Default value Default value String PROJECTTYPE sProject Type Coded Value Default value Duplicate String REHABMETHOD sRehabilitation Method LINE Coded Value Default value Duplicate String LAND_BASE_REVIEWED Yes No Reviewed Coded Value Default value Default value String GFSORWBS sProject Type2 Coded Value Default value Duplicate String REHABDIAMETER sRehabilitation Diameter Wastewater Rehabilitation Diameter Coded Value Default value Default value Double REPLACEMENTYR ReplacementYear Replacement Year Coded Value Default value Default value String SECONDARYMATERIAL sWater Line Material Coded Value Default value Duplicate String COMMUNITYSEWERINDICATOR Yes/No Indicator Coded Value Default value Default value String Collector 3 ENABLED 1 EnabledDomain Coded Value Default value Default value HOUSTON SmallInteger QCVERIFIED sYes/No Indicator - Integer Coded Value Default value Duplicate HOUSTON Integer PROJECTTYPE sProject Type Coded Value Default value Duplicate HOUSTON String OWNER sOwner Coded Value Default value Duplicate HOUSTON String DATASOURCETYPE sData Source Type LINE Coded Value Default value Duplicate HOUSTON String CREATIONSOURCE sCreation Source Coded Value Default value Duplicate HOUSTON String SOURCEOFFUND sSourceoffund Coded Value Default value Default value HOUSTON String DATUM sDatum Coded Value Default value Duplicate HOUSTON String PLANTYPE sPlan Type Coded Value Default value Duplicate HOUSTON String REHABMATERIAL 5 sRehabilitation Material LINE Coded Value Default value Duplicate HOUSTON String REHABMETHOD 5 sRehabilitation Method LINE Coded Value Default value Duplicate HOUSTON String SUBTYPECD 3 sWater Line Material Coded Value Default value Duplicate HOUSTON String MATERIAL PVC sWater Line Material Coded Value Default value Duplicate HOUSTON String LIFECYCLESTATUS E sLifecycle Status Coded Value Default value Duplicate HOUSTON String MEASUREDLENGTH sLength Source Coded Value Default value Duplicate HOUSTON String 0 LENGTHSOURCE MS sLength Source Coded Value Default value Duplicate HOUSTON String PIPESHAPE 12 sPipe Shape Coded Value Default value Duplicate HOUSTON String DIAMETER sWaste Water Line Diameter Coded Value Default value Duplicate HOUSTON Integer 12 LAND_BASE_REVIEWED Yes No Reviewed Coded Value Default value Default value HOUSTON String DOWNSTREAMDIRECTION sDownstream Direction Coded Value Default value Duplicate HOUSTON String FISCAL_YEAR sFiscalYear Coded Value Default value Duplicate HOUSTON String PROJECTTYPE2 sProject Type2 Coded Value Default value Duplicate HOUSTON String Siphon 5 ENABLED 1 EnabledDomain Coded Value Default value Default value HOUSTON SmallInteger QCVERIFIED sYes/No Indicator - Integer Coded Value Default value Duplicate HOUSTON Integer PROJECTTYPE sProject Type Coded Value Default value Duplicate HOUSTON String OWNER sOwner Coded Value Default value Duplicate HOUSTON String DATASOURCETYPE sData Source Type LINE Coded Value Default value Duplicate HOUSTON String CREATIONSOURCE sCreation Source Coded Value Default value Duplicate HOUSTON String DATUM sDatum Coded Value Default value Duplicate HOUSTON String PLANTYPE sPlan Type Coded Value Default value Duplicate HOUSTON String REHABMATERIAL sRehabilitation Material LINE Coded Value Default value Duplicate HOUSTON String REHABMETHOD 8 sRehabilitation Method LINE Coded Value Default value Duplicate HOUSTON String SUBTYPECD 5 sWater Line Material Coded Value Default value Duplicate HOUSTON String MATERIAL PVC sWater Line Material Coded Value Default value Duplicate HOUSTON String LIFECYCLESTATUS E sLifecycle Status Coded Value Default value Duplicate HOUSTON String MEASUREDLENGTH 0 sLength Source Coded Value Default value Duplicate HOUSTON String LENGTHSOURCE sLength Source Coded Value Default value Duplicate HOUSTON String MS PIPESHAPE 12 sPipe Shape Coded Value Default value Duplicate HOUSTON String DIAMETER 12 sWaste Water Line Diameter Coded Value Default value Duplicate HOUSTON Integer FISCAL_YEAR sFiscalYear Coded Value Default value Duplicate HOUSTON String PROJECTTYPE2 wProject Type2 Coded Value Default value Duplicate HOUSTON String DATUM_YEAR Datum Year String 4 0 0 Year datum was established or revised. GIMS Data Dictionary, City of Houston, 1999 CLEANTVPROJECTNUMBER Clean TV Project Number String 24 0 0 Clean TV project number. TV Inspection SUBDIVISION_NAME Subdivision Name String 50 0 0 Name of subdivision in which a feature falls. LAND_BASE_REVIEWED Land Base Reviewed String 5 0 0 Binary column verifying spatial adjustment of features to nearby land base. LENGTH Length Double 8 0 0 Pipe Length in feet. ILMSNUMBER ILMS Number String 15 0 0 Integrated Library Management System number FISCAL_YEAR Fiscal Year String 10 0 0 Fiscal Year in which the feature’s project was completed. RMD_DELIVERY RMD Delivery String 15 0 0 Binary value denoting delivery of annual records to the Resource Management Division. PUMPLINE_NUMBER Pumpline Number String 15 0 0 NOTES2 Notes 2 String 255 0 0 GFSORWBS GFS Or WBS String 5 0 0 Government Financial System or Work Business Structure GFSWBSNUMBER GFS-WBS Number String 24 0 0 Government Financial System or Work Business Structure Number. ADDRESS_ID ADDRESS_ID Double 8 0 0 Unique number related to the nearest address to a given feature. Trunk 8 ENABLED 1 EnabledDomain Coded Value Default value Default value HOUSTON SmallInteger QCVERIFIED sYes/No Indicator - Integer Coded Value Default value Duplicate HOUSTON Integer PROJECTTYPE sProject Type Coded Value Default value Duplicate HOUSTON String OWNER sOwner Coded Value Default value Duplicate HOUSTON String DATASOURCETYPE sData Source Type LINE Coded Value Default value Duplicate HOUSTON String CREATIONSOURCE sCreation Source Coded Value Default value Duplicate HOUSTON String DATUM sDatum Coded Value Default value Duplicate HOUSTON String PLANTYPE sPlan Type Coded Value Default value Duplicate HOUSTON String REHABMATERIAL sRehabilitation Material LINE Coded Value Default value Duplicate HOUSTON String REHABMETHOD sRehabilitation Method LINE Coded Value Default value Duplicate HOUSTON String SUBTYPECD 8 MATERIAL PVC sWater Line Material Coded Value Default value Duplicate HOUSTON String LIFECYCLESTATUS E sLifecycle Status Coded Value Default value Duplicate HOUSTON String MEASUREDLENGTH 0 LENGTHSOURCE MS sLength Source Coded Value Default value Duplicate HOUSTON String PIPESHAPE sPipe Shape Coded Value Default value Duplicate HOUSTON String DIAMETER 12 sWaste Water Line Diameter Coded Value Default value Duplicate HOUSTON Integer FISCAL_YEAR sFiscalYear Coded Value Default value Duplicate HOUSTON String PROJECTTYPE2 sProject Type2 Coded Value Default value Duplicate HOUSTON String UNITID2 Unit ID 2 String 20 0 0 IPS specific column that denotes the UNITID value of the endpoint node of a line feature. IPS: Infor Public Sector MAINCOMP1 Main Comp 1 SmallInteger 2 0 0 IPS specific column that denotes the COMPTYPE value of the start-point node of a line feature. IPS: Infor Public Sector MAINCOMP2 Main Comp 2 SmallInteger 2 0 0 IPS specific column that denotes the COMPTYPE value of the end-point node of a line feature. IPS: Infor Public Sector COMPTYPE COMPTYPE SmallInteger 2 0 0 IPS specific column defining a feature type code as it relates to the main IPS database. IPS: Infor Public Sector PARLINENO PARLINENO String 2 0 0 IPS specific column that identifies coincident lines utilizing the same start and end points. IPS: Infor Public Sector UNITID UNITID String 20 0 0 IPS specific column that denotes either the unique UNITID value for a point feature, or the UNITID value of the start-point node of a line feature. IPS: Infor Public Sector IMSWONUM IMS Work Order Number Integer 4 0 0 IMS Work Management System work order related to a specific feature. REHABWBSNUMBER Rehab WBS Number String 16 0 0 REHABDIAMETER Rehab Size Double 8 0 0 SECONDARYLENGTH Secondary Length Double 8 0 0 SECONDARYMATERIAL Secondary Material String 5 0 0 QCDATE QC Date Date 8 0 0 PSCNUMBER PSC Number String 20 0 0 REPLACEMENTYR Replacement Year String 4 0 0 COMMUNITYSEWERINDICATOR Community Sewer Indicator String 5 0 0 MeterBasin Meter Basin String 30 0 0 IPSEXPIREDATE IPS Expire Date Date 8 0 0 IPSEXPIREDBY IPS Expired By String 10 0 0 ADDRKEY ADDRKEY Integer 4 0 0 SHAPE_Length SHAPE_Length Double 8 0 0 Length of feature in internal units. Esri Positive real numbers that are automatically generated. HOUSTON.Anno_48_126 Relationship HOUSTON.sGravityMain_sOperationsRecord Relationship HOUSTON.sGravityMain_sRootControl Relationship 20240126 All existing gravity mains and corresponding attributes are identified in the Plan and Profile Engineering Drawing, and digitized in an ArcFM Solution Software session. A quality assurance process is performed to ensure that all existing wastewater gravity mains with their corresponding attributes shown in the Plan and Profile Engineering Drawings were accurately digitized and recorded in the production database before being forwarded to a supervisor. The ArcFM session is then posted by a supervisor in the production database. The dataset is then replicated from the production environment to relative replicated databases every night before being distributed to other divisions within the City of Houston. 20080718 Kirt Arthur City of Houston, Department of Public Works and Engineering, Houston Water, GIS Services GIS Supervisor physical address
611 Walker St.
Houston TX 77002 USA (832) 395-2868 Kirt.Arthur@houstontx.gov ArcGIS Software Desktop10.2.1, ESRI; ArcFM Solution 10.2, Schneider Electric 1997-present 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. The dataset is maintained by the GIS Services Group of the Public Utilities Division. The attribute information is taken directly from the Plan and Profile Engineering Drawings. All data available (locations and attributes) from Plan and Profile Engineering Drawings within the City Limits of Houston are included in the dataset. Logical consistency is performed using the Utility Network Analysis and the ArcFM Valence Renderer tools that check for network connectivity errors. The general location of the data is based upon the plan and profile paper drawings. The general location of the data is based upon the plan and profile paper drawings. <DIV STYLE="text-align:Left;"><DIV><P><SPAN>None</SPAN></P></DIV></DIV> The geospatial dataset is currently stored and maintained in a Relational Database Management System (RDBMS). Prior to 2009, the dataset was stored and maintained as ArcInfo coverage. The dataset is being continuously updated with new construction, and ongoing maintenance data as they become available. Data are extracted from Plan and Profile Engineering Drawings obtained 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. All existing gravity mains and their corresponding attributes are identified in the Plan and Profile Engineering Drawing, and digitized in an ArcFM Solution Software session. A quality assurance process is performed to ensure that all existing wastewater gravity mains and their corresponding attributes shown in the Plan and Profile Engineering Drawings were accurately digitized and recorded in the production database before being forwarded to a supervisor. The ArcFM session is then posted by a supervisor in the production database. The dataset is then replicated from the production environment to relative replicated databases every night before being distributed to other divisions within the City of Houston. Kirt Arthur City of Houston, Houston Public Works, Houston Water, GIS Services GIS Supervisor Kirt Arthur John Young /9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAP//Z