Postal Area Sea Boundary Statistics Service Interface

This dataset collection is an assortment of related data tables sourced from the Statistics Finland (Tilastokeskus) website in Finland. The tables are organized in a clear format of rows and columns, presenting related data in a cohesive manner. The data provided in these tables is updated periodically as indicated by the presence of tables for specific years. The data primarily seems to revolve around postal areas, suggesting potential applications in geographical or demographic research. The dataset description provided by the source, the Statistics Finland service interface (WFS), suggests the data is collected and updated using web feature service technologies, ensuring a reliable and up-to-date collection of information. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Postal Code Area Extensions to Marine Regions - Data TableTSV
The table in question is a rich source of information related to geographic postal areas, extending to the maritime regions. The data for this table is sourced from the Finnish Statistics Bureau, 'Tilastokeskus'. The table comprises a variety of columns containing both administrative and geospatial data. The administrative data provides details such as the area name, postal area, and the year, while the geospatial data provides geographic coordinates and related information. Two special columns, '_extract_date' and '_row_number', are included. The '_extract_date' provides the date when the data on the row was extracted from the source, and the '_row_number' gives the unique row number for the data extracted on the specified date. These two columns together uniquely identify each row...
Version History of Postal Area Extensions to Sea Areas (Paavo)TSV
The 'table__history' is a comprehensive data table that represents the version history of the underlying base table rows. This table is part of a larger dataset collection, which is dedicated to providing rich, geospatial information. The data in this table is sourced from 'Tilastokeskus' (Statistics Finland) and is specifically relevant to the postal areas extending to the marine areas. This table is structured with several columns, each carrying unique information. For instance, it captures the start and end dates indicating when the rows were extracted and when a new version of the row was updated. Unique identifiers for each row in this version history table are formed by the combination of the start date and the row number. If the end date is null, it signifies that the row is the...

Column Descriptions

Postal Code Area Extensions to Marine Regions - Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. It helps to track 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 '_extract_date' column. It helps to uniquely identify each row.
geom_geojson	string	This column represents the geometric shape of the area in GeoJSON format.
geom_geotext	string	This column represents the geometric shape of the area in plain text format.
geom_type	string	This column specifies the type of the geometric shape of the area.
geom_centroid	string	This column represents the centroid point of the geometric shape of the area.
geom_center_x	double	This column represents the X coordinate of the center point of the geometric shape of the area.
geom_center_y	double	This column represents the Y coordinate of the center point of the geometric shape of the area.
gml_id	string	This column contains a unique identifier for each record in the data.
kunta	string	This column represents the code of the municipality.
kuntanro	long	This column represents the number of the municipality.
namn	string	This column represents the name of the area in Swedish language.
nimi	string	This column represents the name of the area in Finnish language.
objectid	long	This column contains a unique object identifier for each record in the data.
pinta_ala	long	This column represents the area size in square meters.
posti_alue	string	This column represents the postal code of the area.
vuosi	long	This column represents the year when the data was collected.

Version History of Postal Area Extensions to Sea Areas (Paavo)

Column	Type	Comment
_start_date	date	This column indicates the date when the row was extracted from the data source. This column along with '_row_number' uniquely identifies each row in this version history table.
_end_date	date	This column represents the date when a new version of the row was extracted from the data source. If this column's 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. It serves as a unique identifier in combination with the '_start_date'.
geom_geojson	string	This column contains geometric data in the GeoJSON format. It provides the geographical outline of an area based on the spatial data.
geom_geotext	string	This column holds the geometric data in a text format. It represents the geographic borders of an area in a readable format.
geom_type	string	This column specifies the type of the geometric data. For example, it could be a point, line, polygon, etc.
geom_centroid	string	This column holds the centroid point of the geometric shape that represents the geographical area of interest.
geom_center_x	double	This column contains the X coordinate of the central point of the geometric shape.
geom_center_y	double	This column contains the Y coordinate of the central point of the geometric shape.
gml_id	string	This column contains a unique identifier for the geographic markup language data.
kunta	string	This column represents the municipality code.
kuntanro	long	This column contains the number associated with the municipality.
namn	string	This column holds the name of the area in the local language.
nimi	string	This column contains the name of the area in Finnish.
objectid	long	This column holds a unique identifier for each row in the base table.
pinta_ala	long	This column represents the area size of the geographical region.
posti_alue	string	This column contains the postal code of the area.
vuosi	long	This column indicates the year when the data was recorded.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024