2023 Geospatial Data of Postal Code Areas Extending to Sea Zones
The table in focus forms part of a group of related data tables, specifically belonging to the 'postialue_pno_meri_2023' dataset collection. The table’s contents revolve around the Paavo postal code areas (extending to maritime areas) for the year 2023, sourced from Finland's 'Tilastokeskus' (Statistics Finland) website.
The data in the table is organized into various columns, which include unique identifiers, geographic information, and other specific details. Two of these columns are '_extract_date' and '_row_number'. The '_extract_date' column denotes the date on which the data row was extracted from the source, while the '_row_number' column indicates the row number in the data extracted from the source on the specified extract date. Together, these two columns uniquely identify each row in the table.
The table also contains columns starting with 'geom_', which house geographic information relevant for geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
In terms of data analytics, this table provides a rich source of information. For instance, analysts can use the geographic coordinates and area details to study population distribution patterns across different postal code areas. Additionally, they can track changes over time by comparing the data extraction dates. Furthermore, the unique identifiers in the table can be instrumental in merging this data with other datasets, thereby enriching the overall analysis and leading to more comprehensive insights.
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. The data type of this column is Date. |
_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'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row. The data type of this column is Integer. |
geom_geojson | string | This column contains geographic data in the GeoJSON format. The data type of this column is String. |
geom_geotext | string | This column contains geographic data in the Geotext format. The data type of this column is String. |
geom_type | string | This column indicates the type of the geographic data. The data type of this column is String. |
geom_centroid | string | This column contains the geographic center point of the data. The data type of this column is String. |
geom_center_x | double | This column contains the X-coordinate of the geographic center point. The data type of this column is Float. |
geom_center_y | double | This column contains the Y-coordinate of the geographic center point. The data type of this column is Float. |
gml_id | string | This column contains the unique identifier for the geographic data. The data type of this column is String. |
kunta | string | This column contains the code of the municipality. The data type of this column is String. |
kuntanro | long | This column contains the number of the municipality. The data type of this column is Integer. |
namn | string | This column contains the name of the area in Swedish. The data type of this column is String. |
nimi | string | This column contains the name of the area in Finnish. The data type of this column is String. |
objectid | long | This column contains the object identifier. The data type of this column is Integer. |
pinta_ala | long | This column contains the surface area measurement. The data type of this column is Integer. |
posti_alue | string | This column contains the postal code of the area. The data type of this column is String. |
vuosi | long | This column contains the year which the data is related to. The data type of this column is Integer. |
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 | e0883bec-ef30-48e8-83f6-5b0ff43c61e6 |
Package id | 1b3bb696-e510-4bc9-af00-5822f5a559e1 |
Revision id | 65fd1ae9-4111-454e-b308-e82d0b3adc04 |
State | active |
Table | postialue_pno_meri_2023__table |