Finland Postal Areas - Geospatial Data
The table under discussion belongs to the dataset collection and contains a wealth of information related to postal areas, as implied by the table contents description provided by the data source - 'Paavo-postinumeroalueet', which translates to 'Paavo Postal Code Areas'. This information is sourced from 'Tilastokeskus' (Statistics Finland), a website based in Finland.
The table contains several columns, two of which are of special interest: the '_extract_date' and '_row_number'. The '_extract_date' column indicates the date when the data on that specific row was extracted from the source, while the '_row_number' provides the specific row number in the data extracted from the source on that particular extract date. These two columns together serve as unique identifiers for each row in the table.
The table also contains several columns starting with 'geom_', which are of interest for geospatial data analytics. These columns contain geographic information presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This information can be particularly valuable for any analytical efforts requiring geographic mapping or spatial analysis.
The data contained within the table is highly versatile, and could be used in a variety of data analytics applications. For instance, the data could be used to perform demographic analysis based on postal code areas, enabling a detailed understanding of population distribution and trends. Additionally, the geospatial data could be utilized to create detailed maps of these postal code areas, aiding in planning for things such as infrastructure development or resource allocation. The information regarding the extraction date and row number could also be useful for tracking changes over time, allowing for longitudinal studies on population shifts or other trends.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. |
| _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'. |
| geom_geojson | string | This column contains GeoJSON formatted geometrical data. |
| geom_geotext | string | This column contains geometrical data formatted as text. |
| geom_type | string | This column indicates the type of the geometrical data, such as polygon or multipolygon. |
| geom_centroid | string | This column contains the central point of the geometrical shape. |
| geom_center_x | double | This column represents the X coordinate of the geometrical shape's center. |
| geom_center_y | double | This column represents the Y coordinate of the geometrical shape's center. |
| gml_id | string | This is a unique identifier for each row in the dataset. |
| kunta | string | This column contains the municipality code. |
| kuntanro | long | This column contains the municipality number. |
| namn | string | This column contains the name of the location in Swedish. |
| nimi | string | This column contains the name of the location in Finnish. |
| objectid | long | This column is a unique identifier for each object in the dataset. |
| pinta_ala | long | This column contains the area of the location in square meters. |
| posti_alue | string | This column contains the postal code of the location. |
| vuosi | long | This column contains the year the data was collected. |
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 | 8c975929-2df5-4e1a-94eb-93808898f195 |
| Package id | 2a584650-9961-44ac-877c-b02220cd23f2 |
| Revision id | 1932be2c-6845-4168-95c7-055d9f067ddd |
| State | active |
| Table | postialue_pno__table |