History of Basic Map Polygons in Helsinki City Region
Click here for a data sample
The table provides the version history of rows from the 'avoindataseutukartta_hel_perus__seutukartta_hel_peruspolygon' base table sourced from the web site of 'Helsinki City Planning Department' in Finland ('FI'). It contains information about various attributes like 'kokotun', 'kunta', 'suur', 'perus', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', and 'tietopalve'. The table includes additional columns '_start_date' and '_end_date', representing the extraction dates of the row versions. Utilizing this data, various data analytics tasks can be performed, such as analyzing the changes in attributes over time, identifying trends or patterns, comparing versions, and predicting future changes in the dataset.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the row version starts to be valid. |
|---|
| _end_date | date | The date when the row version stops being valid. |
|---|
| _row_number | long | The unique number assigned to each row version. |
|---|
| 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. |
|---|
| perus | int | The value representing the 'perus' attribute of the row. |
|---|
| nimi | string | The value representing the 'nimi' attribute of the row. |
|---|
| nimi_iso | string | The ISO representation of the 'nimi' attribute of the row. |
|---|
| mtryhm | int | The value representing the 'mtryhm' attribute of the row. |
|---|
| geom_geojson | string | The geographic JSON representation of the geometry. |
|---|
| geom_geotext | string | The geotext representation of the geometry. |
|---|
| geom_type | string | The type of the geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The X-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | The Y-coordinate of the center of the geometry. |
|---|
| geom | binary | The spatial representation of the geometry. |
|---|
| tietopalve | int | The value representing the 'tietopalve' attribute of the row. |
|---|
