2018 Postal Code Areas in Finland
Click here for a data sample
The table is an integral part of the dataset collection named 'postialue_pno_2018'. It contains vital data that encompasses the Paavo postal code areas for the year 2018, which is a unique feature indicating the table's relevance to postal services in Finland. The table is structured with several columns, each serving a definitive purpose. Special columns such as 'extract_date' and '_row_number' provide information on when data was extracted and the specific row number in the extracted data, respectively. This combination helps to uniquely identify each row in the table. Columns starting with 'geom' contain geographic data useful for geospatial data analytics. For instance, geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order of longitude first, followed by latitude. Other columns provide data on various aspects such as municipality codes, names of areas, and even the size of the area. This table can be a valuable resource for data analytics. For instance, it can be used to analyze postal service efficiency by mapping the postal code areas and comparing it with the speed of delivery. Further, the geospatial data can be used to visualize the postal code areas for better logistical planning. The table was sourced from the 'Tilastokeskus' website, which is Finland's statistical bureau.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data on the row was extracted from the source. |
|---|
| _row_number | long | The row number in the data extracted from the source on the specified extract date. It, combined with '_extract_date', uniquely identifies each row. |
|---|
| geom_geojson | string | Contains complex geographical data in GeoJSON format, representing different types of geographic shapes. |
|---|
| geom_geotext | string | This holds the text representation of the geographic shape data. |
|---|
| geom_type | string | Specifies the type of the geographical shape. For example, 'ST_MULTIPOLYGON' indicates a shape that includes multiple polygons. |
|---|
| geom_centroid | string | The geographical point that represents the centroid of the given geographic shape. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geographic shape. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geographic shape. |
|---|
| gml_id | string | A unique identifier for each row in the table. |
|---|
| kunta | string | A coded value representing the municipality where the geographic shape is located. |
|---|
| kuntanro | long | The number associated with the municipality. |
|---|
| namn | string | The Swedish name of the location represented by the geographic shape. |
|---|
| nimi | string | The Finnish name of the location represented by the geographic shape. |
|---|
| objectid | long | A unique identifier for each object in the dataset. |
|---|
| pinta_ala | double | The area of the geographic shape in square meters. |
|---|
| posti_alue | string | The postal code area that the geographic shape belongs to. |
|---|
| shape_leng | double | The length of the perimeter of the geographic shape. |
|---|
| vuosi | long | The year the data was collected. |
|---|
