Urban Areas in Helsinki - March 2017

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, Finland (March 2017)TSV
This table contains data from Helsingin kaupunkiympariston toimiala, a data source from Finland (ISO country code: 'fi'). It consists of various attributes including '_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'. These attributes provide information that can be utilized in data analytics, such as analyzing noise levels ('db_lo' and 'db_hi') in different areas of Helsinki, identifying the data provider ('datanomist'), examining the date of data extraction ('_extract_date'), and exploring the geographical representation of the areas ('geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'). This table allows for...
Version History of Environmental Noise Areas in Helsinki, FinlandTSV
This table, avoindatamelualueet_2017_03_maant_hki_laeq7_22_paiva_npmmelualueet_2017_03_maant_hki_laeq722_paiva_npmpolygonhistory, contains the version history of the base table rows sourced from the website of Helsingin kaupunkiympariston toimiala, which originates from the country Finland (FI). The table includes columns such as '_start_date', '_end_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'. The data in this table can be utilized for various data analytics purposes, such as analyzing noise levels in different areas of Helsinki or investigating any changes or trends in the noise data over time.

Column Descriptions

Noise areas in Helsinki, Finland (March 2017)

Column	Type	Comment
_extract_date	date	The date and time when the data was extracted.
_row_number	long	The unique identifier for each row in the table.
id	int	The unique identifier for each record in the table.
db_lo	float	The lower value of the double precision range.
db_hi	float	The upper value of the double precision range.
datanomist	string	The name of the data owner.
paivitetty	date	The date when the record was last updated.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in Well-known 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 center point of the geometry.
geom_center_y	double	The y-coordinate of the center point of the geometry.
geom	binary	The spatial representation of the data.

Version History of Environmental Noise Areas in Helsinki, Finland

Column	Type	Comment
_start_date	date	The date when the row version starts to be valid.
_end_date	date	The date when the row version stops being valid.
_row_number	long	The number assigned to the row version.
id	int	The unique identifier of the row.
db_lo	float	The lower value of a range.
db_hi	float	The higher value of a range.
datanomist	string	The name of the data analyst.
paivitetty	date	The date when the row was last updated.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row 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 point of the geometry.
geom_center_y	double	The y-coordinate of the center point of the geometry.
geom	binary	The geometry of the row.

Additional Info

Last Updated	May 17, 2024
Created	April 23, 2024