I have a large database in ArcGIS 10.2.2, with over 2 500 000 point vectors. Each point has a unique number code. I want to spatially subset my data, so that I can extract only points with a specific codes. I tried to use an expression build by me, but in the Definition Query, i am limited to a certain number of characters. I want to subset points from over 200 000 unique codes.
The codes are numeric. Here is a sample code:
IdRPL in (1607130,1607131,1609481,1609482, ....., 1709809)
Answer
As an alternative to the Join mentioned by Andy, and fleshing out my comment suggestion, you can still use a definition query. First you'd need to bring the Excel spreadsheet into the same geodatabase as a table. You'd also need to make sure it has an OID field - which may or may not be the uniqueid field itself. Then your definition query would be something like "uniqueid" IN (SELECT "uniqueid" FROM excel_table_in_geodatabase). I've used this method myself a few times.
No comments:
Post a Comment