Deutsches Archologisches Institut Zentrale Berlin IT Referat Frank

Deutsches Archäologisches Institut Zentrale Berlin, IT Referat Frank Schwarzbach, Frank Henze, Nadine Magdalinski, Benjamin Thurm, Philipp Gerth, Felix F. Schäfer, Alexander Schulze Open. Inf. RA: A Web based Information System for Documentation and Publication of Archaeological Research Projects Goals and Concepts funded by 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

OUTLINE - Overview and motivation - Overall goals - Special issues 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

OVERVIEW AND MOTIVATION Open. Inf. RA (Open Information System for Research in Archaeology) A web based system for data capturing, storage, analysis and publication of field projects in archaeology and neighboring disciplines. 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

OVERVIEW AND MOTIVATION Main results of shortcoming analysis Data are modeled, captured, processed, stored, analyzed and presented on a project specific manner high cost of building own IT solutions use of the data only within the limits of the project no sustainability of digital data after the project has ended isolated, non sustainable solutions Improvement is both a technical and organizational challenge! 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

OVERVIEW AND MOTIVATION user interfaces for offline data exchange interfaces to external web applications Digital library catalog ZENON Data sheets, blank forms Structured data (XML, CSV) Photo and object database ARACHNE Access, query, input, annotation, administration Image and raster data (JPG, TIFF) Import, export, of files and documents Open. Inf. RA Gazetteer Referencing, parametric request and query ancient places PLEIADES Metadata (XML, XMP) Engraved prints archive On demand Request Database (SQL, XML) Digital excavation archives GIS (SHP, KML) CAD (DXF, DWG) 2013 CNI Fall Membership Meeting, Washington Web applications Open. Inf. RA Web Services (WMS, WFS) data exchange via web services BTU Cottbus, HTW Dresden, DAI Berlin

OVERALL GOALS Open regarding - projects of national and international institutions, universities and other organizations - all methods relevant for archaeological and historical fieldwork, such as excavations, surveys, building documentation, drilling cores, etc. - large amounts of data of different types, e. g. structured data, text, images, spatial data - free access for open datasets - integration/coupling with neighboring systems - cross project analysis - implementation with Open Source Software - use of standards 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

SPECIAL ISSUES - General data model - Multilingualism - Distributed data management - Presentation and information retrieval 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

SPECIAL ISSUES: A GENERAL DATA MODEL Use of an existing domain specific conceptual schema (here e. g. CIDOC Conceptual Reference Model) plus the associated implementation specifications? savings of analysis and modelling effort subsequent use of the available software high level of semantic and syntactic interoperability But Users are determined to this particular application schema, the corresponding professional point of view on the “Universe of Discourse” and the underlying concepts. 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

SPECIAL ISSUES: A GENERAL DATA MODEL CIDOC CRM? 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

SPECIAL ISSUES: A GENERAL DATA MODEL 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

SPECIAL ISSUES: A GENERAL DATA MODEL Advantages high level of flexibility is obtained Newly added topics, attributes and relationships require no changes to the data model and the corresponding software components. Data exchange with CIDOC CRM based systems via XSL Transformation (already implemented). 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

SPECIAL ISSUES: MULTILINGUALISM ISO: Geographic information – Metadata – XML schema implementation (ISO/TS 19139: 2007) 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

SPECIAL ISSUES: DISTRIBUTED DATA MANAGEMENT - At all instances the same software is implemented. Central Server ("Open. Inf. RA Server") - Data can be maintained in parallel in all instances. Decentralized Project Server Mobile Computer 2013 CNI Fall Membership Meeting, Washington - Decentralized instances are mostly located in areas without permanent internet connection. Mobile Computer Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

SPECIAL ISSUES: PRESENTATION AND INFORMATION RETRIEVAL 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

SPECIAL ISSUES: PRESENTATION AND INFORMATION RETRIEVAL Results 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

SPECIAL ISSUES: PRESENTATION AND INFORMATION RETRIEVAL - text retrieval - SQL retrieval 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

SPECIAL ISSUES: PRESENTATION AND INFORMATION RETRIEVAL SQL-Extension (QSQL 2) SELECT FROM WHERE AND … … … height ~ 1. 80 WEIGHTED BY 0. 5 “Find all sculptures which have the original height (preserved or reconstructed) of around 1. 80 m (e. g. around life size) and search not only in the actual database for stone finds but look also in the old excavations reports which have been attached as PDFs to the excavations datasets. ” Alexander Schulze et al. : Openinf. RA – Storing and Retrieving Information in a Heterogeneous Documentation System. CAA 2012 Proceedings of the 40 th Conference in Computer Applications and Quantitative Methods in Archaeology, Southampton, United Kingdom, 26 30 March 2012 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

CONTEXT user interfaces for offline data exchange interfaces to external web applications Digital library catalog ZENON Data sheets, blank forms Structured data (XML, CSV) Photo and object database ARACHNE Access, query, input, annotation, administration Image and raster data (JPG, TIFF) Import, export, of files and documents Open. Inf. RA Gazetteer Referencing, parametric request and query ancient places PLEIADES Metadata (XML, XMP) Engraved prints archive On demand Request Database (SQL, XML) Digital excavation archives GIS (SHP, KML) CAD (DXF, DWG) 2013 CNI Fall Membership Meeting, Washington Web applications Open. Inf. RA Web Services (WMS, WFS) data exchange via web services BTU Cottbus, HTW Dresden, DAI Berlin

USER INTERFACE user interfaces for offline data exchange interfaces to external web applications Digital library catalog ZENON Data sheets, blank forms Structured data (XML, CSV) Photo and object database ARACHNE Access, query, input, annotation, administration Image and raster data (JPG, TIFF) Import, export, of files and documents Open. Inf. RA Gazetteer Referencing, parametric request and query ancient places PLEIADES Metadata (XML, XMP) Engraved prints archive On demand Request Database (SQL, XML) Digital excavation archives GIS (SHP, KML) CAD (DXF, DWG) 2013 CNI Fall Membership Meeting, Washington Web applications Open. Inf. RA Web Services (WMS, WF) data exchange via web services BTU Cottbus, HTW Dresden, DAI Berlin

USER INTERFACE Login List View Web. GIS Detail Context View Browser 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

INTERFACES user interfaces to external web applications Digital library interfaces for offline data exchange Digital library catalog ZENON Data sheets, blank forms Structured data (XML, CSV) Photo and object database ARACHNE Access, query, input, annotation, administration Image and raster data (JPG, TIFF) Import, export, of files and documents Open. Inf. RA Gazetteer Referencing, parametric request and query ancient places PLEIADES Metadata (XML, XMP) Engraved prints archive On demand Request Database (SQL, XML) Digital excavation archives GIS (SHP, KML) CAD (DXF, DWG) 2013 CNI Fall Membership Meeting, Washington Web applications Open. Inf. RA Web Services (WMS, WF) data exchange via web services BTU Cottbus, HTW Dresden, DAI Berlin

WEB SERVICES user interfaces for offline data exchange interfaces to external web applications Digital library catalog ZENON Data sheets, blank forms Structured data (XML, CSV) Photo and object database ARACHNE Access, query, input, annotation, administration Image and raster data (JPG, TIFF) Import, export, of files and documents Open. Inf. RA Gazetteer Referencing, parametric request and query ancient places PLEIADES Metadata (XML, XMP) Engraved prints archive On demand Request Database (SQL, XML) Digital excavation archives GIS (SHP, KML) CAD (DXF, DWG) 2013 CNI Fall Membership Meeting, Washington Web applications Open. Inf. RA Web Services (WMS, WFS) data exchange via web services BTU Cottbus, HTW Dresden, DAI Berlin

WEB SERVICES List of map services integrate into: Desktop GIS Web. GIS client 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

DATA INTERFACES user interfaces for offline data exchange Data sheets, blank forms Structured data (XML, CSV) Photo and object database ARACHNE Access, query, input, annotation, administration Imageand Image raster data (JPG, TIFF) Import, export, of files and documents interfaces to external web applications Digital library catalog ZENON Open. Inf. RA Gazetteer Referencing, parametric request and query ancient places PLEIADES Metadata (XML, XMP) Engraved prints archive On demand Request Database (SQL, XML) Digital excavation archives GIS (SHP, KML) CAD (DXF, DWG) 2013 CNI Fall Membership Meeting, Washington Web applications Open. Inf. RA Web Services (WMS, WFS) data exchange via web services BTU Cottbus, HTW Dresden, DAI Berlin

GEO-DATA IN ARCHAEOLOGY Vector data: position and geometry of finding situations, structural objects, . . . topography, settlements, land use, infrastructure, . . . current (measured) situation and reconstructions . . . Raster data: aerial images / ortho images scanned maps and plans digital surface and elevation models . . . 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

WEB-GIS ARCHITECTURE browser with 2 D- and 3 D-Client Internet providing 2 D / 3 D client Web-Server providing geo services (WMS, WFS, W 3 DS, . . . ) OGC-Server data management 2013 CNI Fall Membership Meeting, Washington 3 D Geo Data Base Open. Inf. RA GIS files BTU Cottbus, HTW Dresden, DAI Berlin

GEO-DATA IN ARCHAEOLOGY 2 D 2, 5 D 3 D 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

3 D WEB-GIS – APPLICATION AREAS 3 D visualization, query and archiving of single (smaller) objects small finds (e. g. ceramic) architectural elements (e. g. capitals) sculptures without breakdown into individual object parts 3 D visualization and analysis of complex objects or building models divided into several building parts (walls, ceilings, floors, columns, capitals, stamped tiles, stone marks) differentiation of the wall surfaces of a building structure distinction of findings/features and reconstruction 2. 5 D / 3 D visualization and analysis of settlements and urban models with different phases distinction of findings/features and reconstruction combined with classic 2 D Web. GIS LOD 3 D visualization, query, storage/archiving of original measured 3 D data especially point clouds possibly definition of sections / elevations 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

3 D WEB-GIS – PROTOTYPICAL IMPLEMENTATION visualization of static X 3 D files various display options (transparency, color, . . . ) "Mouse. Over" for individual objects link to data base objects via VRML/X 3 D anchor http: //geoinformatik. htw-dresden. de/openinfra/3 DWeb. GIS/ 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

3 D WEB-GIS – PROTOTYPICAL IMPLEMENTATION visualization of static X 3 D files various display options (transparency, color, . . . ) "Mouse. Over" for individual objects link to data base objects via VRML/X 3 D anchor visualization of point clouds CNI Meeting 2013, Dec. 9 10, Washington, DC Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

3 D WEB-GIS – PROTOTYPICAL IMPLEMENTATION visualization of static X 3 D files various display options (transparency, color, . . . ) "Mouse. Over" for individual objects link to data base objects via VRML/X 3 D anchor visualization of point clouds 3 D geometries via W 3 DS from Post. GIS standardized "Get. Scene" request advanced display options combined 2 D / 3 D geometries from Post. GIS Textured Terrain Models / CNI Objects Meeting 2013, Dec. 9 10, Washington, DC http: //geoinformatik. htw-dresden. de/openinfra/3 DWeb. GIS/ Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin

OUTLOOK Towards a working system • • • implementation of core system definition of an initial “Topics Framework” integration of search/retrieval, Web. GIS and 3 D realization of online- / offline-concept migration of project data from legacy systems integration external systems via defined interfaces • test of implementation • system introduction Further information: www. tu-cottbus. de/openinfra 2013 CNI Fall Membership Meeting, Washington Open. Inf. RA BTU Cottbus, HTW Dresden, DAI Berlin