ELY Regions 2017 (1:4 500 000) - Data Table
The table encapsulates data pertaining to the ELY Centres in Finland for the year 2017, as sourced from the 'Statistics Finland' (Tilastokeskus) website. Each row of the table represents an individual ELY Centre, with relevant information organized in various columns.
The table provides geographic information for each ELY Centre. This includes the geographic shape ('geom_geojson', 'geom_geotext'), type of geometry ('geom_type'), centroid of the geographic shape ('geom_centroid'), and the geographic center coordinates ('geom_center_x', 'geom_center_y'). The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This geographic information can be utilized for geospatial analytics, such as spatial pattern detection, spatial clustering, or spatially explicit predictive modeling.
Each ELY Centre is also identified by an 'ely' code, a unique 'gid', and a 'gml_id'. Additional information about the ELY Centre is provided in multiple languages ('name', 'namn', 'nimi'), which can be useful for multilingual data analytics or localization initiatives.
The table also includes the year ('vuosi') the data pertains to. This allows for temporal analytics, to analyze changes over time or to create time series models.
Every row in the table has a unique identifier, which is a combination of the date when the data was extracted ('_extract_date') and the row number ('_row_number') in the extracted data. This is essential for data management, ensuring data integrity and enabling precise data retrieval and manipulation.
Given the rich geographic and multilingual information, this table can be utilized in several data analytics applications. For instance, it can support geospatial analyses to understand spatial patterns or trends among ELY Centres. It could also facilitate multilingual studies or support localization efforts in Finland. Additionally, the temporal aspect of the data can be leveraged to analyze changes in ELY Centres over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | The date when the data on the row was extracted from the data source. This, in combination with '_row_number', uniquely identifies each row. |
| _row_number | long | 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 | A string code representing a specific region, as defined by the source. |
| geom_geojson | string | Geospatial data in GeoJSON format, typically representing the geometry of the region identified by the 'ely' code. |
| geom_geotext | string | Geospatial data in a textual format, typically representing the geometry of the region identified by the 'ely' code. |
| geom_type | string | The type of the geospatial data represented in 'geom_geojson' and 'geom_geotext'. |
| geom_centroid | string | The geospatial coordinates of the centroid of the region represented by the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_x | double | The x-coordinate of the center of the region represented by the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_y | double | The y-coordinate of the center of the region represented by the 'geom_geojson' and 'geom_geotext' columns. |
| gid | long | An integer identifier, possibly corresponding to the region represented by the 'ely' code. |
| gml_id | string | A unique string identifier for each row, provided by the source. |
| name | string | The English name of the region represented by the 'ely' code. |
| namn | string | The name of the region represented by the 'ely' code in another language. |
| nimi | string | The name of the region represented by the 'ely' code in another language, possibly Finnish. |
| vuosi | double | A real number, possibly representing the year of data collection. |
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 | 10a58b4c-13ee-4bba-8e0c-51c51d137d0a |
| Package id | 1eec9fe4-c9ef-4a96-9772-83e8e7d2fdd6 |
| Revision id | 06fbc677-d81d-480b-99b1-2fb5a49ce13f |
| State | active |
| Table | tilastointialueet_ely4500k_2017__table |