I am novice GIS'er. I can create maps and do basic transformation of the SHP file using QGIS. I also succesfully applied formatting based on attributes. I am able to add new attributes to SHP file in QGIS, and I have published my map with styles to my instance of Geoserver (SLD styling compatibility is painful). It's all working fine. I've also familarized myself with kartograph.py note: I am only using free software

My workflow is: I get SHP file for my country with counties. I then add new CSV layer containing KEY matching the attributes in CSV file with the attributes in SHP file. ( I do this to add some numeric data to Counties). Then I will add some styling to counties based on the new attributes and export to new SHP file. I then publish this to GeoServer, correct the styling and I am done - I can see my data on the map via webservice. Hurray!

The question: I am able to generate CSV with new data regularly (e.g. daily) but adding the updated attributes to shapefile and then publishing to geoserve, correcting the SLD style manualy everyday seems very troublesome. I feel there must be better way.

I am wondering how some of you Experts tackle this issue? Is my workflow/approach incorrect?


  • 1
    I think you will find this post very helpful, gis.stackexchange.com/questions/57692/… Essentially, if you want to dynamically change your data, you want to store your data in a database, rather than a shapefile. Because the post references PostGIS, here is a link to get more info: postgis.net – evv_gis Nov 18 '14 at 15:20
  • This seems very useful, thank you very much for your suggestion. I understand that PostGIS is a database representation of the SHP file. That's neat because I'm familiar with SQL. Cheers! – Radek Kukuczka Nov 18 '14 at 15:38

Try using qgis2web (leaflet) plugin. I think that is the asy way to solve your problem. Dynamics that require one or two refresh by hour can be solved in linux using crontab and shel script that run qgis in command line mode.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.