Railway Lines in Helsinki Metropolitan Area

The dataset collection consists of one or more tables sourced from the website of 'Helsingin kaupunkiympäristön toimiala' in Finland.

Tables

Historical Version Data for 'Meluselvitys 2012 Alue 06 Rautatiet L AEQ Yo' from 'Helsinki City Environment Department' in FinlandTSV
This table contains the version history of the rows from the 'avoindatameluselvitys_2012_alue_06_rautatiet_l_aeq_yo__meluselvitys_2012_alue_06_rautatiet_l_aeq_yopolygon' base table. It includes the '_start_date' column, which indicates the date the row was extracted from the data source, and the '_end_date' column, which indicates the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it means that the row is the most recent version. The data in this table can be utilized for data analytics in various ways. For example, it could be used to analyze changes over time in the 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom' columns. The...
Railway Noise Assessment 2012 Area 06 L_night Equivalent Sound Pressure Level (Leq)TSV
This table contains data sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. The table provides information related to avoindatameluselvitys_2012_alue_06_rautatiet_l_aeq_yo__meluselvitys_2012_alue_06_rautatiet_l_aeq_yopolygon. It includes various columns such as _extract_date, _row_number, id, db_lo, db_hi, datanomist, paivitetty, geom_geojson, geom_geotext, geom_type, geom_centroid, geom_center_x, geom_center_y, and geom. This table can be utilized for various data analytics purposes, such as analyzing noise levels in different railway areas, identifying trends in noise pollution over time, studying the distribution of noise levels across different geographical regions, and exploring the relationship between noise levels and other variables.

Column Descriptions

Railway Noise Assessment 2012 Area 06 L_night Equivalent Sound Pressure Level (Leq)

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	int	The lower bound value for a specific database field.
db_hi	int	The upper bound value for a specific database field.
datanomist	string	The name of the data analyst who processed the data.
paivitetty	string	The date when the record was last updated.
geom_geojson	string	The geometry of the record in GeoJSON format.
geom_geotext	string	The text representation of the record's geometry.
geom_type	string	The type of geometry of the record.
geom_centroid	string	The centroid of the record's geometry.
geom_center_x	double	The x-coordinate of the center point of the record's geometry.
geom_center_y	double	The y-coordinate of the center point of the record's geometry.
geom	binary	The geometry object of the record.

Historical Version Data for 'Meluselvitys 2012 Alue 06 Rautatiet L AEQ Yo' from 'Helsinki City Environment Department' in Finland

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 indicating the position of the row version.
id	int	The unique identifier of the row version.
db_lo	int	A low-level database identifier associated with the row version.
db_hi	int	A high-level database identifier associated with the row version.
datanomist	string	The person responsible for the data.
paivitetty	string	The date of the last update for the row version.
geom_geojson	string	The geometric data of the row version in GeoJSON format.
geom_geotext	string	The geometric data of the row version in Geotext format.
geom_type	string	The type of geometric data in the row version.
geom_centroid	string	The centroid coordinates of the geometric data in the row version.
geom_center_x	double	The x-coordinate of the center point of the geometric data in the row version.
geom_center_y	double	The y-coordinate of the center point of the geometric data in the row version.
geom	binary	The geometric data of the row version.

Additional Info

Last Updated	September 13, 2024
Created	April 24, 2024