Title
A flexible framework to cross-analyze heterogeneous multi-source geo-referenced information: the J-CO-QL proposal and its implementation
Abstract
The need for cross-analyzing JSON objects representing heterogeneous geo-referenced information coming from multiple sources, such as open data published on the Web by public administrations and crowd-sourced posts and images from social networks, is becoming common for studying, predicting and planning social dynamics. Nevertheless, although NoSQL databases have emerged as a de facto standard means to store JSON objects, a query language that can be easily used by not-programmers to manipulate and correlate such data is still missing. Furthermore, when the information is geo-referenced, we also need both spatial analysis and mapping facilities. In the paper, we motivate the need for a novel flexible framework, named J-CO, that provides a query language, named J-CO-QL, enabling novel declarative (spatial) queries for JSON objects. We will illustrate the basic concepts of the proposal and the possible use of its spatial and non-spatial operators for cross-analyzing open data and crowd-sourced information. This framework is powered by a plug-in for QGIS that can be used to write and execute queries on MongoDB databases.
Year
DOI
Venue
2017
10.1145/3106426.3106537
WI
Keywords
DocType
ISBN
Collections of JSONbjects, Geo-tagged data sets, Query Language for geographical analysis, Powerful spatial operators
Conference
978-1-4503-4951-2
Citations 
PageRank 
References 
0
0.34
2
Authors
3
Name
Order
Citations
PageRank
Gloria Bordogna1974103.99
Daniele E. Ciriello210.75
Giuseppe Psaila3722192.45