Introduction
The data dictionary includes a description of the elements in the Gas Utility Network Configuration.
It will help you understand what elements are used to create the utility network and provide a description of what they are.
PipelineAssembly
Fields
| Name | Alias | Type | Default Value | Domain | Nullable |
|---|---|---|---|---|---|
| regulatorytype | Regulatory Type | SmallInteger | 0 | Pipeline Regulatory Type | True |
| vault | Vault | SmallInteger | 0 | Yes No | True |
| installationdate | Install Date | Date | True | ||
| inservicedate | Inservice Date | Date | True | ||
| assetid | Asset ID | String(64) | True | ||
| name | Assembly Name | String(64) | True | ||
| ownedby | Owned By | SmallInteger | 1 | Asset Owner | True |
| maintby | Maintained By | SmallInteger | 1 | Asset Manager | True |
| locationdescription | Location Description | String(255) | True | ||
| lifecyclestatus | Life Cycle Status | SmallInteger | 3 | Pipeline Life Cycle Status | False |
| pipelineoperatornumber | Pipeline Operator Number | SmallInteger | 0 | Pipeline Pipeline Operator Number | True |
| supplier | Supplier | SmallInteger | 0 | Pipeline Supplier | True |
| pressurerating | Pressure Rating | Double | True | ||
| mopin | MOP In | Double | True | ||
| mopout | MOP Out | Double | True | ||
| sopin | SOP In | Double | True | ||
| sopout | SOP Out | Double | True | ||
| rotation | Rotation | SmallInteger | 0 | Symbol Rotation | True |
| cpsubnetworkname | cpsubnetworkname | String(2000) | Unknown | False | |
| prottype | Over Pressure Protection Type | SmallInteger | True |
Asset Groups
Compressor Station: 1
The Compressor Station asset group in the PipelineAssembly feature class represents facilities in the natural gas transmission pipeline portion of the pipe system responsible for increasing pressure in the downstream pipeline.
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of compressor station |
| Compressor Station | 1 | Generic compressor station |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| MOP In | mopin | ||
| MOP Out | mopout | ||
| Station Name | name | ||
| Owned By | ownedby | 1 | Asset Owner |
| Pipeline Operator Number | pipelineoperatornumber | 0 | Pipeline Pipeline Operator Number |
| Total Power | pressurerating | ||
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| SOP In | sopin | ||
| SOP Out | sopout | ||
| Supplier | supplier | 0 | Pipeline Supplier |
| Vault | vault | 0 | Yes No |
Fitting Assembly: 8
The Fitting Assembly asset group in the PipelineAssembly feature class represents facilities within a pipeline that contain many fittings or devices within a small geographic area
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of fitting assembly |
| Service Tap | 281 | Location where a service pipe meets a main line |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Station Name | name | ||
| Owned By | ownedby | 1 | Asset Owner |
| Pipeline Operator Number | pipelineoperatornumber | 0 | Pipeline Pipeline Operator Number |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Supplier | supplier | 0 | Pipeline Supplier |
Meter Setting: 2
The Meter Setting asset group in the PipelineAssembly feature class represents facilities in the pipe system that contain meters, regulators, and risers to monitor and record volume and flow
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of meter setting |
| Meter Set | 41 | Generic meter setting |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Premise | name | ||
| Owned By | ownedby | 1 | Asset Owner |
| Pipeline Operator Number | pipelineoperatornumber | 0 | Pipeline Pipeline Operator Number |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Supplier | supplier | 0 | Pipeline Supplier |
| Bypass Indicator | vault | 0 | Yes No |
Pigging Structure: 7
The Pigging Structure asset group in the PipelineAssembly feature class represents facilities that allow for insertion or extraction of pigs from gas or fluid systems
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of pigging structure |
| Launcher | 241 | Facility allowing insertion of a pig |
| Receiver | 242 | Facility allowing extraction of a pig |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Owned By | ownedby | 1 | Asset Owner |
| Pipeline Operator Number | pipelineoperatornumber | 0 | Pipeline Pipeline Operator Number |
| Structure Length | pressurerating | ||
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Supplier | supplier | 0 | Pipeline Supplier |
Pump Station: 9
The Pump Station asset group in the PipelineAssembly feature class represents facilities within a pipeline line that pressurize fluid in the pipe system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of pump station |
| Pump Station | 321 | Generic pump station |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Station Name | name | ||
| Owned By | ownedby | 1 | Asset Owner |
| Pipeline Operator Number | pipelineoperatornumber | 0 | Pipeline Pipeline Operator Number |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Supplier | supplier | 0 | Pipeline Supplier |
| Vault | vault | 0 | Yes No |
Regulator Station: 3
The Regulator Station asset group in the PipelineAssembly feature class represents facilities within a pipeline containing regulators, valves, and piping to change the pressure of fluid or gas in the pipe system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of regulator station |
| Regulator Station | 81 | A generic regulator station |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| MOP In | mopin | ||
| MOP Out | mopout | ||
| Station Name | name | ||
| Owned By | ownedby | 1 | Asset Owner |
| Pipeline Operator Number | pipelineoperatornumber | 0 | Pipeline Pipeline Operator Number |
| Design Capacity | pressurerating | ||
| Over Pressure Protection Type | prottype | 0 | Pipeline Over Pressure Protection Type |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| SOP In | sopin | ||
| SOP Out | sopout | ||
| Supplier | supplier | 0 | Pipeline Supplier |
| Vault | vault | 0 | Yes No |
Rural Tap: 4
The Rural Tap asset group in the PipelineAssembly feature class represents facilities on transmission pipelines used to serve gas to rural residential and industrial customers.
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of rural tap |
| Rural Tap | 121 | Generic rural tap |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| MOP In | mopin | ||
| MOP Out | mopout | ||
| Tap Name | name | ||
| Owned By | ownedby | 1 | Asset Owner |
| Pipeline Operator Number | pipelineoperatornumber | 0 | Pipeline Pipeline Operator Number |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| SOP In | sopin | ||
| SOP Out | sopout | ||
| Supplier | supplier | 0 | Pipeline Supplier |
| Vault | vault | 0 | Yes No |
Town Border Station: 5
The Town Border Station asset group in the PipelineAssembly feature class represents regulator station facilities within a pipeline that are also the point of transfer between the transmission system and the distribution system.
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of town border station |
| Town Border Station | 161 | Generic town border station |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| MOP In | mopin | ||
| MOP Out | mopout | ||
| Station Name | name | ||
| Owned By | ownedby | 1 | Asset Owner |
| Pipeline Operator Number | pipelineoperatornumber | 0 | Pipeline Pipeline Operator Number |
| Over Pressure Protection Type | prottype | 0 | Pipeline Over Pressure Protection Type |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| SOP In | sopin | ||
| SOP Out | sopout | ||
| Supplier | supplier | 0 | Pipeline Supplier |
| Vault | vault | 0 | Yes No |
Unknown: 0
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | ||
| Location Description | locationdescription | ||
| Maintained By | maintby | ||
| MOP In | mopin | ||
| MOP Out | mopout | ||
| Assembly Name | name | ||
| Owned By | ownedby | ||
| Pipeline Operator Number | pipelineoperatornumber | ||
| Pressure Rating | pressurerating | ||
| Over Pressure Protection Type | prottype | ||
| Regulatory Type | regulatorytype | ||
| Rotation | rotation | ||
| SOP In | sopin | ||
| SOP Out | sopout | ||
| Supplier | supplier | ||
| Vault | vault |
Wellhead: 6
The Wellhead asset group in the PipelineAssembly feature class represents the location where a well connects to the pipe system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of wellhead |
| Mudline | 201 | Wellhead designed for deep water using mudline suspension equipment |
| Subsea | 202 | Wellhead located on the ocean floor |
| Surface | 203 | Wellhead located on land |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Well Name | name | ||
| Owned By | ownedby | 1 | Asset Owner |
| Pipeline Operator Number | pipelineoperatornumber | 0 | Pipeline Pipeline Operator Number |
| Pressure Rating | pressurerating | 0.0 | Pipeline Pipe Wellhead Pressure Rating |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Supplier | supplier | 0 | Pipeline Supplier |
PipelineDevice
Fields
| Name | Alias | Type | Default Value | Domain | Nullable |
|---|---|---|---|---|---|
| adddetails | Additional Details | SmallInteger | True | ||
| devicestatus | Device Status | SmallInteger | 1 | Pipeline Device Status | False |
| regulatorytype | Regulatory Type | SmallInteger | 0 | Pipeline Regulatory Type | True |
| designtype | Design Type | SmallInteger | True | ||
| insulatordevice | Insulator Device | SmallInteger | 0 | Yes No | False |
| accessible | Accessible | SmallInteger | 1 | Yes No | True |
| yesno | Generic Yes/No | SmallInteger | True | ||
| turnstoclose | Turns to Close | Double | True | ||
| normalposition | Normal Position | SmallInteger | True | ||
| installationdate | Install Date | Date | True | ||
| inservicedate | Inservice Date | Date | True | ||
| assetid | Asset ID | String(64) | True | ||
| serialnumber | Serial Number | String(20) | True | ||
| ownedby | Owned By | SmallInteger | 1 | Asset Owner | True |
| maintby | Maintained By | SmallInteger | 1 | Asset Manager | True |
| locationdescription | Location Description | String(100) | True | ||
| lifecyclestatus | Life Cycle Status | SmallInteger | 3 | Pipeline Life Cycle Status | False |
| maopdesign | MAOP Design | Double | 0.0 | Pipeline Pressure Range | False |
| maoptest | MAOP Test | Double | 0.0 | Pipeline Pressure Range | True |
| maoprecord | MAOP Record | Double | 0.0 | Pipeline Pressure Range | False |
| depth | Depth | Double | True | ||
| depthtonut | Depth to Nut | Double | True | ||
| length | Length | Double | True | ||
| diameter | Diameter | Double | True | ||
| maxinletpressure | Max Inlet Pressure | Double | True | ||
| maxoutletpressure | Max Outlet Pressure | Double | True | ||
| setpressureentered | Set Pressure Entered | Double | True | ||
| setpressurestandard | Set Pressure Standard | Double | True | ||
| rotation | Rotation | SmallInteger | 0 | Symbol Rotation | True |
| barcode | Barcode | String(16) | True | ||
| manufacturer | Manufacturer | String(2) | True | ||
| manufacturerlotno | Manufacturer Lot # | Integer | True | ||
| manufacturedate | Manufacture Date | Date | True | ||
| manufacturecomponent | Manufacture Component | String(2) | True | ||
| material | Material | String(2) | True | ||
| cpsubnetworkname | cpsubnetworkname | String(2000) | Unknown | False |
Asset Groups
Anode: 15
The Anode asset group in the PipelineDevice feature class represents sacrificial corrosive components that protect the metal of the pipe system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of anode |
| Carbon-Graphite | 281 | Carbon-graphite material anode |
| Cast Iron | 282 | Cast iron material anode |
| Galvanic | 283 | Galvanic material anode |
| Graphite | 284 | Graphite material anode |
| Magnesium | 285 | Magnesium material anode |
| Magnesium (High Grade B) | 286 | High grade B magnesium material anode |
| Magnesium (High Potential) | 287 | High potential magnesium material anode |
| Mixed Metal Oxide | 288 | Mixed metal oxide material anode |
| Scrap Steel | 289 | Scrap steel material anode |
| Zinc | 290 | Zinc material anode |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Weight | depth | 0.0 | CP Anode Weight |
| Quantity | depthtonut | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | CP ASTM Anode Manufacture Component | |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| Material | material | ||
| Owned By | ownedby | 1 | Asset Owner |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber |
Compressor: 10
The Compressor asset group in the PipelineDevice feature class represents devices that mechanically increase gas pressure in the pipe system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of compressor |
| Electric Motor | 161 | Compressor using electric power |
| Reciprocating Engine | 162 | Compressor using an internal combustion engine |
| Turbine | 163 | Compressor using a series of rotating blades |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Device Status | devicestatus | 1 | Pipeline Device Status |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | ||
| Max Inlet Pressure | maxinletpressure | ||
| Max Outlet Pressure | maxoutletpressure | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Set Pressure Entered | setpressureentered | ||
| Set Pressure Standard | setpressurestandard |
Controllable Tee: 12
The Controllable Tee asset group in the PipelineDevice feature class represents fittings that mechanically control the flow of fluid or gas through the pipe system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown Controllable Tee |
| Controllable Tee | 241 | Generic Controllable Tee |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Device Status | devicestatus | 1 | Pipeline Device Status |
| Diameter | diameter | 0.0 | Pipeline Valve Diameter |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Normal Position | normalposition | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber |
Controllable Valve: 3
The Controllable Valve asset group in the PipelineDevice feature class represents components that permit or prevent flow through the pipe system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of controllable valve |
| Bypass | 482 | Valve with a purpose of allowing or preventing flow of a commodity around a facilities primary devices |
| System | 485 | Valve with a purpose of allowing or preventing flow of a commodity around a facilities primary devices |
| Emergency | 483 | Valve capable of impeding the flow of a commodity through the pipe system |
| Meter | 486 | Valve located within a meter set |
Fields
Excess Flow Valve: 1
The Excess Flow Valve asset group in the PipelineJunction feature class represents devices that prevent pressure surges from propagating further down the pipe system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of excess flow valve |
| Automatic Reset | 1 | Excess flow valve with an automatic reset |
| Manual Reset | 2 | Excess flow valve with a manual reset |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline EFV Diameter |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | Pipeline ASTM EFV Manufacture Component | |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Flow Valve: 4
The Flow Valve asset group in the PipelineDevice feature class represents components restricting the flow of a commodity to a single direction
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of flow valve |
| Check | 261 | Valve with a spring hinged flap that automatically closes if commodity attempts to flow in a reverse direction |
| Slam-shut | 262 | Valve that totally and rapidly cuts flow of commodity if the inlet or outlet pressure exceeds or drops below setpoints |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Accessible | accessible | 1 | Yes No |
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Valve Diameter |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | 0 | Pipeline ASTM Valve Manufacture Component |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | 0 | Pipeline ASTM Manufacturer |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber |
Lamp: 9
The Lamp asset group in the PipelineDevice feature class represents natural gas fueled street lamps
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of lamp |
| Lamp | 121 | Generic type of lamp |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Metered | adddetails | ||
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Height | depth | ||
| Usage | designtype | ||
| Device Status | devicestatus | 1 | Pipeline Device Status |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer Lot # | manufacturerlotno | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber | ||
| Drain Valve Indicator | yesno | 0 | Yes No |
Meter: 2
The Meter asset group in the PipelineDevice feature class represents devices measuring the volume of commodity flowing through the meter
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of meter |
| Custody Transfer | 41 | Meter measuring volume of received from another pipe organization |
| Customer | 42 | Meter measuring volume of commodity consumed by an individual customer |
| Utility | 43 | Meter measuring volume of gas or oil at a facility |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Meter Type | designtype | Pipeline Meter Type | |
| Device Status | devicestatus | 1 | Pipeline Device Status |
| Diameter | diameter | 0.0 | Pipeline Meter Diameter - Customer |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | Pipeline ASTM Meter Manufacture Component | |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber |
Pressure Monitoring Device: 8
The Pressure Monitoring Device asset group in the PipelineDevice feature class represents components in a pipe system that measure and record flow
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of pressure monitoring device |
| Pressure Monitoring Device | 81 | Generic pressure monitoring device |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Temperature Rating | adddetails | ||
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Duration | depth | ||
| Usage Type | designtype | ||
| Diaphragm Diameter | diameter | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Permanent Indicator | normalposition | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber | ||
| SCADA Indicator | yesno | 0 | Yes No |
Pump: 18
The Pump asset group in the PipelineDevice feature class represents devices that mechanically increase pressure on hazardous liquid to move it through the pipe system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of pump |
| Booster | 401 | Pump providing additional pressure to the flow of hazardous liquid |
| Primary | 402 | Pump providing majority of pressure to the flow of hazardous liquid |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Device Status | devicestatus | 1 | Pipeline Device Status |
| Diameter | diameter | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer Lot # | manufacturerlotno | ||
| Max Inlet Pressure | maxinletpressure | ||
| Max Outlet Pressure | maxoutletpressure | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber | ||
| Set Pressure Entered | setpressureentered | ||
| Set Pressure Standard | setpressurestandard |
Rectifier: 16
The Rectifier asset group in the PipelineDevice feature class represents devices that generate current for the cathodic protection system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of rectifier |
| CP Rectifier-Ground | 321 | Ground for a rectifier |
| Other | 322 | Rectifier which does not fit in the other defined types |
| Rectifier | 323 | A generic rectifier |
| Rectifier Bond | 324 | Bond connecting a rectifier to the cathodic protection network |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Cooling Method | adddetails | 0 | Pipeline Cooling Method |
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Amperage | depth | ||
| Voltage | designtype | ||
| Device Status | devicestatus | 1 | Pipeline Device Status |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer Lot # | manufacturerlotno | ||
| Manufacturer | normalposition | 0 | CP Rectifier Manufacturer |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber | ||
| Internal Meter | yesno | 0 | Yes No |
Regulator: 19
The Regulator asset group in the PipelineDevice feature class represents mechanical devices that control reduction of pressure
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of regulator |
| Regulator | 521 | Generic regulator |
Fields
Relief Valve: 5
The Relief Valve asset group in the PipelineDevice feature class represents devices in a pipe system responsible for automatically opening when pressure rises above a set point
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of relief valve |
| Blow Off | 21 | Relief valve that opens to release pressure when a set point is exceeded |
Fields
Scrubber: 20
The Scrubber asset group in the PipelineDevice feature class represents components within a pipe system that remove free liquids or dirt particles from the commodity fluid or gas
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of scrubber |
| Scrubber | 561 | Generic scrubber |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer Lot # | manufacturerlotno | ||
| Owned By | ownedby | 1 | Asset Owner |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber |
Short Stop: 13
The Short Stop asset group in the PipelineDevice feature class represents fittings that prevent metal to metal shorts
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of short stop |
| Short Stop | 461 | Generic short stop |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Accessible | accessible | 1 | Yes No |
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Device Status | devicestatus | 1 | Pipeline Device Status |
| Diameter | diameter | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber |
Strainer: 6
The Strainer asset group in the PipelineDevice feature class represents components within a pipe system that remove free liquid or dirt particles from the commodity fluid or gas
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of strainer |
| Strainer | 442 | Generic strainer |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | 0 | Pipeline ASTM Strainer Manufacture Component |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | 0 | Pipeline ASTM Manufacturer |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber | ||
| Drain Valve Indicator | yesno |
Test Point: 17
The Test Point asset group in the PipelineDevice feature class represents read point locations where electric potential can be measured for a cathodic protection system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Test point for an unknown type of rectifier |
| Above Ground | 361 | Test point for a rectifier located above the ground surface |
| Buried | 362 | Test point for a rectifier located below the ground surface |
| On Post | 363 | Test point for a rectifier located above the ground surface and installed on a post |
| Pipeline Marker | 364 | Test point for a rectifier located above the ground surface and installed on a pipeline marker |
| Service Line | 365 | Test point for a rectifier installed on a service line |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Wire Count | adddetails | CP Test Point Wire Count | |
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Device Status | devicestatus | 1 | Pipeline Device Status |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer Lot # | manufacturerlotno | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
| Serial Number | serialnumber |
Unknown: 0
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Accessible | accessible | ||
| Additional Details | adddetails | ||
| Asset ID | assetid | ||
| Barcode | barcode | ||
| cpsubnetworkname | cpsubnetworkname | Unknown | |
| Depth | depth | ||
| Depth to Nut | depthtonut | ||
| Design Type | designtype | ||
| Device Status | devicestatus | ||
| Diameter | diameter | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | ||
| Length | length | ||
| Life Cycle Status | lifecyclestatus | ||
| Location Description | locationdescription | ||
| Maintained By | maintby | ||
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | ||
| MAOP Record | maoprecord | ||
| MAOP Test | maoptest | ||
| Material | material | ||
| Max Inlet Pressure | maxinletpressure | ||
| Max Outlet Pressure | maxoutletpressure | ||
| Normal Position | normalposition | ||
| Owned By | ownedby | ||
| Regulatory Type | regulatorytype | ||
| Rotation | rotation | ||
| Serial Number | serialnumber | ||
| Set Pressure Entered | setpressureentered | ||
| Set Pressure Standard | setpressurestandard | ||
| Turns to Close | turnstoclose | ||
| Generic Yes/No | yesno |
Wellhead Source Flange: 11
The Compressor asset group in the PipelineDevice feature class represents devices that mechanically increase gas pressure in the pipe system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of well source flange |
| Flange | 201 | Generic well head source flange |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer Lot # | manufacturerlotno | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Serial Number | serialnumber |
PipelineJunction
Fields
| Name | Alias | Type | Default Value | Domain | Nullable |
|---|---|---|---|---|---|
| regulatorytype | Regulatory Type | SmallInteger | 0 | Pipeline Regulatory Type | True |
| designtype | Design Type | SmallInteger | True | ||
| insulatordevice | Insulator Device | SmallInteger | 0 | Yes No | False |
| installationdate | Install Date | Date | True | ||
| inservicedate | Inservice Date | Date | True | ||
| assetid | Asset ID | String(64) | True | ||
| ownedby | Owned By | SmallInteger | 1 | Asset Owner | True |
| maintby | Maintained By | SmallInteger | 1 | Asset Manager | True |
| locationdescription | Location Description | String(100) | True | ||
| lifecyclestatus | Life Cycle Status | SmallInteger | 3 | Pipeline Life Cycle Status | False |
| maopdesign | MAOP Design | Double | 0.0 | Pipeline Pressure Range | False |
| maoptest | MAOP Test | Double | 0.0 | Pipeline Pressure Range | True |
| maoprecord | MAOP Record | Double | 0.0 | Pipeline Pressure Range | False |
| diameter | Diameter | Double | True | ||
| height | Height | Double | True | ||
| length | Length | Double | True | ||
| rotation | Rotation | SmallInteger | 0 | Symbol Rotation | True |
| barcode | Barcode | String(16) | True | ||
| manufacturer | Manufacturer | String(2) | True | ||
| manufacturerlotno | Manufacturer Lot # | Integer | True | ||
| manufacturedate | Manufacture Date | Date | True | ||
| manufacturecomponent | Manufacture Component | String(2) | True | ||
| material | Material | String(2) | True | ||
| cpsubnetworkname | cpsubnetworkname | String(2000) | Unknown | False |
Asset Groups
Bond Junction: 22
The Bond Junction asset group in the PipelineJunction feature class represents components interconnecting multiple bond wires
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown bond junction |
| Above Ground | 841 | Bond junction located above ground |
| Above Ground Bond | 842 | Bond junction located above ground |
| Above Ground With Anode | 843 | Bond junction located above ground with an anode |
| Above Ground With Foreign Line | 844 | Bond junction located above ground with a foreign line |
| Curb Box | 845 | Device which provides access to buried cathodic protection components |
| Curb Box Bond | 846 | Bond junction located in a curb box |
| Curb Box With Foreign Line | 847 | Bond junction located in a curb box with a foreign line |
| Polarization | 848 | Device which concurrently provides DC decoupling and AC grounding |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Resistance Indicator | designtype | 0 | Yes No |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Is Critical | insulatordevice | 0 | Yes No |
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer Lot # | manufacturerlotno | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Connection Point: 21
The Connection Point asset group in the PipelineJunction feature class represent attachments between structure junctions and pipes
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of connection point |
| Connection Point | 801 | Generic connection point |
Cooling System: 16
The Cooling System asset group in the PipelineJunction feature class represents components in a pipeline with the ability to reduce the temperature of the liquid or gas
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of cooling system |
| Cooling System | 601 | Generic cooling system |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Coupling: 1
The Coupling asset group in the PipelineJunction feature class represents inline assets used to connect two pipe segments of the same diameter and material
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of coupling |
| Metal Coupling | 1 | Metal base material coupling |
| Plastic Coupling | 2 | Plastic base material coupling |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Fitting Diameter |
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | Pipeline ASTM Coupling Manufacture Component | |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Coupon: 18
The Coupon asset group in the PipelineJunction feature class represents the location of samples cut from a metal pipe to assess internal corrosion
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of coupon |
| Coupon | 681 | Generic coupon |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Dehydration Equipment: 19
The Dehydration Equipment asset group in the PipelineJunction feature class represents components that inhibit the formation of hydrates in a pipeline
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of dehydration equipment |
| Glycol Dehydration | 721 | Equipment associated with the use of glycol to remove water from the gas stream |
| Methanol Dehydration | 722 | Equipment associated with the use of methanol to remove water from the gas stream |
| Solid Absorption | 723 | Equipment associated with the use of solid materials to remove water from the gas stream |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Owned By | ownedby | 1 | Asset Owner |
| Rotation | rotation | 0 | Symbol Rotation |
Drip: 20
The Drip asset group in the PipelineJunction feature class represents components that separate and collect water accumulated a pipeline
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of drip |
| Drip | 761 | Generic drip |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Capacity | diameter | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Elbow: 2
The Elbow asset group in the PipelineJunction feature class represents inline assets used to connect two pipe segments of the same material at an offset angle
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of elbow |
| Metal Elbow | 41 | Metal base material elbow |
| Plastic Elbow | 42 | Plastic base material elbow |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Fitting Diameter |
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | Pipeline ASTM Elbow Manufacture Component | |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Electro Stop: 11
The Electro Stop asset group in the PipelineJunction feature class represents in line assets that insulate electric current
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of electro stop |
| Electro Stop | 401 | Generic electro stop |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Fitting Diameter |
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 1 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
End Cap: 3
The End Cap asset group in the PipelineJunction feature class represents inline assets used for sealing the end of a pipe segment
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of end cap |
| Metal End Cap | 81 | Metal base material end cap |
| Plastic End Cap | 82 | Plastic base material end cap |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Fitting Diameter |
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | Pipeline ASTM End Cap Manufacture Component | |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Expansion Joint: 4
The Expansion Joint asset group in the PipelineJunction feature class represents inline assets used for connecting pipe segments and safely absorbing pipe system expansion, contraction, and vibration
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of expansion joint |
| Expansion Joint | 121 | Generic expansion joint |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Fitting Diameter |
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Flange: 5
The Flange asset group in the PipelineJunction feature class represents inline assets with an internal or external rim used to connect two pipe segments
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of flange |
| Metal Flange | 161 | Metallic primary material flange |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Fitting Diameter |
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Line Heater: 15
The Line Heater asset group in the PipelineJunction feature class represents components in a pipeline that can heat gas or liquids to prevent hydrate formation
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of line heater |
| Line Heater | 561 | Generic line heater |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Heating Capacity | diameter | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Odorizer: 17
The Odorizer asset group in the PipelineJunction feature class represents components that inject odorant into a gas pipe system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of odorizer |
| Absorption Bypass | 641 | Odorizer using a side channel of pipe to inject odorant |
| Injection Pump | 642 | Odorizer using a pump to inject liquid odorant |
| Pulse | 643 | Odorizer using a side tank to mix odorant vapors with gas |
| Rural Tap Odorizer | 644 | Odorizer that is part of a rural tap assembly |
| Wick | 645 | Odorizer that uses a wick to draw odorant from a container |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Odorant Type | designtype | Pipeline Odorant Type | |
| Capacity | diameter | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Plastic Fusion: 12
The Plastic Fusion asset group in the PipelineJunction feature class represents a connection created with an electro fusion device between two plastic pipes or components
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of plastic fusion |
| Plastic Fusion | 441 | Generic plastic fusion |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Fitting Diameter |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Plug: 24
The Plug asset group in the PipelineJunction feature class represents in line assets that allow taking a pressure reading
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of plug |
| Test Plug | 181 | Test plug |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | 0 | Pipeline Regulatory Type |
| Rotation | rotation | 0 | Symbol Rotation |
Reducer: 6
The Reducer asset group in the PipelineJunction feature class represents inline assets that connect pipe segments of different diameters
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of reducer |
| Metal Reducer | 201 | Metal base material reducer |
| Plastic Reducer | 202 | Plastic base material reducer |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Fitting Size | designtype | Pipeline Reducer Fitting Size | |
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | Pipeline ASTM Reducer Manufacture Component | |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Saddle: 13
The Saddle asset group in the PipelineJunction feature class represents saddles used to connect pipe segments, increase structural strength of pipe segments or tap a pipe segment
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of saddle |
| Metal Saddle | 481 | Metal base material saddle |
| Plastic Saddle | 482 | Plastic base material saddle |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Fitting Diameter |
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | Pipeline ASTM Saddle Manufacture Component | |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Screw: 10
The Screw asset group in the PipelineJunction feature class represents an inline asset with screw threads connecting two metal pipe segments
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of screw fitting |
| Screw | 361 | Generic screw fitting |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Fitting Diameter |
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Tank: 14
The Tank asset group in the PipelineJunction feature class represents facilities in a transmission pipeline that act as a storage unit to relieve surges in flow or to receive and store liquid or gas for reinjection into the pipeline
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of tank |
| Tank | 521 | Generic tank |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Lining Type | designtype | Pipeline Lining Type | |
| Flow Capacity | diameter | ||
| Height | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Capacity | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Tee: 7
The Tee asset group in the PipelineJunction feature class represents inline assets used to connect three or four pipe segments
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of tee |
| Metal 3-Way | 241 | Metal base material tee connecting three pipe segments |
| Metal 4-Way | 242 | Metal base material tee connecting four pipe segments |
| Plastic 3-Way | 243 | Plastic base material tee connecting three pipe segments |
| Plastic 4-Way | 244 | Plastic base material tee connecting four pipe segments |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | ||
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | Pipeline ASTM Tee Manufacture Component | |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Transition: 8
The Transition asset group in the PipelineJunction feature class represent inline assets used to connect pipe segments of different material
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of transition |
| Transition | 281 | Generic transition |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Fitting Diameter |
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | Pipeline ASTM Transition Manufacture Component | |
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | Pipeline ASTM Manufacturer | |
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
Union: 23
the Union asset group in the PipelineJunction feature class represents in line assets connecting two pipe segments that can be easily connected and disconnected
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of union |
| Metal Union | 341 | Metal base material union |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| cpsubnetworkname | cpsubnetworkname | Unknown | |
| Diameter | diameter | ||
| Wall Thickness | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | Pipeline ASTM Material | |
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | 0 | Pipeline Regulatory Type |
| Rotation | rotation | 0 | Symbol Rotation |
Unknown: 0
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| cpsubnetworkname | cpsubnetworkname | Unknown | |
| Design Type | designtype | ||
| Diameter | diameter | ||
| Height | height | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | ||
| Length | length | ||
| Life Cycle Status | lifecyclestatus | ||
| Location Description | locationdescription | ||
| Maintained By | maintby | ||
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | ||
| MAOP Record | maoprecord | ||
| MAOP Test | maoptest | ||
| Material | material | ||
| Owned By | ownedby | ||
| Regulatory Type | regulatorytype | ||
| Rotation | rotation |
Weld: 9
The Weld asset group in the PipelineJunction feature class represents a welded connection between two metal pipes
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of weld |
| Weld | 321 | Generic weld |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Diameter | diameter | 0.0 | Pipeline Fitting Diameter |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Insulator Device | insulatordevice | 0 | Yes No |
| Length | length | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | 0.0 | Pipeline Pressure Range |
| MAOP Record | maoprecord | 0.0 | Pipeline Pressure Range |
| MAOP Test | maoptest | 0.0 | Pipeline Pressure Range |
| Material | material | ||
| Owned By | ownedby | 1 | Asset Owner |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Rotation | rotation | 0 | Symbol Rotation |
PipelineLine
Fields
| Name | Alias | Type | Default Value | Domain | Nullable |
|---|---|---|---|---|---|
| regulatorytype | Regulatory Type | SmallInteger | Pipeline Regulatory Type | True | |
| pinchable | Pinchable | SmallInteger | 0 | Yes No | False |
| piggable | Piggable | SmallInteger | True | ||
| warningtape | Warning Tape | SmallInteger | True | ||
| tracerwire | Tracer Wire | SmallInteger | True | ||
| seamtype | Seam Type | SmallInteger | Pipeline Seam Type | True | |
| longseamtype | Long Seam Type | SmallInteger | Pipeline Seam Type | True | |
| girthweldtype | Girth Weld Type | SmallInteger | Pipeline Girth Weld Type | True | |
| longitudinalseamorientation | Longitudinal Seam Orientation | Double | Pipeline Seam Orientation | True | |
| pipesurfacearea | Pipe Surface Area | Double | 0.0 | False | |
| installationdate | Install Date | Date | True | ||
| inservicedate | Inservice Date | Date | True | ||
| installationmethod | Installation Method | SmallInteger | True | ||
| assetid | Asset ID | String(64) | True | ||
| ownedby | Owned By | SmallInteger | 1 | Asset Owner | True |
| maintby | Maintained By | SmallInteger | 1 | Asset Manager | True |
| lifecyclestatus | Life Cycle Status | SmallInteger | 3 | Pipeline Life Cycle Status | False |
| nominaldiameter | Nominal Diameter | Double | True | ||
| operatingpressure | Operating Pressure | Double | Pipeline Pressure Range | True | |
| maopdesign | MAOP Design | Double | 0.0 | Pipeline Pressure Range | False |
| maoptest | MAOP Test | Double | 0.0 | Pipeline Pressure Range | True |
| maoprecord | MAOP Record | Double | 0.0 | Pipeline Pressure Range | False |
| measuredlength | Measured Length | Double | True | ||
| lengthsource | Length Source | SmallInteger | Pipeline Length Source | True | |
| wallthickness | Wallthickness | Double | True | ||
| outsidediameter | Outside Diameter | Double | True | ||
| barcode | Barcode | String(16) | True | ||
| manufacturer | Manufacturer | String(2) | True | ||
| manufacturerlotno | Manufacturer Lot # | Integer | True | ||
| manufacturedate | Manufacture Date | Date | True | ||
| manufacturecomponent | Manufacture Component | String(2) | True | ||
| material | Material | String(2) | True | ||
| cpsubnetworkname | cpsubnetworkname | String(2000) | Unknown | False | |
| pipevolume | Pipe Volume | Double | 0.0 | False |
Asset Groups
Bond Wire: 8
The Bond Wire asset group in the PipelineLine feature class represents wire that is used to continue the electric connection in a cathodic protection system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of bond wire |
| Bond Wire | 281 | Generic type of bond wire |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Installation Method | installationmethod | ||
| Length Source | lengthsource | Pipeline Length Source | |
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Color Code | longseamtype | 0 | CP Color Code |
| Maintained By | maintby | 1 | Asset Manager |
| Measured Length | measuredlength | ||
| Owned By | ownedby | 1 | Asset Owner |
| Pipe Volume | pipevolume | 0.0 | |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Wire Size | seamtype |
Customer Pipe: 6
The Customer Pipe asset group in the PipelineLine feature class represents pipes that the gas organization does not own or maintain
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Pipe segment with unknown material composition |
| Bare Steel | 1 | Steel pipe that is not coated with a hot or cold applied wrapper |
| Cast Iron | 2 | Pipe made from iron with a carbon content greater than 2% |
| Coated Steel | 3 | Steel pipe that has been covered with a hot or cold applied wrapper |
| Composite | 4 | Pipe that is constructed of two or more dissimilar materials |
| Ductile Iron | 6 | Pipe made from iron with a less brittle type of graphite carbon |
| Plastic ABS | 7 | Plastic pipe made from Acrylonitrile- Butadiene Styrene plastic (ABS) |
| Plastic Other | 8 | Plastic pipe that is not made from ABS, PE, or PVC |
| Plastic PE | 9 | Plastic pipe made from polyethylene plastic (PE) |
| Plastic PVC | 10 | Plastic pipe made from polyvinyl chloride plastic (PVC) |
| Reconditioned Cast Iron | 11 | Cast iron pipe that has been rehabilitated |
| Wrought Iron | 12 | Pipe made from iron with a carbon content less than 2% |
Fields
Distribution Pipe: 2
The Distribution Pipe asset group in the PipelineLine feature class represents pipes that deliver gas from the town border station to the service pipe
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Pipe segment with unknown material composition |
| Bare Steel | 1 | Steel pipe that is not coated with a hot or cold applied wrapper |
| Cast Iron | 2 | Pipe made from iron with a carbon content greater than 2% |
| Coated Steel | 3 | Steel pipe that has been covered with a hot or cold applied wrapper |
| Composite | 4 | Pipe that is constructed of two or more dissimilar materials |
| Copper | 5 | Pipe made from the refined mineral copper (Cu) |
| Ductile Iron | 6 | Pipe made from iron with a less brittle type of graphite carbon |
| Plastic ABS | 7 | Plastic pipe made from Acrylonitrile- Butadiene Styrene plastic (ABS) |
| Plastic Other | 8 | Plastic pipe that is not made from ABS, PE, or PVC |
| Plastic PE | 9 | Plastic pipe made from polyethylene plastic (PE) |
| Plastic PVC | 10 | Plastic pipe made from polyvinyl chloride plastic (PVC) |
| Reconditioned Cast Iron | 11 | Cast iron pipe that has been rehabilitated |
| Wrought Iron | 12 | Pipe made from iron with a carbon content less than 2% |
Fields
Gathering Pipe: 4
The Gathering Pipe asset group in the PipelineLine feature class represents pipes that deliver gas from the well to the transmission subsystem
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Pipe segment with unknown material composition |
| Bare Steel | 1 | Steel pipe that is not coated with a hot or cold applied wrapper |
| Cast Iron | 2 | Pipe made from iron with a carbon content greater than 2% |
| Coated Steel | 3 | Steel pipe that has been covered with a hot or cold applied wrapper |
| Composite | 4 | Pipe that is constructed of two or more dissimilar materials |
| Ductile Iron | 6 | Pipe made from iron with a less brittle type of graphite carbon |
| Plastic ABS | 7 | Plastic pipe made from Acrylonitrile- Butadiene Styrene plastic (ABS) |
| Plastic Other | 8 | Plastic pipe that is not made from ABS, PE, or PVC |
| Plastic PE | 9 | Plastic pipe made from polyethylene plastic (PE) |
| Plastic PVC | 10 | Plastic pipe made from polyvinyl chloride plastic (PVC) |
| Reconditioned Cast Iron | 11 | Cast iron pipe that has been rehabilitated |
| Wrought Iron | 12 | Pipe made from iron with a carbon content less than 2% |
Fields
Rectifier Cable: 9
The Rectifier Cable asset group in the PipelineLine feature class represents the cable that transmits electricity from the rectifier to the cathodic protection system
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of rectifier cable |
| Rectifier Cable | 321 | Generic type of rectifier cable |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Installation Method | installationmethod | ||
| Length Source | lengthsource | Pipeline Length Source | |
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Maintained By | maintby | 1 | Asset Manager |
| Measured Length | measuredlength | ||
| Owned By | ownedby | 1 | Asset Owner |
| Pipe Volume | pipevolume | 0.0 | |
| Regulatory Type | regulatorytype | Pipeline Regulatory Type | |
| Cable Gauge | seamtype | 0 | CP Rectifier Cable Gauge |
Riser Pipe: 7
The Riser Pipe asset group in the PipeLine feature class represents the vertical pipe where a pipe system transitions from below ground to above ground
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Pipe segment with unknown material composition |
| Bare Steel | 1 | Steel pipe that is not coated with a hot or cold applied wrapper |
| Cast Iron | 2 | Pipe made from iron with a carbon content greater than 2% |
| Coated Steel | 3 | Steel pipe that has been covered with a hot or cold applied wrapper |
| Composite | 4 | Pipe that is constructed of two or more dissimilar materials |
| Ductile Iron | 6 | Pipe made from iron with a less brittle type of graphite carbon |
| Reconditioned Cast Iron | 11 | Cast iron pipe that has been rehabilitated |
| Wrought Iron | 12 | Pipe made from iron with a carbon content less than 2% |
Fields
Service Pipe: 1
The Service Pipe asset group in the PipelineLine feature class represents pipes that transport gas or liquid to the customer
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Pipe segment with unknown material composition |
| Bare Steel | 1 | Steel pipe that is not coated with a hot or cold applied wrapper |
| Cast Iron | 2 | Pipe made from iron with a carbon content greater than 2% |
| Coated Steel | 3 | Steel pipe that has been covered with a hot or cold applied wrapper |
| Composite | 4 | Pipe that is constructed of two or more dissimilar materials |
| Copper | 5 | Pipe made from the refined mineral copper (Cu) |
| Ductile Iron | 6 | Pipe made from iron with a less brittle type of graphite carbon |
| Plastic ABS | 7 | Plastic pipe made from Acrylonitrile- Butadiene Styrene plastic (ABS) |
| Plastic Other | 8 | Plastic pipe that is not made from ABS, PE, or PVC |
| Plastic PE | 9 | Plastic pipe made from polyethylene plastic (PE) |
| Plastic PVC | 10 | Plastic pipe made from polyvinyl chloride plastic (PVC) |
| Reconditioned Cast Iron | 11 | Cast iron pipe that has been rehabilitated |
| Wrought Iron | 12 | Pipe made from iron with a carbon content less than 2% |
Fields
Station Pipe: 5
The Station Pipe asset group in the PipelineLine feature class represents pipes in a gas facility that transport gas or liquid
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Pipe segment with unknown material composition |
| Bare Steel | 1 | Steel pipe that is not coated with a hot or cold applied wrapper |
| Cast Iron | 2 | Pipe made from iron with a carbon content greater than 2% |
| Coated Steel | 3 | Steel pipe that has been covered with a hot or cold applied wrapper |
| Composite | 4 | Pipe that is constructed of two or more dissimilar materials |
| Ductile Iron | 6 | Pipe made from iron with a less brittle type of graphite carbon |
| Reconditioned Cast Iron | 11 | Cast iron pipe that has been rehabilitated |
| Wrought Iron | 12 | Pipe made from iron with a carbon content less than 2% |
Fields
Transmission Pipe: 3
The Transmission Pipe asset group in the PipelineLine feature class represents pipes that deliver gas from the gathering subsystem to the distribution subsystem
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Pipe segment with unknown material composition |
| Bare Steel | 1 | Steel pipe that is not coated with a hot or cold applied wrapper |
| Cast Iron | 2 | Pipe made from iron with a carbon content greater than 2% |
| Coated Steel | 3 | Steel pipe that has been covered with a hot or cold applied wrapper |
| Composite | 4 | Pipe that is constructed of two or more dissimilar materials |
| Ductile Iron | 6 | Pipe made from iron with a less brittle type of graphite carbon |
| Reconditioned Cast Iron | 11 | Cast iron pipe that has been rehabilitated |
| Wrought Iron | 12 | Pipe made from iron with a carbon content less than 2% |
Fields
Unknown: 0
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Barcode | barcode | ||
| Girth Weld Type | girthweldtype | ||
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Installation Method | installationmethod | ||
| Length Source | lengthsource | ||
| Life Cycle Status | lifecyclestatus | ||
| Longitudinal Seam Orientation | longitudinalseamorientation | ||
| Long Seam Type | longseamtype | ||
| Maintained By | maintby | ||
| Manufacture Component | manufacturecomponent | ||
| Manufacture Date | manufacturedate | ||
| Manufacturer | manufacturer | ||
| Manufacturer Lot # | manufacturerlotno | ||
| MAOP Design | maopdesign | ||
| MAOP Record | maoprecord | ||
| MAOP Test | maoptest | ||
| Material | material | ||
| Measured Length | measuredlength | ||
| Nominal Diameter | nominaldiameter | ||
| Operating Pressure | operatingpressure | ||
| Outside Diameter | outsidediameter | ||
| Owned By | ownedby | ||
| Piggable | piggable | ||
| Pinchable | pinchable | ||
| Pipe Surface Area | pipesurfacearea | ||
| Pipe Volume | pipevolume | 0.0 | |
| Regulatory Type | regulatorytype | ||
| Seam Type | seamtype | ||
| Tracer Wire | tracerwire | ||
| Wallthickness | wallthickness | ||
| Warning Tape | warningtape |
StructureBoundary
Fields
| Name | Alias | Type | Default Value | Domain | Nullable |
|---|---|---|---|---|---|
| installationdate | Install Date | Date | True | ||
| inservicedate | InserviceDate | Date | True | ||
| assetid | Asset ID | String(64) | True | ||
| stationname | Station Name | String(30) | True | ||
| ownedby | Owned By | SmallInteger | 1 | Asset Owner | True |
| maintby | Maintained By | SmallInteger | 1 | Asset Manager | True |
| locationdescription | Location Description | String(100) | True | ||
| lifecyclestatus | Life Cycle Status | SmallInteger | 3 | Pipeline Life Cycle Status | False |
Asset Groups
Pipeline Processing Facility: 3
The Pipeline Processing Facility asset group in the StructureBoundary feature class represents above ground structures used to process the raw commodity
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of processing facility |
| Processing Facility | 41 | Generic processing facility |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| InserviceDate | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Owned By | ownedby | 1 | Asset Owner |
| Station Name | stationname |
Pipeline Station Structure: 1
The Pipeline Station Structure asset group in the StructureBoundary feature class represents above ground structures that house oil and gas facilities such as compressor stations, pump stations, town border stations and regulator stations
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of station structure |
| Station Structure | 1 | Generic station structure |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| InserviceDate | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Owned By | ownedby | 1 | Asset Owner |
| Station Name | stationname |
Pipeline Vault Boundary: 2
The Pipeline Vault Boundary asset group in the StructureBoundary feature class represents below ground structures that house oil and gas facilities such as compressor stations, pump stations, town border stations and regulator stations
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of vault |
| Vault Boundary | 81 | Generic vault |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| InserviceDate | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Owned By | ownedby | 1 | Asset Owner |
| Station Name | stationname |
Unknown: 0
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| InserviceDate | inservicedate | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | |
| Owned By | ownedby | 1 | |
| Station Name | stationname |
StructureJunction
Fields
| Name | Alias | Type | Default Value | Domain | Nullable |
|---|---|---|---|---|---|
| installationdate | Install Date | Date | True | ||
| assetid | Asset ID | String(64) | True | ||
| ownedby | Owned By | SmallInteger | 1 | Asset Owner | True |
| maintby | Maintained By | SmallInteger | 1 | Asset Manager | True |
| locationdescription | Location Description | String(100) | True | ||
| lifecyclestatus | Life Cycle Status | SmallInteger | 3 | Pipeline Life Cycle Status | False |
| quantity | Quantity | SmallInteger | True | ||
| weight | Comments | Double | True |
Asset Groups
Pipeline Anchor: 2
The Pipeline Anchor asset group in the StructureJunction feature class represents pipeline components used to secure the pipeline to a specific location
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of anchor component |
| Anchor | 41 | Generic anchor component |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Owned By | ownedby | 1 | Asset Owner |
| Quantity | quantity | ||
| Weight | weight |
Pipeline End Connection: 5
The Pipeline End Connection asset group in the StructureJunction feature class represents connections at the end of a pipe casing
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of end connection |
| End Seals | 161 | Seal at the end of a pipe casing containing the pipe casing fill |
| Skids & Straps | 162 | Wooden support pieces temporarily elevating pipe segments |
| Spacers | 163 | Insert for a pipe casing maintaining spacing between the pipe casing and the inserted pipe |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Owned By | ownedby | 1 | Asset Owner |
Pipeline Muffler: 1
The Pipeline Muffler asset group in the StructureJunction feature class represents pipeline facility components that reduce compressor or pump noise
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of muffler component |
| Muffler | 1 | Generic muffler component |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Owned By | ownedby | 1 | Asset Owner |
Pipeline Pipe Hanger: 4
The Pipeline Pipe Hanger asset group in the StructureJunction feature class represents pipeline facility components used to hang a pipe segment from an elevated location
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of pipe hanger |
| Constant Spring | 121 | Pipe hanger providing constant tension |
| Rigid | 122 | Pipe hanger restricting movement of the hung pipe segment |
| Variable Spring | 123 | Pipe hanger allowing limited movement in specified directions |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Owned By | ownedby | 1 | Asset Owner |
Pipeline Pipe Support: 3
The Pipeline Pipe Support asset group in the StructureJunction feature class represents pipeline facility components used to support a pipe segment
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of pipe support |
| Pipe Stand | 81 | Support structure securing a pipeline asset |
| Roller | 82 | Support structure upholding a pipe segment and allowing for lateral movement via thermal expansion or contraction |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Owned By | ownedby | 1 | Asset Owner |
Pipeline Valve Box: 7
The Pipeline Valve Box asset group in the StructureJunction feature class represents underground structures containing valves
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of valve box |
| Curb Box | 61 | Valve box containing a valve that controls gas supply from distribution main to customer |
| Curb Box with Stationary Rod | 62 | Valve box containing a valve and rod that controls gas supply from distribution main to customer |
| Roadway | 63 | Valve box located in a roadway |
| Valve Box | 64 | Generic valve box |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Owned By | ownedby | 1 | Asset Owner |
| Depth | weight |
Pipeline Vault: 6
The Pipeline Vault asset group in the StructureJunction feature class represents underground structures that store a gas facility
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | An unknown type of vault |
| Vault | 201 | Generic underground facility |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Owned By | ownedby | 1 | Asset Owner |
Unknown: 0
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Install Date | installationdate | ||
| Life Cycle Status | lifecyclestatus | 3 | |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | |
| Owned By | ownedby | 1 |
StructureLine
Fields
| Name | Alias | Type | Default Value | Domain | Nullable |
|---|---|---|---|---|---|
| filltype | Fill Type | SmallInteger | True | ||
| ventedindicator | Vented Indicator | SmallInteger | True | ||
| insertindicator | Insert Indicator | SmallInteger | True | ||
| installationdate | Install Date | Date | True | ||
| inservicedate | Inservice Date | Date | True | ||
| assetid | Asset ID | String(64) | True | ||
| ownedby | Owned By | SmallInteger | 1 | Asset Owner | True |
| maintby | Maintained By | SmallInteger | 1 | Asset Manager | True |
| locationdescription | Location Description | String(100) | True | ||
| lifecyclestatus | Life Cycle Status | SmallInteger | 3 | Pipeline Life Cycle Status | False |
| casingdiameter | Casing Diameter | Double | Pipeline Casing Diameter | True | |
| measuredlength | Measured Length | Double | True | ||
| lengthsource | Length Source | SmallInteger | True |
Asset Groups
Pipeline Casing: 1
The Pipeline Casing asset group in the StructureJunction feature class represents pipeline facilities that encase a portion of a pipeline
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 | Unknown type of pipe casing |
| Casing | 1 | Generic pipe casing |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Casing Diameter | casingdiameter | Pipeline Casing Diameter | |
| Fill Type | filltype | 0 | Pipeline Casing Fill Type |
| Insert Indicator | insertindicator | 0 | Yes No |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Length Source | lengthsource | 0 | Pipeline Length Source |
| Life Cycle Status | lifecyclestatus | 3 | Pipeline Life Cycle Status |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | Asset Manager |
| Measured Length | measuredlength | ||
| Owned By | ownedby | 1 | Asset Owner |
| Vented Indicator | ventedindicator | 0 | Yes No |
Unknown: 0
| Asset Type | Code | Description |
|---|---|---|
| Unknown | 0 |
Fields
| Name | GDB Name | Default Value | Domain |
|---|---|---|---|
| Asset ID | assetid | ||
| Casing Diameter | casingdiameter | ||
| Fill Type | filltype | 0 | Pipeline Casing Fill Type |
| Insert Indicator | insertindicator | 0 | Yes No |
| Inservice Date | inservicedate | ||
| Install Date | installationdate | ||
| Length Source | lengthsource | 0 | Pipeline Length Source |
| Life Cycle Status | lifecyclestatus | 3 | |
| Location Description | locationdescription | ||
| Maintained By | maintby | 1 | |
| Measured Length | measuredlength | ||
| Owned By | ownedby | 1 | |
| Vented Indicator | ventedindicator | 0 | Yes No |
Attribute Domains
AnnotationStatus
Valid annotation state values.
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Placed |
| 1 | Unplaced |
Asset Manager
The manager of the asset
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 1 | Our Agency |
| 2 | Private |
| 100 | Other |
Asset Owner
The owner of the asset
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 1 | Our Agency |
| 2 | Private |
| 100 | Other |
BooleanSymbolValue
Valid values are Yes and No.
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 1 | Yes |
| 0 | No |
CP ASTM Anode Manufacture Component
List of ASTM F-2897 Anode Manufacture Model Types
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| A0 | Other Anode |
| A1 | Cast Iron Anode |
| A2 | Graphite Anode |
| A3 | Magnesium Anode |
| A4 | Zinc Anode |
| 0 | Unknown |
CP Anode Weight
List of valid types of sizes by weight for anodes
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.75 | 3/4 lb |
| 1.0 | 1 lb |
| 3.0 | 3 lb |
| 5.0 | 5 lb |
| 9.0 | 9 lb |
| 17.0 | 17 lb |
| 20.0 | 20 lb |
| 32.0 | 32 lb |
| 48.0 | 48 lb |
| 1.5 | 1 1/2 lb |
CP Color Code
List of valid color used for bond wires
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Aqua |
| 2 | Blue |
| 3 | Forest |
| 4 | Green |
| 5 | Lavender |
| 6 | Orange |
| 7 | Pink |
| 8 | Purple |
| 9 | Red |
| 10 | Yellow |
CP Rectifier Cable Gauge
List of valid sizes used for rectifier cables
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 4 | 4 |
| 8 | 8 |
CP Rectifier Manufacturer
List of manufacturers for rectifiers
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Goodall |
| 2 | Kerotest |
| 3 | Rockwell |
| 4 | R.W. Lyall |
CP Test Point Wire Count
List of valid number of wires which can connect to a test point
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | 1 |
| 2 | 2 |
Gas Regulatory Type
List of Gas regulatory types
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Distribution |
| 2 | Gathering |
| 3 | Transmission |
| 4 | Offshore Gathering |
| 5 | Offshore Transmission |
Gas Valve Condition
Valid valve box conditions
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Good |
| 2 | Fair |
| 3 | Poor |
HorizontalAlignment
Valid horizontal symbol alignment values.
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Left |
| 1 | Center |
| 2 | Right |
| 3 | Full |
Pipeline ASTM Coupling Manufacture Component
List of ASTM F-2897 types of Coupling Manufacture Models
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 20 | Other Coupling |
| 21 | Socket Fusion Coupling |
| 22 | Socket Fusion with EFV Coupling |
| 23 | Electrofusion Coupling |
| 24 | Electrofusion with EFV Coupling |
| 25 | Mechanical Compression or nut follower Coupling |
| 26 | Mechanical Compression or nut follower Coupling with EFV |
| 27 | Mechanical stab Coupling |
| 28 | Mechanical stab with EFV Coupling |
| 29 | Mechanical interference fit Coupling |
| 2A | Mechanical interference fit with EFV Coupling |
| 2B | Welded Coupling |
| 2C | Threaded Coupling |
| 2D | Flanged Coupling |
| 30 | Other Adapter Coupling |
| 31 | Compression by Male pipe thread Adapter Coupling |
| 32 | Compression by femail pipe thread Adapter Coupling |
| 33 | Compression by butt fusion Adapter Coupling |
| 34 | Compression by butt welded Adapter Coupling |
| 35 | Compression by solvent welded Adapter Coupling |
| 36 | Stab by male pipe thread Adapter Coupling |
| 37 | Stab by female pipe thread Adapter Coupling |
| 38 | Stab by solvent welded Adapter Coupling |
| 39 | Compression by stab Adapter Coupling |
| 0 | Unknown |
Pipeline ASTM EFV Manufacture Component
List of ASTM F-2897 types of EFV Manufacture Models
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| EF | Excess Flow Valve |
| V0 | Other Valve |
| 0 | Unknown |
Pipeline ASTM Elbow Manufacture Component
List of ASTM F-2897 types of Elbow Manufacture Models
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 50 | Other Elbow |
| 51 | Butt fusion 90 Elbow |
| 52 | Socket fusion 90 Elbow |
| 53 | Electrofusion 90 Elbow |
| 54 | Mechanical compression or nut follower Elbow |
| 55 | Mechanical stab 90 Elbow |
| 56 | Mechanical interference fit 90 Elbow |
| 57 | Welded 90 Elbow |
| 58 | Threaded 90 Elbow |
| 59 | Fabricated 90 Elbow |
| 5A | Butt fusion 45 Elbow |
| 5B | Socket fusion 45 Elbow |
| 5C | Electrofusion 45 Elbow |
| 5D | Mechanical compression or nut follower 45 Elbow |
| 5E | Mechanical stab 45 Elbow |
| 5F | Mechanical interference fit 45 Elbow |
| 5G | Welded 45 Elbow |
| 5H | Threaded 45 Elbow |
| 5J | Fabricated 45 Elbow |
| 0 | Unknown |
Pipeline ASTM End Cap Manufacture Component
List of ASTM F-2897 types of End Cap Manufacture Models
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 40 | Other End Cap |
| 41 | Butt fusion End Cap |
| 42 | Socket fusion End Cap |
| 43 | Electrofusion End Cap |
| 44 | Mechanical compression or nut follower End Cap |
| 45 | Mechanical stab End Cap |
| 46 | Mechanical interference fit End Cap |
| 47 | Welded End Cap |
| 48 | Threaded End Cap |
| 49 | Fabricated End Cap |
| 0 | Unknown |
Pipeline ASTM Manufacturer
List of ASTM F2897 Manufacturers
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 35 | Industrial Pipe Fittings |
| 73 | Plasson |
| 78 | Torre Gas |
| AD | A-D Technologies |
| AG | Agru America Inc |
| AY | A.Y. McDonald Mfg Co. |
| CE | Centennial Plastics |
| CH | Charter Plastics Inc |
| CI | Continental Industries |
| CP | Georg Fischer Central Plastics LLC |
| DR | Dresser Pipeline Solutions |
| EL | Elster Perfection |
| EN | Endot Industries Inc |
| FR | IPEX Inc |
| GB | Gas Breaker Inc |
| HF | Valencia Pipe Company |
| IN | Innoge |
| IU | IPEX USA LLC |
| JM | J-M Manufacturing Co. |
| KT | Kerotest Manufacturing Corp |
| MT | M.T. Deason Co. inc |
| NG | Nupi Americas |
| PE | Performance Pipe |
| PL | Pipeline Plastics |
| PP | DuraLine |
| PT | Polytubes LP |
| PV | PolyValve LLC |
| RP | Rahn Plastics |
| RW | R.W. Lyall |
| SB | Smith-Blair Inc |
| TD | T.D. Williamson |
| TP | Teel Pipe LLC |
| UI | Uponor Infra Limited |
| UP | United Poly Systems |
| VP | Versaprofiles Inc |
| WL | WL Plastics |
| 0 | Unknown |
Pipeline ASTM Material
List of ASTM F2897 Materials
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| A | Plastic PE2406 |
| B | Plastic PE2708 |
| C | Plastic PE3408 |
| D | Plastic PE3608 |
| E | Plastic PE3708 |
| F | Plastic PE3710 |
| G | Plastic PE4608 |
| H | Plastic PE4710 |
| J | Plastic PVC |
| K | Plastic PA11 |
| L | Plastic PA12 |
| M | Steel |
| N | Stainless Steel |
| O | Cast Iron |
| P | Copper |
| Q | Brass |
| R | Malleable Iron |
| S | Ductile Iron |
| T | Reinforced Epoxy Resin |
| U | Nylon |
| V | Glass Filled Nylon |
| X | Other |
| 0 | Steel Grade A |
| 1 | Steel Grade B |
| 2 | Steel Grade C |
| 3 | Steel Grade X42 |
| 4 | Steel Grade X46 |
| 5 | Steel Grade X52 |
| 6 | Steel Grade X56 |
| 7 | Steel Grade X60 |
| 8 | Steel Grade X65 |
| 9 | Steel Grade X70 |
Pipeline ASTM Meter Manufacture Component
List of ASTM F-2897 Meter Set Manufacture Model
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| M0 | Other Meter |
| M1 | Diaphragm Meter |
| M2 | Rotary Meter |
| M3 | Meter Set Assembly |
| M4 | Meter bar |
| M5 | Meter Swival |
| M6 | Meter Nut |
| M7 | Ultrasonic Meter |
| M8 | Turbine Meter |
| M9 | Remote shut off Meter |
| 0 | Unknown |
Pipeline ASTM Pipe Manufacture Component
List of ASTM F-2897 Pipe Specifications
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 10 | Other Pipe |
| 11 | Straight Pipe |
| 12 | Coiled Pipe |
| 13 | Casing Pipe |
| 1A | Seamless Line Pipe, API 5L, PSL1, Single Coat Pipe |
| 1B | Seamless Line Pipe, API 5L, PSL1, Dual Coat Pipe |
| 1C | Seamless Line Pipe, API 5L, PSL2, Single Coat Pipe |
| 1D | Seamless Line Pipe, API 5L, PSL2, Dual Coat Pipe |
| 1E | Electric Resistance Weld, API 5L, PSL1, Single Coat Pipe |
| 1F | Electric Resistance Weld, API 5L, PSL1, Dual Coat Pipe |
| 1G | Electric Resistance Weld, API 5L, PSL2, Single Coat Pipe |
| 1H | Electric Resistance Weld, API 5L, PSL2, Dual Coat Pipe |
| 1J | Seamless and Welded ASTM A53/A53M Pipe |
| 1K | Seamless Carbon Steel ASTM A106 Pipe |
| 0 | Unknown |
Pipeline ASTM Reducer Manufacture Component
List of ASTM F-2897 Reducer Manufacture Model Types
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 70 | Other Reducer |
| 71 | Butt fusion Reducer |
| 72 | Socket fusion Reducer |
| 73 | Electrofusion Reducer |
| 74 | Mechanical compression or nut follower Reducer |
| 75 | Mechanical stab Reducer |
| 76 | Mechanical Interference fit Reducer |
| 77 | Welded Reducer |
| 78 | Threaded Reducer |
| 79 | Fabricated Reducer |
| 0 | Unknown |
Pipeline ASTM Regulator Manufacture Component
List of ASTM F-2897 Regulator Manufacture Model Types
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| RX | Other Regulator |
| RP | Pilot Regulator |
| RS | Service Regulator |
| RR | Relief Regulator |
| 0 | Unknown |
Pipeline ASTM Saddle Manufacture Component
List of ASTM F-2897 Saddle Manufacture Model Types
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| B0 | Other branch saddle |
| B1 | Electrofusion branch saddle |
| B2 | Saddle heat fusion branch saddle |
| B3 | Mechanical fusion branch saddle |
| D0 | Other mechanical saddle service tee |
| D1 | Welded by welded mechanical saddle service tee |
| D2 | Welded by butt fusion mechanical saddle service tee |
| D3 | Welded by thread mechanical saddle service tee |
| D4 | Welded by compression or nut follower saddle service tee |
| D5 | Welded by mechanical interference fit mechanical saddle service tee |
| DD | Welded by stab mechanical saddle service tee |
| D6 | Thread by Welded mechanical saddle service tee |
| D7 | Thread by compression or nut follower mechanical saddle service tee |
| DE | Thread by mechanical interference fit mechanical saddle service tee |
| DF | Thread by stab mechanical saddle service tee |
| DG | Thread by thread mechanical saddle service tee |
| DH | Thread by butt fusion mechanical saddle service tee |
| D8 | Mechanical saddle by welded mechanical saddle service tee |
| D9 | Mechanical saddle by butt fusion mechanical saddle service tee |
| DA | Mechanical saddle by thread mechanical saddle service tee |
| DB | Mechanical saddle by compression or nut follower mechanical saddle service tee |
| DC | Mechanical saddle by mechanical interference fit mechanical saddle service tee |
| DJ | Mechanical saddle by stab mechanical saddle service tee |
| E0 | Other service saddle |
| E1 | Single strap service saddle |
| E2 | Double strap service saddle |
| 0 | Unknown |
Pipeline ASTM Strainer Manufacture Component
List of ASTM F-2897 Strainer Manufacture Model Types
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| F0 | Other Filter |
| F1 | Pilot Filter |
| F2 | Service and mains Filter |
| F3 | Strainer Filter |
| 0 | Unknown |
Pipeline ASTM Tee Manufacture Component
List of ASTM F-2897 Tee Manufacture Model Types
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 60 | Other 3-Way Tee |
| 61 | Butt fusion 3-Way Tee |
| 62 | Socket fusion 3-Way Tee |
| 63 | Electrofusion 3-Way Tee |
| 64 | Mechanical compression or nut follower 3-Way Tee |
| 65 | Mechanical stab 3-Way Tee |
| 66 | Mechanical interference fit 3-Way Tee |
| 67 | Welded 3-Way Tee |
| 68 | Threaded 3-Way Tee |
| 69 | Fabricated 3-Way Tee |
| 80 | Other Tapping Tee |
| 81 | Saddle heat fusion by butt fusion outlet tapping Tee |
| 82 | Saddle heat fusion by butt fusion outlet with EFV tapping Tee |
| 83 | Saddle heat fusion by socket outlet tapping Tee |
| 84 | Saddle heat fusion by socket outlet with EFV tapping Tee |
| 85 | Saddle heat fusion by mechanical compression outlet tapping Tee |
| 86 | Saddle heat fusion by mechanical compression outlet with EFV tapping Tee |
| 87 | Saddle heat fusion by stab outlet tapping Tee |
| 88 | Saddle heat fusion by stab outlet with EFV tapping Tee |
| 89 | Electrofusion by butt fusion outlet tapping Tee |
| 8A | Electrofusion by butt fusion outlet with EFV tapping Tee |
| 8B | Electrofusion by socket fusion tapping Tee |
| 8C | Electrofusion by socket fusion with EFV tapping Tee |
| 8D | Electrofusion by mechanical compression outlet tapping Tee |
| 8E | Electrofusion by mechanical compression outlet with EFV tapping Tee |
| 8F | Electrofusion by stab outlet tapping Tee |
| 8G | Electrofusion by stab outlet with EFV tapping Tee |
| 8H | Mechanical by butt fusion tapping Tee |
| 8J | Mechanical by butt fusion with EFV tapping Tee |
| 8K | Mechanical by Socket outlet tapping Tee |
| 8L | Mechanical by socket outlet with EFV tapping Tee |
| 8M | Mechanical by mechanical compression outlet tapping Tee |
| 8N | Mechanical by mechanical compression outlet with EFV tapping Tee |
| 8P | Mechanical by stab outlet tapping Tee |
| 8Q | Mechanical by stab outlet with EFV tapping Tee |
| 8R | Mechanical by mechanical interference fit tapping Tee |
| 8S | Mechanical by mechanical interference fit with EFV tapping Tee |
| 90 | Other high volume tapping Tee |
| 91 | Electrofusion by butt fusion high volume tapping Tee |
| 92 | Saddle heat fusion by butt fusion high volume tapping Tee |
| 93 | Mechanical by compression outlet high volume tapping Tee |
| 94 | Electrofusion by socket outlet high volume tapping Tee |
| 95 | Saddle heat fusion by socket outlet high volume tapping Tee |
| 96 | Mechanical by stab outlet high volume tapping Tee |
| 97 | Mechanical by mechanical interference fit high volume tapping Tee |
| 0 | Unknown |
Pipeline ASTM Transition Manufacture Component
List of ASTM F-2897 Transition Manufacture Model Types
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| T0 | Other Transition |
| T1 | Welded end Transition |
| T2 | Thread end Transition |
| T3 | Flanged end Transition |
| 0 | Unknown |
Pipeline ASTM Valve Manufacture Component
List of ASTM F-2897 manufacturer specified types of valves
| Type | Split Policy | Merge Policy |
|---|---|---|
| Text | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| V0 | Other Valve |
| V1 | Ball Valve |
| V2 | Butterfly Valve |
| V3 | Check Valve |
| V4 | Relief Valve |
| V5 | Gas Valve |
| V6 | Needle Valve |
| V7 | Plug Valve |
| 0 | Unknown |
Pipeline Casing Diameter
List of valid casing diameters
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
Pipeline Casing Fill Type
List of valid casing fill types
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Grout |
| 2 | Pea Gravel |
| 3 | Sand |
Pipeline Cooling Method
List of Valid systems used to prevent the rectifier from overheating
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
Pipeline Device Status
List of valid values for the Network Attribute Device Status
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Open |
| 2 | Closed |
Pipeline EFV Diameter
List of valid diameter sizes for excess flow valves
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.25 | 1/4" |
| 0.375 | 3/8" |
| 0.5 | 1/2" |
| 0.625 | 5/8" |
| 0.75 | 3/4" |
| 1.0 | 1" |
| 1.125 | 1 1/8" |
| 1.25 | 1 1/4" |
| 1.375 | 1 3/8" |
| 1.5 | 1 1/2" |
| 1.875 | 1 7/8" |
| 2.0 | 2" |
| 3.0 | 3" |
| 4.0 | 4" |
| 5.0 | 5" |
| 6.0 | 6" |
Pipeline Fitting Diameter
List of valid diameter sizes for Pipeline Junction Single Diameter Fittings
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.25 | 1/4" |
| 0.375 | 3/8" |
| 0.5 | 1/2" |
| 0.625 | 5/8" |
| 0.75 | 3/4" |
| 1.0 | 1" |
| 1.125 | 1 1/8" |
| 1.25 | 1 1/4" |
| 1.375 | 1 3/8" |
| 1.5 | 1 1/2" |
| 1.875 | 1 7/8" |
| 2.0 | 2" |
| 2.5 | 2 1/2" |
| 3.0 | 3" |
| 4.0 | 4" |
| 5.0 | 5" |
| 5.5 | 5 1/2" |
| 6.0 | 6" |
| 8.0 | 8" |
| 10.0 | 10" |
| 12.0 | 12" |
| 14.0 | 14" |
| 16.0 | 16" |
| 18.0 | 18" |
| 20.0 | 20" |
| 24.0 | 24" |
| 26.0 | 26" |
| 30.0 | 30" |
| 36.0 | 36" |
| 40.0 | 40" |
| 48.0 | 48" |
Pipeline Girth Weld Type
List of valid weld types
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
Pipeline Install Method
List of valid types of methods for installing Pipeline Lines
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Trench |
| 2 | Joint Trench |
| 3 | Insertion |
| 4 | Direct Bore |
| 5 | Split and Pull |
| 6 | Assemble |
Pipeline Length Source
List of valid types of sources for measured length
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Field Measurement |
| 2 | GPS Sub- 30 Meter |
| 3 | GPS Sub- 10 Meter |
| 4 | GPS Sub-Meter |
| 5 | GPS Sub-Foot |
| 6 | GPS Centimeter |
| 7 | Mapping System |
| 8 | User-Derived |
| 9 | Begin-End Measures |
Pipeline Life Cycle Status
List of the valid status's for an asset
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Proposed |
| 2 | Proposed Retired |
| 3 | In Service |
| 4 | Out of Service |
| 5 | Retired |
| 6 | Removed |
| 7 | Abandoned |
| 8 | Under Construction |
Pipeline Lining Type
List of Valid types of material used to cover the interior of the tank to prevent leakage
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
Pipeline Meter Diameter - Customer
List of valid diameter sizes for customer meters
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.25 | 1/4" |
| 0.375 | 3/8" |
| 0.5 | 1/2" |
| 0.625 | 5/8" |
| 0.75 | 3/4" |
| 1.0 | 1" |
| 1.125 | 1 1/8" |
| 1.25 | 1 1/4" |
| 1.375 | 1 3/8" |
| 1.5 | 1 1/2" |
| 1.875 | 1 7/8" |
| 2.0 | 2" |
| 2.5 | 2 1/2" |
| 3.0 | 3" |
| 4.0 | 4" |
| 5.0 | 5" |
| 5.5 | 5 1/2" |
| 6.0 | 6" |
| 8.0 | 8" |
| 10.0 | 10" |
| 12.0 | 12" |
| 14.0 | 14" |
| 16.0 | 16" |
| 18.0 | 18" |
| 20.0 | 20" |
| 24.0 | 24" |
Pipeline Meter Type
List of valid types of meters
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Annubar |
| 2 | Diaphragm |
| 3 | Oriface |
| 4 | Rotary |
| 5 | Thermal Well |
| 6 | Turbine |
| 7 | Ultrasonic |
Pipeline Odorant Type
List of Valid types of odorant used in the odorizer
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
Pipeline Over Pressure Protection Type
List of types of over pressure protection for pipeline facilities
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Full Capacity Relief Valve |
| 2 | Monitor and Operator |
| 3 | Monitor Only |
| 4 | Operator and Monitor |
| 5 | Operator Only |
Pipeline Pipe Diameter - Customer
List of Valid Nominal Diameter Size for Customer Pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.25 | 1/4" |
| 0.375 | 3/8" |
| 0.5 | 1/2" |
| 0.75 | 3/4" |
| 1.0 | 1" |
| 1.25 | 1 1/4" |
| 1.5 | 1 1/2" |
| 2.0 | 2" |
| 2.5 | 2 1/2" |
| 3.0 | 3" |
| 3.5 | 3 1/2" |
| 4.0 | 4" |
| 4.5 | 4 1/2" |
| 5.0 | 5" |
| 6.0 | 6" |
Pipeline Pipe Diameter - Distribution
List of Valid Nominal Diameter Size for Distribution Pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.25 | 1/4" |
| 0.38 | 3/8" |
| 0.5 | 1/2" |
| 0.75 | 3/4" |
| 1.0 | 1" |
| 1.25 | 1 1/4" |
| 1.5 | 1 1/2" |
| 2.0 | 2" |
| 2.5 | 2 1/2" |
| 3.0 | 3" |
| 3.5 | 3 1/2" |
| 4.0 | 4" |
| 4.5 | 4 1/2" |
| 5.0 | 5" |
| 6.0 | 6" |
| 7.0 | 7" |
| 8.0 | 8" |
| 9.0 | 9" |
| 10.0 | 10" |
| 12.0 | 12" |
| 14.0 | 14" |
| 16.0 | 16" |
Pipeline Pipe Diameter - Gathering
List of Valid Nominal Diameter Size for Gathering Pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.25 | 1/4" |
| 0.375 | 3/8" |
| 0.5 | 1/2" |
| 0.75 | 3/4" |
| 1.0 | 1" |
| 1.25 | 1 1/4" |
| 1.5 | 1 1/2" |
| 2.0 | 2" |
| 2.5 | 2 1/2" |
| 3.0 | 3" |
| 3.5 | 3 1/2" |
| 4.0 | 4" |
| 4.5 | 4 1/2" |
| 5.0 | 5" |
| 6.0 | 6" |
| 7.0 | 7" |
| 8.0 | 8" |
| 9.0 | 9" |
| 10.0 | 10" |
| 12.0 | 12" |
| 14.0 | 14" |
| 16.0 | 16" |
Pipeline Pipe Diameter - Riser
List of Valid Nominal Diameter Size for Riser Pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.25 | 1/4" |
| 0.375 | 3/8" |
| 0.5 | 1/2" |
| 0.75 | 3/4" |
| 1.0 | 1" |
| 1.25 | 1 1/4" |
| 1.5 | 1 1/2" |
| 2.0 | 2" |
| 2.5 | 2 1/2" |
| 3.0 | 3" |
| 3.5 | 3 1/2" |
| 4.0 | 4" |
| 4.5 | 4 1/2" |
| 5.0 | 5" |
| 6.0 | 6" |
Pipeline Pipe Diameter - Services
List of Valid Nominal Diameter Size for Service Lines
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.25 | 1/4" |
| 0.375 | 3/8" |
| 0.5 | 1/2" |
| 0.75 | 3/4" |
| 1.0 | 1" |
| 1.25 | 1 1/4" |
| 1.5 | 1 1/2" |
| 2.0 | 2" |
| 2.5 | 2 1/2" |
| 3.0 | 3" |
| 3.5 | 3 1/2" |
| 4.0 | 4" |
| 4.5 | 4 1/2" |
| 5.0 | 5" |
| 6.0 | 6" |
Pipeline Pipe Diameter - Station
List of Valid Nominal Diameter Size for Station Pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 4.0 | 4" |
| 6.0 | 6" |
| 7.0 | 7" |
| 8.0 | 8" |
| 9.0 | 9" |
| 10.0 | 10" |
| 12.0 | 12" |
| 14.0 | 14" |
| 16.0 | 16" |
| 18.0 | 18" |
| 20.0 | 20" |
| 22.0 | 22" |
| 24.0 | 24" |
| 26.0 | 26" |
| 28.0 | 28" |
| 30.0 | 30" |
| 32.0 | 32" |
| 34.0 | 34" |
| 36.0 | 36" |
| 40.0 | 40" |
| 42.0 | 42" |
| 44.0 | 44" |
| 48.0 | 48" |
| 52.0 | 52" |
| 56.0 | 56" |
| 60.0 | 60" |
| 64.0 | 64" |
| 68.0 | 68" |
| 72.0 | 72" |
| 76.0 | 76" |
| 80.0 | 80" |
| 88.0 | 88" |
Pipeline Pipe Diameter - Transmission
List of Valid Nominal Diameter Size for Transmission Pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 12.0 | 12" |
| 14.0 | 14" |
| 16.0 | 16" |
| 18.0 | 18" |
| 20.0 | 20" |
| 22.0 | 22" |
| 24.0 | 24" |
| 26.0 | 26" |
| 28.0 | 28" |
| 30.0 | 30" |
| 32.0 | 32" |
| 34.0 | 34" |
| 36.0 | 36" |
| 40.0 | 40" |
| 42.0 | 42" |
| 44.0 | 44" |
| 48.0 | 48" |
| 52.0 | 52" |
| 56.0 | 56" |
| 60.0 | 60" |
| 64.0 | 64" |
| 68.0 | 68" |
| 72.0 | 72" |
| 76.0 | 76" |
| 80.0 | 80" |
Pipeline Pipe Outside Diameter
List of outside diameter Pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
Pipeline Pipe Outside Diameter - Riser
List of NPS outside diameter for Riser Steel Pipe Material
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.54 | 0.540" |
| 0.675 | 0.675" |
| 0.84 | 0.840" |
| 1.05 | 1.050" |
| 1.315 | 1.315" |
| 1.66 | 1.660" |
| 1.9 | 1.900" |
| 2.375 | 2 3/8" |
| 2.875 | 2 7/8" |
| 3.5 | 3 1/2" |
| 4.0 | 4" |
| 4.5 | 4 1/2" |
| 5.0 | 5" |
| 5.563 | 5.563 |
| 6.625 | 6 5/8" |
| 7.625 | 7 5/8" |
| 8.625 | 8 5/8" |
| 9.625 | 9 5/8" |
| 10.75 | 10 3/4" |
| 12.75 | 12 3/4" |
| 14.0 | 14" |
| 16.0 | 16" |
| 18.0 | 18" |
| 20.0 | 20" |
| 22.0 | 22" |
| 24.0 | 24" |
| 26.0 | 26" |
| 28.0 | 28" |
| 30.0 | 30" |
| 32.0 | 32" |
| 34.0 | 34" |
| 36.0 | 36" |
| 40.0 | 40" |
| 42.0 | 42" |
| 44.0 | 44" |
| 46.0 | 46" |
| 48.0 | 48" |
| 52.0 | 52" |
| 56.0 | 56" |
| 60.0 | 60" |
| 64.0 | 64" |
| 68.0 | 68" |
| 72.0 | 72" |
| 76.0 | 76" |
| 80.0 | 80" |
| 88.0 | 88" |
Pipeline Pipe Outside Diameter - Station
List of NPS outside diameter for Station Steel Pipe Material
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.54 | 0.540" |
| 0.675 | 0.675" |
| 0.84 | 0.840" |
| 1.05 | 1.050" |
| 1.315 | 1.315" |
| 1.66 | 1.660" |
| 1.9 | 1.900" |
| 2.375 | 2 3/8" |
| 2.875 | 2 7/8" |
| 3.5 | 3 1/2" |
| 4.0 | 4" |
| 4.5 | 4 1/2" |
| 5.0 | 5" |
| 5.563 | 5.563 |
| 6.625 | 6 5/8" |
| 7.625 | 7 5/8" |
| 8.625 | 8 5/8" |
| 9.625 | 9 5/8" |
| 10.75 | 10 3/4" |
| 12.75 | 12 3/4" |
| 14.0 | 14" |
| 16.0 | 16" |
| 18.0 | 18" |
| 20.0 | 20" |
| 22.0 | 22" |
| 24.0 | 24" |
| 26.0 | 26" |
| 28.0 | 28" |
| 30.0 | 30" |
| 32.0 | 32" |
| 34.0 | 34" |
| 36.0 | 36" |
| 40.0 | 40" |
| 42.0 | 42" |
| 44.0 | 44" |
| 46.0 | 46" |
| 48.0 | 48" |
| 52.0 | 52" |
| 56.0 | 56" |
| 60.0 | 60" |
| 64.0 | 64" |
| 68.0 | 68" |
| 72.0 | 72" |
| 76.0 | 76" |
| 80.0 | 80" |
| 88.0 | 88" |
Pipeline Pipe Outside Diameter - Transmission
List of NPS outside diameter for Transmission Steel Pipe Material
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.54 | 0.540" |
| 0.675 | 0.675" |
| 0.84 | 0.840" |
| 1.05 | 1.050" |
| 1.315 | 1.315" |
| 1.66 | 1.660" |
| 1.9 | 1.900" |
| 2.375 | 2 3/8" |
| 2.875 | 2 7/8" |
| 3.5 | 3 1/2" |
| 4.0 | 4" |
| 4.5 | 4 1/2" |
| 5.0 | 5" |
| 5.563 | 5.563 |
| 6.625 | 6 5/8" |
| 7.625 | 7 5/8" |
| 8.625 | 8 5/8" |
| 9.625 | 9 5/8" |
| 10.75 | 10 3/4" |
| 12.75 | 12 3/4" |
| 14.0 | 14" |
| 16.0 | 16" |
| 18.0 | 18" |
| 20.0 | 20" |
| 22.0 | 22" |
| 24.0 | 24" |
| 26.0 | 26" |
| 28.0 | 28" |
| 30.0 | 30" |
| 32.0 | 32" |
| 34.0 | 34" |
| 36.0 | 36" |
| 40.0 | 40" |
| 42.0 | 42" |
| 44.0 | 44" |
| 46.0 | 46" |
| 48.0 | 48" |
| 52.0 | 52" |
| 56.0 | 56" |
| 60.0 | 60" |
| 64.0 | 64" |
| 68.0 | 68" |
| 72.0 | 72" |
| 76.0 | 76" |
| 80.0 | 80" |
| 88.0 | 88" |
Pipeline Pipe Wall Thickness
List of valid wall thickness of Pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
Pipeline Pipe Wall Thickness - Riser
List of NPS valid wall thickness of Riser Steel Pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.068 | 0.068" |
| 0.083 | 0.083" |
| 0.088 | 0.088" |
| 0.091 | 0.091" |
| 0.109 | 0.109" |
| 0.113 | 0.113" |
| 0.12 | 0.120" |
| 0.133 | 0.133" |
| 0.134 | 0.134" |
| 0.14 | 0.140" |
| 0.145 | 0.145" |
| 0.148 | 0.148" |
| 0.154 | 0.154" |
| 0.165 | 0.165" |
| 0.18 | 0.180" |
| 0.203 | 0.203" |
| 0.216 | 0.216" |
| 0.226 | 0.226" |
| 0.237 | 0.237" |
| 0.247 | 0.247" |
| 0.25 | 0.250" |
| 0.258 | 0.258" |
| 0.277 | 0.277" |
| 0.28 | 0.280" |
| 0.281 | 0.281" |
| 0.301 | 0.301" |
| 0.307 | 0.307" |
| 0.312 | 0.312" |
| 0.322 | 0.322" |
| 0.33 | 0.330" |
| 0.337 | 0.337" |
| 0.342 | 0.342" |
| 0.355 | 0.355" |
| 0.365 | 0.365" |
| 0.375 | 0.375" |
| 0.406 | 0.406" |
| 0.432 | 0.432" |
| 0.437 | 0.437" |
| 0.5 | 0.500" |
| 0.562 | 0.562" |
| 0.593 | 0.593" |
| 0.625 | 0.625" |
| 0.656 | 0.656" |
| 0.75 | 0.750" |
| 0.812 | 0.812" |
| 0.968 | 0.968" |
Pipeline Pipe Wall Thickness - Station
List of NPS valid wall thickness of Station Steel Pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.068 | 0.068" |
| 0.083 | 0.083" |
| 0.088 | 0.088" |
| 0.091 | 0.091" |
| 0.109 | 0.109" |
| 0.113 | 0.113" |
| 0.12 | 0.120" |
| 0.133 | 0.133" |
| 0.134 | 0.134" |
| 0.14 | 0.140" |
| 0.145 | 0.145" |
| 0.148 | 0.148" |
| 0.154 | 0.154" |
| 0.165 | 0.165" |
| 0.18 | 0.180" |
| 0.203 | 0.203" |
| 0.216 | 0.216" |
| 0.226 | 0.226" |
| 0.237 | 0.237" |
| 0.247 | 0.247" |
| 0.25 | 0.250" |
| 0.258 | 0.258" |
| 0.277 | 0.277" |
| 0.28 | 0.280" |
| 0.281 | 0.281" |
| 0.301 | 0.301" |
| 0.307 | 0.307" |
| 0.312 | 0.312" |
| 0.322 | 0.322" |
| 0.33 | 0.330" |
| 0.337 | 0.337" |
| 0.342 | 0.342" |
| 0.355 | 0.355" |
| 0.365 | 0.365" |
| 0.375 | 0.375" |
| 0.406 | 0.406" |
| 0.432 | 0.432" |
| 0.437 | 0.437" |
| 0.5 | 0.500" |
| 0.562 | 0.562" |
| 0.593 | 0.593" |
| 0.625 | 0.625" |
| 0.656 | 0.656" |
| 0.75 | 0.750" |
| 0.812 | 0.812" |
| 0.968 | 0.968" |
Pipeline Pipe Wall Thickness - Transmission
List of NPS valid wall thickness of Transmission Steel Pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.068 | 0.068" |
| 0.083 | 0.083" |
| 0.088 | 0.088" |
| 0.091 | 0.091" |
| 0.109 | 0.109" |
| 0.113 | 0.113" |
| 0.12 | 0.120" |
| 0.133 | 0.133" |
| 0.134 | 0.134" |
| 0.14 | 0.140" |
| 0.145 | 0.145" |
| 0.148 | 0.148" |
| 0.154 | 0.154" |
| 0.165 | 0.165" |
| 0.18 | 0.180" |
| 0.203 | 0.203" |
| 0.216 | 0.216" |
| 0.226 | 0.226" |
| 0.237 | 0.237" |
| 0.247 | 0.247" |
| 0.25 | 0.250" |
| 0.258 | 0.258" |
| 0.277 | 0.277" |
| 0.28 | 0.280" |
| 0.281 | 0.281" |
| 0.301 | 0.301" |
| 0.307 | 0.307" |
| 0.312 | 0.312" |
| 0.322 | 0.322" |
| 0.33 | 0.330" |
| 0.337 | 0.337" |
| 0.342 | 0.342" |
| 0.355 | 0.355" |
| 0.365 | 0.365" |
| 0.375 | 0.375" |
| 0.406 | 0.406" |
| 0.432 | 0.432" |
| 0.437 | 0.437" |
| 0.5 | 0.500" |
| 0.562 | 0.562" |
| 0.593 | 0.593" |
| 0.625 | 0.625" |
| 0.656 | 0.656" |
| 0.75 | 0.750" |
| 0.812 | 0.812" |
| 0.968 | 0.968" |
Pipeline Pipe Wellhead Pressure Rating
List of valid pressure ratings for wellheads
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 2000.0 | 2000 psi |
| 3000.0 | 3000 psi |
| 5000.0 | 5000 psi |
| 10000.0 | 10000 psi |
| 15000.0 | 15000 psi |
Pipeline Pipeline Operator Number
The valid US DOT issued unique identifiers
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
Pipeline Pressure Range
Valid Range of values for pipeline pipe pressure
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Min | Max |
|---|---|
| 0.0 | 10000.0 |
Pipeline Reducer Fitting Size
List of valid sizes for Pipeline Junction Reducer Fittings
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | 1" x 1/2" |
| 2 | 1" x 5/8" |
| 3 | 1" x 3/4" |
| 4 | 1 1/4" x 1/2" |
| 5 | 1 1/4" x 5/8" |
| 6 | 1 1/4" x 3/4" |
| 7 | 1 1/4" x 7/8" |
| 8 | 1 1/4" x 1" |
| 9 | 1 1/2" x 3/4" |
| 10 | 1 1/2" x 1" |
| 11 | 1 1/2" x 1 1/4" |
| 12 | 2" x 1" |
| 13 | 2" x 1 1/4" |
| 14 | 2" x 1 1/2" |
| 15 | 3" x 1 1/2" |
| 16 | 3" x 2" |
| 17 | 4" x 2" |
| 18 | 4" x 3" |
| 19 | 6" x 3" |
| 20 | 6" x 4" |
| 21 | 8" x 4" |
| 22 | 8" x 6" |
| 23 | 10" x 6" |
| 24 | 10" x 8" |
| 25 | 12" x 6" |
| 26 | 12" x 8" |
| 27 | 12" x 10" |
| 28 | 14" x 8" |
| 29 | 14" x 10" |
| 30 | 14" x 12" |
| 31 | 16" x 8" |
| 32 | 16" x 10" |
| 33 | 16" x 12" |
| 34 | 16" x 14" |
| 35 | 18" x 10" |
| 36 | 18" x 12" |
| 37 | 18" x 14" |
| 38 | 18" x 16" |
| 39 | 20" x 10" |
| 40 | 20" x 12" |
| 41 | 20" x 14" |
| 42 | 20" x 16" |
| 43 | 20" x 18" |
| 44 | 24" x 12" |
| 45 | 24" x 14" |
| 46 | 24" x 16" |
| 47 | 24" x 18" |
| 48 | 24" x 20" |
| 49 | 26" x 14" |
| 50 | 26" x 16" |
| 51 | 26" x 18" |
| 52 | 26" x 20" |
| 53 | 26" x 24" |
| 54 | 30" x 16" |
| 55 | 30" x 18" |
| 56 | 30" x 20" |
| 57 | 30" x 24" |
| 58 | 30" x 26" |
| 59 | 36" x 18" |
| 60 | 36" x 20" |
| 61 | 36" x 24" |
| 62 | 36" x 26" |
| 63 | 40" x 20" |
| 64 | 40" x 24" |
| 65 | 40" x 26" |
| 66 | 40" x 30" |
| 67 | 40" x 36" |
| 68 | 48" x 24" |
| 69 | 48" x 26" |
| 70 | 48" x 30" |
| 71 | 48" x 36" |
Pipeline Regulator Casing Material
List of valid types of material which can be used for regulator casing material
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Aluminum |
| 2 | Cast Iron |
| 3 | Ductile Iron |
| 4 | Steel |
Pipeline Regulatory Type
List of Pipeline regulatory types
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Distribution |
| 2 | Gathering |
| 3 | Transmission |
| 4 | Offshore Gathering |
| 5 | Offshore Transmission |
Pipeline Seam Orientation
The list of seam types as clock positions
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.5 | 00:30 |
| 1.0 | 01:00 |
| 1.5 | 01:30 |
| 2.0 | 02:00 |
| 2.5 | 02:30 |
| 3.0 | 03:00 |
| 3.5 | 03:30 |
| 4.0 | 04:00 |
| 4.5 | 04:30 |
| 5.0 | 05:00 |
| 5.5 | 05:30 |
| 6.0 | 06:00 |
| 6.5 | 06:30 |
| 7.0 | 07:00 |
| 7.5 | 07:30 |
| 8.0 | 08:00 |
| 8.5 | 08:30 |
| 9.0 | 09:00 |
| 9.5 | 09:30 |
| 10.0 | 10:00 |
| 10.5 | 10:30 |
| 11.0 | 11:00 |
| 11.5 | 11:30 |
| 12.0 | 12:00 |
Pipeline Seam Type
List of seam types used during the manufacture of the pipe
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
Pipeline Supplier
The valid names of the organizations supplying the natural gas at the town border station
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
Pipeline Valve Diameter
List of valid diameter sizes for valves
| Type | Split Policy | Merge Policy |
|---|---|---|
| Double | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0.0 | Unknown |
| 0.25 | 1/4" |
| 0.375 | 3/8" |
| 0.5 | 1/2" |
| 0.625 | 5/8" |
| 0.75 | 3/4" |
| 1.0 | 1" |
| 1.125 | 1 1/8" |
| 1.25 | 1 1/4" |
| 1.375 | 1 3/8" |
| 1.5 | 1 1/2" |
| 1.875 | 1 7/8" |
| 2.0 | 2" |
| 2.5 | 2 1/2" |
| 3.0 | 3" |
| 4.0 | 4" |
| 5.0 | 5" |
| 5.5 | 5 1/2" |
| 6.0 | 6" |
| 8.0 | 8" |
| 10.0 | 10" |
| 12.0 | 12" |
| 14.0 | 14" |
| 16.0 | 16" |
| 18.0 | 18" |
| 20.0 | 20" |
| 24.0 | 24" |
| 26.0 | 26" |
| 30.0 | 30" |
| 36.0 | 36" |
| 40.0 | 40" |
| 48.0 | 48" |
Pipeline Valve Position
Indicates if the valve is open or closed
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Closed |
| 1 | Open |
Pipeline Valve Type
List of types for pipeline valves
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Ball |
| 2 | Butterfly |
| 4 | Gate |
| 5 | Needle |
| 6 | Pop |
| 7 | Plug |
| 8 | Stop |
| 9 | Stop Cock |
| 10 | V-Ball |
| 11 | Other |
Symbol Rotation
Valid Range of degrees for rotation
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Min | Max |
|---|---|
| 0.0 | 359.0 |
VerticalAlignment
Valid symbol vertical alignment values.
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Top |
| 1 | Center |
| 2 | Baseline |
| 3 | Bottom |
Yes No
Valid Yes, No values
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Yes |
| 2 | No |
Yes No Not Applicable
Valid Yes, No, and NA values
| Type | Split Policy | Merge Policy |
|---|---|---|
| Short | Duplicate | DefaultValue |
| Code | Value |
|---|---|
| 0 | Unknown |
| 1 | Yes |
| 2 | No |
| 3 | N/A |