Statistical Areas Municipal 1000K 2017 Dataset Collection
Tables
-
Municipalities 2017 (1:1 000 000) - Table from Finnish Statistical Dataset Collection 2017TSV
The table is a component of a larger dataset that represents 'Municipalities 2017' on a scale of 1:1 000 000. The data was sourced from the 'Statistics Centre' (Tilastokeskus) in Finland. The table contains a range of columns, each serving a unique purpose in providing detailed and comprehensive information. Key columns include '_extract_date' and '_row_number', which respectively provide the date of data extraction and the row number in the extracted data. Together, these columns uniquely identify each row of data. The table also includes several geographic data columns, starting with 'geom_', which provide valuable information for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude...
-
Version History of Municipalities 2017 (1:1 000 000) TableTSV
The 'table__history' is a comprehensive chronicle of historical data that forms part of the 'tilastointialueet_kunta1000k_2017' dataset collection. This data is sourced from 'Tilastokeskus' (Statistics Finland), which provides valuable insights on Finnish municipalities in 2017, with a scale of 1:1 000 000. The table houses a rich array of information which includes geospatial data, municipal details, and version history. One of the unique aspects of this table is its geospatial data, which is presented using the WGS 84 coordinate reference system, with the axis order being longitude followed by latitude. This data can be utilized for in-depth geospatial analytics, allowing for the precise location and geographical characteristics of Finnish municipalities to be analyzed. In addition to...
Column Descriptions
Municipalities 2017 (1:1 000 000) - Table from Finnish Statistical Dataset Collection 2017
Column | Type | Comment |
---|---|---|
_extract_date | date | This column records the date when the specific row of data was extracted from the original data source. It helps in understanding when the data was last updated. |
_row_number | long | This column contains the row number in the data extracted from the source. It, in combination with '_extract_date', uniquely identifies each row. |
geom_geojson | string | This column holds the geometry of the area in GeoJSON format, which is a popular format for encoding a variety of geographic data structures. |
geom_geotext | string | This column represents the geographic area in a geotext format, which is a human-readable format used to describe complex polygons. |
geom_type | string | This column specifies the type of the geometric shape that represents the area. All areas in this dataset are represented as multi polygons. |
geom_centroid | string | This column represents the geographic center point of the area in a POINT format. It is useful for placing labels or symbols on maps. |
geom_center_x | double | This column represents the x-coordinate (longitude) of the center point of the area. |
geom_center_y | double | This column represents the y-coordinate (latitude) of the center point of the area. |
gml_id | string | This column contains a unique identifier for each area in the GML (Geography Markup Language) format, which is used for expressing geographic features. |
kunta | string | This column contains a unique identifier for each municipality. |
name | string | This column contains the name of the municipality. |
namn | string | This column contains the name of the municipality in Swedish, which is one of the official languages in Finland. |
nimi | string | This column contains the name of the municipality in Finnish, which is the other official language in Finland. |
vuosi | double | This column contains the year to which the data pertains. |
Version History of Municipalities 2017 (1:1 000 000) Table
Column | Type | Comment |
---|---|---|
_start_date | date | The date when the row was extracted from the data source. Together with '_row_number', it 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. A null value means that the row is the most recent version. |
_row_number | long | The number of the row in the raw data extracted from the source. It forms a unique identifier for each row when combined with '_start_date'. |
geom_geojson | string | The geographical data of the region in GeoJSON format. |
geom_geotext | string | The geographical data of the region in text format. |
geom_type | string | The type of geographical data stored. |
geom_centroid | string | The geographical point that represents the center of the region. |
geom_center_x | double | The X-coordinate of the center of the region. |
geom_center_y | double | The Y-coordinate of the center of the region. |
gml_id | string | The unique identifier for each row, as provided by the data source. |
kunta | string | The municipality code as a string. |
name | string | The English name of the municipality. |
namn | string | The name of the municipality in another language. |
nimi | string | The name of the municipality in another language. |
vuosi | double | The year the data was recorded, as a real number. |
Additional Info
Last Updated | November 11, 2024 |
---|---|
Created | November 11, 2024 |