History of Alue 19 Rautatiet Läden Data from Helsingin kaupunkiympäristön toimiala in Finland
Click here for a data sample
This table contains the version history of rows from the 'avoindatameluselvitys_2017_alue_19_rautatiet_l_den__meluselvitys_2017_alue_19_rautatiet_l_denpolygon' base table. It includes additional columns '_start_date' and '_end_date' indicating the extraction dates of each row. The data in this table is sourced from the website of 'Helsinki City Environment Sector', which originates from the country with ISO country code 'fi'. The table can be used for data analytics purposes, such as analyzing changes over time or measuring the impact of noise pollution on different regions.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | Column indicating the start date of the validity period of the row version. |
|---|
| _end_date | date | Column indicating the end date of the validity period of the row version. |
|---|
| _row_number | long | Column indicating the row number of the version in the history table. |
|---|
| id | int | Column representing the unique identifier of the base table row. |
|---|
| db_lo | int | Column representing the lower value of a date or time range. |
|---|
| db_hi | int | Column representing the upper value of a date or time range. |
|---|
| datanomist | string | Column indicating the data custodian or owner. |
|---|
| paivitetty | string | Column indicating the last updated date or timestamp. |
|---|
| geom_geojson | string | Column storing the geometries of the row version in GeoJSON format. |
|---|
| geom_geotext | string | Column storing the geometries of the row version in text format. |
|---|
| geom_type | string | Column indicating the type of geometry. |
|---|
| geom_centroid | string | Column storing the centroid of the geometry. |
|---|
| geom_center_x | double | Column storing the X coordinate of the centroid. |
|---|
| geom_center_y | double | Column storing the Y coordinate of the centroid. |
|---|
| geom | binary | Column storing the geometry in a binary format. |
|---|
