mapping existing data with OpenLayers Geocoder?

Subscribing to this. I'm looking for something similar that allows geocoding of existing data, or bulk imported data through Feeds / FeedAPI etc. Using Location module at the moment as that feature's already there.

Also looking for a solution to this. I've been using batch geocoding websites to upload a csv, get the lat/lon, put it in the appropriate format for the WKT field, and uploading using Feeds. I've found that none of the geocoding services available for free are very accurate. I can't have addresses in Brooklyn being shown on the map in Buffalo. I'm pretty close to manually editing which would really be very time consuming. I'm no programmer, but it seems there ought to be a way to write some sort of script that uses the Openlayers geocoding to batch process large data sets outside of the Drupal framework.

subscribing.

Sub! I would love to be able to import large .cvs files using Feeds, and just map the City column to the Geocoder field.

subscribe

Subscribe. Would love this functionality too.

I would guess this is a common question.

I did import a large batch using a cheap zip code long / lat converter, but one great thing about Openlayers is it is more accurate than the zip code. So #2 can work. This is the company product I used to get long / lat.

http://www.cdxtech.com/CDXZipStream/Demo.aspx

Even better would be this module, Rules Geocoder:

http://drupal.org/project/rules_geocoder

However I can not get it to work for me.

http://drupal.org/node/1184888

I have tried all the location / proximity solutions in Drupal 6 over many months and OL seems the best, with just a few issues to resolve, this being one.

If anyone has found a solution for bulk geocoding within Drupal please post.

For zip code database, this was the cheapest I found, $5, though I have not tried it, found it too late.

http://www.getzipcodedata.com/

And for geocoding options, this also works:

http://drupal.org/node/853190

The problem with bulk imports, it requires the node to be saved after import for it to be geocoded. The Rules action Save does not work.

Here is someone who has been able to geocode Location fields using Openlayers and Rules Geocoder:

http://drupal.org/node/1202896

The link in #9 provides a very neat solution to a common problem.
We import address data to a custom content types all the time.
If we want to plot the existing data info on a map, other solutions like geo + geocoder are nothing but a headache. Rules_geoder is definitely the way to go! All you have to do is configure a new rule that updates the openlayers cck field on a node save trigger. Bulk updating now also works with views_bulkoperations. Hence, selecting all nodes from the custom content type and doing a bulk save works brilliantly. I use batch api to avoid geocoding service timeouts.