• Sessions appear in the color of their primary track
  • Sessions can be filtered using Products on the right
  • Use the Search bar for more flexibility
See this link for hints on how to search the schedule or sign up for sessions
Back To Schedule
Tuesday, March 20 • 2:55pm - 3:20pm
3D Spatial Utility Database at CALTRANS
Feedback form is now closed.
The California Department of Transportation (CALTRANS) was awarded a federal grant to create a spatial database for the purpose of collecting utility data and locations. Oracle 12c was chosen as the spatial database software and Bentley Map Enterprise V8i (SELECTseries4) was chosen as the software to interface with Oracle 12c. Autodesk Civil 3D and Arc GIS will eventually link to the database.
The multitenant architecture of Oracle 12c is being utilized; pluggable databases were created to separate data by CA Coordinate Systems (CCS). Within the pluggable database, tablespaces were created to separate the CCS zones.
 It is essential that 3D geometry is stored and the Spatial Reference System Identifier (SRID) value be assigned to the Oracle geometry so that coordinates can be re-projected from one coordinate system to another. Compound Coordinate Systems were created.
Creating and maintaining a utility database with a standardized set of data attributes will ensure that the utility infrastructure can be accurately identified during project planning and for conflict resolution during design and construction. This system can easily be adapted to other disciplines.

avatar for Donna Rodrick

Donna Rodrick

Transportation Surveyor, CALTRANS
I graduated from CA State University, Fresno with a degree in Surveying Engineering and Applied Mathematics. I have worked for the California Department of Transportation as a Transportation Surveyor for over 25 years; working in San Luis Obispo and Fresno for the first 4 years in... Read More →

Tuesday March 20, 2018 2:55pm - 3:20pm PDT
3-Rm 103