Regional Units Statistical Data (Scale 1:4,500,000)
The table originates from the 'Tilastokeskus' website, based in Finland. It holds a collection of data pertaining to regional districts, classified at a 1:4 500 000 scale. The table is part of a larger dataset, illustrating the interconnection and relevance of the data across multiple tables.
The data within the table is organized into several columns, each representing a specific attribute of the regional districts. Two special columns, '_extract_date' and '_row_number', are used to uniquely identify each row. The '_extract_date' indicates the date when the corresponding data was extracted, and '_row_number' denotes the position of the row in the extraction sequence.
A significant portion of the table's data is geographical, represented in columns beginning with 'geom_'. This includes geospatial data such as polygons or multipolygons, centroid points, and x-y coordinates for the district center. This geographic information is based on the WGS 84 coordinate reference system, with longitude presented first, followed by latitude, offering potential for geospatial data analytics.
The table also contains columns for the district's names in different languages, and a unique identifier for each district. Furthermore, there is a column indicating the year, which could be used for understanding changes over time.
This table could be utilized in various ways in data analytics. For example, the geographic data could be used for visualizing district boundaries on a map and studying spatial relationships. The temporal data could be leveraged to identify trends or changes in regional data over time. Moreover, the linguistic data could support multilingual analysis or localization efforts.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column contains the date on which the data row was extracted from the data source. The format of the date is YYYY-MM-DD. |
_row_number | long | This column contains the row number corresponding to the data extracted from the source on the date specified in the '_extract_date' column. This column, in combination with the '_extract_date' column, uniquely identifies each row. |
geom_geojson | string | This column contains geometrical data in the GeoJSON format. The GeoJSON data represents various geometrical shapes, such as polygons and multipolygons. |
geom_geotext | string | This column contains geometrical data in the text format. The data represents various geometrical shapes, such as polygons and multipolygons. |
geom_type | string | This column contains the type of the geometrical shape represented in the 'geom_geojson' and 'geom_geotext' columns. |
geom_centroid | string | This column contains the coordinates of the centroid of the geometrical shape represented in the 'geom_geojson' and 'geom_geotext' columns. |
geom_center_x | double | This column contains the X-coordinate of the center of the geometrical shape represented in the 'geom_geojson' and 'geom_geotext' columns. |
geom_center_y | double | This column contains the Y-coordinate of the center of the geometrical shape represented in the 'geom_geojson' and 'geom_geotext' columns. |
gml_id | string | This column contains a unique identifier for each row. |
name | string | This column contains the name of the region in English. |
namn | string | This column contains the name of the region in Swedish. |
nimi | string | This column contains the name of the region in Finnish. |
seutukunta | string | This column contains a code that represents a specific region. |
vuosi | long | This column contains the year corresponding to the data row. |
No sample for this dataset
Additional Information
Last updated | November 11, 2024 |
---|---|
Created | November 11, 2024 |
License | No License Provided |
Geographic coverage | |
Geographic granularity | |
Temporal coverage from | |
Temporal coverage to | |
Temporal coverage to | |
Country | fi |
Database | fi_tilastokeskus |
Extract date | 2024-11-11 |
Id | 9771c053-a9de-40a5-8a5f-a1e0d8920948 |
Package id | 14de74bf-ca9f-4e5d-bdb7-d2244cc7cf77 |
Revision id | 433c2766-af85-442a-80e0-a70d5208cca8 |
State | active |
Table | tilastointialueet_seutukunta4500k__table |