ELY Areas 2021 Version History (1:4 500 000)
The 'table__history' is a rich data repository capturing the version history of its core data rows. It's a key component of the comprehensive dataset 'tilastointialueet_ely4500k_2021'. The table contains crucial information about ELY-areas, essentially Economic Development, Transport and the Environment Centres in Finland, as of 2021, at a scale of 1:4,500,000.
The data table encompasses several columns that track a variety of information. One of the key columns is '_row_number', which notes the row's position in the raw data extracted from the source. To uniquely identify each row in this version history table, a combination of '_start_date' and '_row_number' is used. The '_start_date' indicates the extraction date of the row from the source, while the '_end_date' signifies the date when a fresh version of the row was extracted. If '_end_date' is null, it implies that the row is the latest version.
Moreover, the table hosts several columns starting with 'geom_', providing geographic data useful for geospatial analytics. These columns house geographic coordinates using the WGS 84 coordinate reference system, where the axis order begins with longitude, followed by latitude.
The table also includes other columns that store additional information, such as the name of the ELY Centre in different languages and the year to which the data pertains. The table is sourced from the 'Tilastokeskus' (Statistics Finland) website, affirming the authenticity and reliability of the data.
The 'table__history' has a wide range of applications in data analytics. For instance, it can provide valuable insights for urban planning, environmental impact assessments, and transportation infrastructure development. It could also be used to analyze the temporal changes in the ELY areas over the years, enabling policymakers to understand trends and make data-driven decisions. Furthermore, the geospatial data could be utilized to perform geographic information system (GIS) analyses, helping in the visualization and spatial querying of the ELY areas.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column represents the date on which a particular row was extracted from the data source. It forms part of a unique identifier for each row in this version history table, the other part being '_row_number'. |
| _end_date | date | This column contains the date when a new version of a row was extracted from the data source. If the column's value is null, it 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. Together with '_start_date', it forms a unique identifier for each row in the version history table. |
| ely | string | This is a string type column in the base table that has no English description provided by the source. |
| geom_geojson | string | This column contains the geometric data of the region in GeoJSON format. |
| geom_geotext | string | This column contains the geometric data of the region in a textual format. |
| geom_type | string | This column represents the type of geometric data stored, such as 'ST_MULTIPOLYGON' or 'ST_POLYGON'. |
| geom_centroid | string | This column contains the centroid point of the geometric data of the region. |
| geom_center_x | double | This column represents the x-coordinate of the center point of the geometric data. |
| geom_center_y | double | This column represents the y-coordinate of the center point of the geometric data. |
| gml_id | string | This is a string type column in the base table with no English description provided by the source. |
| id | long | This is an integer type column in the base table with no English description provided by the source. |
| name | string | This is a string type column in the base table with no English description provided by the source. |
| namn | string | This is a string type column in the base table with no English description provided by the source. |
| nimi | string | This is a string type column in the base table with no English description provided by the source. |
| vuosi | long | This is an integer type column in the base table that has no English description provided by the source. |
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 | 5ef3b5c7-ad44-4046-8081-889d6bfed053 |
| Package id | b2856a12-0623-481e-a7f1-7cb45c0acb22 |
| Position | 1 |
| Revision id | b18bd00a-df02-492a-82c4-2cc60ef4eaf0 |
| State | active |
| Table | tilastointialueet_ely4500k_2021__table__history |