Name: Topo Tools - Data
Creator: The Centre for Humanitarian Data (HDX)

Contents

Details

Analytics

Home

All Products

Docs

Source Cooperative is a Radiant Earth project

Topo Tools - Data · The Centre for Humanitarian Data (HDX) · Source Cooperative | Source Cooperative

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_admin2/nld_admin2.parquet') GROUP BY water;
4-- B 1, JA 82, NEE 345
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/2022/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/2022/nld_admin2/nld_admin2.parquet') GROUP BY water;
4-- B 1, JA 82, NEE 345
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/2022/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

Topo Tools - Data

Topo Tools - Data

AGENTS.md: Netherlands admin2 (gemeenten) 2022

Queries

AGENTS.md: Netherlands admin2 (gemeenten) 2022

Queries