Project

General

Profile

« Previous | Next » 

Revision 11993

Added by Aaron Marcuse-Kubitza almost 11 years ago

inputs/SALVIAS/plotMetadata_/create.sql: added join to PrimOwnerID:party_code_party_

View differences:

trunk/inputs/SALVIAS/plotMetadata_/create.sql
1 1 
SELECT *
2 2 
FROM "plotMetadata"
3 
LEFT JOIN
4 
(
5 
	SELECT
6 
	  "*party_code" AS "PrimOwnerID"
7 
	, event_participant_name AS "PrimOwnerID_name"
8 
	FROM party_code_party_
9 
) AS "PrimOwnerID" USING ("PrimOwnerID")
3 10 
LEFT JOIN "lookup_MethodCode" USING ("MethodCode")
4 11 
;
5 12 

  		












  

    
      trunk/inputs/SALVIAS/plotMetadata_/map.csv
    
  





  1
  1
  
    
SALVIAS,VegCore,Filter,Comments


  		




  2
  2
  
    
MethodCode,OMIT#MethodCode,,Not globally unique after lookup_MethodCode_Description is combined with PlotMethod


  		




  
  3
  
    
PrimOwnerID,*PrimOwnerID,,


  		




  3
  4
  
    
PlotID,locationID,,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."


  		




  4
  5
  
    
orig_filename,*orig_filename,,


  		




  5
  6
  
    
AccessCode,accessRights,"/_map:[1=private,2=""metadata only"",3=public]/value","3 plots contain 3 in this field and ""del"" in tmp_del"


  		




  ......




  63
  64
  
    
plot_administrator,*plot_administrator,,


  		




  64
  65
  
    
plot_notes,locationRemarks,,


  		




  65
  66
  
    
tmp_del,*tmp_del,,"3 plots contain ""del"" in this field and 3 in AccessCode"


  		




  
  67
  
    
PrimOwnerID_name,*PrimOwnerID_name,,


  		




  66
  68
  
    
lookup_MethodCode_Description,observationMeasure,,


  		












  

    
      trunk/inputs/SALVIAS/plotMetadata_/VegBIEN.csv
    
  





  72
  72
  
    
MethodCode,,** No non-empty join mapping for OMIT#MethodCode ** Not globally unique after lookup_MethodCode_Description is combined with PlotMethod


  		




  73
  73
  
    
PrecipSource,,** No join mapping for *PrecipSource ** 


  		




  74
  74
  
    
PrimOwnerID,,** No join mapping for *PrimOwnerID ** 


  		




  
  75
  
    
PrimOwnerID_name,,** No join mapping for *PrimOwnerID_name ** 


  		




  75
  76
  
    
RevisionComments,,** No join mapping for *RevisionComments ** 


  		




  76
  77
  
    
SiteName,,** No join mapping for *SiteName ** 


  		




  77
  78
  
    
TempSource,,** No join mapping for *TempSource ** 


  		












  

    
      trunk/inputs/SALVIAS/plotMetadata_/unmapped_terms.csv
    
  





  
  1
  
    
*PrimOwnerID


  		




  1
  2
  
    
*orig_filename


  		




  2
  3
  
    
*PrimOwnerID


  		




  3
  4
  
    
*SiteName


  		




  ......




  13
  14
  
    
*recensused


  		




  14
  15
  
    
*plot_administrator


  		




  15
  16
  
    
*tmp_del


  		




  
  17
  
    
*PrimOwnerID_name


  		












Also available in:  Unified diff