Paavo Postal Code Areas (Extending to Sea Areas) - 2022 Edition
The table in question is a part of a larger dataset collection and contains a comprehensive set of information related to postal zones extending to sea areas for the year 2022, sourced from 'Tilastokeskus' (Statistics Finland). The data provides various geographic details, which are vital for conducting geospatial data analytics. The geographical coordinates are presented using the WGS 84 coordinate reference system, where the longitude is presented first, followed by the latitude.
The table includes a variety of columns, providing specific information. For instance, the table includes columns providing geographic information in different formats, such as GeoJSON and GeoText. These columns offer a valuable resource for mapping and visualizing the data geographically. A column is dedicated to the type of geographic data presented, which can be useful in specifying the visualization tools used.
Moreover, the table captures the centroid of the geographic data, which can be used to find the center point of the geographic area. Additional columns present the x and y coordinates of this center point, which can aid in location pinning on maps.
The table also contains columns with specific identification numbers for each postal zone, which can be used to cross-reference with other tables or datasets. The table also includes columns that contain the names of the postal zones in different languages, which can be useful in international communication and localization efforts.
The table features two special columns, namely '_extract_date' and '_row_number'. The '_extract_date' column records the date when the data on the row was extracted, while the '_row_number' column records the row number of the data extracted on that date. Together, these two columns provide a unique identifier for each row, ensuring that each row represents a unique data extraction instance.
The data in the table can be utilized in a multitude of ways. For example, it can help in understanding the spatial distribution of postal zones, enabling efficient route planning for logistics and delivery companies. Furthermore, the detailed geographical data can assist urban planners in infrastructure development and planning. Lastly, the table could be used by researchers to study population distribution and urbanization trends.
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 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 geographical data. |
geom_geotext | string | This column contains geographical data in geotext format. |
geom_type | string | This column specifies the type of geographical data represented in the table. |
geom_centroid | string | This column contains the centroid point of the geographical area. |
geom_center_x | double | This column contains the longitude of the center point of the geographical area. |
geom_center_y | double | This column contains the latitude of the center point of the geographical area. |
gml_id | string | This column is a unique identifier for each row in the table. |
kunta | string | This column contains a unique identifier for the municipality. |
kuntanro | long | This column contains the number associated with the municipality. |
namn | string | This column contains the name of the geographical area in Swedish. |
nimi | string | This column contains the name of the geographical area in Finnish. |
objectid | long | This column contains a unique object identifier for each row in the table. |
pinta_ala | long | This column contains the area size of the geographical area in square meters. |
posti_alue | string | This column contains the postal code of the geographical area. |
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 | 9df2407e-505d-4ab5-a8b4-0dd70b80fb61 |
Package id | 09e9dc95-4581-4230-b05a-0db73c9a1f51 |
Revision id | a3751a3d-ee5f-4981-a3bd-0febccd10ed2 |
State | active |
Table | postialue_pno_meri_2022__table |