Version History for Vihiti Small Areas
Click here for a data sample
This table contains the version history of the 'seutukarttavihti_pienalueet__vihti_pienalueetpolygon' table. It includes additional columns '_start_date' and '_end_date' that indicate the extraction dates of each row. The data in this table is sourced from the website of Helsingin kaupunkiympariston toimiala, which originates from Finland (ISO country code 'fi'). The table can be used in various data analytics scenarios, such as tracking changes over time, analyzing the historical trends of geographical regions, or studying the evolution of specific attributes over different versions of the data.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date of the validity period of the row version. |
_end_date | date | The end date of the validity period of the row version. |
_row_number | long | The row number indicating the order of the row version. |
kokotun | int | The value of the 'kokotun' column. |
kunta | int | The value of the 'kunta' column. |
suur | int | The value of the 'suur' column. |
tila | int | The value of the 'tila' column. |
pien | int | The value of the 'pien' column. |
nimi | string | The value of the 'nimi' column. |
nimi_iso | string | The value of the 'nimi_iso' column. |
mtryhm | int | The value of the 'mtryhm' column. |
geom_geojson | string | The value of the 'geom_geojson' column. |
geom_geotext | string | The value of the 'geom_geotext' column. |
geom_type | string | The value of the 'geom_type' column. |
geom_centroid | string | The value of the 'geom_centroid' column. |
geom_center_x | double | The x-coordinate of the center point of the geometry. |
geom_center_y | double | The y-coordinate of the center point of the geometry. |
geom | binary | The geometry object containing spatial data. |