Project

General

Profile

« Previous | Next » 

Revision 11997

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/SALVIAS/plotMetadata_/create.sql, map.csv: expanded plot_administrator:party_code_party_ and mapped plot_administrator_name to a 2nd project_participant

View differences:

trunk/inputs/SALVIAS/plotMetadata_/create.sql
7 7 
	, event_participant_name AS "PrimOwnerID_name"
8 8 
	FROM party_code_party_
9 9 
) AS "PrimOwnerID" USING ("PrimOwnerID")
10 
LEFT JOIN
11 
(
12 
	SELECT
13 
	  "*party_code" AS plot_administrator
14 
	, event_participant_name AS plot_administrator_name
15 
	FROM party_code_party_
16 
) AS plot_administrator USING (plot_administrator)
10 17 
LEFT JOIN "lookup_MethodCode" USING ("MethodCode")
11 18 
;
12 19 

  		












  

    
      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
  
    
plot_administrator,*plot_administrator,,


  		




  3
  4
  
    
PrimOwnerID,*PrimOwnerID,,


  		




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


  		




  5
  6
  
    
orig_filename,*orig_filename,,


  		




  ......




  65
  66
  
    
plot_notes,locationRemarks,,


  		




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


  		




  67
  68
  
    
PrimOwnerID_name,project_participant,,


  		




  
  69
  
    
plot_administrator_name,project_participant,,


  		




  68
  70
  
    
lookup_MethodCode_Description,observationMeasure,,


  		












  

    
      trunk/inputs/SALVIAS/plotMetadata_/VegBIEN.csv
    
  





  15
  15
  
    
PlotMethod,/location/locationevent/*_id/method/name,


  		




  16
  16
  
    
lookup_MethodCode_Description,/location/locationevent/*_id/method/observationmeasure,


  		




  17
  17
  
    
PrimOwnerID_name,/location/locationevent/*_id/project/projectcontributor[!*_id/party]/*_id/party/fullname,use [!...] negative lookahead assertion so that multiple project_participant columns will properly map to separate projectcontributor rows


  		




  
  18
  
    
plot_administrator_name,/location/locationevent/*_id/project/projectcontributor[!*_id/party]/*_id/party/fullname,use [!...] negative lookahead assertion so that multiple project_participant columns will properly map to separate projectcontributor rows


  		




  18
  19
  
    
project_id,/location/locationevent/*_id/project/sourceaccessioncode,


  		




  19
  20
  
    
date_finish,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",


  		




  20
  21
  
    
date_start,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",


  		












  

    
      trunk/inputs/SALVIAS/plotMetadata_/test.xml.ref
    
  





  50
  50
  
    
                            <project_id>


  		




  51
  51
  
    
                                <project>


  		




  52
  52
  
    
                                    <projectcontributor><party_id><party><fullname>$PrimOwnerID_name</fullname></party></party_id></projectcontributor>


  		




  
  53
  
    
                                    <projectcontributor><party_id><party><fullname>$plot_administrator_name</fullname></party></party_id></projectcontributor>


  		




  53
  54
  
    
                                    <sourceaccessioncode>$project_id</sourceaccessioncode>


  		




  54
  55
  
    
                                </project>


  		




  55
  56
  
    
                            </project_id>


  		




  ......




  194
  195
  
    
        </path>


  		




  195
  196
  
    
    </_setDefault>


  		




  196
  197
  
    
</VegBIEN>


  		




  197
  
  
    
Inserted 30 new rows into database


  		




  
  198
  
    
Inserted 32 new rows into database


  		












  

    
      trunk/inputs/SALVIAS/plotMetadata_/new_terms.csv
    
  





  28
  28
  
    
date_start,startDate,,


  		




  29
  29
  
    
date_finish,endDate,,


  		




  30
  30
  
    
PrimOwnerID_name,project_participant,,


  		




  
  31
  
    
plot_administrator_name,project_participant,,


  		




  31
  32
  
    
lookup_MethodCode_Description,observationMeasure,,


  		












  

    
      trunk/inputs/SALVIAS/plotMetadata_/unmapped_terms.csv
    
  





  
  1
  
    
*plot_administrator


  		




  1
  2
  
    
*PrimOwnerID


  		




  2
  3
  
    
*orig_filename


  		




  3
  4
  
    
*PrimOwnerID


  		












Also available in:  Unified diff