Skip to content
Snippets Groups Projects

FACT Rail Stations and Lines

Rail stations (passengers and freigth) and working rail lines in Europe and North America from OSM.


Use

Connect to the GitLab container registry with privileges for the FACT group:

docker login -u FACT_token -p glpat-1zG-TQx___xLsPjj2vsG registry.git.nilu.no

Run this data service:

docker run -t -i --name fact_rail -e MARIADB_DATABASE=FACT_rail -e MYSQL_ROOT_PASSWORD=devops -p 3311:3306 -d registry.git.nilu.no/fact/data/fact_rail:0.1

The container makes available a MariaDB instance with the full database on the rail system FACT_rail. It is reachable on port 3311 of the localhost and the password is 'devops'.


Specifications

Table           |Size (MB)|Rows (#)|
----------------+---------+--------+
eu_lines        |   777.08| 1172918|
eu_stations     |    14.98|   30049|
geometry_columns|     0.02|       4|
na_lines        |   231.65|  449237|
na_stations     |     1.13|    3734|
spatial_ref_sys |     0.02|       0|

tables schema

All spatial objects are converted to EPSG:4326


Notes

OSM maps for Europe and North America are downloaded form https://download.geofabrik.de/

Tag filtering is used to select rail lines and stations, and then data is transformed to .geojson and uploaded in the database server. To manipulate and transform data, we use https://osmcode.org/osmium-tool/


Authors

Riccardo Boero - ribo@nilu.no

License