Im currently attempting to query a file geodatabase, where I want to find all the duplicate PID (sub for an OBJECTID), and then within each one of these matching groups of records, find where the LAND_SIZE_ACRES has increased over time (each row of the same PID represents land data of sequential years).
I have been using "Select By Attributes," where I've used this formula, except it doesnt seem to work on a file geodatabase:
[FIELD_NAME] In (SELECT [FIELD_NAME] FROM [TABLE_NAME] GROUP BY [FIELD_NAME] HAVING Count(*)>1 )
Therefore I need to be able to query each group of matching records, and then find the variation within said groups of records. I just dont know where to start.
Example data:
Very few of the records actually change in land_size_acres overtime, hence the picture with no variation.