Version History of Postal Area Extensions to Sea Areas (Paavo)
The 'table__history' is a comprehensive data table that represents the version history of the underlying base table rows. This table is part of a larger dataset collection, which is dedicated to providing rich, geospatial information. The data in this table is sourced from 'Tilastokeskus' (Statistics Finland) and is specifically relevant to the postal areas extending to the marine areas.
This table is structured with several columns, each carrying unique information. For instance, it captures the start and end dates indicating when the rows were extracted and when a new version of the row was updated. Unique identifiers for each row in this version history table are formed by the combination of the start date and the row number. If the end date is null, it signifies that the row is the most recent version.
Moreover, there are columns that provide geographic information, which is valuable for geospatial data analytics. These columns contain geographic coordinates, geojson and geotext data, and centroid points. All the geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
Other columns include details about the postal area, municipality, area in square meters, and the year of data. These pieces of information are presented in Finnish and Swedish languages, catering to the bilingual nature of Finland. Also, each row has a unique object ID and a specific GML ID for better data identification.
The information in this table can be valuable for a variety of data analytics tasks. For instance, the geospatial data can be utilized for mapping postal areas, identifying patterns in the data over time due to the version history aspect, or even for analyzing the expansion of postal areas using the area details. The bilingual data can be beneficial for demographic studies or developing bilingual applications. Lastly, the date columns can help track data changes over time, providing insights into how the postal areas have evolved.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column indicates the date when the row was extracted from the data source. This column along with '_row_number' uniquely identifies each row in this version history table. |
| _end_date | date | This column represents the date when a new version of the row was extracted from the data source. If this column's 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. It serves as a unique identifier in combination with the '_start_date'. |
| geom_geojson | string | This column contains geometric data in the GeoJSON format. It provides the geographical outline of an area based on the spatial data. |
| geom_geotext | string | This column holds the geometric data in a text format. It represents the geographic borders of an area in a readable format. |
| geom_type | string | This column specifies the type of the geometric data. For example, it could be a point, line, polygon, etc. |
| geom_centroid | string | This column holds the centroid point of the geometric shape that represents the geographical area of interest. |
| geom_center_x | double | This column contains the X coordinate of the central point of the geometric shape. |
| geom_center_y | double | This column contains the Y coordinate of the central point of the geometric shape. |
| gml_id | string | This column contains a unique identifier for the geographic markup language data. |
| kunta | string | This column represents the municipality code. |
| kuntanro | long | This column contains the number associated with the municipality. |
| namn | string | This column holds the name of the area in the local language. |
| nimi | string | This column contains the name of the area in Finnish. |
| objectid | long | This column holds a unique identifier for each row in the base table. |
| pinta_ala | long | This column represents the area size of the geographical region. |
| posti_alue | string | This column contains the postal code of the area. |
| vuosi | long | This column indicates the year when the data was recorded. |
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 | 43817f15-23c3-4d86-9c65-33fb59c0cd7e |
| Package id | a2951e94-4314-46a3-a292-91044f575ecd |
| Position | 1 |
| Revision id | 9314911d-7511-4865-82db-cb3b6bca7617 |
| State | active |
| Table | postialue_pno_meri__table__history |