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

Geospatial Dataset Collection: Place Names in Swedish from 'Helsinki Urban Environment' Website, Finland

This dataset collection contains one or more tables sourced from the website of Helsingin kaupunkiympäristön toimiala, which is a government agency responsible for urban environment in Finland. The tables in this collection belong to the avoindataseutukartta_nimisto_paikannimet_ruotsi dataset collection.

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