Version History of Traffic Noise Study 2017 Area 11 Road Traffic Sound Level in Finland
Click here for a data sample
This table contains the version history of rows extracted from the 'Helsingin kaupunkiympariston toimiala' website in the country 'Finland' (ISO country code 'fi'). The table records the changes made to the base table rows identified by the 'id' column. Each version of a row is identified by a unique '_row_number' value. The '_start_date' column indicates the extraction date of a row, while the '_end_date' column indicates the extraction date of the next version of the row. If a row is the most recent version, its '_end_date' value will be null. The table also includes other columns such as 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom', which contain various data related to the extracted rows. This table provides valuable information for data analytics, allowing analysts to track and analyze the changes made to the data over time.
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 sequential number of the row version. |
|---|
| id | int | The unique identifier of the row version. |
|---|
| db_lo | int | A low part of the double-precision floating-point number representing a database value. |
|---|
| db_hi | int | A high part of the double-precision floating-point number representing a database value. |
|---|
| datanomist | string | The name of the data analyst. |
|---|
| paivitetty | string | The date of the last update of the row version. |
|---|
| geom_geojson | string | The geometry data in GeoJSON format. |
|---|
| geom_geotext | string | The geometry data in geotext format. |
|---|
| geom_type | string | The type of the geometry data. |
|---|
| geom_centroid | string | The centroid of the geometry data. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry data. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry data. |
|---|
| geom | binary | The geometry data. |
|---|
