Dataset Collection: Region 18 Metro Area Night Data from Helsingin kaupunkiympariston toimiala (Finland)

This dataset collection consists of one or more dataset tables sourced from the website of 'Helsinki City Environment Sector' in Finland.

2017 Metro Noise Report Area 18TSV
This table provides data from the noise survey conducted in the year 2017 for the metropolitan area of Alue 18. The data includes information on the date of extraction, row numbers, an identifier, noise levels (low and high values), data analyst's name, update date, geometry in GeoJSON and Geotext formats, geometry type, centroid coordinates, and the full geometry. The table is sourced from the website of Helsingin kaupunkiympariston toimiala, which is the Urban Environment Division of the City of Helsinki in Finland.
Metro Noise Survey Area - Version HistoryTSV
This table contains the version history of rows from the 'avoindatameluselvitys_2017_alue_18_metro_l_yo__meluselvitys_2017_alue_18_metro_l_yopolygon' table. The rows in this table represent different versions of the base table rows extracted from the data source. The '_start_date' column denotes the date when each row was extracted, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row is the most recent version. The table is sourced from the website of 'Helsingin kaupunkiympariston toimiala', which is an environmental department of the city of Helsinki, Finland (ISO country code 'fi').

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The unique identifier for each row.
id	int	The unique identifier for each entry.
db_lo	int	The lower value of the range.
db_hi	int	The higher value of the range.
datanomist	string	The name of the data analyst.
paivitetty	string	The date when the data was last updated.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry information in plain text 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 spatial geometry information.

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The row number of the version.
id	int	The unique identifier of the row version.
db_lo	int	Database-related low value.
db_hi	int	Database-related high value.
datanomist	string	The data nomist of the row version.
paivitetty	string	The date when the row version was last updated.
geom_geojson	string	The geometry in GEOJSON format.
geom_geotext	string	The geometry 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.

Last Updated	September 13, 2024
Created	October 21, 2018