Daily Discoveries of a FOSS4G User: PostGIS and Its Bag of Tricks

As I mentioned in the previous post, there were a couple of handy PostGIS functions I found quite useful after importing prepped data via shp2pgsql tool. They involve working with Spatial Reference of geometries and working with Multi* geometries. 1. PostGIS: ST_SetSRID vs ST_Transform Even after figuring out the way to define Spatial Reference in QGIS – it’s still possible to miss …

Daily Discoveries of a FOSS4G User: PostGIS and Its Bag of Tricks Read More »