Provinces 2015 (1:4 500 000) - Dataset Collection of Finnish Statistical Regions
The table in question belongs to a dataset collection that captures geospatial information related to the administrative regions of Finland in 2015. The data is sourced from 'Tilastokeskus' (Statistics Finland), the national statistical institution of Finland. The table contains various columns that store a wealth of information about each region.
The data in the table can be broken down into three main categories - geographic, identification, and shape data. The geographic data, including geospatial coordinates and geographic type, is stored in columns that start with 'geom_'. This data is presented using the WGS 84 coordinate reference system, which uses longitude and latitude to pinpoint locations. This information could be used for geospatial data analytics, such as plotting the regions on a map or calculating the distance between them.
The identification data, found in columns such as 'name', 'namn', and 'nimi', provides different names for each region in various languages. This can be useful for creating multilingual representations of the data or for cross-referencing with other datasets.
The shape data, contained in 'shape_star' and 'shape_stle', gives information about the physical characteristics of each region. The 'shape_star' column provides the area size of the region while the 'shape_stle' column provides the perimeter length. This information could be used to analyze the physical characteristics of each region, for instance, comparing their sizes or evaluating the compactness of their shapes.
In addition to these, the table also contains two special columns - '_extract_date' and '_row_number'. The '_extract_date' column provides the date when the row data was extracted, while the '_row_number' represents the unique row number on that extract date. This combination uniquely identifies each row, which is important for tracking data changes over time. For instance, if the data is extracted periodically, these columns could be used to analyze trends or changes in the region data over time.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column indicates the date when the data on the row of the table was extracted from the source. This, along with '_row_number' column, helps in uniquely identifying each row. |
_row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This, in combination with '_extract_date' column, uniquely identifies each row. |
geom_geojson | string | This column contains geographical information in GeoJSON format, a format for encoding a variety of geographic data structures. |
geom_geotext | string | This column stores the geographic data as text. It is a representation of the geographical region. |
geom_type | string | This column contains the type of the geographical data, which in this dataset is usually a multi-polygon. |
geom_centroid | string | This column contains the point that represents the geometric center of the region. |
geom_center_x | double | This column represents the x-coordinate of the geometric center of the region. |
geom_center_y | double | This column represents the y-coordinate of the geometric center of the region. |
gml_id | string | This column holds a unique identifier for each record. |
maakunta | string | This column contains the codes for the regions or provinces in Finland. |
name | string | This column contains the English names of the regions or provinces. |
namn | string | This column contains the Swedish names of the regions or provinces. |
nimi | string | This column contains the Finnish names of the regions or provinces. |
shape_star | double | This column contains the area size of each region. |
shape_stle | double | This column contains the perimeter length of each region. |
vuosi | double | This column contains the year of the data, which in this dataset, is the year 2015. |
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 | 8a891647-13f3-433a-a893-c83f054ab903 |
Package id | cc7aa84b-9dd6-4f7c-9df8-317e1901f9bc |
Revision id | 3501c7f7-5915-45dc-bea8-209b7b86d60c |
State | active |
Table | tilastointialueet_maakunta4500k_2015__table |