Regions of the ELY Centres in Finland for 2024 at 1:1 Million Scale
Click here for a data sample
The table in question forms part of a wider dataset collection related to ELY areas in 2024 at a scale of 1:1 000 000. Sourced from the website of Statistics Finland ('Tilastokeskus') in Finland, the table contains various pieces of data organized into rows and columns. Each row of data is uniquely identified by a combination of the extraction date and row number. This allows for precise tracking and referencing of data changes over time. The table also contains several geographical columns, useful for geospatial data analytics. These geographical data points, indicated by the prefix 'geom_', are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. These include data points such as the geojson, geotext, and type of the geographical area, as well as the coordinates of the centroid and the center. Other columns in the table provide further details about the area, including its ELY code, ID, name in different languages, and the year the data pertains to. The data in this table could be used in a variety of ways for data analytics. For instance, the geographic data could be used to analyze trends in different ELY areas over time, spot correlations between geographical factors and other variables, or even to create detailed maps and visualizations of the data. Meanwhile, the other columns could be used to conduct more targeted analyses of specific ELY areas. Ultimately, the rich dataset provided in this table offers many opportunities for deep, insightful analysis.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the data in each row was extracted from the source. It forms a unique identifier for each row when combined with the '_row_number' column. |
|---|
| _row_number | long | This column contains the row number, unique to the extracted data from the source on a specific extract date as indicated by the '_extract_date' column. |
|---|
| ely | string | This column contains a string representation of the ELY (Centre for Economic Development, Transport and the Environment) code. |
|---|
| geom_geojson | string | This column contains the geometric data of the ELY region in GEOJSON format. |
|---|
| geom_geotext | string | This column contains the geometric data of the ELY region in a text format. |
|---|
| geom_type | string | This column specifies the type of the geometric data, such as 'ST_MULTIPOLYGON' or 'ST_POLYGON'. |
|---|
| geom_centroid | string | This column provides the centroid, or geometric center, of the ELY region. |
|---|
| geom_center_x | double | This column provides the X-coordinate of the geometric center of the ELY region. |
|---|
| geom_center_y | double | This column provides the Y-coordinate of the geometric center of the ELY region. |
|---|
| gml_id | string | This column contains the unique GML identifier for each row. |
|---|
| id | long | This column contains an integer identifier. |
|---|
| name | string | This column contains the English name of the ELY center. |
|---|
| namn | string | This column contains the name of the ELY center in another language. |
|---|
| nimi | string | This column contains the Finnish name of the ELY center. |
|---|
| vuosi | long | This column contains the year (as an integer) associated with the data row. |
|---|
