Noise Areas in Helsinki Industry

This dataset collection, sourced from the website of the Helsingin kaupunkiympäristön toimiala in Finland, consists of one or more dataset tables. The collection provides information on industrial noise areas in Helsinki.

Tables

Industrial Noise Areas in Helsinki, FinlandTSV
This table provides data on industrial noise areas in Helsinki, Finland. The data is sourced from the website of the City of Helsinki Environment Sector. The table includes information such as the date of extraction, row number, object ID, noise level in decibels, geographic points in GeoJSON and Geotext formats, geometry type, centroid point coordinates, and the full geometry. The table can be utilized for various data analytics purposes, such as analyzing noise pollution patterns in industrial areas, identifying areas with high noise levels, and conducting spatial analysis on the distribution of noise areas within Helsinki.
Version History of Industrial Noise Areas in Helsinki - Helsingin kaupunkiympariston toimiala - FinlandTSV
This table contains the version history of the rows from the 'Helsingin kaupunkiympariston toimiala' data source, which originates from the country Finland (ISO country code 'fi'). The rows in this table represent different versions of the base table rows from the table 'helhki_teollisuus_melualueet_den__hki_teollisuus_melualueet_den'. Each row in this history table is associated with a start date ('_start_date') and an end date ('_end_date'), indicating the time period during which the particular version of the row was valid. If the end date is null, it means that the row is the most recent version. The table includes additional columns such as '_row_number' for identification purposes, 'objectid' for referencing the original objects, 'melu_db' for noise database information,...

Column Descriptions

Industrial 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.
objectid	string	Unique identifier for each object in the table.
melu_db	int	The database where the table belongs.
geom_geojson	string	The geometry of the object in GeoJSON format.
geom_geotext	string	The geometry of the object in text format.
geom_type	string	The type of the geometry.
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The x-coordinate of the centroid.
geom_center_y	double	The y-coordinate of the centroid.
geom	binary	The complete geometry of the object.

Version History of Industrial Noise Areas in Helsinki - Helsingin kaupunkiympariston toimiala - Finland

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	A unique identifier for each row version.
objectid	string	The unique identifier for each row in the base table.
melu_db	int	The name of the database where the row version belongs.
geom_geojson	string	The geometry object in GeoJSON format.
geom_geotext	string	The geometry object in Geotext format.
geom_type	string	The type of geometry object.
geom_centroid	string	The centroid of the geometry object.
geom_center_x	double	The X-coordinate of the center point of the geometry object.
geom_center_y	double	The Y-coordinate of the center point of the geometry object.
geom	binary	The full geometry object.

Additional Info

Last Updated	May 17, 2024
Created	April 23, 2024