search

UGS-GIO / rockcore

UGS Core Research Center Inventory web application that compiles a large data set of rock core data and displays it on an interactive web map
https://geology.utah.gov/apps/rockcore/
0 stars 0 forks source link

O values as the top_depth on some sample types #35

Closed marthajensen closed 2 years ago

marthajensen commented 2 years ago

What happened?

@Vandenberg5 @klcummings @jjhi11

  1. In the web application, search for well #CC-4 CANE CREEK
  2. In the popup, click on Sample Types and Depths
  3. The Sample Types and Depths is showing a Top Depth of 0, but the Top Depth should actually be 2622 (the correct value in the database)

After doing some research, I believe the Top Depth is showing 0 because of "NULL" values in the database. #CC-4 CANE CREEK, for example, has 333 entries for different sample types, and 21 of those values are "NULL". I think the Top Depth is showing 0 when the code behind the application encounters these "NULL" values. I am wondering if @jjhi11 should ignore NULLS in the application code for samples that have both "NULL" values and real integer values in the Top_Depth field?

What do you think @klcummings @Vandenberg5 ?

I searched the database and the following sample types (TYPE field) have both Integer values and "NULL" values in Top_Depth field: BUTTS, Chips (how it appears in the database), CORE, CORE CHIPS, CUTTINGS, OUTCROP SAMPLES, SIDEWALL, SKELENTONIZED CORE, SLABS

There are other sample types in the TYPE field, besides the ones listed above, but all values in those sample types are "NULL" so I don't think they need anything done to them.

Below is the spreadsheet that Katie provided to me showing wells with a Top Depth of 0. We aren't sure this is a complete list of all the well issues throughout the database - these are wells that @Vandenberg5 had encountered doing some research

H storage cores_kc edits (1).xlsx s instead.

What did you expect to happen?

The Top Depths to be correct for all wells shown the spreadsheet above

Browser Version

Chrome Version 96.0.4664.45 (Official Build) (64-bit)

marthajensen commented 2 years ago

@klcummings and @Vandenberg5

The top_depth values have been fixed in the application. Please check when you have time and re-open this Github issue if you see any problems.