Regional Units 2014 (1:1 000 000) - Extracted Data
Click here for a data sample
The table in question is part of a dataset collection focused on statistical regions in Finland from the year 2014. Sourced from 'Tilastokeskus' (Statistics Finland), the table provides a comprehensive set of information regarding these regions. It includes geographic details such as coordinates, geojson and geotext data, and geometric types and centroids, all of which are applicable for geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, where the order is always longitude first, followed by latitude. In addition to the geographic data, the table also provides the names of the regions in multiple languages and an identifier for each region. The data content of this table could be utilized in several ways. For instance, it could be used for regional analysis, giving insights into various phenomena based on geographical location. It could also be useful in demographic studies, where population data could be organized and analyzed based on these regions. Moreover, the geographic data could be used in creating detailed maps or models of the country. The table also includes special columns such as '_extract_date' and '_row_number'. The '_extract_date' column indicates when the data was extracted, and the '_row_number' column provides a unique identifier for each row. This combination allows for a unique identification of each row.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the row data was extracted from the source. It helps to identify the freshness of the data. |
|---|
| _row_number | long | This column contains the unique row number of the data as it was extracted from the source. This, in combination with '_extract_date', can be used to uniquely identify each row. |
|---|
| geom_geojson | string | This column contains the geometric data of the area in GeoJSON format, a popular open standard format designed for representing simple geographical features. |
|---|
| geom_geotext | string | This column contains the geometric data of the area in geotext format. Essentially, it is the textual representation of the geometric data. |
|---|
| geom_type | string | This column describes the type of the geometric data represented. For example, it contains values like 'ST_MULTIPOLYGON' indicating that the geographical area is represented as a multipolygon. |
|---|
| geom_centroid | string | This column contains the centroid or the geometric center of the area. It is represented as a point value. |
|---|
| geom_center_x | double | This column contains the X coordinate of the center of the geographical area. |
|---|
| geom_center_y | double | This column contains the Y coordinate of the center of the geographical area. |
|---|
| gml_id | string | This column contains a unique identifier for each geographical area. |
|---|
| name | string | This column contains the English name of the geographical area. |
|---|
| namn | string | This column contains the name of the geographical area in the local language. |
|---|
| nimi | string | This column contains another local name for the geographical area. |
|---|
| seutukunta | string | This column contains specific codes associated with each geographical area. |
|---|
| vuosi | long | This column represents the year corresponding to the data row. It helps to identify the temporal context of the data. |
|---|
