Version History of Noise Study - Raitiolinja L AEQ Daily Sound Assessment for Area 05 - Finland
Click here for a data sample
This table contains the version history of the base table rows sourced from the web site of Helsingin kaupunkiympariston toimiala in Finland. The data in this table is related to 'avoindatameluselvitys_2017_alue_05_raitioliikenne_l_aeq_paiva__meluselvitys_2017_alue_05_raitioliikenne_l_aeq_paivapolygon' table. The table includes information such as the start date and end date of each row version, the row number, unique identifier 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns can be utilized for various data analytics purposes, such as analyzing the temporal changes in the data, identifying the data owner and the last update date, examining the geographical information related to the rows using different geometry formats, and finding the central coordinates of the polygons.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date and time when the row version starts being valid. |
|---|
| _end_date | date | The date and time when the row version stops being valid. |
|---|
| _row_number | long | The number assigned to each row version. |
|---|
| id | int | The unique identifier of each row version. |
|---|
| db_lo | int | The lower part of the database identifier. |
|---|
| db_hi | int | The higher part of the database identifier. |
|---|
| datanomist | string | The name of the data analyst who modified the row version. |
|---|
| paivitetty | string | The date and time when the row version was last updated. |
|---|
| geom_geojson | string | The geometry of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version in geotext format. |
|---|
| geom_type | string | The type of geometry in the row version. |
|---|
| geom_centroid | string | The centroid of the geometry in the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry in the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry in the row version. |
|---|
| geom | binary | The geometry of the row version. |
|---|
