This data set happens to have “latitude” and “longitude” columns!
Let’s add the data to our ArcGIS map using the normal “Add data” box.Now we will right click on the data and go to Display XY DataYou should edit the coordinate system to be WGS 1984
The dialogue box should be as follows:
Click OK and the points should show up!
In order to use the points, you then have to export the points as a shapefile:
Now you can change the symbology:
Keep these points for the next scenario!
Scenario 2: Join based on unique ID
Say you have new data only based on city names, how would you join it?
Add the uswalkscore.csv file to our ArcMap project.
Now right click on the shapefile from the previous exercise and click Join and Relates and then Join. (Remember!! This can work with other data that already has spatial information, like states or countries)
In the following dialogue box, make sure to select “City” for the field that the join will be based on. Then choose the “us_pop” layer and select the “City” field.
For Join Options, select “Keep only matching records” so that the resulting shapefile contains just the data we connected.
Your dialogue box should look like the following:
Now you can map your data by using the walk score:
Scenario 3: Locate data based on addresses (geocoding)
The last way to add data is to geocode, because there are now price limitations with geocoding, one simple but midly inaccurate way to geocode is using UCLA’s own geocoder:
How to add your data to ArcGIS
Scenario 1: Point data exists in csv format
Download and open the following “uspop.csv” file.
This data set happens to have “latitude” and “longitude” columns!
In order to use the points, you then have to export the points as a shapefile:
Now you can change the symbology:
Keep these points for the next scenario!
Scenario 2: Join based on unique ID
Say you have new data only based on city names, how would you join it?
Go ahead and download the uswalkscore.csv file.
Notice that there is no latitude or longitude.
Add the uswalkscore.csv file to our ArcMap project.
Now right click on the shapefile from the previous exercise and click Join and Relates and then Join. (Remember!! This can work with other data that already has spatial information, like states or countries)
For Join Options, select “Keep only matching records” so that the resulting shapefile contains just the data we connected.
Your dialogue box should look like the following:
Scenario 3: Locate data based on addresses (geocoding)
The last way to add data is to geocode, because there are now price limitations with geocoding, one simple but midly inaccurate way to geocode is using UCLA’s own geocoder:
http://gis.ucla.edu/geocoder
You can see the formatting requirements for UCLA’s geocoder which mandates that specific columns have to be in a particular order.
Once geocoding is done, you can save it as a csv file.
Here is an example of saving it out:
https://sandbox.idre.ucla.edu/Workshops/geocodeexample.csv
Then add the latitude/longitude as XY coordinates, just like in the first scenario.