Version History of Education Data for Basic Education in Finland
Click here for a data sample
This table, sourced from the website of the 'Helsinki City Environment Department' from Finland, provides the version history of rows in the 'avoindataopev_ooa_alaaste_suomi__opev_ooa_alaaste_suomipolygon' table. The rows in this table contain information about various attributes such as 'id', 'aluejako', 'kunta', 'tunnus', 'nimi_fi', 'nimi_se', 'toimipiste', 'yhtluontip', 'yhtdatanom', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The '_start_date' column represents the date when a particular row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' value is null, it implies that the row is the most recent version. The data in this table can be utilized for various data analytics tasks such as trend analysis, historical comparisons, and studying changes over time in the geographic attributes mentioned above.
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 row number indicating the position of the row version. |
|---|
| id | int | The unique identifier of the row. |
|---|
| aluejako | string | The division of the area. |
|---|
| kunta | int | The municipality of the area. |
|---|
| tunnus | int | The code or identifier of the area. |
|---|
| nimi_fi | string | The name of the area in Finnish. |
|---|
| nimi_se | string | The name of the area in Swedish. |
|---|
| toimipiste | int | The office location or branch. |
|---|
| yhtluontip | string | The combined creation type. |
|---|
| yhtdatanom | string | The combined data authority. |
|---|
| paivitetty | string | The timestamp of when the row was last updated. |
|---|
| geom_geojson | string | The geometry of the area in GeoJSON format. |
|---|
| geom_geotext | string | The textual representation of the area's geometry. |
|---|
| geom_type | string | The type of the area's geometry. |
|---|
| geom_centroid | string | The centroid of the area's geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the area's geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the area's geometry. |
|---|
| geom | binary | The detailed geometry information of the area. |
|---|
