2017 Finnish Statistical Regions - Data Collection
Tables
-
ELY Areas 2017 (Scale 1:1,000,000) - Dataset Table from the Finnish Statistics BureauTSV
The table in discussion is a part of a larger dataset collection that focuses on the ELY-areas for the year 2017, represented at a scale of 1:1 million. This table is sourced from the Statistics Finland (Tilastokeskus) website, which is based in Finland. The gathered data is organized into several columns, capturing a diverse range of information. Two of these columns are particularly noteworthy: one captures the date when the data for each row was extracted, while the other signifies the row number from the original data source. Together, these columns uniquely identify each row in the table. The table also comprises columns that contain geographic data. These are especially useful for geospatial data analytics, as they present geographic coordinates using the WGS 84 coordinate...
-
Version History of ELY Areas 2017 (Scale 1:1 000 000)TSV
The 'table__history' is a historical data table that captures the version history of its base table rows. It forms part of a broader dataset collection that encapsulates data on 'ELY-areas 2017' at a scale of 1:1 000 000, indicating it holds geographic data related to administrative regions in Finland. The data is sourced from 'Tilastokeskus' (Statistics Finland), a web portal from Finland. The table includes a range of columns that provide rich data, including geographic, temporal, and categorical data. For instance, it carries columns that hold geographic data encoded in formats such as GeoJSON and GeoText. This geographic data, presented in the WGS 84 coordinate reference system, can be utilized for geospatial data analytics. For instance, it could be used to map the administrative...
Column Descriptions
ELY Areas 2017 (Scale 1:1,000,000) - Dataset Table from the Finnish Statistics Bureau
Column | Type | Comment |
---|---|---|
_extract_date | date | This column holds the date when the data was extracted, helping to identify the specific version of the data. |
_row_number | long | This column contains the row number of the data extracted, which, when combined with the '_extract_date', uniquely identifies each row. |
ely | string | This string column represents a certain code related to the data. |
geom_geojson | string | This column contains geospatial data in GeoJSON format, defining the geographical structure of the data. |
geom_geotext | string | This column contains the geographical data in text format, providing a human-readable representation of the geographical structure. |
geom_type | string | This column describes the type of geographical data structure, in this case, a multi-polygon. |
geom_centroid | string | This column gives the centroid of the geographical structure, representing the center point of the geographical area. |
geom_center_x | double | This column provides the X coordinate of the center of the geographical area. |
geom_center_y | double | This column provides the Y coordinate of the center of the geographical area. |
gid | long | This integer column appears to be a unique identifier for the data. |
gml_id | string | This string column seems to be another form of unique identifier for the data. |
name | string | This column contains the English name of the entity the data represents. |
namn | string | This column contains the name of the entity in another language, providing multi-lingual support. |
nimi | string | This column also contains the name of the entity in another language, further enhancing multi-lingual support. |
vuosi | double | This real type column seems to represent the year related to the data. |
Version History of ELY Areas 2017 (Scale 1:1 000 000)
Column | Type | Comment |
---|---|---|
_start_date | date | This is the date when the row was extracted from the data source, adding a timestamp to each row in the history table. |
_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 means that the row is the most recent version. |
_row_number | long | This column contains the number of the row in the raw data, providing a unique identifier for each row in combination with the '_start_date' column. |
ely | string | This column contains a string value representing a specific administrative region of Finland. |
geom_geojson | string | This column stores the geographical data of the region in GeoJSON format, a popular open standard format for representing simple geographical features. |
geom_geotext | string | This column contains the geographical data of the region in text format. |
geom_type | string | This column indicates the type of the geographical data stored, in this case, a multipolygon. |
geom_centroid | string | This column contains the centroid of the geographical data, representing the geometric center of the region. |
geom_center_x | double | This column contains the x-coordinate of the geographical center of the region. |
geom_center_y | double | This column contains the y-coordinate of the geographical center of the region. |
gid | long | This is an integer column that may be used as a unique identifier for the regions. |
gml_id | string | This column contains a unique identifier for each row in string format. |
name | string | This column contains the English name of the region. |
namn | string | This column contains the Swedish name of the region. |
nimi | string | This column contains the Finnish name of the region. |
vuosi | double | This column contains the year of the record, represented in real number format. |
Additional Info
Last Updated | November 12, 2024 |
---|---|
Created | November 11, 2024 |