ELY Areas 2013 (Scale 1:1 000 000) Dataset Table

The table, sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland, primarily contains data related to ELY areas in 2013 at a scale of 1:1,000,000. Each row in the table represents a unique ELY area, identified by its unique code ('ely'), name ('name'), Finnish name ('nimi'), and Swedish name ('namn'), along with a unique identifier in the form of 'gml_id'. The data in each row is extracted on a specific date, captured by the '_extract_date' column, and assigned a unique '_row_number' for identification purposes.

The table also holds geospatial data related to these ELY areas. This includes 'geom_geojson' and 'geom_geotext' which contain the geographical coordinates of the ELY areas in JSON and text format respectively. The 'geom_type' indicates the type of geographical representation used, in this case, a multipolygon. The 'geom_centroid' provides the geographic centroid of each area, with its coordinates split into 'geom_center_x' and 'geom_center_y' for the longitude and latitude respectively. These geographical coordinates follow the WGS 84 coordinate reference system, with the longitude appearing first, followed by the latitude.

This table can be valuable for various data analytics purposes. For example, the geospatial data can be used to map ELY areas and analyze regional distribution or density. The temporal data can allow for trend analysis over time. The unique ELY codes and names can be useful in cross-referencing with other data sources for a more extensive analysis of regional statistics or demographic data. Additionally, the '_extract_date' and '_row_number' can be used to track data extraction history, which can be important in maintaining data integrity and understanding data changes over time.