Regional Units (1:1 000 000) from Finnish Statistics Dataset Collection
The table in question hails from the dataset collection 'tilastointialueet_seutukunta1000k' and contains a variety of valuable information. The contents of the table, sourced from the 'Tilastokeskus' website in Finland, are primarily built around regions (Seutukunnat) at a 1:1,000,000 scale. This essentially means that the data within this table is closely related to regional statistics and geospatial data in Finland.
The table is composed of a variety of columns, each serving its own unique purpose. There are two special columns: '_extract_date' and '_row_number'. The former includes the date when the data on the row was extracted from the source, while the latter contains the row number in the extracted data. These two columns in combination uniquely identify each row.
In addition to these, there are several columns beginning with 'geom_' which hold geographic information. This data can be valuable for geospatial data analytics, providing insights into regional patterns, trends, and anomalies. It's important to note that the geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table also includes columns for names in different languages, which could be useful for international studies or comparisons. For instance, a study could compare how regional names change across languages or how the geospatial data for these regions compares.
In terms of data analytics, this table could be utilised in numerous ways. For example, researchers could use the geospatial data to examine patterns in regional development, identify areas of interest for further research, or even to make predictions for future changes in these regions. Alternatively, policy makers could use this data to inform decision-making processes, such as where to allocate resources or how to plan for future infrastructure projects.
In summary, this is a rich and versatile table that could serve as a valuable resource for a wide range of data analytics projects, particularly those involving geospatial data or regional studies in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. The format of the date is YYYY-MM-DD. |
| _row_number | long | This column contains the row number of the data extracted from the source on the extract date specified by the column '_extract_date'. This column along with the '_extract_date' column uniquely identifies each row. |
| geom_geojson | string | This column contains the geographic data in GeoJSON format. The data represents the geographic area related to the other data in the row. |
| geom_geotext | string | This column contains the geographic data in text format. The data represents the geographic area related to the other data in the row. |
| geom_type | string | This column describes the type of the geographic data stored in the 'geom_geojson' and 'geom_geotext' columns. The types can be either ST_MULTIPOLYGON or ST_POLYGON. |
| geom_centroid | string | This column contains the geographic coordinates of the centroid of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns. The format of the data is POINT (longitude latitude). |
| geom_center_x | double | This column contains the longitude of the centroid of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_y | double | This column contains the latitude of the centroid of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns. |
| gml_id | string | This column contains a unique identifier for the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns. |
| name | string | This column contains the English name of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns. |
| namn | string | This column contains the Swedish name of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns. |
| nimi | string | This column contains the Finnish name of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns. |
| seutukunta | string | This column contains a unique code for the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns. |
| vuosi | long | This column contains the year associated with the data in the 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 | 4bd3c661-1705-4593-8998-a119b71cfb9b |
| Package id | df82fc7a-ab24-48d0-ab22-437044422a04 |
| Revision id | 7f748d0a-275c-44b1-97eb-864ec1a433ff |
| State | active |
| Table | tilastointialueet_seutukunta1000k__table |