Portugal Summit has ended
Back To Schedule
Sunday, November 30 • 9:40am - 10:40am
The magic of Google mapping: Geocoding Google Spreadsheet

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Temos no nosso imaginário a colocação pins nos mapas quando queríamos identificar países, localidade ou ruas. Isso foi os primórdios do Geocoding. O que se pretende nesta sessão prática é mostrar a potencialidade das ferramentas de geocodificação a partir de uma folha de cálculo da Google Spreadsheet onde, a partir de uma simples lista de moradas, conseguimos calcular automaticamente distâncias, tempos de viagens entre dois pontos (escola e endereço dos alunos, por exemplo) e respetivas coordenadas geográficas. Por último, haverá o mapeamento dinâmico da SpreadSheet através das ferramentas disponíveis em Google My Map, criando mapas temáticos.
We have in our imaginary placing pins on the maps when we wanted to identify countries, towns or streets. This was the beginnings of Geocoding. The intention in this practice session is to show the potential of geocoding tools from a Google Spreadsheet where, with a simple address list, we automatically calculate distances, travel times between two points (school and student’s address, for example) and respective geographic coordinates. Finally, there is the possibility to do a dynamic mapping of SpreadSheet through the tools available on Google My Map, creating a thematic map to show the pins in the Google maps.

avatar for Luis Antunes

Luis Antunes

Training Consultant : Google Earth na Sala de Aula, GEOEduc
Luis Antunes is a Geographical Engineer and have a Master in Georesources. Have more than 300 hours of teacher training in various areas of Geographical Sciences, like GIS Opensource and Google Earth. Now a days, he works in the Madeira's Regional Health Service in spatial modeling... Read More →

Sunday November 30, 2014 9:40am - 10:40am WET
Room W108 St. Julian's School - Quinta Nova 2775-588 Carcavelos, Portugal

Attendees (0)