I know how to join things, but only when they both have matching fields. I have created my own fields before as well, but only when I have had small datasets (less than 100), so it was practical for me to fill in each field by hand.
Now I have the parcelbase data for Saint Louis City (over 128,000 parcels), and the March 2017 crime .csv data from SLMPD (approx 4,000 crimes in March 2017). Both the parcelbase and SLMPD data have addresses, but they have them in different formats (one has street and the other has street direction and street - ex: Field St vs N Field St), so I can't join them since they won't match up in Validate. The second problem is the addresses are two fields each - the address number (ex, 5400) and the street name (ex, Field St), and I don't know how to join based on matching two fields instead of just one.
My boss thinks this isn't something that can be done with Join at all (and I agree), but neither of us know how to match them up otherwise. I do have X Y coordinates for the SLMPD data (not for the parcelbase, but the parcelbase is projected to _1927 and the SLMPD is just an attribute table from a .csv file).
Is this a Georeferencing thing?
How do you do one of those?
If it is not a Georeferencing issue, does anybody know what it is that I need to do to combine these two things?
We want to visually map crime in Saint Louis City for March 2017.