Version History of Paavo Postal Code Areas (Extending to Sea Areas) 2016
The 'table__history' is a comprehensive collection of historic data that keeps track of the changes over time. This history table belongs to the 'postialue_pno_meri_2016' dataset and is vital for data analysis as it allows tracking of changes and trends over time. It contains geographic information that can be utilized for geospatial data analytics, presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
The table reflects the version history of the base table rows, containing unique identifiers for each row, formed by a combination of the start date and the row number. Each row of data is marked with a start date, indicating when the row was extracted from the data source. The end date, on the other hand, signifies when a new version of the row was extracted. A null end date indicates that the row is the most recent version.
Geographic information is stored in the 'geom_' prefixed columns, which can be utilized for geospatial data analytics. These columns include data such as centroid coordinates and geographic shapes, in both text and geoJSON formats.
The table also includes other important data columns like municipality codes and names, surface area, postal area, and year. This data is sourced from 'Tilastokeskus' (Statistics Finland), a reliable source from Finland.
The data in this history table could be used in a variety of data analytical scenarios. For example, it could be used to analyze geographical changes over time, such as alterations in surface areas or changes in postal areas. It could also be used to trace the history of specific areas based on municipality codes and names. Furthermore, the geospatial data could be used to create interactive, time-lapse maps that visualize changes over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column records the date when the row was extracted from the data source, helping to track the version history of the base table rows. For example, a date could be '2024-11-11'. |
| _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 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. It forms a unique identifier for each row in combination with the '_start_date' column. |
| geom_geojson | string | This column contains the geographical information in GeoJSON format. It represents the geographical features of the area. |
| geom_geotext | string | This column holds geometric data as text, which represents the geographical features of the area. |
| geom_type | string | This column specifies the type of geometric data present in the row. It could, for example, be 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid of the area. |
| geom_center_x | double | This column includes the x-coordinate of the geographical center of the area. |
| geom_center_y | double | This column includes the y-coordinate of the geographical center of the area. |
| gml_id | string | This column contains a unique identifier for each row, as provided by the source. |
| kunta | string | This column holds the identifier for the municipality which the row represents. |
| kuntanro | long | This column includes a numerical identifier for the municipality. |
| namn | string | This column contains the name of the area, possibly in a local language. |
| nimi | string | This column holds the name of the area, possibly in another local language. |
| pinta_ala | double | This column provides the area of the region in square meters. |
| posti_alue | string | This column includes the postal code of the area. |
| shape_star | double | This column represents the area of the shape of the geographical entity. |
| shape_stle | double | This column indicates the perimeter of the shape of the geographical entity. |
| vuosi | long | This column records the year the data was collected, for instance, '2016'. |
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 | 6f960868-4a33-4465-b9ca-1106859d24df |
| Package id | 7afa86a9-0386-4b8c-834f-56d21b8c952b |
| Position | 1 |
| Revision id | 42392125-598e-4d62-9892-6bfddead1a16 |
| State | active |
| Table | postialue_pno_meri_2016__table__history |