2024 Postal Area and Sea Region Data Tables Collection

This dataset collection is a compilation of related data tables sourced from the Statistical Center (Tilastokeskus) website in Finland. All tables within this collection are interconnected and provide valuable insights into specific fields of study. The dataset originates from a reliable service interface, ensuring the credibility and accuracy of the data included. Each table within the collection is meticulously organized in a format of columns and rows, facilitating easy data analysis and interpretation. This comprehensive collection is anticipated to be extremely beneficial for researchers, academics, and anyone with an interest in the specific domain it covers. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Paavo Postal Code Areas (Extending to Sea Areas) 2024 Data TableTSV
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...
Version History of Paavo Postal Code Areas (Extended to Maritime Areas) for 2024TSV
The 'table__history' is a part of a larger dataset collection, which is a historical record capturing changes in specific data over time. The table's data is primarily related to geographic areas extending to sea regions for the year 2024, sourced from the 'Statistics Finland' (Tilastokeskus) website. The table consists of various columns that carry unique information. For instance, certain columns carry geospatial data, which can be used for geospatial data analytics. These columns contain geographic coordinates presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The content of the table is unique due to its version history tracking. It contains two special columns, '_start_date' and '_end_date', that denote when a...

Column Descriptions

Paavo Postal Code Areas (Extending to Sea Areas) 2024 Data Table

Column	Type	Comment
_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.

Version History of Paavo Postal Code Areas (Extended to Maritime Areas) for 2024

Column	Type	Comment
_start_date	date	This column indicates the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in this version history table.
_end_date	date	This column records the date when a new version of the row was extracted from the data source. If the value is null, it signifies 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 source. Combined with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column holds the geometric data of the area in GeoJSON format, a popular open standard format designed for representing simple geographical features.
geom_geotext	string	This column stores the geometric data of the area in a text format.
geom_type	string	This column specifies the type of geometric data stored in the respective row, such as 'ST_POLYGON'.
geom_centroid	string	This column contains the centroid point of the geometric data, essentially marking the center point of the area.
geom_center_x	double	This column represents the X coordinate of the center point of the area.
geom_center_y	double	This column represents the Y coordinate of the center point of the area.
gml_id	string	This column contains a unique identifier for each row in the data set.
kunta	string	This column holds the municipality code where the area is located.
kuntanro	long	This column contains the municipality number, a unique identifier for each municipality.
namn	string	This column stores the name of the area in the local language.
nimi	string	This column contains the name of the area.
objectid	long	This column holds a unique identifier for each row in the data set.
pinta_ala	long	This column represents the surface area of the region in square meters.
posti_alue	string	This column contains the postal code of the area.
vuosi	long	This column indicates the year when the data was collected.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024