Version History of Hyvinkaa Small Areas for Seutukartta from Helsingin kaupunkiympariston toimiala (Finland)
Click here for a data sample
This table contains the version history of the 'seutukarttahyvinkaa_pienalueet__hyvinkaa_pienalueetpolygon' table. It is sourced from the website of 'Helsinki City Planning Department' in Finland. The table includes information about the start and end dates of each row, along with other columns like 'row_number', 'kokotun', 'kunta', 'suur', 'tila', 'pien', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The 'geom' column contains the geometric data. This historical versioning framework allows tracking changes over time. Not listing its individual columns, this data can be utilized in various data analytics tasks such as tracking changes in 'tila' (status) over time, analyzing the geographical distribution using the 'geom' column, and understanding the evolution of 'pien' (small) areas in 'kunta' (municipality) 'Hyvinkaa' in a temporal context.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for the row version. |
|---|
| _end_date | date | The end date of the validity period for the row version. |
|---|
| _row_number | long | The row number indicating the order of the row version in the version history. |
|---|
| kokotun | int | The value representing the 'kokotun' attribute of the row. |
|---|
| kunta | int | The value representing the 'kunta' attribute of the row. |
|---|
| suur | int | The value representing the 'suur' attribute of the row. |
|---|
| tila | int | The value representing the 'tila' attribute of the row. |
|---|
| pien | int | The value representing the 'pien' attribute of the row. |
|---|
| nimi | string | The value representing the 'nimi' attribute of the row. |
|---|
| nimi_iso | string | The value representing the 'nimi_iso' attribute of the row. |
|---|
| mtryhm | int | The value representing the 'mtryhm' attribute of the row. |
|---|
| geom_geojson | string | The value representing the 'geom_geojson' attribute of the row. |
|---|
| geom_geotext | string | The value representing the 'geom_geotext' attribute of the row. |
|---|
| geom_type | string | The geometry type of the row. |
|---|
| geom_centroid | string | The centroid of the geometry of the row. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry of the row. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry of the row. |
|---|
| geom | binary | The geometry of the row. |
|---|
