Step-By-Step Tutorial

Step-By-Step Tutorial Creating City of Kent Residential Development Projects Shapefile in ArcGIS Written by Katie Heinitz Spring 2007 Purpose: The purpose of this document is to provide step-by-step instructions on how the City of Kent Residential Development Projects shapefile was created. This document will include information regarding the creation of the data, how to keep the data up-to-date, and how to make the City of Kent Residential Development Projects map available to the public. Table of Contents: A. Exporting an Excel Spreadsheet to an Access Database ………………………………1 B. Making New Shapefile: Join Access Database to Kent Parcels Layer in ArcMap ……3 C. Editing Attribute Table for Residential Project Shapefile……………………………..6 D. Residential Development Projects with Multiple Parcels ……………………………..7 ÆÆÆÆÆÆ A. Exporting an Excel Spreadsheet to an Access Database Using Access instead of Excel for creating a shapefile of the residential development projects creates fewer issues between the data and ArcMap. ArcMap works better with Access than it does with Excel and storing the data in Access allows the data to be more easily updated. If the data is already in Access form, there is no need to go through the steps laid out in this section. To export an Excel spreadsheet to an Access database: Create an Excel spreadsheet containing all desired data to be included in the final ...