Add western stream database reference or link

[ghost]

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...)

[ghost]

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]

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]

• Minnesota
• Iowa
• Wisconsin
• NorWeST
• USFS (federal public land)
• Colorado (state public land)
• Oregon (state public land)
• Montana (state public land)

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

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

[andest01]

@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.

[ghost]

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]

@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

[ghost]

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

[andest01]

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]

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

[andest01]

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