Opened 9 years ago

Closed 9 years ago

#3313 closed defect (invalid)

Where is monkey town? ST_PointFromGeoHash regression difference between 2.1.8 and 2.2.0

Reported by: robe Owned by: pramsey
Priority: medium Milestone: PostGIS 2.2.0
Component: postgis Version: master
Keywords: Cc:

Description (last modified by robe)

Which one of these is the right answer or are they both wrong?

SELECT  ST_AsText(ST_PointFromGeoHash('monkey')) As output,
  ST_GeoHash(ST_PointFromGeoHash('monkey'));

In:

POSTGIS="2.2.0dev r14180" GEOS="3.5.0-CAPI-1.9.0 r4090" PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 2.0.1, released 2015/09/15" LIBXML="2.7.8" LIBJSON="0.12" RASTER

                  output                   |      st_geohash
-------------------------------------------+----------------------
 POINT(53.9593505859375 -21.6732788085938) | mhnkeys0000000000000
(1 row)

POSTGIS="2.1.8 r13780" GEOS="3.5.0-CAPI-1.9.0 r4088" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER

                  output                   |      st_geohash
-------------------------------------------+----------------------
 POINT(53.9593505859375 -44.1732788085938) | m0nkeys0000000000000
(1 row)

I have to say I find the 2.1.8 answer more visually appealing

Change History (7)

comment:1 by robe, 9 years ago

Summary: Where is money town? ST_PointGeoHash regression differnce between 2.1.8 and 2.2.0Where is money town? ST_PointGeoHash regression difference between 2.1.8 and 2.2.0

comment:2 by robe, 9 years ago

Description: modified (diff)

comment:3 by robe, 9 years ago

Summary: Where is money town? ST_PointGeoHash regression difference between 2.1.8 and 2.2.0Where is monkey town? ST_PointGeoHash regression difference between 2.1.8 and 2.2.0

comment:4 by robe, 9 years ago

Summary: Where is monkey town? ST_PointGeoHash regression difference between 2.1.8 and 2.2.0Where is monkey town? ST_PointFromGeoHash regression difference between 2.1.8 and 2.2.0

comment:5 by pramsey, 9 years ago

Ha. Ha. geohash.org agrees with 2.2 http://geohash.org/mhnkey

comment:6 by pramsey, 9 years ago

Actually, sorry, they are both wrong, since as geohash.org notes, 'monkey' is not a valid geohash. So it's all about how one (mis)interprets it

comment:7 by pramsey, 9 years ago

Resolution: invalid
Status: newclosed
Note: See TracTickets for help on using tickets.