Refactor/Coalesce Search Facets

[rm-hull]

Facet Analysis and Coalescing Report

This report analyzes the activities, estimated_duration, facilities, points_of_interest, and terrain facets from the GPS routes API. Similar attributes have been grouped under suggested names to improve data organization and searchability.

---

1. Activities

Group Name	Attributes to Coalesce
Bird watching	bird spotting, bird watching
Boating & Watersports	boat hire, boat ride, boat trip, boating, canoeing, dragon boating, jet skiing, kayaking, paddle boarding, pedalo hire, powerboating, raft building, rowing, sailing, standup paddleboarding, water based activity, watersports, windsurfing
Climbing & Scrambling	abseiling, climbing, rock climbing, scrambling
Cycling	cycling, mountain biking
Dog friendly	dog friendly, dog walking
Fishing	angling, fishing
Horse riding	equestrian, horse riding
Swimming	open water swimming, swimming, wild swimming
Wildlife watching	wildlife spotting, wildlife viewing, wildlife watching
Zip lining	zip lining, zip-lining

---

2. Estimated Duration

The existing categories are well-defined: less than 1 hour, 1 hour, 2 hours, 3 hours, 4 hours, 5 hours, 5-6 hours, half day, multiple days. No coalescing is recommended at this time.

---

3. Facilities

Group Name	Attributes to Coalesce
Bird hide	bird hide
Food & Drink	cafe, farm shop, pub, pub/cafe, restaurant, tea room, tea-house
Accommodation	camping site, campsite, youth hostel
Parking	car park, caravan park
Cycling facilities	bike hire, cycle hire, cycle path, cycle rack, cycle storage
Information points	information board, information centre, information panel, information point
Picnic area	BBQ area, picnic area, picnic bench, picnic facility, picnic site, picnic spot, picnic table
Public toilets	public toilet, toilet, toilets
Visitor centre	visitor centre

---

4. Points of Interest

Group Name	Attributes to Coalesce
Bird hide	bird hide
Castles & Ruins	castle, castle ruin, ruin
Gardens & Arboretums	arboretum, garden, gardens
Hills & Mountains	hill fort, hillfort, mountain, summit
Historical sites	historic site, historical site
Water features	lake, loch, pond, reservoir, tarn, waterfall
Nature reserves	national nature reserve, nature reserve
Parks	country park, park
Rivers, Canals & Harbours	canal, harbour, lock, river, weir
Sculptures	sculpture, sculpture trail
Villages	village, village green
Visitor centres	visitor centre

---

5. Terrain

Group Name	Attributes to Coalesce
Coastal & Beach	beach, coastal, dune, sand dune
Rivers & Wetlands	canal, canal towpath, canalside, lake, lakeside, marsh, marshland, river, riverbank, riverine, riverside, waterside, wetland
Grassland & Heathland	chalk downland, chalk grassland, common, downland, farmland, field, grassland, grassy, heath, heathland, meadow, pasture
Hills, Mountains & Cliffs	cliff, cliff top, gorge, hill, mountain, ridge, valley
Forest & Woodland	forest, woodland
Parks	park, parkland

[rm-hull]

Following further consideration, it is recommended to implement a Dynamic Reverse Mapping approach rather than modifying the raw data files in .

Why Dynamic Mapping?

• Data Integrity: Keeps raw source data pristine.
• Flexibility: Allows updating the taxonomy without needing to re-process the entire dataset.
• Decoupling: Separates the data model from the UI presentation.

Proposed Implementation

1. Mapping File: Create a JSON file (e.g., ) defining the mapping from raw attribute to coalesced name.
2. Runtime Aggregation: Load this into a Go map at startup for fast lookups. During facet retrieval, map raw counts to their coalesced counterparts.
3. Filtering Logic: Update the filter mechanism to expand coalesced names back into their constituent raw tags (e.g., filtering by 'Food & Drink' maps to an OR query for 'cafe', 'pub', 'restaurant').

[rm-hull]

To further refine the dynamic mapping strategy, here is the suggested implementation detail and the full, exhaustive JSON mapping based on all attributes found in the API facets.

Implementation Details

1. Storage: Define the mapping in config/facet_mapping.json.
2. Runtime Aggregation:
   • Load JSON into a map: map[string]map[string]string (e.g., facetType -> rawAttribute -> coalescedAttribute).
   • During API response generation, iterate over raw facet counts and aggregate them using the map.
3. Filtering Expansion:
   • When a filter for a coalesced name is received, perform a reverse lookup to find all raw attributes that map to it, then construct an OR query against the data source.

Full Exhaustive JSON Mapping

{
  "activities": {
    "abseiling": "Climbing & Scrambling",
    "angling": "Fishing",
    "archery": "Archery",
    "bird spotting": "Wildlife watching",
    "bird watching": "Wildlife watching",
    "boat hire": "Boating & Watersports",
    "boat ride": "Boating & Watersports",
    "boat trip": "Boating & Watersports",
    "boating": "Boating & Watersports",
    "canoeing": "Boating & Watersports",
    "caving": "Climbing & Scrambling",
    "climbing": "Climbing & Scrambling",
    "cycling": "Cycling",
    "dinghy sailing": "Boating & Watersports",
    "diving": "Diving",
    "dog friendly": "Dog friendly",
    "dog walking": "Dog friendly",
    "dragon boating": "Boating & Watersports",
    "equestrian": "Horse riding",
    "fishing": "Fishing",
    "fossil hunting": "Fossil hunting",
    "horse riding": "Horse riding",
    "jet skiing": "Boating & Watersports",
    "kayaking": "Boating & Watersports",
    "mountain biking": "Cycling",
    "open water swimming": "Swimming",
    "paddle boarding": "Boating & Watersports",
    "paddling": "Boating & Watersports",
    "pedalo hire": "Boating & Watersports",
    "picnic": "Picnic",
    "powerboating": "Boating & Watersports",
    "raft building": "Boating & Watersports",
    "rock climbing": "Climbing & Scrambling",
    "rowing": "Boating & Watersports",
    "sailing": "Boating & Watersports",
    "sand dune walk": "Walking & Strolling",
    "scrambling": "Climbing & Scrambling",
    "standup paddleboarding": "Boating & Watersports",
    "strolling": "Walking & Strolling",
    "swimming": "Swimming",
    "walking": "Walking & Strolling",
    "water based activity": "Boating & Watersports",
    "watersports": "Boating & Watersports",
    "wild swimming": "Swimming",
    "wildlife spotting": "Wildlife watching",
    "wildlife viewing": "Wildlife watching",
    "wildlife watching": "Wildlife watching",
    "windsurfing": "Boating & Watersports",
    "zip lining": "Zip lining",
    "zip-lining": "Zip lining"
  },
  "facilities": {
    "BBQ area": "Picnic facilities",
    "accommodation": "Accommodation",
    "art gallery": "Arts & Culture",
    "bench": "Rest & Amenities",
    "bike hire": "Cycling facilities",
    "bird hide": "Bird hide",
    "cafe": "Food & Drink",
    "camping site": "Accommodation",
    "campsite": "Accommodation",
    "car park": "Parking",
    "caravan park": "Parking",
    "community center": "Public facilities",
    "cycle hire": "Cycling facilities",
    "cycle path": "Cycling facilities",
    "cycle rack": "Cycling facilities",
    "cycle storage": "Cycling facilities",
    "dog friendly": "Amenities",
    "dog washing facility": "Amenities",
    "farm shop": "Food & Drink",
    "garden": "Nature facilities",
    "garden centre": "Nature facilities",
    "gift shop": "Retail",
    "information board": "Information",
    "information centre": "Information",
    "information panel": "Information",
    "information point": "Information",
    "museum": "Arts & Culture",
    "outdoor seating": "Rest & Amenities",
    "park": "Nature facilities",
    "picnic area": "Picnic facilities",
    "picnic bench": "Picnic facilities",
    "picnic facility": "Picnic facilities",
    "picnic site": "Picnic facilities",
    "picnic spot": "Picnic facilities",
    "picnic table": "Picnic facilities",
    "play area": "Recreation",
    "pub": "Food & Drink",
    "pub/cafe": "Food & Drink",
    "public toilet": "Public toilets",
    "recreation area": "Recreation",
    "restaurant": "Food & Drink",
    "shop": "Retail",
    "tea room": "Food & Drink",
    "tea-house": "Food & Drink",
    "tennis court": "Recreation",
    "toilet": "Public toilets",
    "toilets": "Public toilets",
    "train station": "Transport",
    "visitor centre": "Information",
    "youth hostel": "Accommodation"
  },
  "points_of_interest": {
    "arboretum": "Nature & Gardens",
    "beach": "Coastal",
    "bird hide": "Nature & Gardens",
    "bridge": "Infrastructure",
    "canal": "Water features",
    "castle": "Historical",
    "castle ruin": "Historical",
    "cathedral": "Historical",
    "cave": "Geological",
    "church": "Historical",
    "country park": "Parks & Green spaces",
    "dam": "Infrastructure",
    "garden": "Nature & Gardens",
    "gardens": "Nature & Gardens",
    "harbour": "Coastal",
    "hill fort": "Historical",
    "hillfort": "Historical",
    "historic site": "Historical",
    "historical site": "Historical",
    "lake": "Water features",
    "lighthouse": "Coastal",
    "loch": "Water features",
    "lock": "Infrastructure",
    "manor house": "Historical",
    "marina": "Infrastructure",
    "monument": "Historical",
    "mountain": "Geological",
    "museum": "Cultural",
    "national nature reserve": "Nature & Gardens",
    "nature reserve": "Nature & Gardens",
    "park": "Parks & Green spaces",
    "pond": "Water features",
    "reservoir": "Water features",
    "river": "Water features",
    "rock formation": "Geological",
    "ruin": "Historical",
    "sculpture": "Cultural",
    "sculpture trail": "Cultural",
    "stone circle": "Historical",
    "summit": "Geological",
    "tarn": "Water features",
    "viaduct": "Infrastructure",
    "viewpoint": "Viewpoints",
    "village": "Cultural",
    "village green": "Parks & Green spaces",
    "visitor centre": "Cultural",
    "waterfall": "Water features",
    "weir": "Water features",
    "wildlife": "Nature & Gardens",
    "windmill": "Historical"
  },
  "terrain": {
    "beach": "Coastal",
    "canal": "Rivers & Wetlands",
    "canal towpath": "Rivers & Wetlands",
    "canalside": "Rivers & Wetlands",
    "chalk downland": "Grassland & Heathland",
    "chalk grassland": "Grassland & Heathland",
    "cliff": "Hills & Cliffs",
    "cliff top": "Hills & Cliffs",
    "coastal": "Coastal",
    "common": "Grassland & Heathland",
    "country": "Rural",
    "country lane": "Rural",
    "countryside": "Rural",
    "downland": "Grassland & Heathland",
    "dune": "Coastal",
    "farmland": "Grassland & Heathland",
    "field": "Grassland & Heathland",
    "flat": "General",
    "footpath": "General",
    "forest": "Forest & Woodland",
    "garden": "Rural",
    "gorge": "Hills & Cliffs",
    "grassland": "Grassland & Heathland",
    "grassy": "Grassland & Heathland",
    "heath": "Grassland & Heathland",
    "heathland": "Grassland & Heathland",
    "hill": "Hills & Cliffs",
    "lake": "Rivers & Wetlands",
    "lakeside": "Rivers & Wetlands",
    "marsh": "Rivers & Wetlands",
    "marshland": "Rivers & Wetlands",
    "meadow": "Grassland & Heathland",
    "moor": "Grassland & Heathland",
    "moorland": "Grassland & Heathland",
    "mountain": "Hills & Cliffs",
    "park": "Rural",
    "parkland": "Rural",
    "pasture": "Grassland & Heathland",
    "ridge": "Hills & Cliffs",
    "river": "Rivers & Wetlands",
    "riverbank": "Rivers & Wetlands",
    "riverine": "Rivers & Wetlands",
    "riverside": "Rivers & Wetlands",
    "sand dune": "Coastal",
    "scrub": "Grassland & Heathland",
    "urban": "General",
    "valley": "Hills & Cliffs",
    "waterside": "Rivers & Wetlands",
    "wetland": "Rivers & Wetlands",
    "woodland": "Forest & Woodland"
  }
}