whitewater-guide / gorge

MIT License
2 stars 3 forks source link

USA gauges #9

Open Mkrut opened 4 years ago

Mkrut commented 4 years ago

PNW The main one for the PNW (and not only) is USGS There are probably other minor sources in the PNW

The info in some places on this page is outdated. First they say no JSON available but then they give the examples of JSON and XML requests. Scroll down to Examples.

Map and Table of all the values

License. Open. No attribution needed. BUT these guidelines are recommended. They also ask to drop them a message saying who and how is using the data.

Kayak site with values

doomsower commented 4 years ago

https://www.dwr.state.co.us Colorado division of water resources

Mkrut commented 1 year ago

California gauges https://cdec.water.ca.gov/dynamicapp/QueryF?s=S12

I've received a reply from them with a couple questions

Permission to use received by email mike.krutyansky@gmail.com Jason.Ince@water.ca.gov

Machine readable data https://cdec.water.ca.gov/dynamicapp/wsSensorData

I can only open the link with the US vpn

Mkrut commented 1 year ago

noaa.gov Download the file with the recent values here

Free to use, no permission required

Mkrut commented 1 year ago

Another minor source, not sure if it's needed http://www.mysuwanneeriver.org/realtime/river-levels.php Just a copy of the USGS?

Mkrut commented 1 year ago

4 rivers in Northern California. Conditions of use unknown. Not in the USGS, not in NOAA

Mkrut commented 1 year ago

A guy made a simple page with many US water levels

Mkrut commented 1 year ago

California gauges https://cdec.water.ca.gov/dynamicapp/QueryF?s=S12

I've received a reply from them with a couple questions

Permission to use received by email mike.krutyansky@gmail.com Jason.Ince@water.ca.gov

Machine readable data https://cdec.water.ca.gov/dynamicapp/wsSensorData

Important update. Permission granted

Mkrut commented 1 year ago

Another source https://gis.ecology.wa.gov/portal/home/ Is it the part of the big ArcGIS source?

doomsower commented 1 year ago

noaa.gov Download the file with the recent values here

Free to use, no permission required

Ok, another crazy system without proper docs (at least, I could not find)

Actual data can be found here https://www.arcgis.com/home/webmap/viewer.html?url=https%3A%2F%2Fmapservices.weather.noaa.gov%2Feventdriven%2Frest%2Fservices%2Fwater%2Fahps_riv_gauges%2FMapServer&source=sd

To see the table, you need to select it under layer: telegram-cloud-photo-size-2-5247160605381611984-x

When you open the table, actually this json is loaded: https://mapservices.weather.noaa.gov/eventdriven/rest/services/water/ahps_riv_gauges/MapServer/0/query?f=json&where=(1%3D1)%20AND%20(1%3D1)&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outFields=*&orderByFields=objectid%20ASC&outSR=102100&resultOffset=0&resultRecordCount=50

Now the fun part. Table has 4 columns: units, secunit, observed (not in table, but present in json) and secvalue. I think this is primary sensor unit, secondary sensor unit and their respective values.
Known units values: "cfs", "cfs", "ft", "ft", "kcfs", "kcfs*" Known secunit values: " ", "ft", "kcfs"

Now, some of them have asterisk symbol, and this is really weird. Gauges with astersik return something else. For example this gauge (https://water.weather.gov/ahps2/hydrograph.php?wfo=boi&gage=andi1) has unit as set to ft* and secunit is ft. But If you go to the page and see the data, you can see that it actually returns cfs: telegram-cloud-photo-size-2-5247160605381611988-y

So I have no idea how to get right unit for the gauge, need you to help me to figure out the rules.

Also one thing to note that json returns kcfs value, and charts show cfs value, but rounding to kilo can result in significant deviations.