Street and Road Data for Helsinki, Finland

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

Tables

Noise Areas in Helsinki Streets and RoadsTSV
This table contains data sourced from the website of 'Helsinki Urban Environment Division' in Finland. It provides information on noise areas of streets and roads in Helsinki. The data includes details such as the extraction date, row number, ID, sound pressure level (low), sound pressure level (high), data owner, date of update, geo JSON representation of the geometry, geotext representation of the geometry, type of geometry, centroid of the geometry, x-coordinate of the geometry center, y-coordinate of the geometry center, and the raw geometry data. The table can be utilized in various data analytics tasks such as analyzing noise pollution levels in different areas of Helsinki, identifying high noise exposure zones, studying the impact of noise on urban environments, and conducting...
Version History of Street and Road Noise Areas Data for Helsinki from Helsingin kaupunkiympariston toimiala in FinlandTSV
This table represents the version history of the rows in the 'avoindatamelualueet_2017_01_kadut_maant_hki_laeq7_22_paiva_npm__melualueet_2017_01_kadut_maant_hki_laeq722_paiva_npmpolygon' table. It contains additional columns '_start_date' and '_end_date' which indicate the extraction dates of the rows from the data source. The data in this table is sourced from the website of 'Helsinki City Environment Sector', which originates from Finland (ISO country code 'fi'). The table can be used for data analytics purposes, such as analyzing the historical changes of noise areas in Helsinki's streets and roads over time.

Column Descriptions

Noise Areas in Helsinki Streets and Roads

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data.
id	int	The unique identifier of the record.
db_lo	float	The lower boundary of the database range.
db_hi	float	The higher boundary of the database range.
datanomist	string	The name of the data analyst.
paivitetty	date	The date when the data was last updated.
geom_geojson	string	The geography data in GeoJSON format.
geom_geotext	string	The geography 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 data.

Version History of Street and Road Noise Areas Data for Helsinki from Helsingin kaupunkiympariston toimiala 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 number assigned to the row version.
id	int	The unique identifier for the row version.
db_lo	float	The lower 32 bits of the database identifier.
db_hi	float	The higher 32 bits of the database identifier.
datanomist	string	The name of the data analyst who made the changes.
paivitetty	date	The date and time when the row version was last updated.
geom_geojson	string	The geometry data in GeoJSON format.
geom_geotext	string	The geometry data in geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid coordinates 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 original geometry data.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024