Large Areas 2014 (Scale 1:1 000 000) - Data Table
Click here for a data sample
The table in question contains a range of data relating to large regions in Finland as of 2014. Each row of the table exclusively represents one large region, with the data extracted from the Finnish Statistics Bureau (Tilastokeskus) website. One of the key features of this table is its ability to deliver geospatial and geographical statistics. This includes geographical coordinates, which adhere to the WGS 84 coordinate reference system, with longitude presented first, followed by latitude. The geospatial data is presented in a variety of formats, such as geojson and geotext. The data includes the center coordinates of the region, with the type of geographical shape also indicated. Additionally, the table provides the names of these regions in multiple languages, including English, Swedish, and Finnish. Other details are also included, such as the year the data was recorded and a unique identifier for each region. A unique aspect of this table is the inclusion of two special columns, '_extract_date' and '_row_number'. The former indicates the date on which the data for the specific row was extracted, while the latter indicates the row number from the original data source. These two columns together uniquely identify each row in the table. With such rich information, this table can be utilized in various data analytics scenarios. For instance, it can be used to analyze demographic trends across different regions, or to conduct geospatial analyses to understand the geographical distribution of population or resources. Furthermore, the multi-lingual naming of the regions can aid in cross-cultural studies or international research collaborations.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. It helps in tracking when the data was last updated. |
|---|
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It helps in uniquely identifying each row. |
|---|
| geom_geojson | string | This column holds the geometric data in GeoJSON format, a popular open standard format designed for representing simple geographical features. |
|---|
| geom_geotext | string | This column stores the geometric data in text format, which is useful for visualizing complex geographical features. |
|---|
| geom_type | string | This column indicates the type of the geometric data. For instance, it can show that the data is of type 'ST_MULTIPOLYGON'. |
|---|
| geom_centroid | string | This column contains the centroid point of the geographical feature represented in the row. The centroid is the geometric center of a shape. |
|---|
| geom_center_x | double | This column holds the longitude of the center point of the geographic feature. |
|---|
| geom_center_y | double | This column holds the latitude of the center point of the geographic feature. |
|---|
| gml_id | string | This column contains the Global Monitoring for Environment and Security (GMES) identifier for the geographical feature. |
|---|
| name | string | This column contains the English name of the geographic area. |
|---|
| namn | string | This column contains the Swedish name of the geographic area. |
|---|
| nimi | string | This column contains the Finnish name of the geographic area. |
|---|
| suuralue | string | This column contains a numeric identifier for the large area (suuralue) that the geographical feature belongs to. |
|---|
| vuosi | long | This column holds the year associated with the data row, which can be useful for temporal analysis. |
|---|
