Version History of Road Traffic Night Noise Survey (2012) in Area 08, Finland
Click here for a data sample
This table contains the version history of rows from the 'avoindatameluselvitys_2012_alue_08_tieliikenne_l_yo__meluselvitys_2012_alue_08_tieliikenne_l_yopolygon' base table. It has additional columns '_start_date' and '_end_date' which represent the extraction dates of the rows. The data in this table is sourced from the website of 'Helsinki City Environment Sector' which originates from the country Finland (ISO country code: 'fi'). The table contains various columns related to the extracted data, such as 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The data in this table can be used for various data analytics purposes, such as analyzing the change in noise levels over time, studying the distribution of noise sources in different locations, or identifying the central points of the geographical features represented by the 'geom' column.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date indicating the beginning of the validity period of the row version. |
|---|
| _end_date | date | The end date indicating the end of the validity period of the row version. |
|---|
| _row_number | long | The number assigned to each row in the version history table. |
|---|
| id | int | The unique identifier of each row in the base table. |
|---|
| db_lo | int | The low-order bits of the DB_ID of the versioned object. |
|---|
| db_hi | int | The high-order bits of the DB_ID of the versioned object. |
|---|
| datanomist | string | The name of the data analyst responsible for the version. |
|---|
| paivitetty | string | The date and time when the version was last updated. |
|---|
| geom_geojson | string | The geometry of the object in the GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the object in the GeoText format. |
|---|
| geom_type | string | The type of geometry of the object. |
|---|
| geom_centroid | string | The centroid of the geometry of the object. |
|---|
| geom_center_x | double | The X-coordinate of the center of the geometry of the object. |
|---|
| geom_center_y | double | The Y-coordinate of the center of the geometry of the object. |
|---|
| geom | binary | The full geometry object of the row version. |
|---|
