środa, 22 lipca 2015

Excel: Vector Map of Polish Counties, Shapes for Choropleths

See these tutorials first:
http://www.clearlyandsimply.com/clearly_and_simply/2012/12/create-excel-choropleth-maps-from-shape-files.html
http://www.clearlyandsimply.com/clearly_and_simply/2009/08/build-your-own-choropleth-maps-with-excel.html

Then download shapefile for Poland from here:
http://www.gadm.org/country

Next, use online service to convert shp to svg file:
 http://indiemapper.com/app/ (By the way, you can open svg as xml in Excel and extract a table with columns for  Province, County or Major Town - you may need it. )

Convert svg file into emf in Inkscape (free and open source equivalent of InDesign)

You can now open emf in Excel or PowerPoint and ungroup the vector image into individual shapes for each county. Now it will be possible to use VBA to give them colors, values, labels etc.

More info https://pl.wikipedia.org/wiki/Powiaty_w_Polsce
Translation issues: http://serwistlumacza.com/content/view/27/32/

Another option: http://www.exprodat.com/blogs/blog_Extracting-Vector-Data-from-PDFs.htm using
http://ksng.gugik.gov.pl/pliki/mapa_administracyjna_polski_2012.pdf

Brak komentarzy:

Prześlij komentarz