Version History of 2007 Area 03 Road Traffic Noise Survey (Polygon) Data Source - Helsingin kaupunkiympariston toimiala (Finland)
Click here for a data sample
This table contains the version history of the base table 'avoindatameluselvitys_2007_alue_03_tieliikenne_l_den__meluselvitys_2007_alue_03_tieliikenne_l_denpolygon'. It tracks the changes made to the rows over time, with each row having additional columns '_start_date', '_end_date', and '_row_number'. The table is sourced from the website of 'Helsinki City Environment Sector', which originates from Finland (ISO country code 'fi'). The data in this table can be utilized for various data analytics tasks, such as analyzing the changes in 'geom_geojson' or 'geom_type' over time, identifying patterns in 'paivitetty' (date updated), or examining the distribution of 'db_lo' and 'db_hi'.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The timestamp indicating the start date of the validity period for the row version. |
|---|
| _end_date | date | The timestamp indicating the end date of the validity period for the row version. |
|---|
| _row_number | long | The unique identifier of each row version. |
|---|
| tietopalve | int | The information service associated with the row version. |
|---|
| db_lo | int | The lower bound value of the database range associated with the row version. |
|---|
| db_hi | int | The upper bound value of the database range associated with the row version. |
|---|
| datanomist | string | The data owner or custodian of the row version. |
|---|
| paivitetty | string | The timestamp indicating the last update or modification of the row version. |
|---|
| geom_geojson | string | The geometry representation of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometry representation of the row version in Geotext format. |
|---|
| geom_type | string | The type of geometry associated with the row version. |
|---|
| geom_centroid | string | The centroid point of the geometry associated with the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry associated with the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry associated with the row version. |
|---|
| geom | binary | The spatial representation of the row version. |
|---|
