Germany administrative boundaries
16 states, 401 districts and 10,939 municipalities, each with its official code, in GeoJSON, TopoJSON, GeoPackage, Shapefile, layered SVG, CSV and SQL.
- states
- 16
- districts
- 401
- municipalities
- 10,939
- 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.
Bavaria: the municipalities of the district of Munich, coloured by area, among the other districts.
What is in the package
Levels and identifiers
| Level | Entities | Identifier |
|---|---|---|
| country | 1 | DE |
| states | 16 | DE-R-<official code> |
| districts | 401 | DE-P-<official code> |
| municipalities | 10,939 | DE-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.
Formats and scales
| Format | full | 100m | 1km | 10km | light |
|---|---|---|---|---|---|
| GeoJSON | 50.3 MB | 24.7 MB | 5.7 MB | 183 KB | 885 KB |
| TopoJSON | 12.1 MB | 7.7 MB | 3.9 MB | 136 KB | 472 KB |
| Shapefile | 41.5 MB | 20.3 MB | 4.6 MB | 142 KB | 723 KB |
| SVG | - | 26.4 MB | 5.5 MB | 176 KB | 931 KB |
full: the boundaries as published by the source.100m: simplified within 100 m and coherent: municipalities, districts and states 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, states and districts only: small maps and maps of many countries.- At the borders with the neighbouring countries (Austria, Belgium, Czech Republic, France, Luxembourg, Netherlands, Poland and Switzerland) the
100m,1kmand10kmboundaries share the same vertices as in their packages, so the maps fit without gaps or overlaps. light: country, states and districts 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/de.gpkg(87.9 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 (24.9 MB each). It creates one table with every entity of every level, its
100mboundary in WGS84 and its indexes. - JSON:
data/json/tree.json(954 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/regions.csv |
16 |
The states: official code, names, area, population, bounding box, centre and label point.
code, name, 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/provinces.csv |
401 |
The districts: 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 |
10,939 |
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 |
11,357 |
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 |
12,651 |
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 |
67,154 |
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 |
0 |
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.
- Statistisches Bundesamt (Destatis), Gemeindeverzeichnis (GV100AD), licensed dl-de/by-2-0
- BKG - Bundesamt für Kartographie und Geodäsie, Verwaltungsgebiete 1:250 000 (VG250), Stand 01.01., licensed dl-de/by-2-0
- Wikidata, Labels and external identifiers of the administrative entities (translated names, codes in other datasets), licensed CC0 1.0
Files
All the 165 files of the package, with their size.
ATTRIBUTION.md | 3 KB |
|---|---|
CHANGELOG.md | 0 KB |
LICENSE.md | 2 KB |
README.md | 13 KB |
data/geojson/100m/country.geojson | 333 KB |
data/geojson/100m/municipalities.geojson | 19.2 MB |
data/geojson/100m/provinces.geojson | 4.2 MB |
data/geojson/100m/regions.geojson | 979 KB |
data/geojson/10km/country.geojson | 6 KB |
data/geojson/10km/provinces.geojson | 158 KB |
data/geojson/10km/regions.geojson | 19 KB |
data/geojson/1km/country.geojson | 50 KB |
data/geojson/1km/municipalities.geojson | 4.9 MB |
data/geojson/1km/provinces.geojson | 666 KB |
data/geojson/1km/regions.geojson | 145 KB |
data/geojson/full/municipalities.geojson | 37.7 MB |
data/geojson/full/provinces.geojson | 9.7 MB |
data/geojson/full/regions.geojson | 2.8 MB |
data/geojson/light/country.geojson | 38 KB |
data/geojson/light/provinces.geojson | 655 KB |
data/geojson/light/regions.geojson | 192 KB |
data/geopackage/de.gpkg | 87.9 MB |
data/json/tree.json | 954 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 | 276 KB |
data/shapefile/100m/country.shx | 0 KB |
data/shapefile/100m/municipalities.cpg | 0 KB |
data/shapefile/100m/municipalities.dbf | 1.3 MB |
data/shapefile/100m/municipalities.prj | 0 KB |
data/shapefile/100m/municipalities.shp | 14.4 MB |
data/shapefile/100m/municipalities.shx | 86 KB |
data/shapefile/100m/provinces.cpg | 0 KB |
data/shapefile/100m/provinces.dbf | 38 KB |
data/shapefile/100m/provinces.prj | 0 KB |
data/shapefile/100m/provinces.shp | 3.4 MB |
data/shapefile/100m/provinces.shx | 3 KB |
data/shapefile/100m/regions.cpg | 0 KB |
data/shapefile/100m/regions.dbf | 1 KB |
data/shapefile/100m/regions.prj | 0 KB |
data/shapefile/100m/regions.shp | 809 KB |
data/shapefile/100m/regions.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 | 5 KB |
data/shapefile/10km/country.shx | 0 KB |
data/shapefile/10km/provinces.cpg | 0 KB |
data/shapefile/10km/provinces.dbf | 38 KB |
data/shapefile/10km/provinces.prj | 0 KB |
data/shapefile/10km/provinces.shp | 79 KB |
data/shapefile/10km/provinces.shx | 3 KB |
data/shapefile/10km/regions.cpg | 0 KB |
data/shapefile/10km/regions.dbf | 1 KB |
data/shapefile/10km/regions.prj | 0 KB |
data/shapefile/10km/regions.shp | 15 KB |
data/shapefile/10km/regions.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 | 41 KB |
data/shapefile/1km/country.shx | 0 KB |
data/shapefile/1km/municipalities.cpg | 0 KB |
data/shapefile/1km/municipalities.dbf | 1.3 MB |
data/shapefile/1km/municipalities.prj | 0 KB |
data/shapefile/1km/municipalities.shp | 2.6 MB |
data/shapefile/1km/municipalities.shx | 86 KB |
data/shapefile/1km/provinces.cpg | 0 KB |
data/shapefile/1km/provinces.dbf | 38 KB |
data/shapefile/1km/provinces.prj | 0 KB |
data/shapefile/1km/provinces.shp | 500 KB |
data/shapefile/1km/provinces.shx | 3 KB |
data/shapefile/1km/regions.cpg | 0 KB |
data/shapefile/1km/regions.dbf | 1 KB |
data/shapefile/1km/regions.prj | 0 KB |
data/shapefile/1km/regions.shp | 119 KB |
data/shapefile/1km/regions.shx | 0 KB |
data/shapefile/full/municipalities.cpg | 0 KB |
data/shapefile/full/municipalities.dbf | 1.3 MB |
data/shapefile/full/municipalities.prj | 0 KB |
data/shapefile/full/municipalities.shp | 29.7 MB |
data/shapefile/full/municipalities.shx | 86 KB |
data/shapefile/full/provinces.cpg | 0 KB |
data/shapefile/full/provinces.dbf | 38 KB |
data/shapefile/full/provinces.prj | 0 KB |
data/shapefile/full/provinces.shp | 8.0 MB |
data/shapefile/full/provinces.shx | 3 KB |
data/shapefile/full/regions.cpg | 0 KB |
data/shapefile/full/regions.dbf | 1 KB |
data/shapefile/full/regions.prj | 0 KB |
data/shapefile/full/regions.shp | 2.3 MB |
data/shapefile/full/regions.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 | 38 KB |
data/shapefile/light/provinces.prj | 0 KB |
data/shapefile/light/provinces.shp | 491 KB |
data/shapefile/light/provinces.shx | 3 KB |
data/shapefile/light/regions.cpg | 0 KB |
data/shapefile/light/regions.dbf | 1 KB |
data/shapefile/light/regions.prj | 0 KB |
data/shapefile/light/regions.shp | 157 KB |
data/shapefile/light/regions.shx | 0 KB |
data/topojson/100m/de.topojson | 7.7 MB |
data/topojson/10km/de.topojson | 136 KB |
data/topojson/1km/de.topojson | 3.9 MB |
data/topojson/full/de.topojson | 12.1 MB |
data/topojson/light/de.topojson | 472 KB |
examples/choropleth-svg.html | 2.3 MB |
examples/drill-down-d3.html | 1.3 MB |
examples/leaflet-geojson.html | 658 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 | 4.3 MB |
flags/DE-R-01.svg | 0 KB |
flags/DE-R-02.svg | 2 KB |
flags/DE-R-03.svg | 46 KB |
flags/DE-R-04.svg | 0 KB |
flags/DE-R-05.svg | 0 KB |
flags/DE-R-06.svg | 0 KB |
flags/DE-R-07.svg | 88 KB |
flags/DE-R-08.svg | 0 KB |
flags/DE-R-09.svg | 1 KB |
flags/DE-R-10.svg | 187 KB |
flags/DE-R-11.svg | 3 KB |
flags/DE-R-12.svg | 39 KB |
flags/DE-R-13.svg | 0 KB |
flags/DE-R-14.svg | 0 KB |
flags/DE-R-15.svg | 80 KB |
flags/DE-R-16.svg | 0 KB |
flags/DE.svg | 0 KB |
sql/mysql.sql | 25.1 MB |
sql/postgis.sql | 24.9 MB |
sql/sqlserver.sql | 25.1 MB |
svg/100m/layers.svg | 13.3 MB |
svg/100m/municipalities.svg | 10.3 MB |
svg/100m/provinces.svg | 2.3 MB |
svg/100m/regions.svg | 542 KB |
svg/10km/layers.svg | 90 KB |
svg/10km/provinces.svg | 75 KB |
svg/10km/regions.svg | 11 KB |
svg/1km/layers.svg | 2.8 MB |
svg/1km/municipalities.svg | 2.3 MB |
svg/1km/provinces.svg | 355 KB |
svg/1km/regions.svg | 80 KB |
svg/light/layers.svg | 476 KB |
svg/light/provinces.svg | 349 KB |
svg/light/regions.svg | 106 KB |
tables/changes.csv | 0 KB |
tables/codes.csv | 673 KB |
tables/country.csv | 0 KB |
tables/history.csv | 0 KB |
tables/municipalities.csv | 2.3 MB |
tables/names.csv | 885 KB |
tables/neighbours.csv | 3.1 MB |
tables/provinces.csv | 84 KB |
tables/regions.csv | 3 KB |
The package of Germany is not on sale yet. You can try it now: get the free sample, Saarland (6 districts and 52 municipalities) with the same files and formats.