Description
This thesis concentrates on developing software tools to convert Oracle spatial tables, which contain an SDO_GEOMETRY column, into ESRI (Environmental Systems Research Institute) shape files, commonly known as Shapefiles. Shapefiles provide a simple, non-topological file format for storing geographic and attribute data. It is comprised of three main files with extensions .shp, .shx and .dbf. The .shp file has geodetic descriptions, the .shx file is an index into the shape file, and the .dbf file contains the descriptive attributes of the spatial object, such as area, population, etc. The motivation behind this thesis is to develop simple tools which will be easy, useful and informational to students who wish to convert Spatial Database Tables to ESRI shape files. The student is not required to have any prior knowledge on creating database queries. The thesis leverages currently available tools in market to further simplify the tools. The focus is on making the interface as simple and interactive as possible. The thesis is comprised of two parts (applications). The first part of the thesis is a "Mojo Multi-select Tool", which is an addition to MOJO (Map Objects Java Objects) and aims at tying JTable attributes to MOJO layers and will enhance the syllabus for the San Diego State University Geographic Information Systems (GIS) class, CS 537. This tool is useful for anyone who uses MOJO and finds the code. The second part can assist anyone who wants to access an Oracle database and does not have experience with Database query languages like SQL, to be able to query and generate custom shapefiles, using the simplified and interactive "GeoDatbase Query Tool". JavaFX is used to create the User Interface and Netbeans IDE was used to develop the tools.
