Geospatial Data Collection from Helsingin kaupunkiympariston toimiala in Finland
Tables
-
History of the Area 13 Road Noise Evaluation for the Year 2017 - Polygon Representation - Version HistoryTSV
This table, sourced from the website of Helsingin kaupunkiympäristön toimiala, contains the version history of rows from the base table avoindatameluselvitys_2017_alue_13_maantiet_l_den__meluselvitys_2017_alue_13_maantiet_l_denpolygon. The table includes columns such as '_start_date', '_end_date', 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The '_start_date' column represents the date when a row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version. The data in this table can be utilized for data analytics purposes, such as...
-
Noise Survey 2017 - Road Areas in Region 13 - Polygon DataTSV
This table contains data from 'Helsinki City Environment Division' website. The data represents the geographical areas and noise levels of road traffic in Finland. The table provides information about the extraction date, unique row number, identifier, lower and higher decibel levels, data source, last updated date, geographic data in GeoJSON and Geotext formats, geometry type, centroid coordinates, and the geometry itself. The data in this table can be utilized in various data analytics scenarios such as analyzing noise pollution distribution, identifying areas with high noise levels, spatial visualization, and correlation studies between noise levels and other variables in the vicinity of the road traffic areas.
Column Descriptions
Noise Survey 2017 - Road Areas in Region 13 - Polygon Data
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The extraction date of the data. |
| _row_number | long | The row number of the data. |
| id | int | The unique identifier of the record. |
| db_lo | int | The low bound of the database index. |
| db_hi | int | The high bound of the database index. |
| datanomist | string | The name of the data scientist. |
| paivitetty | string | The date of last update. |
| geom_geojson | string | The geographic data in GeoJSON format. |
| geom_geotext | string | The geographic data in geotext format. |
| geom_type | string | The type of the geographic data. |
| geom_centroid | string | The centroid of the geographic data. |
| geom_center_x | double | The x-coordinate of the center of the geographic data. |
| geom_center_y | double | The y-coordinate of the center of the geographic data. |
| geom | binary | The geometric data. |
History of the Area 13 Road Noise Evaluation for the Year 2017 - Polygon Representation - Version History
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column indicates the start date of the validity period of the row version. |
| _end_date | date | This column indicates the end date of the validity period of the row version. |
| _row_number | long | This column represents the row number or index of the table. |
| id | int | This column stores the unique identifier for each row in the table. |
| db_lo | int | This column is a part of a composite key that represents the lower bound value of the database identifier range. |
| db_hi | int | This column is a part of a composite key that represents the upper bound value of the database identifier range. |
| datanomist | string | This column stores information about the data scientist or person responsible for the data. |
| paivitetty | string | This column represents the date and time when the data 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. |
| geom_centroid | string | This column stores the centroid coordinates of the geometry. |
| geom_center_x | double | This column represents the X coordinate of the center of the geometry. |
| geom_center_y | double | This column represents the Y coordinate of the center of the geometry. |
| geom | binary | This column stores the geometry data in a specific format. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | October 21, 2018 |