2021 Postal Code Areas Extending to Sea Regions - Data Table
The table belongs to a dataset collection that contains information on postal code areas extending to marine areas for the year 2021, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland). It encompasses a broad range of data points, including geographic information useful for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
The table includes details such as the date of data extraction, the number of the row in the extracted data, and various types of geographic data in different formats. The geographic data provides a detailed representation of the postal code areas, including their type (for example, polygon), centroid, center x and y coordinates, and even a GeoJSON representation.
Additionally, the table also contains information like the postal area's name in both Finnish and Swedish, the municipality number, the year, and the size of the area in square meters. Each row in the table is uniquely identified by the combination of the data extraction date and the row number.
Given the breadth and depth of the data, this table can be utilized in various ways for data analytics. For instance, the geographic data could be used to create detailed visual representations of the postal code areas. The size of the areas and the names of the postal areas can be used for demographic studies. The data could also help businesses in logistics or delivery services to optimize their operations based on the geographical layout of the postal code areas. Moreover, the data extraction date and row number could be used to track changes in the data over time, allowing for temporal analysis of the postal code areas.
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 plays a crucial role in tracking the data extraction history. |
| _row_number | long | This column contains the row number in the data extracted from the source on the specific extract date. It works in combination with '_extract_date' to uniquely identify each row. |
| geom_geojson | string | This column stores the geographical data in GeoJSON format which represents simple geographical features. |
| geom_geotext | string | This column holds the geographical data in text format. |
| geom_type | string | This column specifies the type of the geographical data. |
| geom_centroid | string | This column contains the centroid point of the geographical data. |
| geom_center_x | double | This column holds the x-coordinate of the center of the geographical data. |
| geom_center_y | double | This column holds the y-coordinate of the center of the geographical data. |
| gml_id | string | This column holds the unique identifier for each row. |
| kunta | string | This column contains the municipality code. |
| kuntanro | long | This column holds the municipality number. |
| namn | string | This column contains the Swedish name for the municipality. |
| nimi | string | This column holds the Finnish name for the municipality. |
| objectid | long | This column contains the object's identifier. |
| pinta_ala | long | This column holds the surface area of the municipality. |
| posti_alue | string | This column contains the postal area code. |
| vuosi | long | This column holds the year of the data. |
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 | 85d50966-f9db-4641-ac9f-3a7c6b1cef01 |
| Package id | 2043a820-5f28-4daa-b2f1-ad06d4c82d62 |
| Revision id | c7fce539-d92b-4f5b-8cad-a1c6d6e7393b |
| State | active |
| Table | postialue_pno_meri_2021__table |