Queries for Permeability Conversion

In the conversion of data from 3SD to NASIS, the permeability values were mistakenly converted as integers, so that fractional parts of the numbers were lost. Mike Hansen in Montana developed a way to fix this problem in NASIS using the Global Assign feature to put in the correct values for permeability.

As the first step in Global Assign, you will need to create a selected set that contains all the horizon records that are supposed to have a certain value of permeability. Then you fill in one correct value, and Global Assign will copy it to all the other records. To help create the appropriate selected sets, Mike developed the queries listed below. The bold face is the query name, and the smaller print is the text of the query.

You can copy these queries into your NASIS database with a simple cut and paste operation. Just follow these steps:

1. Bring up NASIS, while this Web page is visible in another window.
    
2. Select View from the menu, then Queries, and Query.
    
3. Insert a new row, and fill in a query name.
    
4. Zoom on the Query column to bring up the query editor.
    
5. Come back to this page, and highlight the text for one query (use the left mouse button and drag across the query you want to copy).
    
6. Return to the query editor, and click, using the CENTER mouse button, in the large Select Conditions box. This should place a copy of the query text in the query editor.
    
7. Apply this query, and repeat these steps for each query you want to copy.
   
   Hint: you can copy the query name in the same way. You have to insert the new row and position the cursor on the Query Name column before highlighting the text on the Web page.
    

Permeability errors (slow to mod. slow conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 4.00 and
chorizon.sat_hydraulic_conductivity_l = 0.00

Permeability errors (very slow conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 0.00 and
chorizon.clay_total_separate_h  > 27

Permeability errors (slow conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 1.00 and
chorizon.sat_hydraulic_conductivity_l = 0.00

Permeability errors (mod. slow conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 4.00 and
chorizon.sat_hydraulic_conductivity_l = 1.00

Permeability errors (mod. slow to mod. conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 14.00 and
chorizon.sat_hydraulic_conductivity_l = 1.00

Permeability errors (slow to very rapid conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 705.00 and
chorizon.sat_hydraulic_conductivity_l = 0.00

Permeability errors (slow to mod. conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 14.00 and
chorizon.sat_hydraulic_conductivity_l = 0.00

Permeability errors (mod. slow to rapid conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 141.00 and
chorizon.sat_hydraulic_conductivity_l = 1.00

Permeability errors (slow to mod. rapid conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 42.00 and
chorizon.sat_hydraulic_conductivity_l = 0.00

Permeability errors (mod. slow to mod. rapid conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 42.00 and
chorizon.sat_hydraulic_conductivity_l = 1.00

Permeability errors (mod. slow to very rapid conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 705.00 and
chorizon.sat_hydraulic_conductivity_l = 1.00

Permeability errors (slow to rapid conversion)

from chorizon 
where chorizon.sat_hydraulic_conductivity_h  = 141.00 and
chorizon.sat_hydraulic_conductivity_l = 0.00