Area 04 Road Network Data - Helsinki Urban Environment Sector

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

Tables

2012 Noise Survey - Road Network in Helsingin kaupunkiympariston toimiala, FinlandTSV
This table contains data from 'Helsinki City Environment Department' sourced from the website avoindata.fi. The data relates to a noise survey conducted in 2012 for road sections in Area 04 of Helsinki. The table includes various attributes such as the extract date, row number, unique identifier, noise levels (low and high), data analyst's name, last updated date, geometric representation of the road sections in both geojson and geotext formats, the type of geometry, centroid coordinates, and the full geometric representation. The data in this table can be utilized for data analytics purposes such as analyzing noise levels in different road sections, identifying noise hotspots, comparing noise levels with other factors like population density or land use, or evaluating the effectiveness...
Version History of Geospatial Data for Noise Assessment Areas in Area 04, Roads with Equivalent Noise Levels (LAeq) at Night - Finland, Helsinki Urban Environment SectorTSV
This table contains the version history of the rows in the 'avoindatameluselvitys_2012_alue_04_maantiet_l_aeq_yo__meluselvitys_2012_alue_04_maantiet_l_aeq_yopolygon' table. The rows in this table are extracted from the data source provided by 'Helsinki Urban Environment Department'. The data source originates from Finland (ISO country code: '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'. By analyzing the data in this table, one can gain insights into the historical changes and updates of the rows in the base table. This can be useful for data analytics tasks such as tracking modifications, analyzing...

Column Descriptions

2012 Noise Survey - Road Network in Helsingin kaupunkiympariston toimiala, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the record in the table.
id	int	The unique identifier of the record.
db_lo	int	The lower value of a double precision number.
db_hi	int	The higher value of a double precision number.
datanomist	string	The name of the data scientist who provided the data.
paivitetty	string	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 (WKT) 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 record.

Version History of Geospatial Data for Noise Assessment Areas in Area 04, Roads with Equivalent Noise Levels (LAeq) at Night - Finland, Helsinki Urban Environment Sector

Column	Type	Comment
_start_date	date	This column indicates the start date of the validity period for the row version.
_end_date	date	This column indicates the end date of the validity period for the row version.
_row_number	long	This column represents the row number of the version in the table.
id	int	This column stores the unique identifier for each row version.
db_lo	int	This column represents the lower limit of a specific database value range.
db_hi	int	This column represents the higher limit of a specific database value range.
datanomist	string	This column contains information about the data analyst associated with the row version.
paivitetty	string	This column stores the date and time when the row version was last updated.
geom_geojson	string	This column stores the geometry data in GeoJSON format.
geom_geotext	string	This column stores the geometry data in geotext format.
geom_type	string	This column indicates the type of geometry data stored in the row version.
geom_centroid	string	This column represents the centroid of the geometry data.
geom_center_x	double	This column stores the X-coordinate of the center of the geometry data.
geom_center_y	double	This column stores the Y-coordinate of the center of the geometry data.
geom	binary	This column stores the raw geometry data.

Additional Info

Last Updated	September 13, 2024
Created	April 24, 2024