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

Seutukartta Tuusula Small Areas Dataset Collection

This dataset collection comprises one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala (City of Helsinki's Urban Environment Division) in Finland.

Tables

  • Geographical Areas in Tuusula, FinlandTSV

    This table contains data about small areas in Tuusula, a municipality in Finland. The data is sourced from the website of the Department of Urban Environment of Helsinki. The table includes various columns such as the extraction date, row number, size of the area, municipality, larger area, status, small area name, ISO name, and other attributes. The table also contains geospatial information, such as the geometry in GeoJSON and Geotext formats, the type of geometry, geometric centroid, and center coordinates. The table provides valuable data for data analytics and can be used for various purposes, such as analyzing the distribution of small areas, studying the relationship between different attributes, and conducting spatial analysis in the context of Tuusula municipality in Finland.

  • Version History of Tuusula Small Areas in the Helsinki Metropolitan Area, Sourced from Helsingin kaupunkiympariston toimiala, FinlandTSV

    This table provides the version history of rows in the 'Tuusula Small Areas' table extracted from the website of the 'Helsinki Metropolitan Area Urban Environment Division'. The data in this table originates from Finland. It contains information about various attributes such as the start and end dates of each row, row number, size information, municipality, region, status, name, ISO name, group, geojson and geotext representations of the geometry, geometry type, centroid, center coordinates, and the geometry itself. The table is useful for data analytics tasks such as tracking changes over time, analyzing trends, and comparing different versions of the 'Tuusula Small Areas' dataset.

Column Descriptions

Geographical Areas in Tuusula, Finland

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number of the data entry.
kokotun int The size of the object.
kunta int The municipality of the object.
suur int The area of the object.
tila int The status of the object.
pien int The smallness of the object.
nimi string The name of the object.
nimi_iso string The ISO name of the object.
mtryhm int The measurement group of the object.
geom_geojson string The geometry of the object in GeoJSON format.
geom_geotext string The geometry of the object in Geotext format.
geom_type string The type of geometry of the object.
geom_centroid string The centroid point of the object.
geom_center_x double The x-coordinate of the center point of the object.
geom_center_y double The y-coordinate of the center point of the object.
geom binary The full geometry of the object.

Version History of Tuusula Small Areas in the Helsinki Metropolitan Area, Sourced 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 An additional column for maintaining the version history of the base table rows.
kokotun int A column with an unidentified purpose or meaning.
kunta int A column representing the municipality of the row.
suur int A column with unknown purpose or meaning.
tila int A column showing the status of the row.
pien int A column with unspecified purpose or meaning.
nimi string A column depicting the name of the row.
nimi_iso string A column with the name of the row in ISO format.
mtryhm int A column representing the measurement group of the row.
geom_geojson string A column containing geometry data in GeoJSON format.
geom_geotext string A column containing geometry data in Geotext format.
geom_type string A column representing the type of geometry.
geom_centroid string A column containing the centroid of the geometry.
geom_center_x double The x-coordinate of the center of the geometry.
geom_center_y double The y-coordinate of the center of the geometry.
geom binary A column containing the geometrical representation of the row.

Additional Info

Last Updated April 24, 2024
Created October 22, 2018