Version History of Noise Areas for Railways in Helsinki - Melualueet 2017-20 Rautatiet HKI-LYO Polygon
Click here for a data sample
This table contains the version history of the 'avoindatamelualueet_2017_20_rautatiet_hki_lyo__melualueet_2017_20_rautatiet_hki_lyopolygon' 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 valuable information that can be utilized for data analytics purposes, such as analyzing the noise levels in different areas of Helsinki, tracking changes in noise data over time, identifying areas with high noise levels, and assessing the impact of noise pollution on urban environments.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period of the row version. |
|---|
| _end_date | date | The end date of the validity period of the row version. |
|---|
| _row_number | long | The unique row number of the version within the table. |
|---|
| id | int | The unique identifier of the row version. |
|---|
| db_lo | float | A lower bound value representing the database version. |
|---|
| db_hi | float | An upper bound value representing the database version. |
|---|
| datanomist | string | The data scientist responsible 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 textual representation of the geometry of the row version. |
|---|
| geom_type | string | The type of geometry of the row version. |
|---|
| geom_centroid | string | The centroid coordinates of the geometry of the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry of the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry of the row version. |
|---|
| geom | binary | The raw geometry data of the row version. |
|---|
