This application allows users to link spreadsheets and maps online. Using the features of the Google Spreadsheets Application, users can collaboratively edit and update spreadsheet data and visualize the results in BerkeleyMapper.
How to get started:
1. Goto Google Docs and upload your existing spreadsheets or enter new data. If you do not already have a Google Account you will be prompted to create one.
2. Your Google Spreadsheets file can have any number of fields you want, but must have the first row describing your fields and contain latitude/longitude values in decimal degrees. For example:
| lat | lng | title | description | maxerrorinmeters |
|---|---|---|---|---|
| 37 | -121 | some title | description text | 100 |
| 37 | -120 | another title | more description text | 200 |
3. Publish your spreadsheet (click the "Publish" tab and follow instructions)
4. Run BerkeleyMapMaker to generate BerkeleyMapper configuration file and link. Once you have generated the link, you can bookmark it or place it on a web-server and refer to it later. If you or anyone you have authorized updates your spreadsheet data, it will reflect in the BerkeleyMapper view when you click refresh.
Much of the logic of this script adapted from the Google Maps API Blog