ELY Areas 2016 Version History (1:1 000 000)
The 'table__history' contains a comprehensive record of ELY (Centre for Economic Development, Transport and the Environment) areas in Finland, as recorded in 2016. The data in this history table represents the version history of its base table rows, providing a detailed snapshot of changes over time. Each row in the table is uniquely identified by the combination of '_start_date' and '_row_number', offering precise tracking of data extraction and subsequent updates.
The table includes geographic data, such as geometry in geojson and geotext formats, the type of geometry, the centroid of the geometry, and the x and y coordinates of the center. This geographic information, presented using the WGS 84 coordinate reference system, is valuable for geospatial data analytics, enabling users to visualize and understand geographic distributions and patterns.
In addition to geographical data, the table includes unique identifiers for each ELY area ('gid', 'gml_id'), and their names in three languages: English ('name'), Finnish ('nimi'), and Swedish ('namn'). The column 'vuosi' indicates the year the data was collected.
The table also records the date a row was extracted from the data source ('_start_date') and the date when a new version of the row was extracted ('_end_date'). If the '_end_date' value is null, this indicates that the row is the most recent version.
The wealth of data in the 'table__history' allows for a variety of data analytics applications. For example, the table could be used to track changes in ELY area boundaries over time, analyze spatial patterns in economic development, or identify correlations between geographical characteristics and transport infrastructure. Furthermore, multilingual naming allows for multicultural research and cross-referencing with other language-specific datasets.
The 'table__history' is sourced from the 'Tilastokeskus' website, the Statistics Bureau in Finland, ensuring reliable and accurate data for analytics.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column records the date when the row was extracted from the data source. It is part of 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. If the value of this column is null, it signifies that the row is the most recent version. |
| _row_number | long | This column represents the number of the row in the raw data extracted from the data source. It forms a unique identifier in combination with '_start_date' for each row in this version history table. |
| ely | string | This is a string-type column in the base table, representing a particular category or attribute in the dataset. |
| geom_geojson | string | This column contains geometric data of the entity in GeoJSON format, a popular open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column contains geometric data in a textual format. This can be used for spatial queries and analysis. |
| geom_type | string | This column specifies the type of the geometry stored in the 'geom_geojson' and 'geom_geotext' columns. It can help in understanding the nature of the spatial data. |
| geom_centroid | string | This column stores the geometric center or 'centroid' of the entity. This can be useful in spatial analysis. |
| geom_center_x | double | This column represents the X-coordinate of the geometric center of the entity, providing a spatial reference. |
| geom_center_y | double | This column represents the Y-coordinate of the geometric center of the entity, providing a spatial reference. |
| gid | long | This is an integer-type column in the base table, which may be used as an identifier or a key in the dataset. |
| gml_id | string | This is a string-type column in the base table. It could be an identifier or a key for the rows in the table. |
| name | string | This is a string-type column in the base table. It may contain names of entities or attributes relevant to the dataset. |
| namn | string | This is a string-type column in the base table, possibly containing names or labels in a different language. |
| nimi | string | This is a string-type column in the base table, possibly containing names or labels in a different language. |
| vuosi | double | This is a real number-type column in the base table, which could be used for storing various numerical data, such as year in this context. |
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 | fec21602-b434-4922-8598-62ee3272b7ec |
| Package id | 23d9a335-77a5-4a56-813e-1f0ca46a560c |
| Position | 1 |
| Revision id | 03049bcc-62c2-4035-ae71-1b0930ff7c67 |
| State | active |
| Table | tilastointialueet_ely1000k_2016__table__history |