Centres for Economic Development, Transport and the Environment (1:4 500 000 scale) Data Table
The 'table' belongs to a dataset collection named 'tilastointialueet_ely4500k' and is a structured assembly of data composed of rows and columns. This table provides detailed information about ELY-areas at a scale of 1:4,500,000, sourced from the 'Tilastokeskus' website in Finland.
Each row in the table represents a unique entry, with the columns providing specifics about the entry. Key columns include identifiers such as 'id', 'name', 'namn', and 'nimi', which provide names of the ELY-centers in different languages. The 'ely' column provides a numerical identifier for these centers.
The columns starting with 'geom_' contain geographical data. For instance, 'geom_geojson' and 'geom_geotext' provide geographical coordinates in different formats, while 'geom_type' specifies the type of geographical shape that these coordinates form. The 'geom_centroid' column provides the geographical center of these shapes, and 'geom_center_x' and 'geom_center_y' provide the precise longitudinal and latitudinal coordinates of these centers. All geographical coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
Additionally, the table includes the columns '_extract_date' and '_row_number' which hold significant importance. The '_extract_date' column indicates the date when the data for a specific row was extracted, while the '_row_number' signifies the row number in the data extracted on the specified date. The combination of these two columns uniquely identifies each row in the table.
In terms of data analytics, this table can be utilized in various ways. The geographical data can be employed for geospatial analyses, enabling the study of patterns and trends across different ELY-areas. This could help in understanding spatial distribution and regional disparities, useful in urban planning and policy-making. The temporal data from the '_extract_date' column can be used for time-series analysis to study changes over time, aiding in predictive modeling and forecasting.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | Indicates the date when the data on the row of the table was extracted from the data source. This, combined with '_row_number', uniquely identifies each row. |
| _row_number | long | Contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This, combined with '_extract_date', uniquely identifies each row. |
| ely | string | Represents a code associated with each ELY Centre. ELY Centres are responsible for the regional implementation and development tasks of the central government in Finland. |
| geom_geojson | string | Holds the geographical data of the ELY Centre in GeoJSON format. This format encodes geographical features with a JSON format. The information can include polygons and multipolygons. |
| geom_geotext | string | Stores the geographical data of the ELY Centre in text format. This information represents the geographical boundaries of the ELY Centre. |
| geom_type | string | Specifies the type of geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. It can be either a polygon or a multipolygon. |
| geom_centroid | string | This column contains the centroid point of the geographical data represented in the 'geom_geojson' and 'geom_geotext' columns. The centroid is the geometric center of a plane figure or shape. |
| geom_center_x | double | Indicates the X-coordinate of the centroid point of the geographical data. |
| geom_center_y | double | Indicates the Y-coordinate of the centroid point of the geographical data. |
| gml_id | string | Represents a unique identifier for each row in the dataset. The identifier is in GML (Geography Markup Language) format. |
| id | long | An integer that serves as a unique identifier for each ELY Centre. |
| name | string | Contains the English name of each ELY Centre. |
| namn | string | Holds the Swedish name of each ELY Centre. |
| nimi | string | Contains the Finnish name of each ELY Centre. |
| vuosi | long | Represents the year when the data for the ELY Centre was collected or updated. |
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 | 7ce5773f-4cf8-4b59-aa91-cf16164b9fed |
| Package id | 5ebf616a-3ff5-4c46-aa02-7a3fe9038928 |
| Revision id | 1f8de592-bc93-4560-b0b4-17835e288213 |
| State | active |
| Table | tilastointialueet_ely4500k__table |