Geospatial Data Collection of Helsingin Kaupunkiympariston Toimiala, 2012, Alue_03, Maantiet_l_aeq_paiva

The dataset collection consists of one or more dataset tables sourced from the website of 'Helsingin kaupunkiympäristön toimiala' in Finland.

Tables

History of Open Data Noise Study 2012 Area 03 Road Traffic dB(A) Equivalent Day Levels and Noise Study 2012 Area 03 Road Traffic dB(A) Equivalent Day PolygonTSV
The table 'avoindatameluselvitys_2012_alue_03_maantiet_l_aeq_paivameluselvitys_2012_alue_03_maantiet_l_aeq_paivapolygonhistory' contains the version history of its base table rows. It serves as a historical record of changes made to the base table 'avoindatameluselvitys_2012_alue_03_maantiet_l_aeq_paiva__meluselvitys_2012_alue_03_maantiet_l_aeq_paivapolygon'. The additional columns in this table are '_start_date' and '_end_date', which indicate the extraction dates of the row versions. The table is sourced from the website of 'Helsinki City Environment Sector', which is located in Finland (ISO country code 'fi'). This table can be utilized in data analytics to track changes, analyze trends, and perform historical comparisons of the geographic data represented by the rows in the base table.
Noise survey in Maantiet_l sub-area, 2012 - Geospatial Data for Noise Evaluation in Helsingin kaupunkiympariston toimiala, FinlandTSV
This table contains data from Helsingin kaupunkiympariston toimiala, which is a data source from Finland. The table 'avoindatameluselvitys_2012_alue_03_maantiet_l_aeq_paiva__meluselvitys_2012_alue_03_maantiet_l_aeq_paivapolygon' includes 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', 'geom_center_y', and 'geom'. This table can be utilized for data analytics purposes such as analyzing noise levels in different areas, studying the geographic distribution of noise, and identifying any patterns or trends in the data.

Column Descriptions

Noise survey in Maantiet_l sub-area, 2012 - Geospatial Data for Noise Evaluation in Helsingin kaupunkiympariston toimiala, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	A unique identifier for each row in the table.
id	int	The identifier for each record in the table.
db_lo	int	The lower bound of a database range.
db_hi	int	The upper bound of a database range.
datanomist	string	The name of the data scientist who created or updated the data.
paivitetty	string	The date and time when the record was last updated.
geom_geojson	string	The geometry of the record in GeoJSON format.
geom_geotext	string	The geometry of the record 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 full geometry information.

History of Open Data Noise Study 2012 Area 03 Road Traffic dB(A) Equivalent Day Levels and Noise Study 2012 Area 03 Road Traffic dB(A) Equivalent Day Polygon

Column	Type	Comment
_start_date	date	The date and time when the row version becomes valid.
_end_date	date	The date and time when the row version expires.
_row_number	long	The number assigned to each row in the table.
id	int	The unique identifier of the row.
db_lo	int	The lower part of a database identifier.
db_hi	int	The higher part of a database identifier.
datanomist	string	The data owner of the row.
paivitetty	string	The date and time of the row update.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The text representation of the geometry.
geom_type	string	The type of the geometry.
geom_centroid	string	The centroid point 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 geometry.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024