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

Neighborhoods of Helsinki

The dataset collection consists of table(s) sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

  • Helsinki Sub-Districts Polygon DataTSV

    This table contains information about the sub-regions of Helsinki from the data source 'Helsinki Urban Environment Division'. The data is sourced from the country Finland (ISO country code 'fi'). The table includes various columns such as '_extract_date', '_row_number', 'kokotun', 'kunta', 'suur', 'perus', 'osa', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns store different attributes related to the sub-regions. The table can be utilized in data analytics to gain insights and perform analysis on the sub-regions of Helsinki. It can help in understanding the distribution, characteristics, and relationships of these sub-regions, allowing for various spatial and statistical analyses.

  • Version History of Helsinki Sub-AreasPolygon DataTSV

    This table contains the version history of rows extracted from the dataset 'Helsingin kaupunkiympäristön toimiala' from Finland (ISO country code: 'fi'). The base table, 'seutukarttahelsinki_osa_alueet__helsinki_osaalueetpolygon', serves as the source for this table. The additional columns in this table compared to the base table are '_start_date' and '_end_date'. The '_start_date' column indicates the date when a row was initially extracted, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row represents the most recent version of the data. Although the specific columns of this table are not listed or described, its data can be utilized in various ways for data analytics. For example, it can be...

Column Descriptions

Helsinki Sub-Districts Polygon Data

Column Type Comment
_extract_date date The date the data was extracted.
_row_number long The row number of the record.
kokotun int The total population of a city.
kunta int The municipality of a city.
suur int The number of residents living in a city.
perus int The basic population of a city.
osa int The part of a city.
nimi string The name of a city.
nimi_iso string The ISO name abbreviation of a city.
mtryhm int The municipal group a city belongs to.
geom_geojson string The geometry data of a city in GeoJSON format.
geom_geotext string The geometry data of a city in GeoText format.
geom_type string The type of geometry of a city.
geom_centroid string The centroid of the geometry of a city.
geom_center_x double The x-coordinate of the center of the geometry of a city.
geom_center_y double The y-coordinate of the center of the geometry of a city.
geom binary The geometry data of a city.

Version History of Helsinki Sub-AreasPolygon 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 sequential number of the row version.
kokotun int Description for column 'kokotun' is unavailable.
kunta int Description for column 'kunta' is unavailable.
suur int Description for column 'suur' is unavailable.
perus int Description for column 'perus' is unavailable.
osa int Description for column 'osa' is unavailable.
nimi string Description for column 'nimi' is unavailable.
nimi_iso string Description for column 'nimi_iso' is unavailable.
mtryhm int Description for column 'mtryhm' is unavailable.
geom_geojson string Description for column 'geom_geojson' is unavailable.
geom_geotext string Description for column 'geom_geotext' is unavailable.
geom_type string Description for column 'geom_type' is unavailable.
geom_centroid string Description for column 'geom_centroid' is unavailable.
geom_center_x double Description for column 'geom_center_x' is unavailable.
geom_center_y double Description for column 'geom_center_y' is unavailable.
geom binary Description for column 'geom' is unavailable.

Additional Info

Last Updated September 13, 2024
Created November 22, 2018