250
Chapter 8 Getting There Quicker with Geospatial Technology
32. Locate both the South Rosemont Youth Library and the Oceanfront Area
Library.
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 10 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), but the free ArcExplorer
Java Edition for Educators does not. However, you can use the results from
the gpsvisualizer.com Website with AEJEE by converting the address points
into latitude/longitude coordinates and mapping those as points in AEJEE.
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 AEJEE
1. Open the VBCoords.xls file in Excel. Use Excel’s Save As option to save
the file not as a regular Excel file, but as a Comma Delimited (.csv)
file (in Excel 2007, this is available under the “Other Formats” options
in Save As). Call this new file GISlibraries.csv and save it on your
computer in the ‘Chapter8’ folder.
Chapter 8 Getting There Quicker with Geospatial Technology
32. Locate both the South Rosemont Youth Library and the Oceanfront Area
Library.
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 10 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), but the free ArcExplorer
Java Edition for Educators does not. However, you can use the results from
the gpsvisualizer.com Website with AEJEE by converting the address points
into latitude/longitude coordinates and mapping those as points in AEJEE.
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 AEJEE
1. Open the VBCoords.xls file in Excel. Use Excel’s Save As option to save
the file not as a regular Excel file, but as a Comma Delimited (.csv)
file (in Excel 2007, this is available under the “Other Formats” options
in Save As). Call this new file GISlibraries.csv and save it on your
computer in the ‘Chapter8’ folder.