Match Service

Match Service is a free offering from SafeGraph that lets you seamlessly integrate your existing POI data with SafeGraph’s enriched Places data. With it, you can deduplicate your own dataset, match two unrelated POI datasets, and enrich your data with SafeGraph’s data.

How It Works

  • Swing by our Shop and select Match from the menu.
  • Upload your CSV. Please make sure your CSV has headers and that any address information is broken up into columns for each of the individual components (e.g. street_address, city, state/region, postal_code, etc. should each be its own column) ✅.

  • ⚠️ If you have a file format other than CSV or your file is larger than 3 MB, contact us and we'll help you out 💁‍♂️.

  • Once you have uploaded your file, we will try to match your header names to ours auto-magically 🧙‍♂️. If our magic is having an off day (hey, even Dumbledore wasn't perfect), you can drag and drop the headers to fix any mistakes.

  • We will match your data to ours and show you a preview 🕶.

  • You can download your matched data with placekeys appended for free. You can also purchase our additional POI attributes (including polygons, visitation info, or good ol' normalized addresses 📬) and we will append those columns to your file.

  • Currently, the name and address features are doing a lot of the heavy lifting 🏋️‍♀️ in our match algorithm. So, if your file is missing both of those features, the match rate will likely not be very high 😢. We are working on improving this and appreciate any feedback you have.

Match File Column Ordering

  • The matched file returns all customer submitted columns in the same order as uploaded but with "customer_" appended to the front of each column name. Following the customer submitted fields are a few SafeGraph metadata columns indicative of the match results:
Column NameDescriptionTypeExample
other_match_candidatesA list of other possible match candidates given input information.Listsg:64d0ee4695af4ab4906fe82997ead9fx, sg:64d0ee4695af4ab4906fe82997ead9fz
number_of_candidate_matchesThe number of all possible matches given input information including the primary match provided.Integer3
warningsThe deficiency causing a match failure followed by the number of occurrences. Possible values are the following: INSUFFICIENT_MATCHING_FIELDS, MISSING_STREET_ADDRESS, MISSING_NAME, MISSING_POSTAL_CODE, MISSING_CITY, MISSING_STATEJSON {String: Integer}"MISSING_CITY": 12, "MISSING_STATE":9
is_closedIndicates if the matching POI is flagged as closed. If TRUE and core is selected, only core columns are populated. If TRUE and core is not selected, the "safegraph_place_id" column will read "closed_poi" and the rest of the columns are null. If FALSE, the POI is open and all columns are populated as expected. For more information on closed POIs, please reference the Core Places manual.BooleanFALSE
  • The column order following placekey (all match files include placekey) will vary based on the products selected. For Core, Geometry, or Patterns stand-alone downloads, please reference the column ordering in the Core Places Schema. For multiple product combinations, please reference the Column Ordering section in the Places Manual.

Match File Stats

  • A summary statistics table [stats.csv] is also returned for each matched file and reports the following metrics:
    • total number of rows
    • total number of matches
    • match rate
    • number of matches with more than one match candidate
    • percentage of matches with more than one match candidate
    • number of duplicate entries in the original file
    • fill rate per column
    • warning counts

Match File Names

  • Below is a breakdown of matched file names per product combination downloaded from the SafeGraph match service:

    • SGPID only: sgpid.csv
    • Core: core_poi-sgpid.csv
    • Core + Geometry: core_poi-geometry-sgpid.csv
    • Core + Geometry + Patterns: core_poi-geometry-patterns-sgpid.csv
    • Geometry: geometry-sgpid.csv
    • Patterns: patterns-sgpid.csv
    • Core + Patterns: core_poi-patterns-sgpid.csv
    • Geometry + Patterns: geometry-patterns-sgpid.csv

Did this page help you?