Public Transport Railway Data for Helsinki Region in Finland

This dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Railway Noise Areas in Helsinki, Finland - Data from the Helsinki City Environment SectorTSV
This table contains data from the 'Helsinki City Environment' website, specifically related to noise areas caused by railways in Helsinki, Finland. The table includes various columns such as the extraction date of the data, row number, ID, decibel low range (db_lo), decibel high range (db_hi), data source name (datanomist), update date (paivitetty), geometry in GeoJSON format (geom_geojson), geometry in GeoText format (geom_geotext), geometry type (geom_type), geographic centroid (geom_centroid), x-coordinate of the centroid (geom_center_x), y-coordinate of the centroid (geom_center_y), and the full geometry (geom). The data in this table can be utilized in various data analytics tasks such as studying noise pollution patterns, analyzing the impact of railways on noise levels,...
Version History of Noise Areas for Railways in Helsinki - Melualueet 2017-20 Rautatiet HKI-LYO PolygonTSV
This table contains the version history of the 'avoindatamelualueet_2017_20_rautatiet_hki_lyo__melualueet_2017_20_rautatiet_hki_lyopolygon' table. It includes additional columns '_start_date' and '_end_date' which indicate the extraction dates of each row. The data in this table is sourced from the website of 'Helsinki City Environment Sector' in Finland (ISO country code 'fi'). The table provides valuable information that can be utilized for data analytics purposes, such as analyzing the noise levels in different areas of Helsinki, tracking changes in noise data over time, identifying areas with high noise levels, and assessing the impact of noise pollution on urban environments.

Column Descriptions

Railway Noise Areas in Helsinki, Finland - Data from the Helsinki City Environment Sector

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the record.
id	int	The unique identifier of the record.
db_lo	float	The lower bound of a range value.
db_hi	float	The upper bound of a range value.
datanomist	string	The name of the data analyst.
paivitetty	date	The date when the record was last updated.
geom_geojson	string	The geometry data in GeoJSON format.
geom_geotext	string	The geometry data in Geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid point of the geometry.
geom_center_x	double	The X-coordinate of the center point of the geometry.
geom_center_y	double	The Y-coordinate of the center point of the geometry.
geom	binary	The full geometry data.

Version History of Noise Areas for Railways in Helsinki - Melualueet 2017-20 Rautatiet HKI-LYO Polygon

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 unique row number of the version within the table.
id	int	The unique identifier of the row version.
db_lo	float	A lower bound value representing the database version.
db_hi	float	An upper bound value representing the database version.
datanomist	string	The data scientist responsible for the row version.
paivitetty	date	The date and time when the row version was last updated.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The textual representation of the geometry of the row version.
geom_type	string	The type of geometry of the row version.
geom_centroid	string	The centroid coordinates of the geometry of the row version.
geom_center_x	double	The x-coordinate of the center point of the geometry of the row version.
geom_center_y	double	The y-coordinate of the center point of the geometry of the row version.
geom	binary	The raw geometry data of the row version.

Additional Info

Last Updated	September 13, 2024
Created	July 9, 2018