Geospatial Data on Helsingin kaupunkiympariston toimiala in Finland

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

2017 Noise Survey Data by Road Type in Area 04, Helsingin kaupunkiympariston toimiala, FinlandTSV
This table contains data from the 'Helsinki City Environment Sector'. It provides information related to noise surveys conducted in the year 2017 on road segments in the Helsinki region. The data includes the date of extraction, row number, ID of the road segment, low and high decibel values, data custodian's name, date of update, geometry information in both GeoJSON and Geotext formats, type of geometry, centroid coordinates, center point coordinates, and the full geometry information. This data can be utilized for various data analytics purposes such as studying noise patterns, identifying high noise areas, analyzing noise pollution trends, and conducting spatial analysis in the Helsinki region.
Version History of Geographical Data for Noise Survey Areas in Helsinki, FinlandTSV
This table contains the version history of the rows in the 'avoindatameluselvitys_2017_alue_04_maantiet_l_aeq_yo__meluselvitys_2017_alue_04_maantiet_l_aeq_yopolygon' table. It provides information on the start and end dates of each version. The data in this table can be utilized for data analytics, such as tracking changes over time, analyzing historical trends, and identifying updates made to the base table. The table is sourced from the website of 'Helsinki City Environment Services' in Finland (ISO country code: 'fi').

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The number assigned to each row in the table.
id	int	The unique identifier for each record in the table.
db_lo	int	The lower bound value for a range in the table.
db_hi	int	The upper bound value for a range in the table.
datanomist	string	The name of the data owner or custodian.
paivitetty	string	The date when the record 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 data.
geom_centroid	string	The centroid point of the geometry.
geom_center_x	double	The x-coordinate of the center point of the geometry.
geom_center_y	double	The y-coordinate of the center point of the geometry.
geom	binary	The complete geometry data.

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 of the version.
id	int	The unique identifier of the row.
db_lo	int	Low part of the database value.
db_hi	int	High part of the database value.
datanomist	string	Name of the data analyst.
paivitetty	string	The date and time when the row was updated.
geom_geojson	string	The geometry of the row in the GeoJSON format.
geom_geotext	string	The geometry of the row in the 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 of the row.

Last Updated	September 13, 2024
Created	October 21, 2018