Using the Intersect Function in Tableau for Spatial Analysis | New in Tableau 2022.4
Вставка
- Опубліковано 22 лип 2024
- In geospatial analysis, the intersect function is a powerful tool used to identify the areas of overlap between two or more spatial objects, such as points, lines, or polygons. These objects can represent cities, roads, or census tracts, among other things. The intersect function takes these objects as inputs and outputs a boolean object that represents the area of overlap, essentially true or false. You can imagine it as an imaginary polygon where the two match. This function can be used for tasks such as identifying common features between different datasets, aggregating data at the intersection of regions, and creating thematic maps that show the overlap between spatial data sets. In Tableau, intersect can be combined with other functions and visualization techniques to create interactive maps and charts that help users understand and analyze geospatial data.
Timestamps
0:00 Intro
0:26 Connecting to data
2:03 Creating some points of interest
4:25 Splitting our text to get latitude and Longitude
9:19 Creating our buffer Polygon to intersect
12:06 Creating points for our trees
14:31 Using the intersect function in Tableau
18:50 Some quirks to watch out for
Join this channel to get access to perks:
/ @tableautim
#tableau #salesforce #analytics #data
Follow me on Twitter: / tableautim
My recording gear & what's on my desk. kit.co/TableauTim/desk-setup
My website: www.tableautim.com/
My Screen Annotation Tool: j.mp/3HWc4Mj
My technology Channel: j.mp/3F0d28f
Share feedback and Suggestions: tableautim.canny.io/suggestions ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.
Hi Tim, thanks for this. Instead of using data blending, you could simply use the Relationships (join your two data sources on 1=1). Then the intersect should work without the 'parameter workaround'. I haven't tested. Just a thought. cheers!
Absolutely more videos next week ;) I realised i nmakig this video i give the impression that there's only one way to do this. You can also use the normal intersect join options with a left right or full outer join to do the same thing. All of these work. Pinned your comment so others see it. Thanks for mentioning!
Thanks for diving into this! Loved the LinkedIn note at the end. Made my day Tim. (On a tough day for a Tableau guy)
Great video. Lots of interesting uses. You did a great job explaining the entire process
Glad it was helpful!
Great video Tim. I worked on a project last year with spatial intersects using address data. This function would have been super useful then to limit the number of marks. Thanks for sharing.
Great suggestion of a use case there too! The intersect Function works a sa filter so no need to build a map necessarily to limit the data.
Great examples, Tim 👏
Thanks! 😃
You are the best
Wow
für mich war sehr interessant
Danke
Love this. Thank you.
Glad you enjoyed it!
Thank you for sharing 🙂
My pleasure 😊
You can grab the tree census fo your self and follow along here: data.cityofnewyork.us/Environment/2015-Street-Tree-Census-Tree-Data/pi5s-9p35
This is a great video. ;)
Kent !
Hi Tim, this is an awesome video, thanks a lot for creating it. I started to work with the Geospatial files recently and I often I have a use case where I download a shapefile of a specific geography (Data source 1) and then, via another data source (2) I bring in Points Of Interest with their Lat & Long and bunch of other info, the second data source is a simple table or a SQL connection. These two data sources don't have (to my understanding) anything to relate by so I do left outer join and I overlay the points on the map, so far so good.
But, can I use the LAT & LONG info to filter outside / outside of the shapefile using the coordinates only? I mean, the intersect function would only work with two shapefile data sources right? If I have one shapefile and a table with lat,long data, will I be able to intersect in any way?
yes. use the makepoint () function to make lat longs a point and then Intersect them that way
nice job Tim. the issue with Empire State Building offset, it is not because you typed in 2 x Lat and 2x Long in the parameter list? you then use Long and Lat directly from the parameter without any detail, I thing both of them get aggregated into one mark and that is why the Empire State Building is not in the exact point as the one in the map. Maybe I am wrong
This did cross my mind after the video and i checked but the parameter only feeds one value to the list at a time. Even with min or max the location stays the sameas the avg. 1 data point, 1 row of data.
¿Why when I create the calculated field intersection I just have the false? So it doesn’t show me the trees
I have longitude and latitute in the data as none, both fields are as number (decimal) and latitude/longitude
Not sure why I can't see the INTERSECT function even when I have the latest version of Tableau Desktop 🤔
Should be under spatial. In the calculation section.
@@TableauTim I'm having the same issue, i'm using student free version