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.
          • In Testing

          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.
          • In Testing
          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.
          • In Testing

          Activity

            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.