2014 ELY Areas (Scale 1:1 000 000) - Extracted Data Table
The table 'table' is a part of the 'tilastointialueet_ely1000k_2014' dataset collection. This table holds structured data related to the ELY areas in Finland for the year 2014. The data is sourced from the Statistics Finland ('Tilastokeskus') web site.
Each row in the table represents a specific ELY area, identified by a unique row number and an extraction date when the data was retrieved. The ELY area is identified by a code in the 'ely' column. The name of the ELY Centre is provided in three different languages: English ('name'), Swedish ('namn'), and Finnish ('nimi').
The geographic information about each ELY area is represented by multiple columns starting with 'geom_'. These columns contain geographic data in multiple formats like GeoJSON, GeoText, and centroid coordinates. This geospatial data, presented using the WGS 84 coordinate reference system, can be utilized for geospatial data analytics. For example, the columns 'geom_center_x' and 'geom_center_y' indicate the longitude and latitude respectively of the geometric center of each ELY area.
In data analytics, this table can provide valuable insights. For example, it could be used to analyze regional trends or to create visual representations of data on a map based on the geospatial data. Furthermore, by leveraging the date of extraction, one could track changes and developments over time. The multi-lingual naming of the ELY Centres can also facilitate international studies or research that involves multiple languages.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | The date when the data on the row of the table was extracted from the Statistics Finland (Tilastokeskus) database. This column helps in tracking the history of the data. |
| _row_number | long | The number of the row in the data extracted from the source on the extract date specified by the column '_extract_date'. This column, in combination with '_extract_date', uniquely identifies each row. |
| ely | string | A string identifier representing a specific region in Finland. This information is crucial for regional analysis. |
| geom_geojson | string | The geographical coordinates of the ELY Centre, represented in GeoJSON format. This data is important for geospatial analysis and visualizations. |
| geom_geotext | string | The geographical boundaries of the ELY Centre, represented in geotext format. This information is used in mapping and geographical analysis. |
| geom_type | string | The type of the geographical object represented in the 'geom_geojson' and 'geom_geotext' columns. This column helps in understanding the type of geographical data being used. |
| geom_centroid | string | The geographical coordinates of the centroid of the ELY Centre region. This data is crucial for geographical analysis and mapping. |
| geom_center_x | double | The X coordinate of the centroid of the ELY Centre region. This information is crucial for geographical analysis and mapping. |
| geom_center_y | double | The Y coordinate of the centroid of the ELY Centre region. This information is crucial for geographical analysis and mapping. |
| gml_id | string | A unique identifier for each row, which includes information about the year and the respective ELY Centre. |
| name | string | The English name of the ELY Centre. This information helps in understanding the data in an international context. |
| namn | string | The Swedish name of the ELY Centre. This information helps in understanding the data in a Swedish-speaking context. |
| nimi | string | The Finnish name of the ELY Centre. This information helps in understanding the data in a Finnish-speaking context. |
| vuosi | long | The year when the data was recorded. This column is important for temporal analysis of the data. |
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 | 9df0d7ef-de95-48c6-a31c-b70069f2ded6 |
| Package id | bc1301fc-df2a-40ff-b865-ad1543edd33c |
| Revision id | f8d9a82b-f374-4c75-96fe-bd888fa025d3 |
| State | active |
| Table | tilastointialueet_ely1000k_2014__table |