Provinces 2018 (Scale 1:4 500 000) - Geographic and Demographic Details
Click here for a data sample
The table in question is a rich source of geographic and demographic data. It contains information about regions in the country, specifically from the year 2018. Each row in the table represents a unique region, identified by its own unique combination of extraction date and row number. The geographic characteristics of each region are well-documented in the table, with geographic information such as a GeoJSON representation of the region's shape, a geotext version of the same, the centroid of the region, and the coordinates of the center. This geographic information is presented using the WGS 84 coordinate reference system, where the longitude comes before the latitude. Each region is also identified by a unique GML ID, a code, and names in various languages. The extraction date and row number columns serve as a unique identifier for each row of data. This table was sourced from the 'Tilastokeskus' website from Finland. The data in this table can be utilized in numerous ways in data analytics. For example, changes in geographic characteristics of regions over time could be tracked and analyzed. The data could also be used to analyze regional demographic trends, which can inform policy decisions and business strategies. Additionally, the geographic data can be used in geospatial data analytics to create visual representations of the data, which can provide further insights into regional characteristics and trends.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. |
|---|
| _row_number | long | This column contains the row number in the data extracted from the source. It, in combination with '_extract_date', uniquely identifies each row. |
|---|
| geom_geojson | string | This column contains geometric data in geojson format, which describes the spatial characteristics of the entities. |
|---|
| geom_geotext | string | This column contains geometric data in text format. It complements the 'geom_geojson' column by providing geometric information in a different format. |
|---|
| geom_type | string | This column indicates the type of the geometric data. |
|---|
| geom_centroid | string | This column indicates the geometric center or centroid of the spatial entity. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the spatial entity. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the spatial entity. |
|---|
| gml_id | string | This column contains a unique identifier for each spatial entity. |
|---|
| maakunta | string | This column contains a string representing the region or province. |
|---|
| name | string | This column contains the English name of the region or province. |
|---|
| namn | string | This column contains the name of the region or province in another language. |
|---|
| nimi | string | This column contains the name of the region or province in another language. |
|---|
| vuosi | long | This column contains an integer indicating the year to which the data pertains. |
|---|
