Version History of Polygon Areas in Sipoo, Sourced from Helsingin kaupunkiympariston toimiala, Finland
Click here for a data sample
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 analysis can be performed using the 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom' columns which provide information about the geographical features of the regions.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date of the validity period of the row version in the table |
_end_date | date | The end date of the validity period of the row version in the table |
_row_number | long | The row number of the version in the table |
kokotun | int | The 'kokotun' column in the table |
kunta | int | The 'kunta' column in the table |
suur | int | The 'suur' column in the table |
tila | int | The 'tila' column in the table |
pien | int | The 'pien' column in the table |
nimi | string | The 'nimi' column in the table |
nimi_iso | string | The 'nimi_iso' column in the table |
mtryhm | int | The 'mtryhm' column in the table |
geom_geojson | string | The geometric information in GeoJSON format in the table |
geom_geotext | string | The geometric information in Geotext format in the table |
geom_type | string | The type of the geometry in the table |
geom_centroid | string | The centroid of the geometry in the table |
geom_center_x | double | The X-coordinate of the center of the geometry in the table |
geom_center_y | double | The Y-coordinate of the center of the geometry in the table |
geom | binary | The geometric information in the table |