Version History of Green Areas Points in Helsinki, Finland

This table contains the version history of the rows extracted from the 'Helsingin kaupunkiympariston toimiala' data source in the country 'Finland'. It is a historical record of the base table called 'ylre_viherosat_pointpoint'. Each row in this table represents a specific version of a row in the base table. The columns '_start_date' and '_end_date' indicate the extraction dates for each row version. If the '_end_date' column is null, it means that the row is the most recent version. The table contains additional columns such as '_row_number', 'osan_id', 'paatyyppi', 'paatyyppi_c2', 'alatyyppi', 'alatyyppi_c4', 'materiaali', 'materiaal0', 'rakenteell', 'rakenteel0', 'talvikunno', 'talvikunn0', 'tkp_kiiree', 'tyhjentava', 'hoitoluokk', 'hoitoluok0', 'hoitoluoka', 'puhtaanapi', 'puhtaanap0', 'puhtaanap1', 'pituus', 'leveys', 'pinta_ala', 'puiston_ni', 'viheraluee', 'viheralue0', 'viheralue1', 'osan_nro', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This table provides valuable historical data for conducting data analytics, such as tracking changes over time, analyzing trends, and comparing different versions of the rows for various purposes.