rustprooflabs / pgosm-flex

PgOSM Flex provides high quality OpenStreetMap datasets in PostGIS (Postgres) using the osm2pgsql Flex output.
MIT License
101 stars 20 forks source link

QGIS style should not require manual update for database name #307

Closed rustprooflabs closed 1 year ago

rustprooflabs commented 1 year ago

What version of PgOSM Flex are you using?

0.7.1

Docker image

ebe9e07cef76

What did you do exactly?

Followed instructions for external Postgres connections, using a database name other than pgosm. I loaded the processed data into QGIS, specifically osm.road_line.

What did you expect to happen?

I expected the osm.road_line data to be styled since that is one of the styles I regularly expect to be there.

What did happen instead?

Loading the osm.road_line table into QGIS resulted in an unstyled layer. The style is there, I can manually load it from Postgres via the QGIS dialog, but that isn't ideal.

What did you do to try analyzing the problem?

This step is documented on https://pgosm-flex.com/qgis-styles.html

UPDATE public.layer_styles_staging
    SET f_table_catalog = 'your_db',
        f_table_schema = 'osm'
;

This should not be required as a manual operation. The process in Docker has all the details necessary to run the update command currently documented here

Overall, that QGIS style page is quite outdated now that I look at it. Needs some overall cleaning, review, and removing the manual step.