Version History of Major Areas 2015 (1:1 000 000)
The table under consideration is a historical record, which is a part of a larger dataset. It encompasses various geographical and temporal aspects, tracking the evolution of its base data over a period of time. The data in the table is sourced from 'Tilastokeskus' (Statistic Centre), based in Finland. The table primarily contains data about major regions in Finland as of 2015, specifically captured at a scale of 1:1,000,000.
The table is structured with a series of columns, each serving a unique purpose. For instance, some columns represent geographical data that can be used for geospatial data analytics. These include details such as geographical shapes, centroids, and center points, all represented in the WGS 84 coordinate reference system, with longitude presented before latitude.
The table also contains columns that provide an indicator for the version history of the base table rows. These columns indicate the date of data extraction and the date of new version extraction, providing a unique identifier for each row in combination with the row number. If the 'end date' for a particular row is null, it signifies that the row is the latest version.
Additionally, each row has a unique number, and there are columns providing names of the regions in different languages, which could be useful in multilingual data analysis or localization efforts. There are also columns that indicate the year of the data and the area, represented in square meters and meters respectively.
Given the nature of the data, it could be utilized in various forms of data analytics. One could use the geospatial data for geographical analysis, such as identifying patterns or trends in regional characteristics over time. The historical data could be used to track changes and predict future trends. Lastly, the multilingual data could be leveraged for linguistic or cultural studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column represents the date when the row was extracted from the data source. This, in conjunction with '_row_number', uniquely identifies each row in the history table. |
| _end_date | date | This contains the date when a new version of the 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 | The '_row_number' column contains the number of the row in the raw data extracted from the data source. It is part of the unique identifier for each row, along with '_start_date'. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, a common format for encoding a variety of geographic data structures. |
| geom_geotext | string | The 'geom_geotext' column contains geometric data in text format. |
| geom_type | string | This column specifies the type of geometric data contained in the row. In our case, it is 'ST_MULTIPOLYGON', indicating the data represents multiple polygons. |
| geom_centroid | string | This column contains the centroid, or the geometric center, of the polygon represented in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_x | double | The 'geom_center_x' column represents the x-coordinate of the geometric center of the polygon. |
| geom_center_y | double | This column represents the y-coordinate of the geometric center of the polygon. |
| gml_id | string | This is an identifier for each row, which appears to incorporate the dataset name and an individual identifier for each area. |
| name | string | The 'name' column contains the English name of the area represented by the row. |
| namn | string | This column contains the name of the area in another language, possibly Swedish given the country of origin of the data. |
| nimi | string | The 'nimi' column contains the name of the area in another language, likely Finnish, considering the data source's location. |
| shape_star | double | This column contains a numeric value related to the shape of the area. The exact nature of this value is unclear without further context. |
| shape_stle | double | Like 'shape_star', this column contains a numeric value related to the shape of the area. The exact meaning is unclear without additional information. |
| suuralue | string | The 'suuralue' column seems to be a categorical variable, possibly indicating a larger administrative area that each row belongs to. |
| vuosi | double | The 'vuosi' column contains the year associated with the data in each row, likely indicating the year the data was collected or is relevant for. |
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 | 81ee25d0-91bb-498a-b86f-02af447b72d3 |
| Package id | 92b8690f-da63-4344-93c6-07eb76406cb5 |
| Position | 1 |
| Revision id | f7562260-f4a4-4219-b92f-f33f0f44fcc6 |
| State | active |
| Table | tilastointialueet_suuralue1000k_2015__table__history |