Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Is it possible to calculate trade are that spans multiple countries

asirisilva
5 - Atom

Hi,

With the availability of canadian spatial data, is it possible to calculate demographic values spaning accross both US and Canada ? For e.g. If I want to calculate population within 100 minutes from Niagara falls,Canada will it capture population from both US and Canada? or is it limited to one dataset ? 

 

Thank you in advance

 

-Kansas

2 REPLIES 2
HenrietteH
Alteryx
Alteryx

Hi asirisilva,

 

The Tom Tom drive time data is separated into two data sets, one for Canada and one for the US, so you'd have to create two trade areas and then combine them. 

 

Here is an example (I used the Niagara Falls Post office at 4500 Queen St as the centroid). 

100 mins drive time Canada on the left and 100 mins drive time US on the right: 

10-5-2016 10-14-58 AM.png 10-5-2016 10-15-09 AM.png

 

Using the Summarize tool's Spatial Combine functionality, they are combined to one polygon: 

10-5-2016 10-15-22 AM.png

 

 

If you are calculating your trade area based on distance, it will cross borders and you only have to create one radius. 

 

 

To append demographic values, you can take a similar approach. Once you have your two polugons, you can use them to pull the demographic information and then combine everything together to get a full report. 

 

 

Henriette Haigh
Technical Product Manager - Data Connectors
Alteryx, Inc.

asirisilva
5 - Atom

This is great. Thanks

Labels