ELY Regions 2016 (Scale 1:1 000 000) - Data Table
Click here for a data sample
The table, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland), provides comprehensive data on ELY-areas (Centre for Economic Development, Transport and the Environment) for the year 2016 at a scale of 1:1,000,000. It includes various columns with a mix of geographical and textual data. The geographical data is 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 data analytics, enabling the visualization and analysis of ELY-areas on a map. For example, one could examine the distribution of these areas across Finland, or analyze spatial patterns and trends over time. The table also includes textual data, such as the Finnish, Swedish, and English names of the ELY-centres. This could be used, for instance, in a multilingual application or research that requires the names of these areas in different languages. Two special columns, '_extract_date' and '_row_number', uniquely identify each row. The '_extract_date' column specifies when the data was extracted, and the '_row_number' column indicates the row's position in the data extracted on that particular date.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date data was extracted from the source, serving to provide a historical context to the data. Each row of data is associated with a specific extraction date. |
|---|
| _row_number | long | This column contains the row number in the data extracted from the source. Combined with '_extract_date', it uniquely identifies each row. |
|---|
| ely | string | This column contains a code that represents a specific area in Finland. |
|---|
| geom_geojson | string | This column contains the geometric data of the area in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains the geometric data of the area in textual format. |
|---|
| geom_type | string | This column describes the type of geometric data contained in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_centroid | string | This column contains the geographic coordinates of the centroid or geometric center of the area. |
|---|
| geom_center_x | double | This column contains the X coordinate (longitude) of the geometric center of the area. |
|---|
| geom_center_y | double | This column contains the Y coordinate (latitude) of the geometric center of the area. |
|---|
| gid | long | This column contains a unique identifying number for each area. |
|---|
| gml_id | string | This column contains a unique identification string that is used in Geography Markup Language (GML). |
|---|
| name | string | This column contains the English name of the area. |
|---|
| namn | string | This column contains the name of the area in Swedish. |
|---|
| nimi | string | This column contains the name of the area in Finnish. |
|---|
| vuosi | double | This column contains the year of the data. |
|---|
