ELY Areas 2021 - Scaled 1:1,000,000
The table is a component of a structured dataset collection, which comprises data related to the ELY-areas for the year 2021 at a scale of 1:1 000 000, sourced from the 'Statistics Finland' ('Tilastokeskus') website, located in Finland. The table contains several fields, including unique identifiers, geographic data, and descriptive information about each ELY-area.
The geographic data, embedded in fields that begin with 'geom_', is crucial for geospatial analytics. It includes various forms of geographic information, such as GeoJSON data, geotext, geographic data type, geographic centroid, and coordinates of the geographic center. This geo-information is presented using the WGS 84 coordinate reference system, with the axis order of longitude followed by latitude.
The table also contains fields for unique identifiers such as 'ely', 'gml_id', and 'id', and descriptive information about each ELY-area, stored in fields like 'name', 'namn', and 'nimi'. Moreover, 'vuosi' indicates the year of the data.
Two special fields, '_extract_date' and '_row_number', play a unique role in this table. The '_extract_date' field denotes the date when the data was extracted, while the '_row_number' field represents the row number in the extracted data. The combination of '_extract_date' and '_row_number' uniquely identifies each row in the table.
With this rich array of data, the table could be utilized in several ways within data analytics. For instance, the geospatial data could be used for geographic visualizations or spatial analysis of ELY-areas. The unique identifiers and descriptive information could be used for statistical analysis or trend forecasting related to the ELY-areas.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This special column stores the date when the data on each row was extracted from the data source. The format is YYYY-MM-DD. |
| _row_number | long | This special column stores the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. Together with '_extract_date', this column uniquely identifies each row. |
| ely | string | This column contains a string type code representing different regions. |
| geom_geojson | string | This column contains geographical data in GeoJSON format, which represents different geographical shapes. |
| geom_geotext | string | This column stores geographical data as text. It represents different geographical shapes similar to the 'geom_geojson' column. |
| geom_type | string | This column indicates the type of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns. It can be either ST_MULTIPOLYGON or ST_POLYGON. |
| geom_centroid | string | This column contains the central point of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns. It is stored as a POINT type. |
| geom_center_x | double | This column contains the x-coordinate of the central point in the geographical shape. |
| geom_center_y | double | This column contains the y-coordinate of the central point in the geographical shape. |
| gml_id | string | This column contains a unique string identifier for the data row. |
| id | long | This column contains a unique integer identifier for the data row. |
| name | string | This column contains the English names of different regions. |
| namn | string | This column contains the names of different regions in other languages. |
| nimi | string | This column contains the names of different regions in Finnish language. |
| vuosi | long | This column contains the year when the data was collected. The format is YYYY. |
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 | 15bc9b85-1a99-4dc1-83a3-21c1fa183203 |
| Package id | e2ce37b8-ab43-45bf-8847-ac261f96df9d |
| Revision id | d03c9dcc-26ef-4115-bdfe-f21cf7c6c920 |
| State | active |
| Table | tilastointialueet_ely1000k_2021__table |