2021 Postal Code Areas Data
The 'table' within the 'postialue_pno_2021' dataset collection is a comprehensive assembly of geographic and demographic data, sourced from the 'Statistics Finland' (Tilastokeskus) website in Finland. It provides valuable insights into different areas based on postal codes for the year 2021, as indicated by the 'Paavo-postinumeroalueet 2021' description.
The table contains geographic data that can be used for geospatial analysis, presented using the WGS 84 coordinate reference system, with axis order longitude (geom_center_x) first, followed by latitude (geom_center_y). It provides polygonal geographical shapes, types, and centroid points, which are crucial for detailed geographic mapping and spatial data visualizations.
The table also includes attributes that provide demographic and administrative information such as the names of areas in different languages and their corresponding municipal codes (kunta), which can be used for regional analysis, trend spotting, or population studies.
Additional information like the area size (pinta_ala) and unique identifiers (gml_id & objectid) are also provided, which can be used in a variety of analyses, from studying land utilisation to identifying unique areas for focused studies.
Two special columns, '_extract_date' and '_row_number', uniquely identify each row. The '_extract_date' indicates when the data was extracted from the source, while the '_row_number' denotes the row number from the extracted data, allowing for accurate traceability and replication of data extraction.
This table can serve various data analytics purposes. For example, the geographic data can be used to create detailed maps for visualizing demographic trends or planning logistics. The demographic data can assist in identifying population concentrations for public service planning or market research. Furthermore, changes in area size or other variables over time can be studied by comparing data from different '_extract_date' entries.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column holds the date when the data on the row was extracted from the data source. It is one of the special columns in the table used to uniquely identify each row. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It is another special column used to uniquely identify each row. |
| geom_geojson | string | This column contains the GeoJSON representation of the geographical area related to the data row. |
| geom_geotext | string | This column contains the textual representation of the geography of the data row in the form of polygons. |
| geom_type | string | This column specifies the type of the geographical data represented in the row. The sample value 'ST_POLYGON' indicates that the data is represented as a polygon. |
| geom_centroid | string | This column contains the geographical coordinate of the centroid of the geographical area related to the data row. |
| geom_center_x | double | This column represents the X-coordinate of the center point of the geographical area related to the data row. |
| geom_center_y | double | This column represents the Y-coordinate of the center point of the geographical area related to the data row. |
| gml_id | string | This column, of string type, appears to be a unique identifier for each row in the table. |
| kunta | string | This string-type column contains some form of municipality or region code. |
| kuntanro | long | This integer-type column seems to represent a municipality or region number. |
| namn | string | This column, of string type, could represent the name of the geographical area related to the data row. |
| nimi | string | This column is of string type and it might represent another format or translation of the name of the geographical area related to the data row. |
| objectid | long | This integer-type column seems to be a unique identifier for each row in the table. |
| pinta_ala | long | This column is of integer type and it could represent the area of the geographical zone related to the data row. |
| posti_alue | string | This column, of string type, seems to indicate a postal code related to the geographical area of the data row. |
| vuosi | long | This integer-type column seems to represent the year associated with the data row. |
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 | 929c9bc6-633f-46be-86a1-3fe4ba306084 |
| Package id | 420caed5-97b4-426e-b57e-70274c88d880 |
| Revision id | 4e0e4048-adab-40b4-9615-6111e1cb7b66 |
| State | active |
| Table | postialue_pno_2021__table |