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.
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.
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.
