The 'table' is part of a larger dataset collection known as 'tilastointialueet_avi1000k_2021'. This table contains important information about the AVI areas in 2021 at a scale of 1:1,000,000. It is sourced from the Statistics Finland (Tilastokeskus) web site based in Finland. This table contains geographic data that can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order of longitude first, followed by latitude.
The data in the table is organized in various columns. Two special columns, '_extract_date' and '_row_number', provide key details about each row of data. The '_extract_date' indicates the date when the data on the row was extracted from the source, while the '_row_number' determines the row number in the data extracted from the source on the specific extraction date. This combination uniquely identifies each row in the table.
Several columns in the table contain geographic information, including 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y'. These columns provide various forms of geographic representations of the AVI areas, including their type, centroid, and central coordinates.
Other columns provide unique identifiers for each area ('gml_id', 'id'), the area's Finnish name ('nimi'), Swedish name ('namn'), and English name ('name'), and the year of the data ('vuosi').
The data in this table can be used for various analytical purposes. For instance, the geographic information can be used to conduct geospatial analyses to understand the spatial distribution of AVI areas. The extraction date and row number can be used to track changes in the data over time. The names in different languages can be used to create multilingual visual representations of the data. Overall, the data in this table provides a comprehensive overview of the AVI areas in 2021, serving as a valuable resource for data analysis.
