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.

  • 1
    Google Fusion Tables are a database - so you want to COPY from your wordpress database to your fusion table? – Mapperz Oct 31 '11 at 16:09
  • @Mapperz Yes, I want to copy specific data from my wordpress db to the fusion db. If it can be done automatically then even better. – Rob Oct 31 '11 at 16:11
  • 1
    Interesting. Now, I have no idea if this will work, as I have never worked with Fusion Tables, but I think it's worth looking into. What about using PHP to push your database content out to XML, as in this Google Maps API article? Basically it queries the table and pushes the result out to a XML file, then Google Maps reads it. Can this also be done for Fusion Tables - have it read the dynamic XML file? – Chad Cooper Oct 31 '11 at 16:16
  • 3
    Not sure this is GIS SE question but Yes Export your Wordpress DB en.support.wordpress.com/export csv format - load in csv into fusion tables comma-separated text (.csv) 100mb limit - – Mapperz Oct 31 '11 at 16:28
  • 1
    Sorta. The link to the Google Maps API example explains it better, but it uses PHP to query your database (in your case your WP table), push the query results to a XML file, then maybe somehow have your Fusion Table slurp in that XML with every map request...maybe? – Chad Cooper Oct 31 '11 at 16:37
  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
| improve this answer | |

There's no point and click way to do this. But hiring someone to write the script you need is not hard. The script must read your WordPress database, then write to fusion tables using the Fusion Tables SQL API. Maybe a $100-$200 job. Then you need a way to run the script every so often (nightly?). Your web host may have "cron" jobs available for this purpose.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.