I am trying to find the coordinate of the line at the nearest distance from the point. I am using sde st_geometry library in oracle. I need the code that i can add to my pl SQL procedure.
Thank you, Jurate
You can use the NEAR tool. Keep the Location parameter checked. This will add two new fields NEAR_X and NEAR_Y to the attribute table.
Yes, I know I can use arc toolbox and gp. I am trying to get this done directly in oracle using sde.st_geometry library
With some other DBMSs, e.g., SQL Server and PostGIS, it would be fairly simple to use a shortest line method/function, if I understand your situation correctly. Unfortunately, the ST_Geometry library doesn't offer similar functionality. Doing some quick searches on "SQL nearest point" and "SQL shortest line," it appears there are a variety of suggestions, none of which I can speak to in terms of performance.
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
