Participatory Mapping with Google Forms, Google Sh... - Esri Community Community All Communities Products ArcGIS Survey123 ArcGIS Pro ArcGIS Online ArcGIS Enterprise Data Management Geoprocessing ArcGIS Web AppBuilder ArcGIS Collector ArcGIS Spatial Analyst ArcGIS CityEngine Imagery and Remote Sensing ArcGIS Dashboards All Products Communities Industries Education Water Resources Gas and Pipeline State & Local Government Transportation Water Utilities Telecommunications Roads and Highways Natural Resources Electric Science Commercial All Industries Communities Developers Python ArcGIS API for JavaScript ArcGIS Runtime SDKs ArcObjects SDK ArcGIS API for Python ArcGIS Pro SDK Developers - General ArcGIS API for Silverlight (Retired) ArcGIS API for Flex (Retired) ArcGIS REST API ArcGIS for Windows Mobile (Retired) File Geodatabase API All Developers Communities Worldwide Comunidad Esri Colombia - Ecuador - Panamá ArcGIS 開発者コミュニティ ArcNesia Esri India GeoDev Germany Czech GIS ArcGIS Content - Esri Nederland Esri Italia Community Swiss Geo Community GeoDev Switzerland Comunidad GEOTEC Esri Ireland All Worldwide Communities All Communities Products Developers User Groups Industries Services Worldwide Community Basics Events ArcGIS Topics Learning Networks View All Communities ArcGIS Ideas Community Basics Community Help Documents Community Blog Community Feedback Member Introductions Sign In cancel Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for  Show  only  | Search instead for  Did you mean:  Cancel Home : All Communities : Industries : Education : Education Blog : Participatory Mapping with Google Forms, Google Sh... Participatory Mapping with Google Forms, Google Sheets, and ArcGIS Online Subscribe 7585 4 07-21-2017 06:03 AM Labels (2) Labels Higher Education Schools (K - 12) by JosephKerski Esri Frequent Contributor 3 4 7,585 Subscribe to RSS Feed Mark as New Mark as Read Bookmark Subscribe Email to a Friend Printer Friendly Page Report Inappropriate Content ‎07-21-2017 06:03 AM I have been receiving questions from schools that have become "Google Schools" as well as universities and individual researchers who want to use Google Sheets in ArcGIS Online.  What are the advantages of using Google Sheets (spreadsheets, really, is what they are) over using an Excel spreadsheet on your own computer? Google Sheets live in the cloud, just like ArcGIS Online, so they can be edited from any device, anywhere, and the author of the Sheet can invite others to add data to it, so they can accept input from multiple collaborators, students, and faculty. Some educators want to map data that they have input into Google Sheets.  Others want to go to the next level, where multiple students or researchers edit Google Sheets in a participatory mapping or citizen science environment, and the resulting data is mapped and automatically refreshes as the data continues to be added. Both of these scenarios are possible with ArcGIS Online.  To illustrate, I created a form where students are asked, "What country have you visited?", shown below. After students fill out the form, I go to the "responses" zone in Google Forms, and access the spreadsheet that is created from the data.  Now that my data is in my Google Sheet, I access > File > Publish to the Web > and change "Web Page" to "Comma Separated Values (.csv)" file > Publish.   Then, I copy the resulting URL: Then, I access my ArcGIS Online account, open a new or existing map > Add > Add Layer from Web - CSV file > paste your URL for my Google Sheet here.   Next, I > Add Layer > I indicate which fields contain my location information (address, latitude-longitude, city/state/country combination).   That's really all there is to it!  My results are in this map linked here, and shown below: Note that I used one of the fun new basemaps in ArcGIS Online that I wrote about here. In another example, this time using cities instead of countries, see this map of the 10 most polluted and 10 least polluted large cities of the world.  Students examine spatial patterns and reasons for the pollution (or lack of it) in each city using the map and the metadata here.  I created this map by populating this Google Sheet, below.  My students could add 10 or 20 more to this sheet and their changes would be reflected in my ArcGIS Online map. Here is the map from the data, below.  For those explanatory labels, I used this custom label expression:   $feature.City + " is the #" + " " + $feature.Rank + " " + $feature.Variable and set the text color to match the point symbol color for clarity.  For more about expressions, see my blog post here. In another example, my colleague created this google sheet of some schools in India by latitude-longitude. Then she added the published content from Google to her map.  Let's explore a bit deeper.  Let's say that I wanted to visualize the most commonly visited countries among my students.  I can certainly examine the statistics from my Google form, as seen below: However, my goal is really to see this data on a map.  With the analysis tools in ArcGIS Online, this too is quickly done. The Aggregate Points tool will summarize points in polygons.  For my polygons, I added a generalized world countries map layer, and then used Aggregate Points to summarize my point data within those countries.  The result is shown below and is visible as a layer in the map I referenced above.  Another point worth noting is that you can adjust the settings of how your map interacts with your Google Sheet.  Go to the layer's metadata page, and under “Published content & settings”, select "Automatically republish when changes are made." You can set the refresh interval to, for example, 1 minute, but the actual refresh on your map may take somewhat longer because Google’s “Auto re-publish” isn’t quite "real-time".  Then do the following for the layer: Note that if you are geocoding by address (such as city/country, as I did above, or street address), the automatic refresh option is not available: To get around this challenge, I manually added the latitude-longitude values to my cities spreadsheet.  Thanks to the Measure tool in ArcGIS Online, this took less than 1 minute per city.  I simply typed in the city name in ArcGIS Online, and used the Location button under the Measure tools, clicked on the map where the city was located, and entered the resulting coordinates into my spreadsheet. For more information, see this blog essay.   Labels Higher Education Schools (K - 12) Tags (5) Tags: citizen science crowdsourcing google forms google sheets participatory mapping 3 Kudos Share 4 Comments by JosephKerski Esri Frequent Contributor ‎07-26-2017 05:52 PM Mark as Read Mark as New Bookmark Permalink Print Email to a Friend Report Inappropriate Content Important update!  Because of my experience with not being able to flip the ramp in the top 10 polluted cities map, our awesome development team added the Invert button in smart mapping. Now you don’t need to write an equation and have a legend from 0 to 1. See below.  Very useful indeed! --Joseph Kerski  1 Kudo by HaleyNelson New Contributor II ‎06-12-2018 01:48 PM Mark as Read Mark as New Bookmark Permalink Print Email to a Friend Report Inappropriate Content This is great! Will this process work in reverse? For example, will (or can) the google sheets be automatically updated if new points are added to the map, or attributes are updated in the web map? Is this a possible workflow? For example, can I connect a feature layer to a google sheet, collect data on that feature layer in Survey123, and have this data populate in a connected Google Sheet based on the web map refresh interval? 1 Kudo by deleted-user-0eS87ljx3Rcy New Contributor II ‎01-30-2019 09:49 AM Mark as Read Mark as New Bookmark Permalink Print Email to a Friend Report Inappropriate Content Anybody knows how to secure the published google sheets data? We want to bring the google sheet data to AGOL but google clearly states that data is not secured.  0 Kudos by FlorentBigirimana New Contributor III ‎05-27-2020 07:48 AM Mark as Read Mark as New Bookmark Permalink Print Email to a Friend Report Inappropriate Content I have created a google sheet with some records and managed to have the data from it on my web map as a web layer. One thing I was expecting is when values are updated form the google sheet, automatically the value is also updated on my layer in web map. However this is not happening. What am I missing ? 0 Kudos You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in. Comment About the Author I believe that spatial thinking can transform education and society through the application of Geographic Information Systems for instruction, research, administration, and policy. I hold 3 degrees in Geography, have served at NOAA, the US Census Bureau, and USGS as a cartographer and geographer, and teach a variety of F2F (Face to Face) (including T3G) and online courses. I have authored a variety of books and textbooks about the environment, STEM, GIS, and education. These include "Interpreting Our World", "Essentials of the Environment", "Tribal GIS", "The GIS Guide to Public Domain Data", "International Perspectives on Teaching and Learning with GIS In Secondary Education", "Spatial Mathematics" and others. I write for 2 blogs, 2 monthly podcasts, and a variety of journals, and have created over 5,000 videos on the Our Earth YouTube channel. Yet, as time passes, the more I realize my own limitations and that this is a lifelong learning endeavor and thus I actively seek mentors and collaborators. Labels Curriculum-Learning Resources 4 Education Facilities 28 GeoInquiries 1 Higher Education 324 Informal Education 191 Licensing Best Practices 1 Pedagogy and Education Theory 107 Schools (K - 12) 294 Schools (K-12) 4 STEM 1 Students - Higher Education 148 Students - K-12 Schools 1 Success Stories 1 TeacherDesk 1 Tech Tips 3 Terms of Use Community Guidelines Community Basics Privacy Trust Center Legal Contact Esri