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

Geospatial Dataset Collection of Finland's Archipelago featuring Place Names

This dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

  • Geographical Names of Marine Areas in Finland from Helsingin kaupunkiympariston toimialaTSV

    This table contains data from 'Helsinki City Environmental Sector' website, originating from Finland. It provides information about maritime areas in Finland. The dataset includes fields such as _extract_date, _row_number, nimi_s, ikoord, pkoord, geom_geojson, geom_geotext, geom_type, geom_centroid, geom_center_x, geom_center_y, geom, and tietopalve. The data in this table can be utilized for various data analytics purposes, such as analyzing the distribution and characteristics of different maritime areas in Finland, studying the spatial patterns and clustering of these areas, or conducting geographical analysis related to maritime infrastructure or activities.

  • Historical Versions of Location Names and Coordinates in Finnish Coastal Areas on Open Data Spatial MapTSV

    This table contains the version history of rows extracted from the 'Helsingin kaupunkiympariston toimiala' website. The rows in this table represent various features found in marine areas in Finland. Each row has a unique identification number (_row_number) and includes information such as the name of the feature (nimi_s), geographical coordinates (ikoord and pkoord), geometrical data in both GeoJSON and Geotext formats (geom_geojson and geom_geotext), the type of geometry (geom_type), the centroid of the geometry (geom_centroid), the x and y coordinates of the center point (geom_center_x and geom_center_y), the full geometry (geom), and additional information provided by the 'tietopalve' service. The table includes two additional columns, '_start_date' and '_end_date', indicating the...

Column Descriptions

Geographical Names of Marine Areas in Finland from Helsingin kaupunkiympariston toimiala

Column Type Comment
_extract_date date The date when the row was extracted
_row_number long The row number or identifier
nimi_s string The name
ikoord int The x-coordinate
pkoord int The y-coordinate
geom_geojson string The geometry in GeoJSON format
geom_geotext string The geometry in Geotext format
geom_type string The geometry type
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 server providing the data

Historical Versions of Location Names and Coordinates in Finnish Coastal Areas on Open Data Spatial Map

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 unique row number of the version in the table.
nimi_s string The name of the row version.
ikoord int The i coordinate of the row version.
pkoord int The p coordinate of the row version.
geom_geojson string The geometry of the row version in GeoJSON format.
geom_geotext string The geometry of the row version in geotext format.
geom_type string The type of geometry for the row version.
geom_centroid string The centroid of the geometry for the row version.
geom_center_x double The x-coordinate of the center point of the geometry for the row version.
geom_center_y double The y-coordinate of the center point of the geometry for the row version.
geom binary The geometry of the row version.
tietopalve int The data service of the row version.

Additional Info

Last Updated April 23, 2024
Created May 6, 2018