Simple Tabular Dataset Kaarel Sikk 2012 Project background * data in - PowerPoint PPT Presentation

History of Estonian Archaeological Excavations. Geo- and Network Visualization of Simple Tabular Dataset Kaarel Sikk 2012

Project background * data in archaeology - a lot, uneven, not accessible * 2012 - list of archaeological excavations * no complete overviews so far * application for data visualization

Data sources 1 List of archaeological excavations - 1500 excavations (A. Tvauri, M. Konsa, K.Sikk, A. Kivirüüt) metadata: researcher, year, monument name, location (county parish), monument type (2 levels), register id

Data sources 1 http://www.arheo.ut.ee/kaevamiste-nimekiri Simile Exhibit faceted browsing environment

Data sources 2 Mapinfo work used for creating of Cultural Heritage application for Estonian Land Board Geoportal. http://xgis.maaamet.ee

Goal 1 Geovisualization Map application * distribution map * interactive * filter results * clearly distinct elements http://sites.google.com/site/animamap/muinas.swf

Goal 2 Network visualization Toorandmed paberil või arvutustabelis * social connections * work done in comparison * alternative view to research history * explore the possibilities

Problem 1 Visual channels * Icons on the map distinguish between monument types and researchers * Visual channels dedicated to data dimensions * Color schema?

Problem 2 Network visualization effect * pack maximum information to network diagram * 2 types of nodes (researcers, monument types, area) * relations between node types * quantities of node types * quantities of connections of node types * user's ability to select view and filter data * user experience and visual clarity

Implemetation 1 Data preprocessing * Extracting coordinates from Mapinfo files (Python scripting, Quantum GIS) * Getting missing locations (Google Geocoding API) * Joining coordinates to data (Googel Refine) * Storing data (MySQL database table)

Implementation 2 Web Application Structure

Implementation 3 Geovisualization application * Javascript application * Google Maps API v3 * JSON data transport * Filter: researcher, time range, monument type

Implementation 4 Visual channels * Visual channels: Text - researchers Colors - monument types (and subtypes) * Color schema 26 colors by Green-Armytage

Implementation 5 Network view * D3.js visualization library * Force-directed graph layout * Visual channels: Text - node names Line width - relation quantity Node size - node quantity Position - similarity * Provides comparison between nodes of same type together with connetcions * Filtering capabilities

Conclusions Feedback from users - positive * Created alpha version of application * Missing: Better map icons, graphics Color legend Additional data has to be added * Network - further work has to be done on making network view more easily understandable by people - new concept - may disappoint in a lot of cases * Finalize the application