The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences. Vol. XXXVII. Part B4. Beijing 2008 
70 
be implemented in PostgreSQL/PostGIS open source software 
package and will be capable to efficiently support the spatio- 
temporal analysis of the ship history. 
PostGIS offers a rich collection of spatio-temporal operations. 
Additionally, it may readily be connected to a desktop GIS or a 
Map Viewer in order to visualize the ship location on top of 
digital maps or geographic mashups (see Section 4.4). 
4.4 The Geographic Mashups 
A pilot application to present the most important events of the 
battleship using mashups has been implemented in Google 
Maps API (Figure 5). This application to highlight the powerful 
visualizations that may be readily obtained by combining the 
content of the Project databases and the geographic mashups. 
This application has been implemented in Google Maps API; it 
consists of an interface generated in HTML and visualizes the 
content of a KML (or KMZ) file. The latter has been generated 
by a Java script, which takes as input the result of a SELECT 
query in the historical photographs database (Figure 6). 
*' http «WW •'/r<*ruk, h*ï*vttv!Î kml' 
; 'tit 4# f A&owf -■ OMft fete#*.* 
j b : A * 
% * £3 - m • * 
V 1919 
1913 Nave's#» 
1918 Koivafavt’twuÆiiX^ 
1919*22 
1W1 Afjiifivifma 
1942 Bvp&zrt 
3 1944 
; 'UMSMftK 
: {95<Mì<>f«s 
1983 $«>. ï#x> 
# Ir*»** | npMfnrxuptfW) KStfenoC«« 
(a) 
V* * * bn»«, '«mef.fcmi' 
Wtwfcnupft 
Si * a • *r • ■ U» - :} Utaum • 
: m*A4№*e0t«U4 
a i9ii 
' 1912 
j » 1913 Naapajfi* A%ìmm* 
1918 Ki£MsxowmmìXi>)i^ 
5419 22 Sfcjfcwtj 
1926 T<wp*&v»ì (ftt/Ai») 
1941 
1942 Sòv&in 
1944 $óh*x» 
5945 
1996 
5483 
K OVv^OC» «so IO tyn&M OÌV Xa^OCSmtOf 
(b) 
Figure 5. The Google Maps API Application presenting the 
most important events of the battleship history; (a) 
all the placemarks, (b) focusing on the naval battle 
of Limnos. Available at: http://averof.dynalias.net/ 
averof kml 
4.5 The Spatial Database of the Ship Decks 
The Museum Archives preserve the initial paper plans of the 
shipbuilding company dated in the first decade of the 20 th 
century (Figure 7). Most of them have been partially destroyed. 
One of the Project scope has been the digitization/ vectorization 
of the ship decks plans and the generation of a spatial database 
which can then be used in several applications. Two of them are 
described in Sections 4.6 and 4.7. 
Figure 6. The procedure towards the generation of the Google 
Maps API Application. 
§ B E P 12 <I> 
^RAZZATO DI 10200 TON 
Figure 7. The scanned paper plan of the 1 st deck (part of). 
The spatial database has been implemented in ESRI ArcGIS 
software package. A separate shapefile has been generated for 
each deck, with polygonal features for all cabins, rooms and 
open-air spaces. The associated attribute tables have been 
populated with the corresponding equipment, machines or arms. 
4.6 Virtual Visits in the Museum “G.Averof’ 
A series of virtual visits to the Museum “G. Averof’ can be 
generated by loading the content of the Spatial Database of the 
Ship Decks (Secion 4.5) in a multimedia software package and 
authoring the visit scenario. 
In cooperation with the Museum personnel, we are currently 
composing a pilot virtual visit in the Museum (Georgakas 2008). 
The Adobe Flash (Micromedia) software package has been 
adopted to generate a web accessible virtual visit, while the first 
results are already uploaded at the Project web site (Figure 2). 
4.7 Virtual Presentations of the Daily “Life” on the Ship 
Similarly to the action presented in the previous paragraph, we 
plan to combine the Spatial Database of the Ship Decks 
(Secrion 4.5) with the Historical Photographs Database (Section 
4.1) and associate the photographs taken on the ship with their 
location (on the ship) both in space and time.