GDM Enhanced Pipeline and Facility Data

This data drives analysis to create and manage pipeline integrity management programs. Our data provides asset intelligence for organizations to stay competitive by maximizing asset value, minimizing downtime, and reducing risk across the company. This fuels asset integrity to ensure an asset operates effectively, protects personnel and equipment, and maintains its life cycle. It involves managing assets from design to decommissioning while balancing costs and managing degradation.
Sample Tables
- PIPELINE
- FACILITY
- INCIDENT
- PIPELINECROSSING
- FACILITYBATTERYPRODUCTION
- FACILITYGASPLANT

Sample Fields
- APPROVALNUMBER: Pipeline approval number
- FEDERALLYREGULATED: CER regulated pipeline indicator
- LINENUMBER: Pipeline segment number within an Approval Number
- FACILITYNAME: Name of the facility
- OPERATOREFFDATE: Date of the operator effective
- FACILITYTYPE: Name of the facility type
- LICENSENUMBERWELL: Regulatory business associate or client ID for the
- associated well
- DAMAGETYPE: Pipeline damage category
- INCIDENTTYPE: Identifier if the incident is a release or complaint
- TYPEOFCROSSING: Description of the type of pipeline crossing
- CROSSINGSUBTYPE: Further description of the crossing type
- LOCATION: DLS or NTS Grid location of the pipeline crossing
- OILPRODUCTION: Monthly reported Crude Oil and Crude production (m3)
- GASPRODUCTION: Monthly reported Gas production (1000 m3)
- LASTCHANGE: The date the record was last modified
- PLANTTYPE: Descriptions of Gas Plant types based on their product type
- RESERVES: Calculated reserves potential tying into Gas Plant

Expected Workflow:
- Consumer runs queries in Snowflake on GDM data tables to extract
infrastructure data

Source: These data are compiled using records from government sources, operators, and spatially accurate locations and operational details validated by GDM experts.

搜集汇总

背景与挑战

背景概述

该数据集为增强型管道和设施数据，旨在支持管道完整性管理计划的分析与制定，通过提供资产智能帮助组织最大化资产价值、减少停运和降低风险。数据包含管道、设施、事件等多个样本表及详细字段，可用于在Snowflake平台上进行查询，其来源整合了政府记录、运营商信息以及经专家验证的空间位置和操作细节。