search

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

Add `osm2pgsql_replication` column to `osm.pgosm_flex` #302

Closed rustprooflabs closed 1 year ago

rustprooflabs commented 1 year ago

Closes #295.

Add osm2pgsql_replication column to track when osm2pgsql-replication mode is used in osm.pgosm_flex table.

SELECT id, region, osm_date, pgosm_flex_version,
        osm2pgsql_mode, osm2pgsql_replication
    FROM osm.pgosm_flex 
;
┌────┬───────────────────────────────────────┬────────────┬────────────────────┬────────────────┬───────────────────────┐
│ id │                region                 │  osm_date  │ pgosm_flex_version │ osm2pgsql_mode │ osm2pgsql_replication │
╞════╪═══════════════════════════════════════╪════════════╪════════════════════╪════════════════╪═══════════════════════╡
│  1 │ north-america/us-district-of-columbia │ 2022-12-30 │ 0.7.0-01ecd52      │ create         │ t                     │
│  2 │ north-america/us-district-of-columbia │ 2023-02-15 │ 0.7.0-01ecd52      │ append         │ t                     │
└────┴───────────────────────────────────────┴────────────┴────────────────────┴────────────────┴───────────────────────┘