Version history of the 'Helsinki City Environment Department's dataset on land use in lakes - Helsinki City Environment Department's dataset on land use in lakes polygon', sourced from Finland
Click here for a data sample
This table contains the version history of the rows in the 'avoindataseutukartta_maankaytto_jarvet__seutukartta_maankaytto_jarvetpolygon' table. It has two additional columns compared to its base table: '_start_date' and '_end_date'. The column '_start_date' indicates the date when the row was extracted from the data source, while the column '_end_date' indicates the date when a new version of the row was extracted. If the value of the column '_end_date' is null, it means that the row is the most recent version of the row. The table is sourced from the website of 'Helsinki City Environment Sector' which originates from Finland (country code: 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for the row version in the table. |
|---|
| _end_date | date | The end date of the validity period for the row version in the table. |
|---|
| _row_number | long | The unique identifier for each row version in the table. |
|---|
| vesisto_ni | string | Unknown meaning column. |
|---|
| vesisto_n0 | string | Unknown meaning column. |
|---|
| mtryhm | int | Unknown meaning column. |
|---|
| geom_geojson | string | The geometries of the rows in the table stored in GeoJSON format. |
|---|
| geom_geotext | string | The geometries of the rows in the table stored in Geotext format. |
|---|
| geom_type | string | The type of geometry for each row in the table. |
|---|
| geom_centroid | string | The centroid coordinates of the geometry for each row in the table. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry for each row in the table. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry for each row in the table. |
|---|
| geom | binary | The geometries of the rows in the table. |
|---|
| tietopalve | int | Unknown meaning column. |
|---|
