Version History of Water Drainage Areas - Source: Helsinki City Environment Department, Finland
Click here for a data sample
This table contains the version history of the 'ltj_avoinvesi_purojen_ja_lampien_valuma_alueet__vesi_purojen_ja_lampien_valuma_alueetpolygon' table. It has additional columns '_start_date' and '_end_date', which indicate the start and end dates of each row's version. The data in this table is sourced from the website of 'Helsinki City Environment Sector', which originates from Finland (ISO country code 'fi'). The table provides information that can be used for various data analytics purposes, such as analyzing the changes in 'pinta_ala' (surface area) over time, understanding the spatial distribution of 'nimi' (name) across different versions, examining the 'kuvaus' (description) of each version, and exploring the geographic attributes like 'geom_type' and 'geom_centroid', which can be utilized for spatial analysis.
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 row number indicating the version history order. |
|---|
| id | int | The unique identifier of the table row. |
|---|
| tunnus | string | The identifier of the table row. |
|---|
| luokkatunn | string | The class identifier of the table row. |
|---|
| luokan_nim | string | The name of the class of the table row. |
|---|
| nimi | string | The name of the table row. |
|---|
| kuvaus | string | The description of the table row. |
|---|
| huom | string | The additional information of the table row. |
|---|
| digipvm | string | The digital date of the table row. |
|---|
| pvm_editoi | string | The date when the table row was edited. |
|---|
| pinta_ala | float | The surface area of the table row. |
|---|
| kohdetekst | string | The target text of the table row. |
|---|
| metadata | string | The metadata of the table row. |
|---|
| geom_geojson | string | The geometry in GeoJSON format of the table row. |
|---|
| geom_geotext | string | The geometry in GeoText format of the table row. |
|---|
| geom_type | string | The type of the geometry of the table row. |
|---|
| geom_centroid | string | The centroid of the geometry of the table row. |
|---|
| geom_center_x | double | The X-coordinate of the center of the geometry of the table row. |
|---|
| geom_center_y | double | The Y-coordinate of the center of the geometry of the table row. |
|---|
| geom | binary | The geometry of the table row. |
|---|
