Regional Development and Administration Agencies in Finland 2021 (Scale: 1:4,500,000)
The table in question, part of the 'tilastointialueet_ely4500k_2021' dataset collection, is a compilation of data concerning ELY areas for the year 2021 at a scale of 1:4,500,000. Originating from the Finnish website 'Tilastokeskus' (Statistics Finland), this table provides a detailed view into various aspects of these areas.
The table is equipped with a set of columns capturing unique and valuable data points. There are columns capturing geographical data, which can be extremely handy for geospatial data analytics. These columns begin with 'geom_' and include geographic coordinates presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
Two special columns in the table, '_extract_date' and '_row_number', play a crucial role in the dataset. The former contains the date when the data on the row was extracted, while the latter indicates the row's position in the extracted data. The combination of these two columns serves to uniquely identify each row.
Apart from this, the table includes columns that contain identifiers for the ELY areas, the names of these areas in various languages (including Finnish, Swedish and English), and the year of data capture.
This table could be utilized in several ways for data analytics. For instance, one could analyze the geographical distribution of the ELY areas, or track changes in the ELY areas over time by using the '_extract_date' and 'vuosi' (year) columns. Additionally, the multi-language name columns could be used to investigate linguistic patterns or trends across the ELY areas.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | The date when the data on the row of the table was extracted. This is a special column that, in combination with '_row_number', uniquely identifies each row. For example, a value could indicate that the data was extracted on November 11, 2024. |
| _row_number | long | The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This is a special column that, in combination with '_extract_date', uniquely identifies each row. For instance, a value could be 60, 92, 22, 88, or 50. |
| ely | string | A string identifier related to the data. Sample values include '13', '09', '02', '08', and '16'. |
| geom_geojson | string | Contains complex geometric data in the GeoJSON format. This could include a variety of geometric shapes like MultiPolygons and Polygons. |
| geom_geotext | string | Contains complex geometric data in text format. This often parallels the 'geom_geojson' column, including shapes like MultiPolygons and Polygons. |
| geom_type | string | Specifies the type of geometric data contained in the 'geom_geojson' and 'geom_geotext' columns. This could be, for example, 'ST_MULTIPOLYGON' or 'ST_POLYGON'. |
| geom_centroid | string | Specifies the geometric center, or centroid, of the shape described in the 'geom_geojson' and 'geom_geotext' columns. This is often represented as a 'POINT' with corresponding coordinates. |
| geom_center_x | double | Represents the x-coordinate of the centroid of the geometric shape described in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_y | double | Represents the y-coordinate of the centroid of the geometric shape described in the 'geom_geojson' and 'geom_geotext' columns. |
| gml_id | string | A string type identifier related to the data. This could be a unique identifier for each row in the table. |
| id | long | An integer type identifier that can be related to the data. This could be a unique identifier for each row in the table. |
| name | string | A string type column containing names related to the data. Sample values could include names of different ELY Centres or regions. |
| namn | string | A string type column containing names related to the data, possibly in a different language than the 'name' column. |
| nimi | string | A string type column containing names related to the data, possibly in a different language than both the 'name' and 'namn' columns. |
| vuosi | long | An integer type column containing years related to the data. For instance, it could indicate the year the data was collected or refers 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 | fa370851-4758-4be6-8f3a-607d01bf54cd |
| Package id | b2856a12-0623-481e-a7f1-7cb45c0acb22 |
| Revision id | be949852-cf18-4c86-8115-0d101222f0a8 |
| State | active |
| Table | tilastointialueet_ely4500k_2021__table |