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

Implement the GIS function ST_GeoHash

Details

    Description

      The GIS function ST_GeoHash takes as input:

      • (longitude, latitude, max_length), OR
      • (point, max_length)

      The longitue parameter is a numeric value in the interval [180, -180], the latitude is a numeric value in the interval [90, -90].
      In the case of point, the x coordinate is treated as the latitude and the y coordinate is treated as the latitude. Even in the case of a point, the same constraints apply.
      The max_length parameter is the upper limit on the resulting string size and cannot exceed 100.

      The function returns the geohash corresponding to the input values.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34159 Implement the GIS function ST_LatFromGeoHash

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34160 Implement the GIS function ST_LongFromGeoHash

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-17398 Implement Geographic functions available in MySQL 8.0

          • Major - Major loss of function.
          • Stalled

          Task - A task that needs to be done. MDEV-34120 GSoC 2024, Spatial (GIS) functions in MariaDB

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Stefano Petrilli Stefano Petrilli created issue -
            Stefano Petrilli Stefano Petrilli made changes -
            Field Original Value New Value
            Stefano Petrilli Stefano Petrilli made changes -
            Stefano Petrilli Stefano Petrilli made changes -
            Stefano Petrilli Stefano Petrilli made changes -
            serg Sergei Golubchik made changes -
            Assignee Dave Gosselin [ JIRAUSER52216 ]
            Gosselin Dave Gosselin made changes -
            Fix Version/s 11.7 [ 29815 ]
            Gosselin Dave Gosselin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            Gosselin Dave Gosselin made changes -
            Assignee Dave Gosselin [ JIRAUSER52216 ] Alexey Botchkov [ holyfoot ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            Gosselin Dave Gosselin made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            Gosselin Dave Gosselin made changes -
            Assignee Alexey Botchkov [ holyfoot ] Dave Gosselin [ JIRAUSER52216 ]
            serg Sergei Golubchik made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility GIS gsoc24 Compatibility GIS Preview_11.7 gsoc24
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.8 [ 29921 ]
            Fix Version/s 11.7 [ 29815 ]
            Assignee Dave Gosselin [ JIRAUSER52216 ] Alice Sherepa [ alice ]
            serg Sergei Golubchik made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility GIS Preview_11.7 gsoc24 Compatibility GIS Preview_11.7 Preview_11.8 gsoc24
            alice Alice Sherepa made changes -
            Assignee Alice Sherepa [ alice ] Dave Gosselin [ JIRAUSER52216 ]
            alice Alice Sherepa made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 12.0 [ 29945 ]
            Fix Version/s 11.8 [ 29921 ]
            Gosselin Dave Gosselin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            Gosselin Dave Gosselin made changes -
            Assignee Dave Gosselin [ JIRAUSER52216 ] Daniel Black [ danblack ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            danblack Daniel Black made changes -
            Assignee Daniel Black [ danblack ] Dave Gosselin [ JIRAUSER52216 ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            Gosselin Dave Gosselin made changes -
            Fix Version/s 12.0.2 [ 30117 ]
            Fix Version/s 12.0 [ 29945 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            Gosselin Dave Gosselin made changes -
            Fix Version/s 12.1 [ 29992 ]
            Fix Version/s 12.0.2 [ 30117 ]

            People

              Gosselin Dave Gosselin
              Stefano Petrilli Stefano Petrilli
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.