Pipeline System Metadata Overview
Pipeline System Metadata Overview
OBJECTID
[Object]
OBJECTID
[Object]
RefMode <d>
JM
Instrument / Readings
MeterReading
OwnerOperator CenterlinePolylineEvent CLControl <d>
Product CLStationEditResponse <d> OfflinePoint OfflineNonPointFacility OfflinePointFacility StationSeriesAudit
RouteEventID (fk)
CLXYEditResponse <d> SymbolRotation SiteEventID (fk) SiteEventID (fk) StationSeriesEventID (fk)
BeginSeriesEventID
EndSeriesEventID
CLZEditResponse <d> Point_X Point_X SubSystemRange Site SiteBoundary SitePoint
SymbolRotation Point_Y CPCable Point_Y
CLEditResponse <d> SubSystemEventID (fk) SiteName SiteEventID (fk) SiteEventID (fk)
PIGStructure
AuditObject ActivityExtension CLValidityTolerance <d> Point_Z SiteBoundary
Point_Z CPAnode SiteType <d>
ControlPoint CPBond
SymbolRotation NonFacilityObject
<classname>EventID (fk) ActivityEventID (fk) DocumentPoint
CPGroundBed APDM Core OnlinePointFacility APDMObject NonFacilityObject
CPRectifier
ActivityEventID (fk) SubSystemRange FieldNote CPTestStation
StationSeries RemovedPoint
ActivityDate Site Marker StationSeries SubSystem OnlineFacility InstrumentParameter
Structure SitePoint 1 *
OfflineFacility
<fc>Audit
ExternalDocument
Contact
Instrument InstrumentParameter MeterReading CISReading
<Any APDM
Activity OnlineFacility
parent class> Product OwnerOperator GeoMetaData Manufacturer <d> InstrumentEventID (fk) ReadingDate ReadingDate
InServiceDate ExternalDocument Model <d> ParameterType <d> ReadingUnits Company ReadingUnits
Site Product <d> CompanyEventID (FK) DateCollected
InstallationDate SiteAudit SerialNumber ParameterValue ReadingValue ReadingValue
OwnerPercentage <d> OriginalX FieldNote Contact
OperationalStatus <d> DateManufactured CompanyEventID (fk) DistanceFromPreviousReading
OwnerType <d> OriginalY SiteEventID (fk)
Object OnlinePolyline OnlinePoint SiteEventID (fk) InstrumentName ContactEventID (fk) CompanyEventID (fk)
Metadata OBJECTID BeginMeasure Measure
LineLoop
OriginalZ
PositionSource <d>
Valve
ContactEventID (fk)
EndMeasure StationSeries
SeriesEventID ProjectionID ControlPoint
Flow Reading
Company ExternalDocumentEventID
BeginSeriesEventID Station OnlinePolylineFacility OnlinePointFacility Pressure Reading MeterReadingAudit
BeginStation Status <d> MeterEventID (fk) CISReadingAudit
HCAClass <OnlineFeatureClass> BeginMeasure Measure APDM Core
EndSeriesEventID SymbolRotation CISReadingEventID (fk)
DOTClass EndMeasure SeriesEventID
CouldAffectSegment EndStation Poiint_X
BeginSeriesEventID Station
InspectionRange Status <d> Anomaly Point_Y
OperatingPressure AnomalyPoint BeginStation Point_X
ReferenceMode ClassMetaData OnlineLocationClass PressureTest ElevationPoint
Point_Z
EndSeriesEventID Point_Y
RightOfWay Leak
RefMode <d> ClassType <d> OriginClassEventID (fk) OnlineFieldNote
EndStation Point_Z Appurtenance
RiskAnalysis
RefModeMeasureRootName ClassEventID (pk) OnlineLocationClassEventID (fk) SymbolRotation Instrument
RefModeBasis <d>
RedModeType <d>
RefModeUnits <d>
IsPRM <d>
ClassName
RequiresGeometry
OnlineLocationMechanism <d> OnlinePolylineForOfflineFeature
BeginOffsetAngle
BeginOffsetDistance
OnlinePointForOfflineFeature
OffsetAngle
OffsetDistance
Casing
Coating
StationSeries
Fitting
PipeJoinMethod
Tap
Valve
Vessel
Integrity OnlinePolyline
Catalog View
ParentRefMode (fk) EndOffsetAngle StationLocated <d> PipeSegment DateManufactured
EndOffsetDistance Sleeve GeoDatabase
RefModeRootName Grade <d>
CPOnlineLocation StationLocated <d> InletConnectionType <d>
Closure
CPOnlineLocation InletDiameter <d>
RemovedPoint LineCrossingLocation
Elbow
InletWallThickness <d> DOTClassSegment DOTClass HCASegment HCARange RiskAnalysis CouldAffectSegment Transmission (FeatureDataset)
Meter
StructureLocation AlignmentSheet
LineCrossingEasement <OfflineFeatureClass> Reducer Manufacturer <d> ActivityEventID (fk) ActivityEventID(fk) ActivityEventID (fk) ActivityEventID (fk) ConsequenceEconomic Activity (Core)
StationSeries RemovedLine Tee Anomaly
Material <d> ClusterBufferEventID (fk) CalculatedLength OfflineFeature BIHOStructureCount AssessmentDate ConsequenceEnvironmental ActivityHierarchy (Core)
APDM Core PressureRating <d> BIHOStructureCount ClassType <d> CalculatedLength RangeName ConsequenceLife AnomalyCluster
Address
ClassLength ClassSource <d> DateCalculated RiskRanking ConsequenceProperty Appurtenance AnomalyAudit
ClassSource ClusterBufferEventID (fk) HCARangeEventID (fk) ConsequenceThroughput Casing
AnomalyClusterAudit
ClusteredClassType <d> CorridorWidth MAOP HCARAngeEventID (fk)
ClusterBuffer
ClusterDowngrade <d> CorridorTolerance OutsideDiameter POFConstruction ClassMetaData (MetaData)
CorridorWidth DateCalculated PIRFactor POFIncorrectOperations Closure
AppurtenanceAudit
CorridorTolerance IDSiteBufferRadius PIR POFInternalCorrosion
Event Support
Coating
CasingAudit
DateCalculated StructureOrIDSiteEventID (fk) ClusterBuffer DOTClassCorridor HCACorridor PIRT POFEquipmentFailure ControlPoint (Core)
DOTClassEventID (fk) Provenance <d> POFExternalCorrosion CISReading
ActivityEventID (fk) ActivityEventID (fk) ActivityEventID (fk) CPAnode
IdentifiedSite <d> SturctureOrSiteEventID (fk) POFManufacturingCorrosion ClosureAudit
BufferRadius CorridorRadius PIRFactor CPBond
IDSiteBufferRadius POFMaterials
BufferTolerance CorridorTolerance PIR CoatingAudit
Provenance <d> Method 1 POFOutsideForce CPCable
DOTCorridorType <d> PIRT Company
APDMObject All M-N relationships with the Contact NonFacilityObject APDMObject OfflinePoint OfflineFeature MultiUnitResidential <d> Method 2 POFSCC CPGroundBed
Object Class are Attributed with the SturctureOrSiteEventID (fk) POFThirdParty CPLocation
Contact
ContactType <d> field. UnClusteredClassType <d> POFWeather CPRectifier ControlPointAudit
TotalConsequence CPTestStation CPAnodeAudit
APDM Core Activity
TotalPOF
LineCrossingEasment CPBondAudit
TotalRisk
StructureOrIDSite DocumentPoint CPCableAudit
DOTClass CPGroundBedAudit
InstrumentParameter Contact Company Address Activity ActivityHierarchy ExternalDocument DocumentPoint RemovedPoint RemovedLine
DOTClassSegmentAudit DOTClassAudit ClusterBufferAudit DOTClassCorridorAudit HCACorridorAudit HCASegmentAudit HCARangeAudit RiskAnalysisAudit CouldAffectSegmentAudit DOTClassCorridor CPRectifierAudit
InstrumentEventID (fk) ContactType <d> CompanyLabel City ActivityDate ParentActivityEventID (fk) DocumentDescription DPName Attributes Attributes DOTClassSegment
ParameterType <d> Email CompanyName County ActivityDescription ChildActivityEventID (fk) DocumentType <d> ClassEventID (fk) BeginStationSeriesEventID DOTClassSegmentEventID (fk) DOTClassEventID (fk) ClusterBufferEventID (fk) DOTClassCorridorEventID (fk) HCACorridorEventID (fk) HCASegmentEventID (fk) HCARangeEventID (fk) RiskAnalysisEventID (fk) CouldAffectSegmentEventID (fk) CPTestStationAudit
Elbow
ParameterValue Fax CompanyType <d> Country ActivityName FileName ProjectionID BeginStation ElbowAudit
FirstName StateProvince ActivityType <d> FilePath RemovedDate ClassEventID (fk) ElevationPoint
ElevationPointAudit
Unknown (Verified) LastName Street1 GeoMetaDataEventID (fk) StationSeriesEventID EndStationSeriesEventID FieldNote
Unknown ExternalDocument (Core)
ER Probe Mobile Street2 HyperLink Station EndStation FieldNoteLocation
Pager ZipPostalCode ProjectionID FieldNoteAudit
Corrosion Coupon <classname>Audit
Operations
HCASegment
Flow Computer Phone RemovedDate FieldNoteLocationAudit
Flow Control Valve HighConsequenceArea
Gas Chromatograph GeoMetaData
OwnerOperator GeoMetaData
Gas Sampler RemovedPointAudit HCACorridor
Level Controller HCASegmentAudit
RemovedPointEventID (fk) HCARange
Level Indicator
Liquid Sampler
RemovedLineAudit IDSiteAreaOutline
InstrumentAudit
Pressure Controller LineCrossing InspectionRange <parent class> RemovedLineEventID (fk)
Pressure Gauge
OfflinePoint OnlinePoint OfflinePoint OnlinePoint OfflinePoint OnlinePolyline InspectionRange
InspectionRangeAudit
Pressure Recorder
RightOfWay
APDM Core Instrument InspectionReading
Structure ClassMetaData
Pressure Switch
Structure Leak InstrumentParameter
Pressure Transmitter
Pressure Transducer RightOfWay
Solar Panel
OfflineFeature LineCrossing LeakAudit
Facilities
Operations Note
RemovedLine
Routing Note ElevationPointAudit PressureTestAudit OperatingPressureAudit RightOfWayAudit PipeJoinMethodAudit
Transportation Note RemovedPoint
ElevationPointEventID (fk) PressureTestEventID (fk) OperatingPressureEventID (fk) RightOfWayEventID (fk) PipeSegmentAudit
RightOfWay
PressureTestAudit
Operational feature classes model terrain, survey, pressure FieldNoteAudit OnlineFieldNoteAudit RiskAnalysis
testing, right-of-way, operations and installations information Product (Core)
OnlinePolylineFacility OnlinePointFacility on or along the pipeline system. FieldNoteEventID (fk) OnlineFieldNoteEventID (fk)
Site (Core)
SitePoint ReducerAudit
StructureOrIDSite RemovedPointAudit
StructureLocation RightOfWayAudit
PipeSegment
BendRadius <d>
DateManufactured
GirthWeld <d>
CoatingLength
Coating
CoatingCondition <d>
CoatingLocation <d>
Grade <d>
Sleeve
NominalDiameter <d>
SleeveLength
CasingLength
Casing
CrossingType <d>
Filled <d>
Automated <d>
Valve
InletConnectionType <d>
InletDiameter <d>
Capacity <d>
CapacityUnits <d>
Tap
BranchConnectionType <d>
PipeJoinMethod
Insulated <d>
JoinType <d>
Manufacturer <d>
Vessel
Manufacturer <d>
SerialNumber <d>
VesselType <d>
Appurtenance
AppurtenanceType <d>
Instrument
DateManufactured
InstrumentName
Manufacturer <d>
Encroachments StuctureOutline
SubSystemRange (Core)
Tap
Tee
RiskAnalysisAudit
SiteAudit
SleeveAudit
StationSeriesAudit
Grade <d> CoatingMaterial <d> SleeveType <d> InsulatorType <d> Manufacturer <d> Capped <d> PressureSetting Model <d> OnlinePolylineForOfflinefeature OfflineFeature OnlinePointForOfflineFeature NonFacilityObject OfflineFeature Topology (ESRI Topology) StructureAudit
InletWallThickness <d> CoatingMill <d> WallThickness <d> OutsideDiameter <d> Material <d> FlowDirection <d> SerialNumber Valve SubSystem (Core)
LongitudinalSeam <d> CoatingSource <d> SealType <d> NormalPosition <d> Material <d> Weld VesselAudit AppurtenanceAudit Vessel SubSystemAudit
LongitudinalSeamOrientation-d InternalCoating <d> Shorted <d> OutletConnectionType <d> Manufacturer <d> Coupling
InstrumentParameter
Unknown (Verified)
Flange VesselEventID (fk) AppurtenanceEventID (fk) Unknown Well
Manufacturer <d> Vented <d> OutletDiameter <d> Metered <d> ER Probe
SubSystemHierarchy (Core)
Screw
Material <d> WallThickness <d> PresentPosition <d> PressureSetting Electro Stop Corrosion Coupon LineCrossing StructureOrIDSite TapAudit
MillLocation <d> PressureSetting TapSize <d> Flow Computer
TeeAudit
MillTestPressure ResponseTime TapSpecification <d> Flow Control Valve Clearance Name
PipeJoinMethodAudit Gas Chromatograph CrossingType <d> IdentifiedSite <d>
OutsideDiameter <d> Specification <d> TapType <d> Gas Sampler
LineCrossingEasement LineCrossingLocation StructureLocation IDSiteArea HighConsequenceArea ValveAudit
OutletWallThickness <d> CoatingAudit SleeveAudit CasingAudit ValveFunction <d> TappingMethod <d> PipeJointMethodEventID (fk) Level Controller EasementWidth IdentifiedSiteType <d> NOTE: The Catalog View ValveOperator
LineCrossingEventID (fk) Name LineCrossingEventID (fk) StructureOrIDSiteEventID (fk) NumberOfStories StructureOrSiteIDEventID (fk) AreaType <d> does not show any
Level Indicator
PipeJurisdiction <d> CoatingEventID (fk) SleeveEventID (fk) CasingEventID (fk) ValveNumber Liquid Sampler NearestPointToLineEventID (fk) ClassArea <d> relationship classes Only ValveOperatorAudit
PreTested <d> ValveType <d> NumberOfUnits feature and object classes
Pressure Controller Geographical VesselAudit
PressureRating <d> Pressure Gauge Utility
BIHO <d> are shown.
Contact
SegmentLength Pressure Recorder Transportation DaysPerWeek WellAudit
Pressure Switch WeeksPerYear
PressureRating <d> Company StructureOutline OfflineFeature
TapAudit Pressure Transmitter Address OccupantCount
Specification <d> Pressure Transducer
StructureOrSiteIDEventID (fk)
TapEventID (fk) Solar Panel LineCrossingAudit ImparedMobility <d>
Temperature Switch Contact StructureStatus <d>
Valve Position Ind. LineCrossingEventID (fk)
Valve Positioner StructureOrIDSiteType <d>
GeoMetaData DOTClassSegment DateAdded NearestPointToLine
Encroachment feature classes model any physical feature or boundary that might impact the operation and /or regulated safety SiteDescription
PipeSegmentAudit compliance of the pipeline system. StructureOutlineEventID (fk)
ValveAudit
PipeSegmentEventID (fk) InstrumentParameter StructureOrIDSiteEventID (fk)
ValveEventID (fk) LineCrossings represent offline linear features that intersect the centerline. LineCrossings may have one or more online point
locations (crossing locations) and one or more online polyline locations (easements)
StructureOrIDSiteAudit
InstrumentAudit StructureEventID (fk)
Structures are offline Points that may have zero or more online point locations - structure locations are typically derived for structures
within 1000 feet (304.8 meters) of the centerline.
InstrumentEventID (fk)
OfflinePointFacility OfflineNonPointFacility FacilityObject NonFacilityObject Fitting
Key
APINumber
GeologicFormation
LegalDescription
Well
SeasonallyActive <d>
PigStructure
BarrelDiameter <d>
BarrelGrade <d>
BarrelWallThickness <d>
Manufacturer <d>
ValveOperator
OperatorType <d>
ValveEventID (fk)
MeterReading
ContactEventID (fk) MeterFunction <d>
Meter Tee
BranchConnectionType <d>
Reducer
OutletConnectionType <d> ElbowAngle <d>
Elbow
ClosureType <d>
Closure
Cathodic Protection Concrete Class
RegularNormalField
SomethingEventID (FK)
A concrete class represents a object table or a feature class. Object tables and feature
classes stores rows of data containing attributes & features and attributes respectively.
Each field or attribute in the class stores data of a specific type.
(FK) Indicates the field is a foreign-key (fk) containing values found only in the
Contact CompanyEventID (fk) MeterName BranchDiameter <d> OutletDiameter <d> ElbowRadius <d> Specification <d> primary key (pk) of concrete class.
TieInDate Material <d> OfflinePointFacility OnlinePointForOfflineFeature OfflineNonPointFacility MaybeEventID (FK)
<d> Indicates that the valid values for the field are proscribed by the range of
MeterAuditEventID (fk) MeterNumber BranchWallThickness <d> OutletWallThickness <d> Specification <d> DomainField <d>
WellName MillLocation <d> values contained in a domain
WellType <d> PressureRating <d> ReadingDate MeterType <d> ScaperBars <d> ReducerSize <d>
StructureLength ReadingUnits RemoteNetworked <d> TeeSize <d> ReducerType <d>
An abstract class contains a set of attributes and possibly relationships that are inherited by
StructureType <d> ReadingValue SerialNumber TeeType <d> Specification <d> Abstract Class every concrete subclass beneath the abstract class in the inheritance tree.
Specification <d> Specification <d> RegularNormalField ...
Flow Reading
Pressure Reading ReducerAudit ElbowAudit ClosureAudit Lines that indicate relationships between concrete classes. The single line connector
WellAudit PigStructureAudit ValveOperatorAudit ReducerEventID (fk) ElbowEventID (fk) ClosureEventID (fk) CPRectifier CPGroundBed CPAnode CPTestStation CPBond CPLocation CPCable indicates a cardinality of ‘one’ whereas the ‘Crow’s Foot’ connector indicates a cardinality of
Contact MeterAudit TeeAudit ‘many’. Cardinality defines a rule indicating how many rows in a concrete class can
participate in a single instance of a specified relationship.
WellEventID (fk) PigStructureEventID (fk) ValveOperatorEventID (fk) MeterEventID (fk) TeeEventID (fk) Manufacturer <d> AnodeSpacing <d> AnodeMaterial <d> TestStationType <d> BondType <d> ClassEventID (fk) CableCoating <d> NOTES:
Company Model <d> BackFillMaterial <d> AnodeType <d> CriticalBond <d> CPFeatureEventID (fk) CableSize <d>
NumberOfNegatives <d> CPRectifierEventID (fk) AnodeWeight CableType <d> Wormholes represent a relationship between two concrete classes which is not specified
Facility feature classes model the physical appurtenances 04/23/2010 - Version 5.0
ExternalDocument diagrammatically by a line connecting the two classes. A pink wormhole indicates a proper
or devices found on or along a pipeline system. NumberOfAnodes LocationDescription CPGroundBedEventID (fk) ColorCode <d> 04/01/2006 - Version 4.0
primary key (pk) - foreign key (fk) relationship. A cyan wormhole indicates a relationship
10/05/2004 - Version 3.0
OperatingAmpsOut <d> NumberOfAnodes ClassMetaData
NumberOfCables between a concrete class and any instantiation/implementation of an abstract class.
Valve
OperatingVoltsOut <d> WaterSystem <d> APDM Model is maintained by APDM Technical
PowerSource <d> Committee on behalf of the ESRI and the ESRI Pipeline
Interest Group (PIG).
RatedAmpsOut <d> StationSeries Indicates a concrete class that is an <fc>Audit class which inherits from the <fc>Audit
RatedVoltsOut <d> Copyright 2002, 2003, 2004, 2005, 2006, 2007, 2008, Audit Class class template.