A generator that colors the individual municipalities of the Netherlands based on their status in a SQL table. See it in action!
* Import [SQL data]( How to usehttps://github.com/VDK/NL-municipal-map-gen/blob/master/data.sql) into your database. * Change [database settings in index.php](https://github.com/VDK/NL-municipal-map-gen/blob/master/index.php#L16). * Upload [index.php](https://github.com/VDK/NL-municipal-map-gen/blob/master/index.php) and [map.xml](https://github.com/VDK/NL-municipal-map-gen/blob/master/map.xml) to your server. * Specify the colors you'd like to use in the database in the table *_status_to_color*, specify a municipal status in *_progress*, there is no GUI for this.
- Embed-shapefile-data-into-SVG.php is the script that I used to embed additional info into the SVG after it had been exported. It is not essential for the generators functioning.
- The table _cbs_changes is there to keep the map functioning after municipalities have merged at the beginning of each year. By this table it has joined the municipalities that merged at the beginning of 2013. It should be kept up to date using this CBS data.
The map was generated out of the shapefile of the Wijken- en buurtenkaart 2012, which was published under the condition of attributing the map to the Centraal Bureau voor de Statistiek and Het Kadaster.
Publicatie van digitale geometrie is toegestaan mits het CBS en het Kadaster als bronnen worden vermeld.