Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Dumb problem that for some reason is giving me trouble. I have a polygon shapefile that is loaded with old demographic data in its attribute file, I just received the new data today in xls format. What I want to do is just delete the old demo data from the existing shapefile by selecting the fields in the attribute table and right clicking delete. Then I would do a simple join using the ID numbers for each feature to add the new data from the new table then just export it out as a new shapefile. The problem is that for some reason I can not delete entire columns from the attribute table. I ask the people on this forum how would you go about stripping the data from this polygon shapefile? Thank you!

share|improve this question
    
I suggest you change to title to make it more clear you want to delete the shapefile's columns. –  Petr Krebs Nov 1 '10 at 19:52

4 Answers 4

up vote 12 down vote accepted

Furlong-

Use ArcToolbox > Data Management Tools > Fields > Delete Field. Choose your shapefile as the Input Table. Use the Select All button, then unselect the field(s) you want to keep. Hit OK.

BTW, ArcGIS 10 running on a 64 bit OS has a bug whereby you cannot delete columns using the right-click > delete field operation. Should be fixed in SP1 (I hope).

share|improve this answer
    
Thank you for the heads up about the 64bit bug, I am running on windows 7 64 which is the reason why I am having this issue! –  Furlong Nov 1 '10 at 20:03
    
Unfortunately, this has NOT been fixed in SP1 as I had hoped :-( –  Don Meltz Jan 15 '11 at 4:57

Deleting the fields is scary way of going about this. Are you absolutely sure you'll never need them? There are several non-destructive ways to accomplish your goal. One is to:

  • load the shapefile and new table in ArcMap,
  • join them on the ID field,
  • right click the layer and choose Properties,
  • on the Fields tab deselect all of the fields of the shapefile and click OK,
  • right click the layer and export the data to a new file.

Only the checked fields will be exported to the new file and the old file will be preserved.

share|improve this answer

Make sure that you are not editing the shapefile when trying to alter its columns. Also, make sure other applications (like ArcCatalog) are not locking the shapefile.

share|improve this answer

My method is to make my join. then go to the layer properties and turn off all the fields I don't want. then if I need a subset of selected objects (maybe only the ones that got a join) make that selection. Then use the data export and export to a new shape file. The time involved is a fraction of the time for waiting for each attribute field to delete and update. Another trick to use if you don't go this way is to pause the draw window while deleting fields. this will save a bundle of time also. HTH

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.