Project

General

Profile

« Previous | Next » 

Revision 6001

Added by Aaron Marcuse-Kubitza about 12 years ago

mappings/verify.plots.sql: Added # locations, # location events, which also include subplots

View differences:

inputs/SALVIAS/verify/plots.ref.sql
23 23 
SELECT '# top-level location events' AS ___;
24 24 
SELECT count(*) AS count FROM "plotMetadata";
25 25 

  		




  
  26
  
    
SELECT '# locations' AS ___;


  		




  
  27
  
    
SELECT count(DISTINCT ROW ("PlotID", "Line")) AS count


  		




  
  28
  
    
FROM "plotMetadata"


  		




  
  29
  
    
LEFT JOIN "plotObservations" USING ("PlotID")


  		




  
  30
  
    
;


  		




  
  31
  
    

  		




  
  32
  
    
SELECT '# location events' AS ___;


  		




  
  33
  
    
SELECT count(DISTINCT ROW ("PlotID", "Line", census_date)) AS count


  		




  
  34
  
    
FROM "plotMetadata"


  		




  
  35
  
    
LEFT JOIN "plotObservations" USING ("PlotID")


  		




  
  36
  
    
;


  		




  
  37
  
    

  		




  26
  38
  
    
SELECT '1st methods' AS ___;


  		




  27
  39
  
    
SELECT DISTINCT


  		




  28
  40
  
    
    CAST(project_name AS text) AS projectname


  		












  

    
      inputs/SALVIAS/verify/plots.ref
    
  





  52
  52
  
    
RAINFOR - 1 ha Peru	28


  		




  53
  53
  
    
SERBO Selva Seca Oaxaca	3


  		




  54
  54
  
    
___


  		




  55
  
  
    
# locations


  		




  
  55
  
    
# top-level locations


  		




  56
  56
  
    
count


  		




  57
  57
  
    
13663


  		




  58
  58
  
    
___


  		




  59
  
  
    
# location events


  		




  
  59
  
    
# top-level location events


  		




  60
  60
  
    
count


  		




  61
  61
  
    
13663


  		




  62
  62
  
    
___


  		




  
  63
  
    
# locations


  		




  
  64
  
    
count


  		




  
  65
  
    
21271


  		




  
  66
  
    
___


  		




  
  67
  
    
# location events


  		




  
  68
  
    
count


  		




  
  69
  
    
21272


  		




  
  70
  
    
___


  		




  63
  71
  
    
1st methods


  		




  64
  72
  
    
projectname	method


  		




  65
  73
  
    
ACA Amazon Forest Inventories	1 ha, stems >= 10 cm dbh


  		












  

    
      mappings/verify.plots.sql
    
  





  39
  39
  
    
AND parent_id IS NULL -- no subplots


  		




  40
  40
  
    
;


  		




  41
  41
  
    

  		




  
  42
  
    
SELECT '# locations' AS ___;


  		




  
  43
  
    
SELECT count(DISTINCT location_id) AS count


  		




  
  44
  
    
FROM location


  		




  
  45
  
    
WHERE reference_id =


  		




  
  46
  
    
    (SELECT reference_id FROM reference WHERE shortname = :datasource)


  		




  
  47
  
    
;


  		




  
  48
  
    

  		




  
  49
  
    
SELECT '# location events' AS ___;


  		




  
  50
  
    
SELECT count(*) AS count


  		




  
  51
  
    
FROM locationevent


  		




  
  52
  
    
WHERE reference_id =


  		




  
  53
  
    
    (SELECT reference_id FROM reference WHERE shortname = :datasource)


  		




  
  54
  
    
;


  		




  
  55
  
    

  		




  42
  56
  
    
SELECT '1st methods' AS ___;


  		




  43
  57
  
    
SELECT DISTINCT


  		




  44
  58
  
    
    projectname


  		












Also available in:  Unified diff