Version History of Extended Marine Area Postal Code Regions 2023
The 'table__history' is a rich dataset, part of a larger collection known as 'postialue_pno_meri_2023', sourced from the 'Statistics Finland' ('Tilastokeskus') website. It stores an extensive range of data related to Finnish postal areas extending to maritime areas for the year 2023, presenting data in a structured format with each row signifying a unique data entry.
The table holds the version history of its base table rows, enabling the tracking of changes over time. Each row in the table is distinctly identified by a combination of its '_start_date' and '_row_number'. The '_start_date' indicates the date when the row data was originally extracted, while the '_end_date' signifies when a new version of the same row was extracted. If the '_end_date' is null, this signifies the most recent version of that row.
Among the varied data that the table holds, key information includes geographic data, reflected in columns starting with 'geom_', which are essential for geospatial data analytics. These include details such as the type of geographic data, geographic coordinates, and center points. All geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
In addition to the geographic data, the table includes details such as the postal area code, the area's name in both local language and Swedish, the municipality code, and the size of the area. A unique identifier for each row, 'gml_id', is also provided.
In terms of data analytics, this table offers a wide array of possibilities. For instance, the geographic data from the 'geom_' columns can be leveraged to perform geospatial analysis, which can help in identifying patterns or trends based on location. Furthermore, tracking changes in postal area data over time can help in understanding the evolution of these areas. This could be beneficial for various sectors, such as logistics for route optimization or real estate for identifying emerging development areas.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. This column, in combination with '_row_number', forms a unique identifier for each row in this version history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value of this column 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, and forms a unique identifier for each row when combined with '_start_date'. |
| geom_geojson | string | Contains the geographical data of the area in GeoJSON format. |
| geom_geotext | string | Geospatial data represented in text format. |
| geom_type | string | Specifies the type of the geographical representation. For example, 'ST_POLYGON' refers to a polygon spatial object. |
| geom_centroid | string | Contains the centroid point of the geographical area. |
| geom_center_x | double | The X-coordinate of the center of the geographical area. |
| geom_center_y | double | The Y-coordinate of the center of the geographical area. |
| gml_id | string | Unique identifier for the geographical data. |
| kunta | string | Municipality code for the geographical area. |
| kuntanro | long | Municipality number, similar to 'kunta'. |
| namn | string | The name of the area in Swedish language. |
| nimi | string | The name of the area in Finnish language. |
| objectid | long | An integer that serves as a unique identifier for each object. |
| pinta_ala | long | Area of the geographical entity in square meters. |
| posti_alue | string | Postal code of the area. |
| vuosi | long | Year of the data, indicating when the data was collected or reported. |
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 | e1bf01a0-3aef-4b4a-b1d7-48168602b16c |
| Package id | 1b3bb696-e510-4bc9-af00-5822f5a559e1 |
| Position | 1 |
| Revision id | b3808589-00b1-4881-9da7-9c61a27df849 |
| State | active |
| Table | postialue_pno_meri_2023__table__history |