I need to find coincident points from different geodatabase database and assign a unique id to those features
Facts:
- I have 2 database (A and B) with same feature classes.
- Database A is a subset of Database B from a content perspective
- From schema perspective Database A and B are same
- So if Featureclass BXX will have 2000 features then Featureclass AXX would probably have 1800 features
- I need to assign all the 1800 features from Featureclass AXX and BXX same incremental id
- For e.g first feature for coincident feature in FC AXX and BXX will get id 101. Second coincident feature from both FC will get ID of 102 and so on.
- For the remaining 200 features from BXX will also get a unique id but there won't be anything assigned in feature class AXX as there are not features
- Most (not all) of the attributes are same on both these feature class.
- I also have a lat and long field in addition to shape field - they should match as well.
The challenge is in finding the coincident features in a fashion that is not so memory intensive. We are talking about around 800,000 points in Database A and 600,000 points in database B.
I have tried using matcher, spatial relator and spatial finder. Spatial Relator and spatial finder is not able to process so much data. Perhaps I am doing something wrong. It appered matcher was able to process data but I am not sure if that is the right tool.
Please help :).