SSSD to NASIS Conversion Issues

Horizon Fragments

A bug has been discovered in the way some data in SSSD layer table was converted and populated in NASIS horizon fragments table. Components with a layer that had null in the 4 and 10 sieve, such as organic horizons or bedrock layers, will populated the horizon fragments table with an incorrect volume of 57 for low, high, and rv. This is easily corrected. The following query and method can be used to correct data that has been converted and installed in NASIS.

1. Write a query to select from horizon fragments table where horizon fragment volume low and high equals 57.
   
   FROM chorizon_fragments
   WHERE chorizon_fragments.fragment_volume_h = 57 AND
   chorizon_fragments.fragment_volume_l=57
    
2. Save and run query.
    
3. Use the menus, View-horizon-horizon fragments. Double check your selected set that the horizon fragments table only has records that have 57 in volume columns low, high, and rv.
    
4. Move cursor to horizon fragments table. Then use menu, edit, global delete. This will mark for deletion all the incorrect records.
    
5. Save selected set.

Data Quality Check

Another data quality check related to horizon fragments. Some horizons may have data for 3 to 10 inch sieve and have nulls in 4 and 10 sieve. Such as stony mucks, etc. SSSD to NASIS conversion may not have populated the horizon fragments with the cobble and stone. The following query will select horizons that have nulls in the 4 and 10 sieve and greater than 0 in the 3 to 10 inch sieve high.

FROM chorizon
WHERE chorizon.sieve_number_4_h IS NULL AND
chorizon.sieve_number_10_h IS NULL AND
chorizon.rock_frag_3_to_10_in_h > 0

An example where data in 3 to 10 inch sieve may be correct is stony-mucks. To populate volume percents in the horizon fragments table based on weight percents in 3 to 10 inch and greater than 10 inch sieve, use the following formula:

Volume=Weight*1.5/2.65