20210809 23174000 1.0 FALSE TAYLORVILLE_BDS_Main_V6 002 1629577.169337 5560614.290183 13293501.890130 15107989.382537 1 Relationship Relationship Relationship Relationship Relationship Relationship Relationship Relationship P_EmerIsoSys_Pipe Relationship Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_BLM_Zone_15N_ftUS <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/2.4.0'><WKT>PROJCS[&quot;NAD_1983_BLM_Zone_15N_ftUS&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;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,1640416.666666667],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-93.0],PARAMETER[&quot;Scale_Factor&quot;,0.9996],PARAMETER[&quot;Latitude_Of_Origin&quot;,0.0],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,32165]]</WKT><XOrigin>-16800800</XOrigin><YOrigin>-32802000</YOrigin><XYScale>3048.0060960152905</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333299998</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>32165</WKID><LatestWKID>32165</LatestWKID></ProjectedCoordinateSystem> 20210617 09360600 20210617 09360600 Esri ArcGIS 12.4.0.19948 TAYLORVILLE_BDS_Main_V6 1 -93.039644 -78.872440 41.596020 35.877444 File Geodatabase Feature Class dataset EPSG 7.4.5(9.3.0.0) 0 Simple FALSE 0 TRUE FALSE TAYLORVILLE_BDS_Main_V6 Feature Class 0 OBJECTID OBJECTID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. ABANDONEDINDICATOR Abandoned Indicator String 5 0 0 ACTUALINTERNALDIAMETER Actual Internal Diameter Double 8 0 0 ASSETGROUP Asset Group Integer 4 0 0 ASSETSTYLE Asset Style String 25 0 0 ASSETTYPE Asset Type SmallInteger 2 0 0 ASSETUNITCODE Asset Unit Code String 38 0 0 BARCODE Barcode String 16 0 0 CITYNAME City Name String 50 0 0 COATINGAPPLICATIONDATE Coating Application Date Date 8 0 0 COATINGTYPE Coating Type String 30 0 0 COMMENTS Comments String 100 0 0 COMMODITY Commodity String 30 0 0 CONTINFROMM Continuous From Measure Double 8 0 0 CONTINROUTEID Continuous Route ID String 38 0 0 CONTINROUTENAME Continuous Route Name String 100 0 0 CONTINTOM Continuous To Measure Double 8 0 0 CONTRACTNUMBER Contract Number String 10 0 0 COUNTYNAME County Name String 50 0 0 CPSYSTEMNAME CP System Name String 25 0 0 CPTYPE CP Type Code String 25 0 0 CREATIONUSER Creation User String 50 0 0 CRITICALINDICATOR Critical Indicator String 5 0 0 CROSSINGTYPE Crossing Type String 25 0 0 CUNUMLASTSAVED Compatible Units ID String 15 0 0 DATECREATED Date Created Date 8 0 0 DATEMODIFIED Date Modified Date 8 0 0 DATERETIRED Date Retired Date 8 0 0 DATEUPRATED Date Uprated Date 8 0 0 DESIGNCLASS Design Class Integer 4 0 0 DESIGNFACTOR Design Factor Double 8 0 0 DESIGNPRESSUREENTERED Design Pressure - Entered Double 8 0 0 DESIGNPRESSURESTANDARD Design Pressure - Standard Double 8 0 0 DESIGNPRESSUREUNITOFMEASURE Design Pressure - Unit of Measure String 30 0 0 DETAILINDICATOR Detail Indicator String 5 0 0 DIAMETERUNITS Nominal Diameter Units String 20 0 0 DIFFICULTLOCATEINDICATOR Difficult Locate Indicator String 5 0 0 DIVISION Division String 25 0 0 ELECTRICSURVEYINDICATOR Electric Survey Indicator String 5 0 0 EMERISOSYS_GLOBALID EmerIsoSys_GlobalID GUID 38 0 0 ENABLED Enabled SmallInteger 2 0 0 EVENTID EventID String 38 0 0 FACILITYID Facility ID-DO NOT EDIT Integer 4 0 0 FACILITYIDORIG Original Facility ID Integer 4 0 0 FIVEYEARHISTORY Five Year Operating History Pressure Double 8 0 0 FROMDATE From Date Date 8 0 0 FROMREFLOCATION From Reference Location String 50 0 0 FROMREFMETHOD From Reference Method SmallInteger 2 0 0 FROMREFOFFSET From Reference Offset String 50 0 0 GASTRACEWEIGHT Gas Trace Weight Integer 4 0 0 GIRTHWELDTYPE Girth Weld Type String 50 0 0 GISSYSTEMTYPE GIS System Type String 5 0 0 INCOMPLETERECORDS Incomplete Records String 10 0 0 INSERTIONCOMMENT Insertion Comment String 20 0 0 INSERTMATERIAL Insert Material String 50 0 0 INSERTSIZE Insert Size String 25 0 0 INSERVICEDATE In Service Date Date 8 0 0 INSIDEDIAMETER Inside Diameter Double 8 0 0 INSIDEFENCEINDICATOR Inside Fence String 5 0 0 INSPECTIONTYPE Inspection Type String 25 0 0 INSTALLATIONDATE Installation Date Date 8 0 0 INSTALLATIONMETHOD Installation Method String 20 0 0 JOBMODIFYNAME Job Modify Name String 64 0 0 JOBPLACENAME Job Place Name String 64 0 0 JOINTTYPE Joint Type String 10 0 0 LASTUSER Last User String 50 0 0 LASTUSERNAME Last User Name String 100 0 0 LEAKSURVEYNUMBER Leak Survey Number String 25 0 0 LENGTHSOURCE Length Source String 25 0 0 LINENUMBER Line Number String 10 0 0 LOCATIONDESCRIPTION Location Description String 100 0 0 LOCATIONERROR Location Error String 100 0 0 LONGITUDINALSEAMORIENTATION Longitudinal Seam Orientation String 20 0 0 MANUFACTURELOTNUMBER Manufacturer Heat/Lot# String 10 0 0 MANUFACTURER Manufacturer String 50 0 0 MANUFACTURERDATE Manufacturer Date Date 8 0 0 MANUFACTURERMODEL Manufacturer Model String 50 0 0 MAOPDESIGN Design MAOP Double 8 0 0 MAOPFEATURE MAOP Feature Double 8 0 0 MAOPGRANDFATHERED Grandfathered MAOP Double 8 0 0 MAOPRECORD MAOP Record Double 8 0 0 MAOPTEST System MAOP Double 8 0 0 MAOPUNITOFMEASURE MAOP Unit of Measure String 30 0 0 MATERIAL Material Integer 4 0 0 MEASUREDLENGTH Measured Length Double 8 0 0 MXCREATIONSTATE Maximo Creation State Integer 4 0 0 MXSITEID Maximo Site ID String 8 0 0 NOMINALDIAMETER Nominal Diameter String 10 0 0 OPCENTER Operations Center Gas String 50 0 0 OPCENTERCSS Operating Center CSS String 50 0 0 OUTAGEZONE1 Outage Zone 1 Integer 4 0 0 OUTSIDEDIAMETER Outside Diameter Double 8 0 0 OWNER Owner String 20 0 0 PATROLNUMBER Patrol Number String 25 0 0 PERCENTSMYS Percent SMYS Double 8 0 0 PIGGABLE Piggable String 5 0 0 PIGGABLEROUTE Piggable Route String 5 0 0 PIMCOMPONENT PIM Component String 50 0 0 PINCHABLE Pinchable String 5 0 0 PIPEGRADE Pipe Grade String 20 0 0 PIPESPECIFICATION Pipe Specification String 50 0 0 PIPESTRENGTHTESTDATE Pipe Strength Test Date Date 8 0 0 PIPESTRENGTHTESTDURATION Pipe Strength Test Duration String 20 0 0 PIPESTRENGTHTESTMEDIUM Pipe Strength Test Medium String 15 0 0 PIPESTRENGTHTESTPRESSURE Pipe Strength Test Pressure String 20 0 0 PIPETESTDATE Pipe Test Date Date 8 0 0 PIPETESTDURATION Pipe Test Duration String 20 0 0 PIPETESTMEDIUM Pipe Test Medium String 15 0 0 PIPETESTPRESSURE Pipe Test Pressure String 20 0 0 POLYTYPE Polyethylene Type String 25 0 0 PRESSURECLASS Pressure Class String 50 0 0 PRESSUREESTABLISHEDBY Pressure Established By String 50 0 0 PRESSURESYSTEMNAME Pressure System Name String 50 0 0 PROJECTNUMBER Project Number String 50 0 0 PROJECTNUMBERRETIRED Project Number Retired String 50 0 0 SDR Standard Dimension Ratio String 25 0 0 SEAMTYPE Seam Type String 50 0 0 SMYS SMYS Double 8 0 0 SPATIALACCURACY Spatial Accuracy SmallInteger 2 0 0 STATENAME State Name String 3 0 0 STATUS Status String 4 0 0 STOCKNUMBER Old Stock Number String 30 0 0 STYLEDEFAULT1 Style Default 1 String 50 0 0 STYLEDEFAULT2 Style Default 2 String 50 0 0 STYLEDEFAULT3 Style Default 3 String 50 0 0 SUBSIDIARY Subsidiary String 10 0 0 SYSTEMTYPE Pipe System Type String 20 0 0 TESTEDBY Tested By String 30 0 0 TODATE To Date Date 8 0 0 TOREFLOCATION To Reference Location String 50 0 0 TOREFMETHOD To Reference Method SmallInteger 2 0 0 TOREFOFFSET To Reference Offset String 50 0 0 TOWNGASNAME Town Gas Name String 25 0 0 TOWNSHIP Township String 10 0 0 TOWNSHIPQQS Township Quarter Quarter Integer 4 0 0 TRACERWIRE Tracer Wire String 5 0 0 UPRATEDPRESSURE Uprated Pressure Double 8 0 0 UPRATEDWORKORDER Uprated Work Order String 10 0 0 WALLTHICKNESS Wall Thickness Double 8 0 0 WARNINGTAPE Warning Tape String 5 0 0 WORKORDERID Work Order ID String 38 0 0 WORKORDERIDRETIRED Retired Work Order ID String 38 0 0 XRAYPERCENT XRAY Percent Integer 4 0 0 YEARINSTALLED Year Installed String 4 0 0 GLOBALID GLOBALID GlobalID 38 0 0 DEVICENUMBER Device Number Integer 4 0 0 TRACEPRESSURE Trace Pressure SmallInteger 2 0 0 MXASSETNUM Maximo Asset Number-DO NOT EDIT String 12 0 0 SHAPE Shape Geometry 0 0 0 Feature geometry. Esri Coordinates defining the features. Bare Steel 1 ABANDONEDINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String COATINGTYPE Coating Type List of valid options for the type of coating applied to a pipe Coded Value Default value Default value String CPTYPE CP System Protection Type List of valid type of cathodic protection methods Coded Value Default value Default value String CRITICALINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String CROSSINGTYPE Crossing Type Crossing Type Coded Value Default value Default value String DESIGNCLASS Inch DOTClassType List of valid DOT pipeline classifications Coded Value Default value Default value Integer DIAMETERUNITS Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value GASPUB String Inch DIFFICULTLOCATEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String DIVISION Division List of Divisions Coded Value Default value Default value String ELECTRICSURVEYINDICATOR GH Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String GISSYSTEMTYPE Insert Material Insert Material Coded Value Default value Default value GASPUB String GH INSERTMATERIAL Insert Material Insert Material Coded Value Default value Default value String INSERTSIZE Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String INSIDEFENCEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String INSTALLATIONMETHOD Pipe Install Method Installation methods for installing gas pipe Coded Value Default value Default value String LENGTHSOURCE Length Source The method used determine the measurement Coded Value Default value Default value String MANUFACTURER Gas Pipe Manufacturer List of valid manufacturers of pipe Coded Value Default value Default value String MEASUREDLENGTH Measured Length Valid range of values for pipe lengths Range Default value Default value Double NOMINALDIAMETER Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String OUTSIDEDIAMETER Y Pipe Outside Diameter Bare Steel List of NPS Outside Diameter values for Bare Steel pipe Coded Value Default value Default value Double PIGGABLE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String Y PIGGABLEROUTE N Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PINCHABLE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String N PIPESPECIFICATION GasASTMF2897BSteelPipeType List of ASTM F2897 manufacturer specified types of bare steel Coded Value Default value Default value String PIPESTRENGTHTESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String SEAMTYPE INSV Pipe Metallic Seam Type The method used during metallic pipe manufacture to connect the pipe circumference at its seam Coded Value Default value Default value String STATUS Pipe Facility Status Lifecycle state of a gas facility asset. Coded Value Default value Default value String INSV SUBSIDIARY Subsidiary Subsidiary Coded Value Default value Default value String SYSTEMTYPE Pipe System Type List of valid system types in the pipe system Coded Value Default value Default value String TOWNSHIPQQS Township Quarter Quarter List of valid quarter quarter section values Coded Value Default value Default value Integer TRACERWIRE YesNo Indicator with UNK Yes No Indicator with UNK Coded Value Default value Default value String WALLTHICKNESS PipeWallThickness List of values of the wall thickness of a gas pipe Coded Value Default value Default value Double WARNINGTAPE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String WORKFLOWSTATUS 0 MM Work Flow Status MM Work Flow Status Coded Value Default value Default value Integer WORKFUNCTION 0 MM Work Function MM Work Function Coded Value Default value Default value Integer Cast Iron 2 ABANDONEDINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String COATINGTYPE Coating Type List of valid options for the type of coating applied to a pipe Coded Value Default value Default value String CPTYPE CP System Protection Type List of valid type of cathodic protection methods Coded Value Default value Default value String CRITICALINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String CROSSINGTYPE Crossing Type Crossing Type Coded Value Default value Default value String DESIGNCLASS Inch DOTClassType List of valid DOT pipeline classifications Coded Value Default value Default value Integer DIAMETERUNITS Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value GASPUB String Inch DIFFICULTLOCATEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String DIVISION Division List of Divisions Coded Value Default value Default value String ELECTRICSURVEYINDICATOR GH Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String GISSYSTEMTYPE Insert Material Insert Material Coded Value Default value Default value GASPUB String GH INSERTMATERIAL Insert Material Insert Material Coded Value Default value Default value String INSERTSIZE Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String INSIDEFENCEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String INSTALLATIONMETHOD Pipe Install Method Installation methods for installing gas pipe Coded Value Default value Default value String LENGTHSOURCE Length Source The method used determine the measurement Coded Value Default value Default value String MANUFACTURER Gas Pipe Manufacturer List of valid manufacturers of pipe Coded Value Default value Default value String MEASUREDLENGTH Measured Length Valid range of values for pipe lengths Range Default value Default value Double NOMINALDIAMETER Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String PIGGABLE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIGGABLEROUTE N Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PINCHABLE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String N PIPESTRENGTHTESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String SEAMTYPE INSV Pipe Metallic Seam Type The method used during metallic pipe manufacture to connect the pipe circumference at its seam Coded Value Default value Default value String STATUS Pipe Facility Status Lifecycle state of a gas facility asset. Coded Value Default value Default value String INSV SUBSIDIARY Subsidiary Subsidiary Coded Value Default value Default value String SYSTEMTYPE Pipe System Type List of valid system types in the pipe system Coded Value Default value Default value String TOWNSHIPQQS Township Quarter Quarter List of valid quarter quarter section values Coded Value Default value Default value Integer TRACERWIRE YesNo Indicator with UNK Yes No Indicator with UNK Coded Value Default value Default value String WALLTHICKNESS PipeWallThickness List of values of the wall thickness of a gas pipe Coded Value Default value Default value Double WARNINGTAPE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String WORKFLOWSTATUS 0 MM Work Flow Status MM Work Flow Status Coded Value Default value Default value Integer WORKFUNCTION 0 MM Work Function MM Work Function Coded Value Default value Default value Integer Ductile Iron 3 ABANDONEDINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String COATINGTYPE Coating Type List of valid options for the type of coating applied to a pipe Coded Value Default value Default value String CPTYPE CP System Protection Type List of valid type of cathodic protection methods Coded Value Default value Default value String CRITICALINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String CROSSINGTYPE Crossing Type Crossing Type Coded Value Default value Default value String DESIGNCLASS DOTClassType List of valid DOT pipeline classifications Coded Value Default value Default value Integer DIAMETERUNITS Inch UnitsForDiameter List of valid units of measurement of Diameter Coded Value Default value Default value GASPUB String DIFFICULTLOCATEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String DIVISION Division List of Divisions Coded Value Default value Default value String ELECTRICSURVEYINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String GISSYSTEMTYPE GH INSERTMATERIAL Insert Material Insert Material Coded Value Default value Default value String INSERTSIZE Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String INSIDEFENCEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String INSPECTIONTYPE Type of Inspection Type of Inspection Coded Value Default value Default value String INSTALLATIONMETHOD Pipe Install Method Installation methods for installing gas pipe Coded Value Default value Default value String JOINTTYPE Joint Type Joint Type Coded Value Default value Default value String LENGTHSOURCE Length Source The method used determine the measurement Coded Value Default value Default value String MANUFACTURER Gas Pipe Manufacturer List of valid manufacturers of pipe Coded Value Default value Default value String MEASUREDLENGTH Measured Length Valid range of values for pipe lengths Range Default value Default value Double NOMINALDIAMETER Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String OUTSIDEDIAMETER Pipe Outside Diameter Coated Steel List of NPS Outside Diameter values for coated steel pipe Coded Value Default value Default value Double PIGGABLE Y Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIGGABLEROUTE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PINCHABLE N Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIPESPECIFICATION GasASTMF2897CSteelPipeType List of ASTM F2897 manufacturer specified types of coated steel pipe Coded Value Default value Default value String PIPESTRENGTHTESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String PIPETESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String POLYTYPE Polyethylene Type Polyethylene Type Coded Value Default value Default value String PRESSURECLASS Pressure Class Ameren Pressure Classification Coded Value Default value Default value String PRESSUREESTABLISHEDBY Pressure Established By List of methods used to establish a pipe system pressure Coded Value Default value Default value String SDR Standard Dimension Ratio Standard Dimension Ratio Coded Value Default value Default value String SEAMTYPE Pipe Metallic Seam Type The method used during metallic pipe manufacture to connect the pipe circumference at its seam Coded Value Default value Default value String STATENAME State Name State Name Coded Value Default value Default value String STATUS INSV Pipe Facility Status Lifecycle state of a gas facility asset. Coded Value Default value Default value String SUBSIDIARY Subsidiary Subsidiary Coded Value Default value Default value String SYSTEMTYPE Pipe System Type List of valid system types in the pipe system Coded Value Default value Default value String TOWNSHIPQQS Township Quarter Quarter List of valid quarter quarter section values Coded Value Default value Default value Integer TRACERWIRE YesNo Indicator with UNK Yes No Indicator with UNK Coded Value Default value Default value String WALLTHICKNESS PipeWallThickness List of values of the wall thickness of a gas pipe Coded Value Default value Default value Double WARNINGTAPE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String WORKFLOWSTATUS 0 MM Work Flow Status MM Work Flow Status Coded Value Default value Default value Integer WORKFUNCTION 0 MM Work Function MM Work Function Coded Value Default value Default value Integer Polyethylene-Iron Pipe Size 4 ABANDONEDINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String COATINGTYPE Coating Type List of valid options for the type of coating applied to a pipe Coded Value Default value Default value String CPTYPE CP System Protection Type List of valid type of cathodic protection methods Coded Value Default value Default value String CRITICALINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String CROSSINGTYPE Crossing Type Crossing Type Coded Value Default value Default value String DESIGNCLASS DOTClassType List of valid DOT pipeline classifications Coded Value Default value Default value Integer DIAMETERUNITS Inch UnitsForDiameter List of valid units of measurement of Diameter Coded Value Default value Default value GASPUB String DIFFICULTLOCATEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String DIVISION Division List of Divisions Coded Value Default value Default value String ELECTRICSURVEYINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String GISSYSTEMTYPE GH INSERTMATERIAL Insert Material Insert Material Coded Value Default value Default value String INSERTSIZE Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String INSIDEFENCEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String INSPECTIONTYPE Type of Inspection Type of Inspection Coded Value Default value Default value String INSTALLATIONMETHOD Pipe Install Method Installation methods for installing gas pipe Coded Value Default value Default value String JOINTTYPE Joint Type Joint Type Coded Value Default value Default value String LENGTHSOURCE Length Source The method used determine the measurement Coded Value Default value Default value String MANUFACTURER Gas Pipe Manufacturer List of valid manufacturers of pipe Coded Value Default value Default value String MEASUREDLENGTH Measured Length Valid range of values for pipe lengths Range Default value Default value Double NOMINALDIAMETER Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String PIGGABLE N Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIGGABLEROUTE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PINCHABLE N Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIPESTRENGTHTESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String PIPETESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String POLYTYPE Polyethylene Type Polyethylene Type Coded Value Default value Default value String PRESSURECLASS Pressure Class Ameren Pressure Classification Coded Value Default value Default value String PRESSUREESTABLISHEDBY Pressure Established By List of methods used to establish a pipe system pressure Coded Value Default value Default value String SDR Standard Dimension Ratio Standard Dimension Ratio Coded Value Default value Default value String SEAMTYPE Pipe Non-Steel Seam Type The method used during Non-Steel pipe manufacture to connect the pipe circumference at its seam Coded Value Default value Default value String STATENAME State Name State Name Coded Value Default value Default value String STATUS INSV Pipe Facility Status Lifecycle state of a gas facility asset. Coded Value Default value Default value String SUBSIDIARY Subsidiary Subsidiary Coded Value Default value Default value String SYSTEMTYPE Pipe System Type List of valid system types in the pipe system Coded Value Default value Default value String TOWNSHIPQQS Township Quarter Quarter List of valid quarter quarter section values Coded Value Default value Default value Integer TRACERWIRE YesNo Indicator with UNK Yes No Indicator with UNK Coded Value Default value Default value String WALLTHICKNESS PipeWallThickness List of values of the wall thickness of a gas pipe Coded Value Default value Default value Double WARNINGTAPE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String WORKFLOWSTATUS 0 MM Work Flow Status MM Work Flow Status Coded Value Default value Default value Integer WORKFUNCTION 0 MM Work Function MM Work Function Coded Value Default value Default value Integer Plastic PE 5 ABANDONEDINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String COATINGTYPE Coating Type List of valid options for the type of coating applied to a pipe Coded Value Default value Default value String CPTYPE CP System Protection Type List of valid type of cathodic protection methods Coded Value Default value Default value String CRITICALINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String CROSSINGTYPE Crossing Type Crossing Type Coded Value Default value Default value String DESIGNCLASS Inch DOTClassType List of valid DOT pipeline classifications Coded Value Default value Default value Integer DIAMETERUNITS Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value GASPUB String Inch DIFFICULTLOCATEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String DIVISION Division List of Divisions Coded Value Default value Default value String ELECTRICSURVEYINDICATOR GH Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String GISSYSTEMTYPE Insert Material Insert Material Coded Value Default value Default value GASPUB String GH INSERTMATERIAL Insert Material Insert Material Coded Value Default value Default value String INSERTSIZE Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String INSIDEFENCEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String INSTALLATIONMETHOD Pipe Install Method Installation methods for installing gas pipe Coded Value Default value Default value String LENGTHSOURCE Length Source The method used determine the measurement Coded Value Default value Default value String MANUFACTURER Gas Pipe Manufacturer List of valid manufacturers of pipe Coded Value Default value Default value String MEASUREDLENGTH Measured Length Valid range of values for pipe lengths Range Default value Default value Double NOMINALDIAMETER N Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String PIGGABLE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String N PIGGABLEROUTE Y Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PINCHABLE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String Y PIPESPECIFICATION GasASTMF2897PlasticPipeType List of ASTM F2897 manufacturer specified types of plastic pipe Coded Value Default value Default value String PIPESTRENGTHTESTMEDIUM Seamless PipeTestMedium PipeTestMedium Coded Value Default value Default value String SEAMTYPE Seamless Pipe Facility Status Lifecycle state of a gas facility asset. Coded Value Default value Default value GASPUB String STATUS Pipe Facility Status Lifecycle state of a gas facility asset. Coded Value Default value Default value String INSV SUBSIDIARY Subsidiary Subsidiary Coded Value Default value Default value String SYSTEMTYPE Pipe System Type List of valid system types in the pipe system Coded Value Default value Default value String TOWNSHIPQQS Y Township Quarter Quarter List of valid quarter quarter section values Coded Value Default value Default value Integer TRACERWIRE YesNo Indicator with UNK Yes No Indicator with UNK Coded Value Default value Default value String Y WALLTHICKNESS PipeWallThickness List of values of the wall thickness of a gas pipe Coded Value Default value Default value Double WARNINGTAPE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String WORKFLOWSTATUS 0 MM Work Flow Status MM Work Flow Status Coded Value Default value Default value Integer WORKFUNCTION 0 MM Work Function MM Work Function Coded Value Default value Default value Integer Plastic PVC 6 ABANDONEDINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String COATINGTYPE Coating Type List of valid options for the type of coating applied to a pipe Coded Value Default value Default value String CPTYPE CP System Protection Type List of valid type of cathodic protection methods Coded Value Default value Default value String CRITICALINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String CROSSINGTYPE Crossing Type Crossing Type Coded Value Default value Default value String DESIGNCLASS DOTClassType List of valid DOT pipeline classifications Coded Value Default value Default value Integer DIAMETERUNITS Inch UnitsForDiameter List of valid units of measurement of Diameter Coded Value Default value Default value GASPUB String DIFFICULTLOCATEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String DIVISION Division List of Divisions Coded Value Default value Default value String ELECTRICSURVEYINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String GISSYSTEMTYPE GH INSERTMATERIAL Insert Material Insert Material Coded Value Default value Default value String INSERTSIZE Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String INSIDEFENCEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String INSPECTIONTYPE Type of Inspection Type of Inspection Coded Value Default value Default value String INSTALLATIONMETHOD Pipe Install Method Installation methods for installing gas pipe Coded Value Default value Default value String JOINTTYPE Joint Type Joint Type Coded Value Default value Default value String LENGTHSOURCE Length Source The method used determine the measurement Coded Value Default value Default value String MANUFACTURER Gas Pipe Manufacturer List of valid manufacturers of pipe Coded Value Default value Default value String MEASUREDLENGTH Measured Length Valid range of values for pipe lengths Range Default value Default value Double NOMINALDIAMETER Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String PIGGABLE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIGGABLEROUTE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PINCHABLE N Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIPESTRENGTHTESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String PIPETESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String POLYTYPE Polyethylene Type Polyethylene Type Coded Value Default value Default value String PRESSURECLASS Pressure Class Ameren Pressure Classification Coded Value Default value Default value String PRESSUREESTABLISHEDBY Pressure Established By List of methods used to establish a pipe system pressure Coded Value Default value Default value String SDR Standard Dimension Ratio Standard Dimension Ratio Coded Value Default value Default value String SEAMTYPE Pipe Non-Steel Seam Type The method used during Non-Steel pipe manufacture to connect the pipe circumference at its seam Coded Value Default value Default value String STATENAME State Name State Name Coded Value Default value Default value String STATUS INSV Pipe Facility Status Lifecycle state of a gas facility asset. Coded Value Default value Default value String SUBSIDIARY Subsidiary Subsidiary Coded Value Default value Default value String SYSTEMTYPE Pipe System Type List of valid system types in the pipe system Coded Value Default value Default value String TOWNSHIPQQS Township Quarter Quarter List of valid quarter quarter section values Coded Value Default value Default value Integer TRACERWIRE Y YesNo Indicator with UNK Yes No Indicator with UNK Coded Value Default value Default value String WALLTHICKNESS PipeWallThickness List of values of the wall thickness of a gas pipe Coded Value Default value Default value Double WARNINGTAPE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String WORKFLOWSTATUS 0 MM Work Flow Status MM Work Flow Status Coded Value Default value Default value Integer WORKFUNCTION 0 MM Work Function MM Work Function Coded Value Default value Default value Integer Coated Steel 7 ABANDONEDINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String COATINGTYPE Coating Type List of valid options for the type of coating applied to a pipe Coded Value Default value Default value String CPTYPE CP System Protection Type List of valid type of cathodic protection methods Coded Value Default value Default value String CRITICALINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String CROSSINGTYPE Crossing Type Crossing Type Coded Value Default value Default value String DESIGNCLASS DOTClassType List of valid DOT pipeline classifications Coded Value Default value Default value Integer DIAMETERUNITS Inch UnitsForDiameter List of valid units of measurement of Diameter Coded Value Default value Default value GASPUB String DIFFICULTLOCATEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String DIVISION Division List of Divisions Coded Value Default value Default value String ELECTRICSURVEYINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String GISSYSTEMTYPE GH INSERTMATERIAL Insert Material Insert Material Coded Value Default value Default value String INSERTSIZE Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String INSIDEFENCEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String INSPECTIONTYPE Type of Inspection Type of Inspection Coded Value Default value Default value String INSTALLATIONMETHOD Pipe Install Method Installation methods for installing gas pipe Coded Value Default value Default value String JOINTTYPE Joint Type Joint Type Coded Value Default value Default value String LENGTHSOURCE Length Source The method used determine the measurement Coded Value Default value Default value String MANUFACTURER Gas Pipe Manufacturer List of valid manufacturers of pipe Coded Value Default value Default value String MEASUREDLENGTH Measured Length Valid range of values for pipe lengths Range Default value Default value Double NOMINALDIAMETER Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String PIGGABLE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIGGABLEROUTE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIPESPECIFICATION GasASTMF2897CSteelPipeType List of ASTM F2897 manufacturer specified types of coated steel pipe Coded Value Default value Default value String PIPESTRENGTHTESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String PIPETESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String POLYTYPE Polyethylene Type Polyethylene Type Coded Value Default value Default value String PRESSURECLASS Pressure Class Ameren Pressure Classification Coded Value Default value Default value String PRESSUREESTABLISHEDBY Pressure Established By List of methods used to establish a pipe system pressure Coded Value Default value Default value String SDR Standard Dimension Ratio Standard Dimension Ratio Coded Value Default value Default value String SEAMTYPE Pipe Metallic Seam Type The method used during metallic pipe manufacture to connect the pipe circumference at its seam Coded Value Default value Default value String STATENAME INSV State Name State Name Coded Value Default value Default value String STATUS Pipe Facility Status Lifecycle state of a gas facility asset. Coded Value Default value Default value String INSV SUBSIDIARY Subsidiary Subsidiary Coded Value Default value Default value String SYSTEMTYPE Pipe System Type List of valid system types in the pipe system Coded Value Default value Default value String TOWNSHIPQQS Township Quarter Quarter List of valid quarter quarter section values Coded Value Default value Default value Integer TRACERWIRE YesNo Indicator with UNK Yes No Indicator with UNK Coded Value Default value Default value String WALLTHICKNESS PipeWallThickness List of values of the wall thickness of a gas pipe Coded Value Default value Default value Double WARNINGTAPE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String WORKFLOWSTATUS 0 MM Work Flow Status MM Work Flow Status Coded Value Default value Default value Integer WORKFUNCTION 0 MM Work Function MM Work Function Coded Value Default value Default value Integer Unknown 8 ABANDONEDINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String COATINGTYPE Coating Type List of valid options for the type of coating applied to a pipe Coded Value Default value Default value String CPTYPE CP System Protection Type List of valid type of cathodic protection methods Coded Value Default value Default value String CRITICALINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String CROSSINGTYPE Crossing Type Crossing Type Coded Value Default value Default value String DESIGNCLASS DOTClassType List of valid DOT pipeline classifications Coded Value Default value Default value Integer DIAMETERUNITS Inch UnitsForDiameter List of valid units of measurement of Diameter Coded Value Default value Default value GASPUB String DIFFICULTLOCATEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String DIVISION Division List of Divisions Coded Value Default value Default value String ELECTRICSURVEYINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String GISSYSTEMTYPE GH INSERTMATERIAL Insert Material Insert Material Coded Value Default value Default value String INSERTSIZE Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String INSIDEFENCEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String INSPECTIONTYPE Type of Inspection Type of Inspection Coded Value Default value Default value String INSTALLATIONMETHOD Pipe Install Method Installation methods for installing gas pipe Coded Value Default value Default value String JOINTTYPE Joint Type Joint Type Coded Value Default value Default value String LENGTHSOURCE Length Source The method used determine the measurement Coded Value Default value Default value String MANUFACTURER Gas Pipe Manufacturer List of valid manufacturers of pipe Coded Value Default value Default value String MEASUREDLENGTH Measured Length Valid range of values for pipe lengths Range Default value Default value Double NOMINALDIAMETER Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String PIGGABLE N Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIGGABLEROUTE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PINCHABLE N Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIPESPECIFICATION GasASTMF2897PlasticPipeType List of ASTM F2897 manufacturer specified types of plastic pipe Coded Value Default value Default value String PIPESTRENGTHTESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String PIPETESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String POLYTYPE Polyethylene Type Polyethylene Type Coded Value Default value Default value String PRESSURECLASS Pressure Class Ameren Pressure Classification Coded Value Default value Default value String PRESSUREESTABLISHEDBY Pressure Established By List of methods used to establish a pipe system pressure Coded Value Default value Default value String SDR Standard Dimension Ratio Standard Dimension Ratio Coded Value Default value Default value String SEAMTYPE Pipe Metallic Seam Type The method used during metallic pipe manufacture to connect the pipe circumference at its seam Coded Value Default value Default value String STATENAME State Name State Name Coded Value Default value Default value String STATUS INSV Pipe Facility Status Lifecycle state of a gas facility asset. Coded Value Default value Default value String SUBSIDIARY Subsidiary Subsidiary Coded Value Default value Default value String SYSTEMTYPE Pipe System Type List of valid system types in the pipe system Coded Value Default value Default value String TOWNSHIPQQS Township Quarter Quarter List of valid quarter quarter section values Coded Value Default value Default value Integer TRACERWIRE YesNo Indicator with UNK Yes No Indicator with UNK Coded Value Default value Default value String WALLTHICKNESS PipeWallThickness List of values of the wall thickness of a gas pipe Coded Value Default value Default value Double WARNINGTAPE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String WORKFLOWSTATUS 0 MM Work Flow Status MM Work Flow Status Coded Value Default value Default value Integer WORKFUNCTION 0 MM Work Function MM Work Function Coded Value Default value Default value Integer WORKREQUESTID Work Request ID String 20 0 0 DESIGNID Design ID String 20 0 0 WORKLOCATIONID Work Location ID String 20 0 0 WORKFLOWSTATUS Work Flow Status Integer 4 0 0 WORKFUNCTION Work Function Integer 4 0 0 GISDNUMBER GIS Discrepancy String 12 0 0 Wrought Iron 9 ABANDONEDINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String COATINGTYPE Coating Type List of valid options for the type of coating applied to a pipe Coded Value Default value Default value String CPTYPE CP System Protection Type List of valid type of cathodic protection methods Coded Value Default value Default value String CRITICALINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String CROSSINGTYPE Crossing Type Crossing Type Coded Value Default value Default value String DESIGNCLASS DOTClassType List of valid DOT pipeline classifications Coded Value Default value Default value Integer DIAMETERUNITS Inch UnitsForDiameter List of valid units of measurement of Diameter Coded Value Default value Default value GASPUB String DIFFICULTLOCATEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String DIVISION Division List of Divisions Coded Value Default value Default value String ELECTRICSURVEYINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String GISSYSTEMTYPE GH INSERTMATERIAL Insert Material Insert Material Coded Value Default value Default value String INSERTSIZE Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String INSIDEFENCEINDICATOR Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String INSPECTIONTYPE Type of Inspection Type of Inspection Coded Value Default value Default value String INSTALLATIONMETHOD Pipe Install Method Installation methods for installing gas pipe Coded Value Default value Default value String JOINTTYPE Joint Type Joint Type Coded Value Default value Default value String LENGTHSOURCE Length Source The method used determine the measurement Coded Value Default value Default value String MANUFACTURER Gas Pipe Manufacturer List of valid manufacturers of pipe Coded Value Default value Default value String MEASUREDLENGTH Measured Length Valid range of values for pipe lengths Range Default value Default value Double NOMINALDIAMETER Diameter Nominal List of Nominal Pipe Diameters Coded Value Default value Default value String PIGGABLE N Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIGGABLEROUTE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PINCHABLE N Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String PIPESPECIFICATION GasASTMF2897PlasticPipeType List of ASTM F2897 manufacturer specified types of plastic pipe Coded Value Default value Default value String PIPESTRENGTHTESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String PIPETESTMEDIUM PipeTestMedium PipeTestMedium Coded Value Default value Default value String POLYTYPE Polyethylene Type Polyethylene Type Coded Value Default value Default value String PRESSURECLASS Pressure Class Ameren Pressure Classification Coded Value Default value Default value String PRESSUREESTABLISHEDBY Pressure Established By List of methods used to establish a pipe system pressure Coded Value Default value Default value String SDR Standard Dimension Ratio Standard Dimension Ratio Coded Value Default value Default value String SEAMTYPE Pipe Metallic Seam Type The method used during metallic pipe manufacture to connect the pipe circumference at its seam Coded Value Default value Default value String STATENAME State Name State Name Coded Value Default value Default value String STATUS INSV Pipe Facility Status Lifecycle state of a gas facility asset. Coded Value Default value Default value String SUBSIDIARY Subsidiary Subsidiary Coded Value Default value Default value String SYSTEMTYPE Pipe System Type List of valid system types in the pipe system Coded Value Default value Default value String TOWNSHIPQQS Township Quarter Quarter List of valid quarter quarter section values Coded Value Default value Default value Integer TRACERWIRE YesNo Indicator with UNK Yes No Indicator with UNK Coded Value Default value Default value String WALLTHICKNESS PipeWallThickness List of values of the wall thickness of a gas pipe Coded Value Default value Default value Double WARNINGTAPE Yes No Indicator Boolean list with single letter representation of yes and no Coded Value Default value Default value String WORKFLOWSTATUS 0 MM Work Flow Status MM Work Flow Status Coded Value Default value Default value Integer WORKFUNCTION 0 MM Work Function MM Work Function Coded Value Default value Default value Integer CHANGEDATABASE Change Database Flag String 5 0 0 CLASSMAX Class Max Integer 4 0 0 BUSINESSDISTRICT BUSINESSDISTRICT String 255 0 0 LEAKSURVEYNUMBER_1 Leak Survey Number String 25 0 0 Shape_Length Shape_Length Double 8 0 0 Length of feature in internal units. Esri Positive real numbers that are automatically generated. 20210617