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

To download the data set, please sign up or log in

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_datedateThe start date of the validity period of the row version in the table
_end_datedateThe end date of the validity period of the row version in the table
_row_numberlongThe row number of the version in the table
kokotunintThe 'kokotun' column in the table
kuntaintThe 'kunta' column in the table
suurintThe 'suur' column in the table
tilaintThe 'tila' column in the table
pienintThe 'pien' column in the table
nimistringThe 'nimi' column in the table
nimi_isostringThe 'nimi_iso' column in the table
mtryhmintThe 'mtryhm' column in the table
geom_geojsonstringThe geometric information in GeoJSON format in the table
geom_geotextstringThe geometric information in Geotext format in the table
geom_typestringThe type of the geometry in the table
geom_centroidstringThe centroid of the geometry in the table
geom_center_xdoubleThe X-coordinate of the center of the geometry in the table
geom_center_ydoubleThe Y-coordinate of the center of the geometry in the table
geombinaryThe geometric information in the table

No sample for this dataset

Additional Information

Last updated April 24, 2024
Created April 24, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_helsingin_kaupunkiympariston_toimiala
Idcd3b32ed-cbe2-4c9e-aa5f-012a90c9e919
Package id66d3e609-ad70-45b1-a094-82ad94537bf3
Position1
Revision idfeb309b2-52f8-45b9-a602-93b783f9b87c
Stateactive
Tableseutukarttasipoo_pienalueet__sipoo_pienalueetpolygon__history