# Victorian Public Transport Intelligence Database Diagnostics

Generated: `2026-06-12T15:08:14`

## Database file

| Field | Value |
| --- | --- |
| Database path | A:\TrafficAnalytics\PROJECTS\public_transport_intel\data\duckdb\vic_public_transport.duckdb |
| File size | 315.0 MB |
| Modified | 2026-06-12T10:35:50 |
| SHA-256 short | 29266966b9070ddd |
| DuckDB version | v1.5.1 |

## Inventory summary

| Metric | Value |
| --- | --- |
| Tables/views indexed | 58 |
| Base tables | 24 |
| Views | 34 |
| Columns | 618 |
| Rows counted across base tables | 24,694,810 |
| Largest max departure load found | 5050.0 |
| Max departure load table | main.train_passenger_line_year_summary |
| Max distinct stations seen in a table | 20949 |
| Max distinct lines seen in a table | 23 |

## Largest base tables by row count

| Table | Type | Rows |
| --- | --- | --- |
| main.gtfs_stop_times | BASE TABLE | 15,297,769 |
| main.gtfs_shapes | BASE TABLE | 8,677,565 |
| main.gtfs_trips | BASE TABLE | 401,905 |
| main.gtfs_calendar_dates | BASE TABLE | 129,969 |
| main.train_passenger_station_daytype_summary | BASE TABLE | 98,660 |
| main.gtfs_stops | BASE TABLE | 32,097 |
| main.train_passenger_peak_load_records | BASE TABLE | 13,800 |
| main.gtfs_transfers | BASE TABLE | 13,237 |
| main.gtfs_calendar | BASE TABLE | 8,378 |
| main.train_passenger_station_year_summary | BASE TABLE | 5,834 |

## Interpretation notes for public report

- This is the analytical database behind the public transport intelligence report.
- It contains cleaned, transformed and summary-ready tables, not just raw files.
- Passenger-count boardings/alightings are separate from Myki station-entry datasets.
- Maximum departure load is a pressure/crowding indicator, not annual patronage.
- GTFS tables describe scheduled service supply and do not prove actual service delivery or crowding.
- Station-entry versus boarding comparisons are screening indicators only, not proof of fare evasion.

## Output files

- `database_diagnostics_summary.json`
- `database_diagnostics_summary.md`
- `database_diagnostics_fragment.html`
- `database_table_inventory.csv`
- `database_column_inventory.csv`
- `database_row_counts.csv`
- `database_domain_metrics.csv`
- `database_diagnostic_queries.sql`