Large Areas 2018 (1:1 000 000) - Data Table from Finnish Statistical Data Collection
This table, part of the 'tilastointialueet_suuralue1000k_2018' dataset collection, houses detailed information about the Large Areas of 2018 (1:1 000 000) in Finland. The data originates from 'Tilastokeskus' (Statistics Finland). The table is structured with a variety of columns, each hosting specific types of data.
Among the contents of the table, there are two special columns: '_extract_date' and '_row_number'. The former indicates the date when the specific row's data was extracted, while the latter represents the row number in the data extracted on that particular date. These two columns together establish a unique identifier for each row.
The dataset also includes several columns that begin with 'geom_', representing geographic information. This data is crucial for geospatial data analytics, presenting geographic coordinates using the WGS 84 coordinate reference system, with the axis order being longitude first, then latitude.
The table further includes columns detailing the name of the areas in different languages, the year, and a unique identifier for each area.
This dataset could be utilized in multiple ways for data analytics. For instance, it could be used to analyze regional trends or patterns over time, given the year column. The geospatial data can be used to create geographic visualizations or to conduct spatial analysis, such as studying the proximity of areas to certain facilities or services. Furthermore, the multilingual columns offer opportunities for international studies or investigations into linguistic demographics.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted. It helps track when each record was pulled from the source. |
| _row_number | long | This column contains the row number in the data as it was extracted from the source. In combination with '_extract_date', each row can be uniquely identified. |
| geom_geojson | string | A representation of geographic objects in GeoJSON format. This can include features such as points, lines, and polygons. |
| geom_geotext | string | A geometrical representation of the data in text format. It compliments the 'geom_geojson' column and provides a readable format of the same data. |
| geom_type | string | Specifies the type of the geometry. For example, in our table, it indicates that the geometry is of type 'ST_MULTIPOLYGON'. |
| geom_centroid | string | The centroid or the geometric center of a shape. It is calculated as the average of all points in the shape. |
| geom_center_x | double | The X-coordinate of the geometric center of a shape. |
| geom_center_y | double | The Y-coordinate of the geometric center of a shape. |
| gml_id | string | This is a unique identifier for each row in the table. |
| name | string | The English name of the geographical area. |
| namn | string | The name of the geographical area in Swedish. |
| nimi | string | The name of the geographical area in Finnish. |
| suuralue | string | A coded representation of a geographical area. |
| vuosi | long | Year of the data record. In our table, all records are from the year 2018. |
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 | b287ebbd-02be-4af5-9ff6-232082c7ffea |
| Package id | e3100c5c-13aa-426b-b60b-92ef9005de70 |
| Revision id | 3b6a54bf-3783-44d2-9b34-f3dffae75718 |
| State | active |
| Table | tilastointialueet_suuralue1000k_2018__table |