Dataset 'seutukarttasipoo_pienalueet' from 'Helsinki City Environment Sector' in Finland (ISO country code: 'fi')

Tables

• Small Areas in Sipoo Municipality on Regional MapTSV

  This table contains data from the 'Helsinki Urban Environment Sector' website for the region of 'Sipoo'. It includes information about small areas within Sipoo, such as their size, municipality, main area, status, name, name in ISO format, group, geographic coordinates, polygon type, centroid, center x-coordinate, center y-coordinate, and the geometry. The data in this table can be utilized in various data analytics tasks, such as analyzing the distribution of different area sizes within Sipoo, studying the relationship between the main areas and their corresponding small areas, examining the patterns of area statuses, and visualizing the geographic distribution of the small areas on a map.

• Version History of Polygon Areas in Sipoo, Sourced from Helsingin kaupunkiympariston toimiala, FinlandTSV

  This table contains the version history of rows extracted from the 'Helsinki Urban Environment Services' website for the 'fi' country. It is a historical record of the 'seutukarttasipoo_pienalueet__sipoo_pienalueetpolygon' table. The '_start_date' column represents the date when each version of a row was extracted, while the '_end_date' column indicates the date of the next version. If the '_end_date' is null, it means that the row is the most recent version. The table provides valuable data for data analytics purposes, allowing users to track the changes and evolution of various attributes over time. Analytics tasks may include analyzing trends in 'kokotun' (size category), 'kunta' (municipality), 'tila' (status), 'pien' (small), or 'nimi' (name) attributes. Furthermore, geographic...