Version History of Helsingin kaupunkiympariston toimiala Table Rows in Finland
Click here for a data sample
This table contains the version history of the rows from the 'Helsingin kaupunkiympariston toimiala' data source. The data in this table is sourced from the web site of the Helsinki Urban Environment Division, which originates from Finland (ISO country code 'fi'). The table has additional columns compared to its base table, including '_start_date' which signifies the date when the row was extracted from the data source, and '_end_date' which indicates the date when a new version of the row was extracted. If the value of '_end_date' is null, it means that the row is the most recent version. The data in this table can be utilized in various data analytics tasks, such as analyzing the historical changes and trends of the 'kunta_nimi', 'suurpiiri', 'peruspiiri', 'id', 'tunnus', 'kunta', 'nimi', 'nimi_se', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom' attributes. These attributes provide valuable information for spatial analysis, demographic studies, and urban planning research.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date indicating the beginning of the validity period for the row version. |
|---|
| _end_date | date | The end date indicating the end of the validity period for the row version. |
|---|
| _row_number | long | The row number of the version history row. |
|---|
| kunta_nimi | string | The name of the municipality. |
|---|
| kunta_nim0 | string | The previous name of the municipality. |
|---|
| suurpiiri | string | The name of the big district. |
|---|
| suurpiiri0 | string | The previous name of the big district. |
|---|
| peruspiiri | string | The name of the basic district. |
|---|
| id | int | The unique identifier of the row. |
|---|
| tunnus | int | The code or symbol associated with the row. |
|---|
| peruspiir0 | int | The previous name of the basic district. |
|---|
| suurpiiri1 | int | Another name of the big district. |
|---|
| kunta | int | Another name of the municipality. |
|---|
| nimi | string | The name of the place. |
|---|
| nimi_se | string | The name of the place in Swedish. |
|---|
| peruspiir1 | string | Another name of the basic district. |
|---|
| geom_geojson | string | The geometry of the place in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the place in geotext format. |
|---|
| geom_type | string | The type of the geometry (point, line, polygon, etc.). |
|---|
| geom_centroid | string | The centroid point of the geometry. |
|---|
| 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 full geometry object. |
|---|
