Geocoding with Radian Studio

Recently my students and I wrote a paper on geocoding with different Python tools here. While that was really fun, it does take a bit of work to write the code.  As you know, I’m partial to doing anything I can with SQL.  My attempts to build geocoding into PostgreSQL has not been very successful, although my friends who use Linux versions have had better success.

So, I was really happy to see that Radian built in many geocoding servers into their product, and the functionality is accessible via SQL.   The following video shows how to use the Google geocoder through Radian, and I’ve added a little wrinkle: some of the locations are straight addresses, while others are intersections.  Using a very simple CASE statement, the addresses geocode effortlessly.  Check it out, and let me know what you think.

if you are interested in learning how to use Radian Studio, check out http://www.gisadvisor.com where I have 9 different training courses in geospatial technology. 

2 thoughts on “Geocoding with Radian Studio

  1. Really good, Art. So easy if the data is clean :). I can’t wait for the new Manifold GIS to put it and Radian working together.

  2. Pingback: More geocoding with Radian | gisadvising

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s