Regional Development Areas in Finland, 2019 (Scale: 1:4,500,000)
Click here for a data sample
The table is an organized collection of data that forms part of a larger dataset related to ELY areas in 2019 at a scale of 1:4,500,000. It is sourced from 'Tilastokeskus' (Statistics Finland) in Finland. Each row in the table represents a specific geographical area and includes a variety of data on that area. Two special columns, '_extract_date' and '_row_number', provide context for the data: the former shows when the data was extracted, the latter indicates the row number in the data extracted on the specified date. These two columns together uniquely identify each row. The table also contains multiple columns with geographic data, which can be used for geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the longitude given first, followed by the latitude. The table can be utilized in a number of ways for data analytics. For example, analysts could use the geographic data to map the distribution of ELY areas across Finland, or they could use the '_extract_date' column to track changes in the ELY areas over time.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data in the row was extracted from the source. This is a special column in the table. |
|---|
| _row_number | long | The row number in the data extracted from the source on the specific extract date. This is a special column in the table that, combined with the '_extract_date' column, uniquely identifies each row. |
|---|
| ely | string | A string representing the ELY code, which is a geographical identification code. |
|---|
| geom_geojson | string | A representation of the geographical shape of the ELY area in GeoJSON format. |
|---|
| geom_geotext | string | A textual representation of the geographical shape of the ELY area. |
|---|
| geom_type | string | The type of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns. For example, 'ST_MULTIPOLYGON' indicates that the shape is a multipolygon. |
|---|
| geom_centroid | string | The geographical coordinates of the centroid (geographical center) of the ELY area. |
|---|
| geom_center_x | double | The x-coordinate (longitude) of the centroid of the ELY area. |
|---|
| geom_center_y | double | The y-coordinate (latitude) of the centroid of the ELY area. |
|---|
| gml_id | string | A unique identifier for the row, provided in the GML format. |
|---|
| id | long | A unique identifier for each row in the table, represented as an integer. |
|---|
| name | string | The English name of the ELY center. |
|---|
| namn | string | The name of the ELY center in Swedish. |
|---|
| nimi | string | The name of the ELY center in Finnish. |
|---|
| vuosi | long | The year when the data was collected, represented as an integer. |
|---|
