Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4580

ST_PointOnSurface returns point on the boundary of the polygon

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.1.2, 9.2, 8.12.9.6_3
    • 9.x, 8.12.7.6_3
    • Query Engine
    • None

    Description

      Calling ST_PointOnSurface with a polygon argument returns one of the points of the polygon boundary.

      E.g.

      SELECT ST_AsText(ST_PointOnSurface(ST_GeomFromText('POLYGON ((67 13, 67 18, 59 18, 59 13, 67 13))')));
      

      returns POINT (67 13)

      The spec says

      PointOnSurface( ):Point—A point guaranteed to be on this Surface.

      which might not be completely clear, but several sources indicate that "on this surface" means inside the surface.

      When running the same query against a postgis instance (not through teiid), the result is POINT(63 15.5), which is actually inside the polygon.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            asmigala@redhat.com Andrej Smigala
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: