Geohash functions in SQL Server?

Question

Are there any built in functions for dealing with geohashes in SQL Server? Either to go to/from polygon representations or to get the center point? I looked through the geography functions here but didn't see anything...

If there aren't built in functions is anyone aware of any definitions for user defined functions that might be floating around out there that do this? I know that the algorithm is publicly available but I'd rather not roll my own SQL implementation if it's already been done.

Answer 1

I created a basic user sclarar function that accomplishes some of this:

https://github.com/Broham/SQL-Server-Geohash

Currently it will just take a geohash and return it's center lat/long but it could easily be modified to return a bounding box, get a geohash for a lat/long or any other number of use cases. Hope this is helpful to someone

Answer 2

After searching for a SQL Server TSQL implementation of Geohash types and conversion functions, I finally just went and wrote a whole open-source library myself:

• Github: QalGeohash-TSQL

I designed it for maximum accuracy, performance, and strong conversion consistency guarantees. It is enabling an average IT data warehouse analyst or report writer to efficiently use, process, and leverage simple GIS spatial proximity models and queries. And it accomplishes all this without requiring said analyst or report writer to engage in the steep learning curve of finding and adopting a full GIS style solution.

It provides two Geohash implementation types; Integer (BIGINT) and String (VARCHAR). It also provides two coordinate types; Longitude+Latitude and DMS. And then it provides the conversions to and from these various types. It also provides conversions to/from the SQL Server spatial geography Point type.

Please see the README.md for detailed information.