Bart Zwemmer bartzwemmer
bartzwemmer
/ bag_panden.sql
Created
July 15, 2026 08:02
DuckDB SQL query to retrieve all current Panden (building foorprints) in The Netherlands from local BAG data.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Extensions, so we can read the zipped GML files | |
| INSTALL spatial; LOAD spatial; | |
| -- Combined Relational Model of BAG Objects (Panden, Verblijfsobjecten, Addresses, Public Spaces, Cities) | |
| -- Filters active records (eindGeldigheid IS NULL AND tijdstipInactief IS NULL) to prevent historical duplicate versions. | |
| WITH wpl_active AS ( | |
| SELECT | |
| identificatie, | |
| naam, | |
| status, |