2016 Postal Code Areas - Dataset Table
The table is part of a dataset collection that delves into the postal areas of 2016, as provided by the Finnish Statistical Bureau (Tilastokeskus). The table encompasses a wide range of data, including intricate geographic information that can be leveraged for geospatial data analytics. This geographic data, represented under columns beginning with 'geom_', uses the WGS 84 coordinate reference system, with longitude listed before latitude.
The table also contains unique identifiers for each postal area, as well as associated region names, both in Finnish and in other local languages. It offers insight into the surface area of each postal region, allowing for spatial distribution analysis. Additionally, data pertaining to the year of record is also included.
Two unique columns in the table, '_extract_date' and '_row_number', serve a special purpose. The '_extract_date' column specifies the date the data for a particular row was sourced, while the '_row_number' column provides the row number for the data extracted on the specified date. The combination of these two columns uniquely identifies each row, ensuring data integrity.
This table's data could be used in various analytics scenarios. For instance, the geographic information could be used in spatial analysis or mapping applications to visualize postal areas. The data could also be used to analyze population distribution across different regions, provided that additional demographic data is available. Furthermore, the data could be utilized to track changes in region names or postal area boundaries over time, lending itself to historic or sociocultural studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column holds the date when the data on the row was extracted from the database. It is a special column that helps identify each row uniquely in combination with the _row_number. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the _extract_date column. It is a special column that, in combination with _extract_date, provides a unique identifier for each row. |
| geom_geojson | string | This column contains geospatial data in GeoJSON format, a widely used open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column contains geospatial data in text format. The data usually represents geographic features and their spatial extents. |
| geom_type | string | This column contains information about the type of the geometry that the geospatial data represents. |
| geom_centroid | string | This column contains the coordinates of the centroid of the geometric shape represented by the geospatial data in the row. |
| geom_center_x | double | This column contains the X-coordinate of the center of the geometric shape represented by the geospatial data in the row. |
| geom_center_y | double | This column contains the Y-coordinate of the center of the geometric shape represented by the geospatial data in the row. |
| gml_id | string | This string column stores the unique identifier for each geographical markup language data element. |
| kunta | string | This string column contains the municipality code. |
| kuntanro | long | This integer column contains the municipality number, which is a unique identifier for each municipality. |
| namn | string | This string column represents the name of the geographical area in a foreign language. |
| nimi | string | This string column represents the name of the geographical area. |
| pinta_ala | double | This real (floating-point) column contains the area of the geographic region in square meters. |
| posti_alue | string | This string column represents the postal area code. |
| shape_star | double | This real (floating-point) column represents a shape-related parameter of the geographic area. |
| shape_stle | double | This real (floating-point) column represents a shape-related parameter of the geographic area. |
| vuosi | long | This integer column contains the year when the data for the row was collected or updated. |
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 | 8d66a0c7-dc1f-4d54-96d8-f41467614c99 |
| Package id | 31d3b116-8f8b-4f94-9dc4-22b867ad86db |
| Revision id | 7d78004e-6cea-40aa-9f28-2981df4d904e |
| State | active |
| Table | postialue_pno_2016__table |