Metro Noise Survey Area - Version History
Click here for a data sample
This table contains the version history of rows from the 'avoindatameluselvitys_2017_alue_18_metro_l_yo__meluselvitys_2017_alue_18_metro_l_yopolygon' table. The rows in this table represent different versions of the base table rows extracted from the data source. The '_start_date' column denotes the date when each row was extracted, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row is the most recent version. The table is sourced from the website of 'Helsingin kaupunkiympariston toimiala', which is an environmental department of the city of Helsinki, Finland (ISO country code 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period of the row version. |
|---|
| _end_date | date | The end date of the validity period of the row version. |
|---|
| _row_number | long | The row number of the version. |
|---|
| id | int | The unique identifier of the row version. |
|---|
| db_lo | int | Database-related low value. |
|---|
| db_hi | int | Database-related high value. |
|---|
| datanomist | string | The data nomist of the row version. |
|---|
| paivitetty | string | The date when the row version was last updated. |
|---|
| geom_geojson | string | The geometry in GEOJSON format. |
|---|
| geom_geotext | string | The geometry in GEOTEXT format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry. |
|---|
| geom | binary | The geometry. |
|---|
