GDM Enhanced Pipeline and Facility Data Sample

Name: GDM Enhanced Pipeline and Facility Data Sample
Creator: GDM Inc.
Published: 2026-03-23 21:56:44
License: 暂无描述

Snowflake2026-03-23 更新2026-03-27 收录

下载链接：

https://app.snowflake.com/marketplace/listing/GZ1MBZ3XQ4320

下载链接

链接失效反馈

官方服务：

资源简介：

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 <br/>infrastructure data Source: These data are compiled using records from government sources, operators, and spatially accurate locations and operational details validated by GDM experts.

提供机构：

GDM Inc.

创建时间：

2026-03-23

原始信息汇总

GDM Enhanced Pipeline and Facility Data

数据集概述

数据集名称: GDM Enhanced Pipeline and Facility Data
提供商: GDM Inc.
数据内容: 加拿大各省和美国北部地区的石油和天然气基础设施数据。
试用信息: 提供30天免费试用。
数据用途: 该数据用于驱动分析，以创建和管理管道完整性管理计划。提供资产情报，帮助组织通过最大化资产价值、最小化停机时间和降低公司风险来保持竞争力。确保资产有效运行、保护人员和设备并维护其生命周期，涉及从设计到退役的资产管理，同时平衡成本和管理退化。

数据源与更新

数据源: 这些数据通过政府来源记录、运营商记录以及经GDM专家验证的空间精确位置和操作细节编制而成。
更新频率: 近实时更新。
时间覆盖范围: 1914年5月14日之后，按小时更新。
地理覆盖范围: 美国（2个州）、加拿大，按经纬度覆盖。

数据表与字段示例

示例数据表

PIPELINE
FACILITY
INCIDENT
PIPELINECROSSING
FACILITYBATTERYPRODUCTION
FACILITYGASPLANT

示例字段

APPROVALNUMBER: 管道批准号
FEDERALLYREGULATED: CER受监管管道指示器
LINENUMBER: 批准号内的管道段号
FACILITYNAME: 设施名称
OPERATOREFFDATE: 运营商生效日期
FACILITYTYPE: 设施类型名称
LICENSENUMBERWELL: 相关井的监管业务关联方或客户ID
DAMAGETYPE: 管道损坏类别
INCIDENTTYPE: 标识事件是泄漏还是投诉
TYPEOFCROSSING: 管道穿越类型描述
CROSSINGSUBTYPE: 穿越类型的进一步描述
LOCATION: 管道穿越的DLS或NTS网格位置
OILPRODUCTION: 月度报告的原油和原油产量（立方米）
GASPRODUCTION: 月度报告的天然气产量（千立方米）
LASTCHANGE: 记录最后修改日期
PLANTTYPE: 基于产品类型的天然气厂类型描述
RESERVES: 与天然气厂相关的计算储量潜力

预期工作流程

消费者在Snowflake中对GDM数据表运行查询以提取基础设施数据。

业务需求

资产估值

确保所有资产的有效性能，以维持运营效率和安全。例如，密切关注老化基础设施和收购的资产，将其添加到公司的管道完整性计划中。

库存管理

创建和维护资产连接性，例如查看完整的管道水穿越列表，对穿越进行分类和优先级排序，以制定全面的检查计划。

监管报告

每日访问最新的监管数据（当前和历史数据），以简化向所有监管机构（包括现场审查）的监管提交。

风险分析

了解整个管道风险概况，创建和管理概况，根据特定可能性和后果因素对各个段的风险进行分类。

数据字典对象

FACILITY
FACILITYGASPLANT
INCIDENT
PIPELINE
PIPELINECROSSING
- 15 objects

使用示例

有多少条运营中的管道？

sql SELECT COUNT(PIPELINE.STATUS) AS OPERATING_PIPELINES_COUNT FROM GDM.PIPELINE WHERE PIPELINE.STATUS = OPERATING GROUP BY PIPELINE.STATUS;

所有天然气厂位于何处？

sql SELECT DISTINCT FACILITYGASPLANT.LOCATION FROM GDM.FACILITYGASPLANT;

2015年至2020年间在11-11W4区域发生了多少起事件？

sql SELECT COUNT(INCIDENT.INCIDENTID) AS INCIDENT_COUNT FROM GDM.INCIDENT WHERE DATE_PART(YYYY, INCIDENT.INCIDENTDATE) BETWEEN 2015 AND 2020 AND INCIDENT.LOCATION LIKE %011-11W4;

距离管道-水穿越500米范围内有多少起泄漏事件？

sql SELECT COUNT(DISTINCT INCIDENT.INCIDENTID) AS RELEASE_INCIDENT_WITHIN_500M_OF_PIPELINE_WATER_CROSSING FROM GDM.INCIDENT, GDM.PIPELINECROSSING WHERE PIPELINECROSSING.TYPEOFCROSSING = WATER AND INCIDENT.INCIDENTTYPE = RELEASE AND ST_DISTANCE(INCIDENT.SHAPE, PIPELINECROSSING.SHAPE) < 500 GROUP BY PIPELINECROSSING.TYPEOFCROSSING, INCIDENT.INCIDENTTYPE;