Select to view content in your preferred language

Querying point X,Y data stored in a database

1454
11
09-18-2012 11:36 AM
GagagDa_Morvi
Emerging Contributor
Due to some reasons, I am required to store X,Y point data in a database (and not convert them to point features). The X,Y data represents points in a UTM projection. I need to search for a point that is nearest to a given point in a query. The given point is also in the same UTM projection. Is there an efficient way of accomplishing this using SQL query? Thanks!
0 Kudos
11 Replies
BruceHarold
Esri Regular Contributor
Hi

I updated the functions to be a little more robust.

regards
0 Kudos
BruceHarold
Esri Regular Contributor
Hi

I updated the functions.

Regards
0 Kudos