Version History of Building Identifier and Polygon, Sourced from Helsinki Urban Environment Sector, Finland

This table contains the version history of rows extracted from the 'Helsinki Urban Environment Sector' data source in Finland (ISO country code 'fi'). The base table for this history table is related to building identifiers and their corresponding polygons. The table includes columns such as '_start_date' and '_end_date' representing the extraction dates for each row version. Each row also has a unique '_row_number' identifier. This table includes various data fields such as 'rakennustu', 'kohdenimi', 'tekstisuun', 'tekstikoko', 'tekstifont', 'buix_bid', 'paivitetty', 'datanomist', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These fields provide valuable information that can be utilized in data analytics. For instance, the 'rakennustu' field could be used to analyze building types, and the 'kohdenimi' field could be utilized to explore specific location names. Additionally, the spatial information provided in the 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' fields could be leveraged for various spatial analysis tasks.