Data Collection from Helsingin kaupunkiympariston toimiala - avoindatamelualueet_2017_05_npm_mvyoh_5_1_raitio_laeq2m

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

Tables

Noise Areas in Helsinki, FinlandTSV
This table contains data obtained from the website of Helsingin kaupunkiympariston toimiala, which is an organization in Finland. The data represents the 'avoindatamelualueet_2017_05_npm_mvyoh_5_1_raitio_laeq2m__melualueet_2017_05_npm_mvyoh_5_1_raitio_laeq2mpolygon' table. The table consists of various columns such as '_extract_date', '_row_number', 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This data can be utilized for data analytics purposes such as analyzing noise levels in different areas, identifying patterns and trends, studying geographic characteristics, and conducting spatial analysis.
Version History of Noise Areas Dataset from Helsinki Urban Environment Department in FinlandTSV
This table contains the version history of the 'avoindatamelualueet_2017_05_npm_mvyoh_5_1_raitio_laeq2m__melualueet_2017_05_npm_mvyoh_5_1_raitio_laeq2mpolygon' table. It includes additional columns '_start_date' and '_end_date'. The '_start_date' column stores the date when a row was extracted from the data source, while the '_end_date' column stores 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 source of this data is the website of 'Helsingin kaupunkiympariston toimiala' from Finland (ISO country code 'fi'). This table provides valuable information for data analytics purposes.

Column Descriptions

Noise Areas in Helsinki, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data entry.
id	int	The unique identifier of the entry.
db_lo	float	The lower limit of the database entry.
db_hi	float	The upper limit of the database entry.
datanomist	string	The name of the data analyst who entered the data.
paivitetty	date	The date when the data was last updated.
geom_geojson	string	The GeoJSON representation of the geometry data.
geom_geotext	string	The Geotext representation of the geometry data.
geom_type	string	The type of geometry data.
geom_centroid	string	The centroid of the geometry data.
geom_center_x	double	The x-coordinate of the center point of the geometry data.
geom_center_y	double	The y-coordinate of the center point of the geometry data.
geom	binary	The geometry data.

Version History of Noise Areas Dataset from Helsinki Urban Environment Department 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	A numerical identifier for the row version.
id	int	The unique identifier of the base table row.
db_lo	float	Low-order bits of the unique identifier of the base table row.
db_hi	float	High-order bits of the unique identifier of the base table row.
datanomist	string	The name of the data scientist who updated the row version.
paivitetty	date	The date and time when the row version was last updated.
geom_geojson	string	The geometry of the base table row in GeoJSON format.
geom_geotext	string	The geometry of the base table row in Geotext format.
geom_type	string	The type of geometry present in the base table row.
geom_centroid	string	The centroid of the geometry in the base table row.
geom_center_x	double	The x-coordinate of the center point of the geometry in the base table row.
geom_center_y	double	The y-coordinate of the center point of the geometry in the base table row.
geom	binary	The full geometry object of the base table row.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024