2017 Area 10 Railways in Helsinki, Finland

This dataset collection, sourced from the website of Helsingin kaupunkiympariston toimiala (Department of Urban Environment of Helsinki), consists of one or more dataset tables. The tables provide data related to railways within the region of Helsingin kaupunkiympariston toimiala. All the datasets in this collection were collected in Finland (ISO country code: FI).

Tables

Noise Study 2017 Area 10 Railways (L AEQ & Yo) - Version HistoryTSV
This table contains the version history of the base table 'avoindatameluselvitys_2017_alue_10_rautatiet_l_aeq_yo__meluselvitys_2017_alue_10_rautatiet_l_aeq_yopolygon'. It has two additional columns compared to the base table: '_start_date' which indicates the date when a row was extracted from the data source, and '_end_date' which indicates the date when a new version of the row was extracted. If the value of '_end_date' is null, it means the row is the most recent version. The table has various columns including 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. Instead of listing or describing these individual columns, here are a few examples of how the data in this table could be...
Railways Noise Survey 2017 - Area 10, FinlandTSV
This table contains data from the website of Helsingin kaupunkiympariston toimiala in Finland (ISO country code: 'fi'). The table named 'avoindatameluselvitys_2017_alue_10_rautatiet_l_aeq_yo__meluselvitys_2017_alue_10_rautatiet_l_aeq_yopolygon' consists of various columns. Data in this table can be utilized for data analytics purposes such as analyzing noise levels related to railways. The table includes information about the extraction date, row numbers, identification, noise level values, data source, update date, geographic data information in both JSON and geotext format, geometry type, centroid coordinates, and the full geomety.

Column Descriptions

Railways Noise Survey 2017 - Area 10, Finland

Column	Type	Comment
_extract_date	date	The date the data was extracted.
_row_number	long	The sequential number of the row.
id	int	The unique identifier for each record.
db_lo	int	The lower boundary for a range of values.
db_hi	int	The higher boundary for a range of values.
datanomist	string	The name of the data owner.
paivitetty	string	The date the data was last updated.
geom_geojson	string	The geometry of the data in GeoJSON format.
geom_geotext	string	The geometry of the data 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.

Noise Study 2017 Area 10 Railways (L AEQ & Yo) - Version History

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 number of the row version.
id	int	The unique identifier of the row.
db_lo	int	The low-order bits of the database identifier for the row.
db_hi	int	The high-order bits of the database identifier for the row.
datanomist	string	The data analyst who updated the row version.
paivitetty	string	The date and time when the row version was 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 of the geometry.
geom_center_y	double	The y-coordinate of the center of the geometry.
geom	binary	The geometry object.

Additional Info

Last Updated	April 16, 2025
Created	October 21, 2018