Geocode It!

GeocodeIt! is a custom application that allows you load addresses from either a file or a database, then run those addresses through a third-party online service to obtain standardized address and location information.

Location data is very important in many types of data warehouse and business information projects.  Obtaining standardized address information including addresses and latitude/longitude data enables your data warehouse to perform analyses that simply aren’t possible without it.  Unfortunately this data can often be expensive to obtain.  Many organizations will run their information through the an API like Google Maps, but be careful!  If you are storing the results of this data in your data warehouse, you are violating the Google terms of service and you could be forced to throw all of your hard work away – see below.

GeocodeIt! uses Geocode.Farm which is a service similar to Google that allows you to store the data locally so that you only need to check the address once.  (A separate subscription from Geocode.Farm is required to run more than 400 addresses per day.)  This software allows you to quickly get up-and-running with your Geocode project.  Contact Us today for more information on licensing this product.

 


 

Google Terms of Service: https://developers.google.com/maps/terms

Excerpt:

  1. No caching or storage. You will not pre-fetch, cache, index, or store any Content to be used outside the Service, except that you may store limited amounts of Content solely for the purpose of improving the performance of your Maps API Implementation due to network latency (and not for the purpose of preventing Google from accurately tracking usage), and only if such storage:
    1. is temporary (and in no event more than 30 calendar days);
    2. is secure;
    3. does not manipulate or aggregate any part of the Content or Service; and
    4. does not modify attribution in any way.
  2. No mass downloading. You will not use the Service in a manner that gives you or a third party access to mass downloads or bulk feeds of any Content. For example, you are not permitted to offer a batch geocoding service that uses Content contained in the Maps API(s).