Version History of ELY Areas (1:1 000 000)
The 'table__history' is a rich data table that maintains the version history of its base table rows. It forms part of the 'tilastointialueet_ely1000k' dataset collection and contains information about the ELY-areas, or 'Centre for Economic Development, Transport and the Environment' areas on a 1:1 000 000 scale, a concept relevant in Finland. The data is sourced from the 'Statistics Finland' (Tilastokeskus) website.
The table is equipped with special columns to track the history of each row, with columns capturing the start and end dates for each row version. If the end date column is null, this indicates that the version is the most recent. Each row is uniquely identified by a combination of the start date and row number.
The table also contains a range of geographical data, including geographic coordinates, which are presented using the WGS 84 coordinate reference system. This includes the longitude first, followed by the latitude. Geographic data includes the centroid and center coordinates of each ELY area, and the geographic shape of the area in multiple formats.
Additionally, the table includes comprehensive identifiers and names for each ELY area in multiple languages, including Finnish, Swedish and English, along with the year of the data.
The data in this table could be utilized in a variety of data analytics applications. For example, it could be used to track changes in ELY areas over time. It could also be used to analyze the geographical distribution of ELY areas. The multilingual data could also be useful in creating multilingual maps or applications.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column holds the date when the row was extracted from the data source. It forms a unique identifier combination with the '_row_number' column for each row in this history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it signifies 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 identifier with the '_start_date' column for each row in this history table. |
| ely | string | This string type column holds the identifier for the Centre for Economic Development, Transport and the Environment in Finland. |
| geom_geojson | string | This column contains the geographical information in GeoJSON format, describing the geometry of the regions. |
| geom_geotext | string | This column holds the geographical information in WKT (Well-known text) format, describing the geometry of the regions. |
| geom_type | string | This column specifies the type of the geometry of the regions. It can be either 'ST_MULTIPOLYGON' or 'ST_POLYGON'. |
| geom_centroid | string | This column contains the geographical point that represents the centroid (geometric center) of the regions. |
| geom_center_x | double | This column holds the x-coordinate (longitude) of the geometric center of the regions. |
| geom_center_y | double | This column holds the y-coordinate (latitude) of the geometric center of the regions. |
| gml_id | string | This string type column contains the unique identifier for the geographical markup language data. |
| id | long | This integer type column holds the unique identifier for each row. |
| name | string | This string type column contains the English name of the Centre for Economic Development, Transport and the Environment. |
| namn | string | This column contains the Swedish name of the Centre for Economic Development, Transport and the Environment. |
| nimi | string | This column holds the Finnish name of the Centre for Economic Development, Transport and the Environment. |
| vuosi | long | This integer type column holds the year related to the data row. |
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 | 3e06572b-5de4-4bad-b5c0-1f7dfe8ab5ba |
| Package id | 1b043ec5-a599-41de-b4d1-f7e8a3d4ba13 |
| Position | 1 |
| Revision id | 51272d19-3d60-4322-adef-28eebfd7bdf8 |
| State | active |
| Table | tilastointialueet_ely1000k__table__history |