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.
Postgis
- 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.
- Read here about how the order of input data impacts spatial indexes and database performance.
- Watch the presentations from PostGIS day 2021, hosted by Crunchy Data.
- Would you want to serve OSM data via PostGIS and GeoServer? Check here for instructions how to do just that.
- This article teaches you how to return full GeoJSON FeatureCollection and Feature objects from PostgreSQL/PostGIS queries.
- Read here about how a new algorithm for repairing invalid polygons and multipolygons will affect the results of ST_MakeValid in PostGIS 3.2.
