Forum Discussion
How do I get geographical data from 2 datasets to interact with one another?
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.
Memorable Membergenerically 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.
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.
