Version History of Lakes from Website of Helsingin kaupunkiympariston toimiala in Finland
Click here for a data sample
This table contains the version history of the 'seutukarttavakavesi_jarvet__vakavesi_jarvetpolygon' base table. It is sourced from the website of 'Helsinki City Environment Sector' which originates from Finland. The table includes columns such as '_start_date', '_end_date', '._row_number', 'vesistap', 'vesista0', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The '_start_date' column indicates the extraction date of each row, while the '_end_date' column shows the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row is the most recent version. The table's data can be utilized in data analytics to analyze and track changes over time in features related to bodies of water and their attributes, such as water types, area categories, and geographical information. The 'geom' column represents the geometric data associated with each row.
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. |
|---|
| vesistap | string | The 'vesistap' column. |
|---|
| vesista0 | string | The 'vesista0' column. |
|---|
| mtryhm | int | The 'mtryhm' column. |
|---|
| geom_geojson | string | The 'geom_geojson' column containing the geometry data in GeoJSON format. |
|---|
| geom_geotext | string | The 'geom_geotext' column containing the geometry data 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 'geom' column containing the geometry data. |
|---|
