Statistics Interface Large Area Dataset 2015
Tables
-
Large Areas 2015: Detailed Geographic and Statistical Data (Scale 1:1 000 000)TSV
The table contains rich data that provides a detailed insight into the Major Regions of Finland in 2015. The data is sourced from the Statistics Finland (Tilastokeskus) website. Each row in the table represents a unique data entry, which is extracted on a specific date and identified by a unique row number. The data includes the region's name in Finnish, Swedish, and English, along with a unique identifier ('gml_id') for each region. The table holds geographical data with coordinates in the WGS 84 coordinate reference system. This includes MultiPolygon geographical data, the centroid point of the region, as well as the longitude ('geom_center_x') and latitude ('geom_center_y') of the region's center. The table also includes the area ('shape_star') and perimeter ('shape_stle') of each...
-
Version History of Major Areas 2015 (1:1 000 000)TSV
The table under consideration is a historical record, which is a part of a larger dataset. It encompasses various geographical and temporal aspects, tracking the evolution of its base data over a period of time. The data in the table is sourced from 'Tilastokeskus' (Statistic Centre), based in Finland. The table primarily contains data about major regions in Finland as of 2015, specifically captured at a scale of 1:1,000,000. The table is structured with a series of columns, each serving a unique purpose. For instance, some columns represent geographical data that can be used for geospatial data analytics. These include details such as geographical shapes, centroids, and center points, all represented in the WGS 84 coordinate reference system, with longitude presented before latitude....
Column Descriptions
Large Areas 2015: Detailed Geographic and Statistical Data (Scale 1:1 000 000)
Column | Type | Comment |
---|---|---|
_extract_date | date | This column records the date when the data on each row was extracted from the data source. |
_row_number | long | This column records the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
geom_geojson | string | This column contains the geometry of the area as a MultiPolygon in GeoJSON format. |
geom_geotext | string | This column contains the geometry of the area as a MultiPolygon in text format. |
geom_type | string | This column specifies the type of the geometry, which is a MultiPolygon. |
geom_centroid | string | This column contains the centroid of the MultiPolygon as a point. |
geom_center_x | double | This column records the x-coordinate of the center of the MultiPolygon. |
geom_center_y | double | This column records the y-coordinate of the center of the MultiPolygon. |
gml_id | string | This column represents the unique identifier for each row, formatted as 'suuralue1000k_2015' followed by a number. |
name | string | This column contains the name of the area in English. |
namn | string | This column contains the name of the area in Swedish. |
nimi | string | This column contains the name of the area in Finnish. |
shape_star | double | This column records a geometric parameter of the area, likely related to the size or shape. |
shape_stle | double | This column records another geometric parameter of the area, possibly related to the perimeter or complexity of the shape. |
suuralue | string | This column contains a numeric code representing the area. |
vuosi | double | This column records the year related to the data row, which is 2015 in all records in the dataset. |
Version History of Major Areas 2015 (1:1 000 000)
Column | Type | Comment |
---|---|---|
_start_date | date | This column represents the date when the row was extracted from the data source. This, in conjunction with '_row_number', uniquely identifies each row in the history table. |
_end_date | date | This contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
_row_number | long | The '_row_number' column contains the number of the row in the raw data extracted from the data source. It is part of the unique identifier for each row, along with '_start_date'. |
geom_geojson | string | This column contains geometric data in GeoJSON format, a common format for encoding a variety of geographic data structures. |
geom_geotext | string | The 'geom_geotext' column contains geometric data in text format. |
geom_type | string | This column specifies the type of geometric data contained in the row. In our case, it is 'ST_MULTIPOLYGON', indicating the data represents multiple polygons. |
geom_centroid | string | This column contains the centroid, or the geometric center, of the polygon represented in the 'geom_geojson' and 'geom_geotext' columns. |
geom_center_x | double | The 'geom_center_x' column represents the x-coordinate of the geometric center of the polygon. |
geom_center_y | double | This column represents the y-coordinate of the geometric center of the polygon. |
gml_id | string | This is an identifier for each row, which appears to incorporate the dataset name and an individual identifier for each area. |
name | string | The 'name' column contains the English name of the area represented by the row. |
namn | string | This column contains the name of the area in another language, possibly Swedish given the country of origin of the data. |
nimi | string | The 'nimi' column contains the name of the area in another language, likely Finnish, considering the data source's location. |
shape_star | double | This column contains a numeric value related to the shape of the area. The exact nature of this value is unclear without further context. |
shape_stle | double | Like 'shape_star', this column contains a numeric value related to the shape of the area. The exact meaning is unclear without additional information. |
suuralue | string | The 'suuralue' column seems to be a categorical variable, possibly indicating a larger administrative area that each row belongs to. |
vuosi | double | The 'vuosi' column contains the year associated with the data in each row, likely indicating the year the data was collected or is relevant for. |
Additional Info
Last Updated | November 12, 2024 |
---|---|
Created | November 11, 2024 |