REDAS 2.

9
Operations
Manual
Version 2.9

Rapid Earthquake Damage Assessment System

Philippine Institute of Volcanology and Seismology

Department of Science and Technology

1
This is a manual in progress. Only functions and menus commonly
used are being explained here. We will continuously update the
manual and will also be posted in the REDAS yahoogroups. Feel
free to give your feedbacks to: leyobautista@yahoo.com

2
 ©
About REDAS
REDAS is a simple and user-friendly simulation tool or software that can give a
rapid estimate of the possible seismic hazards which can be used for inferring the
severity of impacts of an earthquake to various elements-at-risk. It has been
developed for use by disaster managers for making prompt decisions for quick
deployment of rescue and relief operations.

The development of REDAS was funded by the DOST-GIA and was developed
by PHIVOLCS-DOST from 2002-2004. The program consisted of two project
components: 1) Development of Seismic Hazard Models and 2) Development of
REDAS and building the risk database

Objectives of REDAS:

1. Provide quick and near real-time simulated earthquake hazard information

to disaster managers which will help them in assessing the distribution and
extent of the impacts of a strong earthquake.
2. To serve as a tool in convincing land use planners, policy makers, city and
town development planners and local government executives to consider
earthquake hazards in their planning and development efforts so as to
ensure long-term mitigation of seismic risks

Target Users of REDAS

1. Civil defense Officials/Disaster Managers/Local Officials
2. Policy Makers/City Planners
3. Rescue and Medical Groups
4. News Media

Authors of REDAS:

Maria Leonila P. Bautista (Program Coordinator),

Bartolome C. Bautista (Software Developer)

Ishmael C. Narag, Arturo S. Daag, Ma. Lynn P. Melosantos, Angelito G. Lanuza,

(Project Leaders)

Kathleen Papiona, Myleen Carlos, Joan Salcedo, Jeffrey Perez, Janila de Ocampo, Jane
Punongbayan, Esmeralda Banganan, Rhommel Grutas, Erlinton Antonio Olavere, Vilma
Hernandez, Roberto Tiglao, Melquiades Figueroa
(Project Members)

Renato U. Solidum, Jr. and Raymundo S. Punongbayan

(Development Consultants)

Philippine Institute of Volcanology and Seismology,

Department of Science and Technology,
C.P. Garcia Ave., UP Campus, Diliman, Quezon City
Tel: (632) 927 1096; 426 1468

3
REDAS Version 2.9
The “Rapid Earthquake Damage Assessment System (REDAS)”software as a tool for
mainstreaming disaster risk reduction into the local development planning process

Abstract

The few minutes after the occurrence of a large and potentially damaging earthquake are very
crucial in making timely decisions especially information regarding the deployment of relief and
rescue operations. The agency mandated to issue earthquake bulletins and provide pertinent
information to the public after an earthquake is the Philippine Institute of Volcanology and
Seismology (PHIVOLCS) of the Department of Science and Technology (DOST). This responsibility
becomes very important when large-magnitude earthquakes occur and the public wants to know
immediately the possible impacts and damages that a given event might have caused. To address
this concern, a simple and user-friendly simulation tool or software that can give a rapid estimate of
the possible seismic hazards which can be used for inferring the severity of impacts to various
elements-at-risk was developed. This software is called “Rapid Earthquake Damage Assessment
System” or REDAS. The software was developed by PHIVOLCS-DOST thru a Grant-in-Aid (GIA)
from the Department of Science and Technology (DOST). REDAS aims to provide quick and near
real-time simulated earthquake hazard information to disaster managers which will help them in
assessing the distribution and extent of the impacts of a strong earthquake. This could help them to
decide and prioritize the deployment of timely rescue and relief operations. The second objective is
for the software to serve as a tool in convincing land use planners, policy makers, city and town
development planners and even local government executives to consider earthquake hazards in
their planning and development efforts so as to ensure long-term mitigation of seismic risks. The
hazards that could be computed using this tool are ground shaking, earthquake-induced landslides,
liquefaction and tsunami. The risk database that are continuously being built in REDAS include
population centers, roads and communication networks, lifelines, high rise buildings, hospitals,
schools, churches, banks, markets, hotels, fire stations, power plants, dams and other critical
facilities. Other capabilities of REDAS include earthquake sorting capability, produces seismicity
maps, can perform query of data points, can produce maps of different sizes, can perform on-
screen map digitization and more importantly, it allows users to build their own risk database by
themselves.

To date, the software has been provided to some local government units (LGU). To make the
software address the other hazards including hydrometeorological hazards, the READY multi-
hazard maps are also incorporated in REDAS to make it multi-hazard in approach. For each LGU,
training on its use is also provided and the participants are also taught how to build their own risk
database using maps and GPS. The software is still being continuously improved by getting
feedbacks and inputs from users to make it more attuned to their needs.

4
Features and Capabilities of REDAS
• Seismic Hazard Assessment
• Risk Plotting
• Query Functions
• On-screen digitization
• Capable of developing own database

Flow Diagram how REDAS works

Chapter 1: Getting Started
• Basic REDAS Installation
• Installation of SQlite and Spatialite
• Installation of Quantum GIS
• Installation of the REDAS-EDM Module

1
Getting Started
a) Installing REDAS
An installation DVD contains all the files needed to run REDAS successfully.
REDAS should be installed using Administrator’s account. Login as guest is not
allowed. The correct specifications are illustrated below:

1. Copy REDAS folder to drive C:\. REDAS Folder should have at least 35 items in it
(31 folders, 2 REDAS icons).

Softwares to be installed by the batch file

• Visual BASIC
• Imagemagick
• DXF2XYZ
• Ghostscript

Instructions in Windows XP and Vista

2
2. Double Click ‘other required files’ folder

3. Double Click ‘install_redas’.

4. Installing Ghostscript.
4a. Click Setup.
4b. Click Install.
4c. Close the Ghostscript window.

3
5. Installing Imagemagick
5a. Click Next
5b. Tick “I accept the agreement” and Click Next

4
5
6
7. REDAS Setup

7
8
For Windows XP
C:\REDAS\other_required_files\

Follow installation prompts

For Windows XP, you will need to set-up the Environment Variables.

Environment Variables (for reference)

9
8. Creating Shortcut Key
Go to C:\REDAS and right-click the REDAS icon, click Send to Desktop(create
Shortcut).

10
9. Run as Administrator (for Windows Vista and Windows 7 operating systems)

10. Input License Key

11
11. Installation of the REDAS GPS Module

Follow installation prompts.

12
12. How to check if you installed REDAS properly.
Start
All Programs
Accessories
Command Prompt

12a. Type psxyz

The command prompt should look like this:

12b. Type gswin32.

The command prompt should look like this:

13
 12c. Type convert

The command prompt should look like this:

If the command prompt displays otherwise, please refer to solutions listed at page

14
Installation of the REDAS-EDM Package
Installation of MYSQL Components

1. Copy the root/REDAS/Exposure_Database folder to C:/REDAS in your

laptop/netbook/PC.
2. Within C:/REDAS/Exposure_Database folder, open the “installer” folder.
3. Double-click “mysql-essential-5.1.40-win32.msi”, choose complete installation, and
just click “Next” and “Finish” when prompted. When you get to the part on Detailed
Configuration, check “Additional” and include “bin”.
4. After that, double-click on “mysql-gui-tools-5.0-r17-win32.msi” and install using the
“complete” option.
5. Open mysql-connector-odbc-3.51.27-win32.zip and extract Setup.exe
6. Double-click on Setup.exe
7. When prompted use
Root password > mysql
8. After installing, you need to do a “database restore”.
9. To restore database, from the start menu, run “Mysql Administrator” and use the
following input:
Server Host : localhost
Username : root
Password : mysql
Leave other parameters blank or as is. A window on “MySQL Administrator –
Connection: root@localhost:3306” will open
10. On the left side of this window, you have several menus. Select “Restore” and on
the “General” tab of the “Restore” menu, click on “Open Backup File” and an
“Open” options window will open.
11. Browse to C:/REDAS/Exposure_Database/MySQL_Database_Backup/ and select
one of the two files in the folder.
12. Select “Start Restore”. If operation hangs, close window.
13. Repeat steps 11 & 12 for the other file in the
C:/REDAS/Exposure_Database/MySQL_Database_Backup/ folder. Close
restoration window.
14. Test check the restored data
15. From the start menu, run “MySQL Query Browser”
16. Make sure that the default schema is “BUILDING_DATA” and password is “mysql”
17. Click “Ok” and the Query Browser window will open. On the right hand side, select
“Iloilo_city” from the building_data schemata.
18. If you see some information similar to the image below, your data is working. Exit
from the MySQL Query Browser.

15
Installation Of The Exposure Database Module

a. Browse to C:\REDAS\EXPOSURE_DATABASE\installer\Package(REDAS EDM

Installer)
b. Double-click on setup.exe
c. Follow installation prompts.

Installation Of The Redas-Gps Module

a. Browse to C:\REDAS\EXPOSURE_DATABASE\installer\package(GPS installer)

b. Double-click on setup.exe
c. Follow installation prompts.

Installation Of The Logitech Webcam

a. Browse to C:\REDAS\EXPOSURE_DATABASE\installer\Logitec Webcam

b. Double-click on setup.exe
c. Follow installation prompts.

Finishing The Installation

1. Open REDAS
2. Click on REDAS EDM button within the REDAS Main Activity page to the Exposure
Database Module and a window with the title “Form 1” will open similar to the image
below.

16
3. Click on a corner space near the word “Form 1” and a window will open where you
can input the unit ID. Unit ID should be unique for each laptop/netbook/PC and
should follow naming conventions. Example of unit names are shown below:
ILO_01
ILO_02
DOST_01
DOST_02
OCD_001
PIVS_001
PIVS_002
It is strongly recommended that a database of the installations be kept within your
office and a copy provided to PHIVOLCS as well. Database should include unit
name, name of user, agency/office/division, and contact details, among other
information.

17
Chapter 2: Learning Key Features
• Launching REDAS
• Measuring Distance & Area
• Plotting Base maps
• Changing Map Parameters
• Saving, Editing and Printing Maps
• Annotating Maps
• Digitizing Polygons & Lines
• Introduction to REDAS Risk Database
• How to plot points, lines & polygons

18
Learning Key Features
Launching REDAS
1. Launch REDAS program by selecting the REDAS icon displayed on the
desktop. REDAS splash screen will be displayed. Click Continue.

2. ClickType in the username and password on the Login window. Click Next.

3. The REDAS main window will appear. Note the basic parts of the window. There
are 14 buttons, five pull down menus, indicative boxes, slider and ruler. The
Philippine map, with all its indicative earthquake source zones, is automatically
displayed. Explore the entire map by sliding the scroll bar or using the middle
mouse button.

19
Notes:
• REDAS maps are always oriented to the North.
• Scales are provided by the geographic coordinates found on the sides
of the map.
• REDAS is using linear geodetic projection with WGS84 datum to
conform with datum used in space imageries, digital elevation data
and other internationally available data including Google Earth
images, etc.
• Geographic locations are in deg.ddddd (degree decimal format).
• Data entry format is always longitude,latitude (x,y).
• Each point in a REDAS map is represented by a pixel (picture
element) whose value is shown (in light green background) in the
lower left boxes of the screen. The corresponding geographical
coordinates of each pixel is shown in the adjacent box (with yellow
background).

20
 Help texts are also displayed each time the mouse pointer hovers a
button (expect for Risk Data and GPS off buttons). This will explain how
each button works.

Basic REDAS Features

1) Measuring Distance
Optional: Click “Digitizer On.”
1. Click “Measure Distance” button.
2. To measure distance from Point A to Point B, left click a specific point on
the map (Pt. A) then right click Pt. B.
3. Estimated distance from Pt. A to B will be displayed in the Distance box.

21
2) Measuring Area

Optional: Click “Digitizer On.”

1. Click “Measure Area” button.
2. To determine the area of polygon ABCD, left click on Pts A, B, C, D and
close the polygon by clicking Pt. A.
3. After closing the polygon, right-click anywhere on the map to finish
defining the polygon.
4. Estimated area of the polygon will be displayed in the Area box next to
the Distance box.

22
3) Displaying Various Maps and Changing their Parameters
REDAS uses the Generic Mapping Tool (GMT) displayed by the University of
Hawaii, to plot various maps. As a result, you can not zoom in or edit on screen as
these involve reprocessing. Hence, points, lines and polygons are also not editable
on the screen. On the other hand, REDAS can handle big files and display large
files easily.

Click “Map Parameters” button. GMT parameters window will be displayed.

Plotting Various Kinds of Maps

a) Coastline Data. Tick the “Use Coastline Data” checkbox to display and edit
coastline land, ocean and coastline colors as well as coastline resolution. You can
change color by clicking on the palette and select you prefer. Coastline Resolution
varies from Low to Full.

23
 Note: Use of this map type is only ideal in regional scale.

b) Digital Elevation Model(DEM) Data. Tick the “Use 30x30 sec DEM (from
NGDC)” checkbox to use the DEM data from the National Geophysical Data
Center (NGDC).

c) Bathymetric Data. Check the “Bathymetric Data” checkbox to use to digital

bathymetric data from NGDC. You can choose from different bathymetric data
listed on the drop-down menu under the checkbox; or, you could also choose
your own data by using the Browse button. The different bathymetric data
ranges from etopo5 (5mi. x 5mi.) to 30sec x 30sec (best resolution).

d) SRTM Data. To display the SRTM data, check the “Use 3x3 sec SRTM data”
checkbox and choose from the available dataset listed in the drop-own menu.
Since files are too big, areas are divided into smaller regions such as Northern
Luzon, Southern Luzon, Visayas, Mindanao, Palawan and Sulu.

4.) How to Zoom into our Area of Interest

a. Using “Set Zoom Focus”.
1. In REDAS main window, click “Set Zoom Focus.” Click your target
area on the map. GMT parameter window will be displayed.
2. Click “Zoom in” until the target area is displayed inside a red box in
the map on the right side of the window.

24
 3. Click “Refresh” button below the Zoom Window Position map to
determine the coordinates of the coverage of the red box.
Coordinates will be displayed on the boxes above the Zoom/Pan
buttons.
4. To navigate in or around the area of the red box, use the
Zoom/Pan buttons. To move the red box anywhere on the map,
click on the new target area on the Zoom Window Position.
Update the geographic coordinates of red box, click Refresh.
5. To go back to the original base map, click Reset (found at the
center of the Zoom/Pan buttons.)

b. Setting geographic coordinates

Define the boundaries of the red box by specifying the geographic
coordinates bounding the area. Make sure that the box is equilateral,
meaning, the box is not too short or too long on one side. Otherwise, the
map will be clipped on the longer side.

25
 c. Axis Properties.
You can change the intervals for Annotation, tick marks and Frames
manually using the values listed in the corresponding drop-down menus or
use the default values.

d. Drawing Contour Lines

Contour lines corresponding to digital bathymetry and land
topography data can be used to draw bathymetry and elevation contour lines
respectively. Note that proper map should be used in generating contour
lines. (Bathymetry map for bathymetry contours; land topography for
elevation contours.) To generate contour lines, check the “Draw Contour”
checkbox. You can select your preferred color by clicking the color palette
box.

Edit the contour parameters by clicking “Edit Contour Parameter 1 (or 2)”.
Programmer’s File Editor (PFE) window will be displayed. PFE has a text editor that
you can use to input your desired contour interval in your maps. Type in the desired
contour interval (e.g. 1, 20, 50, 100) and if you want to add annotations in contours,
add “a” after the number (e.g. 1a, 20a, 50a). Click “Save” button to save changes.

26
 e. Paper Size
Adjust the paper size of the map depending on how detailed or
zoomed your map is. Bigger paper sizes like A0 allow you to view more
details on the map. Choose among the paper sizes in the Paper Size drop-
down list.

5.) Saving Maps

REDAS provides two options for saving maps for future retrieval.
Instead of Instead of typing file names and links, you will browse when
saving files.

1. Click “File” on the pull-down menus located on the upper portion of the
window. Click “Save Map.”

27
2. In the “Save As” window, navigate through the folders to save the file in
the target directory.

3. Replace the asterisk (*) in the *.map with an appropriate filename on the
“File name” text field.
4. Click “Save.”

28
6.) Editing and Printing Maps
Click “Edit and Print Map” button. You will be directed to a Paint window named
map2.bmp found at the bottom of the screen. Click the Paint window.

Editing Maps in Paint using Windows 7 OS

1.From Pull down menu of Paint, click “zoom out” twice.

2. Click “Crop”. A crop tool will appear, use it to select the figure to be cropped. Cut the
figure and paste on the same pallet. Click again crop and crop the figure to fill as one
page.

3. Choose an indicative file name and save as bmp or jpg in the exercise folder
“Redas_exercise” created in the desktop.

Editing Maps in Paint using Windows Vista OS

1. Click “edit and print map”. The Paint software opens with your figure on it. File
name is “map2.bmp” which you will see at the bottom of the page.

2. From Pull down menu of Paint, choose “select all” and drag the figure to the topmost
left portion putting the map coordinates at the edge of the page. You will see jagged
lines at the edges of the figure. You can now drag the figure.

29
3. After dragging, from the pull down menu of paint, choose “page setup”, select “fit to
1 to 1”

4. Choose Page Preview. You should see the map as a one page map.

5. You can crop by going to the leftmost bottom part of the figure and clicking the edge.
You will see a small green dot and when you put your mouse over it, you will see a
double sided arrow, drag the arrow and you can now use it to crop the figure.

6. Choose an indicative file name and save as bmp or jpg in the exercise folder
“Redas_exercise” created in the desktop.

30
Chapter 3: Multi-Hazard Mapping

• Hazard Maps
• Plotting Multi-Hazard Maps

31
Hazards and Elements at Risk
Hazards are potentially damaging physical events, phenomena or human activities that
may cause the loss of life or injury, property damage, social and economic disruption or
environmental degradation.

Elements at risk are elements that may be damaged or injured should a particular hazard
occur.

Types of Hazards
Type Examples
1. Hydro-meteorological strong winds, storm surge, flood/flashflood,
hazards rain-induced landslide
2. Earthquake-related ground rupture, ground shaking, landslide,
hazards liquefaction, tsunami
3. Volcano-related hazards ashfall, pyroclastic flow, lahar, lava flow

Hazard Maps
REDAS can be used to display hazard maps such as the Multi-hazard Map

Hazard Map Limitations

1. The maps are regional in scale (1:50,000.)
2. Hazard maps were produced under the various government projects. They were
either digitized or converted from original GIS files to REDAS. Some fitting error
could have occurred when converting from original maps to REDAS format. Care is
taken so that this is minimized. Always refer to the associated explanation in the
original hazard maps. (These are found among in the DVDs distributed in this
training.)
3. All the multi-hazard maps are worst-case scenario maps and are useful for planning
and disaster preparedness. (For how they were derived, please refer to the
associated powerpoint presentations for each hazard provided in the CDs.)
4. Whenever new maps become available or are updated, developers will send to you
(either via email or through PDRMMC or PPDO.)

Sources of Hazard Maps

Sources are the mandated government agencies to map particular hazards:

• Storm Surge – (1:50,000 scale) – PAGASA
• Rain-Induced Landslides and Floods (1;50,000) – MGB
• Earthquake, Volcanic and Tsunami Hazard Maps (1:50,000) - PHIVOLCS

Plotting Multi-Hazard Maps

1. Plot the base map area of or retrieve your provincial base map. Set the
boundaries and population centers.

The files are located according to specific folders such as:

32
In the following sections, you will learn the various hazard mapping features provided by
REDAS. Please take note of the procedures in loading various Point and Line files by
referring to the previous section. It is best to refer to the image file of the hazard maps
when choosing the colours for easy comparison between maps. For ground rupture, the
lines are either solid and dashed while for other hazards, the high susceptibility is red,
moderate susceptibility is pink and low susceptibility is yellow. Depositional zone is
chocolate.

Ground Rupture Hazard

REDAS provides line data for plotting location of active faults where the hazard of ground
rupture exists. Faults may be categorized to various ways depending on fault types

Plotting active faults: Load previous base map. Click Risk Data
Line Data
File

Browse for line data for faults under the Province/Line folder
Open
Check
corresponding Layers checkbox
Change Symbol, Thickness and Color (to differentiate
one type of active fault from the other types)
Plot Legend
Plot Data
Plot Map

Save Map inside Province\mapfiles\Ground_Rupture_Hazard.map

33
Sample Ground Rupture map:

34
Ground Shaking Map
Ground shaking hazard is represented by polyongs. Intensity VIII above is usually colored
red, Intensity VII as pink, VI as yellow. Data are classified depending on the earthquake
intensity using PHIVOLCS Earthquake Intensity Scale (PEIS).

Plotting ground shaking hazard zones: Load previous base map. Click Risk Data

Polygon Data
File
Browse for polygon data for ground shaking (in the
Province\Polygons\Ground_Shaking_Hazard folder)
Open
Check corresponding
Layers checkbox
Change Fill Type, Size and Color (to distinguish one earthquake
intensity from the other)
Plot Legend
Plot Data
Plot Map
Refresh map
Save
Map in Province\mapfiles\Ground_shaking_hazard.map.

Sample Ground Shaking Map:

35
Liquefaction Hazard
REDAS provides information about liquefaction hazards in the form of polygon files. The
data are usually grouped into three levels: high, moderate and low susceptibility.

Plotting liquefaction hazard zones: Retrieve provincial map. Click Risk Data
Polygon
Data
File
Browse for polygon data for liquefaction (in the
Province\Polygons\Liquefaction_Hazard folder)
Open
Check corresponding Layers
checkbox
Change Fill Type, Size and Color (to differentiate one level of susceptibility
from the other levels)
Plot Legend
Plot Data
Plot Map
Save Map in
Province\mapfile\Liquefaction_hazard.map.

Sample liquefaction map:

36
Earthquake-Induced Landslide (EIL) Hazard
REDAS provides information about earthquake-induced landslide hazards in the form of
polygon files. The data are usually grouped into four levels: high, moderate, low
susceptibility and depositional zone.

Plotting earthquake-induced landslide hazard zones: Retrieve your provincial base map.
Click Risk Data
Polygon Data
File
Browse for polygon data for earthquake-
induced landslide (in thePolygons\Earthquake_Induced_Landslides folder)
Open

Check corresponding Layers checkbox
Change Fill Type, Size and Color (to
differentiate one level of susceptibility from the other levels)
Plot Legend
Plot Data

Plot Map
Save Map in Province\mapfile\EILandslide_hazard.map.

Sample Earthquake-Induced Landslide map:

37
Tsunami Hazard
REDAS provides data on areas that are prone to tsunamis in the form of polygon file.
In some cases, there could be a corresponding point data to represent.

Plotting tsunami-prone zones: Retrieve your provincial base map. Click Risk Data

Polygon Data
File
Browse for polygon data for tsunami-prone zones (in the
Province\Polygons\Tsunami folder)
Open
Check corresponding Layers checkbox

Change Fill Type, Size and Color (to distinguish tsunami prone area from the background)

Plot Legend
Plot Data
To plot Wave height: Go to Point Data
Select Province

Point
Tsunami Wave Height file
Plot Map
Save Map.

Sample Tsunami Hazard map:

Volcanic Hazard

38
REDAS contain information on volcanoes and its hazardous products. The hazard zones
are classified into zones which are highly and moderately susceptible to lahars and zones
where pyroclastic flow and surges might occur.

Plotting volcano-related hazard zones: Retrieve provincial base map. Click Risk Data

Polygon Data
File
Browse for polygon data for volcanoes (in the Province\Polygons)

Open
Check corresponding Layers checkbox
Change Fill Type, Size and Color

Plot Legend
Plot Data
Plot Map
Save Map in
Province\mapfile\Volcanic_hazard.map.

Sample Volcanic hazard map:

Rain-Induced Landslide (RIL) Hazard

REDAS classifies areas into five groups based on their susceptibility to rain-induced
landslides. These groups are high, moderate, low and not susceptible(optional) and
depositional areas.

39
Plotting areas according to their susceptibility to RIL: Retrieve provincial base map. Click
Risk Data
Polygon Data
File
Browse for polygon data for RIL (in the
Polygons\Rain_Induced_Landslide folder)
Open
Check corresponding Layers
checkbox
Change Fill Type, Size and Color
Plot Legend
Plot Data
Plot Map

Save Map in Province\mapfile\RILandslide_hazard.map.

Sample Rain-induced Landslide hazard map:

Flood Hazard
Plotting flood-prone areas:Retrieve your provincial base map. Click Risk Data
Polygon
Data
File
Browse for polygon data for flood hazard
Open
Check corresponding
Layers checkbox
Change Fill Type, Size and Color
Plot Legend
Plot Data
Plot
Map
Save Map in Province\mapfile\Flood_hazard.map.

40
Sample Flood hazard map:

Storm Surge Hazard

REDAS provides storm surge hazard maps mapped by PAGASA-DOST.

Plotting storm surge hazard areas: Retrieve provincial base map. Click Risk Data

Polygon Data
File
Browse for polygon data for flood hazard
Open
Check
corresponding Layers checkbox
Change Fill Type, Size and Color (to differentiate water
level and year from other data)
Plot Legend
Plot Data
Plot Map
Save Map in
Province\mapfile\Storm_surge_hazard.map.

41
Sample Storm surge hazard map:

Saving and Loading Hazard Maps

Saving your map

 There are two ways of saving maps: (1) File
Save Map or (2) Edit and Print Map
button to activate paint window (Review Chapter 2) and save the map are .bmp or
.jpg file.

 Always save maps on appropriate folder. Provide an organize way of sorting files in
easily recognizable and properly name folders.

 Use easily recognizable file names.

 To open the saved file, select File
Load map and select the map you wish to
open.

42
Notes on the Hazard Maps in REDAS:

1. The previous discussions were on static maps that may be produced and displayed by
the REDAS software.

2. Dynamic maps for actual earthquake events can also be modelled by REDAS for real
and hypothetical earthquakes. These are ground shaking, liquefaction, earthquake-
induced landslides and tsunami.

43
Chapter 4: Map Digitizing Using
REDAS

• Annotating Maps
• Digitizing Polygons and Lines
• Concept of Digitizing
• Georeferencing
• Digitizing Points, Lines and Polygons
• Building your own REDAS Risk Databas
• REDAS Point Database
• REDAS Line Database
• REDAS Polygon Database
• Common Sources of Errors

44
1) Annotating Maps
Annotating maps means adding text labels or identifiers to maps to make it easily
understandable. In using REDAS, you use the digitizer function, define the desired text
style and appearance, save parameters in a text file and plot the desired annotation in
your map by using the saved text file.

1. Turn the Digitizer on by clicking the Digitizer button. From red indicator, it
should turn green.

2. Click “Annotation Data”.

45
3. Change the appearance of your desired annotation by changing the text
parameters.

Text parameters

Font Number:

46
4. Click on the desired annotation location on the map.

5. To save the text parameters, click the “Data” pull down menu, then
“Export Data”
“Digitized Data”
“REDAS Text Data”.

6. Choose the appropriate folder for saving the text file by navigating through
folder in the “Save As” window. Type in the appropriate file name in the “File
name” textbox. Click “Save”.

47
7. To plot the annotation on the map, select “tools” pull down menu, select
“Annotate map.” Annotation Data/Plotting Window will be displayed.

8. Click “File” button to direct the location of the text parameter file saved in
Step 6. Choose specific color in the “Color” selection box. Check the
checkbox before it. When finished, click “Plot Data.”

48
9. GMT parameters window will appear. Click “Plot Map.” Reload the map by

clicking .

Note: Before doing the next exercises, you have to click the “Memory Reset”
under the “Data” pull-down menu. In the prompting window, click OK.

49
2) Digitizing Polygons

This feature is very useful for planning routes, evacuation area and land use
delineation.

1. Turn the Digitizer on by clicking the Digitizer button. From red indicator, it
should turn green.

2. Begin tracing the polygon on the map by:

a. Starting point: Right click
Left click
b. Next points: Left click
Left click
Left click
…
Left click
c. Last point: Right click

50
3. To save the polygon, click the “Data” pull down menu, then “Export Data”

“Digitized Data”
“REDAS Polygon Data”. “Save As” window will appear.
Choose the appropriate folder for saving the text file by navigating through
folder in the “Save As” window. Type in the appropriate file name in the “File
name” textbox. Click “Save”.

51
3. To plot the polygon in the base map, click “Risk Data” button. “Risk Data
Plotting Menu” window will be displayed. Choose “Polygon Data.”
Polygon Data Plotting window will appear. Click “File” button to direct the
location of the polygon file saved in Step 3. Choose specific color in the
“Color” selection box. Check the checkbox before it. When finished, click
“Plot Data.”

52
 4. GMT Parameter window will prompt. Click “Plot Map.” Click Refresh or
wait for automatic refresh.

3) Digitizing Lines
1. Turn the Digitizer on by clicking the Digitizer button. From red indicator, it
should turn green.

2. Begin tracing the line on the map by:

a. Starting point: Right click
Left click
b. Next points: Left click
Left click
Left click
…
Left click
c. Last point: Right click

53
3. To save the line, click the “Data” pull down menu, then “Export Data”

“Digitized Data”
“REDAS Line Data”. “Save As” window will appear.
Choose the appropriate folder for saving the text file by navigating
through folder in the “Save As” window. Type in the appropriate file name
in the “File name” textbox. Click “Save”.

4. To plot the polygon in the base map, click “Risk Data” button. “Risk Data
Plotting Menu” window will be displayed. Choose “Line Data.” Line Data
Plotting window will appear. Click “File” button to direct the location of the
polygon file saved in Step 3. Choose specific color in the “Color”
selection box. Specify Thickness of the line. Check the checkbox before
it. When finished, click “Plot Data.”

54
4. GMT Parameter window will prompt. Click “Plot Map.” Click Refresh or wait for
automatic refresh.

Digitizing

Digitizing is a process that involves converting data into digital format. In our application, it
involves tracing information from maps or images in a geographically correct way.

In REDAS, we digitize in order to:

1. Develop a working database for use and/or analysis in REDAS and/or other
applications by
• Transforming paper maps/images into digital information.
• Using GPS devices to obtain information.

2. To integrate available data (e.g. CLUP, land use maps, zoning, etc) of a different
format outside REDAS and align it with existing data within REDAS.

Basic Concepts of Digitizing

Pixel – smallest item of information in an image

 Often represented by squares or dots
 Each pixel is a sample of an original image, where more samples typically
provide more accurate representations of the original
 Pixels are normally arranged in a 2-dimensional grid
 Pixel is a combination of the words “picture element”

55
In georeferencing (or Map Calibration in REDAS)

 It is necessary to assign correct geographic coordinates to the pixel value (x

& y) corresponding to a known longitude and latitude in the image

 By “linking” points on the image with those same locations in the

geographically referenced data, you will create a transformation that
converts the location of the entire image to the correct geographic location

 We call the linked points on each data layer “control points” or “ground
control points”

 Calibrate - to adjust precisely for a particular function1

 Georeference – To establish the relationship between page coordinates on a planar

map and real-world coordinates2;
– The process of aligning spatial data (layers of points, lines, and polygons) to an image
file such as a historical map, satellite image, or aerial photograph

 Orthogonal - 1 a: intersecting or lying at right angles b: having perpendicular slopes

or tangents at the point of intersection <orthogonal curves>1

Digitizing Uncalibrated Image

 Note: Make sure that image format is in bitmap (*.bmp) or converted to bitmap and
 That map has clear and well spread out geographical coordinates

Note:
 Advisable to have a hard copy of map on hand for reference and/or

 You are familiar with elements at risk on map

1. Run Bitmap Digitizer by selecting Tools
Run Bitmap Digitizer
Continue.

56
2. Open the image that you will work on: File
Open BMP File
Open.

3. Map Calibration:
a. Check map and find three orthogonal points with clear geographic coordinates
that will be used as ground control points wherein
1. Points are well spread out in the image
2. Crosshair of selected points are clear

57
b. Find the geographic coordinates (longitude and latitude) of these points by
referring to the hardcopy of the map.
c. Click “Calibrate Off” to turn it on.

d. Click on the 1st point, a coordinate window will appear. Type in the corresponding
X and Y coordinate. Click OK. Do this on the 2nd and 3rd points. Claibrate On button
automatically turns off after 3rd point.

58
3. Check map if calibration is correct by using all the ground control points.
Countercheck if the coordinates that appear on the coordinate panel is the same as its
coordinates in the map or hardcopy. Edit if necessary. Make sure calibration
parameters are correct before starting to digitize.

4. Save calibration configuration by selecting File
Save Configuration.

5. You can now start digitizing.

Digitizing Using Bitmap Digitizer

Note: Reset memory of Bitmap Digitizer window by selecting Data
Memory Reset

OK.

Digitizing points
1. Marker Settings. Select Tools
Change Digitizer Settings
Marker
Point.
2. Click Digitizer Off to turn it on. Select Vector Data.

3. Rename Attribute 3 from “EMPTY” to a specific feature name. This is important.

4. Click on the approximate center of the feature that you want to digitize.
5. When you made a mistake, select Data
Edit Digitized data. PFE window will
appear. Make the necessary adjustments in the PFE. Save your edits.

59
 6. To export point data, select Data
Export data
REDAS Point Data (XY). Save
on the appropriate folder. Click Save.

Tips:
 Create one file each for different points data in the points folder (schools.dat,
hospital.dat, stations.dat, etc.)
 Always reset memory before starting a new type of point data.
 Make sure that finished point features has been exported properly to REDAS
before clicking “Memory Reset”.

Digitizing Lines
1. Marker Settings. Select Tools
Change Digitizer Settings
Marker
Line.
2. Click Digitizer Off to turn it on. Select Vector Data.

3. Rename Attribute 1 from “EMPTY” to a specific line name. This is important.

4. To begin digitizing your line, right click THEN left click on your starting point to
register the 1st point of the line.
5. Continue tracing the line by clicking left-click ONLY on the succeeding points.
6. To mark the end of the line, right-click on the last point. A line should be formed
connecting all the points clicked.

60
7. When you made a mistake, select Data
Edit Digitized data. PFE window will
appear. Make the necessary adjustments in the PFE. Save your edits.

8. To export point data, select Data
Export data
REDAS Line Data (XY). Save
on the appropriate folder. Click Save.

61
Tips:
 Create one file each for different line data in the points folder (rivers.dat,
highways.dat,rails.dat, etc.)
 Make sure that finished point features has been exported properly to REDAS
before clicking “Memory Reset”.

Digitizing Polygons
1. Marker Settings. Select Tools
Change Digitizer Settings
Marker
Polygon.
2. Click Digitizer Off to turn it on. Select Vector Data.

3. Rename Attribute 1 from “EMPTY” to a specific polygon name. This is important.

4. To begin digitizing your polygon, right click THEN left click on your starting point to
register the 1st point of the polygon.
5. Continue tracing the polygon by clicking left-click ONLY on the succeeding points.
6. To mark the end of the polygon, left-click THEN right-click on the last point (this is
not necessarily the first point). A polygon should be formed connecting all the
points clicked.

7. When you made a mistake, select Data
Edit Digitized data. PFE window will
appear. Make the necessary adjustments in the PFE. Save your edits.

62
 8. To export point data, select Data
Export data
REDAS Polygon Data (XY).
Save on the appropriate folder. Click Save.

Exiting Digitizer and Continuing Work Afterwards

1. Close the map you're working on and open it again in the bitmap digitizer window to
append new data

a. Open bitmap file

b. Load configuration (if necessary)
c. Start digitizing

 Data will be appended accordingly when you digitize as long as you did not reset
the memory.

63
Building your own REDAS Risk Database
Risk databases are listings of elements at risk. REDAS classifies these elements
according to their form and content:
a. Points – particular spots
b. Lines – for linear features
c. Polygons – for areas

REDAS databases are stored as texts files, with file extensions .txt or .dat.) All
these files follow a specific structure so that REDAS will recognize it as a database.
You can create and edit databases using word processors like Notepad, Wordpad
and Microsoft Word (take note on the file extension to be used.) As for REDAS, its
default text editor is Programmer’s File Editor (PFE).

a) REDAS Point Database

To enter a new record in REDAS Database, it should have the following format:

“Latitude”, “Longitude”, “Detail1”, “Detail2”, “Detail3” …

Example: Sample Airport REDAS Database

“Longitude”, “Latitude”, “Name”, “Province”, “Elev”, “Class”…

121.9967, 14.3243, “Basco Airport”, “Batanes”, “23, “Domestic”
122.3234, 15.2345, “Laoag Airport”, “Ilocos N.”, “34”, “Domestic”

Notes:
• In REDAS, only the first two first, i.e. Longitude and Latitude, are not
enclosed in quotation marks (“), all the succeeding information must be
enclosed by quotes.

64
 • To indicate that you are typing in new field information in the same record,
comma should be used to separate an information from the other. In this
case, comma (,) is a delimiter.
• In specifying longitudes and latitudes, REDAS only recognizes coordinates
in decimal degrees format. The program does not recognize degrees-
minutes-seconds format.
Wrong: 121°48’12.23”, 4°12’15.21”
Right: 121.0834, 4.2042

Using Existing Point Databases in REDAS

1. To create database in REDAS, launch the Database Building Module. To do this,

click Data
Build Database
Point Data. Point Database Building Module will
appear.

65
 2. To understand the structure of a REDAS database, you need to load sample
database files first. Click “Load File” button and locate existing database files in this
address:
C:\REDAS\USER_DATABASE\REGIONAL\POINTS or
C:\REDAS\USER_DATABASE\METRO_MANILA\POINTS

Choose among the listed files and click Open. Familiarize yourself with the
database structure by examining the Database Builder Module window.

66
Adding New Data to an Existing Point Database

1. Load the database file by repeating the previous section.

2. Type in the new information in appropriate boxes.
3. Click Append to update the database and to add the new information.
4. To add next records of data and to prepare for new data input, click Refresh.

67
Attaching Photographs

The 9th row in the Database Building Module is designed for attaching photographs.
To use this feature, you need to type in the left box of the 9th row the word “picture”
or “risk photo”. To add pictures, click Browse button on the right side. Sometimes,
when the browse window is not active, erase the word “picture” or “photos” and
retype again.

Locate the address of the photograph. Finally, click OK.

68
Notes:
• All photos must be in jpg format.
• The file name must have jpg as extension. (Not jpeg)
• There must be no spaces between file names.

Creating New Point Database

1. Open the Point Database Building Module.
2. Type in all the field names (or categories) in the left boxes. (Example: Name,
Address, Contact No., Picture)
3. When completed, click “Create New File”. Save As window will appear. Save
the new file in an appropriate folder. Click Save.
4. To start adding information on the database, you need to load the saved file
first. Click Load File. Locate the saved file in the Open window. Click Open.
5. Update the database by following the same instruction in the “Adding New data
to Existing Database.”

69
b) REDAS Line Database
In REDAS, line data are edited using PFE. For REDAS to recognize the data as a
line, it should have the following format:

>name1
longitude1A latitude1A
longitude1B latitude1B
longitude1C latitude1C
>name2
longitude2A latitude2A
longitude2B latitude2B
longitude2C latitude2C
>

Example of REDAS Line Data:

70
 >EDSA
120.939375 14.835875
121.015875 14.885875
121.015375 14.908375
>Taft
120.994875 14.894375
120.986375 14.911875
120.933375 14.878375
>

Notes:
• At least two points define a line.
• Start every line data with a “greater than” symbol (>).
• Longitude and latitude must be separated by space.

Creating Line Data in REDAS

(Note: To begin each new exercise, always remember to clear the memory by clicking
Data
Memory Rest
OK.)

1. Click Risk Data button. In the prompting window, select Line Data. Line data
Plotting window will be displayed.

71
2. Click Edit button on the first row of the window. PFE window will prompt.

3. To create a new line data file, click the “New” icon (or File
New).

72
3. Start typing the line data.

73
4. When finished, save the file by clicking File
Save As.

5. Locate the appropriate folder, type in an appropriate filename and with .dat
extension and click Save.

c) REDAS Polygon Database

Polygons consist of lines joined together at common points. A polygon must start
with one point and close using the same point.

Polygon data is almost the same as creating line data. However, there are few
differences that must be taken to account. Below is the format for a polygon data:

74
 X name1
longitude1A latitude1A
longitude1B latitude1B
longitude1C latitude1C
longitude1A latitude1A
X name2
longitude2A latitude2A
longitude2B latitude2B
longitude2C latitude2C
longitude2A latitude2A
X

Example of REDAS Polygon Data:

XBulacan
120.939375 14.835875
121.015875 14.885875
121.015375 14.908375
120.939375 14.835875
XLaguna
120.994875 14.894375
120.986375 14.911875
120.933375 14.878375
120.994875 14.894375
X

Notes:
• For every polygon, the first line of data must be the same as the last line
before starting a new polygon. In the example, polygon Bulacan started
with coordinates (120.939375, 14.835875) and ended with the same
coordinates (120.93937, 14.835875).
• Start every line data with a capital X.
• Longitude and latitude must be separated by space.

Creating Polygon Data in REDAS

75
(Note: To begin each new exercise, always remember to clear the memory by clicking
Data
Memory Rest
OK.)

1. Click Risk Data button. In the prompting window, select Polygon Data. Polygon
data Plotting window will be displayed.

2. Click Edit button on the first row of the window. PFE window will prompt.

3. To create a new line data file, click the “New” icon (or File
New).

76
3. Begin typing the line data by following the format specified earlier.

77
 4. When finished, save the file by clicking File
Save As.

5. Locate the appropriate folder, type in an appropriate filename and click Save.

Converting Line Data to Polygon Data

2. Open the Line Data Plotting window by clicking Risk Data
Line data.
3. Click File button; locate and open the Line Data created on the previous exercises.
After clicking Open, you will be returned to the Line Data Plotting window. Click Edit
button.
4. PFE will display the line data you made. To change this into polygon data, replace
“>” with “X” and remember to repeat the first line of data as your last line to close
the polygon. Save the polygon data by clicking File
Save As.

78
Common Sources of Errors in Building Databases
• Quotation marks (“”) were accidentally erased.
• Excess number of fields.
• File name have spaces:
Wrong: Temporary Database
Right: Temporary_Database
• Wrong location of attributes.

79
 Chapter 5:

• Seismicity Assessment
• Seismic Hazard Assessment

80
Seismicity Assessment
One of the important uses of REDAS is to know the earthquake history of every
province in the Philippines.

To use Seismicity Assessment feature:

1. On the “Tools” pulldown menu, choose “Seismicity Assessment.” “Earthquake
Sorting Menu” window will be displayed.

2. Geographic Position. To determine the earthquake history of a specific area,

take note of the maximum and minimum latitude and longitude that bound the
area. Input the coordinate values in the four textboxes found in the Coordinate
Range Section.

81
3. Depth and Magnitude. You have the option to display earthquakes that are
within a specific range of depth and magnitude. To do this, input values in the
Depth and Magnitude textboxes respectively.

4. Earthquake Databases. You can display earthquakes based on a certain

earthquake catalogue/ database of your preference. To do this, select the
earthquake database that you wish to be sorted. List can be found on the
Earthquake Database section.

5. Click “Start Sorting”, then “Plot Map.”

82
6. GMT window will appear. Click “Plot Map.”

83
7. To understand the meaning of the symbols in the map, you need to display the
legend. To do this, go back to the Seismicity Assessment feature located under the
Tools pull-down menu. Click “Legend.”

Paint window named Legend2.bmp will be displayed. You can use this as
reference to know the meaning of the symbols in the map generated in Step
4.

8. To view the sorted earthquake data displayed in the map, go back to the
Earthquake Sorting menu window by selecting Seismicity Assessment menu. On
the Earthquake Sorting window, click “View Sorted Data”.

84
 Programmer’s File Editor window will be displayed. This window lists the
sorted earthquake information based on your specifications on Steps 2, 3
and 4.

To save the data, click File
Save As. Specify the desired folder and filename.
Click Save.

85
Interpreting Earthquake Data

Guide for Updating the Earthquake Database

1. Open the Earthquake Sorting menu window. (Tools
Seismicity Assessment).
2. Click the “Guide for Updating Database” button. A Notepad window will prompt
displaying the details about each record (a line in the earthquake database) listed
in PFE.

86
 Guide for Updating the SOEPD-PHIVOLCS database

1-4 station code

7-10 year
12-13 month
14-15 day
16-17 hour
18-19 minute
20-24 second
28-33 latitude
35-41 longitude
42-44 depth
48-49 number of stations used
50-53 Ml
54-56 Mb
59-61 Ms
87-90 rms
92-96 error in Latitude
98-102 error in longitude
104-106 error in depth
109 Marked with letter "T" if earthquake is tsunamigenic
110 Marked with letter "F" if earthquake is felt
115-238 Intensity account
239 classification ( F-forshock, M-mainshock, A-
aftershock, B- background seismicity)

Notes:
• This means that the first four characters of the line indicate the station code
(example, for PHIVOLCS = PIVS), the seventh to tenth characters show the
year, and so on.
PHIVOLCS Bulletins report earthquakes in Philippine Standard Time (a.k.a. local time)
but most modern-day catalogues list date and time of earthquake occurrence in universal
time.

Seismic Hazard Assessment

Ground Shaking

1. Assign location of epicenter. Use left mouse button to click on the location of the
earthquake epicenter to be used in computing hazards.
2. In the Tools drop down menu, click Seismic Hazard Assessment Menu.

87
Seismic Hazard Window should appear:

88
3. Click the Ground Shaking folder. The approximate location of the epicenter
should appear on the respective fields. If you know the exact parameters
(longitude, latitude, depth, magnitude and fault azimuth) of the earthquake, it
can also be inputted in the respective fields.

89
4. You can choose which shaded map scheme to use: PGA, MMI and PEIS.

Sample using Peak Ground Acceleration:

Sample Peak Ground Acceleration Map:

Sample using Modified Mercalli Intensity:

90
Sample Modified Mercalli Intensity Map:

Sample using PHIVOLCS Earthquake Intensity Scale:

Sample PEIS Map:

91
5. You can change the parameters after displaying the map.

To change the Fault Azimuth:

- Left click and right click on two points along the structure with the
epicenter located between the two points.

To change the Epicenter:

- Input the new coordinates of the new epicenter.

To change the Magnitude:

- Input the new Magnitude.

92
 To change the Depth:
- Input the new depth value.

6. You can also add a Site Effect to the computation of the hazard.

Landslide

After plotting the Ground Shaking assessment, you can also calculate for the
Landslide hazard.

1. On the Seismic Hazard Assessment Window, click on the Landslide folder.

93
 2. Select if Wet or Dry Season.
3. Click Calculate.
4. Click Plot Map.

Sample Landslide Hazard Map – Dry Season:

94
Sample Landslide Hazard Map – Wet Season:

Liquefaction
After plotting the Ground Shaking assessment, you can also calculate for the
Liquefaction hazard.

1. In the Seismic Hazard Assessment Window, click on the Liquefaction folder.

2. Select if Wet or Dry Season.

3. Click Calculate.
4. Click Plot Map.

95
Sample Liquefaction Hazard Map – Dry Season:

Sample Liquefaction Hazard Map – Wet Season:

Tsunami
After plotting the Ground Shaking assessment, you can also calculate for the
Tsunami hazard.

1. In the Seismic Hazard Assessment Window, click on the Liquefaction folder.

96
2. Click the checkbox for Plot Tsunami Heights and Abe’s Method.
3. Click Calculate Tsunami Heigthts and Arrival Times.
4. Click Plot Tsunami Map.

Sample Tsunami Hazard Map:

97
 The circles represent locations on the map with corresponding tsunami wave
height. The circles on the shore line represent the tsunami wave height and time of
arrival.

To calculate Tsunami Run-up

1. On the Tools drop-down menu, select Calculate Tsunami Run-up.

Form 1 window should appear:

2. Input the Magnitude and Source Distance.

3. Click the button for Hall and Watts (1953) and input the Nearshore Water Depth
(meters).
4. Click Calculate.

98
To calculate for Tsunami Inundation:
1. On the Tools drop-down menu, select Calculate Max Tsunami Inundation Distance.

Form 1 window should appear:

2. Input Dry Land Surface Roughness Constant (N) according to the type of land
surface.
3. Input the Runup Height.
4. Click Calculate.

99
Chapter 6: Building Exposure
Database Module

• Creating SQL Table and Setting-up Table in EDM Tool

• Getting Started with EDM

100
Creating SQL Table and Setting-up Table in the EDM
Tool
1.) Open MySQL browser. Start → All Programs → MySQL → MySQL Query Browser

2.) Input “localhost” as the Server Host. Use “root” as the Username and “mysql” as
the Password. In the Default Schema, input “BUILDING_DATA”.

101
 m

3.) The MySQL Query Browser should appear.

4.) In the File drop-down menu, click Change Default Schema.

102
5.) The Schema Selection window should appear. Select building_data folder and click
Ok.

6.) Under the building_data folder, right-click on the desired location. For this example,
let us use dagupan_city. Click on Edit Table.

103
Right click dagupan_city

104
 Press Edit Table

7.) MySQL Table Editor should appear. In the Columns and Indices tab, input the
following Data Type to the table.

8.) In the Column Details Tab, under Column Options, check Primary Key, Not Null
and Auto Increment.

105
9.) Click Apply Changes and in the Confirm Edit Table pop-up window, click Execute.

106
10.) Click the data file, in this case dagupan_city, and click Execute.

107
11.) Edit the SQL Query Area, “create table (new name) as SELECT * FROM
(original table) d;”. For example, palayan_city SELECT * FROM dagupan_city d;.
Click Execute and right-click anywhere under the Schemata tab and click Refresh.

108
 Right Click and Press refresh

12.) To create back-up table, edit the SQL Query Area, “create table (new
name)_backup as SELECT * FROM (original table) d;”. For example,
palayan_city_backup SELECT * FROM dagupan_city d;. Right-click anywhere
under the Schemata tab and click Refresh.

13.) To check on the newly created table, right-click the new file, in this example,
antipolo_city. And click Edit Table.

109
Right click the ‘new_file’
ex. antipolo_city

110
 Press Edit Table

14.) In the Column Details Tab, Under Column Options, check boxes Primary
Key, Not Null and Auto-Increment.

111
15.) Change the city and province accordingly.

112
16.) Edit the following data type in the MySQL Table Editor.

17.) Click Apply Changes and in the Confirm Edit Table pop-up window, click
Execute.

18.) Edit the City, Province and Unit ID.

113
 19.) Create folders for the new file. For this example, we create new folders for
Nueva Ecija.

Getting Started with Exposure Database Module

1. Open your REDAS software.

114
2. Click the REDAS EDM button.

3. On the REDAS EDM 1.0 window, select “Building” under the Database Type drop
down menu.

4. The Building Inventory window will appear with several Tabs.

The Geography tab has a green theme.

115
The Building Use tab has a cyan theme.

The Roof / Walls tab has a teal theme.

The Floor and Façade tab has an orange theme.

116
The Structural Info tab has a yellow theme.

The Attributes for Wind and Flood tab has a red theme.

The Photographs, Data Appending, Other Comments tab has a pink theme.

117
5. Click the File drop down menu, select Set Configuration.

6. Make sure the entries follow the following format:

For Map File:

For Map Config File:

118
 For Building Plot File:

C:\REDAS\EXPOSURE_DATABASE\BUILDING_DA
Province\City or Town\plot_files\test_plot.dat

119
 For Critical Facilities Plot File:

7. Edit for the appropriate Province and Town/City.

8. Save your configuration settings.

120
C:\REDAS\EXPOSURE_DATABASE\BUILDING_DA
Province\town or city\settings\ save ‘file.cfg’
(example: palayan.cfg)

Geography Tab
1.) The fields initially come with a loaded configuration.

121
2.) Search for a dummy Data ID #1 to display initial information and to set data format
for the next data to be appended.

3.) With GPS receiver connected, click Get GPS Data for current location (on the map
and its geographic coordinates displayed).

122
 Note: If familiar with (calibrated) survey map, GPS is not necessary to be
connected.

4.) Click Show Map for current location on the map and to view previously surveyed
data.

5.) Click point on the map for coordinates of the building for data capture.

123
Building Use Tab

Enter information on Building Use for the next data.(Building Use, Percentage of
Use, Approximate Number of People)
• Building Use:

• Percentage of Use
• Approximate Number of People

Roof/Walls Tab
Enter information on Roof/Walls.
• Roof Attachment:

124
*Parapets are upward extensions of the wall, sometimes with a coping at the top and
below.
• Roof Attachment Height
• Roof Decorations:

• Percentage for each roof type

• With Attic?
• Roof Pitch
• Wall Type/s and from & to what level each wall type
• Wall Attachment:

125
*A dormer is a structural element of a building that protrudes from the plane of a sloping
roof surface.
*An awning or overhang is a secondary covering attached to the exterior wall of a
building.
*An attic is a space found directly below the pitched roof of a house or other building(also
called garret, loft or sky parlor).

Floor/Façade
Enter information on Floor/Façade.

• Floor System:

• Floor Type:

• Floor Elevation from Street

Can be negative(-) if lower than the road.

• Sub-floor Footprint percentage

• Sub-floor Use

126
 • Basement Present?
• Ground Slope:

• Foundation

• Maximum Flood Level

Can be asked from house owners.

A facade or façade is generally one side of the exterior of a building, especially the front.
The word comes from French, literally meaning “frontage" or “face".

• Façade Type:

127
*A foyer in a house is usually a small entry area or room by the front door. Other public
rooms such as the living, dining and family rooms typically attach to it, along with any main
stairway.
*Punch window - A single pane window framed into the façade or wall.
*Panel window - As for a punch window but with multiple panels.

• Façade Projections:

• Main Window Type:

Structure Tab
Enter information on the Structure.
• Horizontal Plan:

128
• Vertical Plan:

• Year Built Range

• Year Build Exactly (if known)
• Width (usually front elevation)
• Depth (sides elevation )
• Number of Storeys
• Overall Condition

129
• Left Seismic Separation (distance to the next structure to the left of the observer
facing the subject)
• Right Seismic Separation (distance to the next structure to the right of the observer
facing the subject)
• Roof Frame Material

• Floor Frame Material

• Column Material

• Beam Material

• Bracing System (usually diagonal material connecting beam and column)

• Building Type

130
• Assessor’s Office Classification:

131
• UPD-ICE Structural System Type

132
*Those in RED are not included in the HAZUS-MH Building Classification.

Legend:
L - 1-2 storeys
M - 3-7 storeys
H - 8-15 storeys
V - 16-25 storeys
E - 26-35 storeys
S - 36 storeys and above

Wind and Flood Tab

Enter attributes on Wind and Flood.

• Roofing Material Support:

• Roofing Material Fastening:

• Roof Type:

133
 • Roof Frame System:

• Roof Frame to Column Connection:

• Internal Wall Materials:

• Opening in Walls
• Floor Finishing:

• Above Ground Parking(levels)

• Number of Basement(levels)

Photographs Tab
Photographs and Appending New Data

134
1. Click “Start Camera” to take picture of recently surveyed data, preferably all
elevations of the building. Then click “Take Picture” (on the webcam window).
Photos are automatically saved to “city/photo” folder.

2. Uncheck the Lock Key 1 check box.

3. Append, Update, Delete currently viewed data.

• Append – to add to database recently surveyed building.

135
 • Update – to replace recently viewed/edited point or building.
• Delete – deleting erroneous point data or sometimes doubly appended data

4. Taxable?
5. Filly up Surveyor Name/Office.

Reviewing Table of Point Data

• On the Geography Tab, click Display Table for Data ID of each point/building.

• Enter Data ID number of desired point to be viewed or edited. Click Search to

reload all point information back to survey windows.

136
• Change wrong information input then click “Update” on the last survey window(pink
window).

Exporting and Importing CSV Data

• Click “Export as CSV” to view the file using spreadsheet or excel. Click “Import
CSV” to import data in .csv format.

• Click Create REDAS Plot File to create file for overlaying in REDAS. The column
information is reduced to Data ID, Coordinates and Building Name. Point plot file is

137
temporarily saved at “city/plot_file/test_file”. Move the file to your “MyWork/MyPoint”
folder.

Chapter 7: Digitizing Risk Elements

Using GPS and REDAS

138
 • REDAS Data Digitizing Format

REDAS Data Digitizing Format

Using Handheld GPS
1. Turn on GPS (and Tracking On).
a. Click Page until Main Menu appears.

139
 b. Select Tracks, click enter. Select On.
c. Select Setup, click enter. Select Units.
• hddd.ddddd ; WGS 84
• Metric, Meters, m/sec, Celsius

2. Waypoint Measurement – 1 point system waypoints, risk elements like residential

houses, institutional facilities, bridges.
3. Tracking – 2 point system, straight line connecting two points, risk elements like
bridge, short road.

Note: Logged on field book and manually enter to REDAS database.

To input GPS readings to REDAS:

• Point Data
1. In REDAS click Data pull-down menu then select Build Database.
2. On Database Building Window click:
a. Load File – if the file where you want to append new data already
exists
b. Create New File – if the set of point data is a new category. Load this
file before entering point data readings.
3. Start entering longitude, latitude and point name.
4. Click “Append”.

• Simple Line or Polygon Data

Open PFE through Risk Data→Line/Polygon Data→Edit.

GPS Waypoint/Track Measurement using GPS with memory/data

storage

GPS with memory/data storage examples are Garmin 60CSx and 76CSx.

Waypoint Measurement and Recording

1. Turn GPS unit On. To save waypoint reading, press “Enter” and hold for a few
seconds for 76CSx. Just press mark for Garmin 60CSx.
2. Write readings to your field book, the number and the corresponding pont
information. If necessary, rename the point number.
3. Note that most of GPS units store 999 waypoints only. It is advisable to immediately
copy/upload the data from GPS before gets overwritten by next recordings.

BETTER to write readings on your field book then enter to REDAS using “Point Database
Buiding Module”.

Track Digitizing and Recoring

1. Turn GPS on with track/route on and it will store in its memory all traversed tracks,
unless track is off.
2. Each track is composed of several points.

140
Working with MapSource( Editing and Uploading Data)
1. Turn GPS on and connect data cable to PC.
2. Go to Garmin folder and double click MapSource icon.

3. In the MapSource window, click Transfer then select Receive from Device.
4. It will upload all data from your GPS until seeing the dialog box containing “The
data was successfully received”.

5. The uploaded file is saved in Garmin folder as “___.gdb”.

Working with ‘MapSource’ of Garmin (opening/editing data)

If data is already uploaded earlier:
1. Within MapSource, open pre-uploaded garmin file.
2. Click ‘File’ pull-down Menu of MapSource. Click “Open” then look for the location of
your desired Garmin file.

Example:
(C:\REDAS\USER_DATABASE\OLONGAPO\MyWork\GPS_Exercise\
Garmin_Data\OLONGAPO.gdb)

Converting Units and Positions

1. To edit or convert other information of the dataset, click “Edit” from pull-down menu
then select “Preferences”.
2. Units can be changed from english to metric by clicking “Units” on the pull-down
menu of the new dialog box.
3. The lat/long units shall be converted from degree-minute to degree decimals
(lat/lon hdd.ddddd).
4. Set datum to WGS 84 to fit the data with REDAS.

Saving File as ‘Text (Tab delimited)’

1. Click ‘File’ - Save as - file type - text (tab delimited) -file name

141
Example:
(C:\REDAS\USER_DATABASE\OLONGAPO\MyWork\GPS_Exercise\ tab_delimited\_.txt)

Importing ‘Text (tab delimited)’ Garmin data to REDAS as Line

1. REDAS is capable to directly import trackpoint Garmin data (saved as ‘text tab
delimited)’ into REDAS format.
2. Run REDAS then click ‘Data’ of the pull-down menu then ‘Import Data’, ‘GPS Track
File’, ‘GARMIN Decimal Degrees’. You will be asked which ‘tab delimited’ file (e.g.
zzz.txt) you want to convert as REDAS line data (zzz.dat)
3. The imported data will be automatically converted and saved as the same file name
of tab_delimited.txt but different extension as _.dat within the same folder
(tab_delimited)

Plotting on REDAS map (Trackpoints)

1. The converted line data can now be overlay\id to REDAS map by clicking ‘Risk
Data’ and ‘Line Data’
2. Note that the ‘converted.dat’ line data is temporarily saved at tab_delimited folder. It
is recommended to transfer the file to MyLine of MyWork folder.
3. (zzz.gdb > zzz.txt > zzz.dat)

These lines converted from Garmin GPS can be refined using REDAS.

142
Direct Digitizing using wireless GPS receiver & REDAS
(Example: Holux Bluetooth GPSlim)

143
1. Turn your bluetooth GPS receiver on and link it with your PC with REDAS software
(Bluetooth connection will depend on your system. The preferred com port where
PC and GPS communicate is com port 6)
2. Run REDAS. Create a map where you do the GPS digitizing (or open saved
basemap of OLONGAPO)

SAMPLE BLUETOOTH CONNECTION

1. Toshiba
2. Blue Soleil (USB Dongle)
3. Other (Generic)

144
3. GPS digitizing points will be appended and temporarily saved in ‘___.tmp’ file. To
check appended points and/or edit ‘___.tmp’ file, click ‘Data’ pull-down menu then
‘Edit Digitized Data’.
4. If data in digitizing memory is not needed anymore, these may be deleted by
clicking ‘Memory Reset’ under ‘Data’ pull-down menu.
5. Reference points on the map can be entered to REDAS map to guide the digitizing
process (e.g. population center)
6. Turn GPS Monitor ON by clicking side toolbox ‘GPS OFF’ then the monitor will pop-
up.
7. Choose communication port where the GPS receiver and REDAS will communicate
(comport 6 is recommended).

145
 8. The outlined box on the upper left of GPS Monitor will show the information of a
point location on earth surface
Position, Elevation, Data Status and number of satellites linked

Recording Waypoints to REDAS (Middle box of GPS Monitor)

1. When the link of GPS receiver to satellites is established (with A data status and at
least 8 sattelites are linked), recording can be started.
2. Recording of waypoints can be simultaneous with track points. The point temporary
reading will be appended to ‘mapfiles\_waypoints.tmp’.
3. To start saving/appending point reading, check ‘Start Averaging’ first, enter the
name of point and address then click save only once.
4. Click ‘Show Waypoints’ from time to time to check/edit recently appended point
reading or to add information about a particular point.
5. Save this file as “_____.dat (‘save as’) new text file once GPS measurement is
finished. The file will be ready for REDAS plotting.

Recording Trackpoints to REDAS (Outer right box of GPS Monitor)

1. To record a series of point, change name/s of track (Attrib1 & Attrib2) which will be
the name of track when imported to REDAS data format. Check ‘Start Tracking’ to
start appending trackpoint on the trackfile ‘mapfiles\___.tmp.
2. The tracking interval can be selected depending on tracking speed.
3. Unchecking ‘Start Tracking’ means end of one series of point (track). This will
create ‘99999,99999,99999,"From PHIVOLCS","to Calamba","","",“ which will
eventually converted as ‘> From PHIVOLCS’ once imported to REDAS.
4. Clicking ‘Show Trackfile’ will show ‘mapfiles\____.tmp’ files of trackpoints for
simultaneous editing or deleting erroneous points.

146
Monitoring of Trackpoint Reading
1. While reading and recording GPS data, a series of red-outlined dots on REDAS
map is seen at the same time.
2. Zoom-in/out to exact digitizing location on the map to monitor if reading and
recording is in progress.
3. This series of dots will blink every time a new dot is appended to temporary
digitizing file.

Exporting Trackpoints to REDAS as Line Data

1. Click ‘Data’ pull-down menu, select ‘Export Data’, ‘Digitized Data’, then ‘REDAS
Line Data’. You will be asked for file name and location to save the new line data
2. To plot the line data to REDAS map, follow risk plotting procedure by clicking side
menu ‘Risk Data’ and ‘Line Data’.
3. Clicking ‘Memory Reset’ under ‘Data’ pull-down menu erases all digitized data and
will erase red dots on the map.

This may be redigitized in REDAS to eliminate unnecessary lines or points.

147
Copying GPS Digitized Trackpoints or Converted Line Data from other REDAS to your
REDAS

(OPTION 1) Just copy the converted ‘___ line.dat’ file

(OPTION 2) From the REDAS tracking survey (to see ___.tmp tracking file)
1. Copy saved GPS digitizing mapfile together with its ___.tmp file
2. Bring the mapfile to other REDAS PC. Open it: File-Load Map
3. To re-load the same file: REDAS - File - Load Map - Select the
mapfile

Direct Digitizing using REDAS & cabled handheld GPS

(Example: Garmin 60csx and 76csx)
( just developed in January 2011 )
1. Prepare digitizing map with reference/indicative points and lines (e.g. population
center, available road maps)
2. CLEAR THE DIGITIZING MEMORY (‘Memory Reset’ under Data pull down menu).
Else, the new digitizing points will be appended to previous works
3. Connect Garmin GPS to PC using USB cable
4. Turn GPS ON
5. Click ‘Tools’ pull down menu > ‘Start GPS MODULES’ > ‘GARMIN (USB)’ > Garmin
GPS window/menu will pop up
6. Click ‘SET DEVICE’ for the GPS to communicate to PC
7. Choose the right GPS name by clicking ‘OK’. Else, click ‘Find Device’
8. Click ‘Start GPS’. The square box on the right corner of GPS main window shall
blink red indicating connection to GPS

148
9. Check ‘Tracking Mode’ box for recording trackpoints to REDAS digitizing _.tmp file.
The green square box on the upper left corner shall blink green, indicating
trackpoints recording to REDAS
10. You’re now ready for tracking as soon as the red outlined dot/s is seen on the
REDAS map continuously appending or congregating (depending on your speed).
Actual location is shown on Long/Lat boxes.

Note that the handheld GPS is also saving its __.gdb trackpoints in its own memory
which can be processed using ‘mapsource’.
Simultaneous digitizing trackpoints provided to REDAS can be directly converted as
line/s within REDAS and without any interface processes.

11. To convert digitizing trackpoints click ‘Data’ pull down menu > ‘Export Data’ >
‘Digitized Data’ > ‘REDAS Line Data’ and its appropriate line file name,
12. Saved to MyLine

149
Copying GPS Digitized Trackpoints or Converted Line Data from other
REDAS to your REDAS
(OPTION 1) Just copy the converted ‘___ line.dat’ file

(OPTION 2) From the REDAS tracking survey (to see ___.tmp tracking file)
1. Copy saved GPS digitizing mapfile together with its ___.tmp file
2. Bring the mapfile to other REDAS PC. Open it: File-Load Map
3. To re-load the same file: REDAS - File - Load Map - Select the
mapfile.

150
 Appendices

A: Using Google Earth for REDAS

B: Converting CBMS Data to REDAS Format
C: AutoCAD ® DXF to REDAS Format
D: Using SQLite
E: Error Messages in REDAS
F: Computer Basics
G: Five-Day REDAS Training Programme
H: REDAS EULA
I: Index

151
 Appendix A

Google Earth (Contributed by Joefel Lopez, Sorsogon DRMMO)

Google Earth is a virtual globe, map and geographical information program developed by
Google in 2004. It maps the Earth by the superimposition of images obtained from satellite
imagery, aerial photography and GIS 3D globe.

Launching Google Earth

1. On the desktop screen, double-click Google Earth shortcut.

2. Google Earth window will be displayed. Familiarize yourself with the parts of
Google Earth window.

3. To display a specific place, type in a specific place name in the Fly To: textbox.
Press Enter. You will be directed and zoomed in to your selected place.

152
Preparing Base Maps using Google Earth Images

1. Launch Google Earth. Fly to your area of interest. Check the area if it has higher-
resolution images. Gray squares and rectangles in the image usually mean higher
resolution version of the image is available.To use this, zoom in to the place by clicking
over that area.

2. To make it easier to create base maps, it is highly recommended to turn on the Grid View
by selecting Tools
Grid. Grid lines will appear over the images.

153
3. To start gathering images for your base map, you should keep in mind that all the
images that you will gather are all viewed at the same zoom level or eye altitude.
To check this, Eye Altitude status is located at the lower-right hand corner of
Google Earth window. Also remember to align the image to the true north direction.
Do this by double-clicking “N” at the upper left coner of the window.

4. Suppose that the base map is composed of several images that you need to stitch
together. Save the first image by selecting File
Save
Save Image... Move to
the other parts of your area and save the images.

154
Digitizing Lines & Polygons For REDAS Using Google Earth

1. Launch Google Earth and fly to the area of interest.

2. Since you are going to use the output for REDAS, you need to configure Lat/Long
measurements to decimal degrees. To do that, select Tools
Options. Google
Earth Options window will prompt the screen.

3. In the Show Lat/Long section, select Decimal Degrees. Click OK.

Digitizing Lines/ Polygons

155
1. To start digitizing, click the Polygon button on the toolbar located above the map.

2. New Polygon window will appear. Rename the polygon by assigning a proper name
for a feature that you need to digitize. You can also change the color, thickness and
fill of the polygon outline by selecting Style/Color tab. At this point, DO NOT close
the current New Polygon window. When you move your mouse pointer outside this,
it will change its appearance to crosshair.

3. Now, you can start digitizing a feature (example, building, river, etc.). Start by left-
click on one corner. Then left-click the successive corners of the building. You will
notice that bit by bit the outline of the building is generated. When finished, move
the mouse pointer to the New Polygon window, and click OK. Repeat the steps for
making new polygons.
4. After doing all the needed features, you will see the list of the names of the
polygons in the left-panel of the Google Earth window. The polygons are all
grouped under the “Temporary Places” folder.

156
5. Right-click the “Temporary Places” label and select “Save Place As…” Save the
places on an appropriate folder. (It is advisable to save this on Desktop). Take note
that you should save the file in .kml format (not .kmz). Click Save.

157
Editing KML Data to REDAS format

1. If you save the “Temporary Places” file on Desktop, right-click “Temporary Places

Open With
WordPad. WordPad window will prompt the screen.

5. In editing the file, remove all the syntax (generally with <>) leaving all the
coordinates in the text.

158
6. After removing KML syntax, add “>” or “X” to indicate lines and polygons
respectively.

159
 7. Open PFE, make all the necessary adjustments. If the coordinates are arranged in
lines and not in blocks, right-click the PFE screen and select Reformat Paragraph.
Take note of the following conditions:
a. All the elevation values (represented by 0 after the value for latitude) must
be removed in ALL lines.
b. Put “>” and “X” separators for every new line/polygon

Exporting Digitized REDAS Data to Google Earth

1. Launch REDAS 2.0.
2. Open a hazard map (with the file extension *.map)
3. Click Risk Data
Polygon Data. In the Polygon Data Plotting Window, find the file
address that pertains to your selected hazard map. Beside it, click Edit. Programmer’s File
Editor will appear. Do not close this window.
4. Launch Google Earth. Click Tools
Options.
5. Check “Show Lat/Long Settings” if it is in Decimal Degrees mode. Click OK.
6. Click to start digitizing polygons. Follow the steps same steps provided in the
“Digitizing Lines/Polygons” found in Appendix A: Google Earth. Please take note of the
following:
a. Create polygons of any shape with at least three points.
b. The names of the polygons are listed on the left side of the Google Earth
window.
c. Make sure that no. of polygons on the PFE file from REDAS that you counted
must be equal to the no. of polygons that you will create.
7. Right click on the folder that contains all the polygons you made on the left part of the
window. Select Save As
Select the proper folder to save the file (It is recommended to
save it on your Desktop for easy access.)
Sav file as “KML” not “KMZ”
Click Save.
8. Locate your saved file. Right click the file
select Open With…
Wordpad.

160
9. Go back to the opened PFE window in Step 3. Copy the portions of the text which
indicates the coordinates of points in the hazard map, do this by highlighting the
coordinates and pressing CTRL and C in the keyboard at the same time or click the Copy
button.
10. Shift to the Wordpad window, locate the coordinates of the points selected randomly
on Step 6. Replace these points by highlighting it and pressing CTRL and V keys at the
same time or rightclick
Paste.
11. After pasting the copied data, add commas between LAT and LONG of every line.
12. Save the file by File
Save.

161
 Appendix B

Converting CBMS Data to REDAS Format (Contributed by Analyn Z.

Galam and Nicasio Gatchalian of Maria Aurora, Aurora)

CBMS files such as lines, polygons and point data should be in .txt files follow these
steps:
a.) Plot a line (barangay boundary, road network, etc.) by adding layer.
b.) From File drop-down menu, select Export.

c.) Select specific destination of file.

d.) Save As type should be Latitude Longitude (*.txt)

An information window should appear to indicate that export is successful.

162
We are now ready to convert the data to REDAS format.

Converting .txt to .dat:

a.) Open the text file in Notepad.
b.) Under the Edit drop-down menu, select Replace.
c.) In the Find what field, input ‘ (apostrophe, symbol for minute) and in the Replace
with field, input , (comma). Click Replace All.

d.) In the Find what field, input N and in the Replace with field, input , (comma). Click
Replace All.

e.) In the Find what field, input E and in the Replace with field, input (empty space).
Click Replace All.

f.) Save the text file.

163
 Before Steps a to f: After Steps a to f:

g.) Open the text file in Microsoft Excel. In the Files of type field, select All files (*.*).

h.) Text Import Wizard will open. Choose your file as Delimited and start import at row
2 and click Next.

164
i.) Check box of Comma and click Next.

j.) Select General for Column Data format and click Finish.

k.) In column G1, enter the following formula to get the longitude:
=D1+E1/60+F1/3600
l.) In column H1, enter the following formula to get the latitude:
=A1+B1/60+C1/3600
m.) Right –click on column G, select Format Cells. In the Format Cells window, select
Number and change the Decimal places to 8. Do the same for column H.

165
n.) Click on cell G1, left-click on the lower right corner of the cell and drag down to the
last entry to copy the formula. Do the same for column H.

o.) Copy columns G and H to another Workbook. Right-click and select Paste Special.
On the Paste Special window, select Values and number formats then click OK.

166
 p.) On the File drop-down menu, click Save As. Choos Save as type as Text (Tab
delimited)

q.) Change the extension name from .txt to .dat to convert it into REDAS format.
r.) Plot the converted CBMS file in REDAS and edit the data in PFE be sure to use “>”
in the first and last line for plotting line and “X” in plotting polygons.

Note: Do the same process in converting polygons and point data. **In plotting the point
data first you must build your database and edit it in PFE.

167
 Appendix C

Converting DXF to REDAS Format

Note: This procedure is for converting files in UTM 50/51 only. If files being converted are
in PTM; they should convert this to UTM Luzon in order to follow this procedure. Else, the
converted points could jump in other reference longitude.

Prior to conversion, make sure that the dxf files are in the appropriate province folder. For
contours, rivers, roads, Create a Line folder, make a subdirectory for topomap. For
hazard maps, use polygon folder.

Important: The REDAS commits errors when encountering spaces in folder names (ex:
earthquake induced landslide maps.dwg). Use underscore “_” to replace spaces in folder
names and in files (ex: earthquake_induced_landslide_maps.dwg.)
It is also systematic to create distinct folder for each hazard and save all xyz, output and
input files there accordingly.

Step 1: Converting DXF to XYZ (UTM)

1. Go to Tools, go to Import DWG (Autocad) format data. Conversion Window will
appear.

168
 2. Click RUN DWG2DXF button. DXF2XYZ 2.0 window will appear. (Take note of the
location of the Save XYZ button. See figure below. You will use this in step 4.) Locate the
dxf file that you want to convert. Press Output Format button.

169
3. In Output Format button, check 2D and Entity Header checkboxes.
Click OK.

170
 4. Press save filename.xyz. (As located in Step 1).

You will see a message at the bottom part of the window that says
“successful conversion”.

This means that the dxf file was converted to xyz format. The filename
now has an xyz extension. Proceed to Step 2.

Step 2: Converting XYZ (UTM) to GEOTRANS format

1. In the Conversion window, press “Convert to geotrans input”. A dialogue box will
prompt you to look in converted xyz file. The filename again is based on the original
dxf file but the extension is xyz. Be careful in choosing the correct file. Look for the
original folder where you saved the dxf. Upon pressing the “convert to geotrans
output” button, you will see at the bottom of the folder that the processing indicator
activate to signify processing was done.

171
2. View/edit output of geotrans by pressing “edit output” button. This is done to see if
the conversion was successful and to check some errors. The xyz is still in UTM
and two more steps are needed to convert to lat long and finally to REDAS format.
Scroll down the converted output file. The file is automatically named
geotrans_input.dat

172
Step 3: Converting geotranslated xyz (UTM) to lat long format
1. Go to redas/geotrans2.2.6/geotrans2/win folder. Click geotrans2.exe to run
Geographic Translator V2.2.6 or geotrans2.2.6

173
2. First, go to options and select “degrees” under decimal units and “+/-“ for
sign/hemisphere.

174
3. Then, select file open geotrans_input.dat.

File Processing window will open. You will see Luzon_A datum and Clarke 1866
ellipsoid as input. Make sure you are in the correct folder. Set output to wgs84 and
geodetic.

175
4. Save as geotrans_output.dat. You will need to rename to “geotrans_output.dat”
here. Make sure you are in the correct folder.
5. You will see a “Geotrans file processing” window , press “start”. Press “OK” when
completed,

6. Close Geotrans v2.2.6 window.

7. Edit output; check output for trash. Copy the name of layer.

176
 8. Take note of how layers were named as this will be the individual layers to be
converted to REDAS format.

Step 4: Converting to REDAS format

1. Specify Layer you want to convert. Paste the layer name you copied to the layer
textbox. Indicate layers as per names used in the geotrans_output.dat file. It is best
to save layer by layer (ex. 0-100 layer or 0 elev layer). Take note of capitalization,
space delimitation, etc, as the program will look for attribute title as typed.

2. Click “Convert to REDAS”. You will be asked to specify file. Choose

geotrans_output.dat in the appropriate folder. Erase # or any marking.
3. Click “Edit output”. Check for possible errors like 0,0 before the first line and
isolated “degree numbers” (ex. 125) at the end of the text file. Clean up any errors.

177
 4. Save file as redas.dat file. More importantly, you can now save the converted layer
into appropriate folders (whether line or polygon). Take note to use “>” for lines
and “X” for polygons. Usually, lines are used for contours, roads, rivers and
polygons for hazard maps.
Appendix D

SQLite
Characteristics of SQLite
1. Non Server based
2. Portable
3. Easy to build database from csv file
4. not secure
5. User-Built Database
6. Possibility for Spatial extension using “SPATIALITE”

Using SQLite in Database Creation for REDAS

1. Copy a sample.dat file and change into .csv file. To do this, right click on the file
and change .dat extension into .csv. The file will change icon to csv format
2. Open the saved.csv file into Microsoft Excel (Spread Sheet) by double clicking the
file.
3. Insert a new column before the “LONGITUDE” and label the header with
“DATA_ID”. Enumerate the newly inserted column. To do this, type 1, 2, 3 in the
succeeding rows from the DATA_ID label.Highlight the three boxes and dobleclick
in the lower corner edge of the three highlighted box.

178
4. Add 5 new column at the last column and label the header respectively: PHOTO1,

PHOTO2, PHOTO3, PHOTO4, UNIT.

5. Edit the headers of each column; remove all symbols

Reminder:
Do not use any symbols ( ; “ : / = - # ) except “_” underscore in between two words.

6. Save copy as .csv file. Close the excel file.

7. Open SQLite found at C:\REDAS\SQLITE_BROWSER

179
8. On the SQLite Database Browser Window, select File
New database
Save As
filename.db in C:\REDAS\NEW_USER_DATABASE\Province\POINTS. (Note: A
Create Table Window will show, just cancel/close the window)
9. Select File
Import
Table from CSV File. Note: Browse for the csv file you
saved a while ago. On the Create Table from CSV File window, fill up the New
Table Name, click on the Extract field names from the first line, then Create.

180
10. Save the database by clicking on the diskette symbol and close the SQLite
Application.
11. Run REDAS 2.5.

12. Scroll down or the TABLE NAME. Load the saved Database.

13. Now you are ready to query your database, plot file, display photo and
add/delete rows.

181
182
14. Display the created database using REDAS by following the figure below.

183
15. Create a new folder in this path:
C:\REDAS\NEW_USER_DATABASE\Province\POINTS\PHOTOS\UNIT_ID
Copy the file name and paste in the table, click on the next row for it to be saved.
Note: the file name should have no spaces and have .jpg extension

184
 Appendix E

Error Messages in REDAS

When a program is running, or executing, it is said to be in runtime. The term is mostly used by
programmers to specify when errors in a program occur. A runtime error is an error that happens
while the program is executing.

In REDAS, when runtime error occurs, a small error window will appear, displaying the error
message. Error windows look like this:

Error Message Nature of Error Recommended Solution

Error ‘76’ REDAS was placed in desktop or other Cut the REDAS folder and paste it to
folder and not in drive C: C: root folder.

Run-time Error '339' Component 'comdlg32.ocx' or one of its Copy the comdlg32.ocx from the folder
dependencies not correctly registered: a REDAS/other required
file is missing or invalid. files/package/support, then paste in the
c:/windows/system32. (In some cases,
copy it in the drive c root directory is
enough). Restart the computer then
REDAS will work.
Error ‘55’ Error in encoded data Edit the .dat file using PFE or
Wordpad. Look for error in
typing/syntax. Save.
Error ‘13’ Full Memory Click data, memory reset
Runtime error 9 This happens during Seismic Hazard Select only a small area to conduct the
Assessment module when the whole seismic hazard assessment
Philippines is selected instead of a small
area only
Error ‘11’ Division by zero when plotting tsunami In C:\REDAS, right click .gmtdefault4
circles. and open with Wordpad, then change
the following: D_format=%.12g to
%1g. (if already %1g, retypr as %1g).
Then edit OUTPUT_degree format and
Change D to +D. (if already +D, just
change to +D). Then “Save”.
Fatal Error Program was not built to run on the Usually this happens when the OS is
processor on your system. the allowed not legal. The new GMT conflicts with

185
processor are Intel ® etc. the OS. To solve, rename the GMT
with GMT_new and rename the
GMT_old with GMT.

186
 Appendix F

Computer Basics
Windows Interface

Mouse Operations

187
Miscellaneous User Interface

1. Drop-down list – allows you to choose

among the listed options which will appear
after you press the inverted triangle drop-
down arrow on the right hand corner of the
feature.

2. Check box – allows you to do multiple

selections on the listed options.

3. Radio button – allows you to choose

only one option among the listed options.

4. Text box – provide space for typing in

text characters needed

188
 Appendix G

MAINSTREAMING DISASTER RISK REDUCTION INTO

LOCAL DEVELOPMENT PLANNING PROCESS
THROUGH THE PROVISION AND TRAINING
ON THE USE OF REDAS SOFTWARE

Day 1
07:00AM Registration
Pre-installation of REDAS software
08:00AM Opening Ceremony
09:00AM Orientation/Briefing (House Rules)
09:15AM Introduction to PHIVOLCS
09:45AM Coffee Break
10:00AM Earthquake and Earthquake Hazards
10:45AM Hydro meteorological Hazards
11:30AM Introduction to REDAS

12:00PM Lunch Break

01:00PM REDAS Application

(Case Study on the Vulnerability to Earthquake Hazards of Gabaldon, N. Ecija)
01:45PM Basic Map Reading
02:45PM Coffee Break
03:00PM Configuration and Final Installation of REDAS

Day 2
08:00AM Learning REDAS Features (Part 1)
09:45AM Exercise 1. Plotting base maps of your municipality
10:00AM Coffee Break
10:15AM Learning REDAS Features (Part 2)
Exercise 2. Plotting risk maps of your municipality

12:00PM Lunch Break

01:00PM Risk Database Development (Points, Lines & Polygons)

02:00PM Annotating Maps, Digitizing Lines & Polygons
03:00PM Coffee Break
03:15PM Earthquake Catalogue & Seismicity Maps
Exercise 3. Determining Maximum Earthquake in your area

Day 3
08:00AM Learning REDAS Features (Part 3):Built-in hazard and Risk Data
Exercise 4. Plotting the hazard and risk in my municipality and filling
up Template 1*

189
10:00AM Coffee Break
10:15AM Seismic Hazards Assessment
Exercise 5. Prepare ground shaking map for specific Earthquake

12:00NN Lunch Break

01:00PM Map Digitizing

Exercise 6. Digitizing risk elements and developing REDAS database
(Making your own Database using maps)
02:45PM Basic Concepts of GPS
03:00PM Coffee Break
03:15PM Presentation of Outputs (Exercise 6)
03:45PM Digitizing using GPS (Introduction to GPS fieldwork)
Execise 7a. Plotting Simple GPS Point and Line Data

Day 4
08:00AM Fieldwork (GPS measurements)
11:15AM Data Uploading and Putting GPS data into REDAS

12:00NN Lunch Break

01:00PM GPS Data Processing/Plotting to REDAS

Exercise 7b. Uploading GPS Trackpoint Data to REDAS
Exercise 7c. Converting Line Data from REDAS GPS Digitizing
Trackpoints
03:00PM Coffee Break
03:15PM Presentation of GPS Fieldwork Output
03:45PM Introduction to Workshop
(*Template 1: How to Mainstream Hazard Assessment to Land Use
Planning)

Day 5
08:00AM Workshop / Participants presentation
10:00AM Coffee Break
01:00PM Reviewing REDAS functions
01:30PM Starting to use REDAS at my office

12:00NN Lunch Break

03:00PM What’s Next and other concerns

04:00PM Closing Ceremony Awarding of Certificates

190
 Appendix H

END-USER LICENSE AGREEMENT

FOR THE REDAS SOFTWARE
This End-User License Agreement is a legal agreement between the user (either an individual or a
single entity) and the Software Developers (PHIVOLCS-DOST) for the REDAS Software, which includes
computer software and associated media and printed materials, and may include “online” or
electronic documentation. By installing, copying, or otherwise using the REDAS Software, you agree
to be bound by the terms of this agreement.

The Rapid Earthquake Damage Assessment System Software, hereafter referred to as REDAS, is a
copyrighted software, protected by Philippine laws on Intellectual Property Rights. The software is licensed,
not sold.

1. GRANT OF LICENSE: This agreement grants you the following rights:

a. You may use one copy of the REDAS Software on a single computer. The software is in
“use” on a computer when it is loaded into temporary memory (i.e. RAM) or installed into
permanent memory (e.g. hard disk, CD-ROM, or other storage device) of that computer
b. The REDAS software provided by PHIVOLCS-DOST shall be used exclusively for this project
and for PHIVOLCS-DOST activities. A limited number of REDAS copies, equivalent to the
number of training participants, shall be installed in computers at no cost for this training.
Limited additional copies of REDAS can be installed upon written request at no cost.
c. The PHIVOLCS-DOST REDAS Software and Database are not for distribution and shall not
be used for any personal transaction, private business of commercial nature or any other way
not explicitly agreed upon by both user and developer.

2. UPGRADES. Future upgrades of REDAS, if and when available, and technical assistance will also
be provided by PHIVOLCS-DOST at no cost. If the REDAS Software is an upgrade, you may use or
transfer the REDAS Software only in conjunction with the upgraded product. You may now use the
upgraded product only in accordance with this agreement.

3. SUBSCRIPTION UPDATES: Third-party users of REDAS through collaboration with the Primary
Users shall first secure written consent from PHIVOLCS-DOST.

4. COPYRIGHT: All title and copyrights in and to the REDAS Software (including but not limited to any
images, photographs, animations, video, audio, music, text, and “applets” incorporated into the
REDAS Software), the accompanying printed materials, and any copies of the REDAS Software are
owned by PHIVOLCS-DOST. The REDAS Software is protected by copyright laws. Therefore, you
must treat the REDAS Software like any other copyrighted material except that you may either (a)
make one copy of the REDAS Software solely for backup or archival purposes or (b) install the
REDAS Software on a single computer provided you keep the original solely for backup or archival
purposes.

5. DESCRIPTION OF OTHER RIGHTS AND LIMITATIONS

191
 a. Limitations on Reverse Engineering, Decompilation and Disassembly. You may not
reverse engineer, decompile or disassemble the REDAS Software, except and only to the
extent that such activity is expressly permitted by applicable laws notwithstanding this
limitation.

b. No Separation of Components. The REDAS Software is licensed as a single product and

neither the software programs comprising the REDAS Software

c. Software Transfer. You may permanently transfer all of your rights under this Agreement,
provided that you retain NO COPIES, you transfer all of the REDAS Software Products
(including all component parts, the media and printed materials, any upgrades, this
Agreement and if applicable the Certificate of Authenticity) and the recipient agrees to the
terms of this Agreement. If the REDAS Software is an upgrade, any transfer must include all
prior version of the REDAS Software.

d. Freeware. As the REDAS Software package comes with freely distributable software such
as GMT, ImageMagick, GhostScript and Pfe, the users should strictly abide by the User
Agreements set by the respective software developers and distributors.

e. Termination. Without prejudice to other rights, PHIVOLCS-DOST may terminate this

Agreement if the user fails to comply with the terms and conditions of this Agreement. In
such event, you must destroy all copies of the REDAS Software.

I hereby agree to the terms and conditions of this End-User License Agreement for the
REDAS Software

______________________________________
Printed Name/ Signature of REDAS User

Position and Office: ____________________

Date: ________________________________

Hardware Authorization No: ____________

Location of PC: _______________________

Purpose of REDAS usage: _______________

Contact Numbers and email: ____________

192
 Appendix I
Index

axis properties -exiting and continuing work georeferencing

-annotation
-tick digitizing using Google Google Earth
-frame Earth -launching
-lines -searching places
annotating maps -polygons -creating base maps
-stitching maps
annotation digitizing using REDAS
-lines ground rupture hazard
areas, measuring -polygons
ground shaking hazard
bathymetric data distance, measuring
hazards
Bitmap digitizer earthquake information -types
-sorting
coastline data -interpreting hazard maps
-updating -limitations
contour data -sources
earthquake history
conversion -by geographic location help texts
-KML to REDAS -by depth and magnitude
-DXF to REDAS -by source database installation, REDAS
-DXF to XYZ
-XYZ to Geotrans earthquake-induced launching, REDAS
-Geotrans to Lat-Long landslide (EIL) hazard
-Lat-Long to REDAS legends, displaying
editing maps
database -Paint (Win7) line
-Paint (WinXP) -digitizing using REDAS
database errors -digitizing using Bitmap
elements-at-risk Digitizer
delimiter -digitizing using Google
errors Earth
digital elevation model -in REDAS program
(DEM) data -in database line database
-format and structure
digitizing using Bitmap fields -creating new
Digitizer -plotting
-georeferencing flood hazard
-points liquefaction hazard
-lines generic mapping tools
-polygons (GMT) map calibration

193
 -format and structure -Installation
map operations -loading existing -Launching
-saving -appending/updating
-editing -attaching photographs REDAS errors
-printing -creating new
-annotating -plotting risk database

map parameters polygon risk database format

-coastline data -digitizing using REDAS -points
-DEM data -digitizing using Bitmap -lines
-bathymetric data Digitizer -polygons
-SRTM data -digitizing using Google
-zooming Earth saving, maps
-axis properties
-contour lines polygon database seismicity assessment
-paper size -format and structure
-creating new SRTM data
memory, reset -plotting
Storm surge hazard
multi-hazard maps printing maps
-boundary, delineating text parameters
-population centers, plotting Programmer’s File Editor
-saving (PFE) tick
-loading
-using for risk assessment rain-induced landslide tsunami hazard
(RIL) hazard
orthogonal volcanic hazard
records
paper size zooming
REDAS -set zoom focus
pixels -Summary of features and -set geographic coordinates
capabilities
point database -Flow diagram