Statistical Area Large Scale 1000K 2014
Tables
-
Large Areas 2014 (Scale 1:1 000 000) - Data TableTSV
The table in question contains a range of data relating to large regions in Finland as of 2014. Each row of the table exclusively represents one large region, with the data extracted from the Finnish Statistics Bureau (Tilastokeskus) website. One of the key features of this table is its ability to deliver geospatial and geographical statistics. This includes geographical coordinates, which adhere to the WGS 84 coordinate reference system, with longitude presented first, followed by latitude. The geospatial data is presented in a variety of formats, such as geojson and geotext. The data includes the center coordinates of the region, with the type of geographical shape also indicated. Additionally, the table provides the names of these regions in multiple languages, including English,...
-
Version History of Large Areas 2014 (1:1 000 000)TSV
The 'table__history' is a version history table that is part of a larger dataset collection. This table provides a historical record of data related to the 'Large Areas 2014 (1:1 000 000)' dataset, containing data on various large geographical areas. The table houses data on each row's unique extraction date, the date when a new version of the row was extracted, and the row number in the raw data from the source, which are identified by the special columns '_start_date', '_end_date', and '_row_number' respectively. A combination of '_start_date' and '_row_number' uniquely identifies each row in this table. The table also contains a wealth of geographic information in columns starting with 'geom_', which can be utilized for geospatial data analytics. This includes data on the type of...
Column Descriptions
Large Areas 2014 (Scale 1:1 000 000) - Data Table
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. It helps in tracking when the data was last updated. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It helps in uniquely identifying each row. |
| geom_geojson | string | This column holds the geometric data in GeoJSON format, a popular open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column stores the geometric data in text format, which is useful for visualizing complex geographical features. |
| geom_type | string | This column indicates the type of the geometric data. For instance, it can show that the data is of type 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column contains the centroid point of the geographical feature represented in the row. The centroid is the geometric center of a shape. |
| geom_center_x | double | This column holds the longitude of the center point of the geographic feature. |
| geom_center_y | double | This column holds the latitude of the center point of the geographic feature. |
| gml_id | string | This column contains the Global Monitoring for Environment and Security (GMES) identifier for the geographical feature. |
| name | string | This column contains the English name of the geographic area. |
| namn | string | This column contains the Swedish name of the geographic area. |
| nimi | string | This column contains the Finnish name of the geographic area. |
| suuralue | string | This column contains a numeric identifier for the large area (suuralue) that the geographical feature belongs to. |
| vuosi | long | This column holds the year associated with the data row, which can be useful for temporal analysis. |
Version History of Large Areas 2014 (1:1 000 000)
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column records the date when the row was extracted from the data source. It helps to keep track of the version history of the row. |
| _end_date | date | This column records the date when a newer version of the row was extracted from the data source. If the value is null, it indicates that the row is the most current version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the source. It is used in combination with the '_start_date' column to uniquely identify each row in this history table. |
| geom_geojson | string | This column stores the geographical data in GeoJSON format, which represents simple geographical features. |
| geom_geotext | string | This column stores the geographical data in geotext format, providing a readable representation of the geographical features. |
| geom_type | string | This column specifies the type of the geographical object, for instance, 'ST_MULTIPOLYGON' indicates the object is a multi-polygon. |
| geom_centroid | string | This column contains the centroid point of the geographical object, providing a central location of the geographical feature. |
| geom_center_x | double | This column records the X-coordinate of the center of the geographical object. |
| geom_center_y | double | This column records the Y-coordinate of the center of the geographical object. |
| gml_id | string | This column contains a unique identifier for each geographical object. |
| name | string | This column contains the English names of the regions in Finland. |
| namn | string | This column contains the Swedish names of the regions in Finland. |
| nimi | string | This column contains the Finnish names of the regions in Finland. |
| suuralue | string | This column contains numerical codes representing the large regions of Finland. |
| vuosi | long | This column records the year the data was collected. |
Additional Info
| Last Updated | November 12, 2024 |
|---|---|
| Created | November 11, 2024 |