1INSTALL spatial; LOAD spatial;
2-- Rows by land/water
3SELECT water, count(*) FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2022/nld_admin4/nld_admin4.parquet') GROUP BY water;
4-- B 1, JA 94, NEE 14317
5
6-- Land area per unit in km²
7SELECT buurtcode, buurtnaam, ST_Area(geometry) / 1e6 AS km2
8FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2022/nld_admin4/nld_admin4.parquet')
9WHERE water = 'NEE';

1INSTALL spatial; LOAD spatial;
2-- Rows by land/water
3SELECT water, count(*) FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2022/nld_admin4/nld_admin4.parquet') GROUP BY water;
4-- B 1, JA 94, NEE 14317
5
6-- Land area per unit in km²
7SELECT buurtcode, buurtnaam, ST_Area(geometry) / 1e6 AS km2
8FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2022/nld_admin4/nld_admin4.parquet')
9WHERE water = 'NEE';