Version History of Paavo Postal Code Areas 2017
The history table is a unique data collection that captures the version history of its base table rows, which belong to the dataset collection pertaining to the Finnish Postal Codes of 2017. This table, sourced from 'Tilastokeskus' (The Statistical Bureau) in Finland, contains valuable data that can be used for various analytical purposes.
The table includes information about the start and end dates of when the row was extracted from the data source. These date columns, together with the row number, create a unique identifier for each row's version history. For example, if the end date value is null, it indicates that the row is the most recent version. This feature makes the table ideal for tracking changes over time, which can be utilized in trend analysis.
One of the significant aspects of this table is its geospatial data. The 'geom_' prefix columns contain geographic information, such as geotext and geojson data, centroid coordinates, and center coordinates. This data is presented using the WGS 84 coordinate reference system, with longitude first, followed by latitude. This can be used in geospatial analytics to visualize and analyze geographical data trends and patterns.
Furthermore, the table provides information on various attributes like the area's name in different languages, the area's postal code, the year, and the object's ID. It also contains data about the area's municipality and the municipality number. This information can be used in demographic studies, regional planning, and marketing segmentation.
In essence, this history table is a rich source of time-series and geospatial data that can be utilized in various data analytics applications, such as trend analysis, demographic studies, geospatial analytics, and regional planning.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column records the date when each row was extracted from the data source, serving as an important part of the unique identifier for each row in the history table. |
| _end_date | date | This column indicates the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the current row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the source. Together with '_start_date', it forms a unique identifier for each row in this history table. |
| geom_geojson | string | This column contains the geographical coordinates of the area in GeoJSON format, a popular format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column holds the geographical coordinates of the area in text format. |
| geom_type | string | This column specifies the type of the geometry data stored in the column, typically a type of shape like 'ST_MULTIPOLYGON' for multiple polygons. |
| geom_centroid | string | This column contains the coordinates of the centroid, or geometric center, of the area. |
| geom_center_x | double | This column records the x-coordinate of the center of the geographical area. |
| geom_center_y | double | This column records the y-coordinate of the center of the geographical area. |
| gml_id | string | This column contains a unique string identifier for each row. |
| kunta | string | This column holds a code representing the municipality where the area is located. |
| kuntanro | double | This column contains numerical identifiers for the municipality. |
| namn | string | This column stores the name of the area. |
| nimi | string | This column holds the name of the area. |
| objectid | double | This is a unique real number identifier for each row. |
| pinta_ala | double | This column contains the area size of the geographical area in square meters. |
| posti_alue | string | This column holds the postal code of the area. |
| vuosi | double | This column records the year associated with the 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 | 5b777865-c089-41bc-98c4-386f67190155 |
| Package id | d730a34a-7383-42f7-bc96-84ff3c8aa08d |
| Position | 1 |
| Revision id | 8bb258b2-d6d8-47b8-a366-88b940d1c588 |
| State | active |
| Table | postialue_pno_2017__table__history |