Statistical Areas Service Interface (WFS) 2023 Dataset Collection
Tables
-
Regional Administrative Agencies (AVI) Areas 2023 Scaled 1:1 000 000TSV
The table, which is part of the 'tilastointialueet_avi1000k_2023' dataset collection, contains detailed information on the AVI regions for the year 2023, at a map scale of 1:1,000,000. Each row in the table is uniquely identified by a combination of the extraction date and the row number. The extraction date signifies when the data was pulled from the source, while the row number represents the order of the data extracted on that specific date. The table offers rich geographic information with columns containing geojson, geotext, and other geospatial elements. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the longitude coming first, followed by the latitude. The table includes identifiers such as 'avi', 'gml_id', and 'id', and naming...
-
Version History of AVI Regions 2023 (scale 1:1 000 000) from a Finnish Statistical Data CollectionTSV
The 'table__history' is a historic compilation of data, tracking alterations and updates over time. It is a component of the 'tilastointialueet_avi1000k_2023' dataset collection, emphasizing the importance of data evolution tracking in data analytics. The content of the base table is an overview of 'AVI-areas 2023' at a scale of 1:1,000,000, sourced from the Finnish 'Tilastokeskus' (Statistics Finland) website. The table includes a variety of columns that store valuable data related to each row's version history. A unique identifier for each row is formed by a combination of the '_start_date' and '_row_number' columns, with the former capturing the date the row was extracted and the latter indicating the row's number in the raw data. The '_end_date' column records the date when a new...
Column Descriptions
Regional Administrative Agencies (AVI) Areas 2023 Scaled 1:1 000 000
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on each row of the table was extracted from the data source. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| avi | string | This column contains numerical data. The specific meaning of this column is not provided by the source. |
| geom_geojson | string | This column contains geometric data in the GeoJSON format, which describes the shapes of geographical features. |
| geom_geotext | string | This column contains textual representations of geographic polygons. |
| geom_type | string | This column specifies the type of geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. In this case, the type is 'ST_MULTIPOLYGON', meaning that the data represents multiple polygons. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid, or geometric center, of each polygon. |
| geom_center_x | double | This column contains the x-coordinate of the center of each polygon. This is part of the information needed to plot the polygon on a map. |
| geom_center_y | double | This column contains the y-coordinate of the center of each polygon. This is part of the information needed to plot the polygon on a map. |
| gml_id | string | This column contains a unique identifier for each row in the table. |
| id | long | This column contains numerical data. The specific meaning of this column is not provided by the source. |
| name | string | This column contains the English names of geographical areas. |
| namn | string | This column contains the names of geographical areas in a language other than English. |
| nimi | string | This column contains the names of geographical areas in a language other than English. |
| vuosi | long | This column contains numerical data. The specific meaning of this column is not provided by the source. |
Version History of AVI Regions 2023 (scale 1:1 000 000) from a Finnish Statistical Data Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column represents the date when the row was extracted from the data source, helping to track the history of data updates. |
| _end_date | date | This column indicates the date when a new version of the row was extracted from the data source. A null value implies that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the source. Together with '_start_date', it uniquely identifies each row in the history table. |
| avi | string | This column contains a string representation of a unique identifier. |
| geom_geojson | string | This column stores the geographical data in GeoJSON format, which represents various geometrical shapes. |
| geom_geotext | string | This column holds the geographical data in text format. |
| geom_type | string | This column indicates the type of the geographical data stored. |
| geom_centroid | string | This column contains the central point of the geographical shape. |
| geom_center_x | double | This column represents the X-coordinate of the center of the geographical shape. |
| geom_center_y | double | This column represents the Y-coordinate of the center of the geographical shape. |
| gml_id | string | This column contains a unique identifier in String format. |
| id | long | This column holds a unique integer identifier. |
| name | string | This column contains the English name of the respective entity. |
| namn | string | This column has the name of the respective entity in the local language. |
| nimi | string | This column includes the name of the respective entity in another local language. |
| vuosi | long | This column holds an integer value representing the year related to the row data. |
Additional Info
| Last Updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |