Version History of Paavo Postal Code Areas (Extended to Maritime Areas) for 2024
The 'table__history' is a part of a larger dataset collection, which is a historical record capturing changes in specific data over time. The table's data is primarily related to geographic areas extending to sea regions for the year 2024, sourced from the 'Statistics Finland' (Tilastokeskus) website.
The table consists of various columns that carry unique information. For instance, certain columns carry geospatial data, which can be used for geospatial data analytics. These columns contain geographic coordinates presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The content of the table is unique due to its version history tracking. It contains two special columns, '_start_date' and '_end_date', that denote when a row was extracted from the data source and when a new version of the row was extracted, respectively. This allows for a historical overview of changes to the data. A row is considered the most recent version if the '_end_date' column is null. These features make this table particularly valuable for longitudinal data analysis.
To give a sense of the data in the table, some columns contain information about the area name in two languages, area code, and year, while others store data about the area's size and postal code. Additionally, each row is uniquely identified by a combination of '_start_date' and '_row_number'.
In terms of data analytics, the table's content could be used for several purposes. For example, the geospatial data can be used to map changes in geographical areas over time or analyze geographic trends. The version history can be utilized for tracking changes and identifying trends in the data. Moreover, the data related to area size and postal codes could be useful in regional planning or demographic studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column indicates the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in this version history table. |
| _end_date | date | This column records 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 number of the row in the raw data extracted from the source. Combined with '_start_date', it uniquely identifies each row in this version history table. |
| geom_geojson | string | This column holds the geometric data of the area in GeoJSON format, a popular open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column stores the geometric data of the area in a text format. |
| geom_type | string | This column specifies the type of geometric data stored in the respective row, such as 'ST_POLYGON'. |
| geom_centroid | string | This column contains the centroid point of the geometric data, essentially marking the center point of the area. |
| geom_center_x | double | This column represents the X coordinate of the center point of the area. |
| geom_center_y | double | This column represents the Y coordinate of the center point of the area. |
| gml_id | string | This column contains a unique identifier for each row in the data set. |
| kunta | string | This column holds the municipality code where the area is located. |
| kuntanro | long | This column contains the municipality number, a unique identifier for each municipality. |
| namn | string | This column stores the name of the area in the local language. |
| nimi | string | This column contains the name of the area. |
| objectid | long | This column holds a unique identifier for each row in the data set. |
| pinta_ala | long | This column represents the surface area of the region in square meters. |
| posti_alue | string | This column contains the postal code of the area. |
| vuosi | long | This column indicates the year when the data was 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 | b77caae9-388b-4129-8aad-102671a67fc3 |
| Package id | 95f1f390-b703-4077-8d44-3d073ea06da4 |
| Position | 1 |
| Revision id | 084c67d6-e98e-44e7-938c-5af2029fa685 |
| State | active |
| Table | postialue_pno_meri_2024__table__history |