Version History of Area 06 Railway Traffic (Night) Noise Survey in Helsinki, Finland
Click here for a data sample
This table contains the version history of the rows from the 'avoindatameluselvitys_2007_alue_06_raideliikenne_l_yo__meluselvitys_2007_alue_06_raideliikenne_l_yopolygon' table. It includes additional columns '_start_date' and '_end_date' that represent the extraction dates of each row. The data in this table can be utilized for data analytics purposes. For example, it can be used to track changes over time or analyze trends in the 'tietopalve' column. The 'geom_geojson' column contains the geometry data in GeoJSON format, which can be further analyzed spatially. The data in this table originates from the website of the 'Helsinki Urban Environment Division' in Finland (ISO country code: 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date indicating the validity period of the row version. |
|---|
| _end_date | date | The end date indicating the validity period of the row version. |
|---|
| _row_number | long | The unique identifier of the row version. |
|---|
| tietopalve | int | The data service associated with the row. |
|---|
| db_lo | int | The lower limit value of the row version. |
|---|
| db_hi | int | The upper limit value of the row version. |
|---|
| datanomist | string | The data controller of the row. |
|---|
| paivitetty | string | The date and time when the row was last updated. |
|---|
| geom_geojson | string | The geometric data in GeoJSON format. |
|---|
| geom_geotext | string | The geometric data as text. |
|---|
| geom_type | string | The type of geometric data. |
|---|
| geom_centroid | string | The centroid point of the geometric data. |
|---|
| geom_center_x | double | The X coordinate of the center of the geometric data. |
|---|
| geom_center_y | double | The Y coordinate of the center of the geometric data. |
|---|
| geom | binary | The geometric data in its original format. |
|---|
