1INSTALL spatial; LOAD spatial;
2-- Rows by land/water
3SELECT water, count(*) FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2021/nld_admin3/nld_admin3.parquet') GROUP BY water;
4-- B 1, JA 82, NEE 3248
5
6-- Land area per unit in km²
7SELECT wijkcode, wijknaam, ST_Area(geometry) / 1e6 AS km2
8FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2021/nld_admin3/nld_admin3.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/2021/nld_admin3/nld_admin3.parquet') GROUP BY water;
4-- B 1, JA 82, NEE 3248
5
6-- Land area per unit in km²
7SELECT wijkcode, wijknaam, ST_Area(geometry) / 1e6 AS km2
8FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2021/nld_admin3/nld_admin3.parquet')
9WHERE water = 'NEE';