Centres for Economic Development, Transport and the Environment (ELY) Areas, 2014 (Scale 1:4,500,000)
The table in question is a part of a larger dataset collection and contains data related to ELY-areas for the year 2014, sourced from the statistical center 'Tilastokeskus' in Finland. The table comprises various columns that include geographic, temporal, and descriptive data.
Among the columns, two special ones, '_extract_date' and '_row_number', form a unique identification for each row. The '_extract_date' column indicates the date when the particular data row was extracted from the source, and '_row_number' represents the row number in the data extracted on that particular date.
The table also includes geographic data in columns starting with 'geom_', which can be utilized for geospatial analytics. This geographic data, such as 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', represents various aspects of the geographical location and structure of the ELY-areas. These coordinates are presented using the WGS 84 coordinate reference system with axis order longitude first, followed by latitude.
The table also includes columns labeled 'ely', 'name', 'namn', 'nimi', and 'vuosi', which provide additional descriptive data. For example, 'name', 'namn', and 'nimi' provide the names of the ELY areas in different languages, and 'vuosi' indicates the year of the data.
Such a table can be utilized in various data analytics applications. For instance, the geospatial data can be used to map the ELY areas, track changes over time, or perform spatial analyses. The information could also be used to analyze trends or patterns related to specific ELY areas, potentially informing policy or decision-making in those regions.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column represents the date when the data on the row of the table was extracted from the data source. It is used together with the '_row_number' to uniquely identify each row. |
_row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This column is used in combination with '_extract_date' to uniquely identify each row. |
ely | string | This string column represents a certain entity or group in the dataset. |
geom_geojson | string | This column contains GeoJSON-formatted geographical data, representing the geographical boundaries of the entity or group represented in the 'ely' column. |
geom_geotext | string | This column contains geographical data in text format, similar to the data in 'geom_geojson' column but in a different format. |
geom_type | string | This column indicates the type of the geographical data stored in 'geom_geojson' and 'geom_geotext' columns. |
geom_centroid | string | This column contains the coordinates of the centroid point of the geographical area represented in 'geom_geojson' and 'geom_geotext' columns. |
geom_center_x | double | This column represents the X-coordinate of the center of the geographical area represented in 'geom_geojson' and 'geom_geotext' columns. |
geom_center_y | double | This column represents the Y-coordinate of the center of the geographical area represented in 'geom_geojson' and 'geom_geotext' columns. |
gml_id | string | This string column contains a unique identifier for each row in the table. |
name | string | This column contains the English name of the entity or group represented in the 'ely' column. |
namn | string | This column contains the name of the entity or group represented in the 'ely' column in a different language. |
nimi | string | This column contains the name of the entity or group represented in the 'ely' column in another different language. |
vuosi | long | This integer column represents the year related to the data in the row. |
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 | df77c157-c046-4892-9e7d-3d38684e1853 |
Package id | 4983d0b6-d6e0-4d62-beec-6bf06b6a11b4 |
Revision id | 906f6c02-b6b0-447d-a4de-3ee7d9648863 |
State | active |
Table | tilastointialueet_ely4500k_2014__table |