![]() Simply copy the numeric ZipCode field to Zip field – it will convert the forma to txt. Make the field Text and exactly 5 digits size. Open newly imported table in geodatabase and Add new Field. Let’s create a new geodatabase in ArcCatalog, and then import CSV table in that database. We need to create a new geodabase and working in ArcMap adding more data to it and editing tables/shapefiles. Note, that you cannot edit CSV file in ArcMap directly. On top panel in ArcMap click on Editor drop-down and start editing. Also note that table has omitted leading zeroes in some zipcodes. We need to change that to match with Shapefile zipcode ID. On the right site open ArcCatalog, find CSV table and right click on it to show Fields – it is a number (Long Integer). Lets check on data type in our Excel table with names. The format of the data is Text and size is 5 digits. Right click on shapefile, select properties and look under Fields tab. ![]() ![]() Let’s check on data type in Zip code shapefile. To join table to shapefile based on ID (zipcode) the data type in the column you are planning to join should be the same. Here we start with performing relational joint of list of zipcodes with names to the US zipcode shapefile. Spatial join is the key concept in GIS and that is what sets all GIS technologies apart from other relational databases. There are two basic types of joins in GIS tables and geo-data: spatial and relational (based on table IDs). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |