2016 Coastal Area Postal Codes: An Organized Collection of Geometrical and Demographical Data
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_date | date | This 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_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'. It's the other special column that helps in uniquely identifying each row. |
geom_geojson | string | This column represents the geographic data of the postal area in a geojson format, which is a format for encoding geographical data structure. |
geom_geotext | string | This 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_type | string | This column specifies the type of the geographical data structure provided in the 'geom_geojson' and 'geom_geotext' columns. |
geom_centroid | string | This column provides the geographical point that represents the centroid of a geographical area. |
geom_center_x | double | This column gives the x-coordinate of the centroid of a geographical area. |
geom_center_y | double | This column gives the y-coordinate of the centroid of a geographical area. |
gml_id | string | This is an identifier column that contains unique identifiers for each row in the table. |
kunta | string | This column contains the municipality code in Finland. |
kuntanro | long | This column contains the municipality number, which is similar to the 'kunta' column. |
namn | string | This column contains the name of the postal area in Swedish language. |
nimi | string | This column contains the name of the postal area in Finnish language. |
pinta_ala | double | This column represents the area size of the postal region. |
posti_alue | string | This column contains the postal area code. |
shape_star | double | This column represents the area of the shape of the postal region. |
shape_stle | double | This column provides the length of the boundary of the postal region. |
vuosi | long | This 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 | |
Country | fi |
Database | fi_tilastokeskus |
Extract date | 2024-11-11 |
Id | 9b751360-e1cc-485a-92c4-00cfaed31033 |
Package id | 7afa86a9-0386-4b8c-834f-56d21b8c952b |
Revision id | b9b27ad7-352c-4910-90d1-99f965e9f46d |
State | active |
Table | postialue_pno_meri_2016__table |