GIS Frequently Asked Questions & Help Page


Here are common GIS questions about our Department of Ecology GIS data and maps. If you cannot find your question here, contact us.


Table of Contents

Importing/Exporting:

  1. How do I use a zip file?
  2. What is a shapefile?
  3. What is an E00 file?
  4. How do I use an ArcInfo E00 export file in ArcView 3.x or ArcExplorer?
  5. How do I use an ArcInfo E00 export file in ArcGIS or workstation ArcInfo?
  6. Is your GIS data available in other formats like DXF?
  7. Where can I find a data converter?
  8. How do I create a DBF file in Access?
  9. How do I create a DBF file in Microsoft Excel 2007?
  10. How do I unzip a geodatabase file (GDB)?

GIS Data:

  1. Where can I find a list of Ecology's data layers?
  2. Where can I find other GIS datasets?
  3. How can I view Ecology's GIS data?
  4. How do I convert Ecology's GIS data to NAD 27 (or any other projection)?
  5. How do I convert my NAD 27 data to Ecology's standard projection?
  6. How do I import a table with XY coordinates?
  7. Why isn't the DAMS layers available online?
  8. Where can I find a list of the facility types (attributes) in the FACILITIES layer?
  9. What are Ecology's GIS spatial standard for data creation and sharing?
  10. Where can I find scripts for ArcGIS?
  11. Where can I find symbolsets for ArcGIS?
  12. Are there any other map layers from the Coastal Zone Atlas of Washington available?
  13. Where can I get USGS Quadrangle maps?
  14. Do you have any aerial photographs/images available?
  15. Where can I find Shoreline Management Act (SMA) designations?
  16. Do you have a watershed layer that is smaller than WRIAs?
  17. Where can I find a Well Log?
  18. When trying to use the Maplex extension, with it turned on, why don’t I see the extended label properties for my data layer of interest?

Maps:

  1. What's a WRIA?
  2. I don't need digital data, do you have maps available?
  3. Is the digital data available that you used for your maps?
  4. Do you have any tips for printing your PDF maps?
  5. Are your maps available in any other formats besides PDF?
  6. I need to combine your maps for a couple of themes. How can I do this?

ArcGIS:

  1. How can I improve the performance of ArcGIS 8.1?
  2. Where can I find training for ArcGIS?

Other:

  1. Where can I find some facts (statistics) about Washington State?

IMPORTING/EXPORTING


1. How do I use a zip file?

Zip files are "archives" used for distributing and storing files. Ecology uses zip file compression for large files to save space. More information about zip files can be found on WinZip's website.

Back to TOC

 

2. What is a shapefile?

Shapefiles are a vector data storage format for storing the location, shape, and attributes of geographic features. A shapefile is stored in a set of related files and contains one feature class.

White paper on shapefiles:  http://www.esri.com/library/whitepapers/pdfs/shapefile.pdf

Wikipedia:  http://en.wikipedia.org/wiki/Shapefile

Back to TOC

 

3. What is an E00 file?

An E00 (E-zero-zero) file is Environment Systems Research Institute's (ESRI) proprietary file format to import and export ArcInfo data files. The E00 refers to the file's suffix. For example, county.e00 could be a GIS layer of counties for a state. Note that an export file can also consist of several E00 files, such as, e00, e01, e02, etc. This is usually done to limit the file size of each export file (so they can fit on a disk).

More information on E00 files can be found at:

http://spatialnews.geocomm.com/education/tutorials/e00data/

To use an E00 file, go to the second question below.

Back to TOC

 

4. How do I use an ArcInfo E00 export file in ArcView 3.x or ArcExplorer?

IMPORT71 is a stand-alone program that converts an ArcInfo interchange file created on any other operating system into a ArcInfo 7.x coverage or grid. If you receive ArcInfo data in interchange format you can use IMPORT71 to convert it to a data source in a format that can be added to a project or view in ArcView (or used in other mapping programs). (Source: ArcView 3.2 help.) If you have ArcView GIS you already have IMPORT71, hopefully you know this!

Import71 can be downloaded from:

GeoCommunity software resources:  http://software.geocomm.com/translators/ArcView

Instructions on how to use IMPORT71:  http://spatialnews.geocomm.com/education/tutorials/e00data.

Back to TOC

 

5. How do I use an ArcInfo E00 export file in ArcGIS or workstation ArcInfo?

ArcGIS, version 8.3:

First, use ArcToolbox to convert the E00 file to a coverage.

Click on Coverage Tools > Conversion > To Coverage:

Then fill in the blanks for the paths and filename/coverage name and click the OK button:

 

ArcGIS, version 9.x:

First you need to add the data format conversion tools. To add the E00 file conversion function (and other tools):

In ArcCatalog select Tools > Customize

 

In the Customize dialog > Toolbars tab > Select ArcView 8.x Tools

 

This adds a new tools set with a drop down list to do the following. Import e00 file is Import from Interchange File.

 

Workstation ArcInfo:

For workstation ArcInfo, use the IMPORT command at the Arc: prompt. This example shows how to import a file named, data.e00 to create a coverage named, data, in the current workspace:

Arc:  import cover data data

Note:  Sometimes a coverage will have one or many related data files. If there are any, these files will be found in the info directory that gets created when you import the E00 file. Use the dir info command to list the Info files in the info directory. Use the list <filename> to see the contents of the file. Also, data files in Info format can be exchanged using the IMPORT command. In this case, you must use the info option with the import command:

Arc:  import info data data

Back to TOC

 

6. Is your GIS data available in other formats like DXF?

Not here on our site. We can, however, convert it using ArcGIS' conversion tools. Due to the time involved though, we must charge for this service. Please contact us for further assistance or you can try using a data converter.

Back to TOC

 

7. Where can I find a data converter?

If you can't use a E00 file, you will have to covert it to another format. Some data converters are found at this site:   http://software.geocomm.com/translators.

Back to TOC

 

8. How do I create a DBF file in Access?

Export the database table as a DBF file:

Back to TOC

 

9. How do I create a DBF file in Microsoft Excel 2007?

In Microsoft Excel 2007, there is no option to save the table in .dbf (dBASE) format as in previous versions. This is by design with Microsoft Office 2007.

Export an Excel table to .dbf format in ArcGIS:
  1. In Excel 2007, save the table as, 'Excel 97-2003 Workbook' (.xls format).
  2. Navigate to the .xls table location through ArcCatalog, and expand the file to view the worksheets.
  3. Right-click on the worksheet representing the table. Select Export > To dBase (single).
Back to TOC

 

10. How do I unzip a geodatabase file?

When you download and unzip a file geodatabase (FGDB) zipped file (filename.gdb.zip), you need to unzip it into a folder with a .gdb extension. Otherwise, ArcGIS won't see it in the catalog tree.

  1. Create a folder named  <file name>.gdb
  2. Extract the contents of the zip file to this location
  3. Refresh the location containing the folder in ArcCatalog 10.x
  4. The data should be recognized now as a FGDB in ArcCatalog 10.x

If you are using WinZip Pro, using the 1-Click Unzip button will automatically do this.

Back to TOC

GIS DATA


1. Where can I find a list of Ecology's data layers?

At http://www.ecy.wa.gov/services/gis/data/data.htm.

Back to TOC

 

2. Where can I find other GIS datasets?

We have some other sites listed at http://www.ecy.wa.gov/services/gis/data/data.htm#sources.

Other sites:

Back to TOC

 

3. How can I view Ecology's GIS data?

To use Ecology's GIS layers spatially, you need to have GIS software that can view shapefiles. One such program is ArcGIS Explorer or ArcReader, which are available for free at ESRI's website:

If you are not familiar with GIS and/or just want to view the tabular data, you can view the dBase (DBF) file that is part of the shapefile structure. When you unzip the Zip file, you will find a DBF file. Shapefiles store the non-spatial (tabular) data in DBF format, which can then be viewed in a program, such as Microsoft Excel.

The Open Source GIS website has links to Open Source / free GIS related software projects that one can download. Note that we have not used these programs and therefore, cannot offer any recommendations nor support.

Our GIS Applications page has programs where some of our data can be viewed in your Internet browser.

Back to TOC

 

4. How do I convert Ecology's GIS data to NAD 27 (or any other projection)?

In ArcGIS, use ArcToolbox: 

Click on:

Choose the dataset, the name you want to call the output, and then the output coordinate system. At this point you can also choose the projection of your choice, for example, UTM.

For Washington stateplane:

Choose:

Of course, if your project is in the northern counties of the state, you will want to choose NAD 1927 StatePlane Washington North FIPS 4601.prj.

For the Geographic Transformation, you need to add two transformations:

Click on the Button  to choose them from the menu.

Workstation Arc/Info:

If you have a coverage and are using workstation ArcInfo, use the PROJECT command with the COVER option:

ARC:  project cover <input coverage> <output coverage> {projection file}

These are the projection file parameters to convert a coverage from NAD 83 HARN to NAD 27 for Washington state plane, south zone, feet:

input
projection stateplane
units feet
fipszone 4602
datum hpgn nadcon
parameters
output
projection stateplane
units feet
fipszone 4602  (or zone 5626)
datum nad27
parameters
end

If you want to save these parameters, copy and paste (omit the text in parenthesis) them to a projection file, which can be used the the command line as shown above. Note that a projection file is a text formatted file.

Back to Top

 

5. How do I convert my NAD 27 data to Ecology's standard projection (NAD 83 HARN)?

In ArcCatalog or ArcMap, use ArcToolbox. Start ArcToolBox by clicking on the in the tool bar.

Click on:

  • Data Management Tools
  • Projections and Transformations
  • Feature
  • Project

Click on Project to bring up the Project Menu.

Project Menu

 

Choose the dataset to project.

Output Dataset or Feature Class:

ArcToolBox will create an output file name for you. If want to have a different name and/or path, fill in the name you want to call the output.

Output Coordinate System:

Click on the icon on the right side of the menu. The Spatial Reference Properties Menu will appear.

Spatial Reference Properties Menu

 

Note the Details: section is blank.

Click on the Select button (middle of the menu)

Browse for Coordinate System Menu

 

Choose:

Projected Coordinate Systems

Click the Add button

Browse for Coordinate System Menu

 

Choose:

State Plane

Click the Add button

Browse for Coordinate System Menu

 

Choose:

NAD 83 HARN (Feet, Intl and US)

Click the Add button

Browse for Coordinate System Menu

 

Scroll to the end and find Washington.

Choose:

NAD 1983 HARN StatePlane Washington South FIPS 4602 Feet.prj

Click the Add button

Spatial Reference Properties Menu

 

Note that Details: section is now filled out with the NAD 83 HARN projection information.

Click on the OK button at the bottom of the menu to continue.

Project Menu

 

Now you need to choose the Geographic Transformation. Note that his transformation consists of two parts so you need to make two selections.

Click at the right side of the Geographic Transformation fill-in form.

Project Menu

 

First transformation: NADCON.

Choose:

NAD_1927_To_NAD_1983_ NADCON

Project Menu

 

Second transformation: WA_OR.

Click to bring up the menu again.

Choose:

NAD_83_To_HARN_WA_OR

Project Menu

 

Your menu should look like this:

 

If you made a mistake, highlight the entry and click on the button to delete it. Then click on the button to add the correct one.

Click the button to start the transformation process.

Workstation Arc/Info:

If you are using workstation ArcInfo and are using coverages, use the PROJECT command with the COVER option:

ARC:  project cover <input coverage> <output coverage> {projection file}

These are the projection file parameters to convert a coverage from NAD 27 to NAD 83 HARN for Washington state plane, south zone, feet:

input
projection stateplane
units feet
zone 5626
datum nad27
parameters
output
projection stateplane
units feet
fipszone 4602
datum hpgn nadcon
parameters
end

If you want to save these parameters, copy and paste them to a projection file, which can be used the the command line as shown above. Note that a projection file is a text formatted file.

Back to Top

 

6. How do I import a table with XY coordinates?

In ArcMap you can import an Excel table or DBF file containing a field with XY coordinates by first loading the file into ArcMap.

Please note that the latitude (Y) and longitude (X) need to be in decimal degrees and west longitudes need to use a negative number (south latitudes requires a negative number, too).

  1. Load the table into ArcMap
  2. Right click on the name of the table
  3. Click on the Display XY Data command.
  1. A Display XY menu appears.
  2. The X coordinate is longitude and the Y is latitude.
  3. Fill in the fields for X Field and Y Field. In this example, the field names are LONG_DD and LAT_DD.
  4. Click the Edit button to enter the coordinate system.
 

Choose:

Geographic Coordinate Systems

 

Click OK Button

 

Choose:

North America

 

Click OK Button

 

Choose:

NAD 1983 HARN

 

Click OK Button

 

Verify entries are correct.

Done!

 

Click OK Button

ArcMap creates a new POINT layer and automatically adds it to your map document.

This new layer is in decimal degrees NAD 1983 HARN.

Back to TOC

 

7. Why isn't the Dams layer available online?

Due to security concerns from the September 11, 2001 terrorist attacks, Ecology removed the Dams layer from our website for FTP downloads; however, it is available by request.

For dam metadata, see http://www.ecy.wa.gov/services/data/hydro/dams.htm. Request the data layer by contacting Gus Ordonez, Dam Inspector, Dam Safety Office, Department of Ecology, (360) 407-6619.

Our Facility/Site layer also contains DAMS. Query the field:   InteractionType = 'DAM'.

Back to TOC

 

8. Where can I find a list of the facility types (attributes) in the FACILITIES layer?

Facility types are in the field, InteractionType. A table listing these is here:

http://www.ecy.wa.gov/services/as/iss/fsweb/interaction_types.html

More information on facilities (a.k.a. facility/site) can be found at:  http://www.ecy.wa.gov/fs/index.html.

Back to TOC

 

9. What are Ecology's GIS spatial standard for data creation and sharing?

See our GIS Standards webpage.

Back to TOC

 

10. Where can I find scripts for ArcGIS?

ESRI' site has a script library:

Back to TOC

 

11. Where can I find symbolsets for ArcGIS?

Sites that we know of:

Back to TOC

 

12. Are any other map layers from the Coastal Zone Atlas of Washington available?

Not yet. We are currently working on the coastal dynamics, geology and habitat layers. Please contact Brain Lynn, Shorelands and Environmental Assistance Program (SEA), (360) 407-6224, for more information.

Back to TOC

 

13. Where can I get USGS Quadrangle maps?

At the University of Washington, look for Digital Raster Graphics (DRG).

Back to TOC

 

14. Do you have any aerial photographs/images available?

Also, some county GIS websites have a GIS Mapping Application that shows aerial photography. Check with the county that you are interested in (links to county websites).

Back to TOC

 

15. Where can I find Shoreline Management Act (SMA) designations?

Designations for the Shoreline Management Act, like conservancy, natural, urban, rural, etc., are managed by individual cities and counties where the shoreline is located. Our layers only show where streams and waterbodies fall under shoreline jurisdiction. Here are some links for Washington counties and cities. For more information on the SMA, see Ecology's Shoreline Management Homepage.

Back to TOC

 

16. Do you have a watershed layer that is smaller than WRIAs?

Ecology does not, some other agencies do:

Back to TOC

 

17. Where can I find a Well Log?

Please contact Chris Anderson, (360) 407-6634, if you need more information on this application. Also, we have a GIS Well Log Location layer available for download.

Back to TOC

 

18. When trying to use the Maplex extension, with it turned on, why don’t I see the extended label properties for my data layer of interest?

Make sure the Group Layer containing the data layer of interest is the Active Group Layer, then turn on Maplex from the Labeling toolbar.  Now you should see the extended label properties.

Back to TOC

MAPS


1. What's a WRIA?

The Department of Ecology and other state resource agencies frequently use a system of "Watershed Resource Inventory Areas" or "WRIAs" to refer to the state's major watershed basins. For more information on WRIAs, see our My Watershed Webpage.

Back to TOC

 

2. I don't need digital data, do you have maps available?

Yes, we have them in PDF format. They are available in different theme areas:  WRIAs, counties, or statewide. We also have a printing tips webpage to help you print the maps on your printer. If these maps do not fit your needs, please contact our cartographer to discuss your request.

Back to TOC

 

3. Is the digital data available that you used for your maps?

Yes, but it's usually available as a statewide data layer. We have listed the data sources for the maps in a table on each of the theme pages:  WRIAs, counties, or statewide. In each of these tables, follow the links listed in the Organization column.

Back to TOC

 

4. Do you have any tips for printing your PDF maps?

Yes, we have put together a webpage, Tips for Viewing and Printing WRIA, County, and State PDF MAPS, for printing our maps.

Back to TOC

 

5. Are your maps available in any other formats besides PDF?

Yes, but only by request. Please contact our cartographer, Liz O'Dea, (360) 407-6142 for more information.

Back to TOC

 

6. I need to combine your maps for a couple of themes. How can I do this?

Each of the maps within each WRIA or county are designed to be used in overlay format with one another using hard copy transparency film. For example, one can overlay all of the theme maps in WRIA 1 or Thurston County; however, adjacent WRIAs or counties cannot be joined, as in WRIAs 2 and 3 or Thurston and Pierce Counties, because they are of different scales.

Back to TOC

ArcGIS


1. How can I improve the performance of ArcGIS

See Performance Tips and Tricks for ArcGIS Desktop 8.1, An ESRI Technical Paper, September 2001 (PDF format).

Back to TOC

 

2. Where can I find training for ArcGIS?

The Washington State Department of Personnel offers ArcGIS training. Also, try Environmental Systems Research Institute, your local colleges, or do a search in Google.

Back to TOC

OTHER


1. Where can I find some facts (statistics) about Washington State?

Back to TOC

Can't find your question here? Contact:

Rich Kim
Spatial Database Administrator
Washington State Department of Ecology
P.O. Box 47600
Olympia, Washington  98504-7600
Phone: 360-407-6121
Fax: 360-407-6493
E-Mail (rich.kim@ecy.wa.gov)


Page last revised on Wednesday, November 26, 2014 15:13 by Rich Kim