Historical Version of Table: Finnish Primary Education Areas in Sweden (Polygon)
Click here for a data sample
The table contains the version history of rows from the 'Helsingin kaupunkiympariston toimiala' data source, which originates from the country 'Finland' (ISO country code 'fi'). The table provides a historical record of changes made to rows in the base table, 'avoindataopev_ooa_alaaste_ruotsi__opev_ooa_alaaste_ruotsipolygon'. Each row in the history table includes the '_start_date' and '_end_date' columns, indicating the extraction dates of the row versions. The table includes additional columns like '_row_number', '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', which store various attributes and location-related information. The table's data can be utilized for various data analytics purposes, such as tracking changes over time, analyzing trends in attribute values, and examining the spatial distribution of the data using the geographic information stored in the 'geom' column.
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 sequential number assigned to each row version in the table. |
|---|
| id | int | The unique identifier for each row in the table. |
|---|
| aluejako | string | The area division of the row. |
|---|
| kunta | int | The municipality of the row. |
|---|
| tunnus | int | The identifier for the row. |
|---|
| nimi_fi | string | The name of the row in Finnish language. |
|---|
| nimi_se | string | The name of the row in Swedish language. |
|---|
| toimipiste | int | The office of the row. |
|---|
| yhtluontip | string | The creation date of the row. |
|---|
| yhtdatanom | string | The data creator of the row. |
|---|
| paivitetty | string | The update date of the row. |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row in GeoTEXT format. |
|---|
| geom_type | string | The type of geometry for the row. |
|---|
| geom_centroid | string | The centroid of the geometry for the row. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry for the row. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry for the row. |
|---|
| geom | binary | The geometry data for the row. |
|---|
