Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

BGT ETL: add BGT Lean SQL Script #362

Closed
justb4 opened this issue Nov 17, 2023 · 1 comment
Closed

BGT ETL: add BGT Lean SQL Script #362

justb4 opened this issue Nov 17, 2023 · 1 comment

Comments

@justb4
Copy link
Contributor

justb4 commented Nov 17, 2023

Besides the full BGT PostGIS version, as a result of the current ETL, there is a need for a BGT PostGIS version and corresposing Dumpfile that has the following characteristics:

  • only actual+existing objects (actueelbestaand)
  • only tables, no views
  • one geometry per table
  • only Simple geometries, no Curve/Surface-like
  • remove 'cruft-columns', mainly metadata and status-columns, take only relevant columns

This has been applied within geotoko.nl and was named "BGT Lean". See description, data and example dumps here:
https://geocatalogus.nl/dataset/bgt-imgeo-database-dumps

"BGT Lean" is simply an SQL script (file) that is applied to the full BGT latest schema and creates a new schema called bgt_lean. The resulting Dump file is also like 14GB where full BGT PG Dump is 24GB.

BGT Lean is very useful for mapping projects and other tooling which e.g. does not accept 'curve' geometries like
CURVEPOLYGON, COMPOUNDCURVE,CIRCULARSTRING etc. Also one geometry per table solves various issues.

So geotoko.nl is basically open-sourcing the BGT Lean script here to be used and hopefully enhanced by the NLExtract-community.

@justb4 justb4 self-assigned this Nov 17, 2023
@justb4 justb4 added this to the Versie 1.6.0 milestone Nov 17, 2023
justb4 added a commit that referenced this issue Nov 17, 2023
@justb4
Copy link
Contributor Author

justb4 commented Nov 17, 2023

@justb4 justb4 closed this as completed Nov 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant