Skip to content

Latest commit

 

History

History
28 lines (22 loc) · 894 Bytes

README.md

File metadata and controls

28 lines (22 loc) · 894 Bytes

PostGIS Tools

This repository houses scripts for the spatial tools and processes in the postgres database. The tools take advantage of the spatial features provided in PostGIS, the spatial component of Postgres databases.

Tools

Query Daymet

Daymet records are returned for a set of lat/lon points (NAD83). One CSV of climate variable timeseries is generated for all of the sites specified in the table. The hydrologically assigned records from the Daymet database are accessed by this tool, not the raw Daymet records.

Zonal Statistics

The average values from a raster are returned for a layer of polygons representing the zones. This is set up specifically for the catchments polygons in the sheds database. The tool is a PostGIS adaptation of the process previously run in ArcGIS.

Contact Info

Kyle O'Neil
[email protected]