Mappings computes the following tables :

Mappings tables Associated database tables
Average ionic fraction ion_frac
Average ionic temperatures ion_temp
Integrated column densities ion_col_dens
Average ionic electron densities ion_dens

Mappings produces the different tables in the following form :

Average ionic fraction :

           H         He        C         N         O         Ne        Na        Mg        Al        Si        S         Cl        Ar        Ca        Fe        Ni
I        0.553     0.589     0.148     0.517     0.568     0.270     5.131E-02 3.429E-02 1.189E-02 2.277E-02 3.851E-02 6.349E-02 0.235     0.241     0.198     0.173    
II       0.447     0.298     0.742     0.391     0.345     0.607     0.786     0.769     0.857     0.849     0.810     0.789     0.615     0.534     0.646     0.714    
III       0.00     0.113     4.164E-02 4.177E-02 4.266E-02 8.454E-02 0.122     0.150     8.523E-03 4.617E-02 8.551E-02 8.394E-02 8.999E-02 0.174     5.643E-02 1.097E-02
IV        0.00      0.00     6.932E-03 3.580E-02 3.333E-02 3.186E-02 3.673E-02 4.301E-02 0.116     5.092E-03 2.887E-02 3.743E-02 4.581E-02 3.807E-02 2.048E-02 1.619E-02
V         0.00      0.00     6.168E-02 7.919E-03 1.034E-02 6.161E-03 3.532E-03 4.488E-03 6.751E-03 7.656E-02 2.956E-02 1.995E-02 1.220E-02 1.130E-02 3.021E-02 4.100E-02
VI        0.00      0.00     2.845E-11 5.693E-03 2.172E-04 1.167E-04 3.323E-05 1.848E-05 5.504E-05 2.023E-04 3.496E-03 5.971E-03 2.141E-03 1.101E-03 4.273E-02 4.023E-02
VII       0.00      0.00      0.00      0.00     6.626E-06 1.218E-07 1.386E-08 4.919E-09 5.480E-09 2.999E-08 4.360E-03 1.395E-04 1.152E-04 1.204E-05 5.798E-03 3.650E-03
VIII      0.00      0.00      0.00      0.00      0.00     3.564E-12 1.494E-13  0.00      0.00     6.741E-14 3.324E-09 2.095E-05 4.260E-07 3.662E-08 1.602E-04 1.128E-04
IX        0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00     1.878E-13 5.834E-09 3.142E-11 5.079E-08 7.333E-07
X         0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00     2.337E-13 1.090E-09
                                                                              
Average ionic temperatures :
                                       
           H         He        C         N         O         Ne        Na        Mg        Al        Si        S         Cl        Ar        Ca        Fe        Ni
I        6.038E+03 6.276E+03 7.165E+03 5.904E+03 6.072E+03 5.912E+03 3.742E+03 5.952E+03 7.071E+03 7.290E+03 6.953E+03 6.290E+03 5.114E+03 7.166E+03 7.026E+03 6.539E+03
II       3.159E+04 1.058E+04 7.576E+03 1.016E+04 1.111E+04 8.868E+03 7.612E+03 6.545E+03 6.813E+03 6.774E+03 7.078E+03 7.097E+03 7.449E+03 6.367E+03 6.496E+03 7.021E+03
III       0.00     9.410E+04 4.399E+04 7.651E+04 8.299E+04 5.408E+04 4.299E+04 3.842E+04 2.050E+04 3.372E+04 3.028E+04 3.426E+04 3.816E+04 3.023E+04 1.699E+04 3.488E+04
IV        0.00      0.00     1.281E+05 1.408E+05 1.439E+05 1.506E+05 1.469E+05 1.327E+05 8.909E+04 7.862E+04 1.069E+05 1.159E+05 1.264E+05 1.300E+05 5.336E+04 6.625E+04
V         0.00      0.00     1.305E+05 1.731E+05 1.730E+05 1.752E+05 1.762E+05 1.693E+05 1.517E+05 1.247E+05 1.525E+05 1.579E+05 1.665E+05 1.679E+05 8.912E+04 9.720E+04
VI        0.00      0.00     1.554E+05 1.423E+05 1.843E+05 1.844E+05 1.832E+05 1.806E+05 1.706E+05 1.610E+05 1.772E+05 1.777E+05 1.825E+05 1.835E+05 1.424E+05 1.294E+05
VII       0.00      0.00      0.00      0.00     1.565E+05 1.885E+05 1.865E+05 1.836E+05 1.819E+05 1.785E+05 1.488E+05 1.881E+05 1.905E+05 1.924E+05 1.734E+05 1.734E+05
VIII      0.00      0.00      0.00      0.00      0.00     1.900E+05 1.885E+05  0.00      0.00     1.847E+05 1.707E+05 1.623E+05 1.950E+05 1.975E+05 1.878E+05 1.828E+05
IX        0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00     1.786E+05 1.791E+05 2.008E+05 1.949E+05 1.853E+05
X         0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00     2.009E+05 1.826E+05

Integrated column densities:

           H         He        C         N         O         Ne        Na        Mg        Al        Si        S         Cl        Ar        Ca        Fe        Ni
I        9.765E+18 7.678E+17 8.471E+13 4.151E+13 1.061E+15 9.799E+13 2.341E+12 7.182E+12 2.867E+11 4.315E+12 1.626E+12 4.859E+10 3.059E+12 1.382E+12 1.573E+13 1.679E+12
II       3.660E+18 1.999E+17 5.951E+14 9.519E+12 2.245E+14 1.202E+14 1.141E+13 1.047E+14 2.924E+13 2.362E+14 4.327E+13 5.322E+11 2.934E+12 5.931E+12 7.486E+13 6.893E+12
III       0.00     1.234E+17 2.032E+13 1.889E+12 5.244E+13 1.622E+13 1.361E+12 1.040E+13 1.305E+11 5.052E+12 2.478E+12 3.156E+10 2.973E+11 1.285E+12 1.749E+12 4.212E+10
IV        0.00      0.00     7.234E+12 3.027E+12 7.236E+13 1.264E+13 9.169E+11 7.854E+12 3.694E+12 1.148E+12 1.661E+12 3.020E+10 4.153E+11 4.806E+11 1.186E+12 1.079E+11
V         0.00      0.00     6.512E+13 8.399E+11 2.751E+13 2.888E+12 1.075E+11 1.061E+12 3.647E+11 2.734E+13 2.485E+12 2.242E+10 1.490E+11 1.880E+11 2.878E+12 4.011E+11
VI        0.00      0.00     3.612E+04 4.866E+11 6.204E+11 5.796E+10 1.057E+09 4.698E+09 3.373E+09 9.471E+10 3.475E+11 7.669E+09 2.903E+10 2.027E+10 6.655E+12 5.340E+11
VII       0.00      0.00      0.00      0.00     1.575E+10 6.207E+07 4.499E+05 1.275E+06 3.611E+05 1.573E+07 3.567E+11 1.913E+08 1.641E+09 2.345E+08 1.121E+12 6.588E+10
VIII      0.00      0.00      0.00      0.00      0.00     1.832E+03  4.91      0.00      0.00      36.7     3.157E+05 2.427E+07 6.241E+06 7.358E+05 3.392E+10 2.160E+09
IX        0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00     0.242     7.714E+04  644.     1.126E+07 1.424E+07
X         0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      53.9     2.080E+04

Average ionic electron dens. :  = 2.823E+01   = 5.769E+01   = 4.525E-01   num/H : 1.0815E+00

           H         He        C         N         O         Ne        Na        Mg        Al        Si        S         Cl        Ar        Ca        Fe        Ni
I         22.3      24.6      31.7      20.9      22.6      22.2      7.94      25.3      32.2      34.0      29.8      23.1      15.7      31.1      31.6      26.5    
II        35.6      37.4      28.9      40.9      40.9      32.1      29.7      27.1      28.7      28.8      28.8      29.3      33.1      26.5      27.0      30.1    
III       0.00      23.3      29.3      21.6      19.8      28.6      33.1      40.2      44.2      41.3      34.8      35.2      38.8      34.5      51.6      38.8    
IV        0.00      0.00      12.6      10.5      10.1      9.56      10.1      12.1      23.9      21.8      14.6      13.4      12.2      12.3      27.6      23.9    
V         0.00      0.00      12.3      7.94      7.89      7.75      7.69      8.12      9.87      13.0      9.40      8.95      8.35      8.27      17.6      17.3    
VI        0.00      0.00      9.37      10.6      7.24      7.23      7.28      7.41      8.01      8.89      7.69      7.62      7.36      7.31      10.5      14.3    
VII       0.00      0.00      0.00      0.00      9.11      7.02      7.11      7.25      7.34      7.52      9.88      7.06      6.95      6.86      7.89      7.95    
VIII      0.00      0.00      0.00      0.00      0.00      6.95      7.01      0.00      0.00      7.19      8.00      8.66      6.73      6.63      7.07      7.32    
IX        0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      7.50      7.48      6.48      6.74      7.18    
X         0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00      6.47      7.30

To access these values from the database, you have to select the table name followed by the element. For example, if you want the integrated column densities for oxygen :


Mappings Database
OI ion_temp.OXYGEN_0
OII ion_temp.OXYGEN_1
OIII ion_temp.OXYGEN_2
OIV ion_temp.OXYGEN_3
... ...
import os
import pymysql
import numpy as np
import pandas as pd
                
host = os.environ['MdB_HOST']
user = os.environ['MdB_USER']
passwd = os.environ['MdB_PASSWD']
port = os.environ['MdB_PORT']
                
db = pymysql.connect(host=host, user=user, passwd=passwd, port=int(port), db='3MdBs')
cursor = db.cursor()
                
result = pd.read_sql("""SELECT shock_params.shck_vel AS shck_vel,
                               ion_frac.OXYGEN_0 AS OI,
                               ion_frac.OXYGEN_1 AS OII,
                               ion_frac.OXYGEN_2 AS OIII
                        FROM shock_params
                        INNER JOIN emis_VI ON emis_VI.ModelID=shock_params.ModelID
                        INNER JOIN ion_frac ON ion_frac.ModelID=shock_params.ModelID
                        INNER JOIN abundances ON abundances.AbundID=shock_params.AbundID
                        WHERE emis_VI.model_type='shock' 
                        AND ion_frac.model_type='shock' 
                        AND abundances.name='Allen2008_SMC'
                        AND shock_params.ref='Allen08'
                        AND shock_params.shck_vel=125
                        AND shock_params.preshck_dens=1
                        AND shock_params.mag_fld=1 
                        ORDER BY shck_vel, mag_fld;""", con=db)
                
db.close()
                
print ("OI : ", result.OI[0])
print ("OII : ", result.OII[0])
print ("OIII : ", result.OIII[0])
import os
import pymysql
import numpy as np
import pandas as pd
                
host = os.environ['MdB_HOST']
user = os.environ['MdB_USER']
passwd = os.environ['MdB_PASSWD']
port = os.environ['MdB_PORT']
                
db = pymysql.connect(host=host, user=user, passwd=passwd, port=int(port), db='3MdBs')
cursor = db.cursor()
                
result = pd.read_sql("""SELECT shock_params.shck_vel AS shck_vel,
                               ion_temp.OXYGEN_0 AS OI,
                               ion_temp.OXYGEN_1 AS OII,
                               ion_temp.OXYGEN_2 AS OIII
                        FROM shock_params
                        INNER JOIN emis_VI ON emis_VI.ModelID=shock_params.ModelID
                        INNER JOIN ion_temp ON ion_temp.ModelID=shock_params.ModelID
                        INNER JOIN abundances ON abundances.AbundID=shock_params.AbundID
                        WHERE emis_VI.model_type='shock' 
                        AND ion_temp.model_type='shock' 
                        AND abundances.name='Allen2008_SMC'
                        AND shock_params.ref='Allen08'
                        AND shock_params.shck_vel=125
                        AND shock_params.preshck_dens=1
                        AND shock_params.mag_fld=1 
                        ORDER BY shck_vel, mag_fld;""", con=db)
                
db.close()
                
print ("OI : ", result.OI[0])
print ("OII : ", result.OII[0])
print ("OIII : ", result.OIII[0])
import os
import pymysql
import numpy as np
import pandas as pd
                
host = os.environ['MdB_HOST']
user = os.environ['MdB_USER']
passwd = os.environ['MdB_PASSWD']
port = os.environ['MdB_PORT']
                
db = pymysql.connect(host=host, user=user, passwd=passwd, port=int(port), db='3MdBs')
cursor = db.cursor()
                
result = pd.read_sql("""SELECT shock_params.shck_vel AS shck_vel,
                               ion_col_dens.OXYGEN_0 AS OI,
                               ion_col_dens.OXYGEN_1 AS OII,
                               ion_col_dens.OXYGEN_2 AS OIII
                        FROM shock_params
                        INNER JOIN emis_VI ON emis_VI.ModelID=shock_params.ModelID
                        INNER JOIN ion_col_dens ON ion_col_dens.ModelID=shock_params.ModelID
                        INNER JOIN abundances ON abundances.AbundID=shock_params.AbundID
                        WHERE emis_VI.model_type='shock' 
                        AND ion_col_dens.model_type='shock' 
                        AND abundances.name='Allen2008_SMC'
                        AND shock_params.ref='Allen08'
                        AND shock_params.shck_vel=125
                        AND shock_params.preshck_dens=1
                        AND shock_params.mag_fld=1 
                        ORDER BY shck_vel, mag_fld;""", con=db)
                
db.close()
                
print (f"OI : {result.OI[0]:.3E}")
print (f"OII : {result.OII[0]:.3E}")
print ("OIII : ", result.OIII[0])
import os
import pymysql
import numpy as np
import pandas as pd
                
host = os.environ['MdB_HOST']
user = os.environ['MdB_USER']
passwd = os.environ['MdB_PASSWD']
port = os.environ['MdB_PORT']
                
db = pymysql.connect(host=host, user=user, passwd=passwd, port=int(port), db='3MdBs')
cursor = db.cursor()
                
result = pd.read_sql("""SELECT shock_params.shck_vel AS shck_vel,
                               ion_dens.OXYGEN_0 AS OI,
                               ion_dens.OXYGEN_1 AS OII,
                               ion_dens.OXYGEN_2 AS OIII
                        FROM shock_params
                        INNER JOIN emis_VI ON emis_VI.ModelID=shock_params.ModelID
                        INNER JOIN ion_dens ON ion_dens.ModelID=shock_params.ModelID
                        INNER JOIN abundances ON abundances.AbundID=shock_params.AbundID
                        WHERE emis_VI.model_type='shock' 
                        AND ion_dens.model_type='shock' 
                        AND abundances.name='Allen2008_SMC'
                        AND shock_params.ref='Allen08'
                        AND shock_params.shck_vel=125
                        AND shock_params.preshck_dens=1
                        AND shock_params.mag_fld=1 
                        ORDER BY shck_vel, mag_fld;""", con=db)
                
db.close()
                
print ("OI : ", result.OI[0])
print ("OII : ", result.OII[0])
print ("OIII : ", result.OIII[0])