Anything Geospatial (AnyGeo.com) The GIS, mapping, mashup, and geospatial weblog - see GISuser.com for even more!

Developed & maintained by Glenn (Founder of GISuser.com, LBSzone & SymbianOne)

Batch geocoding from simple text output using Yahoo! maps

Friday, January 20, 2006 11:45:42 PM

, , , ,

James Fee (www.spatiallyadjusted.com) provided a pointer to this batch geocoder that I just had to check out. The page requests the user simply provide "any kind" of address data from a "simple" format - ie. simply paste address, city, state, ZIP, description, url from an excel spreadsheet. the app validates the source code, then requests the user to specify columns (I was a bit lost on what exactly step 4 does!). Finally, the geocoder runs and displays the output in tabular format with the geocoding output (lat/long) as well as on a map - using Yahoo! maps. Some info provided about the technology behind the scenes... This tool makes primary use of JavaScript ON Demand (JSOD) and JSON to dynamically call and interact with the Yahoo! REST Geocoding API. All you need is somple simple tabular address data and your web client. Ironically, shortly after posting this I heard from the developer, Phillip Holmstrand. He share's this information about the app... You can copy/paste directly from Excel, geocode, and then copy right back into Excel, and/or see addresses on a map instantly. It uses Yahoo's Geocoding API, which is nothing new, but what's nice is it allows batch processing of tabular data. Best news, it's free, and you can geocode up to 50,000 addresses per day.Check it out at http://www.batchgeocode.com/

Free Software Foundation releases draft of GNU General Public License v3Opportunity - Exploring Marine GIS: An ArcGIS Field and Lab Course

Comments

Anonymous Tuesday, October 24, 2006 6:15:51 PM

Anonymous writes: great

Anonymous Sunday, February 4, 2007 11:58:04 AM

Michael writes: this is great it saves so much time!!!!

Anonymous Friday, June 27, 2008 2:58:54 PM

Xun writes: The drawback of the above service you have to do the whole thing manually and cannot use the geocoded result on the fly. The alternative is to use Yahoo Geocoding to batch geocode a list of addresses and write it into a xmldocument and directly plug into a google map or something. This article writes about how to go from a webpage to geocoding to mapping. Check it out. http://dotnetslackers.com/articles/aspnet/The-wild-wide-web-for-mapping.aspx

Anonymous Saturday, January 24, 2009 6:57:10 PM

dwgold writes: Another option is the USC Geocoder (https://webgis.usc.edu) where you can upload a database of addresses (mdb, csv, txt) for online processing or use the APIs or web forms to process addresses one at a time.

Anonymous Tuesday, February 2, 2010 3:33:32 AM

Anonymous writes: Seems the page is broken - .js error

Anonymous Thursday, September 23, 2010 10:28:34 PM

hhc_llc writes: www.batchgeocode.com dropped the feature "show geocode" so to get them you have to use alternative like get the KML and parse it. EEEK. the webgis.usc.edu site referenced above by dwgold works nice even if you have to pay a tiny bit after 2500 free lookups.

Anonymous Monday, November 1, 2010 10:11:36 AM

Maurice Calvert writes: I've developed an addin for Excel which does forward/reverse geocoding and GCD with GoogleMaps. Freeware: http://www.calvert.ch/geodesix/

How to use Quote function:

  1. Select some text
  2. Click on the Quote link

Write a comment

Comment
(BBcode and HTML is turned off for anonymous user comments.)

If you can't read the words, press the small reload icon.


Smilies

February 2012
S M T W T F S
January 2012March 2012
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29

My Websites

Blogroll

GISuser.com site updates

Symbian OS News from SymbianOne

    Updates at Planet Geospatial (Geo blog aggregator)

    • Nokia Email Service (NES) the Free Beta servic ...

      Today I was offered an invitation to sit in on an informal Q&A with the Nokia Email Service (Beta) Management Team. Via Tangler, we bombarded the team with questions for an hour. the following... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

    • A Look at Google Earth API

      Google’s earth viewer plugin is available for use in browsers on Windows and Vista, but not yet Linux or Mac. This latest addition to Google’s family of APIs (yet another beta) lets developers make use of the nifty 3D navigation found in the standalone Google Earth. However, as a plugin the deve ...

    • I Come to Praise the Web ADF, Not to Bury It

      I was just talking to someone today about web applications for ArcGIS Server 9.3 and they were surprised that I was using the Web ADF to create an application after my post earlier this week on the JavaScript API.  I feel like I need to clarify some things about that post.  It wasn’t so much [...]

    • Blackberry Applications

      A reminder to Blackberry device users, if you need apps be sure to consult this fine Application Shop from Blackberry (RIM) - see here For more suggested apps, developer tips, and news for Blackberry... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

    • Terrain of Google Earth - Awesome Tour

    Syndication & Tools

    GISuser Flickr feed

    Via Virtual Earth Feed

      Search Technorati

      Dev links

      ESRI Blog - Geography Matters

      • GIS Day 2008 Promotional Flier

        The new GIS Day 2008 flier is now available!  GIS Day is fast approaching on November 19th and the new flier provides both information and inspiration for celebrating your event.  This colorful flier encourages educators, professionals, and students alike to participate in this global ...

      • GIS Volunteers for Barack Obama

        Students with GIS experience can put their skills to use as a volunteer for Barack Obama's presidential campaign. GIS Intern, Barack Obama Campaign Office, Chicago (March 17, 2008)The Barack Obama campaign is looking for a few good GIS interns in our Chicago office. Campaigns are spatially bas ...

      • GIS Day Anniversary Display

        This year marks the tenth anniversary of GIS Day.  To commemorate this milestone, there will be a special display at the 2008 ESRI International User Conference.  The multi-panel display will include photos of GIS Day events worldwide, the history of GIS Day, and a few featured events ...

      • Governor of California Acknowledges Benefits o ...

        "Well, we are now, because of her (State Chief Information Officer Teri Takai) help, we are moving full steam ahead. A perfect example is, for instance, GIS. GIS is a form of digital mapping technology, kind of like Google Earth but better. (Laughter) During last year's firestorm it allowed fire ...

      • New GIS Day Poster

        The new GIS Day poster is an ideal educational tool for K-12 students. The front side is a colorful poster containing GIS Day photos from over the years. The inside provides a brief overview of GIS and encourages readers to explore GIS by hosting a GIS Day event, thinking about a future in GIS, ...

      Dr Dobbs Journal

      • The Great Debate: PostgreSQL vs. MySQL

        Common industry perceptions of MySQL and PostgreSQL aren't as true with the current generation of releases as they used to be. DBAs, developers, and IT managers and decision-makers will benefit from this presentation and live Q&A about the pros and cons of using PostgreSQL or MySQL, which wi ...

      • Extending Enterprise Value with Web 2.0

        In this webcast we will talk about how to simply build and quickly remix Web 2.0 applications and the role of the IT department and how they support mashups. We will discuss how IBM can help IT teams adapt existing enterprise systems as well as develop unique ones that can support end user drive ...

      • 2008 International Mathematica Conference

        Dr. Dobb's interviews Wolfram Research's Theo Gray, co-founder and Director of User Interfaces, and Robert Germundsson, Director of Research and Development, about the upcoming 2008 International Mathematica Conference.

      • How Do You Do Nightly Builds and Tests when th ...

        Attend this Webcast and find out how to overcome common build-test-deploy challenges that affect all members of a distributed team, including: <ul> <li> Communication difficulties, because of time-zone and cultural differences</li> <li> Workflow challenges, like lack o ...

      • What Zope Did Wrong (and How It's Being Fixed)

        Dr. Dobb's talks with Lennart Regebro about the many things that Zope 2 did right and did wrong. Lennart has also been one of the driving forces behind Five, the integration of Zope 3 technologies into Zope 2.