2022 Version History of Paavo Postal Code Areas Extending to Marine Areas
The 'table__history' is an expansive collection of data, compiled from the Finnish Statistics Bureau (Tilastokeskus), and organized into a structured format for ease of analysis. This table is part of the 'postialue_pno_meri_2022' dataset collection, and serves as a historical record, storing the version history of its base table rows.
The contents of the table are primarily centered around the Paavo postal code areas, extending to marine areas, as of the year 2022. The records in the table are uniquely identified by a combination of the date the row was extracted from the data source ('_start_date') and the row number in the raw data ('_row_number'). This table also includes the '_end_date', marking when a new version of the row was extracted. Thus, allowing tracking of each row's evolution over time. If the '_end_date' is null, it indicates that the row is the most recent version.
The table also contains geospatial data, marked by columns beginning with 'geom_'. These offer a wealth of geographic information, including the type of geographic data, geographic coordinates, and textual and JSON representations of the geographic shapes. This data adheres to the WGS 84 coordinate reference system, and presents coordinates in the order of longitude followed by latitude.
In addition to the geographic data, the table includes columns storing the municipality code ('kunta'), municipality number ('kuntanro'), Finnish and Swedish names of the area ('nimi', 'namn'), and the area's size ('pinta_ala') amongst other details. There's also a field for the year ('vuosi'), which helps to identify the temporal context of the data.
In terms of analytics, this table could be immensely useful. For instance, the geospatial data can be used to perform spatial analyses, such as studying patterns and trends in geographic distribution of the postal code areas. The historical data can be used to track changes in the postal code areas over time, potentially revealing insights into urban development and planning trends. The data on area size can support analyses related to land use and urban density. Furthermore, the municipality information can be used to correlate the data with other demographic or socioeconomic data at the municipality level, providing a rich context for in-depth 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 is part of a unique identifier 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 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. Together with '_start_date', it forms a unique identifier for each row in this version history table. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, which represents the spatial data related to the row. |
| geom_geotext | string | This column holds geometric data in plaintext format, further detailing the spatial attributes of each row. |
| geom_type | string | This column specifies the type of the geometric data contained in the row. |
| geom_centroid | string | This column provides the centroid point of the geometric data associated with each row. |
| geom_center_x | double | This column gives the X-coordinate of the center point of the geometric data. |
| geom_center_y | double | This column gives the Y-coordinate of the center point of the geometric data. |
| gml_id | string | This is a unique identifier for each row, provided by the source. |
| kunta | string | This column contains municipality data related to each row. |
| kuntanro | long | This column holds the municipality number, further identifying each row's regional data. |
| namn | string | This column includes names, potentially of regions or other geographical entities, related to each row. |
| nimi | string | This column also contains names associated with each row, potentially differing from those in the 'namn' column. |
| objectid | long | This is an integer identifier provided by the source for each row. |
| pinta_ala | long | This column contains data on area size, potentially related to the geographic entities associated with each row. |
| posti_alue | string | This column holds postal area data relevant to each row. |
| vuosi | long | This column records the year related to each row's data. |
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 | 16acbe43-1a85-4063-85cf-b672a0c60ba0 |
| Package id | 09e9dc95-4581-4230-b05a-0db73c9a1f51 |
| Position | 1 |
| Revision id | 660c64ae-2de7-4014-9359-9e9dcbc89604 |
| State | active |
| Table | postialue_pno_meri_2022__table__history |