App Icon
Placekey
•  80
Overview
Solve difficult problems with address and POI matching, address normalization, validation, deduplication, and entity resolution with Placekey's free and open universal identifier for a physical place.
Ready to match addresses? Quick start video guide: https://www.youtube.com/watch?v=kMAHCQXfliw

Placekey is a free and open standard universal identifier for any physical place. For every address you have, our add-on generates a Placekey in a new column right inside of Google Sheets, without needing to wrie a single line of code. Placekey is smart: it can tell that differently-formatted addresses are the same (i.e. "Suite 261" vs. "Ste. 261" vs. "#261"), which lets you easily merge disparate data sets. This Add-on exposes the full functionality of the Placekey API in order to quickly add Placekeys to your address and geocoding data, right from Google Sheets.

How can I use Placekey? 

Placekeys solve a number of common problems for data scientists. As a unique identifier for any physical place, Placekey simplifies the process of joining both POI or non-POI datasets. Placekey also reveals relationships between POIs and addresses, providing details such as proximity, co-tenancy, and POI history. Even places without addresses can be appended with a Placekey.


Placekey Details:

Each Placekey is divided into two parts: What and Where, written as “What@Where”. The What part encodes information about the place and its address, while the Where part situates that place on Earth. The What part of a Placekey is optional, and a Whatless Placekey like “@5vg-7qg-tvz” refers to a region on the Earth while a What part plus a Where part specifies a particular place within a region on the Earth. The Where part of a Placekey encodes a hexagon of approximately 15,000 m2 on the surface of the Earth. These hexagons have an edge length of 66 m on average, and it can be helpful to think of them as roughly circles with a diameter of 132 m. The exact area and edge length of the hexagon varies by location. In particular, these hexagons are given by resolution 10 H3 indices.

Full instructions and documentation can be found here:
https://docs.placekey.io/#b02e2799-21ea-43af-b5ee-922dc4bdd164
Reviews
Language:
Sort by:
Profile Picture
Ravi Patel
January 14, 2021
super easy to match and join location data...life changer!
Is this review helpful?
Yes
No
Profile Picture
John Yeung
January 5, 2021
great add-on for joining location datasets
Is this review helpful?
Yes
No
Profile Picture
Sophie Marconi
January 4, 2021
I love this!! So helpful and makes matching addresses and POIs a breeze.
Is this review helpful?
Yes
No
Profile Picture
Lauren Spiegel
January 4, 2021
works great. saved me a lot of time joining poi datasets.
Is this review helpful?
Yes
No
Profile Picture
Bryan Bonack
January 4, 2021
Super easy no code solution. Was also speedier than I had expected.
Is this review helpful?
Yes
No
Profile Picture
Ryan Chang
January 4, 2021
Super intuitive, especially for folks like me that are not very technical
Is this review helpful?
Yes
No
Profile Picture
Jonathan Wolf
December 3, 2020
This was actually super easy to use, and the tool did a great job of reminding me that I was trying to add Placekeys to an empty sheet :)
Is this review helpful?
Yes
No
Profile Picture
Karissa Paddie
November 30, 2020
Godsend for anyone trying to normalize addresses who isn't super technical. Worked perfectly.
Is this review helpful?
Yes
No
Profile Picture
Stu Kendall
November 17, 2020
Installed in seconds and really easy to use
Is this review helpful?
Yes
No
Profile Picture
Roshan George
November 16, 2020
Quick and easy to use.
Is this review helpful?
Yes
No
1-10 of 17
Additional information
Placekey
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu