To download the data set, please sign up or log in

Map of Kauniainen: Subareas

This dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

  • Areas in Kauniainen MunicipalityTSV

    This table contains data from the 'Helsinki Urban Environment Sector' website, which originates from Finland. It provides information on the small areas of Kauniainen, including their sizes, municipalities, classification, names, and geographic data. The table includes various columns like '_extract_date', '_row_number', 'kokotun', 'kunta', 'suur', 'tila', 'pien', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', which can be utilized for data analytics. Examples of data analysis include studying the population density, spatial distribution, and classification of the small areas in Kauniainen, as well as performing geospatial analysis and generating visualizations of the geographic features.

  • Version History of Kauniainen Small Area Polygons from Helsingin kaupunkiympariston toimiala, FinlandTSV

    This table contains the version history of the base table 'seutukarttakauniainen_pienalueet__kauniainen_pienalueetpolygon'. It includes additional columns '_start_date' and '_end_date', representing the extraction dates of each row. The data in this table is sourced from the website of 'Helsinki Urban Environment Division', which originates from the country with the ISO country code 'FI'. The table can be leveraged for various data analytics purposes, such as analyzing changes and updates made to the base table over time, tracking historical trends and patterns, and identifying the most recent version of rows based on the '_end_date' column.

Column Descriptions

Areas in Kauniainen Municipality

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number of the record.
kokotun int The total area in square meters.
kunta int The municipality where the data corresponds to.
suur int The size of an object.
tila int The status of an object.
pien int The small size of an object.
nimi string The name of an object.
nimi_iso string The ISO standardized name of an object.
mtryhm int The group to which an object belongs.
geom_geojson string The geometry of an object in GeoJSON format.
geom_geotext string The geometry of an object in Well-Known Text (WKT) format.
geom_type string The type of geometry.
geom_centroid string The centroid of an object geometry.
geom_center_x double The X-coordinate of the center point of an object geometry.
geom_center_y double The Y-coordinate of the center point of an object geometry.
geom binary The geometry of an object.

Version History of Kauniainen Small Area Polygons from Helsingin kaupunkiympariston toimiala, Finland

Column Type Comment
_start_date date The start date of the validity period for the row version.
_end_date date The end date of the validity period for the row version.
_row_number long A unique identifier for each row version in the table.
kokotun int The value of the 'kokotun' column in the base table for the given row version.
kunta int The value of the 'kunta' column in the base table for the given row version.
suur int The value of the 'suur' column in the base table for the given row version.
tila int The value of the 'tila' column in the base table for the given row version.
pien int The value of the 'pien' column in the base table for the given row version.
nimi string The value of the 'nimi' column in the base table for the given row version.
nimi_iso string The value of the 'nimi_iso' column in the base table for the given row version.
mtryhm int The value of the 'mtryhm' column in the base table for the given row version.
geom_geojson string The value of the 'geom_geojson' column in the base table for the given row version.
geom_geotext string The value of the 'geom_geotext' column in the base table for the given row version.
geom_type string The value of the 'geom_type' column in the base table for the given row version.
geom_centroid string The value of the 'geom_centroid' column in the base table for the given row version.
geom_center_x double The X-coordinate of the center point of the geometry in the 'geom' column for the given row version.
geom_center_y double The Y-coordinate of the center point of the geometry in the 'geom' column for the given row version.
geom binary The geometry value for the given row version in the base table.

Additional Info

Last Updated April 23, 2024
Created October 21, 2018