Supplementary Material for diploma thesis: Parameter analysis on tramway networks with OpenStreetMap

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 

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

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,OSM tag: gauge)

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

Steinwidder, P. (2023). Bewertungsverfahren zur Analyse der Reisegeschwindigkeit von Straßenbahnen [Diploma Thesis, Technische Universität Wien]

Bettinger, T., Leibner, P. and Schindler, C. (2023) 'Horizontal curvature estimation of tram tracks using OpenStreetMap', Proceedings of the Institution of Mechanical Engineers, Part F: Journal of Rail and Rapid Transit, 237(3)

Boeing, G. (2025). Modeling and Analyzing Urban Networks and Amenities with OSMnx. Geographical Analysis 57 (4), 567-577

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.