I'm trying to merge feature records based on identical parameters in two different fields using Python or SQL.
I have a polygon feature class with ~800 records, that I've intersected with another feature, which has created a number of duplicated geometry fragments.
The intersected feature has a field containing IDs (catch_ID), and a field containing landuse (land_ID). The land_ID field contains a string value that's either Impervious or Pervious. After I intersected, I was left with too many duplicates, I'd need to reduce the duplication to each catch_ID so that I'm left with two, one for impervious land_ID and the other for pervious land_ID.
Right now I'm tackling this manually using Select By Attributes ie. catch_ID = '100' AND land_ID = 'Impervious', and then merging them using the editor. I will have to repeat a process a few more times, so I'd like to figure out how to automate this.
What Python commands would I need to generate a script for this, I'm not really familiar with the functions ArcPy uses the Editor, or can this be done with SQL in the Select By Attribute window?
I have Python 2.7.5 and Arcmap 10.2.1 (extensions 3D Analyst, ArcScan, Spatial Analyst, Geo statistical Analyst).