Regional Units 2019 - Geographic Data at 1:4 500 000 Scale
Click here for a data sample
The table is a comprehensive collection of related data that provides details about statistical regions for the year 2019 at a scale of 1:4,500,000, sourced from the 'Tilastokeskus' website in Finland. It comprises of various columns, each representing unique information. There are two special columns: one indicating the date when the data was extracted, and the other specifying the unique row number for each extraction. These two columns together form a unique identifier for each data row. The table also includes a variety of geographic details, which allows for in-depth geospatial data analysis. These geographic attributes are represented using the WGS 84 coordinate reference system, with longitude first, followed by latitude. The information in the table could prove valuable in a number of data analytics applications. For instance, it could facilitate regional planning and development, contribute to demographic studies, or aid in monitoring regional disparities. This data could also be utilized to map regional trends over time, given the inclusion of the extraction date.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column represents the date when the row's data was extracted from the source. The format of the dates is YYYY-MM-DD. |
|---|
| _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 column, in combination with '_extract_date', uniquely identifies each row. |
|---|
| geom_geojson | string | This column contains the geometric data in GeoJSON format. GeoJSON is a type of data format used for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains the geometric data in text format. This format is useful for visualizing the data in applications that do not support GeoJSON. |
|---|
| geom_type | string | This column describes the type of the geometric data. The sample value 'ST_MULTIPOLYGON' indicates that the geometric data represents multiple polygons. |
|---|
| geom_centroid | string | This column contains the centroid of the geometric data. The centroid is the geometric center of the shape. |
|---|
| geom_center_x | double | This column contains the X coordinate of the geometric center. |
|---|
| geom_center_y | double | This column contains the Y coordinate of the geometric center. |
|---|
| gml_id | string | This column contains a unique identifier for each row. The ID is a combination of the dataset name and a unique number. |
|---|
| name | string | This column contains the name of the statistical area in English. |
|---|
| namn | string | This column contains the name of the statistical area in Swedish. |
|---|
| nimi | string | This column contains the name of the statistical area in Finnish. |
|---|
| seutukunta | string | This column contains the code of the statistical area. This is a unique identifier used by the Finnish statistical authority. |
|---|
| vuosi | long | This column represents the year that the data pertains to. The data in the sample is from 2019. |
|---|
