2017 Postal Area Statistics in Table Format
The table in discussion is part of a dataset collection, which comprises related data tables that are structured in a table format. The data content of this table is largely centered around geographic information, with a focus on Paavo's postal code areas for the year 2017. This information is useful for carrying out geospatial data analytics, particularly with reference to postal code areas in Finland. The geographic coordinates in this table are presented using the WGS 84 coordinate reference system, where the order of axis is longitude first, followed by latitude.
In terms of column descriptions, there are several columns that provide intricate details about each entry. There are columns that house geographic data in different formats such as GeoJSON and GeoText. There are also columns that provide the center coordinates (longitude and latitude) of geographic entities. The table also contains columns that denote the names of places in different languages, the area of the place, and the postal code related to that area.
Notably, there are two special columns in the table: '_extract_date' and '_row_number'. The '_extract_date' column holds the date on which the data was extracted from the source. The '_row_number' column, on the other hand, provides the row number of the data extracted from the source on the specified extract date. The combination of these two columns allows each row to be uniquely identified.
This table can be leveraged in various data analytics scenarios. For instance, it can be used to visualize the geographical distribution of postal code areas in Finland, highlight areas with specific characteristics or track changes in postal code areas over time. Furthermore, the table can aid in spatial analysis, allowing analysts to understand patterns, trends, and relationships within the geographic data. The data in the table is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the data source. It helps to understand when the specific data was collected. |
| _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'. The combination of '_extract_date' and '_row_number' uniquely identifies each row, providing a unique identifier for each record. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, which is a format for encoding a variety of geographic data structures. It allows for the representation of spatial features and their non-spatial attributes. |
| geom_geotext | string | Similar to 'geom_geojson', this column contains geometric data but in a textual format. It is another way of representing spatial data. |
| geom_type | string | This column specifies the geometry type of the spatial data contained in the 'geom_geojson' and 'geom_geotext' columns. For example, it might be a polygon, line, or point. |
| geom_centroid | string | This column contains the geometric center (centroid) of the spatial element represented in the 'geom_geojson' and 'geom_geotext' columns. It is usually represented as a point. |
| geom_center_x | double | This column represents the x-coordinate of the geometric center (centroid) of the spatial element. It offers another way to represent the location of the centroid. |
| geom_center_y | double | This column represents the y-coordinate of the geometric center (centroid) of the spatial element. It complements the 'geom_center_x' column to provide a full coordinate for the centroid. |
| gml_id | string | This is a unique identifier for each record. It might be used for indexing or joining tables. |
| kunta | string | This column likely represents a code or identifier for a specific municipality or district in Finland. |
| kuntanro | double | This column seems to be a numerical identifier for a specific municipality or district, possibly correlated with the 'kunta' column. |
| namn | string | This column contains names of locations or areas, possibly in Swedish as it is one of Finland's official languages. |
| nimi | string | Similar to the 'namn' column, this column contains names of locations or areas, but likely in Finnish, another official language of Finland. |
| objectid | double | This column is another unique identifier for each record. It might be used for indexing or joining tables. |
| pinta_ala | double | This column might represent the surface area of the spatial element represented in the 'geom_geojson' and 'geom_geotext' columns. |
| posti_alue | string | This column likely represents postal code areas in Finland. |
| vuosi | double | This column likely represents the year associated with the data record. |
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 | d713d9e9-f8d0-41c9-a4dc-0ab4de16abaf |
| Package id | d730a34a-7383-42f7-bc96-84ff3c8aa08d |
| Revision id | b5a0b663-bef5-43c8-9455-953b2c45adfc |
| State | active |
| Table | postialue_pno_2017__table |