Project

General

Profile

« Previous | Next » 

Revision 10526

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/VegCore/VegCore.ERD.mwb: rel_place: renamed to subplace to clarify that this is any place contained within another place, not just places with a position relative to their parent place

View differences:

schemas/VegCore/VegCore.pg.sql
301 301 
  "tag_history" hstore DEFAULT NULL,
302 302 
  PRIMARY KEY ("id"),
303 303 
  /*KEY "fk_individual_place1_idx" ("place")*/CHECK (true),
304 
  /*CONSTRAINT "fk_individual_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
305 
  /*CONSTRAINT "fk_individual_record1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
304 
  /*CONSTRAINT "fk_individual_record1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
305 
  /*CONSTRAINT "fk_individual_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
306 306 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism'*/;
307 307 
/*!40101 SET character_set_client = @saved_cs_client */;
308 308 

  		




  ......




  613
  613
  
    
/*!40000 ALTER TABLE "referenced_class" ENABLE KEYS */;


  		




  614
  614
  
    

  		




  615
  615
  
    
--


  		




  616
  
  
    
-- Table structure for table "rel_place"


  		




  617
  
  
    
--


  		




  618
  
  
    

  		




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


  		




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


  		




  621
  
  
    
CREATE TABLE "rel_place" (


  		




  622
  
  
    
  "id" text NOT NULL,


  		




  623
  
  
    
  "parent" text NOT NULL,


  		




  624
  
  
    
  "x_m" double precision DEFAULT NULL,


  		




  625
  
  
    
  "y_m" double precision DEFAULT NULL,


  		




  626
  
  
    
  "coords" hstore DEFAULT NULL,


  		




  627
  
  
    
  PRIMARY KEY ("id"),


  		




  628
  
  
    
  /*KEY "fk_rel_place_place1_idx" ("parent")*/CHECK (true),


  		




  629
  
  
    
  /*CONSTRAINT "fk_rel_place_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  630
  
  
    
  /*CONSTRAINT "fk_subplot_place2" FOREIGN KEY ("id") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  631
  
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))'*/;


  		




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


  		




  633
  
  
    

  		




  634
  
  
    
--


  		




  635
  
  
    
-- Dumping data for table "rel_place"


  		




  636
  
  
    
--


  		




  637
  
  
    

  		




  638
  
  
    
/*!40000 ALTER TABLE "rel_place" DISABLE KEYS */;


  		




  639
  
  
    
/*!40000 ALTER TABLE "rel_place" ENABLE KEYS */;


  		




  640
  
  
    

  		




  641
  
  
    
--


  		




  642
  616
  
    
-- Table structure for table "relationship"


  		




  643
  617
  
    
--


  		




  644
  618
  
    

  		




  ......




  933
  907
  
    
/*!40000 ALTER TABLE "stratum" ENABLE KEYS */;


  		




  934
  908
  
    

  		




  935
  909
  
    
--


  		




  
  910
  
    
-- Table structure for table "subplace"


  		




  
  911
  
    
--


  		




  
  912
  
    

  		




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


  		




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


  		




  
  915
  
    
CREATE TABLE "subplace" (


  		




  
  916
  
    
  "id" text NOT NULL,


  		




  
  917
  
    
  "parent" text NOT NULL,


  		




  
  918
  
    
  "x_m" double precision DEFAULT NULL,


  		




  
  919
  
    
  "y_m" double precision DEFAULT NULL,


  		




  
  920
  
    
  "coords" hstore DEFAULT NULL,


  		




  
  921
  
    
  PRIMARY KEY ("id"),


  		




  
  922
  
    
  /*KEY "fk_rel_place_place1_idx" ("parent")*/CHECK (true),


  		




  
  923
  
    
  /*CONSTRAINT "fk_subplot_place2" FOREIGN KEY ("id") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  924
  
    
  /*CONSTRAINT "fk_rel_place_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  925
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))'*/;


  		




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


  		




  
  927
  
    

  		




  
  928
  
    
--


  		




  
  929
  
    
-- Dumping data for table "subplace"


  		




  
  930
  
    
--


  		




  
  931
  
    

  		




  
  932
  
    
/*!40000 ALTER TABLE "subplace" DISABLE KEYS */;


  		




  
  933
  
    
/*!40000 ALTER TABLE "subplace" ENABLE KEYS */;


  		




  
  934
  
    

  		




  
  935
  
    
--


  		




  936
  936
  
    
-- Table structure for table "subplot"


  		




  937
  937
  
    
--


  		




  938
  938
  
    

  		




  ......




  943
  943
  
    
  "parent_plot" text NOT NULL,


  		




  944
  944
  
    
  PRIMARY KEY ("id"),


  		




  945
  945
  
    
  /*KEY "fk_subplot_plot2_idx" ("parent_plot")*/CHECK (true),


  		




  
  946
  
    
  /*CONSTRAINT "fk_subplot_plot1" FOREIGN KEY ("id") REFERENCES "plot" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  946
  947
  
    
  /*CONSTRAINT "fk_subplot_plot2" FOREIGN KEY ("parent_plot") REFERENCES "plot" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  947
  
  
    
  /*CONSTRAINT "fk_subplot_rel_place1" FOREIGN KEY ("id") REFERENCES "rel_place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  948
  
  
    
  /*CONSTRAINT "fk_subplot_plot1" FOREIGN KEY ("id") REFERENCES "plot" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  948
  
    
  /*CONSTRAINT "fk_subplot_rel_place1" FOREIGN KEY ("id") REFERENCES "subplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  949
  949
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




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


  		




  951
  951
  
    

  		












  

    
      schemas/VegCore/document.mwb.xml
    
  





  1838
  1838
  
    
                      <value type="int" key="isPrimary">0</value>


  		




  1839
  1839
  
    
                      <value type="string" key="name">fk_individual_place1_idx</value>


  		




  1840
  1840
  
    
                      <value type="int" key="unique">0</value>


  		




  1841
  
  
    
                      <value type="string" key="oldName">fk_individual_place1</value>


  		




  
  1841
  
    
                      <value type="string" key="oldName">fk_individual_place1_idx</value>


  		




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


  		




  1843
  1843
  
    
                    </value>


  		




  1844
  1844
  
    
                  </value>


  		




  ......




  5826
  5826
  
    
                  <value type="int" key="commentedOut">0</value>


  		




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


  		




  5828
  5828
  
    
                  <value _ptr_="0xbcf2a70" type="dict" key="customData"/>


  		




  5829
  
  
    
                  <value type="string" key="lastChangeDate">2013-07-31 02:39</value>


  		




  
  5829
  
    
                  <value type="string" key="lastChangeDate">2013-07-31 03:05</value>


  		




  5830
  5830
  
    
                  <value type="int" key="modelOnly">0</value>


  		




  5831
  
  
    
                  <value type="string" key="name">rel_place</value>


  		




  
  5831
  
    
                  <value type="string" key="name">subplace</value>


  		




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


  		




  5833
  5833
  
    
                  <value type="string" key="temp_sql"></value>


  		




  5834
  5834
  
    
                  <value type="string" key="comment">stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))</value>


  		




  ......




  13387
  13387
  
    
                <value type="int" key="expanded">1</value>


  		




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


  		




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


  		




  13390
  
  
    
                <value type="real" key="left">6.94e+02</value>


  		




  
  13390
  
    
                <value type="real" key="left">6.93e+02</value>


  		




  13391
  13391
  
    
                <value type="int" key="locked">0</value>


  		




  13392
  13392
  
    
                <value type="int" key="manualSizing">0</value>


  		




  13393
  
  
    
                <value type="real" key="top">3.5e+01</value>


  		




  
  13393
  
    
                <value type="real" key="top">4.4e+01</value>


  		




  13394
  13394
  
    
                <value type="real" key="width">1.02e+02</value>


  		




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


  		




  13396
  13396
  
    
                <value type="int" key="visible">1</value>


  		




  13397
  
  
    
                <value type="string" key="name">rel_place</value>


  		




  
  13397
  
    
                <value type="string" key="name">subplace</value>


  		




  13398
  13398
  
    
              </value>


  		




  13399
  13399
  
    
              <value type="object" struct-name="workbench.physical.TableFigure" id="8EACA0D2-66A0-4E36-B59C-E8F7594BE004" struct-checksum="0x3b14eccb">


  		




  13400
  13400
  
    
                <value type="int" key="columnsExpanded">1</value>


  		




  ......




  14053
  14053
  
    
                <value type="int" key="expanded">1</value>


  		




  14054
  14054
  
    
                <value type="real" key="height">2.38e+02</value>


  		




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


  		




  14056
  
  
    
                <value type="real" key="left">6.01e+02</value>


  		




  
  14056
  
    
                <value type="real" key="left">6.e+02</value>


  		




  14057
  14057
  
    
                <value type="int" key="locked">0</value>


  		




  14058
  14058
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14059
  
  
    
                <value type="real" key="top">2.02e+02</value>


  		




  
  14059
  
    
                <value type="real" key="top">2.11e+02</value>


  		




  14060
  14060
  
    
                <value type="real" key="width">1.25e+02</value>


  		




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


  		




  14062
  14062
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  14606
  14606
  
    
                <value type="int" key="expanded">1</value>


  		




  14607
  14607
  
    
                <value type="real" key="height">7.7e+01</value>


  		




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


  		




  14609
  
  
    
                <value type="real" key="left">6.75e+02</value>


  		




  
  14609
  
    
                <value type="real" key="left">6.74e+02</value>


  		




  14610
  14610
  
    
                <value type="int" key="locked">0</value>


  		




  14611
  14611
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14612
  
  
    
                <value type="real" key="top">4.88e+02</value>


  		




  
  14612
  
    
                <value type="real" key="top">5.e+02</value>


  		




  14613
  14613
  
    
                <value type="real" key="width">9.3e+01</value>


  		




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


  		




  14615
  14615
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  14763
  14763
  
    
        <value _ptr_="0xbcb0438" type="list" content-type="object" content-struct-name="GrtStoredNote" key="notes"/>


  		




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


  		




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


  		




  14766
  
  
    
        <value _ptr_="0xb3ffba8" type="dict" key="syncProfiles"/>


  		




  
  14766
  
    
        <value _ptr_="0xb3ffba8" type="dict" key="syncProfiles">


  		




  
  14767
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="5dbadd9a-f9c8-11e2-b815-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  
  14768
  
    
            <value _ptr_="0xca70f00" type="dict" key="lastKnownDBNames">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  14821
  
    
              <value type="string" key="1cc7051e-f6be-11e2-af44-080027bcf912">fk_aggregate_observation_taxon_presence1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  14847
  
    
              <value type="string" key="3730d234-a7ab-11e2-8ba6-080027bcf912">voucher</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  14908
  
    
              <value type="string" key="523d3e7a-f96b-11e2-9fb4-080027bcf912">fk_geoplace_geoplace1</value>


  		




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


  		




  
  14910
  
    
              <value type="string" key="523e1160-f96b-11e2-9fb4-080027bcf912">fk_geoplace_geoplace1_idx</value>


  		




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


  		




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


  		




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


  		




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


  		




  
  14915
  
    
              <value type="string" key="565fd9e8-a7ab-11e2-8ba6-080027bcf912">fk_taxon_observation_specimen1</value>


  		




  
  14916
  
    
              <value type="string" key="565fe000-a7ab-11e2-8ba6-080027bcf912">fk_taxon_observation_specimen1_idx</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  15104
  
    
              <value type="string" key="be8f60ea-a6e0-11e2-95e9-080027bcf912">fk_soil_observation_place_observation1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  15206
  
    
              <value type="string" key="eaefe558-f6c0-11e2-af44-080027bcf912">fk_place_observation_sampling_event1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  15216
  
    
              <value type="string" key="f6c9182a-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_record1</value>


  		




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


  		




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


  		




  
  15219
  
    
              <value type="string" key="ff7f1558-a791-11e2-84c3-080027bcf912">name</value>


  		




  
  15220
  
    
            </value>


  		




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


  		




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


  		




  
  15223
  
    
          </value>


  		




  
  15224
  
    
        </value>


  		




  14767
  15225
  
    
        <value _ptr_="0xbcb0498" type="list" content-type="object" content-struct-name="GrtObject" key="tagCategories"/>


  		




  14768
  15226
  
    
        <value _ptr_="0xbcb04c8" type="list" content-type="object" content-struct-name="meta.Tag" key="tags"/>


  		




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


  		




  ......




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


  		




  14847
  15305
  
    
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>


  		




  14848
  15306
  
    
      <value type="string" key="caption">New Model</value>


  		




  14849
  
  
    
      <value type="string" key="dateChanged">2013-07-31 03:02</value>


  		




  
  15307
  
    
      <value type="string" key="dateChanged">2013-07-31 03:06</value>


  		




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


  		




  14851
  15309
  
    
      <value type="string" key="description"></value>


  		




  14852
  15310
  
    
      <value type="string" key="project">Name of the project</value>


  		












  

    
      schemas/VegCore/VegCore.my.sql
    
  





  299
  299
  
    
  `tag_history` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  300
  300
  
    
  PRIMARY KEY (`id`),


  		




  301
  301
  
    
  KEY `fk_individual_place1_idx` (`place`),


  		




  302
  
  
    
  CONSTRAINT `fk_individual_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  303
  
  
    
  CONSTRAINT `fk_individual_record1` FOREIGN KEY (`id`) REFERENCES `reobservable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  302
  
    
  CONSTRAINT `fk_individual_record1` FOREIGN KEY (`id`) REFERENCES `reobservable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  303
  
    
  CONSTRAINT `fk_individual_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  304
  304
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism';


  		




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


  		




  306
  306
  
    

  		




  ......




  611
  611
  
    
/*!40000 ALTER TABLE `referenced_class` ENABLE KEYS */;


  		




  612
  612
  
    

  		




  613
  613
  
    
--


  		




  614
  
  
    
-- Table structure for table `rel_place`


  		




  615
  
  
    
--


  		




  616
  
  
    

  		




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


  		




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


  		




  619
  
  
    
CREATE TABLE `rel_place` (


  		




  620
  
  
    
  `id` varbinary(767) NOT NULL,


  		




  621
  
  
    
  `parent` varbinary(767) NOT NULL,


  		




  622
  
  
    
  `x_m` double DEFAULT NULL,


  		




  623
  
  
    
  `y_m` double DEFAULT NULL,


  		




  624
  
  
    
  `coords` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  625
  
  
    
  PRIMARY KEY (`id`),


  		




  626
  
  
    
  KEY `fk_rel_place_place1_idx` (`parent`),


  		




  627
  
  
    
  CONSTRAINT `fk_rel_place_place1` FOREIGN KEY (`parent`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  628
  
  
    
  CONSTRAINT `fk_subplot_place2` FOREIGN KEY (`id`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  629
  
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))';


  		




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


  		




  631
  
  
    

  		




  632
  
  
    
--


  		




  633
  
  
    
-- Dumping data for table `rel_place`


  		




  634
  
  
    
--


  		




  635
  
  
    

  		




  636
  
  
    
/*!40000 ALTER TABLE `rel_place` DISABLE KEYS */;


  		




  637
  
  
    
/*!40000 ALTER TABLE `rel_place` ENABLE KEYS */;


  		




  638
  
  
    

  		




  639
  
  
    
--


  		




  640
  614
  
    
-- Table structure for table `relationship`


  		




  641
  615
  
    
--


  		




  642
  616
  
    

  		




  ......




  931
  905
  
    
/*!40000 ALTER TABLE `stratum` ENABLE KEYS */;


  		




  932
  906
  
    

  		




  933
  907
  
    
--


  		




  
  908
  
    
-- Table structure for table `subplace`


  		




  
  909
  
    
--


  		




  
  910
  
    

  		




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


  		




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


  		




  
  913
  
    
CREATE TABLE `subplace` (


  		




  
  914
  
    
  `id` varbinary(767) NOT NULL,


  		




  
  915
  
    
  `parent` varbinary(767) NOT NULL,


  		




  
  916
  
    
  `x_m` double DEFAULT NULL,


  		




  
  917
  
    
  `y_m` double DEFAULT NULL,


  		




  
  918
  
    
  `coords` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  
  919
  
    
  PRIMARY KEY (`id`),


  		




  
  920
  
    
  KEY `fk_rel_place_place1_idx` (`parent`),


  		




  
  921
  
    
  CONSTRAINT `fk_subplot_place2` FOREIGN KEY (`id`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  922
  
    
  CONSTRAINT `fk_rel_place_place1` FOREIGN KEY (`parent`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  923
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))';


  		




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


  		




  
  925
  
    

  		




  
  926
  
    
--


  		




  
  927
  
    
-- Dumping data for table `subplace`


  		




  
  928
  
    
--


  		




  
  929
  
    

  		




  
  930
  
    
/*!40000 ALTER TABLE `subplace` DISABLE KEYS */;


  		




  
  931
  
    
/*!40000 ALTER TABLE `subplace` ENABLE KEYS */;


  		




  
  932
  
    

  		




  
  933
  
    
--


  		




  934
  934
  
    
-- Table structure for table `subplot`


  		




  935
  935
  
    
--


  		




  936
  936
  
    

  		




  ......




  941
  941
  
    
  `parent_plot` varbinary(767) NOT NULL,


  		




  942
  942
  
    
  PRIMARY KEY (`id`),


  		




  943
  943
  
    
  KEY `fk_subplot_plot2_idx` (`parent_plot`),


  		




  
  944
  
    
  CONSTRAINT `fk_subplot_plot1` FOREIGN KEY (`id`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  944
  945
  
    
  CONSTRAINT `fk_subplot_plot2` FOREIGN KEY (`parent_plot`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  945
  
  
    
  CONSTRAINT `fk_subplot_rel_place1` FOREIGN KEY (`id`) REFERENCES `rel_place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  946
  
  
    
  CONSTRAINT `fk_subplot_plot1` FOREIGN KEY (`id`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  946
  
    
  CONSTRAINT `fk_subplot_rel_place1` FOREIGN KEY (`id`) REFERENCES `subplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  947
  947
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




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


  		




  949
  949
  
    

  		












Also available in:  Unified diff