Version History of Open Water Sources (Polygon) in Helsinki, Finland
Click here for a data sample
This table contains the version history of the 'ltj_avoinvesi_lahteet__vesi_lahteetpolygon' table rows. The rows in this table represent different versions of the data extracted from the web site of 'Helsinki Urban Environment Division'. The data originates from Finland (ISO country code 'fi'). The table includes columns '_start_date' and '_end_date' which indicate the extraction timestamps for each row version. The other columns of the table hold various attributes and metadata related to the water sources. The data in this table can be utilized in data analytics for various purposes such as analyzing the changes in water source characteristics over time, studying the distribution and classification of water sources, and examining the spatial properties of the water sources.
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 history. |
|---|
| id | int | The unique identifier of the row. |
|---|
| tunnus | int | The tunnus value of the row. |
|---|
| luokkatunn | string | The luokkatunn value of the row. |
|---|
| luokan_nim | string | The luokan_nim value of the row. |
|---|
| nimi | string | The nimi value of the row. |
|---|
| kuvaus | string | The kuvaus value of the row. |
|---|
| huom | string | The huom value of the row. |
|---|
| digipvm | string | The digital date of the row. |
|---|
| pvm_editoi | string | The date when the row was edited. |
|---|
| pinta_ala | float | The pinta_ala value of the row. |
|---|
| kohdetekst | string | The kohdetekst value of the row. |
|---|
| metadata | string | The metadata associated with the row. |
|---|
| geom_geojson | string | The row's geometry in GeoJSON format. |
|---|
| geom_geotext | string | The row's geometry in Geotext format. |
|---|
| geom_type | string | The type of the row's geometry. |
|---|
| geom_centroid | string | The centroid of the row's geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the row's geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the row's geometry. |
|---|
| geom | binary | The geometry of the row. |
|---|
