Statistical Area Dataset Collection 2013
Tables
-
Regional Administrative Agency Areas in Finland, 2013 (Scale 1:1,000,000)TSV
The table, which is part of a larger dataset collection, contains detailed data about AVI regions in Finland for the year 2013. This information is sourced from the Finnish website 'Tilastokeskus' (Statistics Finland). The table encompasses various types of information, including identification and geographical details. Each row in the table represents a specific AVI region, identified by features such as a unique gid, and an avi code. The row also includes the official name of the region in multiple languages. The geographical information about these regions is presented in several formats, including GeoJSON and Geotext. These geographic details can be used for geospatial data analytics. For example, the geom_centroid column provides the central point of the region, while the...
-
Version History of AVI Regions 2013 (Scale 1:1,000,000)TSV
The 'table__history' is a historical table that holds the version history of its base table rows, sourced from the 'Tilastokeskus' website in Finland. This table belongs to the 'tilastointialueet_avi1000k_2013' dataset collection and includes several notable columns. This table is a version of the AVI areas 2013 (1:1 000 000) base table with additional columns to track changes over time. Specifically, the table has two additional date-related columns '_start_date' and '_end_date'. The '_start_date' column holds the date when the row was extracted from the source, and '_end_date' represents when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row is the most recent version. In conjunction with the '_row_number' column, which denotes row...
Column Descriptions
Regional Administrative Agency Areas in Finland, 2013 (Scale 1:1,000,000)
Column | Type | Comment |
---|---|---|
_extract_date | date | This is a special column that contains the date when the data on the row of the table was extracted from the source. The format of the data is in date format. |
_row_number | long | This is another special column that contains the row number in the data extracted from the source. It works in combination with '_extract_date' to uniquely identify each row. |
avi | string | This column stores string type data, potentially representing various categories or classifications in the dataset. |
geom_geojson | string | This column contains geometric data in the GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains geometric data as text. It might be helpful for visualization or mapping purposes. |
geom_type | string | This column specifies the type of the geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. For instance, the sample value 'ST_MULTIPOLYGON' indicates that the data represents multiple polygonal areas. |
geom_centroid | string | This column contains the geometric central point of the geographic data in the row. It may be used to represent the data on a map. |
geom_center_x | double | This column represents the X-coordinate of the geometric center of the geographic data in the row. |
geom_center_y | double | This column represents the Y-coordinate of the geometric center of the geographic data in the row. |
gid | long | This is an integer column, which might be used as an identifier or to link this table with other tables in the database. |
gml_id | string | This string-type column may serve as a unique identifier for each row or represent some specific category or classification. |
name | string | This is a string column that might contain names of entities, objects, or categories in the dataset. |
namn | string | This column, similar to 'name', stores string data. It might contain translated or alternative names for the entities represented in the 'name' column. |
nimi | string | This column stores another version of names, potentially in a different language or format compared to 'name' and 'namn'. |
vuosi | long | This integer column seems to represent a year, as suggested by the sample value 2013. |
Version History of AVI Regions 2013 (Scale 1:1,000,000)
Column | Type | Comment |
---|---|---|
_start_date | date | The date when the row was extracted from the data source, forming part of the identifier for each row in this version history table. |
_end_date | date | The date when a new version of the row was extracted from the data source. If this value is null, it signifies that the row is the most recent version. |
_row_number | long | The number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
avi | string | A string type column representing data origin, possibly a code or identifier. |
geom_geojson | string | The geographic data of the area, represented in GeoJSON format. |
geom_geotext | string | The geographic data of the area, represented as text. |
geom_type | string | Describes the type of the geographic data present in the row, for instance 'ST_MULTIPOLYGON'. |
geom_centroid | string | The geographical center or 'centroid' of the area, represented as a point. |
geom_center_x | double | The X coordinate of the geographical center of the area. |
geom_center_y | double | The Y coordinate of the geographical center of the area. |
gid | long | An integer type column, possibly representing a unique identifier or a code. |
gml_id | string | A string type column, representing a unique identifier. |
name | string | The English name of the area. |
namn | string | The name of the area in a local language (possibly Finnish or Swedish). |
nimi | string | The name of the area in another local language (possibly Finnish or Swedish). |
vuosi | long | An integer type column representing the year, possibly the year of data collection or the year the data represents. |
Additional Info
Last Updated | December 18, 2024 |
---|---|
Created | November 8, 2024 |