2 posts / 0 new
Last post
web-based dynamic maps linking to MySql

I am trying to improve some of our online mapping tools. Currently, they are hosted using an esri mapping server. Our data is stored in a MySql database linked to district level shapefiles based on a unique district ID.

This current setup is not useful for individuals who want to access our maps in areas with low bandwidth and it is very expensive to maintain.

It seems that StatPlanet might meet our needs, providing the option for an offline solution.

Is it possible to link data from MySql directly to shapefiles?
I notice that many of the examples provided are at the country level, our maps are district level global maps (very large). Can StatPlanet handle this size?

These are the sites we hope to enhance.

Thanks for your advise,


StatSilk's picture

Hi Rebecca,

Thank you for your message. StatPlanet Plus does have a file size limit (or rather map complexity limit), and therefore it is recommended that shapefiles are simplified for the web using mapshaper as described here: http://www.statsilk.com/maps/useful-free-gis-shapefile-map-tools. In general several hundred map areas and/or a file size up to 5 mb should be ok, but beyond there might be a 'time-out' when loading the map. Simplifying the map could overcome that issue. Please feel free to try out the software (StatPlanet Plus, with the included Shapefile Map edition) - setting up a map does not take much more than a few minutes: http://www.statsilk.com/files/software/StatPlanet_Plus.zip

For some examples of sub-national maps, please see http://www.statsilk.com/examples (under sub-national maps) and http://www.statsilk.com/maps/download-free-shapefile-maps (please scroll down for a list of sub-national maps).

StatPlanet currently does not have a means of communicating with a MySql database although this is a work in progress. Some clients use a script to export from a MySql database directly to the csv / comma-separated values format read by StatPlanet, or alternatively the included StatPlanet Data Editor Excel can be used to automatically import data from a range of file types / structures. For writing your own script to produce the csv files, you could find the required structure of the data explained here: http://www.statsilk.com/files/resources/User_Guide_StatPlanet.htm#_Toc37...

If you need more details just let me know.