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

Dataset Collection: avoindataopev_ooa_ylaaste_ruotsi

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

Tables

  • Geographical Area Polygons with Finnish and Swedish Names and MetadataTSV

    This table contains data from the web site of Helsingin kaupunkiympariston toimiala, which originates from Finland (ISO country code: fi). The table contains various data related to avoindataopev_ooa_ylaaste_ruotsi__opev_ooa_ylaaste_ruotsipolygon. The data in this table can be utilized for various data analytics purposes, such as analyzing the distribution of 'nimi_fi' and 'nimi_se' based on 'aluejako' and 'kunta', analyzing the update frequency of the data using 'paivitetty', and studying the geographic characteristics using 'geom_geojson' and related columns. Other columns in the table provide additional information that can be used for data analysis.

  • Version History of Finnish 'Helsinki Urban Environment Department' Polygon DataTSV

    This table contains the version history of the rows from the avoindataopev_ooa_ylaaste_ruotsi__opev_ooa_ylaaste_ruotsipolygon table. The rows in this table represent different versions of the base table rows, with additional columns _start_date and _end_date indicating the extraction dates. The data in this table is sourced from the website of the Helsinki City environment sector, which originates from Finland (ISO country code: 'fi'). The table provides valuable data for data analytics, allowing analysis of the historical changes over time in the 'aluejako', 'kunta', 'tunnus', 'nimi_fi', 'nimi_se', 'toimipiste', 'yhtluontip', 'yhtdatanom', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom' columns. By analyzing this...

Column Descriptions

Geographical Area Polygons with Finnish and Swedish Names and Metadata

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number of the data.
id int The unique identifier of the record.
aluejako string The division of the area.
kunta int The municipality of the record.
tunnus int The identifier of the record.
nimi_fi string The name of the record in Finnish.
nimi_se string The name of the record in Swedish.
toimipiste int The location of the record.
yhtluontip string The overall creation type.
yhtdatanom string The overall data nomination.
paivitetty string The date when the record was last updated.
geom_geojson string The geometry in GeoJSON format.
geom_geotext string The geometry 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 of the record.

Version History of Finnish 'Helsinki Urban Environment Department' Polygon Data

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 The row number of the version.
id int The unique identifier of the row.
aluejako string The partitioning of the area.
kunta int The municipality of the row.
tunnus int The identifier of the row.
nimi_fi string The name of the row in Finnish.
nimi_se string The name of the row in Swedish.
toimipiste int The office location.
yhtluontip string The co-creation type.
yhtdatanom string The data nominator.
paivitetty string The date of the update.
geom_geojson string The geometry in GeoJSON format.
geom_geotext string The geometry in Well-Known Text (WKT) format.
geom_type string The type of the 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 spatial representation of the feature.

Additional Info

Last Updated September 13, 2024
Created April 24, 2024