2019 Postal Code Areas Data (Extracted From Finnish Statistical Database)
The table, part of the 'postialue_pno_2019' dataset collection, contains a rich collection of data pertaining to the postal code areas in Finland for the year 2019. This information is sourced from 'Tilastokeskus' (Statistics Finland). The table provides a diverse range of data, from geographic data to postal area details.
Geographic data is represented in multiple formats, making the table versatile for various forms of geospatial data analytics. It includes coordinates in the form of 'geom_center_x' and 'geom_center_y', which follow the WGS 84 coordinate reference system. This system orders the axis starting with longitude, then latitude. There's also the 'geom_geojson' column that provides geographic data in the GeoJSON format, and 'geom_geotext' which provides data in the WKT format. The type of geographic information is specified in the 'geom_type' column. The 'geom_centroid' column provides the geographic center point of the postal area.
The table also includes details about the postal areas. This includes the postal area code, the area in square meters, the Finnish and Swedish names of the area, and a unique identifier for each row. The table also contains columns with the extraction date and the row number from the original data extraction. This combination uniquely identifies each row in the table.
This rich data collection could be utilized in various ways for data analytics. For instance, geospatial analysis could be used to understand the spatial distribution of postal areas across Finland. This could aid in logistics planning or infrastructure development. The data could also be used in demographic studies, correlating postal area data with other data sets to gain insights into population distribution, socio-economic trends, and more.
Lastly, the table includes columns that record when the data for each row was extracted, and the row's number in that extraction. This means each row is uniquely identifiable, providing a solid foundation for tracking data changes over time, or for auditing purposes.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the data source. |
| _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. Together with '_extract_date', it uniquely identifies each row. |
| geom_geojson | string | This column contains the geometric representation of the postal area in GeoJSON format, a type of open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column contains the geometric representation of the postal area in geotext format. |
| geom_type | string | This column specifies the type of the geometric object that is represented in 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the central point (centroid) of the geometric shape representing the postal area. |
| geom_center_x | double | This column contains the x-coordinate of the centroid of the geometric shape representing the postal area. |
| geom_center_y | double | This column contains the y-coordinate of the centroid of the geometric shape representing the postal area. |
| gml_id | string | This is a string type column, presumably an identifier for the geographical markup language (GML) representation of the postal area. |
| kunta | string | This string type column likely contains the municipality code or similar identifier for the postal area. |
| kuntanro | long | This is a 64-bit integer type column that appears to be another identifier for the municipality, perhaps a numerical one. |
| namn | string | This string type column contains the name of the postal area. |
| nimi | string | This string type column also contains the name of the postal area, perhaps in a different language or format. |
| objectid | long | This is a 64-bit integer type column that appears to be a unique identifier for each row or object in the dataset. |
| pinta_ala | double | This real type column likely refers to the area of the postal region, likely in square meters or similar unit. |
| posti_alue | string | This string type column contains the postal code or similar identifier for the postal area. |
| shape_leng | double | This real type column likely refers to the length of the perimeter of the postal area, likely in meters or similar unit. |
| vuosi | long | This 64-bit integer type column contains the year when the data in the row was recorded or became effective. |
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 | beec400c-f0eb-4ef0-aef6-2b6346bef0f0 |
| Package id | 31f4c8eb-aed9-4eef-a4fe-d1aaa249b7a7 |
| Revision id | d2c0f3a1-51d5-4234-a4ff-d5898c1f2ec1 |
| State | active |
| Table | postialue_pno_2019__table |