Interlinking opensource geo-spatial datasets for optimal utility in ranking

D. Bhattacharya*, P. Pasquali, J. Komarkova, P. Sedlak, A. Saha, P. Boccardo

*Corresponding author for this work

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract / Description of output

The joining of geospatial datasets is required to utilize the complete set of information available in each of them. There are many open source geospatial datasets available such as GeoNames, Open Street Map, Natural Earth and to get a comprehensive dataset with the union of all available information it is important that such datasets are linked optimally without redundancy or loss of information. Many of the geolocations on digital maps are not classified for importance because of the lack of additional information such as population or administrative level. A way to give an importance scale to the names is by linking the GeoNames to other datasets (OSM, natural earth). OpenStreetMap data provides a limited number of place classifications (such as city, town, village). For the best cartographic results we need classes that are a little more comprehensive about how they rank cities. The challenges faced include geometry searching, matching, buffer determination, local regional naming text inclusion and accuracy. This has been achieved by the current research work where presently GeoNames, Natural Earth and Open Street Map data tables have been merged with the union of all their attribute columns resulting in a complete geospatial dataset with place accuracy of atleast 95 % for any given country dataset. The data tables at global level consist of hundreds of thousands of rows with each row depicting a geolocation. The geometry, name and geo-id complete and fuzzy searching and matching around a buffer of 50 km took a minimum of 30 s to maximum 1 min in a commodity computer with 2 GHz, 2 GB memory, according to size and complexity of the query run for a country which could have a list of points ranging from a dozen to several hundreds. The future aim is to ultimately do this for global datasets to create an all-encompassing geodata bank having such information as administrative, political, ecological details from important databases as GAUL, SALB, GADM etc.

Original languageEnglish
Title of host publicationModern Trends in Cartography
Subtitle of host publicationSelected Papers of CARTOCON 2014
EditorsJan Brus, Alena Vondrakova, Vit Vozenilek
Number of pages14
ISBN (Print)9783319079257
Publication statusPublished - 2 Dec 2014
EventInternational cartographic conference, CARTOCON 2014 - Olomouc, Czech Republic
Duration: 25 Feb 201428 Feb 2014

Publication series

NameLecture Notes in Geoinformation and Cartography
ISSN (Print)1863-2246
ISSN (Electronic)1863-2351


ConferenceInternational cartographic conference, CARTOCON 2014
Country/TerritoryCzech Republic

Keywords / Materials (for Non-textual outputs)

  • data tables
  • fuzzy matching
  • geometry
  • GeoNames
  • geospatial
  • interlinking
  • label ranking
  • mapping
  • metadata
  • Natural Earth
  • Open Street Map
  • open-source data sets
  • scale ranking


Dive into the research topics of 'Interlinking opensource geo-spatial datasets for optimal utility in ranking'. Together they form a unique fingerprint.

Cite this