Regions 2017 (1:4 500 000) - Organized Data Collection
The table, a part of the 'tilastointialueet_seutukunta4500k_2017' dataset, contains detailed geospatial data, specifically pertaining to the 2017 Regional Units at a scale of 1:4 500 000. This intricate data, sourced from the 'Tilastokeskus' website in Finland, offers a wealth of information suitable for a variety of data analytics. It encompasses unique identifiers for each data row along with the date of data extraction, and a range of geographic details that can be leveraged for geospatial data analytics.
For instance, the columns beginning with 'geom_' house geographic coordinates and types, such as 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These fields provide data in formats like GeoJSON and GeoText, with geographic types clearly identified, along with centroid and center coordinates. All geographic coordinates are presented using the WGS 84 coordinate reference system, with longitude first, followed by latitude.
In addition, the table contains columns that identify the name of the region in various languages, including 'name', 'namn', and 'nimi', and the year of data as 'vuosi'. The column 'seutukunta' provides a specific regional code.
In terms of data analytics, this table could be instrumental in various ways. For instance, the geospatial data can be used to create detailed maps, analyze regional trends, or identify patterns in data distribution across different regions. The data can also be used to track changes over time, leveraging the '_extract_date' and 'vuosi' fields. The multi-language name fields can be used to create region-specific analytics in various languages.
Finally, the special column '_extract_date' provides the date when the data was extracted, and '_row_number' gives the row number in the extracted data. Together, these columns uniquely identify each row in the table, offering a reliable way to reference specific data points.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This is a special column that contains the date when the data on the row was extracted from the source. It helps in tracking the historical data extraction process. |
| _row_number | long | This is another special column that contains the row number in the data extracted from the source, as per the extract date specified by the '_extract_date' column. Together, these two columns uniquely identify each row. |
| geom_geojson | string | This column contains geographical data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column holds the geographical data in text format. The data represents multiple polygons that define the geographical boundaries. |
| geom_type | string | This column specifies the type of the geographical data contained in the 'geom_geojson' and 'geom_geotext' columns. In this case, it is a multipolygon type. |
| geom_centroid | string | This column contains the centroid of the geographical area represented by the multipolygon. The centroid is the geometric center of a two-dimensional shape. |
| geom_center_x | double | This column holds the X coordinate of the center of the geographical area represented by the multipolygon. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geographical area represented by the multipolygon. |
| gml_id | string | This column contains a unique identifier for each row, possibly related to the geographical data. |
| name | string | This column contains the English name of the geographical area represented by the multipolygon. |
| namn | string | This column contains the name of the geographical area in another language, which could be local or regional. |
| nimi | string | This column also holds the name of the geographical area in another language. |
| seutukunta | string | This column contains some form of code or identifier related to the geographical area. |
| vuosi | double | This column contains real-type data, possibly indicating a year or time-related aspect. |
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 | 692cdaaf-f746-403a-b3f5-86ee3ffac157 |
| Package id | a5b92f04-1729-418e-a6a4-aac804b56807 |
| Revision id | 8b36d70e-64d8-4e0f-9d23-548e5315baec |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2017__table |