Regions 2023 at 1:1 000 000 scale - Dataset Table

The table is part of a dataset collection that provides detailed geographic and provincial information, specifically related to the provinces in Finland for the year 2023. This granular data is sourced from Tilastokeskus (Statistics Finland), a credible Finnish data source.

The table includes a variety of columns that provide different types of data. The columns beginning with 'geom_' provide geographic information, useful for geospatial data analytics. For instance, the 'geom_geojson' and 'geom_geotext' offer geometric data in various formats, while 'geom_type' specifies the type of geographic shape. The 'geom_centroid' gives the geographic center of the geometric shape, and 'geom_center_x' and 'geom_center_y' provide the precise coordinates of this center. It's important to note that these geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.

The table also includes information about the provinces, with columns for their unique identifiers, names in Finnish and Swedish ('nimi' and 'namn'), and the year they are related to ('vuosi').

Two special columns in the table are '_extract_date' and '_row_number'. The '_extract_date' specifies the date when the data was extracted, and '_row_number' gives the row number in the data extracted. These two columns together uniquely identify each row in the table.

The data in this table can be utilized in various ways for data analytics. For example, the geographic data can be used for geospatial analytics to analyze patterns or trends across different provinces. The provincial data can be used to study demographics or other province-specific trends. Moreover, the unique extract date and row number can be used to track changes in the data over time.