3. Aerial Photo Retrieval System on PC 3D-CAD and RDBMS 
Most important features of flight records were documented into 
RDBMS in the same PC environment. 
3.1 Digitized aerial photos( Exposure stations) 
Most of the large scale aerial photos taken before the Earthquake 
and large and medium scale aerial photos after the Earthquake 
were digitized on the plotted topographical maps and coded into 
PC 3D-CAD environment. 
  
  
  
  
3.3 Database tables 
“Kobe Earthquake aerial photo retrieval system” consists of 16 
tables as follows; 
  
— 
  
  
  
  
  
  
  
  
  
  
  
  
Table Name |Contents Major fields |No.Data Remarks 
Ground Ctl. |GPS Xb,Yb,Hb 736 (National 
G.S.Il., Kobe, |Xa,Ya,Ha Municipal) 
Toyonaka (Bessel,TM) GCPs 
Leveling Pt. |G.S.1., Kobe, |Precise 187 wiDigitized | 
Toyonaka Crust Height Pt. position 
Exposure  |Before & Aft. |Co_Na,StrN |88+33 Proj. |10 Org. 
St. Earquake o,Ph_Na, |536/19000 {from maps 
Exterior Ori. |After Aerial |6 Ext. Orien.| 1336 Albany 
Parameters |Triangulation [Parameters Result 
3D residuals |G.S.I.,Kobe, [3D GCPs 440 Based on 
Toyonaka Movement GPS Pts 
Raster Ref. |Geological, |Image No. 13 Platform of 
Maps disaster, Topo |of Map Animation 
Image Data |Aerial Photo [Image No. 35 Platform of 
Ortho Photo Animation 
DTM Data |G.S.. 50m  |Map Sheet 10 Wireframe 
mesh No. of Animation 
  
  
  
Tab.7 Database tables in " Kobe Earthquake retrieval system" 
3.4 Query systems 
Many icon buttons are prepared for querying the following items. 
  
  
  
Fig. 6 Digitized flight lines and exposure stations 
Background of digitized vector lines and symbols is rasterized 
topographical maps or vectored digital maps. 
According to the range of the area, map projections were unified 
into UTM 53, using map projection software. 
3.2 Attributes on exposure stations 
To put additional attributes on the graphical symbols of exposure 
stations, PC RDBMS( MS-ACCESS) was used with ODBC 
routines of Microsoft Windows. 
Key application for this combination between CAD and RDBMS 
was AutoCAD Data Extension( ADE). 
It realizes 3 types of queries, both for graphical and textual 
attributes 
1) LOCATION(Graphic ENTITIES) 
Window,Potygon ,Buffer fence Circle 
2) PROPERTIES 
Color ,Area ,Attribute Layer, Linetype, Textvalue 
3) SQL QUERIES 
Table, Column Name,Where condition 
ADE handles with multiple map sheets seamlessly during querying 
the above mentioned queries. 
  
  
  
  
  
  
  
  
  
  
  
Query Name [Functionality Usage Data type 
DM Digital Map Background DXF, DWG 
FLC 3D-Studio Animation Image Data 
Hyoutei B Flight Line Flight Record |DWG 
Hyoutei A Flight Line Flight Record |DWG 
Kobeopen open mapsheet |.idx File open |IDX 
Zanbox 3D Movement |Parallelepiped |DWG 
Tin 3D Platform 3D View DWG 
Suijyun Leveling Pts Precise Crust |DWG 
Photo Exposure Sta. {Photo Image (Bmp 
Cam 3D Camera Fig.|Adjusted Pos. |DWG 
  
  
  
  
  
Tab. 8 Query types 
3.5 Preparatory refrieval system for disasters 
For disasters in possible areas in Japan, we can propose the similar 
preparatory retrieval system, derived from this “ Kobe Earthquake 
  
  
  
  
  
  
  
  
  
Project 
Requirements |Ground Ctl. Pts.|Aerial Photos |Reference 
Maps 
After Data Collection |Material Paper Maps 
Earthquake GPS surveying |Collection*A.T. |Scanning 
In the future Continuous GPS controlled |Raterized Maps 
GPS recorded flight 
Observatory pw 
Tab.9 Preparatory retrieval system 
346 
International Archives of Photogrammetry and Remote Sensing. Vol. XXXI, Part B4. Vienna 1996 
  
GP. 
by « 
Sur 
asr 
Bas 
pho 
ana 
Maj 
sup 
Mar 
1) GC 
2) GC 
3) Li 
4)P 
5)N 
6)C 
7) In 
8B 
Int 
For t 
1) Gl 
2) GI 
3)Le 
4) Pt 
5) Nc 
6) Ce 
7) Inr 
8) Bu 
Imag 
Inte 
Ther