There has been a request to be able to attach multiple locations to a node so that users that a particular piece of content can be searchable on a national, or state/province level....

The original request (by ramdak5000 in http://drupal.org/node/18917#comment-33117) presents the use-case of being able to post content that applies to every postal code of a certain region or postal code.

There are several strategies to implement this type of functionality and I wanted to get back the thoughts of others. This isn't something that will happen immediately, but I would definitely be interested in input from others. The only idea I have for this as of now is:

Modifying the interface to allow the user to be able to select all postal codes within a certain province or country. This would create a seperate entry in the location_node table for each postal code. The query, however, would do a select distinct by nid and somehow return the node once, with the distance being listed as the distance of the closest postal code to the search-point parmater.

Comments

boris mann’s picture

boris mann commented

Out of scope for the main location API / module -- have someone code an add on module that ties into the location table if they want to build a model for this.