Statistics Bureau Service Interface (WFS): Comprehensive Data Tables Collection
Tables
-
Historical Versioning of AVI Regions (1:1 000 000)TSV
The 'table__history' is a historical record of the AVI areas (1:1 000 000) table, providing a chronological view of the data changes. The table is part of the 'tilastointialueet_avi1000k' dataset collection, which is sourced from the 'Tilastokeskus' website in Finland. It is a valuable resource for understanding the evolution of AVI areas over time. The table consists of several columns that contain a variety of data types. It presents geographic data, which is particularly useful for geospatial analytics. The geographic data, represented in columns starting with 'geom_', uses the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This geographic information includes the type, the GeoJSON and geotext representations, the centroid, and...
-
Regional Administrative Agency Areas (Scale 1:1,000,000) - Data TableTSV
The table under consideration belongs to a dataset collection named 'Tilastointialueet_avi1000k'. It comprises of a diverse set of columns that carry a rich variety of data, including specific geographic information, identifiers and names, among other elements. The table is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. One of the key components of the table is the geographic information contained in several columns, all beginning with the prefix 'geom_'. These contain various forms of geographic details such as geographic coordinates, which are presented using the WGS 84 coordinate reference system. The axis order for these coordinates follows the structure: longitude first, followed by latitude. This geographical data is particularly valuable for...
Column Descriptions
Regional Administrative Agency Areas (Scale 1:1,000,000) - Data Table
Column | Type | Comment |
---|---|---|
_extract_date | date | This column contains the date when the data on the row was extracted from the source. It plays a crucial role in uniquely identifying each row in combination with the '_row_number' column. |
_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'. It uniquely identifies each row when used in conjunction with the '_extract_date' column. |
avi | string | This column contains string values which might be identifiers or codes for a certain feature or entity in the dataset. |
geom_geojson | string | This column contains geographic data in the GeoJSON format, which is a format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains geographic data in textual format, probably representing various geographic features. |
geom_type | string | This column specifies the type of geographic data stored in the 'geom_geotext' and 'geom_geojson' columns. It appears to contain a single, constant value 'ST_MULTIPOLYGON'. |
geom_centroid | string | This column contains the coordinates of the centroid, or geometric center, of the feature represented in the 'geom_geotext' and 'geom_geojson' columns. |
geom_center_x | double | This column contains the X coordinate of the geometric center of the feature represented in the 'geom_geotext' and 'geom_geojson' columns. |
geom_center_y | double | This column contains the Y coordinate of the geometric center of the feature represented in the 'geom_geotext' and 'geom_geojson' columns. |
gml_id | string | This column contains unique identifiers for each row, likely sourced from the original data source. |
id | long | This column contains integer values, possibly representing unique identifiers for the entities or features referenced in the dataset. |
name | string | This column contains string values, likely representing the names of the entities or features in English language. |
namn | string | This column contains string values, likely representing the names of the entities or features in another language, possibly Swedish. |
nimi | string | This column contains string values, likely representing the names of the entities or features in Finnish language. |
vuosi | long | This column contains integer values, possibly indicating the year associated with the data on each row. |
Historical Versioning of AVI Regions (1:1 000 000)
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It forms a combination with '_row_number' to uniquely identify each row in this version history table. |
_end_date | date | This column contains the date when a new version of the row was extracted from the data source. If its value is null, that indicates the row is the most recent version. |
_row_number | long | This column contains the number of the row in the raw data extracted from the data source. It is part of the unique identifier of each row in combination with '_start_date'. |
avi | string | This string type column is sourced from the base table. |
geom_geojson | string | This column contains geospatial data in GeoJSON format. |
geom_geotext | string | This column contains geospatial data in text format. |
geom_type | string | This column describes the type of the geospatial data. |
geom_centroid | string | This column contains the centroid of the geospatial data. |
geom_center_x | double | This column contains the x-coordinate of the geospatial data center. |
geom_center_y | double | This column contains the y-coordinate of the geospatial data center. |
gml_id | string | This string type column is sourced from the base table. |
id | long | This integer type column is sourced from the base table. |
name | string | This string type column is sourced from the base table. |
namn | string | This string type column is sourced from the base table. |
nimi | string | This string type column is sourced from the base table. |
vuosi | long | This integer type column is sourced from the base table. |
Additional Info
Last Updated | December 22, 2024 |
---|---|
Created | November 8, 2024 |