Railways Dataset Collection in Helsinki, Finland

The dataset collection consists of one or more dataset tables sourced from the website of 'Helsinki City Environment Sector' in Finland.

Tables

Railway Noise Areas in Helsinki - September 2017TSV
This table 'avoindatamelualueet_2017_09_rautatiet_hki_laeq7_22_paiva_npm__melualueet_2017_09_rautatiet_hki_laeq722_paiva_npmpolygon' contains data on noise areas related to railways in Helsinki. It is sourced from the website of 'Urban Environment Division of the City of Helsinki', which originates from Finland (ISO country code 'FI'). This table provides various columns including '_extract_date', '_row_number', 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The data in this table can be utilized for data analytics purposes such as analyzing noise levels, examining spatial patterns, and identifying areas affected by railway noise in Helsinki.
Version History of Noise Areas in Helsinki Railway 2017-09 (Laeq7 22 days avg)TSV
This table contains the version history of rows from the 'avoindatamelualueet_2017_09_rautatiet_hki_laeq7_22_paiva_npm__melualueet_2017_09_rautatiet_hki_laeq722_paiva_npmpolygon' 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 data that can be utilized for various data analytics purposes, such as analyzing noise levels in different areas over time, studying the spatial distribution of noise pollution, and identifying trends or patterns in noise exposure within Helsinki.

Column Descriptions

Railway Noise Areas in Helsinki - September 2017

Column	Type	Comment
_extract_date	date	The date when the row was extracted
_row_number	long	The row number
id	int	The unique identifier of the data
db_lo	float	The lower value of the database range
db_hi	float	The higher value of the database range
datanomist	string	The data nomist
paivitetty	date	The date and time when the data 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

Version History of Noise Areas in Helsinki Railway 2017-09 (Laeq7 22 days avg)

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version.
_end_date	date	The end date of the validity period for the row version.
_row_number	long	The row number of the version in the history table.
id	int	The unique identifier of the row in the base table.
db_lo	float	The low-order bits of the database value.
db_hi	float	The high-order bits of the database value.
datanomist	string	The name of the data analyst who made the update.
paivitetty	date	The timestamp of when the row 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 the geometry.
geom_centroid	string	The centroid 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 geometry in a native format.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024