Version History of Viheralue and Ylre Viheraluepolygon Rows
Click here for a data sample
This table provides the version history of the base table rows for 'Helsinki Urban Environment' sourced from the country Finland. It contains information such as the start and end dates of each row version, row numbers, green area details, park names, addresses, city regions, district areas, land use designations, ownership details, rental information, surface area, update timestamps, geometry information in various formats, and centroid coordinates. The table enables data analytics by allowing analysis of changes made over time, tracking the evolution of green areas, identifying trends in land use and ownership, analyzing rental patterns, and conducting spatial analysis based on the provided geometry and centroid information.
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. |
|---|
| viheralue | int | The green area related to the park. |
|---|
| puistonume | int | The park number. |
|---|
| puiston_ni | string | The park's N-I value. |
|---|
| puistonimi | int | The name of the park. |
|---|
| osoite | string | The address of the park. |
|---|
| kaupungino | string | The city or town where the park is located. |
|---|
| osa_alue | string | The sub-area where the park is located. |
|---|
| suurpiiri | string | The major district where the park is located. |
|---|
| kaavamerki | string | The zoning mark of the park. |
|---|
| kaavamerk0 | string | An additional zoning mark of the park. |
|---|
| kayttotark | string | The designated use of the park. |
|---|
| kayttotar0 | int | An additional designated use of the park. |
|---|
| omistaja | string | The owner of the park. |
|---|
| vuokraus | string | The rental status of the park. |
|---|
| vuokraaja | string | The renter of the park. |
|---|
| pinta_ala | int | The surface area of the park. |
|---|
| paivitetty | string | The last updated date of park information. |
|---|
| geom_geojson | string | The geometry of the park in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the park in Geotext format. |
|---|
| geom_type | string | The type of geometry for the park. |
|---|
| geom_centroid | string | The centroid point geometry of the park. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the park. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the park. |
|---|
| geom | binary | The complete geometry information of the park. |
|---|
