2015 Postal Area Marine Data Collection
Tables
-
Historical Version Records of the Sea-Extending Postal Code Areas (2015)TSV
The 'table__history' is a comprehensive dataset that captures the version history of its base table rows. It's part of the dataset collection 'postialue_pno_meri_2015'. This data originates from the 'Paavo-postinumeroalueet (merialueille ulottuva) 2015', which translates to 'Paavo Postal Code Areas (extending to sea areas) 2015' in English. The table is sourced from the website of 'Tilastokeskus' (Statistics Finland) located in Finland. The data in the table is organized into various columns, each with a unique identifier. For instance, the '_row_number' column captures the number of the row in the raw data extracted from the data source. Each row in this version history table is uniquely identified by a combination of the '_start_date' and '_row_number'. The table also includes...
-
Paavo Postal Code Areas Extending to Sea Regions, 2015TSV
The table in focus, originating from Finland's Statistics Bureau website (Tilastokeskus), is a constituent of the dataset collection known as 'postialue_pno_meri_2015'. Its data is primarily aimed at providing information about the Paavo postal code areas, extending to sea regions, for the year 2015. The table is a treasury of geographic and demographic data, with a rich set of columns providing various details. The special columns '_extract_date' and '_row_number' serve a unique purpose. The former captures the date when the data was extracted, while the latter reflects the row number for the data extracted on that specific date. Together, these two columns establish a unique identity for each row in the table. The table also holds a collection of 'geom_' prefixed columns, which...
Column Descriptions
Paavo Postal Code Areas Extending to Sea Regions, 2015
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. It helps in identifying the currency of the data. |
| _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 uniquely identifies each row. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, a spatial data interchange format based on JavaScript Object Notation (JSON). |
| geom_geotext | string | This column contains geometric data as text, representing the spatial characteristics of the data. |
| geom_type | string | This column specifies the type of the geometric data contained in 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column stores the centroid or the geometric center of a shape. |
| geom_center_x | double | This column represents the X coordinate of the geometric center of a shape. |
| geom_center_y | double | This column represents the Y coordinate of the geometric center of a shape. |
| gml_id | string | This column contains a unique identifier for each record in the data source. |
| kunta | string | This column contains the municipality code in which the postal area is located. |
| kuntanro | long | This column is the numerical representation of the municipality code. |
| namn | string | This column contains the Finnish name of the postal area. |
| nimi | string | This column also contains the Finnish name of the postal area. |
| pinta_ala | double | This column represents the surface area of the postal area. |
| posti_alue | string | This column contains the postal code for the area. |
| shape_star | double | This column contains data related to the shape of the postal area. |
| shape_stle | double | This column represents the style or characteristics of the shape of the postal area. |
| vuosi | long | This column represents the year when the data was recorded. |
Historical Version Records of the Sea-Extending Postal Code Areas (2015)
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique combination with the '_row_number' to identify each row in the history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It forms a unique combination with the '_start_date' to identify each row in the history table. |
| geom_geojson | string | This column contains the geographical information in GeoJSON format. |
| geom_geotext | string | This column contains the geographical information in text format. |
| geom_type | string | This column contains the type of the geographical data. |
| geom_centroid | string | This column contains the centroid of the geographical area. |
| geom_center_x | double | This column contains the X coordinate of the center of the geographical area. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geographical area. |
| gml_id | string | This column contains the unique identifier of the row in the original dataset. |
| kunta | string | This column contains the municipality code. |
| kuntanro | long | This column contains the municipality number. |
| namn | string | This column contains the name of the area in Swedish. |
| nimi | string | This column contains the name of the area in Finnish. |
| pinta_ala | double | This column contains the area of the municipality in square meters. |
| posti_alue | string | This column contains the postal code of the area. |
| shape_star | double | This column contains the shape area of the municipality. |
| shape_stle | double | This column contains the shape length of the municipality. |
| vuosi | long | This column contains the year of the data. |
Additional Info
| Last Updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |