Project

General

Profile

« Previous | Next » 

Revision 8219

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/FIA/TREE/import: Reclustered table by TREE.parent path index, to facilitate path-order joins

View differences:

inputs/FIA/TREE/import
18 18 

  		




  19
  19
  
    
-- ("STATECD", "UNITCD", "COUNTYCD", "locationName", "INVYR", "authorEventCode", "subplot", "TREE", "STATUSCD") is not ID


  		




  20
  20
  
    
SELECT create_if_not_exists($$ALTER TABLE "TREE" ADD CONSTRAINT "TREE.ID" UNIQUE ("individualObservationID")$$);


  		




  21
  
  
    
SELECT cluster_once('"TREE"', '"TREE.ID"');


  		




  22
  21
  
    

  		




  23
  22
  
    
SELECT create_if_not_exists($$CREATE INDEX "TREE.parent" ON "TREE" ("STATECD", "UNITCD", "COUNTYCD", "locationName", "INVYR", "authorEventCode", "subplot")$$);


  		




  
  23
  
    
SELECT cluster_once('"TREE"', '"TREE.parent"');


  		




  24
  24
  
    
EOF


  		




  25
  25
  
    
mk_derived


  		












Also available in:  Unified diff