A geospatial career journey

Tag: PostGIS

Attribute Transfer in PostGIS Using Spatial SQL

Data conflation is a meat-and-potatoes task in most GIS workflows. There are numerous reasons one might need to get data from one data set into another. Perhaps you want to attach a new geometry type to existing attributes or a table. Or maybe you need to pull attributes from one or more data sets into … Continue reading Attribute Transfer in PostGIS Using Spatial SQL →

Bill Dollins gis 2020-04-062020-04-06 2 Minutes

Watching COVID-19 Data for Your County with PostgreSQL and Node

I have addressed the topic of triggered notifications a couple of times on this blog previously. I've taken the opportunity to apply the technique to a current use case - the ability to get notifications whenever the confirmed count of COVID-19 cases changes in my county or surrounding ones. I am basing this workflow on … Continue reading Watching COVID-19 Data for Your County with PostgreSQL and Node →