Questions about Address Geocoder

[Dennis Gray]

CiviCRM 4.1.5

I have used the Smarty Streets service to geocode a significant portion of our civicrm_address table. I now would like to use the Address Geocoder scheduled job but have some questions.

• Does the Address Geocoder look to see if there is already a gecode for a record or does it make a call to the Google API, whether there is an existing geocode or not?
• When I use the "Execute Now" option on the Scheduled Jobs screen, the log shows the job starting but there never seems to be an entry when the job finishes.  What determines when the job stops?

I can see by executing this query that the job is actually running:

Code: [Select]

select count(*) from civicrm_address  where location_type_id = 6 and geo_code_1 is not null

(Location_type_id = 6 is the voting address of our contacts)

The count(*) increases and then stops increasing after a certain amount of time. There is no entry in the log that shows when the job stopped running.

[Dennis Gray]

Surely someone must know something about this feature.

To add to my question, I did manuall run the script that the cron job would be executing. After several moments, it stopped geocoding after 1717 address records, however the script is still running after about 20 minutes. There doesn't seem to be any activity.

1717 records is a bit below Google's daily limit so I would like to be able to increase that, if possilble.

[Dennis Gray]

I finally stopped the script with kill -1. Nothing was written to the log.