Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Intersection Tool

GayatriPanigrahi
8 - Asteroid

Hi Team,

 

Input1 consist of parking lots data of country and each needs to cover 15 mile radius of its location. Input2 contains the boundary point of area. Need to calculate percentage of area that has its parking needs covered.
Seems something wrong in intersection calculation.

Attaching Alteryx workflow

 

 

7 REPLIES 7
DataNath
17 - Castor

Hey @GayatriPanigrahi, not sure if I'm reading into this wrong but if you want to see how much of the area is covered, because the buffer of each parking zone is so large, surely this will just be 100%? If you combine the spatial objects created by the buffered parking lots, you see the area completely engulfed and can then add the standard tools to prove it afterwards:

 

DataNath_0-1657136082033.pngDataNath_1-1657136104596.png

GayatriPanigrahi
8 - Asteroid

@DataNath 

Need to calculate intersection of area coverage on the county.
Which i found is quite similar to Challenge #51 but not sure what is wrong in intersection.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-51-Spatial-County-Coverage/td-p/40313

GayatriPanigrahi
8 - Asteroid

Any update ?
What's wrong in the intersection ? as the coverage is showing 100% instead common overlap.

DataNath
17 - Castor

Sorry @GayatriPanigrahi had forgotten about this. What are you expecting in the output? Because of how much of a buffer there is, the majority of parking lots provide full coverage and even the outer ones at least touch a tiny bit - you can see this if you look at the coverage on browse and in the % covered results.

 

DataNath_0-1657717718902.pngDataNath_1-1657717737229.png

 

I've attached my Challenge 51 solution in case that helps but if not, could you perhaps provide some additional information/a clearer explanation of what you're expecting?

This was a question in Alteryx advance and its not 15 miles it should be 0.5 miles

Simon_St
5 - Atom

@ersiddharthsingh1412 is right, the wrong value is entered there. Radius should be 0.15 miles.

madankumar8707
5 - Atom

Also, the formula should be reversed as [AreaSqMi]/[Source_AreaSqMi]*100

Labels