Transcription
GIS Data DictionaryPTTEPI Zawtika AssetRevisionRev 0IssueFinal revisionPrepared byTanat C.Reviewed byPimporn Ch.Approved byChackrit L.Issue DATE8 Dec 2016
Table of ContentsIntroduction . 1List of Tables. 2Data dictionary . 3ANODE . 3BOND LEAD . 4BUOYANCY CONTROL . 5CALIBRATION POINT . 6CASING . 7CONCRETE SLAB . 8CP READING . 9CUSTOMER . 10DESIGN SPECIFICATION . 11DISPUTE AREA . 12ELBOW . 13EXTERNAL COATING . 14JURISDICTION . 15LAND USE . 16LAUNCHER RECEIVER . 17LINE CROSSING . 18LOCATION CLASS . 19OWNER RANGE . 20PATROLLING . 21PIPE BEND . 22PIPE SEGMENT. 23PIPELINE ROUTE . 24RECTIFIER . 25RECTIFIER READING . 26RIGHT OF WAY BOUNDARY . 27RISK SCORE . 28STATION AREA . 29STATION POINT. 30TEE . 31i
TEST LEAD . 32TRENCH BREAKER . 33VALVE . 34WARNING TAPE . 35ER Diagram . 36References . 36Appendix A . 37ii
IntroductionThis document describes the tables and fields used to store the data of Zawtika pipeline. This datamodel has been simplified from well‐known PODS (Pipeline Open Data Standard) data model byusing a concept of linear referencing of ESRI technology. The pipeline route shall be edited byArcGIS desktop and the event data shall be upDated by the web‐based Geocortex workflowdeveloped by PTT.DMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedPage 1
List of Tables1234ANODEBOND LEADBUOYANCY CONTROLCALIBRATION CONCRETE SLABCP READINGCUSTOMERDESIGN 11213141516DISPUTE AREAELBOWEXTERNAL COATINGJURISDICTIONLAND USELAUNCHER RECEIVERLINE oint1718192021222324252627282930313233LOCATION CLASSOWNER RANGEPATROLLINGPIPE BENDPIPE SEGMENTPIPELINE ROUTERECTIFIERRECTIFIER READINGRIGHT OF WAY BOUNDARYRISK SCORESTATION AREASTATION POINTTEETEST LEADTRENCH BREAKERVALVEWARNING TAPENo.Feature inePointPolylineDescriptionAnodeBond leadBuoyancy control of pipelinesThe point to control stationing(KP) of pipelineCasingConcrete slabReadings of test leadCustomerDesign pressure, MAOP, DesigntemperatureDispute areaElbowExternal coatingJurisdictionLand useLauncher and receiverLine crossing such as road,waterway, railroad, facility etc.Location classRanges of each ownerPatrolling recordsPipe bendSegment of line pipePipeline centerlineRectifierReadings of rectifiersBoundary of pipeline right of wayRisk score of pipelinesA boundary of stationsA location of stationsTeeTest leadTrench breakerValveWarning tapeDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedPage 2
Data dictionaryANODEConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not nullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONKPNUMERIC (38,8)NullTYPEType of stationNVARCHAR (16)NullANODE MASSMass of anodeNUMERIC (4,1)NullMODELModel of anodeNVARCHAR (32)NullDESCRIPTIONDescriptionNVARCHAR (50)NullDEPTH OF COVERDepth of cover of anodeNUMERIC (6,4)NullBACK FILL MATERIALBack fill materialNVARCHAR (16)NullANODE DIAMETERDiameter of anodeNUMERIC (5,1)NullANODE LENGTHLength of anodeNUMERIC (5,1)NullMANUFACTURERManufacturerNVARCHAR (16)NullMATERIALMaterial of pipelineNVARCHAR (16)NullPACKAGE FILLPackage fillNVARCHAR (16)NullPACKAGE DIAMETERPackage diameterNUMERIC (8,4)NullPACKAGE LENGTHPackage lengthNUMERIC (4)NullDATE INSTALLEDDATE installedDATE (7)NullGALVANIC FLGalvanic or not?NVARCHAR (5)NullTAGTag of anodeNVARCHAR (16)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 3
BOND LEADConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONKPNUMERIC (38,8)NullTYPEType of stationNVARCHAR (16)NullSTATUSStatus of bond leadNVARCHAR (16)NullDESCRIPTIONDescriptionNVARCHAR (50)NullTAGTag of bond leadNVARCHAR (32)NullMATERIALMaterial of pipelineNVARCHAR (16)NullDATE INSTALLEDDATE installedDATE (7)NullREF TEST LEAD TAGReference to Test leadNVARCHAR (38)NullMAX RESISTANCEMaximum resistanceNUMERIC (5,2)NullBONDED COMPANYBonded companyNVARCHAR (50)NullRESISTOR TYPEResistor typeNVARCHAR (16)NullRESISTOR POWER RATINGResistor power ratingNUMERIC (5,2)NullGAUGE SIZEGauge sizeNVARCHAR (16)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 4
BUOYANCY CONTROLConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullTYPEType of buoyancy controlNVARCHAR (20)NullQUANTITYQuantity of buoyancy controlNUMERIC (5)NullWEIGHT EACH KGWeight of each buoyancy controlNUMERIC (7,2)NullSPACING DISTANCESpacing distance between each buoyancycontrolNUMERIC (6,2)NullDATE INSTALLEDDATE installedDATE (7)NullDESCRIPTIONDescriptionNVARCHAR (250)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 5
CALIBRATION POINTConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONStationNUMERIC (38,8)NullDESCRIPTIONDescriptionNVARCHAR (250)NullCREATED BYData created byNVARCHAR (25)NullCREATE DATEDATE that data createdDATE (7)NullMODIFIED BYData modify byNVARCHAR (25)NullMODIFY DATEDATE that data modifiedDATE (7)NullNOTESRemarksNVARCHAR (50)NullSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNullPage 6
CASINGConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullCROSSING TYPEType of crossingNVARCHAR (20)NullINSULATOR TYPEType of insulatorNVARCHAR (20)NullSEAL TYPEType of sealNVARCHAR (20)NullVENTED INDICATORThere is a vent?NVARCHAR (3)NullQUANTITY OF VENTSQuantity of ventsNUMERIC (5)NullMANUFACTURERManufacturerNVARCHAR (20)NullDATE MANUFACTUREDDATE manufacturedDATE (7)NullPIPE MILL LOCATIONLocation of pipe millNVARCHAR (20)NullMATERIALMaterial of pipelineNVARCHAR (20)NullPIPE SPECIFICATIONPipe specificationNVARCHAR (20)NullSYMSSMYS of casing pipeNUMERIC (38,8)NullPIPE GRADEPipe gradeNVARCHAR (20)NullOUTSIDE DIAMETEROutside diameterNVARCHAR (20)NullNOMINAL WALL THICKNESSNominal wall thicknessNUMERIC (38,8)NullLENGTHLength of casingNUMERIC (38,8)NullDATE INSTALLEDDATE installedDATE (7)NullDESCRIPTIONDescriptionNVARCHAR (250)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 7
CONCRETE SLABConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullNAMENameNVARCHAR (50)NullWEIGHTWeight of slabNVARCHAR (20)NullTHICKNESSThickness of slabNVARCHAR (20)NullDATE INSTALLEDDATE installedDATE (7)NullDESCRIPTIONDescriptionNVARCHAR (250)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 8
CP READINGConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONKPNUMERIC (38,8)NullTYPEType of stationNVARCHAR (16)NullDESCRIPTIONDescriptionNVARCHAR (50)NullINSPECTION DATEDated inspectedDATE (7)NullPS ONPipe to soil on potential (mV)NUMERIC (10,3)NullPS OFFPipe to soil off potential (mV)NUMERIC (10,3)NullREF TEST LEAD TAGTest lead inspectedNVARCHAR (16)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 9
CUSTOMERConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullCUSTOMER IDID of customersNVARCHAR (20)NullCOMPANY NAMECompany nameNVARCHAR (100)NullFACTORY NAMEFactory nameNVARCHAR (50)NullREF METER STATIONReference to metering stationNVARCHAR (20)NullSTATUSStatus of customerNVARCHAR (20)NullTYPEType of customerNVARCHAR (20)NullFACTORY ADDRESSFactory addressNVARCHAR (250)NullFACTORY ZIPFactory zip codeNVARCHAR (5)NullFACTORY TELFactory telephoneNVARCHAR (20)NullCOMPANY TELCompany telephoneNVARCHAR (20)NullCOMPANY FAXCompany facsimileNVARCHAR (20)NullDESCRIPTIONDescriptionNVARCHAR (250)NullEEastingNUMERIC (38,8)NullNNorthingNUMERIC (38,8)NullSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 10
DESIGN SPECIFICATIONConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullDESIGN PRESSUREDesign pressure of pipelinesNUMERIC (15,3)NullDESIGN MAOPDesign MAOP of pipelinesNUMERIC (15,3)NullDESIGN LIFEDesign life of pipelinesNUMERIC (3)NullREMARKSRemarksNVARCHAR (100)NullANSI RATINGANSI Rating of pipelinesNVARCHAR (10)NullHYDROTEST PRESSUREHydrotest pressure of pipelinesNUMERIC (15,3)NullDESIGN TEMPDesign temperature of pipelinesNUMERIC (10,3)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 11
DISPUTE AREAConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONKPNUMERIC (38,8)NullOWNER NAMEOwner nameNVARCHAR (75)NullDRAWING NODrawing numberNVARCHAR (20)NullOWNERSHIP CERTIFICATE Ownership certificateNVARCHAR (20)NullAREA ACREArea of land parcelNUMERIC (15,3)NullDOC LINKLink to documentsNVARCHAR (250)NullSERIAL NOSerial number of land parcelNUMERIC (5)NullSHAPE.AREAArea of shapeNUMERIC (0,0)NullSHAPE.LENLength of shape (perimeter)NUMERIC (0,0)NullSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 12
ELBOWConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullMODELModel of elbowNVARCHAR (50)NullSTATIONKPNUMERIC (38,8)NullDESCRIPTIONDescriptionNVARCHAR (50)NullOD INLETOutside diameter of inletNVARCHAR (20)NullOD OUTLETOutside diameter of outletNVARCHAR (20)NullNOMINAL WALL THICKNESSNominal wall thicknessNVARCHAR (20)NullANGLEAngle of elbowNUMERIC (5)NullRADIUSRadius of elbowNVARCHAR (20)NullMANUFACTURERManufacturerNVARCHAR (50)NullDATE MANUFACTUREDDATE manufacturedDATE (7)NullMATERIALMaterial of pipelineNVARCHAR (20)NullSPECIFICATIONSpecificationNVARCHAR (20)NullNOMINAL PRESSURE RATING Nominal pressure ratingNVARCHAR (20)NullMILL TEST PRESSURENVARCHAR (20)NullNUMERIC (5)NullMill test pressureTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 13
EXTERNAL COATINGConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullTYPEType of coatingNVARCHAR (20)NullSUBTYPESubtype of coatingNVARCHAR (20)NullCOATING MATERIALMaterial of coatingNVARCHAR (20)NullCOATING MANUFACTURERManufacturerNVARCHAR (20)NullPRODUCT NAMEProduct nameNVARCHAR (20)NullAPPLICATORApplicatorNVARCHAR (20)NullWHERE APPLIEDWhere applied (Mill or Field)NVARCHAR (20)NullDATE APPLIEDDATE appliedDATE (7)NullCOATING THICKNESSThickness of coatingNUMERIC (38,8)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullDESCRIPTIONDescriptionNVARCHAR (250)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 14
JURISDICTIONConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullNAMEName of jurisdictionNVARCHAR (50)NullDESCRIPTIONDescriptionNVARCHAR (50)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 15
LAND USEConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullTYPEType of land useNVARCHAR (20)NullSTATION LENGTHLength of land useNUMERIC (38,8)NullDESCRIPTIONDescriptionNVARCHAR (50)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 16
LAUNCHER RECEIVERConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONKPNUMERIC (38,8)NullEQUIPEMENT TAGTag of Launcher/ReceiverNVARCHAR (20)NullTYPELauncher or ReceiverNVARCHAR (20)NullDATE INSTALLEDDated installedDATE (7)NullPRESSURE RATINGPressure ratingNUMERIC (5)NullSTATUSStatus of Launcher/ReceiverNVARCHAR (20)NullMAJOR BARREL LENGTHLength of major barrelNUMERIC (20,3)NullMINOR BARREL LENGTHLength of minor barrelNUMERIC (20,3)NullDESCRIPTIONDescriptionNVARCHAR (50)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 17
LINE CROSSINGConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONKPNUMERIC (38,8)NullTYPEType of line crossing (Road,Railroad, Waterway, Facility)NVARCHAR (20)NullOWNEROwner of crossingNVARCHAR (50)NullLINE CLEARANCELine clearanceNUMERIC (5)NullMATERIALMaterialNVARCHAR (20)NullFOREIGN DIAMETERDiameter (in case of crossing withNVARCHAR (20)other pipe)NullCROSSING DATECrossing DATEDATE (7)NullINTERSECTION ANGLEIntersection angleNUMERIC (5)NullDIRECTIONDirection of crossingNVARCHAR (50)NullWIDTHWidth of crossingNUMERIC (38,8)NullLINE BELOW GROUNDPipeline below ground?NVARCHAR (3)NullCROSSING BELOW GROUNDCrossing below ground?NVARCHAR (3)NullCROSSING BELOW LINECrossing below pipelineNVARCHAR (3)NullFOREIGN BONDForeign bond available?NVARCHAR (3)NullDESCRIPTIONDescriptionNVARCHAR (250)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 18
LOCATION CLASSConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullCLASSLocation class (1,2,3 or 4)NUMERIC (5)NullDESIGNDesign or RevisedNVARCHAR (20)NullMETHODMethod used (Visual, Survey)NVARCHAR (20)NullDETERMINATION DATEDATE determinedDATE (7)NullNUMBER OF BUILDINGSNumber of buildingsNUMERIC (10)NullDESCRIPTIONDescriptionNVARCHAR (250)NullREMARKSRemarksNVARCHAR (100)NullCURRENT FLAGCurrent result of this pipeline?NVARCHAR (3)NullTYPEType of location classNVARCHAR (20)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 19
OWNER RANGEConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullOWNER NAMEOwner nameNVARCHAR (50)NullPERCENT INTERESTPercent of interestNUMERIC (38,8)NullDESCRIPTIONDescriptionNVARCHAR (250)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 20
PATROLLINGConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONKPNUMERIC (38,8)NullPROBLEM NAMEName of problemNVARCHAR (50)NullPROBLEM DETAILDetail of problemNVARCHAR (200)NullPROBLEM STATUSStatus of problemNVARCHAR (20)NullRECORDED BYRecorded byNVARCHAR (50)NullDATE RECORDEDDate recordedDATE (7)NullREMARKSRemarksNVARCHAR (250)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNullPage 21
PIPE BENDConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONKPNUMERIC (38,8)NullTYPEType of bendNVARCHAR (16)NullBEND RADIUSRadius of bendNUMERIC (3,1)NullANGLEAngle of bendNUMERIC (6,3)NullFABRICATORFabricatorNVARCHAR (20)NullDATE INSTALLEDDATE installedDATE (7)NullDESCRIPTIONDescriptionNVARCHAR (50)NullCOMMENTSCommentsNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 22
PIPE SEGMENTConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullMANUFACTURERManufacturerNVARCHAR (20)NullDATE MANUFACTUREDDATE manufacturedDATE (7)NullPIPE MILL LOCATIONPipe mill locationNVARCHAR (20)NullMILL TEST PRESSUREMill test pressureNUMERIC (5)NullMATERIALMaterial of pipelineNVARCHAR (20)NullPIPE SPECIFICATIONPipe specificationNVARCHAR (20)NullPIPE GRADEPipe gradeNVARCHAR (20)NullSYMSSMYSNUMERIC (5)NullOUTSIDE DIAMETEROutside diameter (inches)NVARCHAR (20)NullNOMINAL WALL THICKNESSNominal wall thickness (inches)NVARCHAR (20)NullPIPE LONG SEAMType of seam weldNVARCHAR (20)NullDATE INSTALLEDDATE installedDATE (7)NullDESCRIPTIONDescriptionNVARCHAR (250)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 23
PIPELINE ROUTEConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE NAMEPipeline nameNVARCHAR (100)NullPIPELINE CODEPipeline codeNVARCHAR (20)NullPIPELINE TYPEType of pipelineNVARCHAR (20)NullMATERIALMaterial of pipelineNVARCHAR (20)NullSTATUSStatus of pipelineNVARCHAR (20)NullDRAWING LENGTHPipeline length in drawingNUMERIC (38,8)NullPROJECT NOProject numberNVARCHAR (50)NullPROJECT NAMEProject nameNVARCHAR (100)NullDESCRIPTIONDescriptionNVARCHAR (250)NullREMARKSRemarksNVARCHAR (50)NullCREATED BYData created byNVARCHAR (20)NullCREATED DATEDATE the data createdDATE (7)NullMODIFIED BYData modify byNVARCHAR (20)NullMODIFIED DATEDATE that data modifiedDATE (7)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNullPage 24
RECTIFIERConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONKPNUMERIC (38,8)NullRECTIFIER IDTag of rectifierNVARCHAR (16)NullAMP RATINGAmp ratingNVARCHAR (16)NullTYPEType of rectifierNVARCHAR (16)NullMANUFACTURERManufacturerNVARCHAR (16)NullDESCRIPTIONDescriptionNVARCHAR (50)NullVOLT RATINGVoltage ratingNVARCHAR (16)NullMODEL NUMBERModel numberNVARCHAR (32)NullSHUNT TYPEShunt typeNVARCHAR (16)NullLIGHTNING ARRESTOR TYPEType of lightning arrestorNVARCHAR (16)NullCOOLING SYSTEMType of cooling systemNVARCHAR (16)NullDATE INSTALLEDDATE installedDATE (7)NullDIODE NUMBERDiode numberNVARCHAR (16)NullSTACK SERIAL NUMBERStack serial numberNVARCHAR (16)NullSTACK FUSE SERIAL NUMBERStack fuse serial numberNVARCHAR (16)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 25
RECTIFIER READINGConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONKPNUMERIC (38,8)NullREF RECTIFIER TAGReference to rectifier inspectedNVARCHAR (20)NullWORK ORDERWork orderNVARCHAR (20)NullDATE INSPECTEDDated inspectedDATE (7)NullINSPECTORInspectorNVARCHAR (25)NullDC V FOUNDDC voltage as foundNUMERIC (10,3)NullDC A FOUNDDC current as foundNUMERIC (10,3)DC V LEFTDC voltage as leftNUMERIC (10,3)DC A LEFTDC current as leftNUMERIC (10,3)P2S FOUNDPipe to soil potential as foundNUMERIC (10,3)P2S LEFTPipe to soil potential as leftNUMERIC (10,3)KWHRKilowatt‐hourNUMERIC (10,3)DEHUMIDIFIERCondition of dehumidifierNVARCHAR (10)ADJUSTEDRectifier adjusted?NVARCHAR (10)P2S OFFPipe to soil off potentialNUMERIC (10,3)DESCRIPTIONDescriptionNVARCHAR (100)REMARKSRemarksNVARCHAR ullNullNUMERIC (5)OFFSETOffset distance from pipelinecenterlineNUMERIC (10,3)NullUP TO DATELatest inspection?NVARCHAR (5)NullSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 26
RIGHT OF WAY BOUNDARYConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullNAMEName of right of wayNVARCHAR (50)NullREMARKSRemarksNVARCHAR (100)NullSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNullPage 27
RISK SCOREConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTART STATIONBegin KPNUMERIC (38,8)NullEND STATIONEnd KPNUMERIC (38,8)NullSTATION LENGTHLength of sectionNUMERIC (38,8)NullRISK SCORERisk of failureNUMERIC (10,5)NullPOFProbability of failureNUMERIC (10,5)NullCOFConsequence of failureNUMERIC (10,5)NullNUMERIC (10,5)NullNUMERIC (10,5)NullNUMERIC (10,5)NullNUMERIC (10,5)NullNUMERIC (10,5)NullNUMERIC (10,5)NullNVARCHAR (100)NullNUMERIC (5)NullTPIECICLGSINOPSCCREMARKSProbability of failure from third partyinterferenceProbability of failure from externalcorrosionProbability of failure from internalcorrosionProbability of failure from loss ofground supportProbability of failure from incorrectoperationProbability of failure from StressCorrosion 6‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNot nullPage 28
STATION AREAConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullSTATION NAMEStation nameNVARCHAR (50)NullSTATION NAME ABAbbreviated station nameNVARCHAR (10)NullTYPEType of stationNVARCHAR (20)NullSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNullPage 29
STATION POINTConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullSTATION NAMEStation nameNVARCHAR (50)NullSTATION NAME ABAbbreviated station nameNVARCHAR (10)NullTYPEType of stationNVARCHAR (20)NullSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all rights reservedNullPage 30
TEEConstrainPKField NameDescriptionTypeJoin toNullOBJECTIDObject IDNUMERIC (*)Not NullPIPELINE CODEPipeline codeNVARCHAR (20)NullSTATIONKPNUMERIC (38,8)NullTYPEType of teeNVARCHAR (20)NullMANUFACTURERManufacturerNVARCHAR (20)NullOUTSIDE DIAMETER INLETOutside diameter of inletNVARCHAR (20)NullOUTSIDE DIAMETER OUTLETOutside diameter of outletNVARCHAR (20)NullOUTSIDE DIAMETER BRANCHOutside diameter of branchNVARCHAR (20)NullNOMINAL WALL THICKNESSNominal wall thicknessNVARCHAR (20)NullSPECIFICATIONSpecificationNVARCHAR (50)NullNOMINAL PRESSURE RATINGNominal pressure ratingNVARCHAR (20)NullMILL TEST PRESSUREMill test pressureNVARCHAR (20)NullMATERIALMaterialNVARCHAR (20)NullDATE MANUFACTUREDDated manufacturedDATE (7)NullDATE INSTALLEDDATE installedDATE (7)NullDESCRIPTIONDescriptionNVARCHAR (250)NullREMARKSRemarksNVARCHAR (100)NullNUMERIC (5)NullTBOIDSHAPEGeometryDMS‐C‐R‐2016‐002 REV 0Copyright PTT Public Company Limited – all
DESIGN_SPECIFICATION Constrain Field Name Description Type Join to Null PK OBJECTID Object ID NUMERIC (*) Not Null PIPELINE_CODE Pipeline code NVARCHAR (20) Null START_STATION Begin KP NUMERIC (38,8) Null END_STATION End KP NUMERIC (38,8) Null DESIGN_PRESSURE Design pressure of pipelines NUMERIC (15,3) Null
