Railway Traffic Data on Alue 06 at Night in Helsinki, Finland

This dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala (City of Helsinki's Urban Environment Division) in Finland.

Tables

Noise survey 2007 - Rail traffic during night time in zone 06 - Helsinki City Environment Department - FinlandTSV
This table contains data from the 'Meluselvitys 2007' report, specifically for the area '06 - Raideliikenne Länsi-Yö'. It includes information related to noise measurements in the railway transportation sector. The data is sourced from the website of the City of Helsinki's Urban Environment Division, which is part of the 'Helsingin kaupunkiympäristön toimiala'. The table contains various columns such as '_extract_date', '_row_number', 'tietopalve', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. These columns provide valuable information that can be utilized for data analytics. For example, the 'db_lo' and 'db_hi' columns provide the range of noise levels measured, which can be used...
Version History of Area 06 Railway Traffic (Night) Noise Survey in Helsinki, FinlandTSV
This table contains the version history of the rows from the 'avoindatameluselvitys_2007_alue_06_raideliikenne_l_yo__meluselvitys_2007_alue_06_raideliikenne_l_yopolygon' table. It includes additional columns '_start_date' and '_end_date' that represent the extraction dates of each row. The data in this table can be utilized for data analytics purposes. For example, it can be used to track changes over time or analyze trends in the 'tietopalve' column. The 'geom_geojson' column contains the geometry data in GeoJSON format, which can be further analyzed spatially. The data in this table originates from the website of the 'Helsinki Urban Environment Division' in Finland (ISO country code: 'fi').

Column Descriptions

Noise survey 2007 - Rail traffic during night time in zone 06 - Helsinki City Environment Department - Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The sequential number of the row
tietopalve	int	The name of the data service
db_lo	int	Low value of the database range
db_hi	int	High value of the database range
datanomist	string	The name of the data custodian
paivitetty	string	The date when the data was updated
geom_geojson	string	The geometry of the location in geoJSON format
geom_geotext	string	The geometry of the location 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 of the geometry
geom_center_y	double	The y-coordinate of the center of the geometry
geom	binary	The geometry of the location

Version History of Area 06 Railway Traffic (Night) Noise Survey in Helsinki, Finland

Column	Type	Comment
_start_date	date	The start date indicating the validity period of the row version.
_end_date	date	The end date indicating the validity period of the row version.
_row_number	long	The unique identifier of the row version.
tietopalve	int	The data service associated with the row.
db_lo	int	The lower limit value of the row version.
db_hi	int	The upper limit value of the row version.
datanomist	string	The data controller of the row.
paivitetty	string	The date and time when the row was last updated.
geom_geojson	string	The geometric data in GeoJSON format.
geom_geotext	string	The geometric data as text.
geom_type	string	The type of geometric data.
geom_centroid	string	The centroid point 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 in its original format.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024