263
Geocoding and Shortest Path Analysis: ArcGIS Version
Question 8.9 What is the distance (and estimated driving time) of the route
between the South Rosemont Youth Library and the Oceanfront Area Library?
8.4 Preparing Geocoded Results for GIS Analysis
The next step of the lab will investigate how to use the GIS road files (like a
TIGER file) and these geocoded results in GIS.
Important note: ArcGIS has full geocoding capabilities, allowing you to
start with a table of addresses and create a point layer from them (without
having to use a Website to perform the geocoding). However, you can use the
results from the gpsvisualizer.com Website with ArcGIS by converting the address points into latitude/longitude coordinates and mapping those as points
in ArcGIS. The gpsvisualizer.com Website will report back the latitude and
longitude coordinates for all geocoded points. If so, it would be easy enough
to copy the full contents of the “Results as text” box into an Excel spreadsheet.
You would then have the addresses and their coordinates together in a file.
Also, the latitude and longitude coordinates for each point are stored in the
.kmz file you loaded into Google Earth.
1. Return to Google Earth, right-click on the GPS data .kmz file, and select
Copy.
2. Open a text editor utility like Notepad (in the Accessories folder in
Windows), and Paste the .kmz file there.
You’ll see the code that makes up the file, including the latitude and longitude coordinates for each geocoded point. You could make two new columns
in the original Excel table—one for latitude and one for longitude—and copy
and paste the coordinate information for each one into its proper place in the
table. It’s a longer way of doing things, but in the end you’ll have coordinates
for each geocoded address available.
For the purposes of this lab, a separate Excel file called VBCoords is available within the ‘Chapter8’ folder that has all of this done for you.
Important note: The latitude and longitude computed by gpsvisualizer.
com are decimal degree values.
8.5 Using TIGER Files and Geocoded Results
in ArcGIS
1. Start ArcMap. From the ‘Chapter8’ folder, add the tgr51810lka.shp
shapefile to the map (see Geospatial Lab Application 5.2 for the basics of
starting ArcMap and adding data to it). This shapefile is a TIGER 2000
file of the Virginia Beach road network.
2. Open the TIGER file’s attribute table. You’ll see it contains 19,026
records, each representing a link of the city’s road network. You’ll also
see the standard TIGER file information of address ranges, census
feature class codes, and so on assigned to each link. You can close the
attribute table for now.
Geocoding and Shortest Path Analysis: ArcGIS Version
Question 8.9 What is the distance (and estimated driving time) of the route
between the South Rosemont Youth Library and the Oceanfront Area Library?
8.4 Preparing Geocoded Results for GIS Analysis
The next step of the lab will investigate how to use the GIS road files (like a
TIGER file) and these geocoded results in GIS.
Important note: ArcGIS has full geocoding capabilities, allowing you to
start with a table of addresses and create a point layer from them (without
having to use a Website to perform the geocoding). However, you can use the
results from the gpsvisualizer.com Website with ArcGIS by converting the address points into latitude/longitude coordinates and mapping those as points
in ArcGIS. The gpsvisualizer.com Website will report back the latitude and
longitude coordinates for all geocoded points. If so, it would be easy enough
to copy the full contents of the “Results as text” box into an Excel spreadsheet.
You would then have the addresses and their coordinates together in a file.
Also, the latitude and longitude coordinates for each point are stored in the
.kmz file you loaded into Google Earth.
1. Return to Google Earth, right-click on the GPS data .kmz file, and select
Copy.
2. Open a text editor utility like Notepad (in the Accessories folder in
Windows), and Paste the .kmz file there.
You’ll see the code that makes up the file, including the latitude and longitude coordinates for each geocoded point. You could make two new columns
in the original Excel table—one for latitude and one for longitude—and copy
and paste the coordinate information for each one into its proper place in the
table. It’s a longer way of doing things, but in the end you’ll have coordinates
for each geocoded address available.
For the purposes of this lab, a separate Excel file called VBCoords is available within the ‘Chapter8’ folder that has all of this done for you.
Important note: The latitude and longitude computed by gpsvisualizer.
com are decimal degree values.
8.5 Using TIGER Files and Geocoded Results
in ArcGIS
1. Start ArcMap. From the ‘Chapter8’ folder, add the tgr51810lka.shp
shapefile to the map (see Geospatial Lab Application 5.2 for the basics of
starting ArcMap and adding data to it). This shapefile is a TIGER 2000
file of the Virginia Beach road network.
2. Open the TIGER file’s attribute table. You’ll see it contains 19,026
records, each representing a link of the city’s road network. You’ll also
see the standard TIGER file information of address ranges, census
feature class codes, and so on assigned to each link. You can close the
attribute table for now.