Version History of Road Traffic Noise Survey 2007 Area 04 Night-Time - Polygon (Web Source: Helsinki Urban Environment Sector, Country: Finland)
Click here for a data sample
This table contains the version history of the rows in the 'avoindatameluselvitys_2007_alue_04_tieliikenne_l_yo__meluselvitys_2007_alue_04_tieliikenne_l_yopolygon' table. The rows in this table are extracted from the data source provided by 'Helsingin kaupunkiympariston toimiala', which originates from Finland. It has additional columns compared to its base table, including '_start_date' and '_end_date', which represent the extraction dates of the rows. The table provides useful data for data analytics purposes, allowing analysts to track changes and historical versions of the rows. Analysts could utilize this data to perform trend analysis, identify patterns, or gain insights into the evolution of the rows over time.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column indicates the start date of the validity period of the row version. |
|---|
| _end_date | date | This column indicates the end date of the validity period of the row version. |
|---|
| _row_number | long | This column represents the row number of the version in the table. |
|---|
| tietopalve | int | This column stores the data related to the service. |
|---|
| db_lo | int | This column stores the low value of the database. |
|---|
| db_hi | int | This column stores the high value of the database. |
|---|
| datanomist | string | This column contains the data custodian information. |
|---|
| paivitetty | string | This column represents the date when the data was updated. |
|---|
| geom_geojson | string | This column stores the geometry data in the geojson format. |
|---|
| geom_geotext | string | This column stores the geometry data in the WKT (well-known text) format. |
|---|
| geom_type | string | This column indicates the type of geometry data. |
|---|
| geom_centroid | string | This column stores the centroid point of the geometry. |
|---|
| geom_center_x | double | This column stores the x-coordinate of the center point of the geometry. |
|---|
| geom_center_y | double | This column stores the y-coordinate of the center point of the geometry. |
|---|
| geom | binary | This column stores the geometry data in a specific format. |
|---|
