Large Districts 2020 (Scale 1:4 500 000) - Data Table
The table in focus, belonging to the dataset collection 'tilastointialueet_suuralue4500k_2020', features data concerning large areas in 2020 at a 1:4,500,000 scale, sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. The table is structured into various columns, each bearing distinct information about the data.
Columns like 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' carry geographic information that could be instrumental for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, where longitude is followed by latitude.
Other columns like 'name', 'namn', and 'nimi' provide the names of the large areas in various languages, offering a multi-lingual perspective. Meanwhile, the 'gml_id' column contains unique identifiers for each area, and the 'suuralue' and 'vuosi' columns respectively contain codes for the large areas and the year of data collection.
Two special columns, '_extract_date' and '_row_number', provide a timeline and ordering of the data. The former records the date when the data was pulled from the source, while the latter assigns a unique row number for each data extraction. These two columns combined uniquely identify each row in the table.
This table can be utilized in several ways for data analytics. For example, it could be used to analyze geographical trends over time by comparing data from different '_extract_date'. It could also support multilingual research or marketing strategies by leveraging the language-specific area names. Additionally, the geospatial data can be used to create comprehensive maps or for spatial analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data row was extracted from the source. It helps track when the specific data was recorded. |
| _row_number | long | This column contains the row number of the data extracted from the source. Together with '_extract_date', it uniquely identifies each row in the table. |
| geom_geojson | string | This column contains the geometric data in GeoJSON format. It can be used to represent spatial features and their attributes. |
| geom_geotext | string | This column contains geometric data in text format, specifically as a multipolygon. This information can be used for spatial analysis. |
| geom_type | string | This column specifies the type of geometric data contained in the table. In this case, the type is ST_MULTIPOLYGON. |
| geom_centroid | string | This column contains the central point of each geographical feature in the table, represented as a point. This is useful for identifying the center of each spatial feature. |
| geom_center_x | double | This column contains the x-coordinate of the center of each geographical feature. It is part of the spatial data in the table. |
| geom_center_y | double | This column contains the y-coordinate of the center of each geographical feature. This is another component of the spatial data in the table. |
| gml_id | string | This column contains an identifier for each row. It is a string and can be used to uniquely identify each geographical feature. |
| name | string | This column contains the English name of the geographical area represented by the row. |
| namn | string | This column contains the name of the geographical area in Swedish. It is equivalent to the 'name' column but in a different language. |
| nimi | string | This column contains the name of the geographical area in Finnish. It is equivalent to the 'name' column but in a different language. |
| suuralue | string | This column contains an identifier for the large area of the geographical feature. It is a string and can be used to group or categorize the data. |
| vuosi | long | This column contains an integer representing the year of the data. This can be used to track changes over time. |
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 | 5c64ec56-71c7-47d9-b985-c47d9c88e909 |
| Package id | ebde98ed-de64-4cfa-8f20-3953043d5e76 |
| Revision id | c6796977-a6f2-4576-b6d3-b0f08de40b9b |
| State | active |
| Table | tilastointialueet_suuralue4500k_2020__table |