Project

General

Profile

« Previous | Next » 

Revision 221

Added by Aaron Marcuse-Kubitza about 13 years ago

VegX-VegBIEN.organisms.csv: sort output of repl

View differences:

mappings/VegX-VegBIEN.organisms.csv
51 51 
/simpleUserdefined[name=count]/value,/collectiveobs/*/stemCount
52 52 
/simpleUserdefined[name=coverPercent]/value,/collectiveobs/cover
53 53 
/simpleUserdefined[name=interceptCm]/value,"/collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
54 
/diameterBaseDistance[baseDistance=1.37]/diameter,/collectiveobs/stemCount/stemDiameter
55 
/height,/collectiveobs/stemCount/stemHeight
56 
/simpleUserdefined[name=stemHeightM]/value,/collectiveobs/stemCount/stemHeight
57 54 
/simpleUserdefined[name=habitat]/value,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=habitat]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
58 55 
/simpleUserdefined[name=htFirstBranchM]/value,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=heightFirstBranchM]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
59 56 
/simpleUserdefined[name=plantFungusDescription]/value,"/collectiveobs/stemCount/individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=plantFungusDescription]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue"
......
67 64 
/*ID->/*s/individualOrganism/identificationLabel,/collectiveobs/stemCount/individual/stemCode
68 65 
/simpleUserdefined[name=xPosition]/value,/collectiveobs/stemCount/individual/stemXPosition
69 66 
/simpleUserdefined[name=yPosition]/value,/collectiveobs/stemCount/individual/stemYPosition
67 
/diameterBaseDistance[baseDistance=1.37]/diameter,/collectiveobs/stemCount/stemDiameter
68 
/height,/collectiveobs/stemCount/stemHeight
69 
/simpleUserdefined[name=stemHeightM]/value,/collectiveobs/stemCount/stemHeight
70 70 
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/authorCode,/taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/collectionNumber
71 71 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName","/taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}"
72 72 
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
mappings/for_review/VegX-VegBIEN.organisms.csv
51 51 
/simpleUserdefined[name=count]/value,//*/stemCount
52 52 
/simpleUserdefined[name=coverPercent]/value,//collectiveobs/cover
53 53 
/simpleUserdefined[name=interceptCm]/value,"//collectiveobs/definedValue[*_ID/userDefined[tableName=collectiveobs,userDefinedName=interceptCm]]/definedValue"
54 
/diameterBaseDistance[baseDistance=1.37]/diameter,//stemCount/stemDiameter
55 
/height,//stemCount/stemHeight
56 
/simpleUserdefined[name=stemHeightM]/value,//stemCount/stemHeight
57 54 
/simpleUserdefined[name=habitat]/value,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=habitat]]/definedValue"
58 55 
/simpleUserdefined[name=htFirstBranchM]/value,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=heightFirstBranchM]]/definedValue"
59 56 
/simpleUserdefined[name=plantFungusDescription]/value,"//individual/definedValue[*_ID/userDefined[tableName=individual,userDefinedName=plantFungusDescription]]/definedValue"
......
67 64 
//individualOrganism/identificationLabel,//individual/stemCode
68 65 
/simpleUserdefined[name=xPosition]/value,//individual/stemXPosition
69 66 
/simpleUserdefined[name=yPosition]/value,//individual/stemYPosition
67 
/diameterBaseDistance[baseDistance=1.37]/diameter,//stemCount/stemDiameter
68 
/height,//stemCount/stemHeight
69 
/simpleUserdefined[name=stemHeightM]/value,//stemCount/stemHeight
70 70 
//taxonNameUsageConcept/authorCode,/taxondetermination[roleCode=collector]/collectionNumber
71 71 
//individualName/givenName,"/taxondetermination[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/last}"
72 72 
"//parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxondetermination[roleCode=collector]/collector_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
mappings/Makefile
14 14 
clean: FORCE
15 15 
	$(RM) $(all)
16 16 

  		




  
  17
  
    
sort = ../scripts/util/sort 1 0


  		




  
  18
  
    
repl = ../scripts/util/repl


  		




  
  19
  
    
chRoot = ../scripts/util/ch_root <$< >$@


  		




  17
  20
  
    

  		




  
  21
  
    

  		




  18
  22
  
    
VegBank-VegBIEN: schemas/vegbien.sql VegX-VegBIEN.organisms.csv


  		




  19
  23
  
    

  		




  20
  
  
    
repl = ../scripts/util/repl


  		




  21
  
  
    

  		




  22
  24
  
    
schemas/vegbien.sql: schemas/vegbank.sql


  		




  23
  25
  
    
	$(repl) <$< VegBank-VegBIEN.schema.csv|$(repl) VegBank-VegBIEN.csv >$@


  		




  24
  26
  
    

  		




  25
  27
  
    
VegX-VegBIEN.organisms.csv: VegX-VegBank.organisms.csv


  		




  26
  
  
    
	$(repl) <$< VegBank-VegBIEN.csv 1 >$@


  		




  
  28
  
    
	$(repl) <$< VegBank-VegBIEN.csv 1|$(sort) >$@


  		




  27
  29
  
    

  		




  28
  30
  
    

  		




  29
  31
  
    
plots: $(subst .organisms.,.plots.,$(wildcard VegX-*.organisms.csv))


  		




  30
  32
  
    

  		




  31
  
  
    
chRoot = ../scripts/util/ch_root <$< >$@


  		




  32
  
  
    

  		




  33
  33
  
    
chRoot2PlotsLeftVegx =\


  		




  34
  34
  
    
	env \


  		




  35
  35
  
    
	left_in_root='/*s/individualOrganismObservation/*ID->/*s/plotObservation' \


  		












Also available in:  Unified diff