[GIS] Using Google Fusion Tables to read WordPress database… which in turn creates map. Can it be done

google mapsgoogle-fusion-tables

Is it possible for Google Fusion Tables to read my WordPress database? If so, how?

I have custom wordpress fields which contain addresses for several hundred companies. Ideally I want Google Fusion Tables to read the database.

Hopefully this will overcome two major problems 1. Avoid the geocode limit (currently done using a time delay, which isn't ideal). 2. Obfuscate my data so it's protected.

Really need someone's help with this.

Best Answer

  1. You have to export your table to csv
  2. Maybe use google refine to improve the data of your articles csv
  3. Import csv in a Fusion Table
  4. Geocode the table, its a feature in the user interface, you Geocode by the column "Article text" where the addresses are
  5. Click on the map view, and you could view the points, some of them will be missing because of an unsuccessful geocoding

If only want to know if it is possible the answer is yes, the limit is the geocoding capacity of google to get addresses inside your text.

  1. You can geocode by yourself using geonames or another Geocoding API
Related Question