Latest Contributions by JeffThomasILM

I've seen many similar questions but somehow never found an answer that I can understand and apply to my problem. I have a layer with Census tracts. I have a layer with parcels. I need to iterate through each tract, select the parcels falling inside, do some things to the parcels (for the sake of testing, I'm trying to copy the parcels in each tract into a new feature class named with the tract number), then repeat for the next tract. The loop works, insofar as it runs through each tract and creates a new feature class that is named with the tract number. But rather than each feature class containing only the parcels falling inside the respective tract, each resulting feature class includes all parcels falling inside all tracts. I'm clearly missing some important construct in my loop. Please help! with arcpy.da.SearchCursor("tracts", "TRACT_NUMBER") as cursor:   for row in cursor:     arcpy.SelectLayerByLocation_management("parcels","HAVE_THEIR_CENTER_IN","tracts")‍‍‍‍‍‍‍‍‍     arcpy.CopyFeatures_management("parcels", "parcels_"+"{}".format(row[0]))‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I just added a corresponding request to ArcGIS ideas: Option to eliminate pairs from Generate Near Table  But in the meantime, I'm wondering if anyone can help me figure out how to find duplicate pairs of attribute values from separate columns, regardless of column order, by way of SQL and/or ArcPy. The problem (described in the ArcGIS Idea above) is that the Generate Near Table tool creates pairs of distance values that are identical, as uniquely identified by the pairing of IN_FID and NEAR_FID attributes. That is, the unique distance between FID "a" and FID "b" occurs twice: "a-b" and "b-a" in the IN_FID and NEAR_FID columns, respectively. I only want one value from that pair, otherwise it affects statistics like the count and average of distances. I've found that it is possible to find these pairs with SQL: mysql - Show distinct tuples regardless of column order - Stack Overflow (I stole this question title for my post, obviously ) But of course, you can't easily break out of the WHERE clause in ArcGIS. Maybe this is possible in ArcPy, but I'm not sure how to adapt that SQL to work in ArcPy. If anyone could help me with that, it would be a boon to doing not just this specific SQL query but how to do any advanced SQL query in ArcPy (or other methods?) that's not otherwise possible within ArcGIS. Note: the near tables I've created are in a file GDB, but I do have the option of putting them in SDE if that helps. I do not, however, have the option of accessing SDE outside of ArcGIS, e.g., through SQL Server Management Studio. I'd like to learn how to do advanced SQL queries (that is, SQL involving more than just WHERE on a single layer) in ArcGIS regardless of data source. If it's possible at all. Thank you! ... View more

My ArcMap.cache.data file is over 18 GB and I can't figure out what's causing it or how to empty it. The closest thing I could find is clearing the display cache, which I've done and it made no difference. I also found a single GeoNet thread that was a similar issue (mine doesn't involve Citrix), but it was never answered. It's not causing any issues that I know of, beyond simply taking up a significant portion of my SSD. I could, of course, simply delete or move the file and see what happens, but that doesn't answer the question of how it got so big and the proper way to handle it. This is the full file path:C:\Users\<username>\AppData\Local\ESRI\Local Caches\BGLCacheV2\ArcMap.cache.data Thank you for any insight! ... View more