Statistical Areas 2014 (Scale 1:4 500 000)
The table provides data on AVI regions in 2014, at a scale of 1:4,500,000. This data is part of a larger collection of related tables, indicating a comprehensive approach to data organization. Key features of the table include temporal data, geographical coordinates, and specific regional information.
The table includes a unique pair of columns, '_extract_date' and '_row_number', which together provide a precise reference point for each row of data. For instance, '_extract_date' specifies the date the data was extracted and '_row_number' indicates the row's position in the extracted data.
Geographical information is a significant part of the table content. Columns starting with 'geom_' contain geographical data, which can be analyzed for spatial patterns and trends, such as regional differences or changes over time. These coordinates are presented in the WGS 84 coordinate reference system, with longitude first, followed by latitude, allowing for accurate global positioning and compatibility with various geospatial data analytics tools.
The table also includes columns dedicated to regional identifiers and names in different languages, which can be used to cross-reference with other datasets for a multi-lingual analysis. For example, the 'name' column provides the English name of the AVI region, while 'namn' and 'nimi' provide the names in other languages.
This data, sourced from the 'Tilastokeskus' website from Finland, can be utilized in numerous ways. For instance, by analyzing the geographical information, one could identify potential correlations between regional characteristics and other variables. Additionally, the temporal data from the '_extract_date' column could be used to study trends and changes over time in the AVI regions. Similarly, the regional names in different languages could support a linguistics study or help in creating multilingual reports or visualizations.
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 plays a crucial role in identifying each row of data uniquely in combination with the '_row_number' column. |
| _row_number | long | This column contains the row number for the data extracted from the source. It is used in conjunction with the '_extract_date' column to uniquely identify each row of data. |
| avi | string | This column signifies a unique string identifier. |
| geom_geojson | string | This is a geographical data column in GeoJSON format, representing geographical features. |
| geom_geotext | string | This is a geographical data column in geotext format, representing geographical features. |
| geom_type | string | This column specifies the type of the geography stored in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column records the centroid point of the geographical object being represented. |
| geom_center_x | double | This column represents the X coordinate of the center point of the geographical object. |
| geom_center_y | double | This column represents the Y coordinate of the center point of the geographical object. |
| gml_id | string | This column stores unique identification strings. |
| name | string | This column stores the name of the geographical area in English. |
| namn | string | This column stores the name of the geographical area in a foreign language. |
| nimi | string | This column stores the name of the geographical area in another foreign language. |
| vuosi | long | This column indicates the year associated with the data 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 | 1908e1db-0331-4ca6-9e46-c81f298ff22f |
| Package id | e6878ebf-4b1e-4333-9c23-673f00dc4955 |
| Revision id | c3712e69-787f-43c2-bdef-56e2ed963747 |
| State | active |
| Table | tilastointialueet_avi4500k_2014__table |