map plugin that pulls addresses from posts

[tyankee]

does anyone know of a map plugin that pulls addresses from posts? i have about 100 posts (customized to Apartment Projects) that all have an address and the client wants to see a map of all the locations in one place with markers to mark each location. all the map plugins i've used work great if you input map locations into them 1 at a time or even batch but new posts that have new locations would not be input into this map. that's why it would be much easier and cleaner if the map pulled the addresses from these posts. i'm not an expert coder but i'd give myself a B grade and do not know javascript at all.

example:
apartment 1 post - new orleans louisiana
apartment 2 post - new york city, new york
apartment 3 post - los angeles, california
apartment 4 post - boston, massachusetts

all these posts have pictures of the properites and a description and address. the individual maps on each page work great. but pulling them all into one map is the problem.

[not2easy]

In theory you could find the addresses in those posts using the .sql database but adding them to a map sounds like a separate process - and both steps would be manual editing. Do these addresses all have a distinct format so you could use RegEx to find them?

There are some specialized plugins for Real Estate listings, but I doubt you will find one that can automate the editing: [wordpress.org...]

[tyankee]

not2easy - yes these all can have an identifiing custom field that marks them as addresses to be mapped and the address IS in an address field. But not sure how RegEx would help?

[not2easy]

If you are going to edit your .sql file, Regex can be used to find each address. IF each address is listed in a format such as "City: Abcdefg" or "City: Abc Dfghi" for example, you could use RegEx to find each instance. Given that you are only talking about 100 posts to be edited to get the data, it might be simpler to view each post and copy the data from it. It would take a few days but less of a struggle than matching up data via editing the .sql tables.

Of course the easiest method is the one you feel conformable with. Viewing the posts to copy/paste into a spreadsheet would take maybe 3 weeks at a very relaxed pace of half a dozen a day.