The 14th Conference on Science and Technology
MANAGING BRIDGES IN THREEDIMENSIONAL GEOGRAPHIC INFORMATION
SCIENCE
Prelector: Lê Hoàng Thanh
1
MAIN PARTS
1. Introduction
2. Managing objects of the problem
3. Model represents for problem
4. Installing application & Demo
2. Nghiên cứu tổng quan
5. Conclusion
6. References
2
Introduction
Transportation infrastructure is important to a country. In
transportation, bridge is a special thing.
Making an application to manage bridges using GIS 3D technology
in order to help the administrators, technicians to find necessary
information fast and accurate.
One of features of GIS is spatial component which appear into data
layer, use graphic technology for displaying at different levels of
detail – LOD.
LOD (Levels of Detail) [3, 8] is a presentation for GIS 3D models, it
can be define.
Displaying objects with multiple levels of detail in GIS 3D
applications also interested by scientists, especially the applications
that manage city’s buildings.
The model layers of GIS 3D are suitable to perform relative
application: urban management, civil engineering, Geological
exploration… In which model type B-REP is suitable for these
applications: civil engineering, urban management…, [1, 2, 6]
3
MANAGING OBJECTS OF THE PROBLEM – SEMANTIC
Using survey method to discover semantic components and spatial
components. Focusing on 2 main parts: data and functions.
30
entities
Entity Name
Meaning
BRIDGE
Describe about bridge infor
BRIDGE BASIC INFORMATION
Describe about bridge basic infor
BRIDGE TYPE
Describe about bridge type
BRIDGE CATEGORY
Describe about bridge category infor
DESIGN STANDARD
Describe about design standard infor
CITY
Describe about city infor
DISTRICT
Describe about district infor
WARD
Describe about ward infor
INVESTOR
Describe about investor infor
SURVEY UNIT
Describe about survey unit infor
VERIFICATION UNIT
Describe about verification unit infor
DESIGN UNIT
Describe about design unit infor
CONSTRUCTION UNIT
Describe about construction unit infor
MONITORING UNIT
Describe about monitoring unit infor
SUPERSTRUCTURE
Describe about superstructure infor
4
MANAGING OBJECTS OF THE PROBLEM – SEMANTIC
Entity Name
Meaning
MAIN BEAM TYPE
Describe about main beam infor
MAIN BEAM
Describe about main beam infor
TRANSVERSE BEAM
Describe about transverse beam infor
ABUTMENT TYPE
Describe about abutment type infor
ABUTMENT
Describe about abutment infor
ABUTMENT FOODING
Describe about abutment fooding infor
PILE TYPE
Describe about pile type infor
PIER TYPE
Describe about pier type infor
PIER
Describe about pier infor
PIER FOODING
Describe about pier fooding infor
BEARING TYPE
Describe about bearing type infor
BEARING
Describe about bearing infor
EXPANSION JOINT TYPE
Describe about expansion joint type infor
EXPANSION JOINT
Describe about expansion joint
MATERIAL TYPE
Describe about marterial type
5
MANAGING OBJECTS OF THE PROBLEM – SPATIAL
There are 4 entities, LOD entity is a remarkable contribution. With its
help, a bridge will be displayed at different levels of detail.
LOD at this moment also different to LOD in [7, 8] at 2 points:
independence about semantic and have arbitrary levels.
Entity Name
Meaning
NODE
Describe about Node infor
LOD
Describe about LOD infor
SURFACE
Describe about surface infor
LINE
Describe about line infor
6
THE MODEL REPRESENTS FOR THE PROBLEM
Representing data also approach follow Entity relationship diagram
[9]. Each entity describes an object in the application.
Data is represented follow instruction by 2 levels: conceptual and
logic.
The conceptual model expresses the sematic relationships between
entities in 2 basic type: one or many.
From conceptual model, we have data of next model-logic model,
data at logic layer includes 40 relationships. Among them also have
8 relationships to represent spatial, the other represents semantic.
Data at logic layer is the foundation that move on to the data
installation on database management system which will be selected
later.
7
THE MODEL REPRESENTS FOR THE PROBLEM
Conceptual Model
8
INSTALLING APPLICATION & DEMO
Data: to prepare data for application, we need 3 steps, describe how
to get bridge’s data from AutoCad 2014 into Oracle database:
Step 1: Transforming bridge’s data from Autocad to coordinate data file
Step 2: Extracting coordinates in the file of Step 1 to bridge’s parts. Continue to map
necessary coordinates correspond to each LOD which will be represented by user’s
definition.
Step 3: Transforming data from coordinate data files into corresponding Oracle
database tables by automatic importation that also support by Oracle..
Representing 3D objects, the application will follow these steps:
Step 1: Get data from database to get necessary information (Surface, Line, Node…)
with specific LOD..
Step 2: Application will process the data from Step 1 to new data for representation.
Step 3: Application use HTML5, ThreeJS library and Canvas to processing.
Step 4: Call functions to draw Line, Surface to represent the bridge based on data
from Step 2. Besides, ThreeJS library also support for features: shift, zoom in, zoom
out, revolve with high resolution and detail.
9
CONVERT AUTOCAD 2D TO 3D
Phu My bridge 2D axial section
Phu My bridge 3D after convert
Phu My bridge 2D lateral section
10
CONVERT 3D DATA TO DATABASE DATA
Coordinate data export from AutoCad
Convert Data
SURFACE
NODE
NODE
LINE_NODE
LOD_BRIDGE_SURFACE
SURFACE_NODE
LINE
LOD_BRIDGE_LINE
11
APPLICATION
Create
BMM
Update
Report
data
Update
Search
Delete
Detail
View
3D graphic
(ThreeJS, Canvas)
Bridges on map
(Google Maps)
Main Module
Feature of Module
Feature of Module with 3rd-party support
12
APPLICATION – BRIDGE LIST
Input: searching criteria
Output: Bridges that satisfy the criteria
Bridge list screen
13
APPLICATION – CREATE NEW BRIDGE
Input: New bridge infor
Output: Save new
bridge to database
Create new bridge screen
14
APPLICATION - MAPS
Input: bridge
list
Output: Display
results match
with input
information
Update bridge screen
15
APPLICATION – REPRESENTING BRIDGE AT
DIFFERENT LEVELS OF DETAIL
Input: Bridge name
Ouput: Representing bridge at different Levels of Detail
LOD 1
LOD 2
LOD 3
LOD 4
16
APPLICATION - REPORT
Input: Report
criteria
Output: Display
result based on
input criteria
17
CONCLUSION
The paper focus on survey, analysis, design and install a database
model to satisfy about management and represent the bridge.
Managing both semantic attributes and spatial attributes.
Design database in order to represent spatial feature of bridge at
different LOD.
The database also links with data of Google Map, to serve for
visualization on a friendly and popular map.
This application is the first step which prepare to intergrade one
more temporal dimension to manage the changing of bridge follow
by time. At that time, we will have 5D Database, it will include 3D of
spatial, 1D of temporal and 1D of semantic.
18
REFERENCES
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
A. Paper
B. Book, technical report, doctor thesis, website…
Alias Abdul Rahman, Spatial Data Modelling for 3D GIS, Springer Verlag BerlinHeidelberg, (2008).
Abdelkader El Garouani , Abdalla Alobeid, Said El Garouani,” Digital surface model based on aerial image stereo pairs
for 3D building”, International Journal of Sustainable Built Environment-Elsevier, Volume 3, Issue 1, June 2014, (2014)
119–126.
Nguyen Gia Tuan Anh, Phan Thanh Vu, Tran Vinh Phuoc, Tran Anh Sy, Pham Van Dang, “Representing Multiple
Levels for Objects in Three-Dimensional GIS Model”, The 13th International Conference on Information Integration and
Web-based Applications & Service (iiWAS2011), ACM Press ISBN, Ho Chi Minh City, Vietnam, (2011) 495-499.
Nguyen Gia Tuan Anh, Tran Thanh Be, Nguyen Ngoc Trung, Phan Thanh Vu, “Xây dựng, so sánh hai mô hình dữ liệu
của ứng dụng quản lí lịch sử biến động các thửa đất”, Tạp chí khoa học Đại học Sư phạm thành phố Hồ Chí Minh, Số
51-2013, (2013) 178-188.
Chen Tet-Khuan, Alias Abdul-Rahman, Sisi Zlatanova “3D Spatial Operations in Geo DBMS Environment for 3D GIS”,
Computational Science and Its Applications : ICCSA, (2007) 549-554.
Meng Xiangjian, and Gang Liu, “Development of 3D GIS Modeling Technology”, CCTA, volume 259 of IFIP Advances
in Information and Communication Technology, Springer, (2007) 1329-1332.
Ming Yuan Hu, “Semantic Based LOD Models Of 3D House Property” Proceedings of Commission II, ISPRS Congress
Beijing, (2008) 95-102.
OGC, “City geography markup language Citygml encoding standard”. Open Geospatial Consortium inc, (2007)
Drawing the Entity-Relationship Diagram, last visited 02/04/2015, from
.
Introduction to Oracle Database , last visited 15/04/2015, from
.
Introduction to the Oracle Server , last visited 16/04/2015, from
19
THANK YOU!
20
- Xem thêm -
.PDF 
20 
1 
111 
