cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
daniwill882
Frequent Visitor

How do I get geographical data from 2 datasets to interact with one another?

Hi there,

 

I'm currently creating a hotspot mapping dashboard, which identifies a hotspot area from crime data and then presents a breakdown of data which shows the issues in that specific area. To do so I am using the Arc GIS add in to create the hotspot map, with lat and long as data points, and then using the select multiple locations option to highlight a 'hot' area. I have several visualisations relating to the data in the same dataset which interact perfectly when a smaller area of the map is highlighted. 

 

I have an additional dataset with the address and lat/long of all the schools in the city and was hoping to use the 'card' visualisation to show how many schools are within the hot area when selected. So far, this visualisation fails to change when an area is selected.

 

How do I make a relationship between these two datasets to make this type of interaction work? I'd really appreciate any help you can give me.  

1 ACCEPTED SOLUTION
CahabaData
Memorable Member
Memorable Member

generically speaking: to link (join) 2 data sets there must be a field in both that will have an identical value - and further 1 of the data sets must have no repeating values.  If that doesn't exist then one must create that table to have a list of unique values and then link it to the two tables.

 

but I think what you want is to put the school records into the crime records so they are 1 table , they will all get mapped as data points - and then figure out a techique to identify a school data point so it has a different style display and stands out and doesn't display as just another crime point.  Assuming your table layouts are sufficiently similar - you can append one into the other - or both into a new table.

 

 

www.CahabaData.com

View solution in original post

2 REPLIES 2
CahabaData
Memorable Member
Memorable Member

generically speaking: to link (join) 2 data sets there must be a field in both that will have an identical value - and further 1 of the data sets must have no repeating values.  If that doesn't exist then one must create that table to have a list of unique values and then link it to the two tables.

 

but I think what you want is to put the school records into the crime records so they are 1 table , they will all get mapped as data points - and then figure out a techique to identify a school data point so it has a different style display and stands out and doesn't display as just another crime point.  Assuming your table layouts are sufficiently similar - you can append one into the other - or both into a new table.

 

 

www.CahabaData.com

View solution in original post

Thank you! This worked perfectly. I appended the two tables and added a column to state whether it was crime data or schools data, then made this the legend in the map.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.