Netherlands administrative boundaries
12 provinces and 342 municipalities, each with its official code, in GeoJSON, TopoJSON, GeoPackage, Shapefile, layered SVG, CSV and SQL.
- provinces
- 12
- municipalities
- 342
- edition
One of the examples in the package
A layered SVG coloured from a table with a few lines of plain JavaScript: every entity is a path whose id is its official code. The page shows a part of the country: the two levels share the same borders, so they fit without gaps. The package has every entity of every level.
North Holland: its municipalities, coloured by area, among the neighbouring provinces.
What is in the package
Levels and identifiers
| Level | Entities | Identifier |
|---|---|---|
| country | 1 | NL |
| provinces | 12 | NL-P-<official code> |
| municipalities | 342 | NL-M-<official code> |
Every entity has the same identifier in every file: it is the feature id in GeoJSON and TopoJSON, the id of the path in SVG and the id column of the tables.
The history lists 940 suppressed municipalities with their successor.
Formats and scales
| Format | full | 100m | 1km | 10km | light |
|---|---|---|---|---|---|
| GeoJSON | 1.1 MB | 941 KB | 240 KB | 10 KB | 296 KB |
| TopoJSON | 350 KB | 287 KB | 135 KB | 7 KB | 213 KB |
| Shapefile | 931 KB | 790 KB | 192 KB | 9 KB | 253 KB |
| SVG | - | 977 KB | 239 KB | 10 KB | 316 KB |
full: the boundaries as published by the source.100m: simplified within 100 m and coherent: municipalities and provinces share exactly the same border vertices.1km: simplified within 1 km and coherent like100m, every level: the whole country on a web map.10km: simplified within 10 km and coherent, country and provinces only: small maps and maps of many countries.- At the borders with the neighbouring countries (Belgium and Germany) the
100m,1kmand10kmboundaries share the same vertices as in their packages, so the maps fit without gaps or overlaps. light: country and provinces only, each level simplified on its own to a small file.- GeoJSON: one FeatureCollection per level, WGS84. TopoJSON: all the levels in one topology, shared borders are shared arcs.
- GeoPackage:
data/geopackage/nl.gpkg(3.1 MB), one file for QGIS and ArcGIS with every level at every scale as a layer (municipalities_100m) with its spatial index, and every table of the package. - Shapefile: one per level and scale, WGS84, UTF-8; the columns longer than ten characters are shortened (
region,province,abbrev). - SVG: one file per level and one with every level as a layer, in a Lambert conformal conic projection; they open as layers in Illustrator, Figma and Inkscape.
- SQL: a script for PostGIS, one for MySQL 8 and one for SQL Server (949 KB each). It creates one table with every entity of every level, its
100mboundary in WGS84 and its indexes. - JSON:
data/json/tree.json(26 KB), the levels nested and sorted by name, without boundaries: what the select boxes of a form need.
Tables
CSV, UTF-8. Names in EN, IT, ES, FR, DE, NL, PT, besides the official one.
| File | Rows | Content |
|---|---|---|
tables/country.csv |
1 |
The country: names, population, bounding box, centre and label point.
code, name, population, min_lat, min_lng, max_lat, max_lng, center_lat, center_lng, label_lat, label_lng, id, name_en, name_it, name_es, name_fr, name_de, name_nl, name_pt
|
tables/provinces.csv |
12 |
The provinces: official code, abbreviation, the code of the parent, names, area, population, bounding box, centre and label point.
code, name, abbreviation, region_code, area_km2, population, min_lat, min_lng, max_lat, max_lng, center_lat, center_lng, label_lat, label_lng, id, name_en, name_it, name_es, name_fr, name_de, name_nl, name_pt
|
tables/municipalities.csv |
342 |
The municipalities: official code, the codes of the parents, names, area, population, elevation in metres (of the centre, or lowest and highest point, as the official source gives it), bounding box, centre and label point.
code, name, province_code, province_abbreviation, region_code, cadastral_code, chief_town, area_km2, population, elevation, elevation_min, elevation_max, elevation_mean, min_lat, min_lng, max_lat, max_lng, center_lat, center_lng, label_lat, label_lng, id, name_en, name_it, name_es, name_fr, name_de, name_nl, name_pt
|
tables/codes.csv |
355 |
Every entity in other datasets, as Wikidata declares it: the Wikidata item, ISO 3166-2, GeoNames and the OpenStreetMap relation.
id, level, code, wikidata, iso_3166_2, geonames, osm_relation
|
tables/names.csv |
445 |
Every name an entity is written with (official, each side of a bilingual name, translated), without accents and as a slug: to match a file that has names and no codes.
id, level, name, name_ascii, slug, kind
|
tables/neighbours.csv |
1,804 |
The entities of the same level that share a border, both ways, with the length of the shared border in km.
level, id, neighbour_id, shared_border_km
|
tables/history.csv |
940 |
The suppressed municipalities with the one that replaced them, for archives that still have the old codes; no rows where the official source gives no history.
code, name, province_code, replaced_by_code, replaced_by_name
|
tables/changes.csv |
0 |
What changed from one edition of the package to the next, one row per entity added, removed, renamed, moved or with a new boundary: the same as CHANGELOG.md.
edition, date, level, id, name, change, before, after
|
Sources and licenses
The package is a derived work of the official datasets below; their publishers do not endorse it. What you may do with it is in the license of the packages.
Files
All the 114 files of the package, with their size.
ATTRIBUTION.md | 2 KB |
|---|---|
CHANGELOG.md | 0 KB |
LICENSE.md | 2 KB |
README.md | 11 KB |
data/geojson/100m/country.geojson | 121 KB |
data/geojson/100m/municipalities.geojson | 637 KB |
data/geojson/100m/provinces.geojson | 183 KB |
data/geojson/10km/country.geojson | 3 KB |
data/geojson/10km/provinces.geojson | 7 KB |
data/geojson/1km/country.geojson | 19 KB |
data/geojson/1km/municipalities.geojson | 186 KB |
data/geojson/1km/provinces.geojson | 34 KB |
data/geojson/full/municipalities.geojson | 848 KB |
data/geojson/full/provinces.geojson | 259 KB |
data/geojson/light/country.geojson | 37 KB |
data/geojson/light/provinces.geojson | 259 KB |
data/geopackage/nl.gpkg | 3.1 MB |
data/json/tree.json | 26 KB |
data/shapefile/100m/country.cpg | 0 KB |
data/shapefile/100m/country.dbf | 0 KB |
data/shapefile/100m/country.prj | 0 KB |
data/shapefile/100m/country.shp | 104 KB |
data/shapefile/100m/country.shx | 0 KB |
data/shapefile/100m/municipalities.cpg | 0 KB |
data/shapefile/100m/municipalities.dbf | 29 KB |
data/shapefile/100m/municipalities.prj | 0 KB |
data/shapefile/100m/municipalities.shp | 498 KB |
data/shapefile/100m/municipalities.shx | 3 KB |
data/shapefile/100m/provinces.cpg | 0 KB |
data/shapefile/100m/provinces.dbf | 1 KB |
data/shapefile/100m/provinces.prj | 0 KB |
data/shapefile/100m/provinces.shp | 155 KB |
data/shapefile/100m/provinces.shx | 0 KB |
data/shapefile/10km/country.cpg | 0 KB |
data/shapefile/10km/country.dbf | 0 KB |
data/shapefile/10km/country.prj | 0 KB |
data/shapefile/10km/country.shp | 2 KB |
data/shapefile/10km/country.shx | 0 KB |
data/shapefile/10km/provinces.cpg | 0 KB |
data/shapefile/10km/provinces.dbf | 1 KB |
data/shapefile/10km/provinces.prj | 0 KB |
data/shapefile/10km/provinces.shp | 5 KB |
data/shapefile/10km/provinces.shx | 0 KB |
data/shapefile/1km/country.cpg | 0 KB |
data/shapefile/1km/country.dbf | 0 KB |
data/shapefile/1km/country.prj | 0 KB |
data/shapefile/1km/country.shp | 16 KB |
data/shapefile/1km/country.shx | 0 KB |
data/shapefile/1km/municipalities.cpg | 0 KB |
data/shapefile/1km/municipalities.dbf | 29 KB |
data/shapefile/1km/municipalities.prj | 0 KB |
data/shapefile/1km/municipalities.shp | 114 KB |
data/shapefile/1km/municipalities.shx | 3 KB |
data/shapefile/1km/provinces.cpg | 0 KB |
data/shapefile/1km/provinces.dbf | 1 KB |
data/shapefile/1km/provinces.prj | 0 KB |
data/shapefile/1km/provinces.shp | 28 KB |
data/shapefile/1km/provinces.shx | 0 KB |
data/shapefile/full/municipalities.cpg | 0 KB |
data/shapefile/full/municipalities.dbf | 29 KB |
data/shapefile/full/municipalities.prj | 0 KB |
data/shapefile/full/municipalities.shp | 678 KB |
data/shapefile/full/municipalities.shx | 3 KB |
data/shapefile/full/provinces.cpg | 0 KB |
data/shapefile/full/provinces.dbf | 1 KB |
data/shapefile/full/provinces.prj | 0 KB |
data/shapefile/full/provinces.shp | 219 KB |
data/shapefile/full/provinces.shx | 0 KB |
data/shapefile/light/country.cpg | 0 KB |
data/shapefile/light/country.dbf | 0 KB |
data/shapefile/light/country.prj | 0 KB |
data/shapefile/light/country.shp | 32 KB |
data/shapefile/light/country.shx | 0 KB |
data/shapefile/light/provinces.cpg | 0 KB |
data/shapefile/light/provinces.dbf | 1 KB |
data/shapefile/light/provinces.prj | 0 KB |
data/shapefile/light/provinces.shp | 219 KB |
data/shapefile/light/provinces.shx | 0 KB |
data/topojson/100m/nl.topojson | 287 KB |
data/topojson/10km/nl.topojson | 7 KB |
data/topojson/1km/nl.topojson | 135 KB |
data/topojson/full/nl.topojson | 350 KB |
data/topojson/light/nl.topojson | 213 KB |
examples/choropleth-svg.html | 108 KB |
examples/drill-down-d3.html | 97 KB |
examples/leaflet-geojson.html | 262 KB |
examples/lib/LICENSES.md | 3 KB |
examples/lib/d3.min.js | 273 KB |
examples/lib/leaflet.css | 14 KB |
examples/lib/leaflet.js | 144 KB |
examples/lib/topojson-client.min.js | 7 KB |
examples/point-lookup.html | 192 KB |
flags/NL.svg | 0 KB |
sql/mysql.sql | 957 KB |
sql/postgis.sql | 949 KB |
sql/sqlserver.sql | 958 KB |
svg/100m/layers.svg | 523 KB |
svg/100m/municipalities.svg | 350 KB |
svg/100m/provinces.svg | 104 KB |
svg/10km/layers.svg | 6 KB |
svg/10km/provinces.svg | 4 KB |
svg/1km/layers.svg | 125 KB |
svg/1km/municipalities.svg | 94 KB |
svg/1km/provinces.svg | 20 KB |
svg/light/layers.svg | 168 KB |
svg/light/provinces.svg | 147 KB |
tables/changes.csv | 0 KB |
tables/codes.csv | 18 KB |
tables/country.csv | 0 KB |
tables/history.csv | 33 KB |
tables/municipalities.csv | 67 KB |
tables/names.csv | 28 KB |
tables/neighbours.csv | 72 KB |
tables/provinces.csv | 2 KB |
The package of the Netherlands is not on sale yet. You can try it now: get the free sample, Zeeland (13 municipalities) with the same files and formats.