Location Data Knowledge Base

Data methodologies, and Release schedules.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
  Data package documentation for the Q1 2018 data releases may be downloaded from the links below...   US Data: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_US_Data.zip CA Data: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_CA_Data.zip US Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_US_Spatial.zip CA Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_CA_Spatial.zip UK & ROI Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_UKROI_Spatial.zip EU Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_EU_Spatial.zip AU & NZ Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_AUNZ_Spatial.zip BR Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_BR_Spatial.zip   Please note that documentation packages are also included with the download from  licenses.alteryx.com  and the external hard drive (US Data or Canada Data)
View full article
  Data package documentation for the Q2 2018 data releases may be downloaded from the links below...   US Data: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_US_Data.zip CA Data: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_CA_Data.zip US Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_US_Spatial.zip CA Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_CA_Spatial.zip UK & ROI Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_UKROI_Spatial.zip EU Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_EU_Spatial.zip AU & NZ Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_AUNZ_Spatial.zip BR Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_BR_Spatial.zip   Please note that documentation packages are also included with the download from   licenses.alteryx.com and the external hard drive (US Data or Canada Data)
View full article
Hi all,   Effective with the Q4 2018 data releases, the base URL referenced in the .map files that render DigitalGlobe Satellite imagery is changing from dgmaps.alteryx.com to whitelist.alteryx.com/v1/dgmaps/v1. This change was made to align with our System Requirements. As we already recommend that customers have whitelist.alteryx.com listed as a safe site, we don't expect this to impact our customers.   Customers can still use the Q3 2018 DigitalGlobe data if they run into network issues. Any network-related issues should ultimately be resolved by whitelisting whitelist.alteryx.com.   Regards,   Jerad Rades Team Lead, Data Products
View full article
This post pertains to any user that downloaded the US Spatial (Q4 2018) package from the Downloads & Licenses portal between the initial release on Wednesday, February 20th, and ~1:30pm EST on Friday, March 1st. You'll know that you have the outdated download package if you do not see 'TomTom US Q4 2018' on the 'Install' screen under the 'Drivetime Datasets' section.   The initial package did not contain the TomTom US Q4 2018 Drivetime data (Guzzler). Should users require the Q4 2018 US Drivetime data, they'll need to download the updated package and rerun the install. Fortunately only a portion of the install needs to be executed unless a Network Install was used. After downloading and extracting the updated package, you can upgrade the TomTom US Q4 2018 Drivetime data with the following steps (for local installation).   Run AlteryxDataInstall.exe and select 'None', then only select the Drivetime dataset. Uninstall TomTom US Q3 2018 if desired. Finish the installation as usual and be sure to restart Designer to refresh the list of available data sets. For customers that utilize the Network Installation process, the simplest approach would be to prepare a full network install in a new location, then ask users to uninstall the entire data package and re-register from the new location (as the registration process is quick to execute).   We apologize for the inconvenience. Please feel free to post questions below.   Jerad Rades Team Lead, Data Products
View full article
You just reverse geocoded latitude/longitude coordinates, now you need structured address fields, right?
View full article
How to troubleshoot when the Allocate Append tool returns zeros. 
View full article
 Unfortunately at this time, non-U.S. and Canadian geocoding is performed via API calls, and as such, requires an Internet connection.
View full article
The option to be able to search a field with wildcard characters is often needed. This functionality within the Calgary suite of Tools can be accomplished by having a “Contains” function, where this is accomplished without utilizing a wildcard to search. This also allows you to be able to use the Indexing power that the Calgary products offer, without having to do these searches with downstream functions like Filter or other Formula based tools. Tools used: Here's how 1) Create a base cydb file with this option selected: 2) Once the base file has been created, you now want to modify that cydb file to enable the Fields you want to query with the “Contains” option. In this example dataset, we want to be able to do these type of queries for the “CONAME” and “ADDR” fields:   Setup Calgary Input into Calgary Loader, when the following message will appear. Make sure you check “Yes”               3) Select the “Load a single advanced index” option   Set the Index Name you would like (in this case, keeping the same name), and choose the field desired from the “Source Field”.  Also, set Advanced Index Mode to Full Text     4) Repeat this process with all of the fields you’d like to be able to search.  In this sample, placing “mail” in the CONAME and “ln” in the ADDR fields returned this record:
View full article
What to do when you see the "CASS engine appears to not be installed" error.
View full article
Mosaic BG Dominant and Mosaic BG Household Distribution counts are balanced to Experian’s census estimates.  ConsumerView is a marketing file and therefore doesn’t need to be balanced to the census estimates.
View full article
Do you pull in demographic variables from the Allocate toolset and then use a formula tool for some basic math functions on those variables? Summing them together for example?
View full article
Ever wonder about the “behind-the-scenes” calculations of Alteryx’s drive times?  How does Alteryx know how long it would take to travel from Point A to Point B?  This post explores the “speed” variable used to calculate Drivetimes.
View full article
Greetings Alteryxians!   The Q1 2019 Business and Location Insights data packages were released today. The packages include analytics-ready data from a variety of vendors as well as data-specific analysis tools to get the most from the packaged data. All data packages are available via the Downloads & Licenses portal; US & Canada Business Insights customers should receive their hard drives later this week, but you are also welcome to download the data from the portal.   Here are a couple important notes specific to this release. Please see the product specific documentation for more details. US & Canada: Install now only includes country specific CASS dataset (i.e., US Business Insights will only install US CASS by default) Canada: Forward Sortation Area data was not updated due to vendor source issue. The vendor confirmed there was no change from Q4 to Q1.   All documentation packages are included in the attached .7z archive. As a side note, our team is working on content to help customers get started with their Insights packages. If you haven't already, be sure to take a look at some of the recent articles in the Location Data Knowledge Base regarding things like installation, mapping, and many more to come! Shout out to @TravisR for his work!   Feel free to add any questions in the comments below.   Jerad Rades Team Lead, Data Products
View full article
Hi everyone!   The Q4 2018 Business and Location Insights data packages includes analytics-ready data from a variety of vendors as well as data-specific analysis tools to get the most from the packaged data. All data packages will be available via the Downloads & Licenses portal later today. US & Canada Business Insights customers should receive their hard drives later this week, but you are also welcome to download the data from the portal.   Here are a couple important notes for this release. Please see the product specific release notes for more information. Product name change (does not affect product contents): US and Canada "Data", which includes demographics, business lists, etc., are now called "Business Insights" All "Spatial" packages are now called "Location Insights" DigitalGlobe Satellite Maps base URL changed to whitelist.alteryx.com/v1/dgmaps/v1. See this post for more details.   All documentation packages included in the attached .zip file. Please let us know if you have any questions or concerns.   Happy Alteryxing!   Jerad Rades Team Lead, Data Products   Note that this post includes a corrected version of the US Data Variable List that was not included on the hard drive or via the Downloads & Licenses portal. The correction corresponds to TrueTouch variables within the ConsumerView dataset - there were no new variables with the Q4 2018 release. 
View full article