Paavo Postal Code Areas Extending to Sea Areas - 2017
Click here for a data sample
The table under consideration belongs to a dataset collection which extends to marine areas in 2017, as per the information provided by the source, 'Tilastokeskus' (Statistics Finland). This table contains various types of data, including geographical information and unique identifiers for each row of data. It encompasses a wide variety of fields such as geographic coordinates, area codes, and names of specific regions, providing a rich source of information for various types of data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This enables the data to be utilized for geospatial data analytics, for instance, to map the distribution of different postal areas across Finland, or to analyze spatial patterns and trends over time. The table also includes unique identifiers for each row of data, derived from the date when the data was extracted and the row number. This combination of extract date and row number enables each row to be uniquely identified, supporting efficient data retrieval and manipulation. For example, it could be used to track changes in data over time or to identify specific records for detailed analysis. Moreover, the table includes data on the area of different regions (in square meters), which could be used, for example, to analyze the relationship between area size and other variables, or to compare the sizes of different regions. The table also includes data on the names of regions in different languages, which could be used to support multilingual data analytics or to study linguistic variations across the country. The table is sourced from Statistics Finland, based in Finland.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column records the date when the data on a particular row was extracted from the data source. It serves as a record of when the data was last updated. |
|---|
| _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 helps to uniquely identify each row in the table. |
|---|
| geom_geojson | string | This column stores the geometric data of the postal areas in a GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains the geometric data of the postal areas in a textual format. It provides a human-readable representation of the geographic data. |
|---|
| geom_type | string | This column specifies the type of the geometrical object. In this table, the type is ST_MULTIPOLYGON, indicating that the geometric data represents a complex shape with multiple boundaries. |
|---|
| geom_centroid | string | This column holds the geographic coordinates of the centroid (geometric center) of the postal areas. It represents the center point of each area. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the centroid of the postal areas. It represents the longitude of the center point. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the centroid of the postal areas. It represents the latitude of the center point. |
|---|
| gml_id | string | This is a unique identifier associated with each postal area. It helps to uniquely identify each postal area. |
|---|
| kunta | string | This column stores the municipality code. It represents the specific municipality that the postal area belongs to. |
|---|
| kuntanro | double | This column holds the municipality number. It is another way to identify the municipality that a postal area is part of. |
|---|
| namn | string | This column contains the name of the postal area. It provides a human-readable identifier for each area. |
|---|
| nimi | string | This column holds the name of the postal area. It is similar to 'namn', and gives a human-readable identifier for each area. |
|---|
| objectid | double | This column contains a unique identifier for each row in the table. It helps to uniquely identify each record in the table. |
|---|
| pinta_ala | double | This column holds the surface area of the postal area. It provides information about the size of each area. |
|---|
| posti_alue | string | This column stores the postal code of the area. It provides a way to identify the postal area. |
|---|
| vuosi | double | This column records the year when the data was collected. It provides information about the timeframe of the data. |
|---|
