Regional roads - Githubissues

bcgov / CE_integratedroads

Merge multiple BC road datasets into a single layer for Cumulative Effects analysis

Apache License 2.0

1 stars 0 forks source link

Regional roads #1

Closed smnorris closed 5 months ago

smnorris commented 7 months ago

Cariboo region is working on product that can replace the 'integrated roads' in their area - it works as a drop-in replacement and works better for road density and similar analysis.

smnorris commented 7 months ago

Draft data are here: ftp.geobc.gov.bc.ca/pub/outgoing/for_CE

smnorris commented 6 months ago

Include these columns from source:

CAPTURE_DATE
STRUCTURED_NAME_1
TRANSPORT_LINE_TYPE_CODE
TRANSPORT_LINE_SURFACE_CODE
TRANSPORT_LINE_TENURE_TYPE_CODE
DEACTIVATION_DATE
PRIVATE_FLAG
ACCESS_RESTRICTED_FLAG
ACCESS_RESTRICTION_TYPE
GROUND_TRUTH_REQUIRED
DESKTOP_EX_STATUS

For above columns that match DRA columns, load directly into existing columns.

smnorris commented 5 months ago

A few questions remain on how to handle Cariboo road attributes:

assign a hierarchy number?
assign a value for the bcgw_source column?
how should the transport_line_type_code values be handled (they are different from DRA codes)

smnorris commented 5 months ago

hierarchy = 1
bcgw_source is null
add ccr_transport_line_type_code