I am struggling to find the solution for the following situation: I am building a tourism site with POIs as nodes (Drupal 7). The POIs are categorized/tagged in a State-County-City hierarchical vocabulary. I want to add two another cathegories - Historical region and Tourism region. Each City belongs to exactly one historical region and one tourism region and these regions do not cover the same area (meaning that e.g. two cities belong to the same county, but to different historical and tourism regions). While creating new node/POI the user/editor selects the State-County-City via Simple Hierarchical Select module (this structure is generally well-known) and I want to automatically assign the corresponding Historical and Tourism region to the node, based on the City selected (as the division into Historical and Tourism regions is not obvious for the general userbase, but I have the corresponding database available).
How to generate the relationship between the terms for Cities in the State-County-City vocabulary with the corresponding Historical and Tourism regions, while maintaining the possibility to list all nodes/POIs in a State/County/City/Historical region/Tourism region?
I have thought about having two additional vocabularies but failed to find a way to connect them with the City terms in the first. I also thought about having multiple parent terms in one vocabulary for the Cities - but this messes up the vocabulary (and Simple Hierarchical Select) completely and is therefore inapplicable. Any help appreciated.