Latest Contributions by JamieHoffmann

Edit: I was able to accomplish my objective by summarizing my field, joining it back to the original dataset and selecting my desired rows that way. Thank you everyone for responding to my post. Happy December everyone! Could anyone suggest me a chunk of SQL code to use in Select by Attributes to select only the first row of each group of duplicates? Or select a duplicate that associated with another column's max value?  Objective: I have a table of 520,000 census block codes that include broadband download speeds. I have the table sorted by Census Blocks (Ascending) and then by download speeds (Descending) to list the census blocks in the order of highest download speed to the lowest (each group of duplicate census blocks are ordered from highest to lowest download speeds). Because there are duplicates of each census block, I only want to select the census block with the highest download speed. I have the table sorted where the first census block code of each group of duplicates has the highest download speed. My goal is to select each block code with the highest download speed. The data is stored in a file geodatabase  Example:    Block Code  Download Speed  1234 (row to select) 25 1234 2 1234 2 5678 (row to select) 100 5678 2   Thanks, Jamie    Edit: I do not have access to Delete Identical/Find Identical Tools     ... View more

1. I have a feature layer of a state consisting of polygons for each county. I would like export each polygon within the feature to their own separate features. Instead of manually selecting each county one-by-one to export to its own feature, can I batch this task or write a python script for it?  2. I have another feature layer consisting of 31k polygons. I would like to clip that feature to each county (from the question above) they are located in. Now I can do this manually by going through each county one by one and clipping the feature to the county boundaries or I can complete it using arcpy... Is it possible to perform all of this in one python script (tasks 1 and 2 listed above)?  Thanks! ... View more