Geospatial Dataset Collection: Place Names in Swedish from 'Helsinki Urban Environment' Website, Finland
Tables
-
Place Names in Helsinki Metropolitan Area in Swedish on Open Metropolitan Area MapTSV
This table contains data from the dataset 'avoindataseutukartta_nimisto_paikannimet_ruotsi__seutukartta_nimisto_paikannimet_ruotsipoint' sourced from the website of 'City Environment Sector of Helsinki'. The dataset originates from Finland (ISO country code: FI). The table includes various columns such as '_extract_date', '_row_number', 'nimi_r', 'ikoord', 'pkoord', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', and 'tietopalve'. This data can be utilized for various data analytics purposes such as geographic analysis, mapping, spatial clustering, and geospatial data visualization.
-
Version History of Place Names in Swedish in the Helsinki Metropolitan AreaTSV
The table contains the version history of the rows extracted from the data source 'Helsinki City Environment Sector' in the country Finland (ISO country code: 'fi'). It represents the historical records of a base table named 'avoindataseutukartta_nimisto_paikannimet_ruotsi__seutukartta_nimisto_paikannimet_ruotsipoint'. The table includes the following columns: '_start_date', '_end_date', '_row_number', 'nimi_r', 'ikoord', 'pkoord', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', 'tietopalve'. The '_start_date' column indicates the date when a row was extracted, while the '_end_date' column represents the date when a new version of the row was extracted. If a row has a null value in the '_end_date' column, it denotes that it is the...
Column Descriptions
Place Names in Helsinki Metropolitan Area in Swedish on Open Metropolitan Area Map
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data was extracted. |
_row_number | long | The unique identifier of each row in the table. |
nimi_r | string | The name of the object. |
ikoord | int | The x-coordinate of the object's position. |
pkoord | int | The y-coordinate of the object's position. |
geom_geojson | string | The geometry in GeoJSON format. |
geom_geotext | string | The geometry in Geotext format. |
geom_type | string | The type of the geometry (e.g., point, line, polygon). |
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. |
tietopalve | int | The service providing information about the object. |
Version History of Place Names in Swedish in the Helsinki Metropolitan Area
Column | Type | Comment |
---|---|---|
_start_date | date | The start date of the validity period of the row version. |
_end_date | date | The end date of the validity period of the row version. |
_row_number | long | The row number of the version history entry. |
nimi_r | string | The name of the row. |
ikoord | int | The i-coordinate of the row. |
pkoord | int | The p-coordinate of the row. |
geom_geojson | string | The geometry of the row in GeoJSON format. |
geom_geotext | string | The geometry of the row in Geotext format. |
geom_type | string | The type of the geometry stored in the row. |
geom_centroid | string | The centroid of the geometry stored in the row. |
geom_center_x | double | The x-coordinate of the center point of the geometry. |
geom_center_y | double | The y-coordinate of the center point of the geometry. |
geom | binary | The geometry stored in the row. |
tietopalve | int | The data service associated with the row. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | May 6, 2018 |