Version History of Postal Code Areas 2023
The 'table__history' is part of the 'postialue_pno_2023' dataset collection. As a history table, it maintains the version history of its base table rows. This table was sourced from the website of the Statistics Finland, or 'Tilastokeskus', from Finland.
The table contains unique data records representing the 'Paavo postal code areas 2023'. It contains a variety of data fields, including geographic, demographic, and administrative data.
The geographic information is presented using the WGS 84 coordinate reference system, with the order of longitude first, followed by latitude. These coordinates are contained in columns beginning with 'geom_', and can be used for geospatial data analytics, such as visualizing the postal code areas on a map or analyzing spatial patterns and trends.
The table also includes administrative data such as the postal area code, the municipality number and the names of the areas in both Finnish and Swedish. These can be used to link the table data with other datasets for further analysis.
In addition, the table contains a unique row number and timestamps for when the row was first extracted and when a new version was extracted. This versioning information allows tracking changes over time and can be used in trend analysis or data auditing. For example, if the '_end_date' is null, it indicates that the row is the most recent version.
Finally, the table features demographic information about the area, such as the number of inhabitants and the surface area. This data could be used in a variety of analytics applications, including population density studies, urban planning, and socioeconomic research.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This represents the date when the data row was extracted from the source. This, in conjunction with '_row_number', uniquely identifies each row in the history table. |
| _end_date | date | This represents the date when a new version of the data row was extracted. If this is null, it indicates that the current row is the most recent version. |
| _row_number | long | This indicates the row number in the raw data extracted from the source. This, in conjunction with '_start_date', uniquely identifies each row in the history table. |
| geom_geojson | string | This contains the geographical data in GeoJSON format, a common format for encoding a variety of geographic data structures. |
| geom_geotext | string | This contains the geographical data in text format. The data can be in different formats such as POLYGON or MULTIPOLYGON. |
| geom_type | string | This indicates the type of the geographical data contained in 'geom_geojson' and 'geom_geotext'. Examples include 'ST_POLYGON' and 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This represents the center point of the geographical area described in 'geom_geojson' and 'geom_geotext'. |
| geom_center_x | double | This indicates the X-coordinate of the center point of the geographical area. |
| geom_center_y | double | This indicates the Y-coordinate of the center point of the geographical area. |
| gml_id | string | This is a unique identifier for each row of the dataset. |
| kunta | string | This field contains the municipality code. |
| kuntanro | long | This field also contains the municipality code, similar to the 'kunta' field. |
| namn | string | This is the Swedish name of the area described in the row. |
| nimi | string | This is the Finnish name of the area described in the row. |
| objectid | long | This is a unique identifier for each object in the dataset. |
| pinta_ala | long | This represents the surface area of the geographical location. |
| posti_alue | string | This field contains the postal code of the area. |
| vuosi | long | This indicates the year related to the data row. In this case, it's 2023. |
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 | 784e80de-8fb0-43ec-bd60-94013d00a9c2 |
| Package id | 27dbf2e7-142a-4758-98ed-9236e158e721 |
| Position | 1 |
| Revision id | fac80f98-1e40-436c-8dca-339f95349c14 |
| State | active |
| Table | postialue_pno_2023__table__history |