2023 Postal Areas Data Table - Finland
The 'table' is a part of the 'postialue_pno_2023' dataset collection. It contains information related to Paavo postal code areas for the year 2023, sourced from the 'Statistics Finland' (Tilastokeskus) website in Finland. The data is structured in a specific format featuring a variety of columns, each representing a different aspect of the postal code area.
Key columns include geographic data fields, which start with 'geom_'. These columns contain geographic information that can be used for geospatial data analytics. For instance, 'geom_geojson' and 'geom_geotext' contain geographic shapes information in different formats, while 'geom_center_x' and 'geom_center_y' provide geographic center coordinates of the postal code area. It's important to note that geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
Other essential columns include 'kunta' and 'kuntanro' that represent municipality identifiers. 'Namn' and 'nimi' contain the names of the areas in different languages. 'Objectid' is a unique identifier for each row, and 'pinta_ala' represents the area size. The 'posti_alue' column contains postal code information, and 'vuosi' indicates the year of the data.
Additionally, the table has two special columns, '_extract_date' and '_row_number'. The '_extract_date' field contains the date when the row's data was extracted, while '_row_number' is the row number in the data extracted on the specified extract date. The combination of these two columns uniquely identifies each row.
In terms of data analytics, this table could be used in various ways. For example, the geographic data could be used to create visual maps of postal code areas. The 'pinta_ala' could be used to analyze the size of the areas, and the 'vuosi' field could be used for time-series analysis. The dataset could also be used for demographic analysis, urban planning, and postal services optimization, among other applications.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column records the date when the data row was extracted from the source. |
| _row_number | long | This indicates the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| geom_geojson | string | This column contains geometry data in GeoJSON format. |
| geom_geotext | string | This stores the geometric data as a text string. |
| geom_type | string | This designates the type of geometric data stored. |
| geom_centroid | string | This signifies the geometric center of a shape in the form of a point. |
| geom_center_x | double | This represents the X-coordinate of the geometric center of a shape. |
| geom_center_y | double | This represents the Y-coordinate of the geometric center of a shape. |
| gml_id | string | This is a unique identifier for each data entry. |
| kunta | string | This column contains string type data. |
| kuntanro | long | This is an integer type data field. |
| namn | string | This contains string type data. |
| nimi | string | This also contains string type data. |
| objectid | long | This is a unique identifier for each data entry. |
| pinta_ala | long | This column contains data of type Integer64. |
| posti_alue | string | This column contains string type data. |
| vuosi | long | This column contains integer type data, referring to a specific year. |
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 | 1daed5c7-94a1-4a9f-afa8-c40167c29f7b |
| Package id | 27dbf2e7-142a-4758-98ed-9236e158e721 |
| Revision id | a728e063-96d6-4782-9342-1ed5971e8eff |
| State | active |
| Table | postialue_pno_2023__table |