Supplementary Material for diploma thesis: Parameter analysis on tramway networks with OpenStreetMap
Contributors
Contact person:
Supervisors:
Description
Supplementary Material for diploma thesis:
Parameter analysis on tramway networks with OpenStreetMap
This dataset contains the supplementary material as described in the diploma thesis: Parameter analysis on tramway networks with OpenStreetMap.
Some of the raw data is not included, since this data can be easily redownloaded from OSM. The timetable data is not included to avoid any legal difficulties concerning different licences. However the sources are documented in the thesis, so a redownload should be possible.
File overview
- building_data.json: the final dataset. Contains all the needed information as described in the diploma thesis. Licensed under CC BY-SA 4.0.
- data.zip (licensed under CC BY-SA 4.0):
- a folder for each city
- buildings-Folder: used to store information on buildings derived from OpenStreetMap (OSM)
- orientations-Folder: used to store information for the orientation-analysis in graphml-Format
- osm-Folder: containing the processed results from the Analysis on OSM
- results-folder: contains the pictures for each city as shown in Appendix A of the thesis
- timetable-Folder: used to store the GTFS data for the given city
- results: containing the processed results of the timetable analysis
- results: containing the processed results of the timetable analysis
- station-matching.csv: Connects stations from timetables to stations from OSM
- cities.csv: contains all the cities to analyze and some initial data
- orientations.csv: contains all information for calculating the Orientation-Order-Index
- a folder for each city
- code.zip (licensed under MIT) - written in
Python 3.12:- curvy: code to download and process OSM data
- diplomarbeit: code to process timetable data and consolidate all information
- main.py: script to run the whole package
- Auswertung.ipynb: Notebook to analyze data
- requirements.txt: contains needed Python packages
- pyproject.toml: contains infomation for the environment.
- README.md: Readme file with information on how to run the code.
building_data.json
The File contains the necessary information for every relation as described in the thesis. The file contains the following data fields:
| Name of the field | Unit | Description |
| line_name | Name of the Relation in OSM (OSM tag: name) | |
| line_number | Number of the Relation in OSM (OSM tag: ref) | |
| from | Starting Point of the OSM relation (OSM tag: from) | |
| to | Destination of the OSM relation (OSM tag: to) | |
| distance | km | Length of the OSM relation as calculated by the Code |
| curvature | gon/km | Curviness of the OSM relation |
| height_up | m/km or ‰ | Average ascend of OSM relation |
| height_down | m/km or ‰ | Average descend of OSM relation |
| gauge | mm | Gauge of tracks on OSM relation (None if multiple gauges given in OSM, |
| gtfs_first_stop_name | Name of the first stop in the GTFS trip | |
| gtfs_last_stop_name | Name of the last stop in the GTFS trip | |
| route_short_name | Short Name of GTFS line (usually the number of the Line) | |
| trip_speed | km/h | Average trip speed calculated from GTFS data |
| first_stop_name | Name of the first stop after merging OSM and timetable data | |
| last_stop_name | Name of the last stop after merging OSM and timetable data | |
| number_trips | Number of observed trips in GTFS data | |
| avg_dist | m | Average Distance between stations from GTFS data |
| avg_time | s | Average time between stops at stations from GTFS data |
| city | City name | |
| Country | Human-readable country name | |
| ISO3166 | ISO 3166-alpha 2 Code of the country | |
| Stadt | Human-readable city name | |
| machine_readable | Machine-readable city name (used in folder names) | |
| OSM-Name | Name to query OSM (via the Nominatim Service) | |
| GTFS-Provider | Code to identify the timetable-provider | |
| Buffer_Width | m | Width of the Buffer to calculate the building densities on |
| H0_strasse | Nat | Entropy of the unweighted / simplified street orientations |
| H0_tram | Nat | Entropy of the unweighted / simplified tram orientations |
| phi_street | Orientation-order of the street network | |
| phi_tram | Orientation-order of the tram network | |
| region | Region to categorize the cities based on the CIA World Factbook | |
| rho_b | m²/m² or % | Building densities along the relation |
| geometry | Line geometry in the coordinate reference system EPSG:4326 |
data.zip
City-Folders
Each folder is an excerpt of the working directory used to calculate the desired information. Some of the folders may be empty, since the Information used in the thesis is contained in building_data.json. These empty directories were used to store information, which can be downloaded from the sources provided in the thesis.
station_matching.csv: Links OSM and Timetabledata
cities.csv
This file is the starting point for the analysis. The code tries to read the file and attempts to gain and process the needed data for each city. Some of the fields can be populated using the functions in code/diplomarbeit/utils.py.
orientations.csv
Contains the results of the calculations using the OSMnx Package for the Orientation-Order-Index.
code.zip
Contains all the necessary Python code to calculate the information given in building_data.json and the file requirements.txt, which lists the necessary Python packages.
Attribution
OpenStreetMap contributors - OpenStreetMap
Lourenço, J.R. (2021) Open-Elevation [Software]
Jarvis, A., Reuter, H.I., Nelson, A. and Guevara, E. (2008) Hole-filled seamless SRTM data V4.
Files
building_data.json
Additional details
Related works
- Cites
- Thesis: 10.34726/hss.2024.110716 (DOI)
- Journal Article: 10.1177/09544097221106851 (DOI)
- Journal Article: 10.1111/gean.70009 (DOI)
Dates
- Submitted
- 2026-04-16