Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7514

GIS: PointOnSurface returns NULL instead of the point

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: N/A
    • Fix Version/s: 10.1.4
    • Component/s: GIS
    • Labels:

      Description

      10.1 tree

      MariaDB [test]> SELECT ST_AsText(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))')));
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | ST_AsText(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))'))) |
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | NULL                                                                                                                                                            |
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)

      PostGIS

      pgis=# SELECT ST_AsText(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))')));
                   st_astext             
      -----------------------------------
       POINT(-70.9510231824279 42.09385)
      (1 row)

      The shape is rather simple (see the picture).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                holyfoot Alexey Botchkov
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: