troutspotr / troutspotr-frontend

Help anglers make safe and legal choices when fishing for trout.
Other
6 stars 2 forks source link

Update MN's kittle routes (aka rivers / streams) to latest #170

Closed andest01 closed 5 years ago

andest01 commented 5 years ago

Linear Referencing won't work without this set:

https://gisdata.mn.gov/dataset/water-measured-kittle-routes

image

andest01 commented 5 years ago

there's an issue with the following MN trout stream kittle_nbr ids:

"trout_flag" = 1
and "kittle_nbr" in (
'S-035-001-002',
'S-000.7-002-007',
'S-035-001-002-003',
'S-088-009-001-001'

)

These ids have no corresponding trout stream match due to annoying decimal-based IDs in their underlying streams_with_measured_kittle_routes data set, e.g. S-000.7-002-007. Note the decimal.

Not really sure what to do with them. I'll likely note it with the DNR and move on with MN's dataset.

image