qgis - add pipelines to mapping

smnorris / bcfishpass

Model and monitor aquatic habitat connectivity in BC. Tools to plan and prioritize the assessment and remediation of barriers.

https://smnorris.github.io/bcfishpass

Apache License 2.0

7 stars 13 forks source link

qgis - add pipelines to mapping #322

Open smnorris opened 1 year ago

smnorris commented 1 year ago

Pipelines are not generally barriers/potential barriers but they are certainly important to be aware of, especially in the field

smnorris commented 11 months ago

@NewGraphEnvironment - Have you already determined the best source for this data?

$ bcdata list | grep PIPEL
WHSE_MINERAL_TENURE.OG_PIPELINE_INSTLN_PERMIT_SP
WHSE_MINERAL_TENURE.OG_PIPELINE_AREA_APPL_SP
WHSE_MINERAL_TENURE.OG_PIPELINE_AREA_PERMIT_SP
WHSE_MINERAL_TENURE.OG_PIPELINE_SEGMENT_PERMIT_SP

There is also pipeline data in TRIM - but that will be rather dated.

smnorris commented 11 months ago

TRIM pipelines:

bcdata bc2pg WHSE_BASEMAPPING.TRIM_CULTURAL_LINES --query "FCODE LIKE 'EA214%'" --schema whse_basemapping --table trim_pipelines

Notes:

TRIM pipelines do not necessarily distinguish between water supply pipelines (and maybe even hydro penstocks) and oil/gas pipes
curiously, neither source includes Fortis line between Victoria and Cowichan
WHSE_MINERAL_TENURE.OG_PIPELINE_SEGMENT_PERMIT_SP seems to be decent, but major line connecting Coldwater/Merrit with Prince George and Fort Nelson (present in TRIM) is absent, as is another major connector in the E Kootenay from ~Yahk to ~Elko (edit, looks like older lines are not present: https://catalogue.data.gov.bc.ca/dataset/oil-and-gas-commission-pipeline-segment-permits)
there is a layer for pre '16 facilities, but it is points only (WHSE_MINERAL_TENURE.OG_FACILITY_LOCATNS_PRE2016_SP)

smnorris commented 11 months ago

On enquiry, the province basically says providing rights of way for pipelines permitted pre06 is not their problem - go buy it from https://gdm-inc.com

No results when searching the federal open data portal either - CANVEC does not seem to include them.

smnorris commented 10 months ago

OSM has pipelines, data from this overpass turbo query has gaps but may augment the other sources:

/*
This has been generated by the overpass-turbo wizard.
The original search was:
“man_made=pipeline”
*/
[out:json][timeout:25];
// gather results
(
  // query part for: “man_made=pipeline”
  node["man_made"="pipeline"]({{bbox}});
  way["man_made"="pipeline"]({{bbox}});
  relation["man_made"="pipeline"]({{bbox}});
);
// print results
out body;
>;
out skel qt;