fields - california public utilities commission · 2015-11-20 · column name objectid enabled...

Column NameOBJECTIDENABLEDSTYPEROUTESEGMENT_NO

SOURCERTESOURCEMPLOCATIONSTANAMEMP1MP2FS1_0LDFS2_0LDJNTEFFGIRTH_WELDLONG_SEAM

JOINT_TYPESMYSGRADEW_THICKODMANUFTEST_JOBTEST_DATETEST_RECTEST_PRESSTEST_MEDIUMTEST_DURCOVERMAOPSMYS_MAOPMOPSMYS_MOPSMYS_ALLOWFDPDPPARAGRAPH_APARAGRAPH_BCOAT_TYPECOAT_DATECONDJOB_NOYR_INSTALLFOOTAGECLASS_ASBUIL TCLASS_PRESENTNO_DWELLUPGRADEJOBMAINTORGADDCOMMENTMCFDNO_CUSTCPAQASTATUSFAC_TYPEDATE_CREATEDSHAPEROUTE_IDTRANS_DEF

ROUTE_JOINIMA_NAMEHCA_ID

Alias NameOBJECTIDEnabledsTypeROUTESEGMENT_NO

SOURCERTESOURCEMPLOCATIONSTANAMEMP1MP2FS1_0LDFS2_0LDJntEffGirth_WeldLong_Seam

JoinCTypeSMYSGradeW_THICKODMANUF

ITEST_JOBTEST_DATEITEST_RECTEST_PRESSTesCMediumTEST_DURCOVERMAOPSMYS_MAOPMOPSMYS_MOPSMYS_ALLOWFDPDPPARAGRAPH_APARAGRAPH_BCoaCTypeCOAT_DATECond

IJOB_NOYR_INSTALLFOOTAGEClass_AsBuiltClass_PresentNO_DWELLUPGRADEJOBMaintOrgADDCOMMENTMCFDNO_CUSTCPAQAStatusFac_TypeDATE_CREATEDShapeROUTE_IDTRANS_DEF

ROUTE_JOINIMA_NAMEHCA_ID

Fields

DescriptionUnique identifierNot UsedType of pipe segment: 1201 - Active_Pipe, 1202 - Inactive Pipe, 1207 - Foreign Pipe, 1208 - CasingUne number w/sub-route designated, e.g. 300A, or 300A-1Segment number of route = A unique, sequential number greater than 100. Add an X fordeactivated pipe, C for Casing and R for Removed Pipe.For branch lines, the source route of the branchFor branch lines, the milepoint of the source routeDFM pipe only. The common line description.name of station associated with pipelinebeginning milepoint of segmentending milepoint of segmentField station at beginning of segmentField station at ending of segment.Joint efficiency.Girth weld type: Arc, Gas, or FlashLong seam type: FBW - furnace butt weld, CW - continuous weld, DSAW - double submergedarc weld, ERW - elec. Res. Weld, SSAW - single submerged arc weld, LAP - lap weld, SMLS -seamless, AOS - A.O. Smith, FBW - furnace butt weld

Joint type: BUn - butt weld, BBCR - bell bell chill ring, BLSP - bell and spigot, SW - socket weldSpecified Minimum Yield StrengthPipe gradeWall thicknessOutside diameterManufacturePressure test job numberPressure test dateHydro test record numberPressure test pressurePressure test medium: W - water, G - natural gas, N - nitrogen, A - air, L - leak test.Pressure test duration in decimal hoursDepth of coverMaximum allowable operating pressure of segmentPercent SMYS @ MAOPMaximum allowable operating pressure of systemPercent SMYS @ MOPSMYS allowed per class pres.Future Design pressureDesign pressureWelding pressure per Paragraph AWelding pressure per Paragraph BCoating type: Refer to "Coating Type" tabCoating dateCondition of pipe: E - excellent, G - good, F - fair, P - poor.Job number that installed the pipe.Year or date of installationChain length footage of segmentClass location of the pipe when it was installed.The current class location of the pipe.The historic number of dwellings - field not maintained.job number of pipe for uprate/deactivation/removal.Maintenance Organizationmapping commentsmillion cubic feet per daynumber of customersCathodic protection areaCode indicating pipeline alignment accuracy and pipeline alignment source data. Refer to QA Values tab.Status of pipeline: 0 - Deactivated, 1 - Active, 2 - removed, 4 - proposedFacility type: see Facility Type tabDate of first entry into databaseGIS geometry of the pipeline segment (stores vertex and endpoint coordinates)route identifierTransmission Definition per 49 CFR 192.3: T = Transmission, TC = Transmission large volumecustomer, TI = conservatively considered Transmission but more information on the pipe mayprove it otherwise, D = distribution, blank = not transmission

database identifierIntegrity Management Area nameHCA status code of segment: begins with A, B or I means it is HCA pipe.

SanBrunoGT-LineRuptureInvestigation_DR_IRP_010-Q06Atch01

Page 1

PG&E's Pipeline Attributes

Column NameBAR_IDASMT_PLANLST_ASMTPLM_DESCPLAT_NONO_VENTSEDIT_VERSIONEDIT_DATEIMP_ZONEHCA_RISKEC_THREATTP3HREATSCC_THREATMANU_THREATCONST 3HREATOF_THREATHS_THREATIC_THREATFUT_ASMTLEAK_SRVGPGASMAPIDWP_IDSHAPE.len

Alias NameBAR_IDASMT_PLANLST_ASMTPLM_DESCPLAT_NONo_VentsEDIT_VERSIONEDIT_DATEIMP_ZONEHCA_RISKEC_THREATTP_THREATSCC_THREATMANU_THREATCONST_THREATOF_THREATHS_THREATIC_THREATFUT_ASMTLeakSurveyGroupGASMAPIDWP_IDSHAPE.len

Fields

Descriptionidentifier for PLM systemStores year and method of targeted completion for external corrosion integrity assessmentsYear of last assessmentDescription from PLM systemGas Distribution Plat numberNumber of ventsEdit version nameEdit version DatePotential Impact RadiusRisk for HCAExternal Corrosion threatThird Party threatStress Corrosion Cracking threatManufacture threatConstruction threatOutside forces threatHard Spot threatInternal Corrosion threatNot usedLeak survey group numberUnique identifierNot Usedlength of segment in feet calculated on the planimetric basis (i.e. does not consider verticle component).

SanBrunoGT-LineRuptureInvestigation_DR_IRP_010-Q06Atch01

Page 2

PG&E's Pipeline Attributes

QA - Quality AssuranceThe QA attribute on the pipe data is an indicator of the accuracy of the data.The first digit is the spatial digit. This digit indicates the accuracy of the data in relation to the true locati<The second digit is the source digit. This digit makes known the source of the data.The first and second digits are used in combination to describe the data quality.Examples:Aerial Photos - 21Traditional Surveys - 22As- Builts - 24Plat - 35PLSS - 56GPS - 23Resource GPS - 43A QA may also be chosen from the following lists if the above QA numbers do not fit. If youhave questions on assigning QA numbers, please ask one ofthe GIS Team.

Spatial SourceDigit Definition Digit Definition

1 eM 1 Aerial Photos2 Submeter 2 Traditional Surveys3 2-5 Meter 3 Resource GPS4 10 Meter 4 As Built5 30 Meter 5 Plats6 100 Meter 6 PLSS/ Wallmap7 1KM 7 7.5' USGS Quad8 5KM 8 lOOK USGS Quad9 Unknown/Best Fit 9 Unknown

SanBrunoGT-LineRuptureInvestigation_DR_IRP_010-Q06Atch01

Page 3

PG&E's Pipeline Attributes

PipeSpec Coating Types

Text valueUNKWAXBARECOAL TARCONCFBEHAAMECHPAINTPCPCJPLSOMASTLTAPEXTRUPLDEV-GRIP 238BAR-RUST 235DEV-TAR 247Protal7200Other

DomainCode Description100 Unknown551 Wax552 Bare Pipe553 Coal Tar554 Concrete555 Fusion Bonded Epoxy557 Hot Applied Asphalt558559 Paint560561 Powercrete J562565 Somastic566567 Use for OW, double wrapped, single wrapped, polyken, etc568 Extruded Plastic570 DEVGRIP 238 Abrasion Resistant Epoxy Coating569 Bar Rust 235 Multi-Purpose Epoxy coating571 DEVT AR 247 High Build Epoxy Mastic572 Denso Protal 7200574 Other coating type - there are two entries both of which are Stac Wrap

SanBrunoGT-LineRuptureInvestigation_DR_IRP_010-Q06Atch01

Page 4

PG&E's Pipeline Attributes

Internal Code502 UGS503 DFM504 BB505 BD506 SERV507 FORGN508 LT509 DSBN510 SP511 GG512 GG-LT513 GG-A514 GG-B515 GG-U

Facility Type

descriptionUnderground StorageDistribution Feeder MainBackbone TransmissionBlow DownServiceForeign pipe (Non-PG&E ownership)Local TransmissionDistribution pipe under 60 poundsStandard Pacific Gas Line Inc. Oointownership)Gas Gathering deactivated prior to new Gas Gathering regulationsFormerly Gas Gathering that is now classed as Local Transmission per Federal Code change·Gas Gathering Type A regulationGas Gathering Type B regulationGas Gathering unregulated

QUERYFAC_TYPE = 502FAC_TYPE = 503FAC_TYPE = 504FAC_TYPE = 505FAC_TYPE = 506FAC_TYPE = 507FAC_TYPE = 508FAC_TYPE = 509FAC_TYPE = 510FAC_TYPE = 511FAC_TYPE=512FAC_TYPE = 513FAC_TYPE = 514FAC_TYPE=515

SanBrunoGT-LineRuptureInvestigation_DR_IRP_010-Q06Atch01

Page 5

PG&E's Pipeline Attributes