Postgres / postgis feature layer

[bclay1297]

We are looking at our long term goal for our Earth viewer application. I lieu of using pbf files we would like to load data using spatial queries direct from the OSM and others postgis enabled databases. I could not find an example that shows how to create a feature layer from postgis. I assume it would be a GDALFeatureLayer but how does the query get loaded?

[gwaldron]

Bruce, you can use the OGRFeatureSource and the connection property to connect to PostGIS.

<OGRFeatureSource name="db">
    <connection>...</connection>

Refer to the documentation on connection strings here:
https://gdal.org/en/stable/drivers/vector/pg.html#connecting-to-a-database