Geo Mashup
Copy Geodata Meta Fields option (4 posts)

  1. ChubbyEatsNY
    Posted 3 years ago #

    I have my list of all my addresses in 'wp_postmeta', using metatag 'address'. Is there a way for me to copy all the addresses over?
    Below is an record in the database table.

    meta_id post_id meta_key meta_value
    20046 7882 address 300 W 22nd St, New York, NY 10011



  2. Dylan Kuhn
    Plugin Author

    Posted 3 years ago #

    Setting the Geocode Custom Field setting to 'address' will work for newly added fields, but not existing ones. Doing bulk geocoding is tricky because most services will limit the speed and number of requests you can make. There is an open feature request for it here:


    There may be other batch geocoding solutions that would allow you to import geo_latitude and geo_longitude fields.

  3. ChubbyEatsNY
    Posted 3 years ago #

    I couldn't find any other solution to import. Do you have the SQL script that copies the custom field to the geo table when an update is performed? I think if I use the postID, I can quickly update the post and populate the geo mashup tables?

  4. Dylan Kuhn
    Plugin Author

    Posted 3 years ago #

    There isn't a SQL script - the GeoMashupDB::copy_from_geodata() function uses the WordPress API to do it. If you already have latitude and longitude, though, enabling Geo Mashup's "Copy Geodata Meta Fields" setting and then using another plugin to bulk load geo_latitude and geo_longitude should work.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic


No tags yet.