Geocode

From PeaceTech Wiki
Jump to: navigation, search

Top contributors to this page: DerekPeaceTech

Logo
To find an image, do a Google image search of the tool. Find an image about 600px wide, if possible. Copy the image URL and paste into the box below.
knCByiM.png
Name
What is the name of the tool?
Geocode
Tool Class
To what "family" does the tool belong? Pick as many categories as are appropriate. EG: Data Collection, Security, etc. The wiki will automatically create a link to the relevant tool class.
Geocoding, Mapping
Developer
Who made the tool? Sometimes the tool name and the developer name are the same, and sometimes, they are different.
Awesome Table
Date Created
What was the date when the tool was first launched?
Still Maintained?
Do the developers of the tool continue to work on it, adding features and fixing problems?
Yes
Open Source?
Is the tool's source code original source code freely available and may it be redistributed and modified? (This makes it possible for users to employ the tool for free, with some technical effort.)
No
Platforms
Pick the platforms on which the user would primarily use the tool. Be as selective as possible. If a tool works mainly in the browser, select "Web". If the user can technically load the interface on a smartphone but have a very poor experience, do not select "Android" or "iOS". "Mac" and "PC" are for apps that must be installed to a machine in order to run, as opposed to running from a browser.
Web
Website
What is the main website where a user can learn more about the tool? (Remember to include "http://)."
https://sites.google.com/site/scriptsexamples/available-web-apps/awesome-tables/add-ons/geocode
Payment Structure
How, if at all, does a user pay to use the tool. Select all that apply: "Free" if there are components of a service that can be used for free; "Paid" if payment is required (either one-time, or at a given rate upon use) for use of the tool's full functionality; "subscription" if a monthly payment is required.
free
Languages Supported
What languages does the app's interface support? Note: some apps allow users to communicate in other languages but require the user to use an English language interface. In this case, the app is considered only to support "English".
All
Skill Level Needed
*
  • Beginner - The tool has a simple interface that assists the user, either through automatic processes or simple guides, in working with the tool. The user is able to do most things that they need to do without knowledge of advanced concepts, like code.
  • Intermediate - The tool allows the user to perform many tasks without knowledge of advanced concepts, but about an equal amount of functionality requires advanced knowledge. Some training may be required to use the tool.
  • Advanced - The tool requires advanced knowledge or training in order to use most of its functionality.
Beginner

Tool Description

Geocode is a Geocoding plugin for Google Sheets that provides latitude and longitude coordinates for addresses. After geocoding, the add-on automatically creates an map view for that displays markers on a map for each row of the spreadsheet and adds filters on top of this map.

8Rj5Vtc.jpg

What Makes This Tool Different from Others in its Class?

Geocode, like Batch Geocoding, provides latitude and longitude coordinates for addresses. Geocode is specifically a plugin for Google Sheets, whereas Batch Geocoding requires the user to copy and paste into an online form. Geocode has no limit of queries that can be processed. Gecode can be slow to process large datasets.

Links to Tutorial Content

Developer Instructions

1. Open a spreadsheet through Google Drive (Geocode also works perfectly with previously created sheets)

2. Add physical addresses and other information to the Sheet

3. Go to the Chrome Web Store with the menu Add-ons > Get Add-ons… and install Geocode

4. Select the menu Add-ons > Geocode > Start Geocoding

5. Select your source sheet Geocode automatically recognizes existing sheets’ names, column headers and can determinate the type of each category of data (strings, numbers, dates…)

6. Select the addresses column

7. Click "Start Geocoding"

8. After it's geocoded, click on “Create a map” to display it.

Other Resources

Projects that use this tool