
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 lastupdated 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
Voila!



on the toolbar.