Version History of Neuvola Area Distribution in Helsinki (from web site of Helsinki Urban Environment Sector, Finland)
Click here for a data sample
This table contains the version history of the 'sote_neuvola_aluejako' base table from the data source 'Helsingin kaupunkiympariston toimiala' in Finland (ISO country code: 'fi'). It includes rows with additional columns '_start_date' and '_end_date' indicating the extraction dates of each version. The table 'helsote_neuvola_aluejakosote_neuvola_aluejakohistory' can be used for data analytics to analyze the evolution of the 'sote_neuvola_aluejako' table over time. By comparing the start and end dates, users can track changes made to the rows. The table provides valuable information for studying trends, identifying updates, and understanding historical patterns in the 'sote_neuvola_aluejako' base table.
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 unique row number of the version history table. |
|---|
| gml_id | string | The GML ID of the row version. |
|---|
| aluejako | string | The partition of the area. |
|---|
| kunta | int | The municipality of the area. |
|---|
| nimi | string | The name of the area. |
|---|
| nimi_se | string | The name of the area in Swedish. |
|---|
| omistaja | string | The owner of the area. |
|---|
| toimipiste | int | The location of the area. |
|---|
| tunnus | string | The identifier of the area. |
|---|
| geom_geojson | string | The geometric data of the area in GeoJSON format. |
|---|
| geom_geotext | string | The geometric data of the area in Geotext format. |
|---|
| geom_type | string | The type of geometric data (e.g., polygon, point). |
|---|
| geom_centroid | string | The centroid of the geometric data. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometric data. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometric data. |
|---|
| geom | binary | The full geometric data of the area. |
|---|
