Regions 2014 - Detailed Geographic Data (1:1 000 000)
Click here for a data sample
The table, which is part of the dataset collection 'tilastointialueet_maakunta1000k_2014', contains detailed information about the 'Regions of 2014' in Finland. The information is sourced from 'Tilastokeskus' (Statistics Finland). The columns of the table provide a range of data including extraction dates, row numbers, and geographic details, as well as specific regional identifiers and names in multiple languages. The geographic details are presented using the WGS 84 coordinate reference system, with the longitude first, followed by the latitude. This could be utilized for geospatial data analytics. For instance, one could use this data to analyze regional trends over the years, or to study the geographic distribution of certain phenomena in Finland. Two special columns, '_extract_date' and '_row_number', provide unique identifiers for each row with the former indicating the extraction date of the data, and the latter denoting the row number in the extracted data. This combination of extraction date and row number ensures that each row in the table can be uniquely identified.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the row's data was extracted from the data source. The dates are formatted in the YYYY-MM-DD format. |
|---|
| _row_number | long | This column contains the row number in the data extracted from the source. Combined with '_extract_date', it uniquely identifies each row. |
|---|
| geom_geojson | string | This column contains the geographical representation of the data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains the geographical data in text format. The sample values suggest that it contains multipolygon data. |
|---|
| geom_type | string | This column describes the type of the geographical data. In this case, it's of type 'ST_MULTIPOLYGON'. |
|---|
| geom_centroid | string | This column contains the centroid of the geographical data. The centroid is the center point of the geographical object. |
|---|
| geom_center_x | double | This column represents the X coordinate of the center of the geographical object. |
|---|
| geom_center_y | double | This column represents the Y coordinate of the center of the geographical object. |
|---|
| gml_id | string | This is a technical identifier of the geographical object. |
|---|
| maakunta | string | This column contains a code representing a province. |
|---|
| name | string | This column contains the English name of the province. |
|---|
| namn | string | This column contains the name of the province in Swedish. |
|---|
| nimi | string | This column contains the name of the province in Finnish. |
|---|
| vuosi | long | This column contains the year of the data. The sample values suggest that the year is represented as an integer. |
|---|
