Neighborhoods of Helsinki
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 |