Read here about how a new algorithm for repairing invalid polygons and multipolygons will affect the results of ST_MakeValid in PostGIS 3.2.
Archive: Postgis
- Would you want to serve OSM data via PostGIS and GeoServer? Check here for instructions how to do just that.
- Watch the presentations from PostGIS day 2021, hosted by Crunchy Data.
- Read here about how the order of input data impacts spatial indexes and database performance.
- Do you have data in a live database - updating all the time - that you want turn into a map? The new version of MapTiler Server can easily connect to any PostGIS database and load data as map tiles.
- Recent versions of QGIS support using the OGC API for Features as a vector data source. Learn how to publish spatial data with pg_featureserv using this protocol and add the layer to QGIS.
- The PostGIS raster extension has a steep learning curve, but it opens up some unique possibilities for data analysis and accessing non-standard data from within PostgreSQL.
- This post compares running spatial join queries in PostGIS with GPU-assisted spatial joins. See how much they differ here.
- This blog post introduces the ST_AsMVT PostGIS function which enables building lightweight tile services that can convert map tile requests into binary Mapbox Vector Tile representations.
- Check out this post for how to get data from an ArcGIS Feature Service to PostGIS using QGIS (or ogr2ogr, if you prefer the command line). Sharing the data with pg_featureserv is also demonstrated.
