topic Re: How to find point on the line from nearest point in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/how-to-find-point-on-the-line-from-nearest-point/m-p/783213#M1676 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; Unfortunately, the ST_Geometry library doesn't offer similar functionality.&nbsp; 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.</P></BODY></HTML> Thu, 22 Sep 2016 15:53:42 GMT JoshuaBixby 2016-09-22T15:53:42Z How to find point on the line from nearest point https://community.esri.com/t5/geodatabase-questions/how-to-find-point-on-the-line-from-nearest-point/m-p/783210#M1673 <HTML><HEAD></HEAD><BODY><P>I am trying to find the coordinate of the line at the nearest distance from the point. I am using sde&nbsp;st_geometry library in oracle. I need the code that i can add to my pl SQL&nbsp;procedure.</P><P>Thank you, Jurate</P></BODY></HTML> Wed, 21 Sep 2016 12:42:10 GMT https://community.esri.com/t5/geodatabase-questions/how-to-find-point-on-the-line-from-nearest-point/m-p/783210#M1673 JurateMeister1 2016-09-21T12:42:10Z Re: How to find point on the line from nearest point https://community.esri.com/t5/geodatabase-questions/how-to-find-point-on-the-line-from-nearest-point/m-p/783211#M1674 <HTML><HEAD></HEAD><BODY><P>You can use the <A href="http://pro.arcgis.com/en/pro-app/tool-reference/analysis/near.htm">NEAR</A> tool. Keep the Location parameter checked. This will add two new fields NEAR_X and NEAR_Y to the attribute table.</P></BODY></HTML> Wed, 21 Sep 2016 12:51:02 GMT https://community.esri.com/t5/geodatabase-questions/how-to-find-point-on-the-line-from-nearest-point/m-p/783211#M1674 JayantaPoddar 2016-09-21T12:51:02Z Re: How to find point on the line from nearest point https://community.esri.com/t5/geodatabase-questions/how-to-find-point-on-the-line-from-nearest-point/m-p/783212#M1675 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Wed, 21 Sep 2016 12:58:54 GMT https://community.esri.com/t5/geodatabase-questions/how-to-find-point-on-the-line-from-nearest-point/m-p/783212#M1675 JurateMeister1 2016-09-21T12:58:54Z Re: How to find point on the line from nearest point https://community.esri.com/t5/geodatabase-questions/how-to-find-point-on-the-line-from-nearest-point/m-p/783213#M1676 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; Unfortunately, the ST_Geometry library doesn't offer similar functionality.&nbsp; 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.</P></BODY></HTML> Thu, 22 Sep 2016 15:53:42 GMT https://community.esri.com/t5/geodatabase-questions/how-to-find-point-on-the-line-from-nearest-point/m-p/783213#M1676 JoshuaBixby 2016-09-22T15:53:42Z