Version History of Postal Code Areas (Paavo)
The 'table__history' is a history table that contains the version history of its base table rows. This particular table belongs to a dataset collection named 'postialue_pno'. The data in the table represents the postal area data from Finland as sourced from the Statistics Finland (Tilastokeskus) website. The table contains a wealth of information including geographic information and postal area details. This collection of data is highly structured and organized, allowing users to perform detailed data analytics.
The table contains several columns, each providing unique information. For instance, there are columns that contain the start and end date of the data extraction. These columns, combined with the row number, provide a unique identifier for each row in the table. If the end date is null, it indicates that the row is the most current version.
Another set of columns contain geographic coordinates and information. These columns begin with 'geom_' and the data can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table also includes information about the postal area such as the name, area size, and the year. This information could be particularly useful for demographic studies, urban planning, or research into population trends. For instance, a data analyst could use this information to track the expansion of postal areas over time or to study the geographic distribution of postal areas in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source, providing a timestamp for the start of the row's version history. |
| _end_date | date | This column 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 | Holds the number of the row in the raw data extracted from the data source. Together with '_start_date', this column uniquely identifies each row in the version history. |
| geom_geojson | string | Contains geospatial data in GeoJSON format. This could represent various geographic structures such as polygons and multipolygons. |
| geom_geotext | string | This column stores the geospatial data in a text format, representing various geographic structures such as polygons and multipolygons. |
| geom_type | string | Identifies the type of the geospatial data stored in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | Contains the centroid point of the geographic structure, represented as a point in the geospatial data. |
| geom_center_x | double | The X-coordinate of the center point of the geographic structure. |
| geom_center_y | double | The Y-coordinate of the center point of the geographic structure. |
| gml_id | string | A unique identifier for each row in the table. |
| kunta | string | Contains the municipality code in Finland where the geographical structure is located. |
| kuntanro | long | Contains the municipality number in Finland where the geographical structure is located. |
| namn | string | Name of the geographical structure in Swedish. |
| nimi | string | Name of the geographical structure in Finnish. |
| objectid | long | An integer identifier for each row in the table. |
| pinta_ala | long | The area of the geographical structure in square meters. |
| posti_alue | string | The postal code area where the geographical structure is located. |
| vuosi | long | The year related to the data row. |
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 | efe7fca1-7b60-4c35-b297-0d46bb27d093 |
| Package id | 2a584650-9961-44ac-877c-b02220cd23f2 |
| Position | 1 |
| Revision id | d5472b70-a94e-4d40-852f-e489265198b1 |
| State | active |
| Table | postialue_pno__table__history |