X hits on this document

PDF document

PCCC GIS I Exercise 2 (AV9.1) - Locate your car with GPS, map it with GIS v2, Apr 2007 - page 21 / 31

85 views

0 shares

0 downloads

0 comments

21 / 31

Step 9 - Create an address table with PCTC’s name, street address, zipcode. Discussion: Both an address table and a reference table are needed for geocoding. You will first create the input address table populated with the address(es) you wish to map.

Procedure:

Open a new spreadsheet in MS Excel.

Set the column headers and enter data as follows:

NOTE: Make sure that you format the Zipcode column as Text!

  • File > Save As, scroll to your folder, save as input_address_table.xls.

  • Select Cell A1 in the input address table, select File > Save As, scroll to your folder, save as input_address_table.dbf (select DBF4 using the arrow in the Files of Type window below the File Name window).

You will be prompted by several windows:

  • Press OK. Another window opens:

  • Press Yes. The table returns, now saved as a .dbf file:

  • Close the input address table. If prompted, save it (again!) as a .dbf.

21

Document info
Document views85
Page views85
Page last viewedSat Dec 10 20:58:15 UTC 2016
Pages31
Paragraphs436
Words7215

Comments