Project

General

Profile

« Previous | Next » 

Revision 3199

Added by Aaron Marcuse-Kubitza over 12 years ago

VegBIEN: Fixing import issue related to duplicate entries in tables with children, where when a new table entry duplicates an existing entry, the 1:1 tables of that table and those tables' children are not merged, causing them to become orphaned. It is described in detail at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Import_issues#Merging-duplicates-with-children&gt;, including the rationale for this solution. Note that this is not a bug in column-based import, it applies to row-based import as well. This commit fixes the issue for specimenreplicate->taxonoccurrence.

View differences:

inputs/MO/test/import.specimens.out.ref
1 
Inserted 34 new rows into database
1 
Inserted 32 new rows into database
inputs/QMOR/test/import.specimens.out.ref
1 
Inserted 30 new rows into database
1 
Inserted 28 new rows into database
schemas/vegbien.my.sql
103 103 

  		




  104
  104
  
    

  		




  105
  105
  
    
--


  		




  
  106
  
    
-- Name: taxondetermination_taxonoccurrence_id_fkey(); Type: FUNCTION; Schema: public; Owner: -


  		




  
  107
  
    
--


  		




  
  108
  
    

  		




  
  109
  
    

  		




  
  110
  
    

  		




  
  111
  
    

  		




  
  112
  
    
--


  		




  106
  113
  
    
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -


  		




  107
  114
  
    
--


  		




  108
  115
  
    

  		




  ......




  2101
  2108
  
    

  		




  2102
  2109
  
    

  		




  2103
  2110
  
    
--


  		




  2104
  
  
    
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  
  2111
  
    
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  2105
  2112
  
    
--


  		




  2106
  2113
  
    

  		




  2107
  
  
    
CREATE TABLE specimenreplicate (


  		




  2108
  
  
    
    specimenreplicate_id int(11) NOT NULL,


  		




  2109
  
  
    
    datasource_id int(11) NOT NULL,


  		




  2110
  
  
    
    collectioncode_dwc text,


  		




  2111
  
  
    
    catalognumber_dwc text,


  		




  2112
  
  
    
    collectiondate timestamp NULL,


  		




  2113
  
  
    
    institution_id int(11),


  		




  2114
  
  
    
    sourceaccessioncode text,


  		




  
  2114
  
    
CREATE TABLE taxonoccurrence (


  		




  2115
  2115
  
    
    taxonoccurrence_id int(11) NOT NULL,


  		




  2116
  
  
    
    collectionnumber text,


  		




  2117
  
  
    
    specimen_id int(11),


  		




  2118
  
  
    
    description text,


  		




  
  2116
  
    
    locationevent_id int(11),


  		




  
  2117
  
    
    verbatimcollectorname text,


  		




  
  2118
  
    
    growthform text,


  		




  
  2119
  
    
    iscultivated int(1),


  		




  
  2120
  
    
    cultivatedbasis text,


  		




  
  2121
  
    
    isnative int(1),


  		




  2119
  2122
  
    
    accessioncode text


  		




  2120
  2123
  
    
);


  		




  2121
  2124
  
    

  		




  2122
  2125
  
    

  		




  2123
  2126
  
    
--


  		




  2124
  
  
    
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -


  		




  
  2127
  
    
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -


  		




  2125
  2128
  
    
--


  		




  2126
  2129
  
    

  		




  2127
  2130
  
    

  		




  2128
  2131
  
    

  		




  2129
  2132
  
    

  		




  2130
  2133
  
    
--


  		




  2131
  
  
    
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -


  		




  
  2134
  
    
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -


  		




  2132
  2135
  
    
--


  		




  2133
  2136
  
    

  		




  2134
  2137
  
    

  		




  2135
  2138
  
    

  		




  2136
  2139
  
    

  		




  2137
  2140
  
    
--


  		




  2138
  
  
    
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -


  		




  
  2141
  
    
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -


  		




  2139
  2142
  
    
--


  		




  2140
  2143
  
    

  		




  2141
  2144
  
    

  		




  2142
  2145
  
    

  		




  2143
  2146
  
    

  		




  2144
  2147
  
    
--


  		




  2145
  
  
    
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -


  		




  
  2148
  
    
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -


  		




  2146
  2149
  
    
--


  		




  2147
  2150
  
    

  		




  2148
  2151
  
    

  		




  2149
  2152
  
    

  		




  2150
  2153
  
    

  		




  2151
  2154
  
    
--


  		




  2152
  
  
    
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -


  		




  
  2155
  
    
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -


  		




  2153
  2156
  
    
--


  		




  2154
  2157
  
    

  		




  2155
  2158
  
    

  		




  2156
  2159
  
    

  		




  2157
  2160
  
    

  		




  2158
  2161
  
    
--


  		




  2159
  
  
    
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -


  		




  
  2162
  
    
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -


  		




  2160
  2163
  
    
--


  		




  2161
  2164
  
    

  		




  2162
  2165
  
    

  		




  ......




  2165
  2168
  
    

  		




  2166
  2169
  
    

  		




  2167
  2170
  
    
--


  		




  
  2171
  
    
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  
  2172
  
    
--


  		




  
  2173
  
    

  		




  
  2174
  
    
CREATE TABLE specimenreplicate (


  		




  
  2175
  
    
    taxonoccurrence_id int(11) NOT NULL AUTO_INCREMENT,


  		




  
  2176
  
    
    datasource_id int(11) NOT NULL,


  		




  
  2177
  
    
    collectioncode_dwc text,


  		




  
  2178
  
    
    catalognumber_dwc text,


  		




  
  2179
  
    
    collectiondate timestamp NULL,


  		




  
  2180
  
    
    institution_id int(11),


  		




  
  2181
  
    
    sourceaccessioncode text,


  		




  
  2182
  
    
    collectionnumber text,


  		




  
  2183
  
    
    specimen_id int(11),


  		




  
  2184
  
    
    description text


  		




  
  2185
  
    
)


  		




  
  2186
  
    
;


  		




  
  2187
  
    
ALTER TABLE specimenreplicate


  		




  
  2188
  
    
    ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  2189
  
    

  		




  
  2190
  
    

  		




  
  2191
  
    

  		




  
  2192
  
    
--


  		




  
  2193
  
    
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -


  		




  
  2194
  
    
--


  		




  
  2195
  
    

  		




  
  2196
  
    

  		




  
  2197
  
    

  		




  
  2198
  
    

  		




  
  2199
  
    
--


  		




  
  2200
  
    
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -


  		




  
  2201
  
    
--


  		




  
  2202
  
    

  		




  
  2203
  
    

  		




  
  2204
  
    

  		




  
  2205
  
    

  		




  
  2206
  
    
--


  		




  
  2207
  
    
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -


  		




  
  2208
  
    
--


  		




  
  2209
  
    

  		




  
  2210
  
    

  		




  
  2211
  
    

  		




  
  2212
  
    

  		




  
  2213
  
    
--


  		




  
  2214
  
    
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -


  		




  
  2215
  
    
--


  		




  
  2216
  
    

  		




  
  2217
  
    

  		




  
  2218
  
    

  		




  
  2219
  
    

  		




  
  2220
  
    
--


  		




  2168
  2221
  
    
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  2169
  2222
  
    
--


  		




  2170
  2223
  
    

  		




  ......




  2343
  2396
  
    

  		




  2344
  2397
  
    

  		




  2345
  2398
  
    
--


  		




  2346
  
  
    
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  2347
  
  
    
--


  		




  2348
  
  
    

  		




  2349
  
  
    
CREATE TABLE taxonoccurrence (


  		




  2350
  
  
    
    taxonoccurrence_id int(11) NOT NULL,


  		




  2351
  
  
    
    locationevent_id int(11),


  		




  2352
  
  
    
    verbatimcollectorname text,


  		




  2353
  
  
    
    growthform text,


  		




  2354
  
  
    
    iscultivated int(1),


  		




  2355
  
  
    
    cultivatedbasis text,


  		




  2356
  
  
    
    isnative int(1),


  		




  2357
  
  
    
    accessioncode text


  		




  2358
  
  
    
);


  		




  2359
  
  
    

  		




  2360
  
  
    

  		




  2361
  
  
    
--


  		




  2362
  
  
    
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -


  		




  2363
  
  
    
--


  		




  2364
  
  
    

  		




  2365
  
  
    

  		




  2366
  
  
    

  		




  2367
  
  
    

  		




  2368
  
  
    
--


  		




  2369
  
  
    
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -


  		




  2370
  
  
    
--


  		




  2371
  
  
    

  		




  2372
  
  
    

  		




  2373
  
  
    

  		




  2374
  
  
    

  		




  2375
  
  
    
--


  		




  2376
  
  
    
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -


  		




  2377
  
  
    
--


  		




  2378
  
  
    

  		




  2379
  
  
    

  		




  2380
  
  
    

  		




  2381
  
  
    

  		




  2382
  
  
    
--


  		




  2383
  
  
    
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -


  		




  2384
  
  
    
--


  		




  2385
  
  
    

  		




  2386
  
  
    

  		




  2387
  
  
    

  		




  2388
  
  
    

  		




  2389
  
  
    
--


  		




  2390
  
  
    
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -


  		




  2391
  
  
    
--


  		




  2392
  
  
    

  		




  2393
  
  
    

  		




  2394
  
  
    

  		




  2395
  
  
    

  		




  2396
  
  
    
--


  		




  2397
  
  
    
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -


  		




  2398
  
  
    
--


  		




  2399
  
  
    

  		




  2400
  
  
    

  		




  2401
  
  
    

  		




  2402
  
  
    

  		




  2403
  
  
    
--


  		




  2404
  2399
  
    
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  2405
  2400
  
    
--


  		




  2406
  2401
  
    

  		




  ......




  2857
  2852
  
    

  		




  2858
  2853
  
    

  		




  2859
  2854
  
    
--


  		




  2860
  
  
    
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -


  		




  2861
  
  
    
--


  		




  2862
  
  
    

  		




  2863
  
  
    

  		




  2864
  
  
    

  		




  2865
  
  
    

  		




  2866
  
  
    
--


  		




  2867
  2855
  
    
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -


  		




  2868
  2856
  
    
--


  		




  2869
  2857
  
    

  		




  ......




  3490
  3478
  
    
--


  		




  3491
  3479
  
    

  		




  3492
  3480
  
    
ALTER TABLE specimenreplicate


  		




  3493
  
  
    
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);


  		




  
  3481
  
    
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (taxonoccurrence_id);


  		




  3494
  3482
  
    

  		




  3495
  3483
  
    

  		




  3496
  3484
  
    
--


  		




  ......




  4085
  4073
  
    

  		




  4086
  4074
  
    

  		




  4087
  4075
  
    
--


  		




  4088
  
  
    
-- Name: fki_specimenreplicate_taxonoccurrence_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4089
  
  
    
--


  		




  4090
  
  
    

  		




  4091
  
  
    
CREATE INDEX fki_specimenreplicate_taxonoccurrence_id ON specimenreplicate  (taxonoccurrence_id);


  		




  4092
  
  
    

  		




  4093
  
  
    

  		




  4094
  
  
    
--


  		




  4095
  4076
  
    
-- Name: fki_stemtag_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4096
  4077
  
    
--


  		




  4097
  4078
  
    

  		




  ......




  4834
  4815
  
    

  		




  4835
  4816
  
    

  		




  4836
  4817
  
    
--


  		




  
  4818
  
    
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: TRIGGER; Schema: public; Owner: -


  		




  
  4819
  
    
--


  		




  
  4820
  
    

  		




  
  4821
  
    

  		




  
  4822
  
    

  		




  
  4823
  
    

  		




  
  4824
  
    
--


  		




  4837
  4825
  
    
-- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4838
  4826
  
    
--


  		




  4839
  4827
  
    

  		




  ......




  5612
  5600
  
    

  		




  5613
  5601
  
    

  		




  5614
  5602
  
    
--


  		




  5615
  
  
    
-- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  5616
  
  
    
--


  		




  5617
  
  
    

  		




  5618
  
  
    
ALTER TABLE specimenreplicate


  		




  5619
  
  
    
    ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  5620
  
  
    

  		




  5621
  
  
    

  		




  5622
  
  
    
--


  		




  5623
  5603
  
    
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  5624
  5604
  
    
--


  		




  5625
  5605
  
    

  		




  ......




  5690
  5670
  
    

  		




  5691
  5671
  
    

  		




  5692
  5672
  
    
--


  		




  5693
  
  
    
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  5694
  
  
    
--


  		




  5695
  
  
    

  		




  5696
  
  
    
ALTER TABLE taxondetermination


  		




  5697
  
  
    
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  5698
  
  
    

  		




  5699
  
  
    

  		




  5700
  
  
    
--


  		




  5701
  5673
  
    
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  5702
  5674
  
    
--


  		




  5703
  5675
  
    

  		




  ......




  5726
  5698
  
    
--


  		




  5727
  5699
  
    

  		




  5728
  5700
  
    
ALTER TABLE voucher


  		




  5729
  
  
    
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  5701
  
    
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  5730
  5702
  
    

  		




  5731
  5703
  
    

  		




  5732
  5704
  
    
--


  		












  

    
      schemas/vegbien.sql
    
  





  294
  294
  
    

  		




  295
  295
  
    

  		




  296
  296
  
    
--


  		




  
  297
  
    
-- Name: taxondetermination_taxonoccurrence_id_fkey(); Type: FUNCTION; Schema: public; Owner: -


  		




  
  298
  
    
--


  		




  
  299
  
    

  		




  
  300
  
    
CREATE FUNCTION taxondetermination_taxonoccurrence_id_fkey() RETURNS trigger


  		




  
  301
  
    
    LANGUAGE plpgsql


  		




  
  302
  
    
    AS $$


  		




  
  303
  
    
BEGIN


  		




  
  304
  
    
    IF (


  		




  
  305
  
    
        SELECT count(*) = 0


  		




  
  306
  
    
        FROM taxonoccurrence


  		




  
  307
  
    
        WHERE taxonoccurrence_id = new.taxonoccurrence_id


  		




  
  308
  
    
    ) THEN


  		




  
  309
  
    
        RAISE EXCEPTION 'duplicate key value violates unique constraint '


  		




  
  310
  
    
            '"taxondetermination_taxonoccurrence_id_fkey()"'


  		




  
  311
  
    
            USING ERRCODE = 'unique_violation';


  		




  
  312
  
    
    END IF;


  		




  
  313
  
    
    


  		




  
  314
  
    
    RETURN new;


  		




  
  315
  
    
END;


  		




  
  316
  
    
$$;


  		




  
  317
  
    

  		




  
  318
  
    

  		




  
  319
  
    
--


  		




  297
  320
  
    
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -


  		




  298
  321
  
    
--


  		




  299
  322
  
    

  		




  ......




  2573
  2596
  
    

  		




  2574
  2597
  
    

  		




  2575
  2598
  
    
--


  		




  2576
  
  
    
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  
  2599
  
    
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  2577
  2600
  
    
--


  		




  2578
  2601
  
    

  		




  2579
  
  
    
CREATE TABLE specimenreplicate (


  		




  2580
  
  
    
    specimenreplicate_id integer NOT NULL,


  		




  2581
  
  
    
    datasource_id integer NOT NULL,


  		




  2582
  
  
    
    collectioncode_dwc text,


  		




  2583
  
  
    
    catalognumber_dwc text,


  		




  2584
  
  
    
    collectiondate timestamp with time zone,


  		




  2585
  
  
    
    institution_id integer,


  		




  2586
  
  
    
    sourceaccessioncode text,


  		




  
  2602
  
    
CREATE TABLE taxonoccurrence (


  		




  2587
  2603
  
    
    taxonoccurrence_id integer NOT NULL,


  		




  2588
  
  
    
    collectionnumber text,


  		




  2589
  
  
    
    specimen_id integer,


  		




  2590
  
  
    
    description text,


  		




  
  2604
  
    
    locationevent_id integer,


  		




  
  2605
  
    
    verbatimcollectorname text,


  		




  
  2606
  
    
    growthform growthform,


  		




  
  2607
  
    
    iscultivated boolean,


  		




  
  2608
  
    
    cultivatedbasis text,


  		




  
  2609
  
    
    isnative boolean,


  		




  2591
  2610
  
    
    accessioncode text


  		




  2592
  2611
  
    
);


  		




  2593
  2612
  
    

  		




  2594
  2613
  
    

  		




  2595
  2614
  
    
--


  		




  2596
  
  
    
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -


  		




  
  2615
  
    
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -


  		




  2597
  2616
  
    
--


  		




  2598
  2617
  
    

  		




  2599
  
  
    
COMMENT ON TABLE specimenreplicate IS 'A herbarium''s replicate of a specimen. Contains Darwin Core specimen data.';


  		




  
  2618
  
    
COMMENT ON TABLE taxonoccurrence IS 'VegBank''s taxonobservation table.';


  		




  2600
  2619
  
    

  		




  2601
  2620
  
    

  		




  2602
  2621
  
    
--


  		




  2603
  
  
    
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -


  		




  
  2622
  
    
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -


  		




  2604
  2623
  
    
--


  		




  2605
  2624
  
    

  		




  2606
  
  
    
COMMENT ON COLUMN specimenreplicate.collectioncode_dwc IS 'The code for the collection that the specimenreplicate is from.';


  		




  
  2625
  
    
COMMENT ON COLUMN taxonoccurrence.iscultivated IS 'cultivated or wild';


  		




  2607
  2626
  
    

  		




  2608
  2627
  
    

  		




  2609
  2628
  
    
--


  		




  2610
  
  
    
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -


  		




  
  2629
  
    
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -


  		




  2611
  2630
  
    
--


  		




  2612
  2631
  
    

  		




  2613
  
  
    
COMMENT ON COLUMN specimenreplicate.institution_id IS 'The the institution (such as a museum) that the specimenreplicate is from.';


  		




  
  2632
  
    
COMMENT ON COLUMN taxonoccurrence.cultivatedbasis IS 'The reason why a taxonoccurrence was marked as cultivated (or not).';


  		




  2614
  2633
  
    

  		




  2615
  2634
  
    

  		




  2616
  2635
  
    
--


  		




  2617
  
  
    
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -


  		




  
  2636
  
    
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -


  		




  2618
  2637
  
    
--


  		




  2619
  2638
  
    

  		




  2620
  
  
    
COMMENT ON COLUMN specimenreplicate.collectionnumber IS 'The number of the specimenreplicate within the collection.';


  		




  
  2639
  
    
COMMENT ON COLUMN taxonoccurrence.isnative IS 'native or exotic';


  		




  2621
  2640
  
    

  		




  2622
  2641
  
    

  		




  2623
  2642
  
    
--


  		




  2624
  
  
    
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -


  		




  
  2643
  
    
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -


  		




  2625
  2644
  
    
--


  		




  2626
  2645
  
    

  		




  2627
  
  
    
CREATE SEQUENCE specimenreplicate_specimenreplicate_id_seq


  		




  
  2646
  
    
CREATE SEQUENCE taxonoccurrence_taxonoccurrence_id_seq


  		




  2628
  2647
  
    
    START WITH 1


  		




  2629
  2648
  
    
    INCREMENT BY 1


  		




  2630
  2649
  
    
    NO MINVALUE


  		




  ......




  2633
  2652
  
    

  		




  2634
  2653
  
    

  		




  2635
  2654
  
    
--


  		




  2636
  
  
    
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -


  		




  
  2655
  
    
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -


  		




  2637
  2656
  
    
--


  		




  2638
  2657
  
    

  		




  2639
  
  
    
ALTER SEQUENCE specimenreplicate_specimenreplicate_id_seq OWNED BY specimenreplicate.specimenreplicate_id;


  		




  
  2658
  
    
ALTER SEQUENCE taxonoccurrence_taxonoccurrence_id_seq OWNED BY taxonoccurrence.taxonoccurrence_id;


  		




  2640
  2659
  
    

  		




  2641
  2660
  
    

  		




  2642
  2661
  
    
SET default_with_oids = true;


  		




  2643
  2662
  
    

  		




  2644
  2663
  
    
--


  		




  
  2664
  
    
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  
  2665
  
    
--


  		




  
  2666
  
    

  		




  
  2667
  
    
CREATE TABLE specimenreplicate (


  		




  
  2668
  
    
    datasource_id integer NOT NULL,


  		




  
  2669
  
    
    collectioncode_dwc text,


  		




  
  2670
  
    
    catalognumber_dwc text,


  		




  
  2671
  
    
    collectiondate timestamp with time zone,


  		




  
  2672
  
    
    institution_id integer,


  		




  
  2673
  
    
    sourceaccessioncode text,


  		




  
  2674
  
    
    collectionnumber text,


  		




  
  2675
  
    
    specimen_id integer,


  		




  
  2676
  
    
    description text


  		




  
  2677
  
    
)


  		




  
  2678
  
    
INHERITS (taxonoccurrence);


  		




  
  2679
  
    

  		




  
  2680
  
    

  		




  
  2681
  
    
--


  		




  
  2682
  
    
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -


  		




  
  2683
  
    
--


  		




  
  2684
  
    

  		




  
  2685
  
    
COMMENT ON TABLE specimenreplicate IS 'A herbarium''s replicate of a specimen. Contains Darwin Core specimen data.';


  		




  
  2686
  
    

  		




  
  2687
  
    

  		




  
  2688
  
    
--


  		




  
  2689
  
    
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -


  		




  
  2690
  
    
--


  		




  
  2691
  
    

  		




  
  2692
  
    
COMMENT ON COLUMN specimenreplicate.collectioncode_dwc IS 'The code for the collection that the specimenreplicate is from.';


  		




  
  2693
  
    

  		




  
  2694
  
    

  		




  
  2695
  
    
--


  		




  
  2696
  
    
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -


  		




  
  2697
  
    
--


  		




  
  2698
  
    

  		




  
  2699
  
    
COMMENT ON COLUMN specimenreplicate.institution_id IS 'The the institution (such as a museum) that the specimenreplicate is from.';


  		




  
  2700
  
    

  		




  
  2701
  
    

  		




  
  2702
  
    
--


  		




  
  2703
  
    
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -


  		




  
  2704
  
    
--


  		




  
  2705
  
    

  		




  
  2706
  
    
COMMENT ON COLUMN specimenreplicate.collectionnumber IS 'The number of the specimenreplicate within the collection.';


  		




  
  2707
  
    

  		




  
  2708
  
    

  		




  
  2709
  
    
--


  		




  2645
  2710
  
    
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  2646
  2711
  
    
--


  		




  2647
  2712
  
    

  		




  ......




  2845
  2910
  
    

  		




  2846
  2911
  
    

  		




  2847
  2912
  
    
--


  		




  2848
  
  
    
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  2849
  
  
    
--


  		




  2850
  
  
    

  		




  2851
  
  
    
CREATE TABLE taxonoccurrence (


  		




  2852
  
  
    
    taxonoccurrence_id integer NOT NULL,


  		




  2853
  
  
    
    locationevent_id integer,


  		




  2854
  
  
    
    verbatimcollectorname text,


  		




  2855
  
  
    
    growthform growthform,


  		




  2856
  
  
    
    iscultivated boolean,


  		




  2857
  
  
    
    cultivatedbasis text,


  		




  2858
  
  
    
    isnative boolean,


  		




  2859
  
  
    
    accessioncode text


  		




  2860
  
  
    
);


  		




  2861
  
  
    

  		




  2862
  
  
    

  		




  2863
  
  
    
--


  		




  2864
  
  
    
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -


  		




  2865
  
  
    
--


  		




  2866
  
  
    

  		




  2867
  
  
    
COMMENT ON TABLE taxonoccurrence IS 'VegBank''s taxonobservation table.';


  		




  2868
  
  
    

  		




  2869
  
  
    

  		




  2870
  
  
    
--


  		




  2871
  
  
    
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -


  		




  2872
  
  
    
--


  		




  2873
  
  
    

  		




  2874
  
  
    
COMMENT ON COLUMN taxonoccurrence.iscultivated IS 'cultivated or wild';


  		




  2875
  
  
    

  		




  2876
  
  
    

  		




  2877
  
  
    
--


  		




  2878
  
  
    
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -


  		




  2879
  
  
    
--


  		




  2880
  
  
    

  		




  2881
  
  
    
COMMENT ON COLUMN taxonoccurrence.cultivatedbasis IS 'The reason why a taxonoccurrence was marked as cultivated (or not).';


  		




  2882
  
  
    

  		




  2883
  
  
    

  		




  2884
  
  
    
--


  		




  2885
  
  
    
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -


  		




  2886
  
  
    
--


  		




  2887
  
  
    

  		




  2888
  
  
    
COMMENT ON COLUMN taxonoccurrence.isnative IS 'native or exotic';


  		




  2889
  
  
    

  		




  2890
  
  
    

  		




  2891
  
  
    
--


  		




  2892
  
  
    
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -


  		




  2893
  
  
    
--


  		




  2894
  
  
    

  		




  2895
  
  
    
CREATE SEQUENCE taxonoccurrence_taxonoccurrence_id_seq


  		




  2896
  
  
    
    START WITH 1


  		




  2897
  
  
    
    INCREMENT BY 1


  		




  2898
  
  
    
    NO MINVALUE


  		




  2899
  
  
    
    NO MAXVALUE


  		




  2900
  
  
    
    CACHE 1;


  		




  2901
  
  
    

  		




  2902
  
  
    

  		




  2903
  
  
    
--


  		




  2904
  
  
    
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -


  		




  2905
  
  
    
--


  		




  2906
  
  
    

  		




  2907
  
  
    
ALTER SEQUENCE taxonoccurrence_taxonoccurrence_id_seq OWNED BY taxonoccurrence.taxonoccurrence_id;


  		




  2908
  
  
    

  		




  2909
  
  
    

  		




  2910
  
  
    
--


  		




  2911
  2913
  
    
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  2912
  2914
  
    
--


  		




  2913
  2915
  
    

  		




  ......




  3384
  3386
  
    

  		




  3385
  3387
  
    

  		




  3386
  3388
  
    
--


  		




  3387
  
  
    
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -


  		




  3388
  
  
    
--


  		




  3389
  
  
    

  		




  3390
  
  
    
ALTER TABLE specimenreplicate ALTER COLUMN specimenreplicate_id SET DEFAULT nextval('specimenreplicate_specimenreplicate_id_seq'::regclass);


  		




  3391
  
  
    

  		




  3392
  
  
    

  		




  3393
  
  
    
--


  		




  3394
  3389
  
    
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -


  		




  3395
  3390
  
    
--


  		




  3396
  3391
  
    

  		




  ......




  4017
  4012
  
    
--


  		




  4018
  4013
  
    

  		




  4019
  4014
  
    
ALTER TABLE ONLY specimenreplicate


  		




  4020
  
  
    
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);


  		




  
  4015
  
    
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (taxonoccurrence_id);


  		




  4021
  4016
  
    

  		




  4022
  4017
  
    

  		




  4023
  4018
  
    
--


  		




  ......




  4612
  4607
  
    

  		




  4613
  4608
  
    

  		




  4614
  4609
  
    
--


  		




  4615
  
  
    
-- Name: fki_specimenreplicate_taxonoccurrence_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4616
  
  
    
--


  		




  4617
  
  
    

  		




  4618
  
  
    
CREATE INDEX fki_specimenreplicate_taxonoccurrence_id ON specimenreplicate USING btree (taxonoccurrence_id);


  		




  4619
  
  
    

  		




  4620
  
  
    

  		




  4621
  
  
    
--


  		




  4622
  4610
  
    
-- Name: fki_stemtag_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4623
  4611
  
    
--


  		




  4624
  4612
  
    

  		




  ......




  5361
  5349
  
    

  		




  5362
  5350
  
    

  		




  5363
  5351
  
    
--


  		




  
  5352
  
    
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: TRIGGER; Schema: public; Owner: -


  		




  
  5353
  
    
--


  		




  
  5354
  
    

  		




  
  5355
  
    
CREATE TRIGGER taxondetermination_taxonoccurrence_id_fkey BEFORE INSERT OR UPDATE ON taxondetermination FOR EACH ROW EXECUTE PROCEDURE taxondetermination_taxonoccurrence_id_fkey();


  		




  
  5356
  
    

  		




  
  5357
  
    

  		




  
  5358
  
    
--


  		




  5364
  5359
  
    
-- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  5365
  5360
  
    
--


  		




  5366
  5361
  
    

  		




  ......




  6161
  6156
  
    

  		




  6162
  6157
  
    

  		




  6163
  6158
  
    
--


  		




  6164
  
  
    
-- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  6165
  
  
    
--


  		




  6166
  
  
    

  		




  6167
  
  
    
ALTER TABLE ONLY specimenreplicate


  		




  6168
  
  
    
    ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  6169
  
  
    

  		




  6170
  
  
    

  		




  6171
  
  
    
--


  		




  6172
  6159
  
    
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  6173
  6160
  
    
--


  		




  6174
  6161
  
    

  		




  ......




  6241
  6228
  
    

  		




  6242
  6229
  
    

  		




  6243
  6230
  
    
--


  		




  6244
  
  
    
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  6245
  
  
    
--


  		




  6246
  
  
    

  		




  6247
  
  
    
ALTER TABLE ONLY taxondetermination


  		




  6248
  
  
    
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  6249
  
  
    

  		




  6250
  
  
    

  		




  6251
  
  
    
--


  		




  6252
  6231
  
    
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  6253
  6232
  
    
--


  		




  6254
  6233
  
    

  		




  ......




  6277
  6256
  
    
--


  		




  6278
  6257
  
    

  		




  6279
  6258
  
    
ALTER TABLE ONLY voucher


  		




  6280
  
  
    
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  6259
  
    
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  6281
  6260
  
    

  		




  6282
  6261
  
    

  		




  6283
  6262
  
    
--


  		












  

    
      mappings/DwC2-VegBIEN.specimens.csv
    
  





  1
  1
  
    
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",VegBIEN:/specimenreplicate,Comments,Order


  		




  2
  
  
    
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88


  		




  3
  
  
    
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89


  		




  4
  
  
    
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  5
  
  
    
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  6
  
  
    
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  7
  
  
    
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  8
  
  
    
continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  9
  
  
    
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  10
  
  
    
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69


  		




  11
  
  
    
habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52


  		




  12
  
  
    
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  13
  
  
    
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  14
  
  
    
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  15
  
  
    
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  16
  
  
    
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  17
  
  
    
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  18
  
  
    
maximumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  19
  
  
    
minimumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  20
  
  
    
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44


  		




  21
  
  
    
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120


  		




  22
  
  
    
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  23
  
  
    
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  24
  
  
    
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  25
  
  
    
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  26
  
  
    
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  27
  
  
    
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  28
  
  
    
family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  29
  
  
    
order,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145


  		




  30
  
  
    
class,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144


  		




  31
  
  
    
phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143


  		




  32
  
  
    
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  33
  
  
    
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  34
  
  
    
establishmentMeans,"/*_id/taxonoccurrence/{growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=],iscultivated/_map:[cultivated=t,wild=f,*=],isnative/_map:[native=t,exotic=f,*=]}/value",,30


  		




  
  2
  
    
coordinateUncertaintyInMeters,/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88


  		




  
  3
  
    
coordinatePrecision,/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89


  		




  
  4
  
    
footprintWKT,/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  
  5
  
    
county,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  
  6
  
    
stateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  
  7
  
    
country,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  
  8
  
    
continent,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  
  9
  
    
locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  
  10
  
    
verbatimLocality,/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69


  		




  
  11
  
    
habitat,"/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52


  		




  
  12
  
    
minimumElevationInMeters,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  
  13
  
    
maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  
  14
  
    
decimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  
  15
  
    
verbatimLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  
  16
  
    
decimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  
  17
  
    
verbatimLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  
  18
  
    
maximumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  
  19
  
    
minimumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  
  20
  
    
eventDate,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44


  		




  35
  21
  
    
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12


  		




  36
  22
  
    
sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26


  		




  37
  23
  
    
fieldNotes,/description/_merge/1,,


  		




  38
  24
  
    
taxonRemarks,/description/_merge/2,,158


  		




  39
  
  
    
catalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  40
  
  
    
occurrenceID,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  
  25
  
    
dateIdentified,/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120


  		




  
  26
  
    
identifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  
  27
  
    
scientificName,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  
  28
  
    
scientificNameAuthorship,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  
  29
  
    
infraspecificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  
  30
  
    
specificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  
  31
  
    
genus,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  
  32
  
    
family,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  
  33
  
    
order,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145


  		




  
  34
  
    
class,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144


  		




  
  35
  
    
phylum,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143


  		




  
  36
  
    
kingdom,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  
  37
  
    
recordedBy,/verbatimcollectorname,,23


  		




  
  38
  
    
establishmentMeans,"/{growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=],iscultivated/_map:[cultivated=t,wild=f,*=],isnative/_map:[native=t,exotic=f,*=]}/value",,30


  		




  
  39
  
    
catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  41
  40
  
    
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22


  		




  42
  41
  
    
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9


  		




  43
  42
  
    
fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53


  		




  44
  43
  
    
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8


  		




  45
  44
  
    
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,


  		




  
  45
  
    
occurrenceID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  46
  46
  
    
acceptedNameUsage,,,135


  		




  47
  47
  
    
acceptedNameUsageID,,,128


  		




  48
  48
  
    
associatedMedia,,,36


  		












  

    
      inputs/GBIF/test/import.specimens.out.ref
    
  





  1
  
  
    
Inserted 27 new rows into database


  		




  
  1
  
    
Inserted 25 new rows into database


  		












  

    
      inputs/GBIF/maps/VegBIEN.specimens.csv
    
  





  1
  1
  
    
GBIF[DwC],VegBIEN:/specimenreplicate,Comments,Order


  		




  2
  
  
    
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  3
  
  
    
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  4
  
  
    
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  5
  
  
    
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  6
  
  
    
MinimumElevationInMeter,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  7
  
  
    
MaximumElevationInMeter,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  8
  
  
    
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  9
  
  
    
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  10
  
  
    
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  11
  
  
    
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  12
  
  
    
LatestDateCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44


  		




  13
  
  
    
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  14
  
  
    
ScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  15
  
  
    
AuthorOfScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  16
  
  
    
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  17
  
  
    
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  18
  
  
    
Genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  19
  
  
    
Family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  20
  
  
    
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  
  2
  
    
County,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  
  3
  
    
StateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  
  4
  
    
Country,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  
  5
  
    
Locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  
  6
  
    
MinimumElevationInMeter,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  
  7
  
    
MaximumElevationInMeter,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  
  8
  
    
DecimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  
  9
  
    
VerbatimLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  
  10
  
    
DecimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  
  11
  
    
VerbatimLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  
  12
  
    
LatestDateCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44


  		




  21
  13
  
    
CollectionCD,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12


  		




  22
  
  
    
CatalogNO,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  
  14
  
    
IdentifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  
  15
  
    
ScientificName,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  
  16
  
    
AuthorOfScientificName,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  
  17
  
    
InfraspecificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  
  18
  
    
SpecificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  
  19
  
    
Genus,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  
  20
  
    
Family,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  
  21
  
    
Collector,/verbatimcollectorname,,23


  		




  
  22
  
    
CatalogNO,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  23
  23
  
    
InstitutionCD,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,


  		




  24
  24
  
    
GBIFFamilyOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/first ** DwC doesn't fully support taxonomic redeterminations


  		




  25
  25
  
    
GBIFGenusOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/middle ** DwC doesn't fully support taxonomic redeterminations


  		












  

    
      inputs/NCU-NCSC/test/VegBIEN.specimens.xml.ref
    
  





  1
  1
  
    
<?xml version="1.0" ?>


  		




  2
  2
  
    
<VegBIEN>


  		




  3
  3
  
    
    <specimenreplicate id="0">


  		




  4
  
  
    
        <taxonoccurrence_id>


  		




  5
  
  
    
            <taxonoccurrence>


  		




  6
  
  
    
                <locationevent_id>


  		




  7
  
  
    
                    <locationevent>


  		




  8
  
  
    
                        <location_id>


  		




  9
  
  
    
                            <location>


  		




  10
  
  
    
                                <locationdetermination>


  		




  11
  
  
    
                                    <namedplace_id>


  		




  
  4
  
    
        <locationevent_id>


  		




  
  5
  
    
            <locationevent>


  		




  
  6
  
    
                <location_id>


  		




  
  7
  
    
                    <location>


  		




  
  8
  
    
                        <locationdetermination>


  		




  
  9
  
    
                            <namedplace_id>


  		




  
  10
  
    
                                <namedplace>


  		




  
  11
  
    
                                    <rank>county</rank>


  		




  
  12
  
    
                                    <placename>Lancaster</placename>


  		




  
  13
  
    
                                    <parent_id>


  		




  12
  14
  
    
                                        <namedplace>


  		




  13
  
  
    
                                            <rank>county</rank>


  		




  14
  
  
    
                                            <placename>Lancaster</placename>


  		




  
  15
  
    
                                            <rank>stateProvince</rank>


  		




  
  16
  
    
                                            <placename>Virginia</placename>


  		




  15
  17
  
    
                                            <parent_id>


  		




  16
  18
  
    
                                                <namedplace>


  		




  17
  
  
    
                                                    <rank>stateProvince</rank>


  		




  18
  
  
    
                                                    <placename>Virginia</placename>


  		




  19
  
  
    
                                                    <parent_id>


  		




  20
  
  
    
                                                        <namedplace>


  		




  21
  
  
    
                                                            <rank>country</rank>


  		




  22
  
  
    
                                                            <placename>USA</placename>


  		




  23
  
  
    
                                                        </namedplace>


  		




  24
  
  
    
                                                    </parent_id>


  		




  
  19
  
    
                                                    <rank>country</rank>


  		




  
  20
  
    
                                                    <placename>USA</placename>


  		




  25
  21
  
    
                                                </namedplace>


  		




  26
  22
  
    
                                            </parent_id>


  		




  27
  23
  
    
                                        </namedplace>


  		




  28
  
  
    
                                    </namedplace_id>


  		




  29
  
  
    
                                </locationdetermination>


  		




  30
  
  
    
                            </location>


  		




  31
  
  
    
                        </location_id>


  		




  32
  
  
    
                        <obsstartdate>1994-06-25</obsstartdate>


  		




  33
  
  
    
                        <obsenddate/>


  		




  34
  
  
    
                    </locationevent>


  		




  35
  
  
    
                </locationevent_id>


  		




  36
  
  
    
                <taxondetermination>


  		




  37
  
  
    
                    <isoriginal>true</isoriginal>


  		




  38
  
  
    
                    <iscurrent>true</iscurrent>


  		




  39
  
  
    
                    <role>identifier</role>


  		




  40
  
  
    
                    <plantconcept_id>


  		




  41
  
  
    
                        <plantconcept>


  		




  42
  
  
    
                            <plantname_id>


  		




  43
  
  
    
                                <plantname>


  		




  44
  
  
    
                                    <rank>binomial</rank>


  		




  45
  
  
    
                                    <plantname>Sanguinaria canadensis</plantname>


  		




  46
  
  
    
                                </plantname>


  		




  47
  
  
    
                            </plantname_id>


  		




  48
  
  
    
                        </plantconcept>


  		




  49
  
  
    
                    </plantconcept_id>


  		




  50
  
  
    
                </taxondetermination>


  		




  51
  
  
    
                <growthform/>


  		




  52
  
  
    
                <iscultivated>f</iscultivated>


  		




  53
  
  
    
                <isnative/>


  		




  54
  
  
    
            </taxonoccurrence>


  		




  55
  
  
    
        </taxonoccurrence_id>


  		




  
  24
  
    
                                    </parent_id>


  		




  
  25
  
    
                                </namedplace>


  		




  
  26
  
    
                            </namedplace_id>


  		




  
  27
  
    
                        </locationdetermination>


  		




  
  28
  
    
                    </location>


  		




  
  29
  
    
                </location_id>


  		




  
  30
  
    
                <obsstartdate>1994-06-25</obsstartdate>


  		




  
  31
  
    
                <obsenddate/>


  		




  
  32
  
    
            </locationevent>


  		




  
  33
  
    
        </locationevent_id>


  		




  56
  34
  
    
        <collectioncode_dwc>NCU</collectioncode_dwc>


  		




  
  35
  
    
        <taxondetermination>


  		




  
  36
  
    
            <isoriginal>true</isoriginal>


  		




  
  37
  
    
            <iscurrent>true</iscurrent>


  		




  
  38
  
    
            <role>identifier</role>


  		




  
  39
  
    
            <plantconcept_id>


  		




  
  40
  
    
                <plantconcept>


  		




  
  41
  
    
                    <plantname_id>


  		




  
  42
  
    
                        <plantname>


  		




  
  43
  
    
                            <rank>binomial</rank>


  		




  
  44
  
    
                            <plantname>Sanguinaria canadensis</plantname>


  		




  
  45
  
    
                        </plantname>


  		




  
  46
  
    
                    </plantname_id>


  		




  
  47
  
    
                </plantconcept>


  		




  
  48
  
    
            </plantconcept_id>


  		




  
  49
  
    
        </taxondetermination>


  		




  
  50
  
    
        <growthform/>


  		




  
  51
  
    
        <iscultivated>f</iscultivated>


  		




  
  52
  
    
        <isnative/>


  		




  57
  53
  
    
        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>


  		




  58
  54
  
    
        <catalognumber_dwc>NCU00090254</catalognumber_dwc>


  		




  59
  55
  
    
        <sourceaccessioncode>0</sourceaccessioncode>


  		




  60
  56
  
    
    </specimenreplicate>


  		




  61
  57
  
    
    <specimenreplicate id="1">


  		




  62
  
  
    
        <taxonoccurrence_id>


  		




  63
  
  
    
            <taxonoccurrence>


  		




  64
  
  
    
                <locationevent_id>


  		




  65
  
  
    
                    <locationevent>


  		




  66
  
  
    
                        <location_id>


  		




  67
  
  
    
                            <location>


  		




  68
  
  
    
                                <locationdetermination>


  		




  69
  
  
    
                                    <coordsaccuracy>1000</coordsaccuracy>


  		




  70
  
  
    
                                    <namedplace_id>


  		




  
  58
  
    
        <locationevent_id>


  		




  
  59
  
    
            <locationevent>


  		




  
  60
  
    
                <location_id>


  		




  
  61
  
    
                    <location>


  		




  
  62
  
    
                        <locationdetermination>


  		




  
  63
  
    
                            <coordsaccuracy>1000</coordsaccuracy>


  		




  
  64
  
    
                            <namedplace_id>


  		




  
  65
  
    
                                <namedplace>


  		




  
  66
  
    
                                    <rank>county</rank>


  		




  
  67
  
    
                                    <placename>Moore</placename>


  		




  
  68
  
    
                                    <parent_id>


  		




  71
  69
  
    
                                        <namedplace>


  		




  72
  
  
    
                                            <rank>county</rank>


  		




  73
  
  
    
                                            <placename>Moore</placename>


  		




  
  70
  
    
                                            <rank>stateProvince</rank>


  		




  
  71
  
    
                                            <placename>North Carolina</placename>


  		




  74
  72
  
    
                                            <parent_id>


  		




  75
  73
  
    
                                                <namedplace>


  		




  76
  
  
    
                                                    <rank>stateProvince</rank>


  		




  77
  
  
    
                                                    <placename>North Carolina</placename>


  		




  78
  
  
    
                                                    <parent_id>


  		




  79
  
  
    
                                                        <namedplace>


  		




  80
  
  
    
                                                            <rank>country</rank>


  		




  81
  
  
    
                                                            <placename>USA</placename>


  		




  82
  
  
    
                                                        </namedplace>


  		




  83
  
  
    
                                                    </parent_id>


  		




  
  74
  
    
                                                    <rank>country</rank>


  		




  
  75
  
    
                                                    <placename>USA</placename>


  		




  84
  76
  
    
                                                </namedplace>


  		




  85
  77
  
    
                                            </parent_id>


  		




  86
  78
  
    
                                        </namedplace>


  		




  87
  
  
    
                                    </namedplace_id>


  		




  88
  
  
    
                                    <latitude>35.1611111</latitude>


  		




  89
  
  
    
                                    <longitude>-79.3486111</longitude>


  		




  90
  
  
    
                                </locationdetermination>


  		




  91
  
  
    
                                <centerlatitude>35.1611111</centerlatitude>


  		




  92
  
  
    
                                <centerlongitude>-79.3486111</centerlongitude>


  		




  93
  
  
    
                            </location>


  		




  94
  
  
    
                        </location_id>


  		




  95
  
  
    
                        <obsstartdate>1965-05-08</obsstartdate>


  		




  96
  
  
    
                        <obsenddate/>


  		




  97
  
  
    
                    </locationevent>


  		




  98
  
  
    
                </locationevent_id>


  		




  99
  
  
    
                <taxondetermination>


  		




  100
  
  
    
                    <isoriginal>true</isoriginal>


  		




  101
  
  
    
                    <iscurrent>true</iscurrent>


  		




  102
  
  
    
                    <role>identifier</role>


  		




  103
  
  
    
                    <plantconcept_id>


  		




  104
  
  
    
                        <plantconcept>


  		




  105
  
  
    
                            <plantname_id>


  		




  106
  
  
    
                                <plantname>


  		




  107
  
  
    
                                    <rank>binomial</rank>


  		




  108
  
  
    
                                    <plantname>Senecio anonymus</plantname>


  		




  109
  
  
    
                                </plantname>


  		




  110
  
  
    
                            </plantname_id>


  		




  111
  
  
    
                        </plantconcept>


  		




  112
  
  
    
                    </plantconcept_id>


  		




  113
  
  
    
                </taxondetermination>


  		




  114
  
  
    
                <growthform/>


  		




  115
  
  
    
                <iscultivated>f</iscultivated>


  		




  116
  
  
    
                <isnative/>


  		




  117
  
  
    
            </taxonoccurrence>


  		




  118
  
  
    
        </taxonoccurrence_id>


  		




  
  79
  
    
                                    </parent_id>


  		




  
  80
  
    
                                </namedplace>


  		




  
  81
  
    
                            </namedplace_id>


  		




  
  82
  
    
                            <latitude>35.1611111</latitude>


  		




  
  83
  
    
                            <longitude>-79.3486111</longitude>


  		




  
  84
  
    
                        </locationdetermination>


  		




  
  85
  
    
                        <centerlatitude>35.1611111</centerlatitude>


  		




  
  86
  
    
                        <centerlongitude>-79.3486111</centerlongitude>


  		




  
  87
  
    
                    </location>


  		




  
  88
  
    
                </location_id>


  		




  
  89
  
    
                <obsstartdate>1965-05-08</obsstartdate>


  		




  
  90
  
    
                <obsenddate/>


  		




  
  91
  
    
            </locationevent>


  		




  
  92
  
    
        </locationevent_id>


  		




  119
  93
  
    
        <collectioncode_dwc>WEWO</collectioncode_dwc>


  		




  
  94
  
    
        <taxondetermination>


  		




  
  95
  
    
            <isoriginal>true</isoriginal>


  		




  
  96
  
    
            <iscurrent>true</iscurrent>


  		




  
  97
  
    
            <role>identifier</role>


  		




  
  98
  
    
            <plantconcept_id>


  		




  
  99
  
    
                <plantconcept>


  		




  
  100
  
    
                    <plantname_id>


  		




  
  101
  
    
                        <plantname>


  		




  
  102
  
    
                            <rank>binomial</rank>


  		




  
  103
  
    
                            <plantname>Senecio anonymus</plantname>


  		




  
  104
  
    
                        </plantname>


  		




  
  105
  
    
                    </plantname_id>


  		




  
  106
  
    
                </plantconcept>


  		




  
  107
  
    
            </plantconcept_id>


  		




  
  108
  
    
        </taxondetermination>


  		




  
  109
  
    
        <growthform/>


  		




  
  110
  
    
        <iscultivated>f</iscultivated>


  		




  
  111
  
    
        <isnative/>


  		




  120
  112
  
    
        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>


  		




  121
  113
  
    
        <sourceaccessioncode>1</sourceaccessioncode>


  		




  122
  114
  
    
    </specimenreplicate>


  		












  

    
      inputs/SpeciesLink/test/import.specimens.out.ref
    
  





  1
  
  
    
Inserted 36 new rows into database


  		




  
  1
  
    
Inserted 34 new rows into database


  		












  

    
      inputs/SpeciesLink/maps/VegBIEN.specimens.csv
    
  





  1
  1
  
    
"SpeciesLink[DwC,dwc_dwcore_,dwc_curatorial_,dwc_geospatial_,http__purl_org_,dwc_terms_,conceptual_darwin_2003_1_0_]",VegBIEN:/specimenreplicate,Comments,Order


  		




  2
  
  
    
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88


  		




  3
  
  
    
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89


  		




  4
  
  
    
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  5
  
  
    
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  6
  
  
    
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  7
  
  
    
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  8
  
  
    
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  9
  
  
    
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  10
  
  
    
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  11
  
  
    
Continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  12
  
  
    
ContinentOcean,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  13
  
  
    
continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  14
  
  
    
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  15
  
  
    
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  16
  
  
    
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  17
  
  
    
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  18
  
  
    
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  19
  
  
    
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  20
  
  
    
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  21
  
  
    
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  22
  
  
    
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  23
  
  
    
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  24
  
  
    
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  25
  
  
    
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  26
  
  
    
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  27
  
  
    
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  28
  
  
    
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  29
  
  
    
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  30
  
  
    
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  31
  
  
    
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  32
  
  
    
MaximumDepth,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  33
  
  
    
MaximumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  34
  
  
    
maximumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  35
  
  
    
MinimumDepth,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  36
  
  
    
MinimumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  37
  
  
    
minimumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  38
  
  
    
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44


  		




  39
  
  
    
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44


  		




  40
  
  
    
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44


  		




  41
  
  
    
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120


  		




  42
  
  
    
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120


  		




  43
  
  
    
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120


  		




  44
  
  
    
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120


  		




  45
  
  
    
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  46
  
  
    
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  47
  
  
    
ScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  48
  
  
    
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  49
  
  
    
AuthorYearOfScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  50
  
  
    
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","`union` would otherwise remove this input name because it's been mapped to (renamed) above; Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  51
  
  
    
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  52
  
  
    
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  53
  
  
    
Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  54
  
  
    
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  55
  
  
    
Species,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  56
  
  
    
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  57
  
  
    
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  58
  
  
    
Genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  59
  
  
    
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  60
  
  
    
Family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  61
  
  
    
family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  62
  
  
    
Order,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145


  		




  63
  
  
    
order,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145


  		




  64
  
  
    
Class,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144


  		




  65
  
  
    
class,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144


  		




  66
  
  
    
Phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143


  		




  67
  
  
    
phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143


  		




  68
  
  
    
Kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  69
  
  
    
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  70
  
  
    
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  71
  
  
    
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  
  2
  
    
coordinateUncertaintyInMeters,/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88


  		




  
  3
  
    
CoordinatePrecision,/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89


  		




  
  4
  
    
BoundingBox,/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  
  5
  
    
County,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  
  6
  
    
county,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  
  7
  
    
StateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  
  8
  
    
stateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  
  9
  
    
Country,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  
  10
  
    
country,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  
  11
  
    
Continent,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  
  12
  
    
ContinentOcean,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  
  13
  
    
continent,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  
  14
  
    
Locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  
  15
  
    
locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  
  16
  
    
MinimumElevation,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  
  17
  
    
MinimumElevationInMeters,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  
  18
  
    
minimumElevationInMeters,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  
  19
  
    
MaximumElevation,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  
  20
  
    
MaximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  
  21
  
    
maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  
  22
  
    
DecimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  
  23
  
    
Latitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  
  24
  
    
VerbatimLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  
  25
  
    
decimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  
  26
  
    
verbatimLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  
  27
  
    
DecimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  
  28
  
    
Longitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  
  29
  
    
VerbatimLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  
  30
  
    
decimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  
  31
  
    
verbatimLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  
  32
  
    
MaximumDepth,"/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  
  33
  
    
MaximumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  
  34
  
    
maximumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  
  35
  
    
MinimumDepth,"/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  
  36
  
    
MinimumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  
  37
  
    
minimumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  
  38
  
    
DayCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44


  		




  
  39
  
    
MonthCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44


  		




  
  40
  
    
YearCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44


  		




  72
  41
  
    
CollectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12


  		




  73
  42
  
    
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12


  		




  74
  43
  
    
Sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26


  		




  75
  44
  
    
sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26


  		




  76
  45
  
    
Notes,/description/_merge/1,,


  		




  77
  46
  
    
Remarks,/description/_merge/2,,158


  		




  78
  
  
    
CatalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  79
  
  
    
catalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  80
  
  
    
GlobalUniqueIdentifier,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  
  47
  
    
DayIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120


  		




  
  48
  
    
MonthIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120


  		




  
  49
  
    
YearIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120


  		




  
  50
  
    
dateIdentified,/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120


  		




  
  51
  
    
IdentifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  
  52
  
    
identifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  
  53
  
    
ScientificName,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  
  54
  
    
scientificName,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  
  55
  
    
AuthorYearOfScientificName,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  
  56
  
    
ScientificNameAuthor,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","`union` would otherwise remove this input name because it's been mapped to (renamed) above; Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  
  57
  
    
scientificNameAuthorship,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  
  58
  
    
InfraspecificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  
  59
  
    
Subspecies,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  
  60
  
    
infraspecificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  
  61
  
    
Species,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  
  62
  
    
SpecificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  
  63
  
    
specificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  
  64
  
    
Genus,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  
  65
  
    
genus,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  
  66
  
    
Family,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  
  67
  
    
family,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  
  68
  
    
Order,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145


  		




  
  69
  
    
order,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145


  		




  
  70
  
    
Class,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144


  		




  
  71
  
    
class,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144


  		




  
  72
  
    
Phylum,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143


  		




  
  73
  
    
phylum,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143


  		




  
  74
  
    
Kingdom,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  
  75
  
    
kingdom,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  
  76
  
    
Collector,/verbatimcollectorname,,23


  		




  
  77
  
    
recordedBy,/verbatimcollectorname,,23


  		




  
  78
  
    
CatalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  
  79
  
    
catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  81
  80
  
    
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/1,,22


  		




  82
  81
  
    
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/2,,22


  		




  83
  82
  
    
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9


  		




  ......




  85
  84
  
    
fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53


  		




  86
  85
  
    
InstitutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,


  		




  87
  86
  
    
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,


  		




  
  87
  
    
GlobalUniqueIdentifier,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  88
  88
  
    
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord ** 


  		




  89
  89
  
    
DateLastModified,,** No non-empty join mapping for DateLastModified ** 


  		




  90
  90
  
    
DayOfYear,,** No non-empty join mapping for JulianDay ** 


  		












  

    
      inputs/MO/maps/VegBIEN.specimens.csv
    
  





  1
  1
  
    
MO[DwC],VegBIEN:/specimenreplicate,Comments,Order


  		




  2
  
  
    
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  3
  
  
    
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  4
  
  
    
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  5
  
  
    
ContinentOcean,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  6
  
  
    
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  7
  
  
    
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  8
  
  
    
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  9
  
  
    
latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  10
  
  
    
longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  11
  
  
    
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44


  		




  12
  
  
    
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44


  		




  13
  
  
    
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44


  		




  14
  
  
    
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  15
  
  
    
ScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  16
  
  
    
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  17
  
  
    
Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  18
  
  
    
species,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  19
  
  
    
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  20
  
  
    
family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  21
  
  
    
Kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  22
  
  
    
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  
  2
  
    
County,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  
  3
  
    
StateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  
  4
  
    
Country,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  
  5
  
    
ContinentOcean,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  
  6
  
    
Locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  
  7
  
    
MinimumElevation,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  
  8
  
    
MaximumElevation,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  
  9
  
    
latitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  
  10
  
    
longitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  
  11
  
    
DayCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44


  		




  
  12
  
    
MonthCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44


  		




  
  13
  
    
YearCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44


  		




  23
  14
  
    
CollectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12


  		




  24
  15
  
    
convertednotes,/description/_merge/1,,


  		




  25
  
  
    
CatalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  
  16
  
    
IdentifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  
  17
  
    
ScientificName,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  
  18
  
    
ScientificNameAuthor,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  
  19
  
    
Subspecies,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  
  20
  
    
species,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  
  21
  
    
genus,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  
  22
  
    
family,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  
  23
  
    
Kingdom,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  
  24
  
    
Collector,/verbatimcollectorname,,23


  		




  
  25
  
    
CatalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  26
  26
  
    
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/1,,22


  		




  27
  27
  
    
InstitutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,


  		




  28
  28
  
    
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord ** 


  		












  

    
      inputs/QMOR/maps/VegBIEN.specimens.csv
    
  





  1
  1
  
    
QMOR[DwC],VegBIEN:/specimenreplicate,Comments,Order


  		




  2
  
  
    
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88


  		




  3
  
  
    
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  4
  
  
    
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  5
  
  
    
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  6
  
  
    
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  7
  
  
    
continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  8
  
  
    
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  9
  
  
    
habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52


  		




  10
  
  
    
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  11
  
  
    
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  12
  
  
    
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  13
  
  
    
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  14
  
  
    
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  15
  
  
    
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  16
  
  
    
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44


  		




  17
  
  
    
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120


  		




  18
  
  
    
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  19
  
  
    
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  20
  
  
    
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  21
  
  
    
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  22
  
  
    
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  23
  
  
    
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  24
  
  
    
family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  25
  
  
    
order,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145


  		




  26
  
  
    
class,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144


  		




  27
  
  
    
phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143


  		




  28
  
  
    
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  29
  
  
    
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  
  2
  
    
coordinateUncertaintyInMeters,/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88


  		




  
  3
  
    
footprintWKT,/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  
  4
  
    
county,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  
  5
  
    
stateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  
  6
  
    
country,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  
  7
  
    
continent,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  
  8
  
    
locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  
  9
  
    
habitat,"/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52


  		




  
  10
  
    
minimumElevationInMeters,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  
  11
  
    
maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  
  12
  
    
decimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  
  13
  
    
verbatimLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  
  14
  
    
decimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  
  15
  
    
verbatimLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  
  16
  
    
eventDate,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44


  		




  30
  17
  
    
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12


  		




  31
  18
  
    
sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26


  		




  32
  
  
    
catalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  33
  
  
    
id,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  
  19
  
    
dateIdentified,/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120


  		




  
  20
  
    
identifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  
  21
  
    
scientificName,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  
  22
  
    
scientificNameAuthorship,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  
  23
  
    
infraspecificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  
  24
  
    
specificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  
  25
  
    
genus,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  
  26
  
    
family,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  
  27
  
    
order,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145


  		




  
  28
  
    
class,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144


  		




  
  29
  
    
phylum,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143


  		




  
  30
  
    
kingdom,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  
  31
  
    
recordedBy,/verbatimcollectorname,,23


  		




  
  32
  
    
catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  34
  33
  
    
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9


  		




  35
  34
  
    
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8


  		




  36
  35
  
    
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,


  		




  
  36
  
    
id,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  37
  37
  
    
acceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage ** 


  		




  38
  38
  
    
basisOfRecord,,** No non-empty join mapping for basisOfRecord ** 


  		




  39
  39
  
    
behavior,,** No non-empty join mapping for behavior ** 


  		












  

    
      mappings/DwC.cs-VegBIEN.specimens.csv
    
  





  1
  1
  
    
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",VegBIEN:/specimenreplicate,Comments,Order


  		




  2
  
  
    
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88


  		




  3
  
  
    
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89


  		




  4
  
  
    
boundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  5
  
  
    
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  6
  
  
    
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  7
  
  
    
state,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  8
  
  
    
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  9
  
  
    
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  10
  
  
    
continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  11
  
  
    
continentOcean,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  12
  
  
    
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  13
  
  
    
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69


  		




  14
  
  
    
habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52


  		




  15
  
  
    
minimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  16
  
  
    
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  17
  
  
    
maximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  18
  
  
    
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  19
  
  
    
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  20
  
  
    
latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  21
  
  
    
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  22
  
  
    
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  23
  
  
    
longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  24
  
  
    
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  25
  
  
    
maximumDepth,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  26
  
  
    
maximumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  27
  
  
    
minimumDepth,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  28
  
  
    
minimumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  29
  
  
    
eventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44


  		




  30
  
  
    
dayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44


  		




  31
  
  
    
monthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44


  		




  32
  
  
    
yearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44


  		




  33
  
  
    
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44


  		




  34
  
  
    
collectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44


  		




  35
  
  
    
dateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120


  		




  36
  
  
    
dayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120


  		




  37
  
  
    
monthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120


  		




  38
  
  
    
yearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120


  		




  39
  
  
    
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120


  		




  40
  
  
    
identifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120


  		




  41
  
  
    
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  42
  
  
    
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  43
  
  
    
scientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  44
  
  
    
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  45
  
  
    
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  46
  
  
    
subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  47
  
  
    
species,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  48
  
  
    
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  49
  
  
    
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  50
  
  
    
family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  51
  
  
    
order,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145


  		




  52
  
  
    
class,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144


  		




  53
  
  
    
phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143


  		




  54
  
  
    
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  55
  
  
    
collector,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  56
  
  
    
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  57
  
  
    
establishmentMeans,"/*_id/taxonoccurrence/{growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=],iscultivated/_map:[cultivated=t,wild=f,*=],isnative/_map:[native=t,exotic=f,*=]}/value",,30


  		




  
  2
  
    
coordinateUncertaintyInMeters,/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88


  		




  
  3
  
    
coordinatePrecision,/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89


  		




  
  4
  
    
boundingBox,/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  
  5
  
    
footprintWKT,/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  
  6
  
    
county,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  
  7
  
    
state,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  
  8
  
    
stateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  
  9
  
    
country,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  
  10
  
    
continent,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  
  11
  
    
continentOcean,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  
  12
  
    
locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		




  
  13
  
    
verbatimLocality,/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69


  		




  
  14
  
    
habitat,"/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52


  		




  
  15
  
    
minimumElevation,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  
  16
  
    
minimumElevationInMeters,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71


  		




  
  17
  
    
maximumElevation,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  
  18
  
    
maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72


  		




  
  19
  
    
decimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85


  		




  
  20
  
    
latitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  
  21
  
    
verbatimLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81


  		




  
  22
  
    
decimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86


  		




  
  23
  
    
longitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  
  24
  
    
verbatimLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82


  		




  
  25
  
    
maximumDepth,"/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  
  26
  
    
maximumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75


  		




  
  27
  
    
minimumDepth,"/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  
  28
  
    
minimumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74


  		




  
  29
  
    
eventDate/_alt,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44


  		




  
  30
  
    
dayCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44


  		




  
  31
  
    
monthCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44


  		




  
  32
  
    
yearCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44


  		




  
  33
  
    
eventDate,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44


  		




  
  34
  
    
collectedDate,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44


  		




  58
  35
  
    
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12


  		




  59
  36
  
    
sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26


  		




  60
  37
  
    
fieldNotes,/description/_merge/1,,


  		




  61
  38
  
    
notes,/description/_merge/1,,


  		




  62
  39
  
    
remarks,/description/_merge/2,,158


  		




  63
  40
  
    
taxonRemarks,/description/_merge/2,,158


  		




  64
  
  
    
catalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  65
  
  
    
globalUniqueIdentifier,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  66
  
  
    
id,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  67
  
  
    
occurrenceID,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  
  41
  
    
dateIdentified/_alt,/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120


  		




  
  42
  
    
dayIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120


  		




  
  43
  
    
monthIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120


  		




  
  44
  
    
yearIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120


  		




  
  45
  
    
dateIdentified,/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120


  		




  
  46
  
    
identifiedDate,/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120


  		




  
  47
  
    
identifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  
  48
  
    
scientificName,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  
  49
  
    
scientificNameAuthor,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  
  50
  
    
scientificNameAuthorship,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  
  51
  
    
infraspecificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  
  52
  
    
subspecies,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150


  		




  
  53
  
    
species,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  
  54
  
    
specificEpithet,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149


  		




  
  55
  
    
genus,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147


  		




  
  56
  
    
family,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146


  		




  
  57
  
    
order,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145


  		




  
  58
  
    
class,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144


  		




  
  59
  
    
phylum,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143


  		




  
  60
  
    
kingdom,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142


  		




  
  61
  
    
collector,/verbatimcollectorname,,23


  		




  
  62
  
    
recordedBy,/verbatimcollectorname,,23


  		




  
  63
  
    
establishmentMeans,"/{growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=],iscultivated/_map:[cultivated=t,wild=f,*=],isnative/_map:[native=t,exotic=f,*=]}/value",,30


  		




  
  64
  
    
catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20


  		




  68
  65
  
    
collectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/1,,22


  		




  69
  66
  
    
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/2,,22


  		




  70
  67
  
    
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9


  		




  71
  68
  
    
fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53


  		




  72
  69
  
    
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8


  		




  73
  70
  
    
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,


  		




  
  71
  
    
globalUniqueIdentifier,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  
  72
  
    
id,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  
  73
  
    
occurrenceID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19


  		




  74
  74
  
    
acceptedNameUsage,,,135


  		




  75
  75
  
    
acceptedNameUsageID,,,128


  		




  76
  76
  
    
accessRights,,** No non-empty join mapping for dcterms:accessRights ** Versions without namespace


  		












  

    
      mappings/DwC-VegBIEN.specimens.csv
    
  





  1
  1
  
    
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",VegBIEN:/specimenreplicate,Comments,Order


  		




  2
  
  
    
CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88


  		




  3
  
  
    
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88


  		




  4
  
  
    
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89


  		




  5
  
  
    
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89


  		




  6
  
  
    
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  7
  
  
    
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  8
  
  
    
boundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  9
  
  
    
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91


  		




  10
  
  
    
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  11
  
  
    
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66


  		




  12
  
  
    
State,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  13
  
  
    
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  14
  
  
    
state,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  15
  
  
    
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65


  		




  16
  
  
    
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  17
  
  
    
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63


  		




  18
  
  
    
Continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  19
  
  
    
ContinentOcean,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  20
  
  
    
continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  21
  
  
    
continentOcean,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59


  		




  22
  
  
    
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68


  		








... This diff was truncated because it exceeds the maximum size that can be displayed.



Also available in:  Unified diff