Version History of Rows in 'Helsingin kaupunkiympariston toimiala' Table from Finland
Click here for a data sample
This table contains the version history of the 'Helsingin kaupunkiympariston toimiala' dataset. It is sourced from the website of Helsinki City Planning Department which originates from the country Finland (ISO country code: FI). The table includes various columns such as '_start_date', '_end_date', '_row_number', 'source', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. The '_start_date' column indicates the date when each row was extracted from the data source, while the '_end_date' column represents the date when a new version of a row was extracted. If the '_end_date' value is null, it signifies that the row is the most recent version. This version history table provides valuable insights for data analytics and enables tracking changes made to the original 'Helsingin kaupunkiympariston toimiala' dataset over time.
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 of the versioned row. |
|---|
| source | string | The source of the row version. |
|---|
| geom_geojson | string | The geometry of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version in geotext format. |
|---|
| geom_type | string | The type of geometry of the row version. |
|---|
| geom_centroid | string | The centroid of the geometry of the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry of the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry of the row version. |
|---|
| geom | binary | The geometry of the row version. |
|---|
