smnorris / PSCIS_datafixes

Tracking and creating data fix patches for BC Provincial Stream Crossing Information System (PSCIS)
0 stars 0 forks source link

PSCIS Phase 1 duplicates Bulkley #13

Open Mateo9569 opened 1 year ago

Mateo9569 commented 1 year ago

Hi Simon, here is a table showing all the pscis ids for our phase 1 sites. It was entered into the system twice. We'd like to retain everything from stream_crossing_id 198109 down to 198117, and get rid of the duplicates which are from 198108 up to 198100. In reference to issue here: https://github.com/NewGraphEnvironment/fish_passage_bulkley_2022_reporting/issues/41

image

smnorris commented 1 year ago

Thanks Mateo! Any chance you could post the ids as text so I can copy/paste?

Mateo9569 commented 1 year ago
198100, 198101, 198102, 198103, 198104, 198105, 198106, 198107, 198108
198109, 198110, 198111, 198112, 198113, 198114, 198115, 198116, 198117
NewGraphEnvironment commented 1 year ago

csv is attached as well pscis_phase1_dups.csv