ELY Areas 2022 (1:4 500 000) - History Version
The 'table__history' is a history table that maintains the version history of its base table rows. It belongs to a collection of related tables named 'tilastointialueet_ely4500k_2022'. This table contains additional columns, '_start_date' and '_end_date', compared to its base table, to track the version history. These columns store the date when the row was extracted from the data source and when a new version of the row was extracted, respectively. A null value in the '_end_date' column indicates that the row is the most recent version. Also, the '_row_number' column contains the number of the row in the raw data, and the combination of '_start_date' and '_row_number' uniquely identifies each row in this table.
The content of the base table is about ELY areas in 2022 at a 1:4 500 000 scale. The table includes columns like 'ely', 'name', 'namn', 'nimi', and 'vuosi' that hold information like the ELY area code, and its name in different languages. 'id' column holds the unique identifier for each ELY area.
The columns with names starting with 'geom_' contain geographic information. For example, 'geom_centroid' contains the coordinates of the geometric center of the ELY area, while 'geom_geojson' and 'geom_geotext' contain the geographic representation of the ELY area in GeoJSON and text format respectively. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
This table is sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The data in this table can be used for various data analytics purposes. For example, geospatial data analytics can be performed using the geographic information to analyze the distribution of ELY areas. Moreover, the version history can be used to track the changes in ELY areas over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when a certain row was extracted from the data source. It's a part of a unique identifier for each row in the history table. |
| _end_date | date | This column holds the date when a new version of a row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
| _row_number | long | This column contains the row number from the raw data extracted from the data source. It forms a unique combination with the '_start_date' to identify each row in the version history. |
| ely | string | This string column contains unique codes associated with the ELY Centers in Finland. |
| geom_geojson | string | This column contains the geographical data in GeoJSON format. It represents the geographical boundaries associated with the ELY Centers. |
| geom_geotext | string | This column holds the geographical data in geotext format. Similar to 'geom_geojson', it contains the geographical boundaries of the ELY Centers. |
| geom_type | string | This string column describes the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. In this case, the data type is 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column contains the centroid points of the geographical areas associated with the ELY Centers. |
| geom_center_x | double | This column contains the x-coordinate of the center point of the geographical area related to the ELY Centers. |
| geom_center_y | double | This column contains the y-coordinate of the center point of the geographical area related to the ELY Centers. |
| gml_id | string | This string column contains unique identifiers for each row. |
| id | long | This integer column contains identifiers for each row. |
| name | string | This string column contains the English names of the ELY Centers in Finland. |
| namn | string | This column contains the names of the ELY Centers in Swedish. |
| nimi | string | This column contains the names of the ELY Centers in Finnish. |
| vuosi | long | This integer column contains the year of the data. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | c0232970-43c0-44d2-b306-2e579320679c |
| Package id | 066acae1-f7d0-4488-ad9b-68f8bbdc3d71 |
| Position | 1 |
| Revision id | 78c7f666-2a40-49d0-94a5-5527c5bedcae |
| State | active |
| Table | tilastointialueet_ely4500k_2022__table__history |