Version History of Area Noise Areas in Helsinki - Data Source: Helsinki City Environment Sector (Finland)
Click here for a data sample
This table contains the version history of rows from the 'avoindatamelualueet_2017_13_maant_hki_lden__melualueet_2017_13_maant_hki_ldenpolygon' base table. It has additional columns '_start_date' and '_end_date' representing the extraction dates of the row versions. The data in this table is sourced from the website of Helsingin kaupunkiympäristön toimiala, which originates from the country Finland (ISO country code 'fi'). The table provides valuable data that can be utilized for various data analytics purposes, such as studying the noise areas in Helsinki based on different time periods, analyzing changes in noise levels over time, identifying areas with significant noise variations, and exploring spatial patterns of noise pollution in the city.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for the row version in the table. |
|---|
| _end_date | date | The end date of the validity period for the row version in the table. |
|---|
| _row_number | long | The number assigned to each row version in the table. |
|---|
| id | int | The unique identifier for each row in the table. |
|---|
| db_lo | float | A lower bound value for the range of values for a given row. |
|---|
| db_hi | float | An upper bound value for the range of values for a given row. |
|---|
| datanomist | string | The name of the data custodian for the row version. |
|---|
| paivitetty | date | The date and time when the row version was last updated. |
|---|
| geom_geojson | string | The geometry of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version in text format. |
|---|
| geom_type | string | The type of geometry for the row version. |
|---|
| geom_centroid | string | The centroid of the geometry for the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry for the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry for the row version. |
|---|
| geom | binary | The geometry of the row version. |
|---|
