Postal Code Area Extensions to Marine Regions - Data Table
The table in question is a rich source of information related to geographic postal areas, extending to the maritime regions. The data for this table is sourced from the Finnish Statistics Bureau, 'Tilastokeskus'.
The table comprises a variety of columns containing both administrative and geospatial data. The administrative data provides details such as the area name, postal area, and the year, while the geospatial data provides geographic coordinates and related information.
Two special columns, '_extract_date' and '_row_number', are included. The '_extract_date' provides the date when the data on the row was extracted from the source, and the '_row_number' gives the unique row number for the data extracted on the specified date. These two columns together uniquely identify each row in the table.
The columns beginning with 'geom_' contain geographic data that can be used for geospatial analytics. Specifically, they provide geographic coordinates, types, and related geographic details. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
Given the nature of the data, this table could be utilized in various ways for data analytics. It could be used to analyze spatial patterns and trends across different geographical locations. For example, one could study population distribution, housing trends, or business activities in different postal areas over time. Additionally, by leveraging the geospatial data, advanced geospatial analytics could be conducted to understand geographic distribution and spatial relationships among different variables.
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. It helps to track when the data was last updated. |
_row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It helps to uniquely identify each row. |
geom_geojson | string | This column represents the geometric shape of the area in GeoJSON format. |
geom_geotext | string | This column represents the geometric shape of the area in plain text format. |
geom_type | string | This column specifies the type of the geometric shape of the area. |
geom_centroid | string | This column represents the centroid point of the geometric shape of the area. |
geom_center_x | double | This column represents the X coordinate of the center point of the geometric shape of the area. |
geom_center_y | double | This column represents the Y coordinate of the center point of the geometric shape of the area. |
gml_id | string | This column contains a unique identifier for each record in the data. |
kunta | string | This column represents the code of the municipality. |
kuntanro | long | This column represents the number of the municipality. |
namn | string | This column represents the name of the area in Swedish language. |
nimi | string | This column represents the name of the area in Finnish language. |
objectid | long | This column contains a unique object identifier for each record in the data. |
pinta_ala | long | This column represents the area size in square meters. |
posti_alue | string | This column represents the postal code of the area. |
vuosi | long | This column represents the year when 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 | 0aa8dd82-a3b3-45b1-9df2-9ea91c94ac97 |
Package id | a2951e94-4314-46a3-a292-91044f575ecd |
Revision id | ad38e233-ad0a-4e49-9cd5-2426a7a643b8 |
State | active |
Table | postialue_pno_meri__table |