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.
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: