ELY Areas Data Table (Scale 1:1 000 000)
The table, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland), is a structured collection of data, part of the 'tilastointialueet_ely1000k' dataset. It contains information on ELY areas (Centres for Economic Development, Transport and the Environment) at a scale of 1:1,000,000, offering a comprehensive overview of these entities within Finland.
The table contains several columns, each offering unique insights into the ELY areas. For instance, there are columns indicating unique identifiers, names of the ELY centres in various languages, and the year of data extraction. Specific columns like 'ely', 'name', 'namn', 'nimi', 'vuosi' offer detailed information about the ELY centres such as their ID, their Finnish and other language names, and the year of the data.
Geographic information plays a key role in the table, with several columns starting with 'geom_' offering geospatial data. These include 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', which provide data in GeoJSON format, textual representation of the geometry, type of the geometry, centroid of the geometry and the x and y coordinates of the geometric center. This information is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
Two special columns, '_extract_date' and '_row_number', offer additional granularity. The '_extract_date' column holds the date when the data on the row was extracted, while the '_row_number' provides the row number in the extracted data. Together, these two columns uniquely identify each row in the table.
The data in this table can be utilized in several ways in data analytics. For instance, the geospatial data can be used to analyze the geographic distribution of ELY centres, their proximity to each other, or to significant landmarks. The '_extract_date' and '_row_number' can be used to track changes in the data over time. The multilingual name columns can support multilingual analytics or localization efforts.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column holds the date on which the specific row of data was extracted from the source. It helps in understanding when the data was last updated. |
| _row_number | long | This column contains the sequential row number from the data extracted from the source, unique for each extraction date. It helps in identifying each row of data uniquely in combination with the extract date. |
| ely | string | This column stores a coded string representation related to a specific region or area. |
| geom_geojson | string | This column holds the geographical data in GeoJSON format, representing the geography of the region or area in a spatial format that can be easily processed. |
| geom_geotext | string | This column contains the geographical data in a text format, which can be used to represent the geographical area or region. |
| geom_type | string | This column indicates the type of geometric data stored, such as 'ST_MULTIPOLYGON' or 'ST_POLYGON', giving an idea about the complexity of the geographical area represented. |
| geom_centroid | string | This column holds the geographical central point of the area or region represented, in POINT format. |
| geom_center_x | double | This column contains the X coordinate of the geographical center of the area or region represented. |
| geom_center_y | double | This column contains the Y coordinate of the geographical center of the area or region represented. |
| gml_id | string | This column holds a unique identifier for each row in GML (Geography Markup Language) format. |
| id | long | This column stores an integer value that serves as a unique identifier for each row of data. |
| name | string | This column contains the English name of the region or area represented in the data. |
| namn | string | This column holds the Swedish name of the region or area represented in the data. |
| nimi | string | This column contains the Finnish name of the region or area represented in the data. |
| vuosi | long | This column holds an integer value representing the year pertaining to 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 | ce5f51d9-be64-4782-bfc4-46f5ff8896de |
| Package id | 1b043ec5-a599-41de-b4d1-f7e8a3d4ba13 |
| Revision id | 691da156-f00d-483c-8950-c4ca685b66e9 |
| State | active |
| Table | tilastointialueet_ely1000k__table |