Leaflet Maps with Google Sheets

Customize Leaflet maps with a linked Google Sheets template and GeoJSON data on GitHub

Live links (replace with your own)

• Leaflet Map https://datameet-pune.github.io/live-crop-map/
• Google Sheets template https://docs.google.com/spreadsheets/d/1fxxPLbFHj3Id8JYz9lDAqnb_h9bFUYRpYccxQN5w7PQ/edit#gid=0

Create your own

• See video with step-by-step tutorial in Data Visualization for All http://www.datavizforall.org/leaflet/with-google-sheets/

Credits (and licenses)

Developed by Ilya Ilyankou and Jack Dougherty with support from Trinity College CT, using a Google Sheets template, with these open-source components:

• Inspired by: Code for Atlanta mapsfor.us (2016) https://github.com/codeforatlanta/mapsforus (BSD-3-Clause)
• Leaflet v1.0.3 https://leafletjs.com (BSD-2-Clause)
• jQuery v3.2.0 https://code.jquery.com (MIT)
• leaflet-providers (v1.1.15, manually updated for Carto https) https://github.com/leaflet-extras/leaflet-providers (BSD-2-Clause)
• Mapzen Search geocoding plugin (v1.8.1, customized to display a blue circle around the search result) https://github.com/mapzen/leaflet-geocoder (MIT)
• leaflet-locatecontrol (v0.60.0) https://github.com/domoritz/leaflet-locatecontrol (MIT)
• Leaflet.markercluster (v1.0.4) https://github.com/Leaflet/Leaflet.markercluster (MIT)
• Leaflet.MarkerCluster.LayerSupport (v.1.0.3) https://github.com/ghybs/Leaflet.MarkerCluster.LayerSupport (MIT)
• Font Awesome (v4.7) https://cdn.fontawesome.com (MIT, SIL OFL 1.1)
• Leaflet.awesome-markers (v2.0.4) https://github.com/sigma-geosistemas/Leaflet.awesome-markers (MIT)
• Single Element CSS Spinner (31 May 2016) https://github.com/lukehaas/css-loaders (MIT)
• Tabletop.js gives spreadsheets legs, by returning Google Sheets data in JSON format (v1.5.1) https://github.com/jsoma/tabletop (MIT)
• Google Colour Palette Generator (2015) https://github.com/google/palette.js (MIT)
• Google Sheets Geocoder (v1.0) by Ilya Ilyankou and Jack Dougherty https://github.com/jackdougherty/google-sheets-geocoder (no license)
• polylabel (Dec. 2016 customized) https://github.com/mapbox/polylabel to optimally place text labels in a polygon (ISC), with TinyQueue (v1.1.0) (https://github.com/mourner/tinyqueue), polylabel's dependency (ISC)
• jQuery-CSV (v0.71) https://github.com/evanplaice/jquery-csv (MIT)
• DataTables (v1.10.13) by SpryMedia Ltd. https://datatables.net (MIT)

Please submit any pull requests to our DEV repo

• Leaflet Map FOR DEVELOPMENT https://jackdougherty.github.io/leaflet-maps-with-google-sheets-dev/index.html
• Google Sheet FOR DEVELOPMENT https://docs.google.com/spreadsheets/d/1_xjrH3gSImzRKqIkhRAqpAAMjH387yaBWfGbidkKtqM/