search
|
directory
|
contact us
|
411
|
subscribe
|
help
Reconnaissance Offshore Sand Search
Home
Mapping
Database
-Query Builder
Downloads
-Shapefiles
Reports
Technical Advise
Bibliography
Project List
ROSS Terms
Preliminary Inventory Report
FAQs
|
Related Links
|
Contact Us
|
FTP
The ORACLE Database
The data displayed throughout this web site is stored in an Oracle Enterprise database. Below are links to the Query Builder and to documentation on the ORACLE database.
The Query Builder
The online Query Builder allows the user to create a customized SQL statement that retrieves only certain data from the database of sand samples. The user may set conditions ranging from mean grain size to a specific project, Munsell Color range, or area based on Lat/Long or State Plane Coordinates.
Go To Query Builder
Physical Schema
This pdf document contains a graphical representation of all data tables in the ROSS database. In addition to displaying the individual tables and columns within each table, the diagram shows how the tables are related to each other.
View/Download Physical Schema (ER Diagram)
Data Dictionary
This pdf document describes the tables and columns in the ROSS database, and includes column data type as well as the physical length limitations of each column.
View/Download Data Dictionary