I use a shared Google Drive spreadsheet to coordinate a large GIS mapping project. The work involves processing thousands of DOQQ images. Essentially, work is divided into study areas and then further into DOQQ boundaries that make up the study areas.

I am envisioning a dynamically updated web map that show which DOQQs have been processed within study areas. In other words, as I update the shared spreadsheet, the web map should also update. The attached image is a rough example of the type of data I wish to present.

Is this feat possible with any web mapping services (e.g. CartoDB)? Which technologies should I pursue to accomplish this type of web mapping?

enter image description here


1 Answer 1


Never tried something like it, but certainly it should be possible. Realtime mapping is one of cartoDB selling points, although you would need to solve the issue of automating the update between Google drive and cartoDB's postGIS database.

If you have some experience in Web development, it should also be possible to write a JavaScript application that syncs with Google Drive directly. For example using backbone.js with Tabletop.js. Again, I have never tried this, but it looks perfectly feasible. You can start from the Tabletop README and its backbone example. Once you have set-up a backbone collection with your dynamic data, you can then use this data to draw a vector map in leaflet or OpenLayers. The application would then listen to a backbone "change:[attribute]" event that would fire a real-time update on the vector map.

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.