Version History of Helsinki Sub-Areas (Polygon)
Click here for a data sample
This table contains the version history of the 'seutukarttahelsinki_pienalueet__helsinki_pienalueetpolygon' table. It includes additional columns '_start_date' and '_end_date' which respectively indicate the extraction date of each row and the date when a new version of the row was extracted. The data in this table is sourced from the website of 'Helsinki City Environment Sector' in Finland ('fi' ISO country code). The table provides valuable information that can be used for data analytics purposes such as studying the changes in 'kokotun', 'kunta', 'suur', 'perus', 'osa', 'pien', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom' over time. By analyzing the version history, trends and patterns can be identified, enabling insights into the development of Helsinki's small areas and their associated attributes.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column indicates the start date of the validity period of the row version. |
|---|
| _end_date | date | This column indicates the end date of the validity period of the row version. |
|---|
| _row_number | long | This column represents the row number in the table. |
|---|
| kokotun | int | This column stores the value for 'kokotun' attribute. |
|---|
| kunta | int | This column stores the value for 'kunta' attribute. |
|---|
| suur | int | This column stores the value for 'suur' attribute. |
|---|
| perus | int | This column stores the value for 'perus' attribute. |
|---|
| osa | int | This column stores the value for 'osa' attribute. |
|---|
| pien | int | This column stores the value for 'pien' attribute. |
|---|
| mtryhm | int | This column stores the value for 'mtryhm' attribute. |
|---|
| geom_geojson | string | This column stores the geometric data in GeoJSON format. |
|---|
| geom_geotext | string | This column stores the geometric data in Geotext format. |
|---|
| geom_type | string | This column stores the type of geometric data. |
|---|
| geom_centroid | string | This column stores the centroid of the geometric data. |
|---|
| geom_center_x | double | This column stores the X-coordinate of the center of the geometric data. |
|---|
| geom_center_y | double | This column stores the Y-coordinate of the center of the geometric data. |
|---|
| geom | binary | This column stores the geometric data in a general format. |
|---|
