Version History of Avoindatakaavahakemisto Viiteviivat - Kaavahakemisto Viiteviivatpoint

This table contains the version history of rows from the 'avoindatakaavahakemisto_viiteviivat__kaavahakemisto_viiteviivatpoint' base table. It represents data sourced from the website of the Department of Urban Environment in Helsinki, Finland. The table includes additional columns '_start_date' and '_end_date', which indicate the extraction dates of each row version. The table can be utilized for data analytics purposes, such as analyzing the changes in 'sijaintial' (location), 'geom_geojson' (geographical data in GeoJSON format), 'geom_geotext' (geographical data in Geotext format), 'geom_type' (geometry type), 'geom_centroid' (centroid coordinates), 'geom_center_x' (x-coordinate of the geometric center), 'geom_center_y' (y-coordinate of the geometric center), and 'geom' (general geometry). By examining the historical versions of these attributes, valuable insights can be gained regarding the spatial evolution or patterns over time in Helsinki's urban environment.