Project

General

Profile

« Previous | Next » 

Revision 10658

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: aggregate_observation: renamed to individual_count for clarity. added count field. renamed traits to aggregating_traits since these are used in uniquely identifying the individual_count. taxon_presence: added cover_percent.

View differences:

schemas/VegCore/VegCore.pg.sql
26 26 
USE "VegCore";
27 27 

  		




  28
  28
  
    
--


  		




  29
  
  
    
-- Table structure for table "aggregate_observation"


  		




  30
  
  
    
--


  		




  31
  
  
    

  		




  32
  
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




  33
  
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  34
  
  
    
CREATE TABLE "aggregate_observation" (


  		




  35
  
  
    
  "id" text NOT NULL,


  		




  36
  
  
    
  "taxon" text NOT NULL,


  		




  37
  
  
    
  "size_class" text DEFAULT NULL,


  		




  38
  
  
    
  "traits" hstore DEFAULT NULL,


  		




  39
  
  
    
  PRIMARY KEY ("id"),


  		




  40
  
  
    
  /*KEY "fk_aggregate_observation_taxon_presence1_idx" ("taxon")*/CHECK (true),


  		




  41
  
  
    
  /*KEY "fk_aggregate_observation_size_class1_idx" ("size_class")*/CHECK (true),


  		




  42
  
  
    
  /*CONSTRAINT "fk_aggregate_observation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  43
  
  
    
  /*CONSTRAINT "fk_aggregate_observation_size_class1" FOREIGN KEY ("size_class") REFERENCES "size_class" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  44
  
  
    
  /*CONSTRAINT "fk_aggregate_observation_taxon_presence1" FOREIGN KEY ("taxon") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  45
  
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= stemCount.VegBank.vegpath.org'*/;


  		




  46
  
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  47
  
  
    

  		




  48
  
  
    
--


  		




  49
  
  
    
-- Dumping data for table "aggregate_observation"


  		




  50
  
  
    
--


  		




  51
  
  
    

  		




  52
  
  
    
/*!40000 ALTER TABLE "aggregate_observation" DISABLE KEYS */;


  		




  53
  
  
    
/*!40000 ALTER TABLE "aggregate_observation" ENABLE KEYS */;


  		




  54
  
  
    

  		




  55
  
  
    
--


  		




  56
  29
  
    
-- Table structure for table "base_class"


  		




  57
  30
  
    
--


  		




  58
  31
  
    

  		




  ......




  352
  325
  
    
/*!40000 ALTER TABLE "individual" ENABLE KEYS */;


  		




  353
  326
  
    

  		




  354
  327
  
    
--


  		




  
  328
  
    
-- Table structure for table "individual_count"


  		




  
  329
  
    
--


  		




  
  330
  
    

  		




  
  331
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




  
  332
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  
  333
  
    
CREATE TABLE "individual_count" (


  		




  
  334
  
    
  "id" text NOT NULL,


  		




  
  335
  
    
  "taxon" text NOT NULL,


  		




  
  336
  
    
  "size_class" text DEFAULT NULL,


  		




  
  337
  
    
  "aggregating_traits" hstore DEFAULT NULL,


  		




  
  338
  
    
  "count" integer DEFAULT NULL,


  		




  
  339
  
    
  PRIMARY KEY ("id"),


  		




  
  340
  
    
  /*KEY "fk_aggregate_observation_taxon_presence1_idx" ("taxon")*/CHECK (true),


  		




  
  341
  
    
  /*KEY "fk_aggregate_observation_size_class1_idx" ("size_class")*/CHECK (true),


  		




  
  342
  
    
  /*CONSTRAINT "fk_aggregate_observation_size_class1" FOREIGN KEY ("size_class") REFERENCES "size_class" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  343
  
    
  /*CONSTRAINT "fk_aggregate_observation_taxon_presence1" FOREIGN KEY ("taxon") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  344
  
    
  /*CONSTRAINT "fk_aggregate_observation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  345
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= stemCount.VegBank.vegpath.org'*/;


  		




  
  346
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  347
  
    

  		




  
  348
  
    
--


  		




  
  349
  
    
-- Dumping data for table "individual_count"


  		




  
  350
  
    
--


  		




  
  351
  
    

  		




  
  352
  
    
/*!40000 ALTER TABLE "individual_count" DISABLE KEYS */;


  		




  
  353
  
    
/*!40000 ALTER TABLE "individual_count" ENABLE KEYS */;


  		




  
  354
  
    

  		




  
  355
  
    
--


  		




  355
  356
  
    
-- Table structure for table "individual_observation"


  		




  356
  357
  
    
--


  		




  357
  358
  
    

  		




  ......




  1269
  1270
  
    
CREATE TABLE "taxon_presence" (


  		




  1270
  1271
  
    
  "id" text NOT NULL,


  		




  1271
  1272
  
    
  "occurrence_status" text DEFAULT NULL,


  		




  
  1273
  
    
  "cover_percent" double precision DEFAULT NULL,


  		




  1272
  1274
  
    
  "traits" hstore DEFAULT NULL,


  		




  1273
  1275
  
    
  PRIMARY KEY ("id"),


  		




  1274
  1276
  
    
  /*CONSTRAINT "fk_taxon_presence_taxon_determination1" FOREIGN KEY ("id") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		












  

    
      schemas/VegCore/document.mwb.xml
    
  





  2388
  2388
  
    
                      <value type="int" key="scale">-1</value>


  		




  2389
  2389
  
    
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>


  		




  2390
  2390
  
    
                      <value type="string" key="comment"></value>


  		




  2391
  
  
    
                      <value type="string" key="name">traits</value>


  		




  
  2391
  
    
                      <value type="string" key="name">aggregating_traits</value>


  		




  2392
  2392
  
    
                      <value type="string" key="oldName">traits</value>


  		




  2393
  2393
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>


  		




  2394
  2394
  
    
                    </value>


  		




  
  2395
  
    
                    <value type="object" struct-name="db.mysql.Column" id="a882f398-0117-11e3-b872-080027bcf912" struct-checksum="0x783b5183">


  		




  
  2396
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  
  2397
  
    
                      <value type="string" key="characterSetName"></value>


  		




  
  2398
  
    
                      <value _ptr_="0xd1164e0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>


  		




  
  2399
  
    
                      <value type="string" key="collationName"></value>


  		




  
  2400
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  
  2401
  
    
                      <value type="string" key="defaultValue"></value>


  		




  
  2402
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  
  2403
  
    
                      <value _ptr_="0xb555820" type="list" content-type="string" key="flags"/>


  		




  
  2404
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  
  2405
  
    
                      <value type="int" key="length">-1</value>


  		




  
  2406
  
    
                      <value type="int" key="precision">-1</value>


  		




  
  2407
  
    
                      <value type="int" key="scale">-1</value>


  		




  
  2408
  
    
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.int</link>


  		




  
  2409
  
    
                      <value type="string" key="comment"></value>


  		




  
  2410
  
    
                      <value type="string" key="name">count</value>


  		




  
  2411
  
    
                      <value type="string" key="oldName"></value>


  		




  
  2412
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  2413
  
    
                    </value>


  		




  2395
  2414
  
    
                  </value>


  		




  2396
  2415
  
    
                  <value type="string" key="connectionString"></value>


  		




  2397
  2416
  
    
                  <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  ......




  2562
  2581
  
    
                  <value type="int" key="commentedOut">0</value>


  		




  2563
  2582
  
    
                  <value type="string" key="createDate">2013-04-16 14:58</value>


  		




  2564
  2583
  
    
                  <value _ptr_="0xbd769e0" type="dict" key="customData"/>


  		




  2565
  
  
    
                  <value type="string" key="lastChangeDate">2013-08-09 10:04</value>


  		




  
  2584
  
    
                  <value type="string" key="lastChangeDate">2013-08-09 10:36</value>


  		




  2566
  2585
  
    
                  <value type="int" key="modelOnly">0</value>


  		




  2567
  
  
    
                  <value type="string" key="name">aggregate_observation</value>


  		




  
  2586
  
    
                  <value type="string" key="name">individual_count</value>


  		




  2568
  2587
  
    
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>


  		




  2569
  2588
  
    
                  <value type="string" key="temp_sql"></value>


  		




  2570
  2589
  
    
                  <value type="string" key="comment">= stemCount.VegBank.vegpath.org</value>


  		




  ......




  2612
  2631
  
    
                      <value type="string" key="oldName">occurrence_status</value>


  		




  2613
  2632
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>


  		




  2614
  2633
  
    
                    </value>


  		




  
  2634
  
    
                    <value type="object" struct-name="db.mysql.Column" id="65752312-0119-11e3-b872-080027bcf912" struct-checksum="0x783b5183">


  		




  
  2635
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  
  2636
  
    
                      <value type="string" key="characterSetName"></value>


  		




  
  2637
  
    
                      <value _ptr_="0xce4b9d0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>


  		




  
  2638
  
    
                      <value type="string" key="collationName"></value>


  		




  
  2639
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  
  2640
  
    
                      <value type="string" key="defaultValue"></value>


  		




  
  2641
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  
  2642
  
    
                      <value _ptr_="0xd03e2a0" type="list" content-type="string" key="flags"/>


  		




  
  2643
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  
  2644
  
    
                      <value type="int" key="length">-1</value>


  		




  
  2645
  
    
                      <value type="int" key="precision">-1</value>


  		




  
  2646
  
    
                      <value type="int" key="scale">-1</value>


  		




  
  2647
  
    
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.double</link>


  		




  
  2648
  
    
                      <value type="string" key="comment"></value>


  		




  
  2649
  
    
                      <value type="string" key="name">cover_percent</value>


  		




  
  2650
  
    
                      <value type="string" key="oldName"></value>


  		




  
  2651
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  2652
  
    
                    </value>


  		




  2615
  2653
  
    
                    <value type="object" struct-name="db.mysql.Column" id="d72de448-ad19-11e2-9d85-080027bcf912" struct-checksum="0x783b5183">


  		




  2616
  2654
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  2617
  2655
  
    
                      <value type="string" key="characterSetName"></value>


  		




  ......




  2713
  2751
  
    
                  <value type="int" key="commentedOut">0</value>


  		




  2714
  2752
  
    
                  <value type="string" key="createDate">2013-04-16 14:58</value>


  		




  2715
  2753
  
    
                  <value _ptr_="0xbd7a5e0" type="dict" key="customData"/>


  		




  2716
  
  
    
                  <value type="string" key="lastChangeDate">2013-08-09 10:07</value>


  		




  
  2754
  
    
                  <value type="string" key="lastChangeDate">2013-08-09 10:34</value>


  		




  2717
  2755
  
    
                  <value type="int" key="modelOnly">0</value>


  		




  2718
  2756
  
    
                  <value type="string" key="name">taxon_presence</value>


  		




  2719
  2757
  
    
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>


  		




  ......




  13752
  13790
  
    
                <value type="real" key="extraCaptionXOffs">0.e+00</value>


  		




  13753
  13791
  
    
                <value type="real" key="extraCaptionYOffs">0.e+00</value>


  		




  13754
  13792
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">d2081100-f959-11e2-8597-080027bcf912</link>


  		




  13755
  
  
    
                <value type="real" key="middleSegmentOffset">-7.830631616688742724363692104816436767578125e+01</value>


  		




  
  13793
  
    
                <value type="real" key="middleSegmentOffset">-5.1883460168963893011095933616161346435546875e+01</value>


  		




  13756
  13794
  
    
                <value type="real" key="startCaptionXOffs">0.e+00</value>


  		




  13757
  13795
  
    
                <value type="real" key="startCaptionYOffs">0.e+00</value>


  		




  13758
  13796
  
    
                <value type="int" key="drawSplit">0</value>


  		




  ......




  13773
  13811
  
    
                <value type="real" key="extraCaptionXOffs">0.e+00</value>


  		




  13774
  13812
  
    
                <value type="real" key="extraCaptionYOffs">0.e+00</value>


  		




  13775
  13813
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">d5a68396-f959-11e2-8597-080027bcf912</link>


  		




  13776
  
  
    
                <value type="real" key="middleSegmentOffset">6.21546658059154424336156807839870452880859375e+01</value>


  		




  
  13814
  
    
                <value type="real" key="middleSegmentOffset">1.53908368400834660860709846019744873046875e+00</value>


  		




  13777
  13815
  
    
                <value type="real" key="startCaptionXOffs">0.e+00</value>


  		




  13778
  13816
  
    
                <value type="real" key="startCaptionYOffs">0.e+00</value>


  		




  13779
  13817
  
    
                <value type="int" key="drawSplit">0</value>


  		




  ......




  14758
  14796
  
    
                <value type="int" key="triggersExpanded">0</value>


  		




  14759
  14797
  
    
                <value type="string" key="color">#FFFF00</value>


  		




  14760
  14798
  
    
                <value type="int" key="expanded">1</value>


  		




  14761
  
  
    
                <value type="real" key="height">1.e+02</value>


  		




  
  14799
  
    
                <value type="real" key="height">1.23e+02</value>


  		




  14762
  14800
  
    
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>


  		




  14763
  
  
    
                <value type="real" key="left">1.255e+03</value>


  		




  
  14801
  
    
                <value type="real" key="left">1.216e+03</value>


  		




  14764
  14802
  
    
                <value type="int" key="locked">0</value>


  		




  14765
  14803
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14766
  14804
  
    
                <value type="real" key="top">6.09e+02</value>


  		




  ......




  14798
  14836
  
    
                <value type="int" key="triggersExpanded">0</value>


  		




  14799
  14837
  
    
                <value type="string" key="color">#FFFF00</value>


  		




  14800
  14838
  
    
                <value type="int" key="expanded">1</value>


  		




  14801
  
  
    
                <value type="real" key="height">1.23e+02</value>


  		




  
  14839
  
    
                <value type="real" key="height">1.46e+02</value>


  		




  14802
  14840
  
    
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>


  		




  14803
  
  
    
                <value type="real" key="left">1.026e+03</value>


  		




  
  14841
  
    
                <value type="real" key="left">1.028e+03</value>


  		




  14804
  14842
  
    
                <value type="int" key="locked">0</value>


  		




  14805
  14843
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14806
  
  
    
                <value type="real" key="top">6.69e+02</value>


  		




  14807
  
  
    
                <value type="real" key="width">1.82e+02</value>


  		




  
  14844
  
    
                <value type="real" key="top">6.63e+02</value>


  		




  
  14845
  
    
                <value type="real" key="width">1.45e+02</value>


  		




  14808
  14846
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  14809
  14847
  
    
                <value type="int" key="visible">1</value>


  		




  14810
  
  
    
                <value type="string" key="name">aggregate_observation</value>


  		




  
  14848
  
    
                <value type="string" key="name">individual_count</value>


  		




  14811
  14849
  
    
              </value>


  		




  14812
  14850
  
    
              <value type="object" struct-name="workbench.physical.TableFigure" id="793D3016-8986-43EC-A4BD-1926D93F12C5" struct-checksum="0x3b14eccb">


  		




  14813
  14851
  
    
                <value type="int" key="columnsExpanded">1</value>


  		




  ......




  15606
  15644
  
    
                <value type="int" key="expanded">1</value>


  		




  15607
  15645
  
    
                <value type="real" key="height">5.4e+01</value>


  		




  15608
  15646
  
    
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>


  		




  15609
  
  
    
                <value type="real" key="left">1.1e+03</value>


  		




  
  15647
  
    
                <value type="real" key="left">1.107e+03</value>


  		




  15610
  15648
  
    
                <value type="int" key="locked">0</value>


  		




  15611
  15649
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15612
  
  
    
                <value type="real" key="top">5.8e+02</value>


  		




  
  15650
  
    
                <value type="real" key="top">5.46e+02</value>


  		




  15613
  15651
  
    
                <value type="real" key="width">1.36e+02</value>


  		




  15614
  15652
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  15615
  15653
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15868
  15906
  
    
                <value type="real" key="left">8.6e+02</value>


  		




  15869
  15907
  
    
                <value type="int" key="locked">0</value>


  		




  15870
  15908
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15871
  
  
    
                <value type="real" key="top">6.89e+02</value>


  		




  
  15909
  
    
                <value type="real" key="top">6.99e+02</value>


  		




  15872
  15910
  
    
                <value type="real" key="width">1.09e+02</value>


  		




  15873
  15911
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  15874
  15912
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15888
  15926
  
    
                <value type="real" key="left">1.393e+03</value>


  		




  15889
  15927
  
    
                <value type="int" key="locked">0</value>


  		




  15890
  15928
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15891
  
  
    
                <value type="real" key="top">7.5e+02</value>


  		




  
  15929
  
    
                <value type="real" key="top">7.25e+02</value>


  		




  15892
  15930
  
    
                <value type="real" key="width">1.84e+02</value>


  		




  15893
  15931
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  15894
  15932
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  16033
  16071
  
    
              <value type="int" key="visible">1</value>


  		




  16034
  16072
  
    
              <value type="string" key="name"></value>


  		




  16035
  16073
  
    
            </value>


  		




  16036
  
  
    
            <value _ptr_="0xbe03ea8" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>


  		




  
  16074
  
    
            <value _ptr_="0xbe03ea8" type="list" content-type="object" content-struct-name="model.Object" key="selection">


  		




  
  16075
  
    
              <link type="object">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>


  		




  
  16076
  
    
              <link type="object">7afee050-0075-11e3-906b-080027bcf912</link>


  		




  
  16077
  
    
            </value>


  		




  16037
  16078
  
    
            <value type="int" key="updateBlocked">0</value>


  		




  16038
  16079
  
    
            <value type="real" key="width">1.6215e+03</value>


  		




  16039
  16080
  
    
            <value type="real" key="x">0.e+00</value>


  		




  ......




  16045
  16086
  
    
        <value _ptr_="0xbd65310" type="list" content-type="object" content-struct-name="GrtStoredNote" key="notes"/>


  		




  16046
  16087
  
    
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>


  		




  16047
  16088
  
    
        <value _ptr_="0xbd65340" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>


  		




  16048
  
  
    
        <value _ptr_="0xb44ccc8" type="dict" key="syncProfiles"/>


  		




  
  16089
  
    
        <value _ptr_="0xb44ccc8" type="dict" key="syncProfiles">


  		




  
  16090
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="4432776a-0117-11e3-b872-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  
  16091
  
    
            <value _ptr_="0xc85ca60" type="dict" key="lastKnownDBNames">


  		




  
  16092
  
    
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>


  		




  
  16093
  
    
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>


  		




  
  16094
  
    
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>


  		




  
  16095
  
    
              <value type="string" key="04149c40-fa90-11e2-83d9-080027bcf912">official_name</value>


  		




  
  16096
  
    
              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>


  		




  
  16097
  
    
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>


  		




  
  16098
  
    
              <value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value>


  		




  
  16099
  
    
              <value type="string" key="049e0370-a91b-11e2-bdec-080027bcf912">PRIMARY</value>


  		




  
  16100
  
    
              <value type="string" key="08481eda-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>


  		




  
  16101
  
    
              <value type="string" key="08483334-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>


  		




  
  16102
  
    
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">boundary_WKT</value>


  		




  
  16103
  
    
              <value type="string" key="0ab9880e-a7a1-11e2-b667-080027bcf912">individual_observation</value>


  		




  
  16104
  
    
              <value type="string" key="0ab98a66-a7a1-11e2-b667-080027bcf912">id</value>


  		




  
  16105
  
    
              <value type="string" key="0ab98c50-a7a1-11e2-b667-080027bcf912">individual</value>


  		




  
  16106
  
    
              <value type="string" key="0ab98e12-a7a1-11e2-b667-080027bcf912">traits</value>


  		




  
  16107
  
    
              <value type="string" key="0ab99006-a7a1-11e2-b667-080027bcf912">PRIMARY</value>


  		




  
  16108
  
    
              <value type="string" key="0ab99376-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1_idx</value>


  		




  
  16109
  
    
              <value type="string" key="0ab99696-a7a1-11e2-b667-080027bcf912">fk_individual_observation_taxon_occurrence1</value>


  		




  
  16110
  
    
              <value type="string" key="0ab99812-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1</value>


  		




  
  16111
  
    
              <value type="string" key="110c72d2-a73f-11e2-9fbf-080027bcf912">stem_observation_unique</value>


  		




  
  16112
  
    
              <value type="string" key="11b487b4-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1</value>


  		




  
  16113
  
    
              <value type="string" key="11b489bc-f97f-11e2-8a2e-080027bcf912">taxon_path</value>


  		




  
  16114
  
    
              <value type="string" key="11b49e5c-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1_idx</value>


  		




  
  16115
  
    
              <value type="string" key="11c10cc8-a90c-11e2-8576-080027bcf912">source_unique</value>


  		




  
  16116
  
    
              <value type="string" key="1388436e-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1</value>


  		




  
  16117
  
    
              <value type="string" key="13884530-f9c5-11e2-9af4-080027bcf912">parent</value>


  		




  
  16118
  
    
              <value type="string" key="13885958-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1_idx</value>


  		




  
  16119
  
    
              <value type="string" key="16537a20-a7a7-11e2-8ba6-080027bcf912">taxon_observation</value>


  		




  
  16120
  
    
              <value type="string" key="16537d54-a7a7-11e2-8ba6-080027bcf912">id</value>


  		




  
  16121
  
    
              <value type="string" key="16538808-a7a7-11e2-8ba6-080027bcf912">growth_form</value>


  		




  
  16122
  
    
              <value type="string" key="165389fc-a7a7-11e2-8ba6-080027bcf912">cultivated</value>


  		




  
  16123
  
    
              <value type="string" key="16538c2c-a7a7-11e2-8ba6-080027bcf912">traits</value>


  		




  
  16124
  
    
              <value type="string" key="165395c8-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>


  		




  
  16125
  
    
              <value type="string" key="177949e8-f9c8-11e2-b815-080027bcf912">fk_individual_place1</value>


  		




  
  16126
  
    
              <value type="string" key="17796428-f9c8-11e2-b815-080027bcf912">fk_individual_place1_idx</value>


  		




  
  16127
  
    
              <value type="string" key="17d59e68-a794-11e2-84c3-080027bcf912">info</value>


  		




  
  16128
  
    
              <value type="string" key="181c8a8a-0077-11e3-906b-080027bcf912">height_min_m</value>


  		




  
  16129
  
    
              <value type="string" key="1832712c-a77d-11e2-afd5-080027bcf912">taxon_concept</value>


  		




  
  16130
  
    
              <value type="string" key="18327370-a77d-11e2-afd5-080027bcf912">id</value>


  		




  
  16131
  
    
              <value type="string" key="18327514-a77d-11e2-afd5-080027bcf912">according_to</value>


  		




  
  16132
  
    
              <value type="string" key="18327686-a77d-11e2-afd5-080027bcf912">parent</value>


  		




  
  16133
  
    
              <value type="string" key="183277ee-a77d-11e2-afd5-080027bcf912">accepted_taxon_concept</value>


  		




  
  16134
  
    
              <value type="string" key="1832797e-a77d-11e2-afd5-080027bcf912">PRIMARY</value>


  		




  
  16135
  
    
              <value type="string" key="18327c76-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1_idx</value>


  		




  
  16136
  
    
              <value type="string" key="18327f64-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1_idx</value>


  		




  
  16137
  
    
              <value type="string" key="1832823e-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1_idx</value>


  		




  
  16138
  
    
              <value type="string" key="18328522-a77d-11e2-afd5-080027bcf912">taxon_concept_unique_name</value>


  		




  
  16139
  
    
              <value type="string" key="183287f2-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1</value>


  		




  
  16140
  
    
              <value type="string" key="18328950-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1</value>


  		




  
  16141
  
    
              <value type="string" key="18328a9a-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1</value>


  		




  
  16142
  
    
              <value type="string" key="18328be4-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_name1</value>


  		




  
  16143
  
    
              <value type="string" key="184d9a4a-a793-11e2-84c3-080027bcf912">observations</value>


  		




  
  16144
  
    
              <value type="string" key="18c810aa-0084-11e3-ac06-080027bcf912">fk_aggregate_observation_record1</value>


  		




  
  16145
  
    
              <value type="string" key="18e739f0-a91b-11e2-bdec-080027bcf912">fk_organization_party1</value>


  		




  
  16146
  
    
              <value type="string" key="1b1bf6e4-0077-11e3-906b-080027bcf912">height_max_m</value>


  		




  
  16147
  
    
              <value type="string" key="1c952e1c-a791-11e2-84c3-080027bcf912">y_m</value>


  		




  
  16148
  
    
              <value type="string" key="21b40060-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1</value>


  		




  
  16149
  
    
              <value type="string" key="21b41366-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1_idx</value>


  		




  
  16150
  
    
              <value type="string" key="21c8f928-fa8d-11e2-9ba8-080027bcf912">fk_geovalidation_georeferencing1</value>


  		




  
  16151
  
    
              <value type="string" key="2213caf6-f971-11e2-9f36-080027bcf912">fk_georeferencing_geoplace1</value>


  		




  
  16152
  
    
              <value type="string" key="2213dee2-f971-11e2-9f36-080027bcf912">fk_georeferencing_geoplace1_idx</value>


  		




  
  16153
  
    
              <value type="string" key="238b4ae4-a700-11e2-9461-080027bcf912">stratum</value>


  		




  
  16154
  
    
              <value type="string" key="238b4f6c-a700-11e2-9461-080027bcf912">id</value>


  		




  
  16155
  
    
              <value type="string" key="238b53d6-a700-11e2-9461-080027bcf912">fk_place_path_record10</value>


  		




  
  16156
  
    
              <value type="string" key="23ec4078-0075-11e3-906b-080027bcf912">layer</value>


  		




  
  16157
  
    
              <value type="string" key="23ec4406-0075-11e3-906b-080027bcf912">id</value>


  		




  
  16158
  
    
              <value type="string" key="23ec4726-0075-11e3-906b-080027bcf912">name</value>


  		




  
  16159
  
    
              <value type="string" key="23ec49ec-0075-11e3-906b-080027bcf912">info</value>


  		




  
  16160
  
    
              <value type="string" key="23ec4e92-0075-11e3-906b-080027bcf912">PRIMARY</value>


  		




  
  16161
  
    
              <value type="string" key="245083fa-a763-11e2-aa10-080027bcf912">geovalidation</value>


  		




  
  16162
  
    
              <value type="string" key="24508724-a763-11e2-aa10-080027bcf912">id</value>


  		




  
  16163
  
    
              <value type="string" key="2450919c-a763-11e2-aa10-080027bcf912">PRIMARY</value>


  		




  
  16164
  
    
              <value type="string" key="251c29a8-f67b-11e2-aebb-080027bcf912">fk_event_party_list1</value>


  		




  
  16165
  
    
              <value type="string" key="251c2b92-f67b-11e2-aebb-080027bcf912">participants</value>


  		




  
  16166
  
    
              <value type="string" key="251c57de-f67b-11e2-aebb-080027bcf912">fk_event_party_list1_idx</value>


  		




  
  16167
  
    
              <value type="string" key="2673b9ee-f9bc-11e2-a599-080027bcf912">subplot</value>


  		




  
  16168
  
    
              <value type="string" key="2673bdc2-f9bc-11e2-a599-080027bcf912">id</value>


  		




  
  16169
  
    
              <value type="string" key="2673d532-f9bc-11e2-a599-080027bcf912">PRIMARY</value>


  		




  
  16170
  
    
              <value type="string" key="273737e8-a796-11e2-84c3-080027bcf912">tag</value>


  		




  
  16171
  
    
              <value type="string" key="293dc5b4-0085-11e3-ac06-080027bcf912">fk_reobservable_presence_taxon_presence1</value>


  		




  
  16172
  
    
              <value type="string" key="29c29602-a7a4-11e2-8ba6-080027bcf912">common_name</value>


  		




  
  16173
  
    
              <value type="string" key="2a08cd96-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1</value>


  		




  
  16174
  
    
              <value type="string" key="2a08de6c-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1_idx</value>


  		




  
  16175
  
    
              <value type="string" key="2d3c42f6-0078-11e3-906b-080027bcf912">fk_place_observation_event1</value>


  		




  
  16176
  
    
              <value type="string" key="2ed4b280-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1</value>


  		




  
  16177
  
    
              <value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value>


  		




  
  16178
  
    
              <value type="string" key="2f5fcbcc-a793-11e2-84c3-080027bcf912">observations</value>


  		




  
  16179
  
    
              <value type="string" key="3292225e-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1</value>


  		




  
  16180
  
    
              <value type="string" key="3292247a-f6df-11e2-b6d1-080027bcf912">input_geoplace</value>


  		




  
  16181
  
    
              <value type="string" key="329238b6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1_idx</value>


  		




  
  16182
  
    
              <value type="string" key="35cce77e-f6df-11e2-b6d1-080027bcf912">corrected_geoplace</value>


  		




  
  16183
  
    
              <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">verbatim</value>


  		




  
  16184
  
    
              <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>


  		




  
  16185
  
    
              <value type="string" key="3d9b13d2-a7a1-11e2-b667-080027bcf912">id</value>


  		




  
  16186
  
    
              <value type="string" key="3d9b17ba-a7a1-11e2-b667-080027bcf912">taxon_assertion</value>


  		




  
  16187
  
    
              <value type="string" key="3d9b197c-a7a1-11e2-b667-080027bcf912">identified_by</value>


  		




  
  16188
  
    
              <value type="string" key="3d9b1d28-a7a1-11e2-b667-080027bcf912">fit_info</value>


  		




  
  16189
  
    
              <value type="string" key="3d9b1f30-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1_idx</value>


  		




  
  16190
  
    
              <value type="string" key="3d9b26c4-a7a1-11e2-b667-080027bcf912">PRIMARY</value>


  		




  
  16191
  
    
              <value type="string" key="3d9b2d86-a7a1-11e2-b667-080027bcf912">taxon_determination_unique</value>


  		




  
  16192
  
    
              <value type="string" key="3d9b3600-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1</value>


  		




  
  16193
  
    
              <value type="string" key="4001ec92-f678-11e2-9716-080027bcf912">party_list</value>


  		




  
  16194
  
    
              <value type="string" key="4001ef9e-f678-11e2-9716-080027bcf912">id</value>


  		




  
  16195
  
    
              <value type="string" key="4001f296-f678-11e2-9716-080027bcf912">count</value>


  		




  
  16196
  
    
              <value type="string" key="4001f692-f678-11e2-9716-080027bcf912">fk_collection_source100</value>


  		




  
  16197
  
    
              <value type="string" key="4001fa52-f678-11e2-9716-080027bcf912">PRIMARY</value>


  		




  
  16198
  
    
              <value type="string" key="400c0dc2-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1</value>


  		




  
  16199
  
    
              <value type="string" key="400c0fac-f6d1-11e2-a35e-080027bcf912">parsed_taxon_assertion</value>


  		




  
  16200
  
    
              <value type="string" key="400c2370-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1_idx</value>


  		




  
  16201
  
    
              <value type="string" key="40e95b66-acfb-11e2-b309-080027bcf912">fk_method_method1</value>


  		




  
  16202
  
    
              <value type="string" key="40e95d64-acfb-11e2-b309-080027bcf912">parent</value>


  		




  
  16203
  
    
              <value type="string" key="40e971d2-acfb-11e2-b309-080027bcf912">fk_method_method1_idx</value>


  		




  
  16204
  
    
              <value type="string" key="415f1a26-ad15-11e2-9617-080027bcf912">specimen_unique_in_individual</value>


  		




  
  16205
  
    
              <value type="string" key="42266085-54CC-4441-8553-68BBE0286A05">default</value>


  		




  
  16206
  
    
              <value type="string" key="42405474-a783-11e2-afd5-080027bcf912">annotations</value>


  		




  
  16207
  
    
              <value type="string" key="43cfb7dc-a790-11e2-84c3-080027bcf912">lat_long_domain_valid</value>


  		




  
  16208
  
    
              <value type="string" key="43f62c16-ad1a-11e2-9d85-080027bcf912">info</value>


  		




  
  16209
  
    
              <value type="string" key="43f70d90-f679-11e2-9716-080027bcf912">sort_order</value>


  		




  
  16210
  
    
              <value type="string" key="44e36b2c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1</value>


  		




  
  16211
  
    
              <value type="string" key="44e36d02-a7b4-11e2-97d7-080027bcf912">specimen</value>


  		




  
  16212
  
    
              <value type="string" key="44e38f6c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1_idx</value>


  		




  
  16213
  
    
              <value type="string" key="45a3f404-ad0f-11e2-b309-080027bcf912">name</value>


  		




  
  16214
  
    
              <value type="string" key="46a92892-f95e-11e2-8597-080027bcf912">occurrence_status</value>


  		




  
  16215
  
    
              <value type="string" key="47b3b670-0076-11e3-906b-080027bcf912">diameter_max_m</value>


  		




  
  16216
  
    
              <value type="string" key="4824526a-a791-11e2-84c3-080027bcf912">area_m2</value>


  		




  
  16217
  
    
              <value type="string" key="489c177a-a6ea-11e2-98a6-080027bcf912">referenced_class</value>


  		




  
  16218
  
    
              <value type="string" key="489c19be-a6ea-11e2-98a6-080027bcf912">id</value>


  		




  
  16219
  
    
              <value type="string" key="489c1b62-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>


  		




  
  16220
  
    
              <value type="string" key="489c1e64-a6ea-11e2-98a6-080027bcf912">fk_example_record10</value>


  		




  
  16221
  
    
              <value type="string" key="489c25e4-a6ea-11e2-98a6-080027bcf912">base_class</value>


  		




  
  16222
  
    
              <value type="string" key="489c281e-a6ea-11e2-98a6-080027bcf912">id</value>


  		




  
  16223
  
    
              <value type="string" key="489c29c2-a6ea-11e2-98a6-080027bcf912">referenced_class</value>


  		




  
  16224
  
    
              <value type="string" key="489c2b34-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>


  		




  
  16225
  
    
              <value type="string" key="489c2e22-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1_idx</value>


  		




  
  16226
  
    
              <value type="string" key="489c325a-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1</value>


  		




  
  16227
  
    
              <value type="string" key="489c3958-a6ea-11e2-98a6-080027bcf912">derived_class</value>


  		




  
  16228
  
    
              <value type="string" key="489c3b9c-a6ea-11e2-98a6-080027bcf912">id</value>


  		




  
  16229
  
    
              <value type="string" key="489c3d40-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>


  		




  
  16230
  
    
              <value type="string" key="489c402e-a6ea-11e2-98a6-080027bcf912">fk_derived_class_base_class1</value>


  		




  
  16231
  
    
              <value type="string" key="48af0dca-a795-11e2-84c3-080027bcf912">slope_direction_deg_N</value>


  		




  
  16232
  
    
              <value type="string" key="49a23428-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2</value>


  		




  
  16233
  
    
              <value type="string" key="49a235d6-f9c5-11e2-9af4-080027bcf912">parent_plot</value>


  		




  
  16234
  
    
              <value type="string" key="49a26722-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2_idx</value>


  		




  
  16235
  
    
              <value type="string" key="4c32a89c-a76a-11e2-92a3-080027bcf912">match_score</value>


  		




  
  16236
  
    
              <value type="string" key="4c3ffc96-a741-11e2-9fbf-080027bcf912">taxon_string</value>


  		




  
  16237
  
    
              <value type="string" key="4c40001a-a741-11e2-9fbf-080027bcf912">string</value>


  		




  
  16238
  
    
              <value type="string" key="4c4005b0-a741-11e2-9fbf-080027bcf912">PRIMARY</value>


  		




  
  16239
  
    
              <value type="string" key="4e241b94-ad15-11e2-9617-080027bcf912">specimen_unique_by_collection_event</value>


  		




  
  16240
  
    
              <value type="string" key="4e34b204-f9c5-11e2-9af4-080027bcf912">fk_subplot_rel_place1</value>


  		




  
  16241
  
    
              <value type="string" key="4ee0a0e2-a794-11e2-84c3-080027bcf912">info</value>


  		




  
  16242
  
    
              <value type="string" key="4f2d2f86-f986-11e2-8a2e-080027bcf912">info</value>


  		




  
  16243
  
    
              <value type="string" key="5077e4de-a748-11e2-9fbf-080027bcf912">taxon</value>


  		




  
  16244
  
    
              <value type="string" key="523d417c-f96b-11e2-9fb4-080027bcf912">parent_geoplace</value>


  		




  
  16245
  
    
              <value type="string" key="5256ac76-f983-11e2-8a2e-080027bcf912">azimuth_deg_N</value>


  		




  
  16246
  
    
              <value type="string" key="54dd4bd4-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1</value>


  		




  
  16247
  
    
              <value type="string" key="54dd4d82-f67d-11e2-aebb-080027bcf912">specimenholder_institutions</value>


  		




  
  16248
  
    
              <value type="string" key="54dd6466-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1_idx</value>


  		




  
  16249
  
    
              <value type="string" key="57512c00-ac86-11e2-aa54-080027bcf912">PRIMARY</value>


  		




  
  16250
  
    
              <value type="string" key="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>


  		




  
  16251
  
    
              <value type="string" key="59b33ca8-f6ba-11e2-aebb-080027bcf912">taxon_absence</value>


  		




  
  16252
  
    
              <value type="string" key="59b33fe6-f6ba-11e2-aebb-080027bcf912">id</value>


  		




  
  16253
  
    
              <value type="string" key="59b34b30-f6ba-11e2-aebb-080027bcf912">PRIMARY</value>


  		




  
  16254
  
    
              <value type="string" key="5a0331b2-f96d-11e2-9fb4-080027bcf912">name</value>


  		




  
  16255
  
    
              <value type="string" key="5b345f5e-f957-11e2-8597-080027bcf912">fk_taxon_determination_taxon_observation1</value>


  		




  
  16256
  
    
              <value type="string" key="5c62b4f2-ad03-11e2-b309-080027bcf912">code</value>


  		




  
  16257
  
    
              <value type="string" key="5e41c0d2-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1</value>


  		




  
  16258
  
    
              <value type="string" key="5e41cb90-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1_idx</value>


  		




  
  16259
  
    
              <value type="string" key="648b8c10-0075-11e3-906b-080027bcf912">fk_layer_stratum1</value>


  		




  
  16260
  
    
              <value type="string" key="66675a70-f970-11e2-9f36-080027bcf912">fk_geoplace_place1</value>


  		




  
  16261
  
    
              <value type="string" key="66c25c1c-a791-11e2-84c3-080027bcf912">length_m</value>


  		




  
  16262
  
    
              <value type="string" key="67fa5b28-f6c1-11e2-af44-080027bcf912">fk_taxon_observation_sampling_event1</value>


  		




  
  16263
  
    
              <value type="string" key="6856853a-a796-11e2-84c3-080027bcf912">traits</value>


  		




  
  16264
  
    
              <value type="string" key="686ec05a-f9bc-11e2-a599-080027bcf912">fk_subplot_plot1</value>


  		




  
  16265
  
    
              <value type="string" key="687f12b8-a780-11e2-afd5-080027bcf912">taxon_name</value>


  		




  
  16266
  
    
              <value type="string" key="687f1542-a780-11e2-afd5-080027bcf912">id</value>


  		




  
  16267
  
    
              <value type="string" key="687f1718-a780-11e2-afd5-080027bcf912">unique_name</value>


  		




  
  16268
  
    
              <value type="string" key="687f18b2-a780-11e2-afd5-080027bcf912">formal_name</value>


  		




  
  16269
  
    
              <value type="string" key="687f1a6a-a780-11e2-afd5-080027bcf912">taxon_name</value>


  		




  
  16270
  
    
              <value type="string" key="687f1c2c-a780-11e2-afd5-080027bcf912">author</value>


  		




  
  16271
  
    
              <value type="string" key="687f1dda-a780-11e2-afd5-080027bcf912">rank</value>


  		




  
  16272
  
    
              <value type="string" key="687f1f92-a780-11e2-afd5-080027bcf912">PRIMARY</value>


  		




  
  16273
  
    
              <value type="string" key="687f22b2-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10_idx</value>


  		




  
  16274
  
    
              <value type="string" key="687f25a0-a780-11e2-afd5-080027bcf912">fk_taxon_record10</value>


  		




  
  16275
  
    
              <value type="string" key="687f26f4-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10</value>


  		




  
  16276
  
    
              <value type="string" key="687f2f28-a780-11e2-afd5-080027bcf912">taxon_path</value>


  		




  
  16277
  
    
              <value type="string" key="687f31c6-a780-11e2-afd5-080027bcf912">id</value>


  		




  
  16278
  
    
              <value type="string" key="687f339c-a780-11e2-afd5-080027bcf912">family</value>


  		




  
  16279
  
    
              <value type="string" key="687f3590-a780-11e2-afd5-080027bcf912">genus</value>


  		




  
  16280
  
    
              <value type="string" key="687f3752-a780-11e2-afd5-080027bcf912">specific_epithet</value>


  		




  
  16281
  
    
              <value type="string" key="687f3900-a780-11e2-afd5-080027bcf912">ranks</value>


  		




  
  16282
  
    
              <value type="string" key="687f3ae0-a780-11e2-afd5-080027bcf912">PRIMARY</value>


  		




  
  16283
  
    
              <value type="string" key="68bcc4bc-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1</value>


  		




  
  16284
  
    
              <value type="string" key="68bcc6ce-0083-11e3-ac06-080027bcf912">taxon</value>


  		




  
  16285
  
    
              <value type="string" key="68bcdca4-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1_idx</value>


  		




  
  16286
  
    
              <value type="string" key="69b7c87c-f970-11e2-9f36-080027bcf912">fk_nested_geoplace_geoplace1</value>


  		




  
  16287
  
    
              <value type="string" key="6b43aacc-f979-11e2-9f36-080027bcf912">fk_place_geopath1</value>


  		




  
  16288
  
    
              <value type="string" key="6b43ac84-f979-11e2-9f36-080027bcf912">geopath</value>


  		




  
  16289
  
    
              <value type="string" key="6b43c264-f979-11e2-9f36-080027bcf912">fk_place_geopath1_idx</value>


  		




  
  16290
  
    
              <value type="string" key="6b54505e-ad0f-11e2-b309-080027bcf912">collection_unique</value>


  		




  
  16291
  
    
              <value type="string" key="6c2bb9d2-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1</value>


  		




  
  16292
  
    
              <value type="string" key="6c2bbbb2-0083-11e3-ac06-080027bcf912">size_class</value>


  		




  
  16293
  
    
              <value type="string" key="6c2bd08e-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1_idx</value>


  		




  
  16294
  
    
              <value type="string" key="6ec4a89c-ad05-11e2-b309-080027bcf912">fk_specimen_individual1</value>


  		




  
  16295
  
    
              <value type="string" key="6ec4aa86-ad05-11e2-b309-080027bcf912">individual</value>


  		




  
  16296
  
    
              <value type="string" key="6ec4c2fa-ad05-11e2-b309-080027bcf912">fk_specimen_individual1_idx</value>


  		




  
  16297
  
    
              <value type="string" key="74709b22-a795-11e2-84c3-080027bcf912">slope_incline_deg</value>


  		




  
  16298
  
    
              <value type="string" key="7627a20a-0085-11e3-ac06-080027bcf912">fk_reobservable_presence_specimen1</value>


  		




  
  16299
  
    
              <value type="string" key="7627b66e-0085-11e3-ac06-080027bcf912">fk_reobservable_presence_specimen1_idx</value>


  		




  
  16300
  
    
              <value type="string" key="782db00a-a782-11e2-afd5-080027bcf912">match_info</value>


  		




  
  16301
  
    
              <value type="string" key="7afebdc8-0075-11e3-906b-080027bcf912">size_class</value>


  		




  
  16302
  
    
              <value type="string" key="7afec156-0075-11e3-906b-080027bcf912">id</value>


  		




  
  16303
  
    
              <value type="string" key="7afec49e-0075-11e3-906b-080027bcf912">diameter_min_m</value>


  		




  
  16304
  
    
              <value type="string" key="7afec6ec-0075-11e3-906b-080027bcf912">info</value>


  		




  
  16305
  
    
              <value type="string" key="7afec93a-0075-11e3-906b-080027bcf912">fk_layer_stratum10</value>


  		




  
  16306
  
    
              <value type="string" key="7afecb88-0075-11e3-906b-080027bcf912">PRIMARY</value>


  		




  
  16307
  
    
              <value type="string" key="7c31a514-f96f-11e2-9f36-080027bcf912">boundary_WKT</value>


  		




  
  16308
  
    
              <value type="string" key="7d6806c8-f95e-11e2-8597-080027bcf912">description</value>


  		




  
  16309
  
    
              <value type="string" key="7f176964-f6c0-11e2-af44-080027bcf912">taxa_sampling_event</value>


  		




  
  16310
  
    
              <value type="string" key="7f176d06-f6c0-11e2-af44-080027bcf912">id</value>


  		




  
  16311
  
    
              <value type="string" key="7f177512-f6c0-11e2-af44-080027bcf912">fk_project_event10</value>


  		




  
  16312
  
    
              <value type="string" key="7f177760-f6c0-11e2-af44-080027bcf912">PRIMARY</value>


  		




  
  16313
  
    
              <value type="string" key="7f3654cc-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_barcode</value>


  		




  
  16314
  
    
              <value type="string" key="803980c8-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1</value>


  		




  
  16315
  
    
              <value type="string" key="8039828a-f6d1-11e2-a35e-080027bcf912">input_string</value>


  		




  
  16316
  
    
              <value type="string" key="80399806-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1_idx</value>


  		




  
  16317
  
    
              <value type="string" key="81937b1c-ad12-11e2-b309-080027bcf912">fk_collection_source1_idx</value>


  		




  
  16318
  
    
              <value type="string" key="83dbd4da-f6e8-11e2-9cf1-080027bcf912">georeferencing</value>


  		




  
  16319
  
    
              <value type="string" key="83dbd8ae-f6e8-11e2-9cf1-080027bcf912">id</value>


  		




  
  16320
  
    
              <value type="string" key="83dbdbec-f6e8-11e2-9cf1-080027bcf912">input_place</value>


  		




  
  16321
  
    
              <value type="string" key="83dbe060-f6e8-11e2-9cf1-080027bcf912">fk_geovalidation_record100</value>


  		




  
  16322
  
    
              <value type="string" key="83dbe6aa-f6e8-11e2-9cf1-080027bcf912">PRIMARY</value>


  		




  
  16323
  
    
              <value type="string" key="8535dbc2-006c-11e3-895c-080027bcf912">stratum_event</value>


  		




  
  16324
  
    
              <value type="string" key="8535dfbe-006c-11e3-895c-080027bcf912">id</value>


  		




  
  16325
  
    
              <value type="string" key="8535e306-006c-11e3-895c-080027bcf912">stratum</value>


  		




  
  16326
  
    
              <value type="string" key="8535e982-006c-11e3-895c-080027bcf912">PRIMARY</value>


  		




  
  16327
  
    
              <value type="string" key="8542fbb8-a793-11e2-84c3-080027bcf912">info</value>


  		




  
  16328
  
    
              <value type="string" key="8b8a694e-a792-11e2-84c3-080027bcf912">name</value>


  		




  
  16329
  
    
              <value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value>


  		




  
  16330
  
    
              <value type="string" key="8f0c3678-f978-11e2-9f36-080027bcf912">rank</value>


  		




  
  16331
  
    
              <value type="string" key="913a6e06-008a-11e3-9629-080027bcf912">fk_soil_observation_record1</value>


  		




  
  16332
  
    
              <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>


  		




  
  16333
  
    
              <value type="string" key="95e0feca-a793-11e2-84c3-080027bcf912">info</value>


  		




  
  16334
  
    
              <value type="string" key="978ed2dc-f9c4-11e2-9af4-080027bcf912">place</value>


  		




  
  16335
  
    
              <value type="string" key="98e532e4-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1</value>


  		




  
  16336
  
    
              <value type="string" key="98e534d8-008a-11e3-9629-080027bcf912">place_observation</value>


  		




  
  16337
  
    
              <value type="string" key="98e5491e-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1_idx</value>


  		




  
  16338
  
    
              <value type="string" key="9b006114-f6d2-11e2-a35e-080027bcf912">fk_taxon_scrub_record1</value>


  		




  
  16339
  
    
              <value type="string" key="9b6b7d6a-ad0c-11e2-b309-080027bcf912">fk_parsed_taxon_assertion_taxon_name1_idx</value>


  		




  
  16340
  
    
              <value type="string" key="9d6c9e9a-f678-11e2-9716-080027bcf912">party_list_entry</value>


  		




  
  16341
  
    
              <value type="string" key="9d6ca408-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party_list1</value>


  		




  
  16342
  
    
              <value type="string" key="9d6ca570-f678-11e2-9716-080027bcf912">id</value>


  		




  
  16343
  
    
              <value type="string" key="9d6ca7aa-f678-11e2-9716-080027bcf912">PRIMARY</value>


  		




  
  16344
  
    
              <value type="string" key="9d6cb042-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1</value>


  		




  
  16345
  
    
              <value type="string" key="9d6cb150-f678-11e2-9716-080027bcf912">entry</value>


  		




  
  16346
  
    
              <value type="string" key="9d6cb812-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1_idx</value>


  		




  
  16347
  
    
              <value type="string" key="9d6cbbd2-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party_list1_idx</value>


  		




  
  16348
  
    
              <value type="string" key="9f4bd98c-a6fb-11e2-9461-080027bcf912">plot</value>


  		




  
  16349
  
    
              <value type="string" key="9f4bdd10-a6fb-11e2-9461-080027bcf912">id</value>


  		




  
  16350
  
    
              <value type="string" key="9f4be008-a6fb-11e2-9461-080027bcf912">fk_subplot_place1</value>


  		




  
  16351
  
    
              <value type="string" key="9f4be256-a6fb-11e2-9461-080027bcf912">PRIMARY</value>


  		




  
  16352
  
    
              <value type="string" key="9f58576a-a792-11e2-84c3-080027bcf912">name</value>


  		




  
  16353
  
    
              <value type="string" key="a01e225c-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1</value>


  		




  
  16354
  
    
              <value type="string" key="a01e269e-a741-11e2-9fbf-080027bcf912">string</value>


  		




  
  16355
  
    
              <value type="string" key="a01e47fa-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1_idx</value>


  		




  
  16356
  
    
              <value type="string" key="a0266c92-a92a-11e2-93c8-080027bcf912">latitude_deg</value>


  		




  
  16357
  
    
              <value type="string" key="a09e45d4-a79d-11e2-a346-080027bcf912">source_record_id</value>


  		




  
  16358
  
    
              <value type="string" key="a2fe2068-a790-11e2-84c3-080027bcf912">name</value>


  		




  
  16359
  
    
              <value type="string" key="a3e070f8-a77c-11e2-afd5-080027bcf912">fk_parsed_taxon_assertion_taxon_name1</value>


  		




  
  16360
  
    
              <value type="string" key="a45bf56a-f980-11e2-8a2e-080027bcf912">fk_subplot_place2</value>


  		




  
  16361
  
    
              <value type="string" key="a60e3a24-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_accession_number</value>


  		




  
  16362
  
    
              <value type="string" key="a8348424-a78f-11e2-84c3-080027bcf912">geovalid</value>


  		




  
  16363
  
    
              <value type="string" key="a841b894-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1</value>


  		




  
  16364
  
    
              <value type="string" key="a841ba7e-f6c0-11e2-af44-080027bcf912">method</value>


  		




  
  16365
  
    
              <value type="string" key="a842920a-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1_idx</value>


  		




  
  16366
  
    
              <value type="string" key="aa191bd2-a92a-11e2-93c8-080027bcf912">longitude_deg</value>


  		




  
  16367
  
    
              <value type="string" key="ae7761fe-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1</value>


  		




  
  16368
  
    
              <value type="string" key="ae7763ca-008a-11e3-9629-080027bcf912">measurement_spot</value>


  		




  
  16369
  
    
              <value type="string" key="ae777b3a-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1_idx</value>


  		




  
  16370
  
    
              <value type="string" key="aed5d5c4-a769-11e2-92a3-080027bcf912">cf_aff</value>


  		




  
  16371
  
    
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>


  		




  
  16372
  
    
              <value type="string" key="b3ac613c-0086-11e3-ac06-080027bcf912">fk_reobservable_presence_reobservable1</value>


  		




  
  16373
  
    
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>


  		




  
  16374
  
    
              <value type="string" key="b8ce339a-a797-11e2-8681-080027bcf912">fk_stem_individual2</value>


  		




  
  16375
  
    
              <value type="string" key="b922e5ba-006c-11e3-895c-080027bcf912">fk_stratum_event_stratum1</value>


  		




  
  16376
  
    
              <value type="string" key="b922fa5a-006c-11e3-895c-080027bcf912">fk_stratum_event_stratum1_idx</value>


  		




  
  16377
  
    
              <value type="string" key="b95efb72-f982-11e2-8a2e-080027bcf912">width_m</value>


  		




  
  16378
  
    
              <value type="string" key="b9695d2e-a793-11e2-84c3-080027bcf912">info</value>


  		




  
  16379
  
    
              <value type="string" key="b9be8c42-acff-11e2-b309-080027bcf912">collectors</value>


  		




  
  16380
  
    
              <value type="string" key="bb0eaf44-ad10-11e2-b309-080027bcf912">current_collection</value>


  		




  
  16381
  
    
              <value type="string" key="bbbbdd9c-ad09-11e2-b309-080027bcf912">code_in_individual</value>


  		




  
  16382
  
    
              <value type="string" key="be8cb246-a6e0-11e2-95e9-080027bcf912">VegCore</value>


  		




  
  16383
  
    
              <value type="string" key="be8cc04c-a6e0-11e2-95e9-080027bcf912">source</value>


  		




  
  16384
  
    
              <value type="string" key="be8cc362-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16385
  
    
              <value type="string" key="be8cc59c-a6e0-11e2-95e9-080027bcf912">parent</value>


  		




  
  16386
  
    
              <value type="string" key="be8cc75e-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16387
  
    
              <value type="string" key="be8ccb14-a6e0-11e2-95e9-080027bcf912">fk_source1_idx</value>


  		




  
  16388
  
    
              <value type="string" key="be8cce5c-a6e0-11e2-95e9-080027bcf912">fk_source1</value>


  		




  
  16389
  
    
              <value type="string" key="be8cd56e-a6e0-11e2-95e9-080027bcf912">record</value>


  		




  
  16390
  
    
              <value type="string" key="be8cd7b2-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16391
  
    
              <value type="string" key="be8cd956-a6e0-11e2-95e9-080027bcf912">source</value>


  		




  
  16392
  
    
              <value type="string" key="be8cdac8-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16393
  
    
              <value type="string" key="be8cddca-a6e0-11e2-95e9-080027bcf912">fk_record_source1_idx</value>


  		




  
  16394
  
    
              <value type="string" key="be8ce0b8-a6e0-11e2-95e9-080027bcf912">fk_record_source1</value>


  		




  
  16395
  
    
              <value type="string" key="be8ce932-a6e0-11e2-95e9-080027bcf912">relationship</value>


  		




  
  16396
  
    
              <value type="string" key="be8cebb2-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16397
  
    
              <value type="string" key="be8ced88-a6e0-11e2-95e9-080027bcf912">record</value>


  		




  
  16398
  
    
              <value type="string" key="be8cef2c-a6e0-11e2-95e9-080027bcf912">related_record</value>


  		




  
  16399
  
    
              <value type="string" key="be8cf0d0-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16400
  
    
              <value type="string" key="be8cf42c-a6e0-11e2-95e9-080027bcf912">fk_relationship_record1_idx</value>


  		




  
  16401
  
    
              <value type="string" key="be8cf71a-a6e0-11e2-95e9-080027bcf912">fk_relationship_related_record_idx</value>


  		




  
  16402
  
    
              <value type="string" key="be8cf9fe-a6e0-11e2-95e9-080027bcf912">fk_relationship_record1</value>


  		




  
  16403
  
    
              <value type="string" key="be8cfb66-a6e0-11e2-95e9-080027bcf912">fk_relationship_record2</value>


  		




  
  16404
  
    
              <value type="string" key="be8cfcb0-a6e0-11e2-95e9-080027bcf912">fk_relationship_related_record</value>


  		




  
  16405
  
    
              <value type="string" key="be8d17d6-a6e0-11e2-95e9-080027bcf912">taxon_assertion</value>


  		




  
  16406
  
    
              <value type="string" key="be8d1ac4-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16407
  
    
              <value type="string" key="be8d1de4-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16408
  
    
              <value type="string" key="be8d249c-a6e0-11e2-95e9-080027bcf912">fk_qualified_taxon_record1</value>


  		




  
  16409
  
    
              <value type="string" key="be8d4a58-a6e0-11e2-95e9-080027bcf912">geoplace</value>


  		




  
  16410
  
    
              <value type="string" key="be8d4cd8-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16411
  
    
              <value type="string" key="be8d4eae-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16412
  
    
              <value type="string" key="be8d8c2a-a6e0-11e2-95e9-080027bcf912">method</value>


  		




  
  16413
  
    
              <value type="string" key="be8d8ea0-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16414
  
    
              <value type="string" key="be8d906c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16415
  
    
              <value type="string" key="be8d93c8-a6e0-11e2-95e9-080027bcf912">fk_method_record1</value>


  		




  
  16416
  
    
              <value type="string" key="be8df962-a6e0-11e2-95e9-080027bcf912">collection</value>


  		




  
  16417
  
    
              <value type="string" key="be8dfbf6-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16418
  
    
              <value type="string" key="be8e0240-a6e0-11e2-95e9-080027bcf912">fk_collection_source1</value>


  		




  
  16419
  
    
              <value type="string" key="be8e3ecc-a6e0-11e2-95e9-080027bcf912">individual</value>


  		




  
  16420
  
    
              <value type="string" key="be8e4142-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16421
  
    
              <value type="string" key="be8e4322-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16422
  
    
              <value type="string" key="be8e4688-a6e0-11e2-95e9-080027bcf912">fk_individual_record1</value>


  		




  
  16423
  
    
              <value type="string" key="be8e6514-a6e0-11e2-95e9-080027bcf912">stem</value>


  		




  
  16424
  
    
              <value type="string" key="be8e679e-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16425
  
    
              <value type="string" key="be8e6974-a6e0-11e2-95e9-080027bcf912">individual</value>


  		




  
  16426
  
    
              <value type="string" key="be8e6b22-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16427
  
    
              <value type="string" key="be8e6e7e-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1_idx</value>


  		




  
  16428
  
    
              <value type="string" key="be8e7360-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1</value>


  		




  
  16429
  
    
              <value type="string" key="be8e7cde-a6e0-11e2-95e9-080027bcf912">stem_observation</value>


  		




  
  16430
  
    
              <value type="string" key="be8e7f5e-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16431
  
    
              <value type="string" key="be8e8134-a6e0-11e2-95e9-080027bcf912">individual_observation</value>


  		




  
  16432
  
    
              <value type="string" key="be8e82ce-a6e0-11e2-95e9-080027bcf912">stem</value>


  		




  
  16433
  
    
              <value type="string" key="be8e8472-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16434
  
    
              <value type="string" key="be8e87d8-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1_idx</value>


  		




  
  16435
  
    
              <value type="string" key="be8e8b20-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1_idx</value>


  		




  
  16436
  
    
              <value type="string" key="be8e8fe4-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1</value>


  		




  
  16437
  
    
              <value type="string" key="be8e9156-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1</value>


  		




  
  16438
  
    
              <value type="string" key="be8e9930-a6e0-11e2-95e9-080027bcf912">aggregate_observation</value>


  		




  
  16439
  
    
              <value type="string" key="be8e9bba-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16440
  
    
              <value type="string" key="be8e9d90-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16441
  
    
              <value type="string" key="be8ea786-a6e0-11e2-95e9-080027bcf912">taxon_presence</value>


  		




  
  16442
  
    
              <value type="string" key="be8eaa06-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16443
  
    
              <value type="string" key="be8f1784-a6e0-11e2-95e9-080027bcf912">community</value>


  		




  
  16444
  
    
              <value type="string" key="be8f1a36-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16445
  
    
              <value type="string" key="be8f1c2a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16446
  
    
              <value type="string" key="be8f1fc2-a6e0-11e2-95e9-080027bcf912">fk_community_record1</value>


  		




  
  16447
  
    
              <value type="string" key="be8f272e-a6e0-11e2-95e9-080027bcf912">geological_context</value>


  		




  
  16448
  
    
              <value type="string" key="be8f29d6-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16449
  
    
              <value type="string" key="be8f2b98-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16450
  
    
              <value type="string" key="be8f2ecc-a6e0-11e2-95e9-080027bcf912">fk_geological_context_record1</value>


  		




  
  16451
  
    
              <value type="string" key="be8f387c-a6e0-11e2-95e9-080027bcf912">place_observation</value>


  		




  
  16452
  
    
              <value type="string" key="be8f3ade-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16453
  
    
              <value type="string" key="be8f3ca0-a6e0-11e2-95e9-080027bcf912">place</value>


  		




  
  16454
  
    
              <value type="string" key="be8f3e30-a6e0-11e2-95e9-080027bcf912">geological_context</value>


  		




  
  16455
  
    
              <value type="string" key="be8f3fd4-a6e0-11e2-95e9-080027bcf912">community</value>


  		




  
  16456
  
    
              <value type="string" key="be8f416e-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1_idx</value>


  		




  
  16457
  
    
              <value type="string" key="be8f4524-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1_idx</value>


  		




  
  16458
  
    
              <value type="string" key="be8f483a-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1_idx</value>


  		




  
  16459
  
    
              <value type="string" key="be8f4b64-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1</value>


  		




  
  16460
  
    
              <value type="string" key="be8f4d08-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1</value>


  		




  
  16461
  
    
              <value type="string" key="be8f4e98-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1</value>


  		




  
  16462
  
    
              <value type="string" key="be8f58b6-a6e0-11e2-95e9-080027bcf912">soil_observation</value>


  		




  
  16463
  
    
              <value type="string" key="be8f5b5e-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16464
  
    
              <value type="string" key="be8f5d5c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16465
  
    
              <value type="string" key="be8f67e8-a6e0-11e2-95e9-080027bcf912">subplace</value>


  		




  
  16466
  
    
              <value type="string" key="be8f6a86-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16467
  
    
              <value type="string" key="be8f6c7a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16468
  
    
              <value type="string" key="be8f78aa-a6e0-11e2-95e9-080027bcf912">geovalidatable_place</value>


  		




  
  16469
  
    
              <value type="string" key="be8f7b0c-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16470
  
    
              <value type="string" key="be8f8084-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16471
  
    
              <value type="string" key="be8fa0fa-a6e0-11e2-95e9-080027bcf912">project</value>


  		




  
  16472
  
    
              <value type="string" key="be8fa398-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16473
  
    
              <value type="string" key="be8fa58c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16474
  
    
              <value type="string" key="be8fa91a-a6e0-11e2-95e9-080027bcf912">fk_project_event1</value>


  		




  
  16475
  
    
              <value type="string" key="be8fb202-a6e0-11e2-95e9-080027bcf912">taxon_scrub</value>


  		




  
  16476
  
    
              <value type="string" key="be8fb5ae-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16477
  
    
              <value type="string" key="be8fb7a2-a6e0-11e2-95e9-080027bcf912">matched_taxon_concept</value>


  		




  
  16478
  
    
              <value type="string" key="be8fb98c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16479
  
    
              <value type="string" key="be8fe70e-a6e0-11e2-95e9-080027bcf912">party</value>


  		




  
  16480
  
    
              <value type="string" key="be8fe97a-a6e0-11e2-95e9-080027bcf912">id</value>


  		




  
  16481
  
    
              <value type="string" key="be8feb50-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>


  		




  
  16482
  
    
              <value type="string" key="be8fee8e-a6e0-11e2-95e9-080027bcf912">fk_collection_source10</value>


  		




  
  16483
  
    
              <value type="string" key="c20b4bce-ad13-11e2-b309-080027bcf912">fk_specimen_organization3_idx</value>


  		




  
  16484
  
    
              <value type="string" key="c3760d74-a7b3-11e2-8ba6-080027bcf912">specimen_observation</value>


  		




  
  16485
  
    
              <value type="string" key="c376109e-a7b3-11e2-8ba6-080027bcf912">id</value>


  		




  
  16486
  
    
              <value type="string" key="c3762570-a7b3-11e2-8ba6-080027bcf912">fk_specimen_taxon_occurrence10</value>


  		




  
  16487
  
    
              <value type="string" key="c37629b2-a7b3-11e2-8ba6-080027bcf912">PRIMARY</value>


  		




  
  16488
  
    
              <value type="string" key="c4391d16-006c-11e3-895c-080027bcf912">fk_stratum_event_sampling_event1</value>


  		




  
  16489
  
    
              <value type="string" key="c540c5c0-ad19-11e2-9d85-080027bcf912">traits</value>


  		




  
  16490
  
    
              <value type="string" key="c66112f6-ad10-11e2-b309-080027bcf912">fk_specimen_collection2</value>


  		




  
  16491
  
    
              <value type="string" key="c6612660-ad10-11e2-b309-080027bcf912">fk_specimen_collection2_idx</value>


  		




  
  16492
  
    
              <value type="string" key="c6722390-a7a0-11e2-b667-080027bcf912">geopath</value>


  		




  
  16493
  
    
              <value type="string" key="c67225de-a7a0-11e2-b667-080027bcf912">id</value>


  		




  
  16494
  
    
              <value type="string" key="c6722782-a7a0-11e2-b667-080027bcf912">continent</value>


  		




  
  16495
  
    
              <value type="string" key="c6722912-a7a0-11e2-b667-080027bcf912">country</value>


  		




  
  16496
  
    
              <value type="string" key="c6722a98-a7a0-11e2-b667-080027bcf912">state_province</value>


  		




  
  16497
  
    
              <value type="string" key="c6722c1e-a7a0-11e2-b667-080027bcf912">county</value>


  		




  
  16498
  
    
              <value type="string" key="c6722da4-a7a0-11e2-b667-080027bcf912">municipality</value>


  		




  
  16499
  
    
              <value type="string" key="c6722f2a-a7a0-11e2-b667-080027bcf912">ranks</value>


  		




  
  16500
  
    
              <value type="string" key="c67230d8-a7a0-11e2-b667-080027bcf912">PRIMARY</value>


  		




  
  16501
  
    
              <value type="string" key="c6723d8a-a7a0-11e2-b667-080027bcf912">place</value>


  		




  
  16502
  
    
              <value type="string" key="c6724000-a7a0-11e2-b667-080027bcf912">id</value>


  		




  
  16503
  
    
              <value type="string" key="c67241b8-a7a0-11e2-b667-080027bcf912">parent</value>


  		




  
  16504
  
    
              <value type="string" key="c672467c-a7a0-11e2-b667-080027bcf912">locality</value>


  		




  
  16505
  
    
              <value type="string" key="c6724820-a7a0-11e2-b667-080027bcf912">PRIMARY</value>


  		




  
  16506
  
    
              <value type="string" key="c6724e7e-a7a0-11e2-b667-080027bcf912">fk_place1_idx</value>


  		




  
  16507
  
    
              <value type="string" key="c67254b4-a7a0-11e2-b667-080027bcf912">fk_place_record1</value>


  		




  
  16508
  
    
              <value type="string" key="c6725784-a7a0-11e2-b667-080027bcf912">fk_place1</value>


  		




  
  16509
  
    
              <value type="string" key="c672743a-a7a0-11e2-b667-080027bcf912">event</value>


  		




  
  16510
  
    
              <value type="string" key="c67276b0-a7a0-11e2-b667-080027bcf912">id</value>


  		




  
  16511
  
    
              <value type="string" key="c672785e-a7a0-11e2-b667-080027bcf912">parent</value>


  		




  
  16512
  
    
              <value type="string" key="c6727a2a-a7a0-11e2-b667-080027bcf912">name</value>


  		




  
  16513
  
    
              <value type="string" key="c6727bce-a7a0-11e2-b667-080027bcf912">date_range</value>


  		




  
  16514
  
    
              <value type="string" key="c6727d54-a7a0-11e2-b667-080027bcf912">place</value>


  		




  
  16515
  
    
              <value type="string" key="c67280b0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>


  		




  
  16516
  
    
              <value type="string" key="c67283da-a7a0-11e2-b667-080027bcf912">fk_event_place1_idx</value>


  		




  
  16517
  
    
              <value type="string" key="c6728830-a7a0-11e2-b667-080027bcf912">fk_event1_idx</value>


  		




  
  16518
  
    
              <value type="string" key="c6729578-a7a0-11e2-b667-080027bcf912">fk_event_record1</value>


  		




  
  16519
  
    
              <value type="string" key="c672971c-a7a0-11e2-b667-080027bcf912">fk_event_place1</value>


  		




  
  16520
  
    
              <value type="string" key="c672994c-a7a0-11e2-b667-080027bcf912">fk_event1</value>


  		




  
  16521
  
    
              <value type="string" key="c672a8d8-a7a0-11e2-b667-080027bcf912">reobservable</value>


  		




  
  16522
  
    
              <value type="string" key="c672abda-a7a0-11e2-b667-080027bcf912">id</value>


  		




  
  16523
  
    
              <value type="string" key="c672b24c-a7a0-11e2-b667-080027bcf912">current_determination</value>


  		




  
  16524
  
    
              <value type="string" key="c672b418-a7a0-11e2-b667-080027bcf912">original_determination</value>


  		




  
  16525
  
    
              <value type="string" key="c672bda0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>


  		




  
  16526
  
    
              <value type="string" key="c672c0d4-a7a0-11e2-b667-080027bcf912">fk_taxon_occurrence_taxon_determination1_idx</value>


  		




  
  16527
  
    
              <value type="string" key="c672c52a-a7a0-11e2-b667-080027bcf912">fk_taxon_occurrence_taxon_determination2_idx</value>


  		




  
  16528
  
    
              <value type="string" key="c672cf2a-a7a0-11e2-b667-080027bcf912">fk_taxon_occurrence_taxon_determination1</value>


  		




  
  16529
  
    
              <value type="string" key="c672d2a4-a7a0-11e2-b667-080027bcf912">fk_taxon_occurrence_taxon_determination2</value>


  		




  
  16530
  
    
              <value type="string" key="c672d4ac-a7a0-11e2-b667-080027bcf912">fk_taxon_occurrence_event1</value>


  		




  
  16531
  
    
              <value type="string" key="c672f914-a7a0-11e2-b667-080027bcf912">specimen</value>


  		




  
  16532
  
    
              <value type="string" key="c672fb6c-a7a0-11e2-b667-080027bcf912">id</value>


  		




  
  16533
  
    
              <value type="string" key="c673038c-a7a0-11e2-b667-080027bcf912">owner_collection</value>


  		




  
  16534
  
    
              <value type="string" key="c6730896-a7a0-11e2-b667-080027bcf912">orig_collection</value>


  		




  
  16535
  
    
              <value type="string" key="c6730b98-a7a0-11e2-b667-080027bcf912">barcode</value>


  		




  
  16536
  
    
              <value type="string" key="c6730d78-a7a0-11e2-b667-080027bcf912">accession_number</value>


  		




  
  16537
  
    
              <value type="string" key="c6731048-a7a0-11e2-b667-080027bcf912">PRIMARY</value>


  		




  
  16538
  
    
              <value type="string" key="c6731534-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1_idx</value>


  		




  
  16539
  
    
              <value type="string" key="c6731a52-a7a0-11e2-b667-080027bcf912">fk_specimen_taxon_occurrence1</value>


  		




  
  16540
  
    
              <value type="string" key="c6731c28-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1</value>


  		




  
  16541
  
    
              <value type="string" key="c7a57ce0-a92a-11e2-93c8-080027bcf912">lat_long_in_place_ranks</value>


  		




  
  16542
  
    
              <value type="string" key="c7c1e6aa-a91b-11e2-bdec-080027bcf912">fk_source_party2</value>


  		




  
  16543
  
    
              <value type="string" key="c7c1e862-a91b-11e2-bdec-080027bcf912">first_publisher</value>


  		




  
  16544
  
    
              <value type="string" key="c7c2089c-a91b-11e2-bdec-080027bcf912">fk_source_party2_idx</value>


  		




  
  16545
  
    
              <value type="string" key="c8552934-a7bc-11e2-8af2-080027bcf912">fk_source_party1</value>


  		




  
  16546
  
    
              <value type="string" key="c8552b14-a7bc-11e2-8af2-080027bcf912">owner</value>


  		




  
  16547
  
    
              <value type="string" key="c8554edc-a7bc-11e2-8af2-080027bcf912">fk_source_party1_idx</value>


  		




  
  16548
  
    
              <value type="string" key="c8868c00-a793-11e2-84c3-080027bcf912">info</value>


  		




  
  16549
  
    
              <value type="string" key="cfea1514-a790-11e2-84c3-080027bcf912">x_m</value>


  		




  
  16550
  
    
              <value type="string" key="d009232a-f671-11e2-9716-080027bcf912">tag_history</value>


  		




  
  16551
  
    
              <value type="string" key="d0d97d8a-f6c7-11e2-a35e-080027bcf912">coords</value>


  		




  
  16552
  
    
              <value type="string" key="d2081100-f959-11e2-8597-080027bcf912">fk_taxon_presence_taxon_determination1</value>


  		




  
  16553
  
    
              <value type="string" key="d2b2ccf6-a794-11e2-84c3-080027bcf912">elevation_m</value>


  		




  
  16554
  
    
              <value type="string" key="d5a68396-f959-11e2-8597-080027bcf912">fk_taxon_absence_taxon_determination1</value>


  		




  
  16555
  
    
              <value type="string" key="d6b1b62e-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>


  		




  
  16556
  
    
              <value type="string" key="d72de448-ad19-11e2-9d85-080027bcf912">traits</value>


  		




  
  16557
  
    
              <value type="string" key="d9b5781e-a90b-11e2-8576-080027bcf912">name</value>


  		




  
  16558
  
    
              <value type="string" key="dbe10c36-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1</value>


  		




  
  16559
  
    
              <value type="string" key="dbe121f8-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1_idx</value>


  		




  
  16560
  
    
              <value type="string" key="dc8d1c42-ad19-11e2-9d85-080027bcf912">traits</value>


  		




  
  16561
  
    
              <value type="string" key="dda7bbf8-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2</value>


  		




  
  16562
  
    
              <value type="string" key="dda7bdec-0072-11e3-906b-080027bcf912">parent_event</value>


  		




  
  16563
  
    
              <value type="string" key="dda7d480-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2_idx</value>


  		




  
  16564
  
    
              <value type="string" key="e5155806-a793-11e2-84c3-080027bcf912">info</value>


  		




  
  16565
  
    
              <value type="string" key="e550209e-f676-11e2-9716-080027bcf912">fk_party_organization1</value>


  		




  
  16566
  
    
              <value type="string" key="e5502346-f676-11e2-9716-080027bcf912">organization</value>


  		




  
  16567
  
    
              <value type="string" key="e550389a-f676-11e2-9716-080027bcf912">fk_party_organization1_idx</value>


  		




  
  16568
  
    
              <value type="string" key="e5d27f54-a792-11e2-84c3-080027bcf912">info</value>


  		




  
  16569
  
    
              <value type="string" key="ea3bec44-acef-11e2-bdae-080027bcf912">source_id_scope</value>


  		




  
  16570
  
    
              <value type="string" key="eb778868-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1</value>


  		




  
  16571
  
    
              <value type="string" key="eb778aac-ad01-11e2-b309-080027bcf912">collection_event</value>


  		




  
  16572
  
    
              <value type="string" key="eb77b1da-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1_idx</value>


  		




  
  16573
  
    
              <value type="string" key="ec1f6aa2-f6c5-11e2-a35e-080027bcf912">shape</value>


  		




  
  16574
  
    
              <value type="string" key="ec6965f0-a925-11e2-acee-080027bcf912">fk_specimen_organization3</value>


  		




  
  16575
  
    
              <value type="string" key="ed1eb2a6-ad0e-11e2-b309-080027bcf912">fk_collection_organization1</value>


  		




  
  16576
  
    
              <value type="string" key="ed1eb468-ad0e-11e2-b309-080027bcf912">institution</value>


  		




  
  16577
  
    
              <value type="string" key="ed1ec98a-ad0e-11e2-b309-080027bcf912">fk_collection_organization1_idx</value>


  		




  
  16578
  
    
              <value type="string" key="f62bfaf6-a797-11e2-8681-080027bcf912">fk_stem_observation_individual_observation2</value>


  		




  
  16579
  
    
              <value type="string" key="f903388e-0084-11e3-ac06-080027bcf912">reobservable_presence</value>


  		




  
  16580
  
    
              <value type="string" key="f9033c9e-0084-11e3-ac06-080027bcf912">id</value>


  		




  
  16581
  
    
              <value type="string" key="f903400e-0084-11e3-ac06-080027bcf912">voucher</value>


  		




  
  16582
  
    
              <value type="string" key="f903472a-0084-11e3-ac06-080027bcf912">PRIMARY</value>


  		




  
  16583
  
    
              <value type="string" key="fbf69d1e-a79d-11e2-a346-080027bcf912">record_unique</value>


  		




  
  16584
  
    
              <value type="string" key="fc6fbbae-f96e-11e2-9f36-080027bcf912">geoplace</value>


  		




  
  16585
  
    
            </value>


  		




  
  16586
  
    
            <value type="string" key="lastSyncDate"></value>


  		




  
  16587
  
    
            <value type="string" key="name"></value>


  		




  
  16588
  
    
          </value>


  		




  
  16589
  
    
        </value>


  		




  16049
  16590
  
    
        <value _ptr_="0xbd65370" type="list" content-type="object" content-struct-name="GrtObject" key="tagCategories"/>


  		




  16050
  16591
  
    
        <value _ptr_="0xbd653a0" type="list" content-type="object" content-struct-name="meta.Tag" key="tags"/>


  		




  16051
  16592
  
    
        <link type="object" struct-name="model.Diagram" key="currentDiagram">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  ......




  16128
  16669
  
    
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">


  		




  16129
  16670
  
    
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>


  		




  16130
  16671
  
    
      <value type="string" key="caption">New Model</value>


  		




  16131
  
  
    
      <value type="string" key="dateChanged">2013-08-09 10:14</value>


  		




  
  16672
  
    
      <value type="string" key="dateChanged">2013-08-09 10:36</value>


  		




  16132
  16673
  
    
      <value type="string" key="dateCreated">2012-01-19 14:06</value>


  		




  16133
  16674
  
    
      <value type="string" key="description"></value>


  		




  16134
  16675
  
    
      <value type="string" key="project">Name of the project</value>


  		












  

    
      schemas/VegCore/VegCore.my.sql
    
  





  24
  24
  
    
USE `VegCore`;


  		




  25
  25
  
    

  		




  26
  26
  
    
--


  		




  27
  
  
    
-- Table structure for table `aggregate_observation`


  		




  28
  
  
    
--


  		




  29
  
  
    

  		




  30
  
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




  31
  
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  32
  
  
    
CREATE TABLE `aggregate_observation` (


  		




  33
  
  
    
  `id` varbinary(767) NOT NULL,


  		




  34
  
  
    
  `taxon` varbinary(767) NOT NULL,


  		




  35
  
  
    
  `size_class` varbinary(767) DEFAULT NULL,


  		




  36
  
  
    
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  37
  
  
    
  PRIMARY KEY (`id`),


  		




  38
  
  
    
  KEY `fk_aggregate_observation_taxon_presence1_idx` (`taxon`),


  		




  39
  
  
    
  KEY `fk_aggregate_observation_size_class1_idx` (`size_class`),


  		




  40
  
  
    
  CONSTRAINT `fk_aggregate_observation_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  41
  
  
    
  CONSTRAINT `fk_aggregate_observation_size_class1` FOREIGN KEY (`size_class`) REFERENCES `size_class` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  42
  
  
    
  CONSTRAINT `fk_aggregate_observation_taxon_presence1` FOREIGN KEY (`taxon`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  43
  
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= stemCount.VegBank.vegpath.org';


  		




  44
  
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  45
  
  
    

  		




  46
  
  
    
--


  		




  47
  
  
    
-- Dumping data for table `aggregate_observation`


  		




  48
  
  
    
--


  		




  49
  
  
    

  		




  50
  
  
    
/*!40000 ALTER TABLE `aggregate_observation` DISABLE KEYS */;


  		




  51
  
  
    
/*!40000 ALTER TABLE `aggregate_observation` ENABLE KEYS */;


  		




  52
  
  
    

  		




  53
  
  
    
--


  		




  54
  27
  
    
-- Table structure for table `base_class`


  		




  55
  28
  
    
--


  		




  56
  29
  
    

  		




  ......




  350
  323
  
    
/*!40000 ALTER TABLE `individual` ENABLE KEYS */;


  		




  351
  324
  
    

  		




  352
  325
  
    
--


  		




  
  326
  
    
-- Table structure for table `individual_count`


  		




  
  327
  
    
--


  		




  
  328
  
    

  		




  
  329
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




  
  330
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  
  331
  
    
CREATE TABLE `individual_count` (


  		




  
  332
  
    
  `id` varbinary(767) NOT NULL,


  		




  
  333
  
    
  `taxon` varbinary(767) NOT NULL,


  		




  
  334
  
    
  `size_class` varbinary(767) DEFAULT NULL,


  		




  
  335
  
    
  `aggregating_traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  
  336
  
    
  `count` int(11) DEFAULT NULL,


  		




  
  337
  
    
  PRIMARY KEY (`id`),


  		




  
  338
  
    
  KEY `fk_aggregate_observation_taxon_presence1_idx` (`taxon`),


  		




  
  339
  
    
  KEY `fk_aggregate_observation_size_class1_idx` (`size_class`),


  		




  
  340
  
    
  CONSTRAINT `fk_aggregate_observation_size_class1` FOREIGN KEY (`size_class`) REFERENCES `size_class` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  341
  
    
  CONSTRAINT `fk_aggregate_observation_taxon_presence1` FOREIGN KEY (`taxon`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  342
  
    
  CONSTRAINT `fk_aggregate_observation_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  343
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= stemCount.VegBank.vegpath.org';


  		




  
  344
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  345
  
    

  		




  
  346
  
    
--


  		




  
  347
  
    
-- Dumping data for table `individual_count`


  		




  
  348
  
    
--


  		




  
  349
  
    

  		




  
  350
  
    
/*!40000 ALTER TABLE `individual_count` DISABLE KEYS */;


  		




  
  351
  
    
/*!40000 ALTER TABLE `individual_count` ENABLE KEYS */;


  		




  
  352
  
    

  		




  
  353
  
    
--


  		




  353
  354
  
    
-- Table structure for table `individual_observation`


  		




  354
  355
  
    
--


  		




  355
  356
  
    

  		




  ......




  1267
  1268
  
    
CREATE TABLE `taxon_presence` (


  		




  1268
  1269
  
    
  `id` varbinary(767) NOT NULL,


  		




  1269
  1270
  
    
  `occurrence_status` varbinary(767) DEFAULT NULL,


  		




  
  1271
  
    
  `cover_percent` double DEFAULT NULL,


  		




  1270
  1272
  
    
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  1271
  1273
  
    
  PRIMARY KEY (`id`),


  		




  1272
  1274
  
    
  CONSTRAINT `fk_taxon_presence_taxon_determination1` FOREIGN KEY (`id`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		












Also available in:  Unified diff