I have two tables, a Census tract table with population numbers and a table with student information (but no addresses).
I need to combine the tables to make graduated color maps, such as the average GPA per tract and many more.
The only field that I can see using in the Census tracts table (the only field with distinct values per row other than the Object ID, length and area fields) is the GEO_ID field of tract numbers (there are multiple sets of tracts with the same numbers).
However, this is not in the student info table (neither are the others). We received the student data already geocoded (so we wouldn't have to see the addresses for privacy rights).
When I did a spatial join of the student table to the Census tract table, it gave me a Count per tract field (of course), but removed all of the student data.
I did a Reverse geocode, but the values I got were not the same as the GEO_ID values in the other table (The Address Locator I used was the default MGRS).
I have linked the two attribute tables as .xls files: https://www.dropbox.com/s/em696y77h8c601m/EnrollmentTracts.xls?dl=0 https://www.dropbox.com/s/yz2e4j532zrq5rz/FallStudents2015_Projected_Clipped.xls?dl=0
Do you have any suggestions as to how I can do this?