Dataset Collection: avoindataopev_ooa_ylaaste_ruotsi
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 |