I would like to join a CSV file attributes to multiple spatialite layers, but I would like to be able to edit the csv externally (export it from a different project on Excel or Numbers every time I make a change).

I've done this with SHP layers and it worked fine, as long as I re-opened the project to refresh the join.

I'm getting started with Spatialite layers instead of SHP mostly because I want the ability to create dynamic views with simple queries. I'm wondering if it's possible to keep such link with a csv that is stored outside of the database, or if I will have to ditch Excel/Numbers altogether and only work from within the DB. I would like to keep these tools for many other functions that are not spatial-related, and for which I'm a lot more proficient than SQL/DB (zero experience).

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.