Statistical Areas Municipality 4500K 2015 Dataset Collection
Tables
-
Municipalities 2015 (1:4 500 000) - Dataset TableTSV
The table is a rich source of geospatial data related to the municipalities of Finland, as sourced from the Finnish statistical authority, Tilastokeskus. The data represents the key attributes of each municipality in the year 2015, at a scale of 1:4,500,000. The table is a part of a larger collection of tables, indicating its connection with other related data. The contents of the table are organized into several columns, each carrying unique and valuable information. Two of these columns, '_extract_date' and '_row_number', serve a special function. The '_extract_date' column holds the date on which each unique row of data was extracted, while the '_row_number' provides the specific row number within the data extracted on a specific date. Together, these columns uniquely identify each...
-
Version History of Municipalities 2015 (1:4 500 000) - TableTSV
The 'table__history' is a rich repository of historical data, serving as a version history for its base table rows. Originating from the 'Tilastokeskus' (Statistics Finland) website, this table belongs to the 'tilastointialueet_kunta4500k_2015' dataset collection. The table provides a detailed account of Finnish municipalities as of the year 2015 at a scale of 1:4,500,000. The data is organized in a range of columns that contain diverse pieces of information. Of particular note are two special columns: '_start_date' and '_end_date'. The former specifies the date when a particular row was extracted from the source, while the latter indicates when a new version of that row was sourced. If an '_end_date' is null, it signifies that the associated row is the most recent version....
Column Descriptions
Municipalities 2015 (1:4 500 000) - Dataset Table
Column | Type | Comment |
---|---|---|
_extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. It helps to trace the data extraction history. |
_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 provides a unique identifier for each row in combination with '_extract_date'. |
geom_geojson | string | This column contains the geographical data in GeoJSON format. It represents the multipolygonal shapes of the geographical areas. |
geom_geotext | string | This column represents the geographical data as text. It is another representation of the geographical areas akin to 'geom_geojson'. |
geom_type | string | This column indicates the type of the geographical data, which in this table is 'ST_MULTIPOLYGON', representing multipolygonal shapes. |
geom_centroid | string | This column contains the centroid of the geographical area. It is the geometric center point of the area. |
geom_center_x | double | This column contains the X coordinate of the center of the geographical area. It is part of the geometric description of the area. |
geom_center_y | double | This column contains the Y coordinate of the center of the geographical area. It is part of the geometric description of the area. |
gml_id | string | This is an identification column for the geographical markup language data. |
kunta | string | This column contains a unique string identifier for each municipality in the dataset. |
name | string | This column contains the English name of the municipality. |
namn | string | This column contains the local name of the municipality. |
nimi | string | This column contains another local name of the municipality. |
shape_star | double | This column contains the star shape data of the geographical area. It's a numerical representation of the shape. |
shape_stle | double | This column contains the style shape data of the geographical area. It's another numerical representation of the shape. |
vuosi | double | This column contains the year data. It refers to the year the data of the row was collected or refers to. |
Version History of Municipalities 2015 (1:4 500 000) - Table
Column | Type | Comment |
---|---|---|
_start_date | date | The date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies each row in this version history table. |
_end_date | date | The date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
_row_number | long | The number of the row in the raw data extracted from the data source. This column, in combination with '_start_date', uniquely identifies each row in this version history table. |
geom_geojson | string | Contains the geographical data in GeoJSON format. |
geom_geotext | string | Contains the geographical data in textual format. |
geom_type | string | Specifies the type of the geographical data. |
geom_centroid | string | Contains the centroid of the geographical data. |
geom_center_x | double | Specifies the x-coordinate of the center of the geographical data. |
geom_center_y | double | Specifies the y-coordinate of the center of the geographical data. |
gml_id | string | A unique identifier assigned to each row. |
kunta | string | Contains string data, possibly referring to the municipality or region related to the row. |
name | string | Contains string data, possibly referring to the name of the municipality or region related to the row. |
namn | string | Contains string data, possibly referring to the name of the municipality or region related to the row. |
nimi | string | Contains string data, possibly referring to the name of the municipality or region related to the row. |
shape_star | double | Contains real number data, possibly referring to some aspect of the geographical shape related to the row. |
shape_stle | double | Contains real number data, possibly referring to some aspect of the geographical shape related to the row. |
vuosi | double | Contains real number data, possibly referring to the year related to the row. |
Additional Info
Last Updated | November 12, 2024 |
---|---|
Created | November 11, 2024 |