ELY Areas 2023: Geospatial Information at 1:1 000 000 Scale
The table, part of the dataset collection, represents the ELY (Centre for Economic Development, Transport and the Environment) areas in Finland for the year 2023, as indicated by the Finnish Statistical Central Office (Tilastokeskus). The data is organized into various columns that include unique identifiers, geographical descriptions, and other relevant information.
Each row in the table is uniquely identified by a combination of the extract date and the row number, indicating the date when the data was extracted and its sequence in the extraction process. The geographic information, stored in the columns that start with 'geom_', is crucial for geospatial data analytics. These details are represented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table contains a variety of geographic data types, such as polygons and multipolygons, which describe the shape and layout of the ELY areas. These geographical details, in tandem with the central points of these areas, give a comprehensive geographic portrayal of each ELY area.
In addition to the geographic data, the table also includes an identification code, and names of the ELY centres in different languages, which could be used to gain linguistic insights or for internationalization purposes.
From a data analytics perspective, this table offers several avenues for exploration. For example, the geographic data could be used to visualize the ELY areas on a map, which could aid in regional planning or environmental studies. The extract date and row number could help in tracking changes in the data over time, providing insights into temporal trends. Furthermore, the multilingual names could be used in analytics for multicultural communication strategies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the row's data was extracted from the data source. It provides a way to understand when the data was last updated. The date is in the format YYYY-MM-DD. |
| _row_number | long | This column contains the row number of the extracted data, which combined with the '_extract_date' column, can be used to uniquely identify each row in the table. |
| ely | string | This column refers to a code, likely representing a specific geographic area or entity within Finland. |
| geom_geojson | string | This column contains geographical data in GeoJSON format, a common format used for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geographical data in text format. This could be coordinates or other forms of spatial data. |
| geom_type | string | This column specifies the type of geographical data stored in the row. The types include 'ST_MULTIPOLYGON' and 'ST_POLYGON', indicating complex geographic structures. |
| geom_centroid | string | This column contains the centroid of the geographical object. The centroid is the geometric center of a plane figure or shape. |
| geom_center_x | double | This column contains the x-coordinate (longitude) of the geographical object's center. |
| geom_center_y | double | This column contains the y-coordinate (latitude) of the geographical object's center. |
| gml_id | string | This column contains a unique identifier for each row. It appears to include a reference to the dataset collection ('ely1000k_2023') and a unique code. |
| id | long | This column contains an integer identifier for each row. It may be used for indexing and referencing purposes. |
| name | string | This column contains the English name of the entity associated with the row. The names seem to correspond to different regions or entities within Finland. |
| namn | string | This column contains the name of the entity in another language, likely Swedish, considering Finland's bilingual status. |
| nimi | string | This column contains the name of the entity in Finnish. |
| vuosi | long | This column contains the year associated with the data in the row. The sample year is 2023, indicating that the data is either projected or current up to that year. |
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 | 8c777388-db6f-4a4b-9c94-e5077bca17d3 |
| Package id | d350c534-87b3-4f33-86c4-37c2b1e10e90 |
| Revision id | f5bf2a8f-456e-4015-b1ac-17636011ac7c |
| State | active |
| Table | tilastointialueet_ely1000k_2023__table |