1INSTALL spatial; LOAD spatial;
2-- Rows by land/water
3SELECT water, count(*) FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2023/nld_admin2/nld_admin2.parquet') GROUP BY water;
4-- B 1, JA 81, NEE 342
5
6-- Largest gemeenten by land area in km²
7SELECT gemeentecode, gemeentenaam, round(sum(ST_Area(geometry)) / 1e6, 1) AS land_km2
8FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2023/nld_admin2/nld_admin2.parquet')
9WHERE water = 'NEE'
10GROUP BY ALL ORDER BY land_km2 DESC LIMIT 3;
11-- GM1900 Súdwest-Fryslân, 574.6

1INSTALL spatial; LOAD spatial;
2-- Rows by land/water
3SELECT water, count(*) FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2023/nld_admin2/nld_admin2.parquet') GROUP BY water;
4-- B 1, JA 81, NEE 342
5
6-- Largest gemeenten by land area in km²
7SELECT gemeentecode, gemeentenaam, round(sum(ST_Area(geometry)) / 1e6, 1) AS land_km2
8FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2023/nld_admin2/nld_admin2.parquet')
9WHERE water = 'NEE'
10GROUP BY ALL ORDER BY land_km2 DESC LIMIT 3;
11-- GM1900 Súdwest-Fryslân, 574.6