Skill Drill: Geocoding an Address  and Creating a CSV Table to Import As XY Data

The Eureka Garbage Dump will be used in the vehicle routing model as a place where the route will begin and end. It will also serve as the location for route renewals. Without a route renewal, the garbage trucks will eventually fill to capacity. At this point, the route will end whether or not all of the locations have received service. By adding a route renewal location to our model, the garbage trucks will navigate back to garbage dump, unload the cargo, and then continue to service the next business on the route.

The Eureka Garbage Dump is located at the following address:

1059 W Hawthorne St

Eureka, CA 95501

Use Google Maps or another online service to geocode the address and obtain the latitude and longitude values for this address in decimal degrees. Many websites will geocode a single address for free. Be sure to find out which spatial reference system the website uses to generate the decimal degree values. The most common spatial reference on the web is WGS 1984. In Microsoft Excel, create a CSV table with the following field headers: name, latitude, longitude. You may use Eureka Garbage Dump as the name attribute for the route renewal. Enter the latitude and longitude values in the appropriate fields. Save as a CSV table and close Excel.

Name Latitude Longitude
Eureka Garbage Dump  40.xxxx  -124.xxxxx

In ArcMap, add the CSV table as XY data, using the same workflow as for the businesses above. Use the Project tool if necessary. In the end, you should have a shapefile of the Eureka Garbage Dump using the NAD 83 UTM Zone 10 spatial reference system.

An image of the Garbage Dump layer added to ArcMap.
The Eureka Garbage Station is indicated here as a black square.