Version History of ELY Areas 2020 (1:1 000 000) Records
Click here for a data sample
The history table provides detailed records of the version history of the ELY areas 2020 (1:1 000 000) data. The history table is a part of the 'tilastointialueet_ely1000k_2020' dataset, which is sourced from the 'Tilastokeskus' (Statistics Finland) website. This table contains specific columns that track the data extraction process and the temporal aspects of the data. Certain columns indicate the start and end dates of data extraction, and if the end date is null, it signifies that the particular row is the most recent version. Additionally, each row in this table is uniquely identified by a combination of the row number and the start date. The table also includes several geographical columns, containing data that can be used for geospatial analytics. This includes information like geographical coordinates, presented in the WGS 84 coordinate reference system, with longitude appearing before latitude. The data in this table can be utilized in various ways, such as tracking changes over time in the ELY areas, conducting geospatial analysis, or studying the distribution and evolution of specific features within the ELY areas.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a combination with '_row_number' that uniquely identifies each row in this version history table. |
|---|
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. A null value indicates that the row is the most recent version. |
|---|
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. In combination with '_start_date', it uniquely identifies each row in this version history table. |
|---|
| ely | string | A string type column which represents a certain ELY center. |
|---|
| geom_geojson | string | This column contains geometrical data in the format of GeoJSON, which includes information about the shape and area of the geographical region. |
|---|
| geom_geotext | string | This column contains geometrical data in textual format, providing information about the shape and area of the geographical region. |
|---|
| geom_type | string | This column states the type of the geometric data stored in the row. |
|---|
| geom_centroid | string | This column contains the point that represents the center of the geometric shape of the region. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric shape of the region. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric shape of the region. |
|---|
| gml_id | string | A string type column which contains a unique identifier for each row. |
|---|
| id | long | An integer type column which provides a unique identification number for each row. |
|---|
| name | string | A string type column which contains the English name of the ELY center. |
|---|
| namn | string | This column contains the name of the ELY center in Swedish. |
|---|
| nimi | string | This column contains the name of the ELY center in Finnish. |
|---|
| vuosi | long | An integer type column that specifies the year the data was gathered. |
|---|
