Public Transport Map - Train Railways

The dataset collection contains tables sourced from the website of Helsingin kaupunkiympariston toimiala (City of Helsinki). The tables provide information about traffic and train rail in the metropolitan area. The data is sourced from the country Finland.

Tables

Public Transport: Railway Line Information in Helsingin kaupunkiymparisto, FinlandTSV
The table is sourced from the website of 'Helsinki City Environment Sector' from Finland. It contains data related to train tracks in the Helsinki metropolitan area. The table includes information about the extraction date of the data, row numbers, track sections, measurement groups, geometry in both GeoJSON and Geotext formats, geometry types, centroids, center coordinates, complete geometry information, and data service references. The data in this table can be utilized for various data analytics tasks such as analyzing the growth or changes in train tracks, identifying correlations between different measurement groups, studying the spatial distribution of the tracks, and conducting geospatial analysis.
Train Rail Network HistoryTSV
This table contains the version history of the rows from 'avoindataseutukartta_liikenne_juna_rata__seutukartta_liikenne_juna_rataline' table. Each row in this table represents a specific version of the base table row, with additional columns '_start_date' and '_end_date' indicating the extraction dates. The data in this table is sourced from the website of 'Helsinki Urban Environment Division' in Finland (ISO country code: 'fi'). The table provides valuable information for data analytics, such as analyzing changes in 'rataosuus' (rail portion), 'mtryhm' (track group), 'geom_geojson' (geographical data in GeoJSON format), 'geom_geotext' (geographical data in geotext format), 'geom_type' (type of geometry), 'geom_centroid' (centroid of the geometry), 'geom_center_x' (x-coordinate of the...

Column Descriptions

Public Transport: Railway Line Information in Helsingin kaupunkiymparisto, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number for each record in the table.
rataosuus	string	The section of the railway.
mtryhm	int	The maintenance group of the railway section.
geom_geojson	string	The geometry of the railway section in GeoJSON format.
geom_geotext	string	The textual representation of the geometry of the railway section.
geom_type	string	The type of geometry for the railway section.
geom_centroid	string	The centroid of the geometry of the railway section.
geom_center_x	double	The X-coordinate of the center point of the geometry of the railway section.
geom_center_y	double	The Y-coordinate of the center point of the geometry of the railway section.
geom	binary	The geometry of the railway section.
tietopalve	int	The data service associated with the railway section.

Train Rail Network History

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The number assigned to each row version.
rataosuus	string	The rail section.
mtryhm	int	The group of measurements.
geom_geojson	string	The geometrical representation of the feature in GeoJSON format.
geom_geotext	string	The geometrical representation of the feature in GeoText format.
geom_type	string	The type of geometry of the feature.
geom_centroid	string	The centroid point of the feature geometry.
geom_center_x	double	The X-coordinate of the center point of the feature geometry.
geom_center_y	double	The Y-coordinate of the center point of the feature geometry.
geom	binary	The representation of the feature geometry.
tietopalve	int	The data service associated with the row version.

Additional Info

Last Updated	April 23, 2024
Created	May 6, 2018