Spatial Database
In this project, I built a spatial database using Oracle 10g, Oracle Spatial features, and Java (JDBC).
Also, I developed a GUI application to track the locations of cameras, vehicles and buildings on USC map.
The program provided the provision for users to draw shapes and query a specific region on the map.
Firstly, the program parsed several pre-defined files and stored the information in the oracle spatial database.
Then there would be a panel showing the USC map and several query options, such as whole region, range query, line query, find cameras and find vehicle.
The program could do some spatial interactions according to the user's selection and return the result on the map.
The result should look like this :
