Effective Database Design for Geoscience Professionals

During the planning phase of a geotechnical data management project, a survey must be conducted to determine the types of geological data available, the formats to be accounted for, and the possible exceptions. The checklist presented provides a starting point for the DBM when conducting surveys and interviews with end-users. A similar checklist should be developed for geophysical data where needed.
q Spatial Data
q Well location coordinates in latitude-longitude and UTM
q Well elevations (and units of measure)
q Hardcopy Data
q Survey plat (hardcopy)
q Survey coordinates (digital)
q GPS coordinates (latitude, longitude, elevation)
q Cuttings Samples
q Physical cuttings samples (bagged)
q Cuttings description logs
q Drilling Time (Penetration Rate)
q Curve-oriented data (digital)
q Drilling time logs (hardcopy)
q MWD Data Types
q Formation properties data (GR, resistivity, etc.)
q Directional survey data from MWD tools
q Mud Gas Chromatography
q Mud gas data on strip logs (hardcopy)
q Mud gas analyses (hardcopy)
q Raw mud gas data (digital)
q Computed mud-gas ratios and other analyses (digital)
q Formation Tops
q Predrill prognosis tops
q Tops picked from drill time and cuttings
q Core Data
q Conventional core material (physical)
q Sidewall core samples (physical)
q Rotary sidewall core samples (physical)
q Core plug samples (physical)
q