I have 2 CSV files with GPS coordinates. I want to check if there are any locations in the first file which are inside a specified elliptical region surrounded by each location in the 2nd file. The major axis , minor axis and major axis bearing(angle) is given in the 2nd file for each location coordinates. For start I have plotted the points from both files in an ArcMap document where I can see red dots as first file locations and green dots as 2nd file locations.
For example if the coordinates of one location in 2nd file is 39.6145,-89.7823 (latitude(h), longitude(k)) and the major axis(a) 1200 and minor axis(b) 400 and bearing(A) 114 degree, then I want the list of the instances in first file which falls inside that region
N.B its is basically solving (x,y) in following equation,
The image is basically the ellipse equation if you can't view it. 〖((x-h) cosA+(y-k) sin〖A)〗〗^2/a^2 +〖((x-h) sinA-(y-k) cosA)〗^2/b^2 ≤ 1
I am totally new in ArcGIS. I am also trying to do it in Python but want to know how to implement it in ArcGIS too. And both the files are pretty large, with millions of entries in both. So I would also like to know if it is too much time consuming in ArcGIS.