
Introduction to
Geographic Information Systems in Forest Resources |
Exercise: Importing Data
Objective:
- Download GIS data from the web and import to ArcView.
- Find information about data sources by using the National Spatial Data Infrastructure
Clearinghouse.
- Set up your directories
- Download and import data from the USGS GeoData web
site
- Find GIS data on the web, download and import
- Search the NSDI Clearinghouse
- Download SDTS DEM data
- Convert SDTS DEM to USGS DEM
- Import USGS DEM
- Download SDTS DLG data
- Convert SDTS DLG to DXF
- Convert DXF to shapefile
- Get and view USGS DRG data
- Convert SDTS DLG to ArcInfo coverage
Set up your directories
- Open the Windows Explorer to your Zip disk.
- Create a directory called grand_coulee. Within the grand_coulee
directory, create a directory called masterdd and another directory
called data. Your file system layout should look like this (with the
drive letter for your Zip drive):
- Start the Microsoft Internet Explorer (do not use Netscape).
Download and import data from the a USGS web site.
- Go to the
USGS page for download of physiographic data.
- Download the Physiographic regions data set (physio.e00.gz) set
into your working directory. (If the site is down, retrieve this
copy.)
- Download this copy of the gzip compression utility,
and place it your working directory (or use the one on CD:\unix).
- Open a command prompt (Start > Programs > Accessories > Command
Prompt).
- Use the commands shown below to change drives and to unzip the gzipped file.
- Start ArcView.
- From the Windows Start button, navigate to the place where you normally
start ArcView. You will find Import71 in the same place. Start Import71.
- Enter the full path names of the files in the dialog, or use the Browse
button for the Export File and the Output Data Source directories.
Note that if you browse to an Output Data Source directory, you will
still need to enter the name of the data set you wish to create. In this example,
the new data source will be saved in D:\, but the data source will
be called physio. The Output Data Source does not need to have
the same name as the export file, but it is customary to call the output data
set by the same name as the interchange file. In any case, there is a 13-character
limit on the file name of the output data (do not use spaces, either!).

- Click OK.
After the import completes, the utility will report a completion:
- This creates the theme specified in the Output Data Source.
- Add this theme to a view. Note that because this is an ArcInfo coverage
data set, it does not have the .shp file extension.

- ArcInfo coverages (if built properly) will have projection information listed
in a file in the coverage directory. Use the command prompt to list the contents
of the file:

- Since you know this data set is stored with these projection parameters,
create a new view using USA data from the esridata\usa directory from the
CD. Alter the view's projection properties to match the projected data set

- Save these themes in projected units. Now you will have several data sets
all projected in the same system, and they can be used together in the same
view.



You have just downloaded a GIS data set in ArcInfo Interchange File format
from the web and imported it into ArcView. You have also projected some unprojected
data sets to match the data you downloaded and imported. Many of the data sets
available on the web are in this format.
Find GIS data on the web, download and import.
- Search the web using Ixquick, MetaCrawler
or Dogpile for the phrase "GIS
data" or "E00" or "ARC+Interchange+File"
(use the quotes to search for the entire phrase).
- Based on the response, find an ARC Interchange file on a web or on
an ftp site.
- Download and import the file.
- Open a Windows Explorer. You will see a directory ("folder") that
has the same name as the data set you imported. This is the "coverage
directory."
- Add the imported coverage to a new view. Note that there may be multiple
feature types in the imported data source. If this is the case, add each different
source as a theme.
- Save each of the theme(s) as a single or a series of shapefiles.
- Create a new directory on your zip disk called data_bak.
- Using the Windows Explorer, copy all of the individual files for your shapefiles
to this new directory.
- Add these new copies shapefiles to a view. They should work fine.
- Using the Windows Explorer, go back to the directory where you imported
the data set in step (3). Copy only the coverage directory (not the
info directory) to the same place where you moved the shapefiles.
- Attempt to add the data source from the previous step. You should see no
such theme listed as a data source when you navigate to the new directory.
This is because the info directory has not accompanied the coverage
directory. Arbitrarily moving directories without understanding the file structure
could have dangerous results. Deleting various directories may corrupt
your data sources. Deleting info directories will definitely
corrupt any ArcInfo data sets in the parent directory.
Do you see now why the Manage Data Sources is included in ArcView, and
why it is important to be have mastery over the hierarchical file structure?
Search the NSDI Clearinghouse
Searching the Clearinghouse is done by using a forms-based or Java-based interface.
Enter various query properties, including which database to search, spatial
location, and keywords.
- Open a new web browser pointed at the Washington State Node of the NSDI
Clearinghouse Gateway by right-clicking on the link and selecting "Open
in new browser" or the equivalent. Select one of the servers you see
on the map.

- From the next web page that displays, select Search Clearinghouse sites
using place names.
- Click the radio button for Don't search based on time period. This
will make a more liberal search for data.
- Enter a full text search for "Elevation"

- Use the Washington State Geospatial Clearinghouse Node. If the Washington
State Node is unresponsive, select another node.

- Click the Search button.

After a minute or two you will be presented with a series of metadata records
for various data sources. The metadata records describe data formats, contact
information, time period, etc. Your search results should look something like
this:
- Click the link for Washington State Geospatial Clearinghouse - All Nodes.
This will return a list of all metadata records with the word elevation
anywhere in the record.
- Click the Full record for one of these data sets to see the complete
FGDC-format metadata record for the data set. You should see all kinds of
important information, such as projection and coordinate system parameters,
contact data, file type, source scale, etc.
Here is an excerpt from the Washington State Elevation Data Layer:
- Search for other data on this server and on other servers. Do you find anything
useful or interesting? Some of the data sets described will have online linkages
to actual data sources.
You have just searched the National Spatial Data Infrastructure for Federal
Geographic Data Committee (FGDC) formatted metadata. This should give you an
idea of the wealth of GIS data that are available, and how you can begin to
track down data.
Download Spatial Data Transfer Standard (SDTS) DEM data
- Enable the Spatial Analyst extension (we will need this for importing and
displaying DEM grid data sets).
- We will be downloading and working with data from the Grand Coulee Dam
7.5 min quadrangle.
- Open another browser window and go to the USGS
GeoData site (you can do this by right-clicking on the hyperlink and selecting
the choice "Open in new browser").

- Click the choice for 1:24,000 DEM. This will instruct you to visit the GIS
Data Depot for 7.5 minute tiled DEM data. Click the link for http://gisdatadepot.com/dem
on the USGS GeoData web page.

- When you have the GIS Data Depot web site up, click Download Data.
- Follow the links for United States > Statewide Data > Washington
> Countywide Data > Lincoln. This will take you to the Lincoln County
data sets.

- Find the quad for Grand Coulee Dam. Click the Download button
to go to the download page..

- On the Download page, click the link for 1705288.DEM.SDTS.TAR.GZ
to download the SDTS-format DEM file. If the download appears to be unbearably
slow, get this copy.

- Open a Windows Explorer and navigate to the grand_coulee\data directory
on your Zip disk. You should see the SDTS file listed.

- If you want to use the most efficient (expert user) way
of extracting the file, download this copy of the tar executable
to the grand_coulee\data directory on your zip disk. If you want to
use the slower and more cumbersome, multi-step WinZip process, skip
ahead.
- Copy the tar.exe and gzip.exe files from CD:\unix to
the grand_coulee\data. These utilities will allow you to unzip
the TGZ format archive file.
- Using a command window, move to the Zip drive and the grand_coulee\data
directory, then use the tar command to extract the files. Green
text shows the commands you need to enter. The red text here is explanatory
for what the commands accomplish.

- Now that you have the SDTS DEM files extracted, skip
ahead to importing the data.
- If you will be using WinZip, you will need to download
and install it. This will not be possible if your computer account lacks the
proper privilege. If you cannot install WinZip, you will need to use tar
and gzip.
- Open WinZip or the unzipping software you have available. Select File >
Open Archive (or the equivalent), and navigate to the file you just downloaded.
Open the file. WinZip will ask:

Choose Yes.
- From the WinZip menu, select Options > Configuration.

- On the Miscellaneous tab, make sure that "TAR ..." is UNCHECKED,
and click OK. If you are not using WinZip, you will need to make the
equivalent change in your unzipping software. This step is necessary in order
to extract the files correctly.

- Click the Extract button on WinZip's GUI. Navigate to the grand_coulee\data
directory.

- You should now have all the component files in your grand_coulee\data
directory.
You have just downloaded an SDTS format DEM from the USGS web site and extracted
the individual files making up the SDTS data set. Most of the Washington state
DEMs are available in USGS DEM format, but if you are searching for DEM data
for other states, you may encounter SDTS formatted digital elevation data. You
will now convert the SDTS data into USGS DEM format, which can be imported within
ArcView.
Convert SDTS DEM to USGS DEM
Before the SDTS format DEM can be imported to ArcView, it will need to be converted
to USGS format DEM.
- Download the sdts2dem_dos.exe file from the BLM
GIS ftp site to the grand_coulee\data directory. You may need to
download the zipped copy and then unzip it.
If the BLM site is down, or if you cannot find sdts2dem_dos.exe on the site,
download this copy.
- Using your command prompt window, run the executable. Green text shows the
commands you need to enter. Red text is explanatory.
- After the import completes, the prompt will reappear.
You have just converted an SDTS format DEM to a USGS format DEM. The new file
can be imported directly into ArcView.
Import USGS DEM
- Use the instructions provided in the 2nd Raster Analysis exercise (Importing
data from generic raster files) to import the USGS format DEM.
- Create an analytically hillshaded grid from the elevation grid (Surface
> Compute Hillshade from the menu).
- Display the hillshaded grid in 256 shades of gray (Gray Monochrome). Make
sure that the lower values are black and the higher values are white or you
will "see" your landscape in "reverse," where depressions
on the landscape appear raised, and high places on the landscape appear sunken.
In order to do this, click the flip symbols button on the legend editor
.
|

incorrect
|

correct
|
The dam is clearly visible on the western side of the DEM, spanning the Columbia
River.
This is cool to look at in a 3D Scene:
You have just completed the process of downloading a digital elevation model
in SDTS format, converted SDTS to DEM format, imported into ArcView, and created
an analytically hillshaded view of the Grand Coulee Dam 7.5 minute quadrangle.
You should be able to repeat this process for any area in the USA that has SDTS
DEM data.
Download SDTS DLG data
Next, we shall download and import some vector data.
- Navigate to the USGS
GeoData site in your other browser window.
- Select the choice for 1:24 K DLG.
- Select FTP via Graphics. Follow the link for Conterminous 48 states.
Click on Washington state.
- Click the area highlighted below. This contains the Grand Coulee Dam quadrangle.
- Click the Grand Coulee Dam quadrangle. This will open a link to the
parent directory for the files.
Click on the link for GRAND COULEE DAM, WA.
- Enter the hydrography directory and download the 911965.HY.sdts.tar.gz
file, but save it locally in the grand_coulee\data directory. Only
if the USGS server is unresponsive, get this
copy.
- Use the same method as before (either the tar executable, or WinZip) of
unzipping the 911965.HY.sdts.tar.gz file.
You have just downloaded an SDTS format vector data source from the USGS and
recreated its native multi-file format. SDTS is a file format that has specifications
for storage and interchange of fully-attributed vector data as well as raster
data.
Convert SDTS DLG to DXF
Before we can use the SDTS vector format data, it must be converted to a form
that ArcView can read. ArcInfo has SDTS importing functionality, but because
we cannot assume that everyone has ArcInfo, we'll stick to some public-domain
tools.
The sdts2dxf.exe program
(also from the BLM) will convert SDTS vector data into AutoCAD DXF, which can
be read directly by ArcView. If the BLM ftp site is down, you can get a copy
here.
- Download the executable into the same directory where your other data reside.
- Open a command window and navigate to your grand_coulee\data directory
. Review the syntax if you have forgotten
how to change drives and directories.
- Verify the names of the files you have recreated and run the sdts2dxf command.
Note that the prefix for all of these files is hy01. Also note that
some of the files have the suffix 01 in positions 7 & 8 of the
file name. The prefix and the suffix will be necessary in a moment.

- Verify that you have created a DXF file.
You have just converted an SDTS file to a DXF file, which will be able to be
loaded into ArcView according to instructions in Adding
Themes to Views & Legend Editing.
Convert DXF to shapefile
- Following the instructions
for loading CAD themes, load the all 4 of the different data sources from
the DXF file.
- Save the line type as a shape file called coulee_hydro.shp.

- Open and browse the attribute table for the new line shapefile
There is a basic problem with this method. Although we have recreated line
data, imported it to ArcView, these lines have no attribute values. In addition,
all polygon features are not converted or displayed properly. In order to do
a full conversion, you will need to use ArcInfo
or some other commercial software.
Get and view USGS DRG data
The last step in looking at the Grand Coulee area will be to download and view
the scanned USGS 7.5 minute quadrangle digital raster graphic (DRG).
- Visit the WAGDA
page for digital raster graphics and find the Grand Coulee Dam quadrangle
(within the larger Ritzville quad).
If the download seems to be exceedingly slow, or if the link is dead, you
can download a local copy of the files (both image and world file in a single
Zip file). Download the file o47118h8.zip
and unzip it.
- It will unzip to o47118h8.tif, o47118h8.tfw, and o47118h8.tfw83.
The larger TIFF file is the image itself, and the other two files are world
files, one for UTM NAD27, and the other for UTM NAD83.
- Make sure both the image and the world files are in your grand_coulee\data
directory.
- Load the image into your view. Alter the drawing order so that the image
is the first to draw. Zoom into the western side of the map, right at the
dam. What is the elevation of the dam?
Convert SDTS DLG to ArcInfo coverage (optional, only if you have access
to ArcInfo; not available in MGH Autumn 2002)
There is a method that will convert SDTS vector data to ArcInfo coverages,
recreate polygon structures, and recreate attribute values. This method assumes
no previous experience with ArcInfo, and will not explain any of the "behind
the scenes" functionality.
Note: If you are working in MGH, you will not
be able to complete this part of the exercise. If you are a student in Fisheries,
Geography, or Urban Planning, you should have lab facilities that have ArcInfo.
Other students can use the STF Computer lab in 311 Bloedel Hall. I do strongly
suggest that you complete this part of the exercise, so that you can be aware
of how to utilize the vast amount of free vector data available from the USGS.
- Download the SDTS Master Data Dictionary by following the link on the USGS
GeoData page. Make sure and retrieve the single tar file MASTERDD for
the 24K data sets. If the site is unresponsive, get this
copy.
- Use WinZip (or the tar -zxvf command as before) to expand the 00MASTERDD_LRG_SDTS.tar.gz
file into the masterdd directory you created before.
- Download and unzip the sdts2cov.zip file
into the grand_coulee\data directory. It will unzip to sdts2cov.aml.
This is the ArcInfo macro that will convert SDTS vector data to ArcInfo coverage
data.
- Change directories back to the grand_coulee\data directory in the
command window.
- Start ArcInfo from an command prompt (use the arc command to start
ArcInfo).
- Run the sdts2cov macro to create the ArcInfo coverages (use the command
&r sdts2cov). Some output will begin to scroll up the command window.
If the routine fails, you probably do not have the directory structure correct
(see start of exercise).

After a few moments the macro will terminate, giving a list of the coverages
and the type and number of features created.

- If you feel ambitious, you should convert more data sets over from SDTS
to ArcInfo coverage format.
- At this time, you should be able to customize display of the data set, browse
attribute data, convert to shapefile, or perform any other GIS functionality
you have learned so far.
Here is a view containing several of the data sets available for the Grand
Coulee Dam quadrangle.

You have just converted SDTS vector data into ArcInfo coverage data. There
are a tremendous amount of data sets available for free from the USGS, but many
of the data will need to be converted over in this method.