Geocode Addresses in T-SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by David Rueter » Geocode Addresses in T-SQL

52 posts, Page 5 of 6

«««2 3 4 5 6 »»

Geocode Addresses in T-SQL

Rate Topic

Display Mode

Topic Options

Author

Message

DeusExDatum

Posted Monday, June 25, 2012 10:17 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, January 11, 2013 1:07 PM
Points: 587, Visits: 131

Yeah, I've been through this POC before and what I've discovered is that even if you have the Google Maps Premier license, you still can't use it for this sort of potential "Batch Geo-Coding" without running the risk of getting your licenses disabled. That being said, if you have a funded project, there are companies like Melissa Data or Telogys (sp) that can provide web or local implementations for you to Geocode with. Personally my experience is with Melissa Data; they will provide SSIS wrappers around their GeoCoding API, with unlimited Geo Lookups, and at least Quarterly updates of their files. Being that we are .NET savvy based on this discussion, it should be easy enough to write a CLR wrapper around their API to deliver GeoCoding from T-SQL.

Joshua T. Lewis

Post #1320735

cleonard 54659

Posted Friday, July 20, 2012 4:08 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 2:21 PM
Points: 3, Visits: 39

Don't see the sp_geoCode script?

Post #1333270

David Rueter

Posted Friday, July 20, 2012 6:13 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:22 PM
Points: 44, Visits: 357

The link to the original script is under "Resources" at the bottom of the article (http://www.sqlservercentral.com/articles/geocode/70061)

The direct link is: http://www.sqlservercentral.com/Files/Geocode.sql/6085.sql

Post #1333296

cleonard 54659

Posted Monday, July 23, 2012 10:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 2:21 PM
Points: 3, Visits: 39

Thank you!

Post #1333929

Naresh Parmar

Posted Monday, October 22, 2012 10:37 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, October 28, 2012 10:43 PM
Points: 3, Visits: 21

hi all,
i have created the SP, mention in this topic.

when i execute the sp : EXEC spGeocode '1234 N. Main Street, Santa Ana, CA'

i got NULL value in all the field.

am i missed any previous step ???

Thanks in advance.

Post #1375821

beetles

Posted Tuesday, October 23, 2012 1:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:40 AM
Points: 2, Visits: 14

Hi.. I did this for reverse geocoding. I changed the url to:
DECLARE @URL varchar(MAX)
SET @URL = 'http://maps.google.com/maps/api/geocode/xml?sensor=false&latlng=' +
CAST(@GPSLatitude AS VARCHAR(20)) +
',' + CAST(@GPSLongitude AS VARCHAR(20))

But it shows null. What should I do to show the address for specific Lattitude and longitude using this techinique?

Post #1375869

mr-967650

Posted Tuesday, October 23, 2012 8:01 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, October 23, 2012 8:21 AM
Points: 11, Visits: 40

Hello,

I would suggest to use Google API ver. 3 (the current one) rather than ver. 2 referred in this post. Therefore, the URL should be something like:

http://maps.googleapis.com/maps/api/geocode/.....etc' - ver. 3

instead of:

http://maps.google.com/maps/api/geocode/ - ver. 2

Post #1376067

mr-967650

Posted Tuesday, October 23, 2012 8:30 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, October 23, 2012 8:21 AM
Points: 11, Visits: 40

It works on my system, I get:

33.755319 -117.867595 Santa Ana CA 92701 1234 N Main St

but I modified the code to use Google API ver. 3 instead of ver. 2 referred in the article, please see the post just above this one.
Not sure though this is the reason, did you try to execute spGeocode with other parameter variations as described in the article?

Regards,
M.R.

Post #1376093

beetles

Posted Wednesday, October 24, 2012 6:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:40 AM
Points: 2, Visits: 14

thanx for the reply. I solved it with a little modification before seeing the reply... anywz, thnx again... Smile

Post #1376432

Naresh Parmar

Posted Thursday, October 25, 2012 10:32 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, October 28, 2012 10:43 PM
Points: 3, Visits: 21

hi ,
i have changed api url from v2 to v3.
still getting null value after trying this : EXEC spGeocode '1234 N. Main Street, Santa Ana, CA'

Thanks

Post #1377389

« Prev Topic | Next Topic »

52 posts, Page 5 of 6

«««2 3 4 5 6 »»

Permissions