CiviCRM Community Forums (archive)

I want to load a lot of latitude/longitude data into the geo_code_1 and geo_code_2 fields.

This is straightforward.

However, I wish to associate with that coordinates an accuracy flag (values 1-9).

I can create an "accuracy" custom field with combo box (easy) but I would like to have this field associated with the geo_code_1 and _2 fields on the contact input address form.
Also from a data management point of view I would like to put that accuracy field in the civicrm_address table but can understand if that is not possible.

So, questions are:

1. Is it possible to add a custom field to civicrm_address?
2. Regardless, can I associate the new custom field "accuracy" with the latitude/longitude input boxes on the address form of the contact create/update form? If so, how?

I have temporarily created a new set of custom fields called Mapping which has Latitude/Longitude/Accuracy fields. The problem with this is that the inbuilt geocoding engine fills in the geo_code_1 etc fields and not my latitude/longitude fields. I could create a database trigger to copy them across and keep them in sync but it would be nice to be able to tell CiviCRM to use my fields and not its geo_code_1/2 fields. Also, if I used my custom field set Mapping I would want to hide the current geo_code_1/2 fields.

Comments?

regards
Simon

In recent versions you can do this via admin UI. Just add a custom data set Used For = Addresses. Then add your Accuracy multiple choice field.

Example here on demo (until demo db is reset in any case):
http://drupal.demo.civicrm.org/civicrm/admin/custom/group/field?reset=1&action=browse&gid=7
http://drupal.demo.civicrm.org/civicrm/contact/add?reset=1&action=update&cid=102