Awesome

postgis-verwaltungsgebiete

This repository provides simple scripts to set up a PostGIS database with administrative features (federal states, administrative regions, districts etc.) of Germany.

Verwaltungsgebiete - Screenshot aus QGIS

Prerequisites

Provided scripts assume a locally installed PostGIS database with a postgres superuser.

What these scripts do

Provided scripts do the following:

Create the database named VG and enable the postgis extension on it.
Download shape files of administrative areas to data/vg-shape-files.
Import the downloaded shape files into the VG database

Layers

The scripts import all of the layers:

VG250_STA - Staat, the country
VG250_LAN - Länder, federal states
VG250_RBZ - Regierungsbezirke, administrative regions
VG250_KRS - Kreise, districts
VG250_VWG - Verwaltungsgemeinschaften, association of administrations
VG250_GEM - Gemeinden, munucipalities
VG250_LI - all of the border lines
VG250_PK - center points of municipalities

QGIS

This project also provides a pre-configured QGIS project which includes layers from shape files as well as from the database. Please open it only after you've executed the scripts - that is, downloaded and extracted the shape files and imported them into the PostGIS database.

Usage

Windows

00-create-postgis-vg-database.bat
01-get-vg-shape-files.bat
02-import-vg-shape-files.bat

License

Scripts are licensed under BSD 2-clause license.

The data is downloaded from the State Department of Cartography and Geodesy and is subject to the following Usage Regulations.