Geohash funcitons in SQL Server?
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.
sql
sql-server 
azure-sql-database asked Nov 14 '18 at 16:39
Abe MiesslerAbe Miessler
53.4k68248407
add a comment |
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.
sql
sql-server azure-sql-database asked Nov 14 '18 at 16:39
Abe MiesslerAbe Miessler
53.4k68248407
There aren't any such functions native to sql server. This is the first thing I've read about geohashes but I've done similar things with Lat/Lng coordinates. You can do the same "proximity" thing with Lat/Lng by simply adding & substacting vales to create a range.
– Jason A. Long
Nov 14 '18 at 22:04
add a comment |
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.
sql
sql-server azure-sql-database asked Nov 14 '18 at 16:39
Abe MiesslerAbe Miessler
53.4k68248407
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.
sql
sql-server azure-sql-database sql
sql-server azure-sql-database asked Nov 14 '18 at 16:39
Abe MiesslerAbe Miessler
53.4k68248407
asked Nov 14 '18 at 16:39
Abe MiesslerAbe Miessler
53.4k68248407
asked Nov 14 '18 at 16:39
Abe MiesslerAbe Miessler
53.4k68248407
asked Nov 14 '18 at 16:39
Abe MiesslerAbe Miessler
53.4k68248407
asked Nov 14 '18 at 16:39
Abe MiesslerAbe Miessler
53.4k68248407
53.4k68248407
There aren't any such functions native to sql server. This is the first thing I've read about geohashes but I've done similar things with Lat/Lng coordinates. You can do the same "proximity" thing with Lat/Lng by simply adding & substacting vales to create a range.
– Jason A. Long
Nov 14 '18 at 22:04
add a comment |
There aren't any such functions native to sql server. This is the first thing I've read about geohashes but I've done similar things with Lat/Lng coordinates. You can do the same "proximity" thing with Lat/Lng by simply adding & substacting vales to create a range.
– Jason A. Long
Nov 14 '18 at 22:04
There aren't any such functions native to sql server. This is the first thing I've read about geohashes but I've done similar things with Lat/Lng coordinates. You can do the same "proximity" thing with Lat/Lng by simply adding & substacting vales to create a range.
– Jason A. Long
Nov 14 '18 at 22:04
There aren't any such functions native to sql server. This is the first thing I've read about geohashes but I've done similar things with Lat/Lng coordinates. You can do the same "proximity" thing with Lat/Lng by simply adding & substacting vales to create a range.
– Jason A. Long
Nov 14 '18 at 22:04
add a comment |
1 Answer
1
active
oldest
votes
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
answered Dec 5 '18 at 18:45
Abe MiesslerAbe Miessler
53.4k68248407
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53304937%2fgeohash-funcitons-in-sql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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
answered Dec 5 '18 at 18:45
Abe MiesslerAbe Miessler
53.4k68248407
add a comment |
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
answered Dec 5 '18 at 18:45
Abe MiesslerAbe Miessler
53.4k68248407
add a comment |
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
answered Dec 5 '18 at 18:45
Abe MiesslerAbe Miessler
53.4k68248407
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
answered Dec 5 '18 at 18:45
Abe MiesslerAbe Miessler
53.4k68248407
answered Dec 5 '18 at 18:45
Abe MiesslerAbe Miessler
53.4k68248407
answered Dec 5 '18 at 18:45
Abe MiesslerAbe Miessler
53.4k68248407
answered Dec 5 '18 at 18:45
Abe MiesslerAbe Miessler
53.4k68248407
53.4k68248407
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53304937%2fgeohash-funcitons-in-sql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
There aren't any such functions native to sql server. This is the first thing I've read about geohashes but I've done similar things with Lat/Lng coordinates. You can do the same "proximity" thing with Lat/Lng by simply adding & substacting vales to create a range.
– Jason A. Long
Nov 14 '18 at 22:04