Residential Area Polygon History from Helsinki City Environment Department, Finland

This table contains the version history of rows from the base table 'seutukarttaasuinalueet__asuinalueetpolygon'. The rows in this table represent different versions of the data extracted from the website of the 'City of Helsinki Environment Sector' in Finland. Each row in the table is identified by the columns '_start_date', '_end_date', and '_row_number'. The '_start_date' column contains the date when the row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it means that the row is the most recent version. The table includes additional columns such as 'maankay', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom'. These columns provide various information related to the geographical polygons of residential areas. The use of this data in data analytics could include analyzing trends in land use, studying different types of residential areas, visualizing geographical features using the 'geom_geojson' column, and calculating spatial properties such as centroid coordinates using 'geom_centroid', 'geom_center_x', and 'geom_center_y' columns.