search

CityofToronto / bdit_volumes

Traffic Volumes Modelling Project
7 stars 6 forks source link

Create temp process for migrating MOVE centreline <-> arterycode matching process #74

Open aharpalaniTO opened 3 years ago

aharpalaniTO commented 3 years ago

Created new table for only ATR matches here:

CREATE TABLE prj_volume.arteries_centreline (
    arterycode int,
    centreline_type smallint,
    centreline_id int,
    direction character(1)
);

ALTER TABLE prj_volume.arteries_centreline OWNER TO prj_volume;
GRANT SELECT ON prj_volume.arteries_centreline TO bdit_humans;
aharpalaniTO commented 3 years ago

Imported dump from counts.arteries_centreline (flashcrow database)

aharpalaniTO commented 3 years ago

Importing latest centreline version from https://open.toronto.ca/dataset/toronto-centreline-tcl/

here: prj_volume.centreline_new (existing processes / linkages are using prj_volume.centreline)