AnsweredAssumed Answered

Select field value A based on largest polygon with field value B

Question asked by bettyalex on Jan 19, 2012
Latest reply on Jun 4, 2015 by rfairhur24
I have a set of polygons that have been dissected into sub-polygons to reflect spatial values.  I need to select the spatial value of the largest sub-polygon to use to describe the entire polygon.  I thought Dissolve would work, but it does not always return the spatial value for the largest polygon.  Here is an example of the table: 

Name        Acres     Value
Loc1          1.0         M
Loc1          2.0         N
Loc1          0.5         P    I need to be able to assign Value N to the Loc1 polygon (dissolved on 'Name') because the largest sub-poly value is N. 

I've tried various Dissolves, Selects, etc. but cannot get a file with the correct values.  I also really can't use grid files because the area of the polygon needs to remain consistent.