Study on Railway Data in Helsinki, Finland

This dataset collection, sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland, consists of one or more dataset tables. It provides information related to the avoindatameluselvitys_2012_alue_05_rautatiet_l_aeq_paiva dataset collection.

Tables

Railway Noise Assessment Area - Level Aeq Day - Helsinki Urban Environment Department - FinlandTSV
This table contains data from the 'Helsinki Environmental Department' website on noise level measurements for railway lines in the Helsinki area. The data includes information such as the extraction date, row number, unique identifier, lower and upper decibel values, data source name, last update date, geometric data in both GeoJSON and GeoText formats, geometric type, centroid coordinates, and the full geometric data. The table can be utilized in data analytics to analyze noise pollution trends, identify areas with high noise levels, evaluate the impact of railway noise on nearby properties, and assess the effectiveness of noise reduction measures. The data source originates from Finland (ISO country code: 'fi').
Version History of Meluselvitys 2012 Alue 05 Rautatiet L Aeq Paiva PolygonTSV
This table contains the version history of rows from the avoindatameluselvitys_2012_alue_05_rautatiet_l_aeq_paiva__meluselvitys_2012_alue_05_rautatiet_l_aeq_paivapolygon base table. The rows in this table represent different versions of the data extracted from the web site of Helsingin kaupunkiympariston toimiala, which originates from the country with ISO country code 'fi' (Finland). Each row in this table is associated with a start date and an end date, indicating the time period during which the row was valid. The '_start_date' column stores the date when the row was extracted, while the '_end_date' column stores the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it means that the row is the most recent version. The data in this...

Column Descriptions

Railway Noise Assessment Area - Level Aeq Day - Helsinki Urban Environment Department - Finland

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

Version History of Meluselvitys 2012 Alue 05 Rautatiet L Aeq Paiva 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 number assigned to each row version in the table.
id	int	The unique identifier of the row version.
db_lo	int	The lower bound of the database.
db_hi	int	The upper bound of the database.
datanomist	string	The name of the data scientist.
paivitetty	string	The date when the row version was last updated.
geom_geojson	string	The geometric data in GeoJSON format.
geom_geotext	string	The geometric data in geotext format.
geom_type	string	The type of geometric data.
geom_centroid	string	The centroid of the geometric data.
geom_center_x	double	The x-coordinate of the center of the geometric data.
geom_center_y	double	The y-coordinate of the center of the geometric data.
geom	binary	The geometric data.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024