Version history of Road Traffic Night Noise Survey 2017 Area 12 - Noise Survey 2017 - Road Traffic Night Noise Polygon - Finland
Click here for a data sample
This table contains the version history of the rows from the 'avoindatameluselvitys_2017_alue_12_tieliikenne_l_yo__meluselvitys_2017_alue_12_tieliikenne_l_yopolygon' base table. The rows in this table represent different versions of the data extracted from the web site of 'City Planning Department of Helsinki', which originates from Finland. Each row in the table has information about the start and end date of its version. If the '_end_date' column value is null, it means that the row represents the most recent version. The table may be utilized in data analytics to analyze changes and trends over time in the dataset, such as studying the evolution of noise levels in different areas of Helsinki during nighttime.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The starting date of the validity period for the row version |
|---|
| _end_date | date | The ending date of the validity period for the row version |
|---|
| _row_number | long | The sequential number of the row version |
|---|
| id | int | The identifier of the row |
|---|
| db_lo | int | The lower part of the database identifier of the row |
|---|
| db_hi | int | The higher part of the database identifier of the row |
|---|
| datanomist | string | The name of the person who updated the row |
|---|
| paivitetty | string | The date and time when the row was last updated |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format |
|---|
| geom_geotext | string | The geometry of the row in Geotext format |
|---|
| geom_type | string | The type of geometry of the row |
|---|
| geom_centroid | string | The centroid of the geometry of the row |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry of the row |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry of the row |
|---|
| geom | binary | The geometry of the row |
|---|
