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.
          • Stalled

          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.
          • Stalled
          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.
          • Stalled

          Activity

            Transition Time In Source Status Execution Times
            Dave Gosselin made transition -
            Open In Progress
            		63d 19h 22m 1
            Dave Gosselin made transition -
            In Review In Testing
            		12d 22h 54m 1
            Alice Sherepa made transition -
            In Testing Stalled
            		195d 23h 25m 1
            Dave Gosselin made transition -
            Stalled In Progress
            		44d 36m 1
            Dave Gosselin made transition -
            In Progress In Review
            		2h 32m 2
            Daniel Black made transition -
            In Review Stalled
            		6h 34m 1
            Dave Gosselin made transition -
            Stalled Closed
            		16h 1m 1

            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.