I'm trying to inspect town assets, like pavement and signs. I want to display that information on a web-based map (CartoDB). I also want to be able to pull the most up to date information to generate reports using Crystal Reports or other similar reporting software.
My first attempt was to upload the shapefiles to CartoDB. Then I created a table with all the attributes that I would be filling out in the field that would stay synced in my DropBox. This would allow me to access the table to perform reports or update any information using excel, etc on my desktop. But I needed to merged that table with the shapefile, and if I did that, it would turn off syncing.
Does anyone know how I could get this to work? And what the best method of field collecting the data would be in order to keep everything synced with that one table in my DropBox?