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

Missing OGC Spatial functions

Details

    • Task
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.1.2
    • GIS

    Description

      Hi,
      I've tried the OGC Spatial demos today in '10.0.0-MariaDB' and
      got some missing functions:

      FUNCTION ogcdemo.IsRing
      FUNCTION ogcdemo.PointOnSurface
      FUNCTION ogcdemo.NumInteriorRing
      FUNCTION ogcdemo.Relate
      FUNCTION ogcdemo.Distance
      FUNCTION ogcdemo.Intersection
      FUNCTION ogcdemo.ConvexHull

      I used the demo data and function checks from:
      06-104r4_Implementation_Specification_for_Geographic_Information_Simple_feature_access_Part_2_SQL_option_v1.2.1

      Does this functions not exist in MariaDB ?

      Thanks
      Friedhold

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-7509 Testing for GIS extensions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            fmatz Friedhold Matz created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Assignee Alexey Botchkov [ holyfoot ]
            holyfoot Alexey Botchkov added a comment -

            Some of these functions exist with SQL_MM names only:
            ST_Distance()
            ST_Intersection()

            We have NumInteriorRings instead of NumInteriorRing, that's a bug.

            Some are not in the 10.0 code yet, but ready to be pushed. These are:
            ST_IsRing
            ST_NumInteriorRing
            ST_Relate
            ST_ConvexHull

            And finally PointOnSurface - doesn't exist and no plans at the moment to implement the Surface-related functions.

            holyfoot Alexey Botchkov added a comment - Some of these functions exist with SQL_MM names only: ST_Distance() ST_Intersection() We have NumInteriorRings instead of NumInteriorRing, that's a bug. Some are not in the 10.0 code yet, but ready to be pushed. These are: ST_IsRing ST_NumInteriorRing ST_Relate ST_ConvexHull And finally PointOnSurface - doesn't exist and no plans at the moment to implement the Surface-related functions.
            fmatz Friedhold Matz added a comment -

            Many thanks Alexey.

            I've not checked the result yet: Does MariaDB handle the shapes and not
            only the bounding boxes?

            Friedhold.

            2013/1/16 Alexey Botchkov (JIRA) <jira@mariadb.atlassian.net>

            fmatz Friedhold Matz added a comment - Many thanks Alexey. I've not checked the result yet: Does MariaDB handle the shapes and not only the bounding boxes? Friedhold. 2013/1/16 Alexey Botchkov (JIRA) <jira@mariadb.atlassian.net>
            holyfoot Alexey Botchkov added a comment -

            New functions in MariaDB handle shapes, not the bounding boxes.
            The limitation at the moment - it only handles plain coordinate system. Can't handle geodetic coordinates properly.(MDEV-60)

            holyfoot Alexey Botchkov added a comment - New functions in MariaDB handle shapes, not the bounding boxes. The limitation at the moment - it only handles plain coordinate system. Can't handle geodetic coordinates properly.( MDEV-60 )
            fmatz Friedhold Matz added a comment -

            Good News!!

            Many thanks
            Friedhold.

            2013/1/16 Alexey Botchkov (JIRA) <jira@mariadb.atlassian.net>

            fmatz Friedhold Matz added a comment - Good News!! Many thanks Friedhold. 2013/1/16 Alexey Botchkov (JIRA) <jira@mariadb.atlassian.net>
            fmatz Friedhold Matz added a comment -

            Good News!

            I will check and verify the spatial results.

            So long,
            Friedhold

            2013/1/16 Alexey Botchkov (JIRA) <jira@mariadb.atlassian.net>

            fmatz Friedhold Matz added a comment - Good News! I will check and verify the spatial results. So long, Friedhold 2013/1/16 Alexey Botchkov (JIRA) <jira@mariadb.atlassian.net>
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1.0 [ 12200 ]
            serg Sergei Golubchik made changes -
            Labels gis
            serg Sergei Golubchik added a comment -

            hf said it's almost ready to be pushed

            serg Sergei Golubchik added a comment - hf said it's almost ready to be pushed
            fmatz Friedhold Matz added a comment -

            Hi Sergey,

            many thanks.
            Where can I find the download link for 10.1.0 ?

            Best,
            Friedhold.

            fmatz Friedhold Matz added a comment - Hi Sergey, many thanks. Where can I find the download link for 10.1.0 ? Best, Friedhold.
            serg Sergei Golubchik added a comment -

            10.1.0 is not released yet. We're discussing now what tasks will be in 10.1 and what tasks will be postponed to 10.2. But it looks like this task will be in 10.1, give it few more months, please, and you'll have a download link.

            serg Sergei Golubchik added a comment - 10.1.0 is not released yet. We're discussing now what tasks will be in 10.1 and what tasks will be postponed to 10.2. But it looks like this task will be in 10.1, give it few more months, please, and you'll have a download link.
            fmatz Friedhold Matz added a comment -

            Hi Sergei,

            many thanks for your answer and let me know it.

            2014-04-18 13:35 GMT+02:00 Sergei Golubchik (JIRA) <

            fmatz Friedhold Matz added a comment - Hi Sergei, many thanks for your answer and let me know it. 2014-04-18 13:35 GMT+02:00 Sergei Golubchik (JIRA) <
            ratzpo Rasmus Johansson (Inactive) made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 25918 ] MariaDB v2 [ 42615 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.1.0 [ 12200 ]
            holyfoot Alexey Botchkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            holyfoot Alexey Botchkov made changes -
            Component/s GIS [ 10105 ]
            Fix Version/s 10.1.2 [ 15801 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            holyfoot Alexey Botchkov made changes -
            Resolution Done [ 10000 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Due Date 2014-11-26
            holyfoot Alexey Botchkov added a comment -

            Patch :
            http://lists.askmonty.org/pipermail/commits/2014-November/007081.html

            holyfoot Alexey Botchkov added a comment - Patch : http://lists.askmonty.org/pipermail/commits/2014-November/007081.html
            holyfoot Alexey Botchkov made changes -
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            elenst Elena Stepanova made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 42615 ] MariaDB v3 [ 65383 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 65383 ] MariaDB v4 [ 132055 ]

            People

              holyfoot Alexey Botchkov
              fmatz Friedhold Matz
              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.