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

1-- Which 2023 gemeente took over Weesp's 2022 territory
2WITH w AS (
3  SELECT ST_Union_Agg(geometry) AS g
4  FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2022/nld_admin2/nld_admin2.parquet')
5  WHERE gemeentenaam = 'Weesp'
6)
7SELECT n.gemeentecode, n.gemeentenaam,
8       round(ST_Area(ST_Intersection(n.geometry, w.g)) / 1e6, 2) AS km2
9FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2023/nld_admin2/nld_admin2.parquet') n, w
10WHERE ST_Intersects(n.geometry, w.g)
11  AND ST_Area(ST_Intersection(n.geometry, w.g)) > 1e4
12ORDER BY km2 DESC;
13-- GM0363 Amsterdam, 24.16

1-- Which 2023 gemeente took over Weesp's 2022 territory
2WITH w AS (
3  SELECT ST_Union_Agg(geometry) AS g
4  FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2022/nld_admin2/nld_admin2.parquet')
5  WHERE gemeentenaam = 'Weesp'
6)
7SELECT n.gemeentecode, n.gemeentenaam,
8       round(ST_Area(ST_Intersection(n.geometry, w.g)) / 1e6, 2) AS km2
9FROM read_parquet('https://data.source.coop/hdx/topo-tools/nld/2023/nld_admin2/nld_admin2.parquet') n, w
10WHERE ST_Intersects(n.geometry, w.g)
11  AND ST_Area(ST_Intersection(n.geometry, w.g)) > 1e4
12ORDER BY km2 DESC;
13-- GM0363 Amsterdam, 24.16

Topo Tools - Data

Topo Tools - Data

AGENTS.md: Netherlands

Conventions shared by every year

Comparing years

Revisions

AGENTS.md: Netherlands

Conventions shared by every year

Comparing years

Revisions