Paavo Postal Code Areas (Extending to Sea Areas) 2024 Data Table
Click here for a data sample
The table is a part of a dataset collection that contains data on postal areas extending to maritime areas for the year 2024, sourced from 'Tilastokeskus' (Statistics Finland). The data within the table is structured into various columns, each holding specific information. Special columns like 'extract_date' and '_row_number' hold details about when the data was extracted and the unique row number in the extracted data respectively. These two columns together uniquely identify each row in the table. The table also contains geographic information in columns starting with 'geom', which can be used for geospatial data analytics. The geographic coordinates are presented using WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Other columns provide details about the postal area such as its area size and the name of the region. For instance, you can identify a specific region's area size or track changes in the postal areas over time using the data in this table. The dataset can be used in a variety of ways in data analytics. For instance, it could be used to analyze population density across different postal areas, or it could be used in logistics to optimize delivery routes. Additionally, the geospatial data can be used to create detailed maps or conduct spatial analysis.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the data on each row was extracted from the source. It helps to track when the specific data was fetched. |
|---|
| _row_number | long | This column contains the row number from the data extracted from the source. Combined with '_extract_date', it uniquely identifies each row. |
|---|
| geom_geojson | string | This column contains geometric data in GeoJSON format. It provides a visual representation of the data points. |
|---|
| geom_geotext | string | This column provides the geometric data in text form, offering another method for visualizing the data. |
|---|
| geom_type | string | This column specifies the type of geometry used in the 'geom_geojson' and 'geom_geotext' columns. For instance, it could be a polygon. |
|---|
| geom_centroid | string | This column provides the central point of the geometric shape defined in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the geometric center. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the geometric center. |
|---|
| gml_id | string | This column contains unique identifiers for each row in the table. |
|---|
| kunta | string | This column represents the municipality code in the dataset. |
|---|
| kuntanro | long | This column contains the municipality number, which is another form of identification for the municipalities. |
|---|
| namn | string | This column contains the Swedish names of the municipalities. |
|---|
| nimi | string | This column contains the Finnish names of the municipalities. |
|---|
| objectid | long | This column contains unique object identifiers. |
|---|
| pinta_ala | long | This column represents the area size of the municipalities. |
|---|
| posti_alue | string | This column contains the postal code area for each municipality. |
|---|
| vuosi | long | This column contains the year of the data. |
|---|
