1. Home
  2. Datasets
  3. 2015 Regional Statistics Area ...
To download the data set, please sign up or log in

2015 Regional Statistics Area Collection

This dataset collection is an organized grouping of related tables, sourced from 'Tilastokeskus' (Statistics Finland), a reputable website in Finland. The data tables contain related data organized in a structured format of rows and columns. The dataset collection is essentially a resource from the Statistical Service Interface (WFS) of 'Tilastokeskus'. It provides an array of information that could be utilized for various analytical and statistical purposes. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

  • Regional Units 2015 (Scale 1:1,000,000) Dataset TableTSV

    The table contains geospatial data about the regions in Finland as of 2015, sourced from 'Tilastokeskus' (Statistics Finland). Each row in the table represents a distinct region, identified by a combination of the extraction date and the row number. The table provides comprehensive geographic details about each region, including geospatial details in GeoJSON and GeoText formats, a centroid point, and the center coordinates. These geospatial details follow the WGS 84 coordinate reference system, with the longitude listed first, followed by the latitude. Other details include the name of the region in various languages and the region's code. The data in this table could be utilized in several ways in data analytics. For example, it could be used to analyze geographic distribution and...

  • Version History of Regional Units 2015 (1:1 000 000)TSV

    The 'table__history' is a comprehensive historical data table within the 'tilastointialueet_seutukunta1000k_2015' dataset. It serves as a version history of its base table, which is essentially a presentation of regions in Finland for the year 2015 at a scale of 1:1 000 000. The table contains several unique columns that are key in data management and geospatial analytics. The table assigns a unique identifier for each row, based on the row number in the raw data extracted from the data source. This, coupled with the start date of the row, forms a combination that uniquely identifies each row in this version history table. The start and end dates indicate the period during which a particular version of the row was active, with a null end date signifying that the row is the most recent...

Column Descriptions

Regional Units 2015 (Scale 1:1,000,000) Dataset Table

Column Type Comment
_extract_date date This column records the date when the data in each row was extracted. It plays a crucial role in uniquely identifying each row in combination with the '_row_number' column.
_row_number long This column contains the row number from the data extracted on the date specified in the '_extract_date' column. This, in conjunction with '_extract_date', helps to uniquely identify each row.
geom_geojson string This column stores the geographical data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext string This column contains geographical data represented as text, specifically in the form of MULTIPOLYGONs, which are used to define complex shaped geospatial objects.
geom_type string This column indicates the type of geometric object contained in the row. In the given sample, the type is 'ST_MULTIPOLYGON', suggesting complex shaped geospatial objects.
geom_centroid string This column represents the geometric center, or centroid, of the geospatial data as a point. This can be particularly useful for geographic computations.
geom_center_x double This column contains the X coordinate of the geometric center of the geospatial object.
geom_center_y double This column contains the Y coordinate of the geometric center of the geospatial object.
gml_id string This column contains a unique identifier for each geospatial feature, which is useful for linking and cross-referencing data.
name string This column contains the name of the region in the local language.
namn string This column contains the name of the region, potentially in a different local language or dialect.
nimi string This column also contains the name of the region, potentially in yet another local language or dialect.
seutukunta string This column contains a code representing the region. This can be useful for categorizing and grouping the data.
shape_star double This column contains data related to the shape of the geospatial object, though the specific meaning of this data is not clear from the provided information.
shape_stle double This column also contains data related to the shape of the geospatial object, though the specific meaning of this data is not clear from the provided information.
vuosi double This column contains real type data, which in the given sample is 2015.0. It could potentially indicate the year associated with the data.

Version History of Regional Units 2015 (1:1 000 000)

Column Type Comment
_start_date date This column records the date that each row was extracted from the data source, helping to track the version history of the base table rows.
_end_date date This column records the date when a new version of a row was extracted from the data source. If the value is null, it indicates that the row is the most recent version.
_row_number long This column contains the number of the row as it appears in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in the history table.
geom_geojson string This column stores the geographical data associated with each row in GeoJSON format, a widely-used format for encoding a variety of geographic data structures.
geom_geotext string This column contains the geometrical data in text format, specifically in the form of MultiPolygons, which are used to represent a region with multiple boundaries.
geom_type string This column specifies the type of the geometry object associated with each row, in this case, 'ST_MULTIPOLYGON'.
geom_centroid string This column contains the coordinates of the centroid (geometric center) of the geographical region represented by the row.
geom_center_x double This column contains the x-coordinate (longitude) of the geometric center of the geographical region associated with each row.
geom_center_y double This column contains the y-coordinate (latitude) of the geometric center of the geographical region associated with each row.
gml_id string This unique identifier is a string that represents a specific geographical region.
name string This column contains the English names of the geographical regions represented by each row.
namn string This column contains the names of the geographical regions in another language, providing multilingual support.
nimi string This column contains an alternative representation of the names of the geographical regions, providing further multilingual support.
seutukunta string This column contains a string representation of a specific geographical area.
shape_star double This column represents a real number associated with the geometrical shape of the region.
shape_stle double This column represents another real number associated with the geometrical shape of the region.
vuosi double This column contains a real number representation associated with each row, which might indicate a year or a similar time-related concept.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024