Version History of Green Area Lines
Click here for a data sample
This table represents the version history of rows in the 'Helsingin kaupunkiympariston toimiala' dataset. It is sourced from the website of 'City of Helsinki Urban Environment Division' in Finland. The table contains the base table rows from 'hkrylre_viherosat_line__ylre_viherosat_lineline' and includes additional columns '_start_date' and '_end_date'. The '_start_date' column indicates the date when a row was extracted from the data source, while the '_end_date' column indicates the date when a newer version of the row was extracted. If the value of '_end_date' is null, it means that the row represents the most recent version. The table provides valuable data for data analytics and insights. Some examples of how the data can be utilized include analyzing changes and trends in the various columns such as 'alatyyppi', 'materiaali', 'hoitoluokka', 'pituus', 'leveys', 'pinta_ala', 'viheralue1', and more. The data can be used to understand the evolution and characteristics of green areas, park maintenance, materials used, dimensions, and other related information. By analyzing the 'paivitetty' column, it is possible to track the dates at which the data was last updated. The table enables researchers, analysts, and organizations to gain valuable insights into the historical changes and attributes of urban green areas in Helsinki.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date of the validity period for the row version |
_end_date | date | The end date of the validity period for the row version |
_row_number | long | The row number of the version history |
osan_id | int | The identifier of the base table row |
paatyyppi | string | The main type of the data |
paatyyppi_c2 | int | The secondary main type of the data |
alatyyppi | string | The sub-type of the data |
alatyyppi_c4 | int | The secondary sub-type of the data |
materiaali | string | The material of the data |
materiaal0 | int | The secondary material of the data |
rakenteell | string | The structural information of the data |
rakenteel0 | int | The secondary structural information of the data |
talvikunno | string | The winter maintenance information of the data |
talvikunn0 | int | The secondary winter maintenance information of the data |
tkp_kiiree | string | The urgency of the repair work |
tyhjentava | string | The emptying information of the data |
hoitoluokk | string | The maintenance class of the data |
hoitoluok0 | int | The secondary maintenance class of the data |
hoitoluoka | string | The tertiary maintenance class of the data |
puhtaanapi | string | The cleanliness information of the data |
puhtaanap0 | int | The secondary cleanliness information of the data |
puhtaanap1 | int | The tertiary cleanliness information of the data |
pituus | int | The length of the data |
leveys | int | The width of the data |
pinta_ala | int | The surface area of the data |
puiston_ni | string | The park name or number of the data |
viheraluee | string | The green area of the data |
viheralue0 | int | The secondary green area of the data |
viheralue1 | int | The tertiary green area of the data |
osan_nro | int | The part number of the data |
paivitetty | string | The date of the data update |
geom_geojson | string | The geometry in GeoJSON format |
geom_geotext | string | The geometry 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 geometry information of the data |