I tried to dissolve smaller features into larger (from unit to district) with field in related table. I can easily see the related records of related (many) table but unable to dissolved the features based on this (related) field. I also failed to do summary statistics of field at related table.

  • I'm not clear about what you are describing - perhaps pictures of a few records from the attribute and related tables will help - but you may want to look into using the Join Field tool prior to trying to Dissolve. – PolyGeo Feb 9 '15 at 9:40

If you don't want to change the schema of your data in database use arcmap in memory (map) join.

In-Memory Map Join

if changing the schema isn't problematic follow PolyGeo suggestion (Join Field Tool).

  • If you have 10.1 or later this may work. However, you may have to also do an Export or Copy Features or some other feature class creation tool to duplicate the related features prior to running Dissolve if just joining the table and running Dissolve is not producing the results you expect. Prior to 10.1 this will not work at all. You can use a script to do the related join, but fast da cursors require 10.1. Basically get 10.1 at least. See my post: gis.stackexchange.com/questions/133496/… – Richard Fairhurst Feb 10 '15 at 0:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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