USGS real-time streamflow stations


We have added the NY USGS stream gage stations to the ARGIS interactive map under the “Hydrology” tab.  Use the identify tool to get details and graphs directly from the USGS website.  In order to make the real-time connection, we set up a script that runs hourly and pulls the data from the USGS National Water Information System.  Here’s how the script works:

1) The latest data is downloaded as a comma-separated file (CSV)
2) The old data is deleted from the table in our PostgreSQL database
3) The new data is loaded into the table
4) The last updated field is updated to reflect the latest download
5) Points are constructed using the lat/lon contained in the CSV
6) Geoserver renders the points and associated info onto the map

DEC Campsites layer