Statistics Interface (WFS) Dataset Collection 2015
Tables
-
Regional Division of Finland (ELY) - 2015 Statistical Data TableTSV
The table presents data pertaining to the ELY areas (Centres for Economic Development, Transport and the Environment) in Finland for the year 2015, at a scale of 1:1,000,000. The data in this table is compiled from the website of the Finnish Statistical Bureau, 'Tilastokeskus' (Statistics Finland), offering a wealth of information for various geographical and statistical analyses. The table features numerous columns, each containing specific types of data. Columns within the table provide geographic details, including geojson, geotext, type, centroid, center x and y coordinates, all of which adhere to the WGS 84 coordinate reference system. These columns contain geographic coordinates represented with longitude first, followed by latitude, making them valuable resources for geospatial...
-
Version History of ELY Areas 2015 (1:1 000 000)TSV
The 'table__history' is a historical data table that is part of the 'tilastointialueet_ely1000k_2015' dataset collection. It contains the version history of its base table rows. The data content of the table relates to ELY-areas 2015 (1:1 000 000), as provided by the data source, Tilastokeskus, in Finland. The table includes a variety of columns that capture information such as the date when the row was extracted from the source and the row's unique identifier. Some columns capture geographic data, useful for geospatial analytics. This includes data about the type, centroid, center x and y coordinates, presented in the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The table also includes the name of the ELY centers in different languages and...
Column Descriptions
Regional Division of Finland (ELY) - 2015 Statistical Data Table
Column | Type | Comment |
---|---|---|
_extract_date | date | This column indicates the date when the data on the row of the table was extracted from the data source. |
_row_number | long | This column represents the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
ely | string | This column contains string values representing ELY centre codes. |
geom_geojson | string | This column stores the geometrical data in GeoJSON format. |
geom_geotext | string | This column holds geometrical data in text format. The data describes various shapes, such as multipolygons. |
geom_type | string | This column states the type of the geometric object stored in the table, e.g., ST_MULTIPOLYGON. |
geom_centroid | string | This column contains the geometrical center or centroid of the shape described in the 'geom_geotext' column. |
geom_center_x | double | This column shows the X coordinate of the geometric center or centroid. |
geom_center_y | double | This column displays the Y coordinate of the geometric center or centroid. |
gid | long | This column consists of integer values which are unique identifiers. |
gml_id | string | This column includes string values which are unique identifiers in the GML format. |
name | string | This column contains the English names of the ELY centres. |
namn | string | This column holds the Swedish names of the ELY centres. |
nimi | string | This column consists of the Finnish names of the ELY centres. |
shape_star | double | This column contains the area of the shapes described in the 'geom_geotext' column. |
shape_stle | double | This column holds the length of the shapes described in the 'geom_geotext' column. |
vuosi | double | This column represents the year in which the data was collected. |
Version History of ELY Areas 2015 (1:1 000 000)
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the data row was extracted from the data source. It is part of the unique identifier for each row in this version history table. |
_end_date | date | This column contains the date when a new version of the data row was extracted. If the value is null, it means that the current row is the most recent version. |
_row_number | long | This column contains the number of the row in the raw data extracted from the data source. This, together with '_start_date', uniquely identifies each row in this version history table. |
ely | string | This column contains string identifiers of the ELY centers in Finland. |
geom_geojson | string | This column contains the geographic data of the ELY centers in GeoJSON format. |
geom_geotext | string | This column contains the geographic data of the ELY centers in text format. |
geom_type | string | This column indicates the type of the geographic data. |
geom_centroid | string | This column contains the coordinates of the center point of the geographic area of the ELY centers. |
geom_center_x | double | This column contains the x-coordinate of the center point of the geographic area of the ELY centers. |
geom_center_y | double | This column contains the y-coordinate of the center point of the geographic area of the ELY centers. |
gid | long | This column contains the integer identifier of the geographic area of the ELY centers. |
gml_id | string | This column contains string identifiers of the geographic area of the ELY centers. |
name | string | This column contains the English names of the ELY centers. |
namn | string | This column contains the names of the ELY centers in Swedish. |
nimi | string | This column contains the names of the ELY centers in Finnish. |
shape_star | double | This column contains real number values representing the area of the geographic area of the ELY centers. |
shape_stle | double | This column contains real number values representing the perimeter of the geographic area of the ELY centers. |
vuosi | double | This column contains the year the data was recorded. |
Additional Info
Last Updated | November 11, 2024 |
---|---|
Created | November 11, 2024 |