aboutsummaryrefslogtreecommitdiff
path: root/data/vigo/download-stops.py
blob: f332f5b9c7b8749e1449709ebc9138b4dc08c4e9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
# /// script
# requires-python = ">=3.12"
# dependencies = [
#    "PyYAML>=6.0.2",  # For YAML support
# ]
# ///
import json
import os
import sys
import urllib.request
import yaml  # Add YAML support for overrides

OVERRIDES_DIR = "overrides"
OUTPUT_FILE = "../../src/frontend/public/stops/vigo.json"

def load_stop_overrides(file_path):
    """Load stop overrides from a YAML file"""
    if not os.path.exists(file_path):
        print(f"Warning: Overrides file {file_path} not found")
        return {}

    try:
        with open(file_path, 'r', encoding='utf-8') as f:
            overrides = yaml.safe_load(f)
            print(f"Loaded {len(overrides) if overrides else 0} stop overrides")
            return overrides or {}
    except Exception as e:
        print(f"Error loading overrides: {e}", file=sys.stderr)
        return {}

def apply_overrides(stops, overrides):
    """Apply overrides to the stop data and add new stops"""
    # Track existing stop IDs
    existing_stop_ids = {stop.get("stopId") for stop in stops}
    
    # Apply overrides to existing stops
    for stop in stops:
        stop_id = stop.get("stopId")
        if stop_id in overrides:
            override = overrides[stop_id]

            # Override name if provided
            if "name" in override:
                stop["name"]["original"] = override["name"]

            # Apply or add alternate names
            if "alternateNames" in override:
                for key, value in override["alternateNames"].items():
                    stop["name"][key] = value

            # Apply location override
            if "location" in override:
                if "latitude" in override["location"]:
                    stop["latitude"] = override["location"]["latitude"]
                if "longitude" in override["location"]:
                    stop["longitude"] = override["location"]["longitude"]

            # Add amenities
            if "amenities" in override:
                stop["amenities"] = override["amenities"]

            # Mark stop as hidden if needed
            if "hide" in override:
                stop["hide"] = override["hide"]

            # Mark stop as cancelled
            if "cancelled" in override:
                stop["cancelled"] = override["cancelled"]

            # Add alert title
            if "title" in override:
                stop["title"] = override["title"]

            # Add alert message
            if "message" in override:
                stop["message"] = override["message"]

            # Add alternate codes
            if "alternateCodes" in override:
                stop["alternateCodes"] = override["alternateCodes"]
    
    # Add new stops (those with "new: true" parameter)
    new_stops_added = 0
    for stop_id, override in overrides.items():
        # Check if this is a new stop
        if override.get("new") and stop_id not in existing_stop_ids:
            # Ensure stop_id is an integer for consistency
            stop_id_int = int(stop_id) if isinstance(stop_id, str) else stop_id
            
            # Create the new stop
            new_stop = {
                "stopId": stop_id_int,
                "name": {
                    "original": override.get("name", f"Stop {stop_id_int}")
                },
                "latitude": override.get("location", {}).get("latitude"),
                "longitude": override.get("location", {}).get("longitude"),
                "lines": override.get("lines", [])
            }
            
            # Add optional fields (excluding the 'new' parameter)
            if "alternateNames" in override:
                for key, value in override["alternateNames"].items():
                    new_stop["name"][key] = value
            if "amenities" in override:
                new_stop["amenities"] = override["amenities"]
            if "cancelled" in override:
                new_stop["cancelled"] = override["cancelled"]
            if "title" in override:
                new_stop["title"] = override["title"]
            if "message" in override:
                new_stop["message"] = override["message"]
            if "alternateCodes" in override:
                new_stop["alternateCodes"] = override["alternateCodes"]
            
            stops.append(new_stop)
            new_stops_added += 1
    
    if new_stops_added > 0:
        print(f"Added {new_stops_added} new stops from overrides")

    return stops

def main():
    print("Fetching stop list data...")

    # Download stop list data
    url = "https://datos.vigo.org/vci_api_app/api2.jsp?tipo=TRANSPORTE_PARADAS"
    req = urllib.request.Request(url)

    try:
        with urllib.request.urlopen(req) as response:
            # Read the response and decode from ISO-8859-1 to UTF-8
            content = response.read().decode('iso-8859-1')
            data = json.loads(content)

        print(f"Downloaded {len(data)} stops")

        # Process the data
        processed_stops = []
        for stop in data:
            name = stop.get("nombre", "").strip()
            # Fix double space equals comma-space: "Castrelos  202" -> "Castrelos, 202"; and remove quotes
            name = name.replace("  ", ", ").replace('"', '').replace("'", "")

            processed_stop = {
                "stopId": stop.get("id"),
                "name": {
                    "original": name
                },
                "latitude": stop.get("lat"),
                "longitude": stop.get("lon"),
                "lines": [line.strip() for line in stop.get("lineas", "").split(",")] if stop.get("lineas") else []
            }
            processed_stops.append(processed_stop)

        # Load and apply overrides
        script_dir = os.path.dirname(os.path.abspath(__file__))
        overrides_dir = os.path.join(script_dir, OVERRIDES_DIR)
        # For each YML/YAML file in the overrides directory, load and apply the overrides
        for filename in os.listdir(overrides_dir):
            if not filename.endswith(".yml") and not filename.endswith(".yaml"):
                continue

            print(f"Loading overrides from {filename}")
            overrides_file = os.path.join(overrides_dir, filename)
            overrides = load_stop_overrides(overrides_file)
            processed_stops = apply_overrides(processed_stops, overrides)

        # Filter out hidden stops
        visible_stops = [stop for stop in processed_stops if not stop.get("hide")]
        print(f"Removed {len(processed_stops) - len(visible_stops)} hidden stops")

        # Sort stops by ID ascending
        visible_stops.sort(key=lambda x: x["stopId"])

        output_file = os.path.join(script_dir, OUTPUT_FILE)

        with open(output_file, 'w', encoding='utf-8') as f:
            json.dump(visible_stops, f, ensure_ascii=False, indent=2)

        print(f"Saved processed stops data to {output_file}")
        return 0

    except Exception as e:
        print(f"Error processing stops data: {e}", file=sys.stderr)
        return 1

if __name__ == "__main__":
    sys.exit(main())