[postgis-tickets] [PostGIS] #5268: ST_ShortestLine return invalid linestring when distance of geometries is 0

PostGIS trac at osgeo.org
Sun Oct 30 12:27:43 PDT 2022


#5268: ST_ShortestLine return invalid linestring when distance of geometries is 0
----------------------+---------------------------
  Reporter:  latot    |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.4.0
 Component:  postgis  |    Version:  3.3.x
Resolution:           |   Keywords:
----------------------+---------------------------
Changes (by robe):

 * cc: pramsey (added)

Comment:

 @latot

 Forgot to mention -- somewhat related to this.  Paul Ramsey has been
 looking at s2. I'm not sure you saw his comment on PostGIS irc channel


 {{{
 'm actually working on postgis_s2 right now
 11:19AM
 In reply to
 R
 Regina Obe
 pramsey
 I'm actually working on postgis_s2 right now
 I see neither of the earlier attempts got very far... I got quite a ways
 on a non-postgis implementation, but in the end to be useful a binding
 needs a full set of real geometric types, the pgsql native ones just don't
 hack it. Also missing is a good way to do indexing... you end up either
 inventing something much like what is already in postgis geography or
 something similar using Caps. Ironically/oddly it's well nigh impossible
 (I've found) to leverage the S2 cell id into something useful for general
 purpose index assistance in the database. You end up needing to handball
 it a lot for many cases.

 one "issue" with s2, which is or isn't an issue depending on your
 perspective: it's truly a spherical library. not a geodetic library. so if
 you ask for distance, you get the spherical distance, not the spheroidal
 distance. if you do constructive geometry, you get the spherical
 construction

 maybe I should push my non-postgis implementation to github. it's cute,
 I'm proud of the bindings 🙂
 }}}


 @pramsey how's that pushing coming along?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5268#comment:4>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list