Historical Version Data of ELY Areas 2013 - Scaled 1:4,500,000
The 'table__history' is a part of a dataset collection named 'tilastointialueet_ely4500k_2013'. This history table serves as a repository for the version history of its base table rows, tracking changes over time. It contains data detailing the ELY-areas for the year 2013 at a scale of 1:4,500,000. The data is sourced from 'Tilastokeskus' (Statistics Finland), based in Finland.
The table includes various columns which offer a wealth of information about each row's timeline and contents. Unique row identifiers are formed by coupling the extraction date and the row's number from the original dataset. Monitoring when a row was extracted and when a new version of it was introduced is possible through the '_start_date' and '_end_date' columns, respectively. When a row's '_end_date' is null, it indicates that the row is the latest version.
The table also includes geographic information in a set of columns with names beginning with 'geom_'. This data presents geographic coordinates using the WGS 84 coordinate reference system, with the order of the axis being longitude first, followed by latitude. This information can be utilized for geospatial data analytics, for instance, to analyze regional trends and patterns.
The table also contains columns with multi-lingual labels for each ELY-area, along with a unique identification code. These can be used to cross-reference with other regional data for comparative studies or to provide localized insights. For example, data analysts could use this table to compare changes in regional boundaries over time, or to track changes in regional nomenclature across multiple languages. The table thus presents a valuable resource for anyone interested in temporal and regional data analysis.
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 unique identifier for each row in the version history table in combination with the '_row_number' column. |
| _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 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. It forms a unique identifier for each row in the version history table in combination with the '_start_date' column. |
| ely | string | This column contains a string type value, likely representing a certain classification or code within the data. |
| geom_geojson | string | This column contains GeoJSON representations of multi-polygonal geographic shapes. |
| geom_geotext | string | This column contains text representations of multi-polygonal geographic shapes. |
| geom_type | string | This column specifies the type of the geographic shape represented in 'geom_geojson' and 'geom_geotext' columns. The type is 'ST_MULTIPOLYGON' indicating multi-polygonal shapes. |
| geom_centroid | string | This column contains the geographic coordinates of the centroid point of the multi-polygonal shapes. |
| geom_center_x | double | This column contains the x-coordinate of the center point of the multi-polygonal shapes. |
| geom_center_y | double | This column contains the y-coordinate of the center point of the multi-polygonal shapes. |
| gid | long | This column contains an integer value, likely a unique identifier or a classification code within the data. |
| gml_id | string | This column contains a unique string identifier for each row in the data. |
| name | string | This column contains the English names of the geographic areas represented by the multi-polygonal shapes. |
| namn | string | This column contains the local names of the geographic areas represented by the multi-polygonal shapes. |
| nimi | string | This column contains another form of local names for the geographic areas represented by the multi-polygonal shapes. |
| vuosi | long | This column contains an integer value representing a year, probably the year when the data were collected. |
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 | baf0f17d-7924-4b9b-9372-fe140509782d |
| Package id | f3d85c25-a231-4392-a586-dfcebb32b1ad |
| Position | 1 |
| Revision id | eb9791f5-b240-49b4-819f-d6657eefc8f4 |
| State | active |
| Table | tilastointialueet_ely4500k_2013__table__history |