Selection, Filtering and Sorting

• Selecting a summary of horizon thickness, sand, silt, clay and AWC for a given component (chorizon table).
  
  SELECT  hzname AS name, hzdepb_r - hzdept_r AS thickness, sandtotal_r AS sand, silttotal_r AS silt, claytotal_r AS clay, awc_r AS awc
  FROM chorizon
  WHERE cokey = '467038:646635'
  ORDER BY hzdept_r;
  Query Results
  name | thickness | sand | silt | clay | awc
  --------+-----------+------+------+------+------
  Ap | 18 | 35 | 37 | 28 | 0.16
  Bw | 23 | 35 | 40 | 25 | 0.15
  Bk1 | 28 | 35 | 40 | 25 | 0.16
  Bk2 | 40 | 35 | 40 | 25 | 0.16
  Bk3 | 36 | 35 | 40 | 25 | 0.16
  Bk4 | 38 | 60 | 25 | 15 | 0.13
• Select some common fields from the component table:
  
   SELECT cokey, majcompflag, comppct_r, wei, weg, tfact
  FROM component
  WHERE mukey = '467038'
  ORDER BY comppct_r DESC;
  Query Results
  cokey | majcompflag | comppct_r | wei | weg | tfact
  ---------------+-------------+-----------+-----+-----+-------
  467038:646635 | Yes | 85 | 48 | 6 | 5
  467038:646636 | No | 5 | | |
  467038:646638 | No | 4 | | |
  467038:646640 | No | 2 | | |
  467038:646639 | No | 2 | | |
  467038:646637 | No | 2 | | |
• Create a new table 'yolo_comp' using the component table, for a specific survey area (Yolo County), with components sorted by their component percentages.
  
  CREATE TABLE yolo_comp AS
  SELECT * FROM component
  WHERE areasymbol = 'ca113'
  ORDER BY mukey, comppct_r DESC ;

   
  The resulting table can be copied to a CSV file (in the current working directory) like this: \copy yolo_comp TO 'yolo_comp.csv' CSV HEADER

   
  If you are done with the table, remove it with the following SQL: DROP TABLE yolo_comp ;