History of ELY-areas 2023 Version Data (1:4 500 000)
Click here for a data sample
The 'table__history' is a comprehensive repository of version history data related to the ELY-areas for the year 2023, sourced from the Finnish statistical authority, 'Tilastokeskus' (Statistics Finland). With a focus on geospatial information, the table provides a wealth of data points for each row, including geographical coordinates, polygonal representations, and geographical centroid points, all presented using the WGS 84 coordinate reference system (longitude first, followed by latitude). In addition to geographical data, the table also holds important data points such as the ELY area identifiers and names in multiple languages including English, Finnish, and Swedish. The table also tracks the extraction date of each data row, allowing for chronological analysis of data changes. If a row has a null end_date, it indicates that the row is the most recent version. This aspect, along with the unique combination of '_start_date' and '_row_number' fields, offers a robust mechanism for version control of the data. This table could be utilized for a range of data analytics applications. For instance, the geospatial data could be used for mapping and spatial analysis of the ELY areas, while the version history could support trend analysis and monitoring of changes over time. Furthermore, the multilingual name fields could support multi-regional studies or applications targeting different language user groups.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the specific row was extracted from the data source, marking the start of the version of the row in the 'table__history'. |
|---|
| _end_date | date | The date when a new version of the row was extracted from the data source, marking the end of the current version. If this column has a null value, it indicates the row is the most recent version. |
|---|
| _row_number | long | The number of the row as per the raw data extracted from the data source. This column, combined with '_start_date', uniquely identifies each row in the history table. |
|---|
| ely | string | A string type column representing the specific code for the ELY center. |
|---|
| geom_geojson | string | Contains the geographical data in the GeoJSON format, describing the shape and the location of the ELY center. |
|---|
| geom_geotext | string | Contains the geographical data in a textual format, describing the shape and the location of the ELY center. |
|---|
| geom_type | string | The type of the geographical data representing the ELY center. It could be either a polygon or a multipolygon. |
|---|
| geom_centroid | string | The geographical point representing the centroid of the geographical shape of the ELY center. |
|---|
| geom_center_x | double | The x-coordinate (longitude) of the center of the geographical shape of the ELY center. |
|---|
| geom_center_y | double | The y-coordinate (latitude) of the center of the geographical shape of the ELY center. |
|---|
| gml_id | string | A string type column representing the unique identifier for the row in the 'tilastointialueet_ely4500k_2023' dataset. |
|---|
| id | long | An integer type column acting as the identifier for the ELY center. |
|---|
| name | string | The name of the ELY center in English. |
|---|
| namn | string | The name of the ELY center in Swedish. |
|---|
| nimi | string | The name of the ELY center in Finnish. |
|---|
| vuosi | long | An integer type column representing the year related to the data of the ELY center. |
|---|
