Helsinki City Environment Department - Railways Data Collection

The dataset collection consists of one or more dataset tables sourced from the website of 'Helsingin kaupunkiympariston toimiala' in Finland.

Tables

Railway Noise Areas in Helsinki, Finland - 2017TSV
This table contains data from the 'Helsinki City Environment Sector' website, specifically related to noise areas along railways in Helsinki. The data is sourced from the country Finland (ISO country code 'fi'). The table provides information about various attributes including the extraction date, row number, unique identifier, noise level lows and highs, data source, last updated date, geometric data in GeoJSON and Geotext formats, geometric type, centroid coordinates, and the geometry itself. The data in this table can be utilized for data analytics purposes such as analyzing noise levels in different railway areas, identifying noise patterns, assessing the impact of noise on the environment, and conducting spatial analysis.
Version History of Noise Areas in Helsinki Railways (October 2017)TSV
This table contains the version history of the 'avoindatamelualueet_2017_10_rautatiet_hki_laeq22_7_yo_npm__melualueet_2017_10_rautatiet_hki_laeq227_yo_npmpolygon' table. It has additional columns '_start_date' and '_end_date' to indicate the extraction dates of each row. The table provides data sourced from the website of 'Helsinki City Environment Department' in Finland (ISO country code 'fi'). The data can be utilized for various data analytics purposes, such as analyzing noise levels in different areas of Helsinki over time, identifying areas with high noise pollution, studying the spatial distribution of noise, and calculating the average noise levels within specific polygons.

Column Descriptions

Railway Noise Areas in Helsinki, Finland - 2017

Column	Type	Comment
_extract_date	date	The date the data was extracted.
_row_number	long	The row number of the record.
id	int	The unique identifier of the record.
db_lo	float	The lower value of the database range.
db_hi	float	The higher value of the database range.
datanomist	string	The data custodian of the record.
paivitetty	date	The date when the record was last updated.
geom_geojson	string	The GeoJSON representation of the geometry.
geom_geotext	string	The WKT representation of the geometry.
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 geometric shape or spatial object.

Version History of Noise Areas in Helsinki Railways (October 2017)

Column	Type	Comment
_start_date	date	The date at which the row version becomes valid.
_end_date	date	The date at which the row version expires.
_row_number	long	The number assigned to each row version.
id	int	The unique identifier of the row.
db_lo	float	The lower part of the row's database reference.
db_hi	float	The higher part of the row's database reference.
datanomist	string	The name of the data analyst who updated the row version.
paivitetty	date	The date of the row version update.
geom_geojson	string	The geographic data of the row version in GeoJSON format.
geom_geotext	string	The geographic data of the row version in Geotext format.
geom_type	string	The type of geographic data stored in the row version.
geom_centroid	string	The centroid of the geographic data in the row version.
geom_center_x	double	The x-coordinate of the center point of the geographic data in the row version.
geom_center_y	double	The y-coordinate of the center point of the geographic data in the row version.
geom	binary	The geometry data of the row version.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024