Regional Division of Finland - ELY Areas 2019 Scaled 1:1 000 000
The table under consideration is a part of a dataset collection that compiles related tables. This specific table is packed with valuable information pertaining to the ELY-areas for the year 2019, as indicated by the data source. This data is key to understanding the geography and administrative divisions of Finland, as sourced from the Finnish statistical authority, 'Tilastokeskus'.
The table includes a range of columns, each providing unique insights into the ELY-areas. To understand when the data was extracted from the source, one can refer to the '_extract_date' column, while the '_row_number' gives a sequence to the extracted data, with each row being uniquely identifiable by a combination of these two columns. Examples of other columns include identifiers for the ELY-areas, their names in multiple languages, and the year of the data.
A standout feature of this table is the inclusion of geospatial data. With columns providing geographic information, this table is a useful resource for geospatial data analytics. These columns include geographic coordinates presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This allows for a precise mapping of the ELY-areas.
Given the rich content of this table, there are several applications in data analytics. For instance, one could track changes in administrative divisions over time by comparing '_extract_date' across years. Furthermore, the geographic information can be utilized in advanced geospatial analytics to study spatial patterns and trends. The multilingual names of the ELY-areas also open up possibilities for cross-cultural studies and comparisons.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This is a special column that records the date when the data on the row of the table was extracted from the source. It helps in tracking the timeline of data extraction. |
| _row_number | long | This is another special column that records the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This, in combination with '_extract_date', uniquely identifies each row. |
| ely | string | This string type column represents certain codes, perhaps related to regional or organizational identifiers. |
| geom_geojson | string | This column contains geographical data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column seems to contain geographic data represented in a textual format, likely corresponding to the GeoJSON data in the 'geom_geojson' column. |
| geom_type | string | This column specifies the type of the geographic data represented in the 'geom_geojson' and 'geom_geotext' columns. In the given sample, it is 'ST_MULTIPOLYGON' which suggests the data represents multiple polygonal areas. |
| geom_centroid | string | This column contains the coordinates of the centroid, or geometric center, of the geographic area represented in the row. |
| geom_center_x | double | This column records the X-coordinate (longitude) of the geographic center of the area represented in the row. |
| geom_center_y | double | This column records the Y-coordinate (latitude) of the geographic center of the area represented in the row. |
| gml_id | string | This string type column contains unique identifiers for each row, perhaps related to the data source or the geographic area represented. |
| id | long | This is an integral column that provides a unique numerical identifier for each row. |
| name | string | This string column contains names, possibly of geographical regions or organizations, in English. |
| namn | string | This is a string column that appears to contain names similar to those found in the 'name' column, but in a different language, possibly Finnish or Swedish. |
| nimi | string | This is another string column that holds names similar to those in the 'name' and 'namn' columns, but in another language, possibly Finnish. |
| vuosi | long | This integral column records a year, possibly the year the data in the row was collected or pertains to. |
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 | eef5d045-0dab-428d-a50a-fddeac92b90e |
| Package id | 1ed301ad-8f0f-4052-b018-30371ca19450 |
| Revision id | c68369ef-1b5e-4551-9fcc-627a42d51838 |
| State | active |
| Table | tilastointialueet_ely1000k_2019__table |