About SolarisPKN-Transport

SolarisPKN-Transport is a robust pipeline designed to collect, validate, and store transport timetables from official sources. It leverages the same backends used by applications like Trenes Argentinos and Cuándo SUBO to gather published schedules. The system validates each schedule, saves it in a human-readable spreadsheet format (XLSX), and constructs a normalized SQLite database for efficient web queries. This ensures reliable access to transport information even when live APIs are unavailable.

• Key Features:
• Spreadsheet-driven configuration for easy route updates without code changes.
• Automatic discovery of routes, directions, and stops.
• Utilizes official app backends for data collection.
• Safe replacement strategy ensures data integrity.
• Atomic persistence and manual data protection mechanisms.
• Daily automation via GitHub Actions for continuous updates.
• Traceable data provenance indicating update methods (API or Manual).
• Bilingual documentation in English and Spanish.

The project aims to provide a dependable source for planned transport services, acting as a fallback when live tracking data is inaccessible. It prioritizes data integrity by never overwriting trusted data with incomplete or inconsistent information.

Technology Stack:

• Python 3.11+ for core logic, validation, and data processing.
• openpyxl for handling XLSX files.
• SQLite for creating a queryable database.
• Node.js for specific connector tests.
• GitHub Actions for automated workflows.
• REST for interacting with external APIs.