Spatio-textual spreadsheets: geotagging via spatial coherence

TitleSpatio-textual spreadsheets: geotagging via spatial coherence
Publication TypeConference Papers
Year of Publication2009
AuthorsLieberman MD, Samet H, Sankaranarayanan J, Sperling J
Conference NameProceedings of the 17th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems
Date Published2009///
Conference LocationNew York, NY, USA
ISBN Number978-1-60558-649-6
Keywordsgeotagging, spatial coherence, spatio-textual, spreadsheets

The spatio-textual spreadsheet is a conventional spreadsheet where spatial attribute values are specified textually. Techniques are presented to automatically find the textually-specified spatial attributes that are present in spreadsheets. Once the spatial attributes have been identified, an accurate translation of the values of the spatial attributes to their actual geographic locations is needed (known as geotagging). The key observation is that spreadsheets with spatial data exhibit spatial coherence --- that is, cells with spatial data that are nearby in the spreadsheet contain data that share spatial characteristics in the real world. These techniques also allow richer search engine results by returning actual tuples from spreadsheets instead of simply links to the spreadsheets. Moreover, when the search key is a particular location, results in proximity to the query can be provided rather than just exact matches.