Large Areas Statistical Dataset (1:4 500 000 Scale)
The table is part of a dataset collection that holds information on different geographical areas at a 1:4,500,000 scale. The data in this table provides a rich set of information, including geographical identifiers, detailed geographical information, and names of the areas in various languages. This dataset is sourced from the 'Tilastokeskus' website, based in Finland.
The table consists of unique identifiers for each row that are determined by a combination of the date when the data was extracted and a row number. This allows for each row to be uniquely identified and tracked over time. The table also contains geographical data, encoded in various formats, including GeoJSON and GeoText. The geographical data present in this table is based on the WGS 84 coordinate reference system, with the order of the coordinates being longitude followed by latitude.
In addition to geographical information, the table also includes the names of the areas in three different languages, providing a multilingual representation of the data. Additionally, the table includes a year column, which could be used to track changes over time.
There are many potential uses for this data in analytics. For example, the geographical data could be used to analyze spatial patterns or trends, such as population distributions or land use patterns. The multilingual names could be used in applications designed for international users or for studies on language diversity. The year column could be used to track changes in these patterns over time, providing insights into historical trends or predicting future developments.
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 to track 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 column '_extract_date'. It helps to uniquely identify each row. |
| geom_geojson | string | This column contains geometric data in geojson format, which represents geographical features. |
| geom_geotext | string | This column contains geometric data in text format, providing a textual representation of the geographical features. |
| geom_type | string | This column specifies the type of geometric data present in the table, for example, 'ST_MULTIPOLYGON' indicates that the data represents multiple polygonal areas. |
| geom_centroid | string | This column contains the geometric center or centroid of the geographical feature. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the geographical feature. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the geographical feature. |
| gml_id | string | This column contains a unique identifier for the geographical feature, which can be used for reference and linking. |
| name | string | This column contains the name of the geographical feature in English. |
| namn | string | This column contains the name of the geographical feature in the Swedish language. |
| nimi | string | This column contains the name of the geographical feature in the Finnish language. |
| suuralue | string | This column contains a numerical value representing a specific larger area, possibly a region or district code. |
| vuosi | long | This column contains the year related to the data, which could indicate when the data was collected or the year the data is relevant for. |
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 | a4cf3721-78ac-450a-ab72-6c251031804f |
| Package id | b2d6af9f-eb94-4459-86da-b8a5704b846c |
| Revision id | 4fa90929-0692-4ef6-8255-23056b854401 |
| State | active |
| Table | tilastointialueet_suuralue4500k__table |