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.

I am studying ArcMap 10.2 and concentrates on different join operations. I am working on a Personal Geodatabase.

I have digitized some polygons from a raster representing houses and have created a feature class under a certain feature dataset for this purpose. I have further created a table (not within any feature dataset) contains number of people occupy each house. I've used the ID in the polygon layer as a primary key and field named house_number in the table i've formed as a foriegn key.

After joining those two tables - I've received the attached new table:

1st table after join. I've joined the green circled table to the red cirecled feature class. Primary Key in yellow and Foriegn Key in blue

After that I've tried to add a field (double precision) to use the field calculator, but it caused data to shift from one field to another, messing the attribute table. While in editor mode data is organized as it should be, but after exiting the editor mode it is being shifted back. Photos are attached:

after adding the field

In editor mode

share|improve this question
1  
Have you tried adding the calculated field before performing the join (if possible)? –  user3461 Nov 11 '13 at 15:10
    
Hi GeoKevin. It is not possible since I joined a data that is essential for the calculation. However the problem occures just when I add a field - even without using the field calcualtor. –  dof1985 Nov 11 '13 at 15:21

2 Answers 2

Export the joined table into a new shapefile or feature class, and then add the new field.

share|improve this answer
    
thanks. I'll check it on Sunday when I'll have ESRI access again. –  dof1985 Nov 13 '13 at 8:02

Referring to the comment of @GeoKevin try this:

  1. Add field (densitiy) to your polygon feature class (Resid).
  2. Join your two tables
  3. Use field calculator to calculate the field density. Field calculator will has access to both tables (Resid and Occupied)!
share|improve this answer
    
Thanks, will give it a try tomorrow and update you. –  dof1985 Nov 15 '13 at 15:07

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.