Postal Code Area Extensions to Marine Regions - Data Table

To download the data set, please sign up or log in

Click here for a data sample

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_datedateThis 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_numberlongThis 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_geojsonstringThis column represents the geometric shape of the area in GeoJSON format.
geom_geotextstringThis column represents the geometric shape of the area in plain text format.
geom_typestringThis column specifies the type of the geometric shape of the area.
geom_centroidstringThis column represents the centroid point of the geometric shape of the area.
geom_center_xdoubleThis column represents the X coordinate of the center point of the geometric shape of the area.
geom_center_ydoubleThis column represents the Y coordinate of the center point of the geometric shape of the area.
gml_idstringThis column contains a unique identifier for each record in the data.
kuntastringThis column represents the code of the municipality.
kuntanrolongThis column represents the number of the municipality.
namnstringThis column represents the name of the area in Swedish language.
nimistringThis column represents the name of the area in Finnish language.
objectidlongThis column contains a unique object identifier for each record in the data.
pinta_alalongThis column represents the area size in square meters.
posti_aluestringThis column represents the postal code of the area.
vuosilongThis 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
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Id0aa8dd82-a3b3-45b1-9df2-9ea91c94ac97
Package ida2951e94-4314-46a3-a292-91044f575ecd
Revision idad38e233-ad0a-4e49-9cd5-2426a7a643b8
Stateactive
Tablepostialue_pno_meri__table