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

Suuralueet Dataset Collection

This dataset collection contains one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

  • History of Tuusula Greater Area Polygons in Finland from Helsingin kaupunkiymparisto ToimialaTSV

    This table contains the version history of the 'seutukarttatuusula_suuralueet__tuusula_suuralueetpolygon' table. It provides information about the versions of rows extracted from the data source. The table has additional columns compared to the base table, which are '_start_date' and '_end_date'. The '_start_date' column represents the date when a particular version of the row was extracted, while the '_end_date' column represents the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it indicates that the row is the most recent version. The data in this table can be utilized in various data analytics tasks, such as tracking changes in the attributes of the base table rows over time, analyzing the frequency of updates, and identifying...

  • Suuralueet in Tuusula, FinlandTSV

    The table contains information about the municipalities and regions in Tuusula, Finland. It provides data related to the extract date, row number, size category, municipality, region, name, ISO name, group, geometric data in GeoJSON and Geotext formats, geometric type, centroid, center x-coordinate, center y-coordinate, and geometry. The table can be used for various data analytics purposes such as analyzing the size distribution of regions, studying the relationship between municipalities and regions, visualizing the geometric data, and performing spatial analysis.

Column Descriptions

Suuralueet 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 kokotun value.
kunta int The name of the municipality.
suur int The suur value.
nimi string The name.
nimi_iso string The ISO name.
mtryhm int The mtryhm value.
geom_geojson string The geometry data in GeoJSON format.
geom_geotext string The geometry data in Geotext format.
geom_type string The type of geometry.
geom_centroid string 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 The geometry data.

History of Tuusula Greater Area Polygons in Finland from Helsingin kaupunkiymparisto Toimiala

Column Type Comment
_start_date date A column indicating the start date of the validity period for the row version.
_end_date date A column indicating the end date of the validity period for the row version.
_row_number long A column indicating the row number of the version history.
kokotun int A column with an unspecified purpose or meaning.
kunta int A column containing a municipality or local district name.
suur int A column with an unspecified purpose or meaning.
nimi string A column containing a name.
nimi_iso string A column containing an ISO standardized name.
mtryhm int A column categorizing data into a specific group or category.
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 indicating the type of geometry data.
geom_centroid string A column containing the centroid of the geometry data.
geom_center_x double A column containing the x-coordinate of the centroid of the geometry data.
geom_center_y double A column containing the y-coordinate of the centroid of the geometry data.
geom binary A column containing the actual geometry data.

Additional Info

Last Updated September 13, 2024
Created October 22, 2018