search

troutspotr / troutspotr-frontend

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

Add western stream database reference or link #190

Open zacharyrpope opened 5 years ago

zacharyrpope commented 5 years ago

Just a formal request to consider, assuming the dataset is not proprietary and originates from a public source or agency such as DNR or USGS. Specifically, the request is to reference or include the original dataset for those streams west of Minnesota (SD, MT, WY, ID etc...)

zacharyrpope commented 5 years ago

Or maybe this is just the NHD referred to in other issues? I'll keep digging. If this ends up being it I'll close.

andest01 commented 5 years ago

yeah this is a good idea.

Let's get two birds with one stone and start gathering all the publicly sourced data in this thread.

andest01 commented 5 years ago

https://www.dnr.state.mn.us/aboutdnr/disclaimers_and_policies.html

https://www.fs.fed.us/rm/boise/AWAE/projects/NorWeST/ModeledStreamTemperatureScenarioMaps.shtml

andest01 commented 5 years ago

@zacharyrpope it seems NorWeST has some new data. I doubt I'll be using it until the govt shutdown is done because I'd want to reach out to them directly. I can, however, batch them all into a zip file and send them to you if you prefer. lmk.

zacharyrpope commented 5 years ago

Yea, I've noticed a lot of gov't sites down here this week.

That would be fantastic if you could .zip them up. That said, your link is quite sufficient, appreciate it!

andest01 commented 5 years ago

@zacharyrpope you never know when this climate science related stuff is just gonna poof disappear from the USFS.

~700 MB zip https://drive.google.com/file/d/1m8VqKpy5rhYZjCTHJuLiHVrY67dWGMQs/view?usp=sharing

zacharyrpope commented 5 years ago

@andest01 Sweet dataset. How did you get stream names to this NowrWeST data?

andest01 commented 5 years ago

wanna know the trade secrets eh?

short answer: download and install literally the NHD, filter out the unnamed creeks, hail Mary, and dissolve by GNIS_ID. Then, write a series of very careful postgis queries that find the greatest matching NorWeST candidate by several house recipes. After about 5 weeks of work you may just get the results you wanted just in time for the USGS to update the NHD again, and now you get to do it all over again.

Alternatively, when this whole government shutdown kerfuffle is over, we could talk to the folks who run the data set and ask them kindly to include the GNIS_ID in the norwest dataset when available and we could all save ourselves about three thousand lines of code and a month of our lives with a inner join.

andest01 commented 5 years ago

I'm of course being facetious. But God bless the GNIS. Equally important and thankless work, that.

andest01 commented 5 years ago

OK, now that TroutSpotr officially uses MIT + attribution, the website has to be updated to conform to this.