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.
-
1Google Fusion Tables are a database - so you want to COPY from your wordpress database to your fusion table?Mapperz– Mapperz ♦2011年10月31日 16:09:41 +00:00Commented Oct 31, 2011 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– Rob2011年10月31日 16:11:29 +00:00Commented Oct 31, 2011 at 16:11
-
1Interesting. 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– Chad Cooper2011年10月31日 16:16:10 +00:00Commented Oct 31, 2011 at 16:16
-
3Not 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– Mapperz ♦2011年10月31日 16:28:09 +00:00Commented Oct 31, 2011 at 16:28
-
1Sorta. 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– Chad Cooper2011年10月31日 16:37:24 +00:00Commented Oct 31, 2011 at 16:37
2 Answers 2
- You have to export your table to csv
- Maybe use google refine to improve the data of your articles csv
- Import csv in a Fusion Table
- Geocode the table, its a feature in the user interface, you Geocode by the column "Article text" where the addresses are
- 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.
- You can geocode by yourself using geonames or another Geocoding API
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.