Statistics Finland 2015 Service Interface Collection
Tables
-
AVI Regions 2015 (Scale 1:1,000,000) - Related Data CollectionTSV
The table in question, part of a larger dataset collection, contains data pertaining to AVI-areas in 2015 at a scale of 1:1 000 000. Sourced from 'Tilastokeskus' (Statistics Finland), it integrates various forms of information, including a unique identifier for each row, the date of data extraction, and data on geographic coordinates, among others. Each row is uniquely identified by combining the extract date and the row number. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This geographic data can be utilized for geospatial data analytics. The table includes data on the names of these areas in different languages, which can be used to provide multi-lingual support in data analyses....
-
Version History of AVI Regions 2015 Table (Scale 1:1 000 000)TSV
The table being described is a history table that stores the version history of rows from its base table. The base table content relates to the administrative boundaries in Finland for the year 2015, as sourced from the Finnish statistical agency, Tilastokeskus. The data in the table could be utilized in numerous ways including geospatial data analytics and studying historical changes in administrative boundaries. The table includes several columns that provide a wealth of information. Unique identifiers for each row version are created by combining two specific columns: one that indicates when the data was extracted and another showing the row number. Geographical coordinates are captured in several columns that start with 'geom_'. This information is particularly useful for...
Column Descriptions
AVI Regions 2015 (Scale 1:1,000,000) - Related Data Collection
Column | Type | Comment |
---|---|---|
_extract_date | date | This column contains the date when the data on the 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 string values representing a specific identifier. |
geom_geojson | string | This column contains data in GeoJSON format representing specific geographical shapes. |
geom_geotext | string | This column contains textual data representing geographical shapes in a format similar to GeoJSON. |
geom_type | string | This column specifies the type of the geographical shape represented by the data in the 'geom_geojson' and 'geom_geotext' columns. |
geom_centroid | string | This column contains the geographical coordinates of the centroid (geometrical center) of the shape represented by the data in the 'geom_geojson' and 'geom_geotext' columns. |
geom_center_x | double | This column contains the x-coordinate of the center of the geographical shape represented by the data in the 'geom_geojson' and 'geom_geotext' columns. |
geom_center_y | double | This column contains the y-coordinate of the center of the geographical shape represented by the data in the 'geom_geojson' and 'geom_geotext' columns. |
gid | long | This column contains integer values serving as unique identifiers. |
gml_id | string | This column contains string values serving as unique identifiers. |
name | string | This column contains English names of certain entities. |
namn | string | This column contains names of certain entities in a language other than English, possibly Finnish or Swedish. |
nimi | string | This column contains names of certain entities in a language other than English, possibly Finnish. |
shape_star | double | This column contains real (floating-point) values representing certain properties of the geographical shapes. |
shape_stle | double | This column contains real (floating-point) values representing certain properties of the geographical shapes. |
vuosi | double | This column contains real (floating-point) values possibly representing years. |
Version History of AVI Regions 2015 Table (Scale 1:1 000 000)
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source, helping to track the version history of the data. |
_end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it means that the row is the most recent version in the data history. |
_row_number | long | This column contains the number of the row in the raw data extracted from the source. Together with the '_start_date' column, it uniquely identifies each row in this version history table. |
avi | string | This column contains string values that represent an unspecified attribute of the data. |
geom_geojson | string | This column contains geographical data in GeoJSON format, which represents the geometric shapes of the regions. |
geom_geotext | string | This column contains geographical data in text format, which represents the geometric shapes of the regions. |
geom_type | string | This column specifies the type of geometry represented by the 'geom_geojson' and 'geom_geotext' columns. |
geom_centroid | string | This column contains the geographical coordinates of the geometric center of the regions. |
geom_center_x | double | This column contains the X-coordinate of the geometric center of the regions. |
geom_center_y | double | This column contains the Y-coordinate of the geometric center of the regions. |
gid | long | This column contains integer values representing a unique identifier for the data. |
gml_id | string | This column contains string values that constitute unique identifiers for the data. |
name | string | This column contains the English names of the regions represented by the data. |
namn | string | This column contains the names of the regions in another language. |
nimi | string | This column contains the names of the regions in yet another language. |
shape_star | double | This column contains real numbers that represent an unspecified attribute of the geometric shape of the regions. |
shape_stle | double | This column contains real numbers that represent another unspecified attribute of the geometric shape of the regions. |
vuosi | double | This column contains real numbers that represent the year related to the data. |
Additional Info
Last Updated | November 11, 2024 |
---|---|
Created | November 11, 2024 |