2016 Coastal Area Postal Codes: An Organized Collection of Geometrical and Demographical Data

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

Click here for a data sample

The table, which is a part of the dataset 'postialue_pno_meri_2016', gathers comprehensive data relevant to postal areas extending to marine areas in Finland, as sourced from the Finnish Statistics Bureau ('Tilastokeskus'). The data fields in the table can be broadly categorized into three groups: extraction details, geographic data, and postal area specifics.

The extraction details contain two columns, one indicating the date when the data row was extracted, and the other specifying the row number of the data as extracted from the source. These two fields combined uniquely identify each row of data.

The geographic data is represented by a collection of columns that start with 'geom_'. These fields encompass various geospatial data points such as geographic coordinates and geotext, which are presented using the WGS 84 coordinate reference system with the axis order of longitude followed by latitude. This information can be used for geospatial data analytics, allowing users to visualize the data on a map and explore geographic patterns.

The postal area specifics include a variety of information about each postal area, such as its name, area in square meters, postal area code, and more. It provides rich context about each area that can be valuable for a range of analyses.

Potential applications of the data in this table could be varied. For instance, the geographic data can be used for spatial analysis or cartographic visualization, helping users to identify geographic patterns or trends. The postal area specifics can be used in demographic or socio-economic studies, allowing researchers to examine patterns in postal areas across Finland. Finally, the extraction details can be used for data management and auditing, ensuring the integrity and accuracy of the data.

Field Descriptions

Name Data type Description
_extract_datedateThis column records the date when the data on the row was extracted from the data source. It is one of the two special columns that uniquely identifies each row of data in the table.
_row_numberlongThis column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It's the other special column that helps in uniquely identifying each row.
geom_geojsonstringThis column represents the geographic data of the postal area in a geojson format, which is a format for encoding geographical data structure.
geom_geotextstringThis column contains the geographical data in geotext format. It represents the same data as in the 'geom_geojson' column but in a different format.
geom_typestringThis column specifies the type of the geographical data structure provided in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroidstringThis column provides the geographical point that represents the centroid of a geographical area.
geom_center_xdoubleThis column gives the x-coordinate of the centroid of a geographical area.
geom_center_ydoubleThis column gives the y-coordinate of the centroid of a geographical area.
gml_idstringThis is an identifier column that contains unique identifiers for each row in the table.
kuntastringThis column contains the municipality code in Finland.
kuntanrolongThis column contains the municipality number, which is similar to the 'kunta' column.
namnstringThis column contains the name of the postal area in Swedish language.
nimistringThis column contains the name of the postal area in Finnish language.
pinta_aladoubleThis column represents the area size of the postal region.
posti_aluestringThis column contains the postal area code.
shape_stardoubleThis column represents the area of the shape of the postal region.
shape_stledoubleThis column provides the length of the boundary of the postal region.
vuosilongThis column represents the year when the data row was recorded.

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
Id9b751360-e1cc-485a-92c4-00cfaed31033
Package id7afa86a9-0386-4b8c-834f-56d21b8c952b
Revision idb9b27ad7-352c-4910-90d1-99f965e9f46d
Stateactive
Tablepostialue_pno_meri_2016__table