Version History of Noise Areas in Helsinki Railway 2017-09 (Laeq7 22 days avg)
Click here for a data sample
This table contains the version history of rows from the 'avoindatamelualueet_2017_09_rautatiet_hki_laeq7_22_paiva_npm__melualueet_2017_09_rautatiet_hki_laeq722_paiva_npmpolygon' table. It includes additional columns '_start_date' and '_end_date' which indicate the extraction dates of each row. The data in this table is sourced from the website of 'Helsinki City Environment Sector' in Finland (ISO country code: 'fi'). The table provides data that can be utilized for various data analytics purposes, such as analyzing noise levels in different areas over time, studying the spatial distribution of noise pollution, and identifying trends or patterns in noise exposure within Helsinki.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for the row version. |
|---|
| _end_date | date | The end date of the validity period for the row version. |
|---|
| _row_number | long | The row number of the version in the history table. |
|---|
| id | int | The unique identifier of the row in the base table. |
|---|
| db_lo | float | The low-order bits of the database value. |
|---|
| db_hi | float | The high-order bits of the database value. |
|---|
| datanomist | string | The name of the data analyst who made the update. |
|---|
| paivitetty | date | The timestamp of when the row was last updated. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in geotext 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 geometry in a native format. |
|---|
