Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Is it possible to get the distance between a Polygon and a point?

When you use ST_Distance you can only get the distance between two points (round-Earth).

I wonder if there is something similar you can use between a point and polygon?

asked 20 Mar '15, 12:20

M%20G's gravatar image

M G
629253044
accept rate: 42%

edited 20 Mar '15, 12:23

Volker's suggestion is a good general solution. Another possibility could be to use thecentroid; depending upon which sense you mean distance.

http://dcx.sap.com/index.html#sa160/en/dbspatial/pg-api-spatial-st-surface-type-st-centroid-method.html

(20 Mar '15, 14:01) Nick Elson S...
Replies hidden

Hm, the cited page tells that:

This method can not be used with geometries in round-Earth spatial reference system.

(20 Mar '15, 15:25) Volker Barth

Obviously didn't catch that one. I'd delete the comment but it may help others not repeat my mistake, thanks.

(20 Mar '15, 15:57) Nick Elson S...
Comment Text Removed

Distance between a point and a polygon is equivalent to distance between point and a set of lines (unless the point and polygon intersect, then it's 0). To do that you need to compute the path of the line. Computing the length of a line is not too hard using an iterative algorithm (we use Vincenty's Formula, which fails for nearly-antipodal points, but is otherwise pretty simple and effective). This is why we can compute distance between two points.

Unfortunately, computing the exact path of a line on a round-earth projection is very hard, and occasionally there are several equivalent paths that all have the shortest length. Furthermore, the line is most definitely not "straight" in the Euclidean sense of the word, nor is it a nice curve (search for "geodesic" if you want to know more).

This is usually the job of projections to sort out, and is way too complicated for mere mortals to understand. So doing this directly in round-earth is not currently supported, and we would need some strong justification for doing this.

Internally we project round-earth geometries into the special (planar) 1000004326 SRID in order to do various operations on them, but this projection is not distance preserving. Therefore, anything that requires distance calculations (even Centroid()) cannot be trusted to give the right answer.

Volker's "silly example" of transforming to 1000004326 will definitely fall apart if your polygon crosses the equator anywhere other than between 0 and 90 degrees longitude. He happened to pick a special case where the Centroid is correct. But the distance will be wrong. If you get the centroid right, you could project back to 4326 and do the distance calculation in round-earth to get a reasonable distance measurement.

Your best bet is to know the context of your data and choose a local planar SRS that has an acceptable error margin for all data involved, project everything so it's all planar, and then do the distance calculation on the planar data. Other products often do this transparently in order to support round-earth distance measurements.

permanent link

answered 24 Mar '15, 15:32

Phil%20Mitchell's gravatar image

Phil Mitchell
1.9k1831
accept rate: 27%

edited 24 Mar '15, 18:55

1

Volker's "silly example" [...] He happened to pick [...]

That's absolutely right, and I'm glad that I cannot be blamed for my ignorance here as I'm certainly a mere mortal:)

(24 Mar '15, 17:57) Volker Barth

Thank you Phil for the extended explanation

(25 Mar '15, 06:04) M G

I do assume you want to calculate that in a round-Earth SRS, right?

Just a hint from the docs:

You can project round-Earth data to a flat-Earth spatial reference system to perform distance computations with reasonable accuracy provided you are working within distances of a few hundred kilometers. To project the data to a planar projected spatial reference system, you use the ST_Transform method.

Just a silly sample - it tries to calculate the distance between the point (6,8) and the rectangle with length 8 around the origin.

begin
   declare stp ST_Point;
   declare stpg ST_Polygon;
   declare nRE_SRID int = 4326; -- a ROUND-earth SRID
   declare nPL_SRID int = 1000004326; -- according planar SRID

   set stp = new ST_Point(6, 8, nRE_SRID);
   set stpg = new ST_Polygon(new ST_Point(-4.0, -4.0), new ST_Point(4.0, 4.0)).ST_SRID(nRE_SRID);
--   select stp.ST_Distance(stpg); -- will fail with SQLCODE -1436
--   select stp.ST_Distance(stpg.ST_Centroid()); -- will fail with -1435

   -- returns 10
   select stp.ST_Transform(nPL_SRID).ST_Distance(
      TREAT(stpg.ST_Transform(nPL_SRID) as ST_Polygon).ST_Centroid());
end;
permanent link

answered 20 Mar '15, 13:10

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822
accept rate: 34%

edited 20 Mar '15, 16:38

Thank you for the answer Volker and yes I wanted it in round-Earth, I'll look into it

(24 Mar '15, 06:16) M G
1

The example code here is good. Just don't use 1000004326 as the planar SRID. Choose a proper local projection based on the latitude, longitude, and distances involved with your polygons and points.

(24 Mar '15, 19:12) Phil Mitchell
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×260
×24

question asked: 20 Mar '15, 12:20

question was seen: 2,788 times

last updated: 25 Mar '15, 06:04