I am building/editing a table and utilising Excel as the vehicle. When I change the spreadsheet I need to produce a new csv file and then re-import to generate new layers. Handling Excel spreadsheet in QGIS? gives me some options.

But would it be easier to use a database for the process? I can update/edit the database which could then automatically update the layers? (Postgis, Spatiallite, GeoPackage?) If so, which database should I be moving to? There will be a steep learning curve for all of them.

  • 1
    We use an R script to upload a CSV to a PostGIS table. We then notify QGIS to the change and see the results straight away. – AWGIS Jun 21 '19 at 14:23
  • 1
    Yes it is feasible - we chose to do it this way because many of our analysts are far more familiar with Excel and it's functionality. We do also have an online interface which was developed for data entry into PostGIS but this is costly and lengthy to implement if you need a lot of built in logic. – AWGIS Jun 21 '19 at 14:30
  • 2
    @IanGS - If you load it as a delimited text layer, you could enable the Watch file option which updates the layer when any changes are made/saved to the csv file. – Joseph Jun 21 '19 at 14:32
  • 1
    @IanGS yes that is correct - you can also edit in QGIS which will update the PostGIS table if you allow yourself permission to do so. Is it mainly data entry or do you need to run cross-field calculations? Joseph's comment is also a good one but I have never tried it. – AWGIS Jun 21 '19 at 14:41
  • 1
    have done both, watch files (from the web so cannot change the format etc) and postgis - postgres wins as qgis can visualize the change much faster on bigger datasets almost in real-time. – Mapperz Jun 21 '19 at 16:35

Your Answer

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

Browse other questions tagged or ask your own question.