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

GIS: PointOnSurface returns NULL instead of the point

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • N/A
    • 10.1.4
    • GIS

    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

        1. gis1.png
          25 kB
          Elena Stepanova

        Issue Links

          Activity

            People

              holyfoot Alexey Botchkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.