PostGIS¶
The PostGIS map source reads geometries from a PostgreSQL/PostGIS connection.
Goal¶
Configure a map that uses the PostGIS source.
Prerequisites¶
- A map element is on the canvas
- Required connections exist in Connection Manager (when applicable)
Steps¶
- Create a PostgreSQL connection to your PostGIS database.
- Select the map and choose PostGIS.
- Select the connection.
- Enter Map SQL that returns geometry (for example
SELECT geom FROM parcels). - Configure extent, symbology, basemap, and labels.
- Preview.
[ Screenshot: PostGIS map configuration ]
Result¶
Preview renders features from the PostGIS source inside the map frame.
Tips¶
Tip
Keep Map SQL efficient — maps render at preview/print size and complex queries slow Preview.