Statistical Regions Dataset Collection, 2013 Edition
Tables
-
Historical Version Data of ELY Areas 2013 - Scaled 1:4,500,000TSV
The 'table__history' is a part of a dataset collection named 'tilastointialueet_ely4500k_2013'. This history table serves as a repository for the version history of its base table rows, tracking changes over time. It contains data detailing the ELY-areas for the year 2013 at a scale of 1:4,500,000. The data is sourced from 'Tilastokeskus' (Statistics Finland), based in Finland. The table includes various columns which offer a wealth of information about each row's timeline and contents. Unique row identifiers are formed by coupling the extraction date and the row's number from the original dataset. Monitoring when a row was extracted and when a new version of it was introduced is possible through the '_start_date' and '_end_date' columns, respectively. When a row's '_end_date' is null,...
-
Regional Division ELY Areas 2013 (Scale 1:4,500,000) - Dataset TableTSV
The table is part of a dataset collection that represents the 'ELY-areas 2013' (Centers for Economic Development, Transport and the Environment in Finland) at a scale of 1:4 500 000. The data has been sourced from the Statistics Finland website ('Tilastokeskus') based in Finland. The table contains various columns, each providing unique information about the ELY areas. The columns contain data such as the extraction date of the data row, the row number, geographical information in the form of GeoJSON and GeoText, the type of geometry represented (i.e., MultiPolygon), the centroid of the geometry, the X and Y coordinates of the center of the geometry, a unique identifier, a GML ID, and the name of the ELY area in three languages - English, Swedish, and Finnish. There are specific columns...
Column Descriptions
Regional Division ELY Areas 2013 (Scale 1:4,500,000) - Dataset Table
Column | Type | Comment |
---|---|---|
_extract_date | date | This column indicates the date when the data on the row was extracted from the data source. It provides an understanding of the currency of the data. |
_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'. This, in combination with '_extract_date', uniquely identifies each row. |
ely | string | This column contains a coded representation of different regions in Finland. |
geom_geojson | string | This column contains the geometric representation of the region in GeoJSON format, a popular format for encoding a variety of geographic data structures. |
geom_geotext | string | This column provides the geometric representation of the region in text format. |
geom_type | string | This column specifies the type of the geometric data. |
geom_centroid | string | This column contains the central point of the geometric shape representing the region. |
geom_center_x | double | This column represents the X-coordinate of the central point of the geometric shape. |
geom_center_y | double | This column represents the Y-coordinate of the central point of the geometric shape. |
gid | long | This column contains a unique identifier for each row in the table. |
gml_id | string | This column contains a unique identifier for each geographical feature in the table. |
name | string | This column contains the English names of different regions in Finland. |
namn | string | This column contains the names of different regions in Finland in another language, possibly Swedish. |
nimi | string | This column contains the names of different regions in Finland in Finnish language. |
vuosi | long | This column indicates the year to which the data pertains. For example, data extracted in 2013. |
Historical Version Data of ELY Areas 2013 - Scaled 1:4,500,000
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier for each row in the version history table in combination with the '_row_number' column. |
_end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it indicates that the 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. It forms a unique identifier for each row in the version history table in combination with the '_start_date' column. |
ely | string | This column contains a string type value, likely representing a certain classification or code within the data. |
geom_geojson | string | This column contains GeoJSON representations of multi-polygonal geographic shapes. |
geom_geotext | string | This column contains text representations of multi-polygonal geographic shapes. |
geom_type | string | This column specifies the type of the geographic shape represented in 'geom_geojson' and 'geom_geotext' columns. The type is 'ST_MULTIPOLYGON' indicating multi-polygonal shapes. |
geom_centroid | string | This column contains the geographic coordinates of the centroid point of the multi-polygonal shapes. |
geom_center_x | double | This column contains the x-coordinate of the center point of the multi-polygonal shapes. |
geom_center_y | double | This column contains the y-coordinate of the center point of the multi-polygonal shapes. |
gid | long | This column contains an integer value, likely a unique identifier or a classification code within the data. |
gml_id | string | This column contains a unique string identifier for each row in the data. |
name | string | This column contains the English names of the geographic areas represented by the multi-polygonal shapes. |
namn | string | This column contains the local names of the geographic areas represented by the multi-polygonal shapes. |
nimi | string | This column contains another form of local names for the geographic areas represented by the multi-polygonal shapes. |
vuosi | long | This column contains an integer value representing a year, probably the year when the data were collected. |
Additional Info
Last Updated | November 11, 2024 |
---|---|
Created | November 11, 2024 |