/postgis-verwaltungsgebiete

Scripts to setup a Postgis database with administrative areas of Germany

Primary LanguageBatchfileBSD 2-Clause "Simplified" LicenseBSD-2-Clause

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.