Froide

Excel geocoding tool V3

As Meg Stewart stated in the GIS @ Vassar blog, "Geocoding in ArcGIS is not pleasant. Success rates hit a high of about 70 percent, in my experience." We all feel your pain, especially those of us in education where we are constantly put in the position where we need to explain this geocoding unpleasantness at least once per week.

The GIS @ Vassar post points out the fantastic BatchGeocode.com, which makes up a major component of my My Powerful Geospatial Suite of Free GIS.

However, lately I have been directing students to download and use the Juice Analytics: Excel Geocoding Tool. I first learned of this tool via Ogle Earth last year, but for whatever reason, it is only lately that I have really begun appreciating it.

The Excel Geocoding Tool is a downloadable Excel file with super-easy-to-use Macros built into it, so of course you need to enable Macros to use this tool. There are two worksheets. The first worksheet prompts which geocoding service to use (Yahoo! API or geocoder.us). Yeah...who's going to use geocoder.us when compared to Yahoo! Maps API? The second sheet has fields for address, city, state, and zip. Paste tens, hundreds, or thousands (I have never done more than 2, 000) of addresses into this sheet, click Geocode All Rows, and voila. At lightening speeds compared to BatchGeocode.com, the lat/long of each address appear in the first two columns. The 500 addresses per geocode limit in BatchGeocode.com is nowhere to be seen with this tool. Another advantage is this Excel tool provides the geocoding precision level for each address, which is truly, truly wonderful. Not nearly as powerful as ArcMap's geocoding score, but for each geocoded address, this tool specifies whether the supplied lat/long is matched for the specific address, street, zip code, or city. Just like BatchGeocode.com, the Excel Geocoding Tool can even create KML files.

You might also like
Maps for Business: Generating Valid Signatures
Maps for Business: Generating Valid Signatures
BatchGeo - Wikipedia example, map in seconds
BatchGeo - Wikipedia example, map in seconds

Web Site Shows Neighbor Campaign Donations

Just type your address and ZIP code into the "Neighbor Search" tool at fundrace.org, and you'll get a list of what your neighbors gave to any of the presidential candidates last year - and how much.
Your nearest neighbors are listed first.
The tool uses technology called geocoding, which matches street addresses with longitude and latitude data. The match works about 70 percent of the time; in cases of failure, results are given based on ZIP code. Visitors can also search by name.
Candidates, by law, are required to disclose contributions of $200 or more, and the Federal Election Commission makes databases available for download

Vintage History 1871 Map of Brazil, Bolivia, Paraguay, Uruguay & Chili of Brazil, Bolivia, Parag
Home (Vintage History)
  • 1871 Map of Brazil, Bolivia, Paraguay, and Uruguay ; Map of Chili. Scale ca. 1:10,, (W 74, W 69/S 24, S 42). Relief shown by hachures. Scale ca. 1:20,, (W 73, W...
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction

7 Game of Thrones Apps That Will Get You Through the Much-awaited Winter  — Gizmodo India
.. or Winterfell, you get a dialog box, which asks you to buy more maps. Unfortunately, you can't dismiss the dialogue box, leading to the obstruction of the cartography. ..

Flagstaff's rocky lava field became a little piece of the moon  — azcentral
If American know-how could put a man on the moon, the man should bring back rocks to study. The government agreed, and in 1963, the .. Volcanoes were chosen because of the moon's volcanic history, the test site for its impact craters.

Vintage History 1864 Civil War Map Petersburg shows Federal forces of the environs of Petersburg
Home (Vintage History)
  • 1864 Map of the environs of Petersburg from the Appomattox River to the Jerusalem Plank Road showing entrenchments occupied by Federal forces / Engineer Department...
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction

Missing in Alaska without a trace  — Anchorage Daily News
The official version of events, according to a still active missing person's bulletin from the Alaska State Troopers is that Griffis went into the wild "to test out a survival 'cocoon' that he had invented.

Vintage History 1895 Map of Knox County, Tennessee
Home (Vintage History)
  • 1895 Map of Knox County, Tennessee
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction
Vintage History 1746 map of Camarones Bay, Argentina, showing Camarones Bay and adjoining capes,
Home (Vintage History)
  • 1746 Map showing Camarones Bay and adjoining capes, Argentina. Oriented with north to the right.
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction
Lowrance Lowrance Elite-7 Gold CHIRP Fishfinder/Chartplotter with 83/200 KHz and 455/800 KHz Transducer and Navionics Cartography
GPS or Navigation System (Lowrance)
  • 7 Widescreen LCD
  • Includes Navionics Gold Cartography
  • Broadband CHIRP and Hi-Def. Down Imaging Sonar
  • Includes 83/200+455/800KHz transom mount transducer
  • Built-in GPS
Related Posts