Location Data Knowledge Base

Data methodologies, and Release schedules.
The Q3 2021 Business and Location Insights data packages are now available to plug into your analytic processes. The packages include analytics-ready data from a variety of vendors as well as data-specific analysis tools which will empower users to get the most from the packaged data.
View full article
We have identified that the Census information for this data is partially updated with 2020 Census data and IDs. Here we present two solutions for those using Census ID with Allocate using either Spatial Match Tool or our new US_2010CensusID_Geocoder Install containing Census IDs from Q1 2021 package.
View full article
Have you ever used the Allocate tools and received back some strange looking variable names? You're not alone! The Allocate Rename Fields Macro will allow you to rename your fields into readable variables.
View full article
We have identified an issue with the Consumer Expenditure variables defined in the VVF files installed with the Q2 2021 Experian US Allocate dataset, specifically Current Year Estimates (2021) - Total Expenditure (TCTOTALEXP) and Five-Year Estimates (2026) – Total Expenditure (TFTOTALEXP).
View full article
The Data Products team has identified the deprecated field CASS_StatusCode included in the US and Canada Dun & Bradstreet Analytical File.  This field will be removed for the Q3 2021 Business and Location Insights release since the field had been replaced with CASS_ErrorCode long ago. We are making this post to notify any users currently running workflows referencing CASS_StatusCode so they can adjust their workflows before this update.   
View full article
The Q2 2021 Business and Location Insights data packages are now available to plug into your analytic processes.
View full article
Because most Calgary Databases (files with .cydb extension) contain millions of records with hundreds of fields, a method for allowing a user to quickly determine which records to read is available. 
View full article
This article will walk through the Network data installation process and is intended for Admins.
View full article
This article will walk through the standard data installation process.
View full article
This article focuses on one key area of our Location Insights products – Maps. I'll use the US Location Insight product for this example, but all of our international Location Insight products are functionally the same unless I call it out specifically as a unique part of the US package.
View full article
We’ll cover getting you started with spatial data and more using the Drivetime Data available with each Location Insights package in this article.
View full article
The DNB 2019 Q4 Analytical File in the Calgary Input tool reads the DNB 2019 Q3 dataset.
View full article
Have some Latitude/Longitude points and not much else? Working with Spatial Objects and need more information than a simple map point? Time to call in the Reverse Geocoding macro. Reverse Geocoding can give some robust information to help make important business decisions when working with spatial data. Case in point: Your “friend” has hacked the Pokémon Go APK and hands you a list of Pokémon with the associated Latitude/Longitude. You can’t make an informed decision on your next weekend Poke-session without first understanding more than just the location on a map!
View full article
Occasionally someone asks the question, “how many businesses have ACTUAL YEAR STARTED” (or referenced another field) and you have no idea how to respond. You looked in the quarterly Variable List and didn’t see the answer. Now what? You could run a query in Alteryx but should you?
View full article
I have CAPE installed and a newer version of a VGF (with updated names) is available in a new install. I uninstalled that version of the data, ran the new install but the old VGF names are still visible. I reran the install twice. What am I doing incorrectly? I notice when I run the install, the process happening more quickly than usual.
View full article
This note is to alert users of Alteryx 8.6 to 10.1 of a potentialmessage window that may appear after updating the US andCanadian CASS engine.
View full article
CAPE Consumer Expenditure and Retail Demand.  How are they different?
View full article
I'm using data from Alteryx.  How do I correctly reference the source?
View full article