Project

General

Profile

« Previous | Next » 

Revision 6777

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/vegbien.sql: Renamed sampletype to observationtype to match the VegCore term

View differences:

inputs/NCU/Source/VegBIEN.csv
1 1 
NCU,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:herbarium,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/TEAM/Source/VegBIEN.csv
1 1 
TEAM,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:primary database,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/CTFS/Source/VegBIEN.csv
1 1 
CTFS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:primary database,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/SALVIAS/Source/VegBIEN.csv
1 1 
SALVIAS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:aggregator,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/GBIF/Source/VegBIEN.csv
1 1 
GBIF,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:aggregator,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/JBM/Source/VegBIEN.csv
1 1 
JBM,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:herbarium,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/HIBG/Source/VegBIEN.csv
1 1 
HIBG,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:herbarium,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/SpeciesLink/Source/VegBIEN.csv
1 1 
SpeciesLink,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:aggregator,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/bien_web/observation/VegBIEN.csv
1 1 
bien_web,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 2 
observationID,"/_if[@name=""if specimen""]/cond/_exists",
3 3 
dataSourceName,"/_if[@name=""if specimen""]/else/source/shortname/_first/1",
4 
observationType,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
4 
observationType,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
5 5 
plotCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
6 6 
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
7 7 
observationType,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/Madidi/Source/VegBIEN.csv
1 1 
Madidi,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:primary database,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/CVS/Source/VegBIEN.csv
1 1 
CVS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:primary database,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/CVS/taxonObservation_/VegBIEN.csv
1 1 
CVS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 2 
museumAccessionNumber,"/_if[@name=""if specimen""]/cond/_exists",
3 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
3 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
4 4 
:plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
5 5 
museumAccessionNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists",
6 6 
museumAccessionNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",
inputs/.herbaria/herbaria/VegBIEN.csv
1 1 
herbaria,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 2 
herbariumAcronym,"/_if[@name=""if specimen""]/else/source/shortname/_first/1",
3 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
3 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
4 4 
:herbarium,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
5 5 
:specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
6 6 
herbariumAcronym,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then",
inputs/SALVIAS-CSV/Source/VegBIEN.csv
1 1 
SALVIAS-CSV,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:aggregator,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/REMIB/Source/VegBIEN.csv
1 1 
REMIB,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:aggregator,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/FIA/Source/VegBIEN.csv
1 1 
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:primary database,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/NVS/Source/VegBIEN.csv
1 1 
NVS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:primary database,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/VASCAN/Source/VegBIEN.csv
1 1 
VASCAN,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:herbarium,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/VegBank/Source/VegBIEN.csv
1 1 
VegBank,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
2 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
3 3 
:aggregator,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
4 4 
:plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
inputs/VegBank/taxonobservation_/VegBIEN.csv
1 1 
VegBank,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 2 
museumaccessionnumber,"/_if[@name=""if specimen""]/cond/_exists",
3 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",
3 
:plot,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",
4 4 
:plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
5 5 
museumaccessionnumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists",
6 6 
museumaccessionnumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",
schemas/vegbien.my.sql
46 46 

  		




  47
  47
  
    

  		




  48
  48
  
    
--


  		




  
  49
  
    
-- Name: observationtype; Type: TYPE; Schema: public; Owner: -


  		




  
  50
  
    
--


  		




  
  51
  
    

  		




  
  52
  
    

  		




  
  53
  
    

  		




  
  54
  
    

  		




  
  55
  
    
--


  		




  49
  56
  
    
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: -


  		




  50
  57
  
    
--


  		




  51
  58
  
    

  		




  ......




  116
  123
  
    

  		




  117
  124
  
    

  		




  118
  125
  
    
--


  		




  119
  
  
    
-- Name: sampletype; Type: TYPE; Schema: public; Owner: -


  		




  120
  
  
    
--


  		




  121
  
  
    

  		




  122
  
  
    

  		




  123
  
  
    

  		




  124
  
  
    

  		




  125
  
  
    
--


  		




  126
  126
  
    
-- Name: sourcetype; Type: TYPE; Schema: public; Owner: -


  		




  127
  127
  
    
--


  		




  128
  128
  
    

  		




  ......




  1267
  1267
  
    
    sourcetype varchar(255),


  		




  1268
  1268
  
    
    accesslevel varchar(255),


  		




  1269
  1269
  
    
    accessconditions varchar(255),


  		




  1270
  
  
    
    sampletype varchar(255),


  		




  
  1270
  
    
    observationtype varchar(255),


  		




  1271
  1271
  
    
    title varchar(255),


  		




  1272
  1272
  
    
    titlesuperior varchar(255),


  		




  1273
  1273
  
    
    volume varchar(255),


  		












  

    
      schemas/vegbien.sql
    
  





  80
  80
  
    

  		




  81
  81
  
    

  		




  82
  82
  
    
--


  		




  
  83
  
    
-- Name: observationtype; Type: TYPE; Schema: public; Owner: -


  		




  
  84
  
    
--


  		




  
  85
  
    

  		




  
  86
  
    
CREATE TYPE observationtype AS ENUM (


  		




  
  87
  
    
    'plot',


  		




  
  88
  
    
    'specimen'


  		




  
  89
  
    
);


  		




  
  90
  
    

  		




  
  91
  
    

  		




  
  92
  
    
--


  		




  83
  93
  
    
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: -


  		




  84
  94
  
    
--


  		




  85
  95
  
    

  		




  ......




  277
  287
  
    

  		




  278
  288
  
    

  		




  279
  289
  
    
--


  		




  280
  
  
    
-- Name: sampletype; Type: TYPE; Schema: public; Owner: -


  		




  281
  
  
    
--


  		




  282
  
  
    

  		




  283
  
  
    
CREATE TYPE sampletype AS ENUM (


  		




  284
  
  
    
    'plot',


  		




  285
  
  
    
    'specimen'


  		




  286
  
  
    
);


  		




  287
  
  
    

  		




  288
  
  
    

  		




  289
  
  
    
--


  		




  290
  290
  
    
-- Name: sourcetype; Type: TYPE; Schema: public; Owner: -


  		




  291
  291
  
    
--


  		




  292
  292
  
    

  		




  ......




  2042
  2042
  
    
    sourcetype sourcetype,


  		




  2043
  2043
  
    
    accesslevel accesslevel,


  		




  2044
  2044
  
    
    accessconditions text,


  		




  2045
  
  
    
    sampletype sampletype,


  		




  
  2045
  
    
    observationtype observationtype,


  		




  2046
  2046
  
    
    title text,


  		




  2047
  2047
  
    
    titlesuperior text,


  		




  2048
  2048
  
    
    volume text,


  		












  

    
      mappings/VegCore-VegBIEN.csv
    
  





  2
  2
  
    
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists",


  		




  3
  3
  
    
occurrenceID,"/_if[@name=""if specimen""]/cond/_exists",


  		




  4
  4
  
    
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1",


  		




  5
  
  
    
observationType,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",


  		




  
  5
  
    
observationType,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/observationtype",


  		




  6
  6
  
    
referenceType,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",


  		




  7
  7
  
    
subplot,"/location/_if[@name=""if subplot""]/cond/_exists",


  		




  8
  8
  
    
subplotID,"/location/_if[@name=""if subplot""]/cond/_exists",


  		












  

    
      mappings/for_review/VegCore-VegBIEN.csv
    
  





  2
  2
  
    
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists",


  		




  3
  3
  
    
occurrenceID,"/_if[@name=""if specimen""]/cond/_exists",


  		




  4
  4
  
    
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname",


  		




  5
  
  
    
observationType,"/_if[@name=""if specimen""]/else/source/sampletype",


  		




  
  5
  
    
observationType,"/_if[@name=""if specimen""]/else/source/observationtype",


  		




  6
  6
  
    
referenceType,"/_if[@name=""if specimen""]/else/source/sourcetype",


  		




  7
  7
  
    
subplot,"/location/_if[@name=""if subplot""]/cond/_exists",


  		




  8
  8
  
    
subplotID,"/location/_if[@name=""if subplot""]/cond/_exists",


  		












Also available in:  Unified diff