Project

General

Profile

« Previous | Next » 

Revision 11213

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: place_observation: renamed to place_visit for clarity, since other tables that point to this use it as a general container, not just a link to the observations about the place

View differences:

schemas/VegCore/ERD/document.mwb.xml
5833 5833 
                      <value type="int" key="scale">-1</value>
5834 5834 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5835 5835 
                      <value type="string" key="comment"></value>
5836 
                      <value type="string" key="name">place_observation</value>
5836 
                      <value type="string" key="name">place_visit</value>
5837 5837 
                      <value type="string" key="oldName">place_observation</value>
5838 5838 
                      <link type="object" struct-name="GrtObject" key="owner">be8f58b6-a6e0-11e2-95e9-080027bcf912</link>
5839 5839 
                    </value>
......
6045 6045 
                  <value type="int" key="commentedOut">0</value>
6046 6046 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
6047 6047 
                  <value _ptr_="0xb9ca538" type="dict" key="customData"/>
6048 
                  <value type="string" key="lastChangeDate">2013-08-08 17:32</value>
6048 
                  <value type="string" key="lastChangeDate">2013-10-09 16:18</value>
6049 6049 
                  <value type="int" key="modelOnly">0</value>
6050 6050 
                  <value type="string" key="name">soil_observation</value>
6051 6051 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
8665 8665 
                  <value type="int" key="commentedOut">0</value>
8666 8666 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
8667 8667 
                  <value _ptr_="0xb9ee508" type="dict" key="customData"/>
8668 
                  <value type="string" key="lastChangeDate">2013-10-09 16:01</value>
8668 
                  <value type="string" key="lastChangeDate">2013-10-09 16:18</value>
8669 8669 
                  <value type="int" key="modelOnly">0</value>
8670 
                  <value type="string" key="name">place_observation</value>
8670 
                  <value type="string" key="name">place_visit</value>
8671 8671 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
8672 8672 
                  <value type="string" key="temp_sql"></value>
8673 8673 
                  <value type="string" key="comment">A sampling of a [[VegCore#Location|Location]]. = VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?observation (which was confusingly named) + VegBank.vegpath.org?plot (which is actually 1:1 with observation)</value>
......
10690 10690 
                      <value type="int" key="scale">-1</value>
10691 10691 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
10692 10692 
                      <value type="string" key="comment"></value>
10693 
                      <value type="string" key="name">place_observation</value>
10693 
                      <value type="string" key="name">place_visit</value>
10694 10694 
                      <value type="string" key="oldName">place_observation</value>
10695 10695 
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10696 10696 
                    </value>
......
10881 10881 
                      <value type="int" key="isPrimary">0</value>
10882 10882 
                      <value type="string" key="name">taxa_sampling_event__unique</value>
10883 10883 
                      <value type="int" key="unique">1</value>
10884 
                      <value type="string" key="oldName"></value>
10884 
                      <value type="string" key="oldName">taxa_sampling_event__unique</value>
10885 10885 
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10886 10886 
                    </value>
10887 10887 
                  </value>
......
10915 10915 
                  <value type="int" key="commentedOut">0</value>
10916 10916 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
10917 10917 
                  <value _ptr_="0xba11248" type="dict" key="customData"/>
10918 
                  <value type="string" key="lastChangeDate">2013-10-09 16:04</value>
10918 
                  <value type="string" key="lastChangeDate">2013-10-09 16:18</value>
10919 10919 
                  <value type="int" key="modelOnly">0</value>
10920 10920 
                  <value type="string" key="name">taxa_sampling_event</value>
10921 10921 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
11608 11608 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
11609 11609 
                  <value type="string" key="temp_sql"></value>
11610 11610 
                  <value type="string" key="comment">= VegBank.vegpath.org?stratumType</value>
11611 
                  <value type="string" key="oldName">layer</value>
11611 
                  <value type="string" key="oldName">stratum</value>
11612 11612 
                </value>
11613 11613 
                <value type="object" struct-name="db.mysql.Table" id="7afebdc8-0075-11e3-906b-080027bcf912" struct-checksum="0x1a403946">
11614 11614 
                  <value type="string" key="avgRowLength"></value>
......
15180 15180 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15181 15181 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15182 15182 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">07e2f24c-1dde-11e3-bd5f-080027bcf912</link>
15183 
                <value type="real" key="middleSegmentOffset">-6.0766011412909165301243774592876434326171875e+01</value>
15183 
                <value type="real" key="middleSegmentOffset">-5.75351215338697556944680400192737579345703125e+01</value>
15184 15184 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15185 15185 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15186 15186 
                <value type="int" key="drawSplit">0</value>
......
16075 16075 
                <value type="int" key="locked">0</value>
16076 16076 
                <value type="int" key="manualSizing">0</value>
16077 16077 
                <value type="real" key="top">8.72e+02</value>
16078 
                <value type="real" key="width">1.55e+02</value>
16078 
                <value type="real" key="width">1.34e+02</value>
16079 16079 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16080 16080 
                <value type="int" key="visible">1</value>
16081 
                <value type="string" key="name">place_observation</value>
16081 
                <value type="string" key="name">place_visit</value>
16082 16082 
              </value>
16083 16083 
              <value type="object" struct-name="workbench.physical.TableFigure" id="B61D4BD4-43FB-4E3D-B257-6991B484B1FB" struct-checksum="0x3b14eccb">
16084 16084 
                <value type="int" key="columnsExpanded">1</value>
......
17583 17583 
              <value type="int" key="visible">1</value>
17584 17584 
              <value type="string" key="name"></value>
17585 17585 
            </value>
17586 
            <value _ptr_="0xba36528" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17586 
            <value _ptr_="0xba36528" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17587 
              <link type="object">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
17588 
            </value>
17587 17589 
            <value type="int" key="updateBlocked">0</value>
17588 17590 
            <value type="real" key="width">1.6215e+03</value>
17589 17591 
            <value type="real" key="x">0.e+00</value>
......
17595 17597 
        <value _ptr_="0xb986d28" type="list" content-type="object" content-struct-name="GrtStoredNote" key="notes"/>
17596 17598 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17597 17599 
        <value _ptr_="0xb986d58" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17598 
        <value _ptr_="0xb1a9c10" type="dict" key="syncProfiles"/>
17600 
        <value _ptr_="0xb1a9c10" type="dict" key="syncProfiles">
17601 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="627cc12a-3138-11e3-aa43-080027bcf912" struct-checksum="0xc64972c2" key="">
17602 
            <value _ptr_="0xca6b780" type="dict" key="lastKnownDBNames">
17603 
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17604 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17605 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17606 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
17607 
              <value type="string" key="04149c40-fa90-11e2-83d9-080027bcf912">official_name</value>
17608 
              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>
17609 
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>
17610 
              <value type="string" key="049e0370-a91b-11e2-bdec-080027bcf912">PRIMARY</value>
17611 
              <value type="string" key="07e2f24c-1dde-11e3-bd5f-080027bcf912">fk_taxon_observation_taxa_sampling_event1</value>
17612 
              <value type="string" key="07e2f45e-1dde-11e3-bd5f-080027bcf912">sampling_event</value>
17613 
              <value type="string" key="07e3e7c4-1dde-11e3-bd5f-080027bcf912">fk_taxon_observation_taxa_sampling_event1_idx</value>
17614 
              <value type="string" key="08481eda-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>
17615 
              <value type="string" key="08483334-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>
17616 
              <value type="string" key="09a29b5c-1dd2-11e3-b98c-080027bcf912">fk_taxon_occurrence_place1</value>
17617 
              <value type="string" key="09a29d14-1dd2-11e3-b98c-080027bcf912">within_place</value>
17618 
              <value type="string" key="09a2b70e-1dd2-11e3-b98c-080027bcf912">fk_taxon_occurrence_place1_idx</value>
17619 
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">boundary_WKT</value>
17620 
              <value type="string" key="0ab9880e-a7a1-11e2-b667-080027bcf912">individual_observation</value>
17621 
              <value type="string" key="0ab98a66-a7a1-11e2-b667-080027bcf912">id</value>
17622 
              <value type="string" key="0ab98c50-a7a1-11e2-b667-080027bcf912">subject</value>
17623 
              <value type="string" key="0ab99006-a7a1-11e2-b667-080027bcf912">PRIMARY</value>
17624 
              <value type="string" key="0ab99376-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1_idx</value>
17625 
              <value type="string" key="0ab99696-a7a1-11e2-b667-080027bcf912">fk_individual_observation_taxon_occurrence1</value>
17626 
              <value type="string" key="0ab99812-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1</value>
17627 
              <value type="string" key="0cec3fce-29ae-11e3-a980-080027bcf912">traceable__id_by_source</value>
17628 
              <value type="string" key="0de39e86-1dec-11e3-b571-080027bcf912">record</value>
17629 
              <value type="string" key="0de3a2aa-1dec-11e3-b571-080027bcf912">id</value>
17630 
              <value type="string" key="0de3a61a-1dec-11e3-b571-080027bcf912">scoping_dataset</value>
17631 
              <value type="string" key="0de3ab06-1dec-11e3-b571-080027bcf912">id_within_dataset</value>
17632 
              <value type="string" key="0de3afc0-1dec-11e3-b571-080027bcf912">fk_record_source10</value>
17633 
              <value type="string" key="0de3b22c-1dec-11e3-b571-080027bcf912">PRIMARY</value>
17634 
              <value type="string" key="0de3b510-1dec-11e3-b571-080027bcf912">record_unique</value>
17635 
              <value type="string" key="0de3ba38-1dec-11e3-b571-080027bcf912">fk_record_source1_idx</value>
17636 
              <value type="string" key="10b01930-1dcb-11e3-b98c-080027bcf912">fk_taxon_occurrence_taxon_determination3_idx</value>
17637 
              <value type="string" key="110c72d2-a73f-11e2-9fbf-080027bcf912">stem_observation_unique</value>
17638 
              <value type="string" key="1156cf50-2393-11e3-a6f3-080027bcf912">fk_dataset_dataset1</value>
17639 
              <value type="string" key="1156d180-2393-11e3-a6f3-080027bcf912">parent</value>
17640 
              <value type="string" key="1156fa5c-2393-11e3-a6f3-080027bcf912">fk_dataset_dataset1_idx</value>
17641 
              <value type="string" key="11b487b4-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1</value>
17642 
              <value type="string" key="11b489bc-f97f-11e2-8a2e-080027bcf912">taxon_path</value>
17643 
              <value type="string" key="11b49e5c-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1_idx</value>
17644 
              <value type="string" key="12c0ef2c-3119-11e3-995a-080027bcf912">dataset_dataset_source_fkey1</value>
17645 
              <value type="string" key="12c15368-3119-11e3-995a-080027bcf912">dataset_dataset_source_fkey1_idx</value>
17646 
              <value type="string" key="1388436e-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1</value>
17647 
              <value type="string" key="13884530-f9c5-11e2-9af4-080027bcf912">parent</value>
17648 
              <value type="string" key="13885958-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1_idx</value>
17649 
              <value type="string" key="16537a20-a7a7-11e2-8ba6-080027bcf912">taxon_observation</value>
17650 
              <value type="string" key="16537d54-a7a7-11e2-8ba6-080027bcf912">id</value>
17651 
              <value type="string" key="16538808-a7a7-11e2-8ba6-080027bcf912">growth_form</value>
17652 
              <value type="string" key="165389fc-a7a7-11e2-8ba6-080027bcf912">cultivated</value>
17653 
              <value type="string" key="16538c2c-a7a7-11e2-8ba6-080027bcf912">traits</value>
17654 
              <value type="string" key="165395c8-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
17655 
              <value type="string" key="170b9dc8-310c-11e3-ab47-080027bcf912">fk_source_party2_idx</value>
17656 
              <value type="string" key="174e1b4c-23e9-11e3-ab7c-080027bcf912">person</value>
17657 
              <value type="string" key="174e1e76-23e9-11e3-ab7c-080027bcf912">id</value>
17658 
              <value type="string" key="174e216e-23e9-11e3-ab7c-080027bcf912">fk_organization_party10</value>
17659 
              <value type="string" key="174e238a-23e9-11e3-ab7c-080027bcf912">PRIMARY</value>
17660 
              <value type="string" key="17d59e68-a794-11e2-84c3-080027bcf912">info</value>
17661 
              <value type="string" key="181c8a8a-0077-11e3-906b-080027bcf912">height_min_m</value>
17662 
              <value type="string" key="1832712c-a77d-11e2-afd5-080027bcf912">taxon_concept</value>
17663 
              <value type="string" key="18327370-a77d-11e2-afd5-080027bcf912">id</value>
17664 
              <value type="string" key="18327514-a77d-11e2-afd5-080027bcf912">according_to</value>
17665 
              <value type="string" key="18327686-a77d-11e2-afd5-080027bcf912">parent</value>
17666 
              <value type="string" key="183277ee-a77d-11e2-afd5-080027bcf912">accepted_taxon_concept</value>
17667 
              <value type="string" key="1832797e-a77d-11e2-afd5-080027bcf912">PRIMARY</value>
17668 
              <value type="string" key="18327c76-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1_idx</value>
17669 
              <value type="string" key="18327f64-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1_idx</value>
17670 
              <value type="string" key="1832823e-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1_idx</value>
17671 
              <value type="string" key="18328522-a77d-11e2-afd5-080027bcf912">taxon_concept_unique_name</value>
17672 
              <value type="string" key="183287f2-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1</value>
17673 
              <value type="string" key="18328950-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1</value>
17674 
              <value type="string" key="18328a9a-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1</value>
17675 
              <value type="string" key="18328be4-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_name1</value>
17676 
              <value type="string" key="184d9a4a-a793-11e2-84c3-080027bcf912">observations</value>
17677 
              <value type="string" key="18e739f0-a91b-11e2-bdec-080027bcf912">fk_organization_party1</value>
17678 
              <value type="string" key="1b07bbcc-1dcb-11e3-b98c-080027bcf912">fk_reobservable_taxon_determination1_idx</value>
17679 
              <value type="string" key="1b1bf6e4-0077-11e3-906b-080027bcf912">height_max_m</value>
17680 
              <value type="string" key="1c952e1c-a791-11e2-84c3-080027bcf912">y_m</value>
17681 
              <value type="string" key="1e711948-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_occurrence_record1</value>
17682 
              <value type="string" key="20c2d304-311b-11e3-84d1-080027bcf912">use_conditions</value>
17683 
              <value type="string" key="21b40060-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1</value>
17684 
              <value type="string" key="21b41366-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1_idx</value>
17685 
              <value type="string" key="21c8f928-fa8d-11e2-9ba8-080027bcf912">fk_geovalidation_georeferencing1</value>
17686 
              <value type="string" key="21d06e5c-3137-11e3-aa43-080027bcf912">taxa_sampling_event__unique</value>
17687 
              <value type="string" key="2213caf6-f971-11e2-9f36-080027bcf912">fk_georeferencing_geoplace1</value>
17688 
              <value type="string" key="2213dee2-f971-11e2-9f36-080027bcf912">fk_georeferencing_geoplace1_idx</value>
17689 
              <value type="string" key="23ec4078-0075-11e3-906b-080027bcf912">stratum</value>
17690 
              <value type="string" key="23ec4406-0075-11e3-906b-080027bcf912">id</value>
17691 
              <value type="string" key="23ec4726-0075-11e3-906b-080027bcf912">name</value>
17692 
              <value type="string" key="23ec4e92-0075-11e3-906b-080027bcf912">PRIMARY</value>
17693 
              <value type="string" key="245083fa-a763-11e2-aa10-080027bcf912">geovalidation</value>
17694 
              <value type="string" key="24508724-a763-11e2-aa10-080027bcf912">id</value>
17695 
              <value type="string" key="2450919c-a763-11e2-aa10-080027bcf912">PRIMARY</value>
17696 
              <value type="string" key="251c29a8-f67b-11e2-aebb-080027bcf912">fk_event_party_list1</value>
17697 
              <value type="string" key="251c2b92-f67b-11e2-aebb-080027bcf912">participants</value>
17698 
              <value type="string" key="251c57de-f67b-11e2-aebb-080027bcf912">fk_event_party_list1_idx</value>
17699 
              <value type="string" key="26132be0-23e9-11e3-ab7c-080027bcf912">fk_person_organization1</value>
17700 
              <value type="string" key="26132e1a-23e9-11e3-ab7c-080027bcf912">organization</value>
17701 
              <value type="string" key="26134602-23e9-11e3-ab7c-080027bcf912">fk_person_organization1_idx</value>
17702 
              <value type="string" key="2673b9ee-f9bc-11e2-a599-080027bcf912">subplot</value>
17703 
              <value type="string" key="2673bdc2-f9bc-11e2-a599-080027bcf912">id</value>
17704 
              <value type="string" key="2673d532-f9bc-11e2-a599-080027bcf912">PRIMARY</value>
17705 
              <value type="string" key="26b22c2a-011d-11e3-9f3a-080027bcf912">fk_taxon_absence_taxa_sampling_event1</value>
17706 
              <value type="string" key="273737e8-a796-11e2-84c3-080027bcf912">tag</value>
17707 
              <value type="string" key="29c29602-a7a4-11e2-8ba6-080027bcf912">common_name</value>
17708 
              <value type="string" key="2a08cd96-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1</value>
17709 
              <value type="string" key="2a08de6c-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1_idx</value>
17710 
              <value type="string" key="2d3c42f6-0078-11e3-906b-080027bcf912">fk_place_observation_event1</value>
17711 
              <value type="string" key="2ebd5a70-238c-11e3-a6f3-080027bcf912">dataset_source</value>
17712 
              <value type="string" key="2ed4b280-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1</value>
17713 
              <value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value>
17714 
              <value type="string" key="2f07b8cc-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1</value>
17715 
              <value type="string" key="2f07bade-0127-11e3-9f3a-080027bcf912">identifying_place</value>
17716 
              <value type="string" key="2f07d0b4-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1_idx</value>
17717 
              <value type="string" key="2f5fcbcc-a793-11e2-84c3-080027bcf912">observations</value>
17718 
              <value type="string" key="3292225e-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1</value>
17719 
              <value type="string" key="3292247a-f6df-11e2-b6d1-080027bcf912">input_geoplace</value>
17720 
              <value type="string" key="329238b6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1_idx</value>
17721 
              <value type="string" key="3587a3e0-1dc6-11e3-838b-410b6ef2c3ca">fk_reobservable_taxon_occurrence1</value>
17722 
              <value type="string" key="35cce77e-f6df-11e2-b6d1-080027bcf912">corrected_geoplace</value>
17723 
              <value type="string" key="39e40ed2-23e9-11e3-ab7c-080027bcf912">fk_organization_organization1</value>
17724 
              <value type="string" key="39e41094-23e9-11e3-ab7c-080027bcf912">parent</value>
17725 
              <value type="string" key="39e42688-23e9-11e3-ab7c-080027bcf912">fk_organization_organization1_idx</value>
17726 
              <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">verbatim</value>
17727 
              <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>
17728 
              <value type="string" key="3d9b13d2-a7a1-11e2-b667-080027bcf912">id</value>
17729 
              <value type="string" key="3d9b17ba-a7a1-11e2-b667-080027bcf912">taxon_assertion</value>
17730 
              <value type="string" key="3d9b197c-a7a1-11e2-b667-080027bcf912">identified_by</value>
17731 
              <value type="string" key="3d9b1d28-a7a1-11e2-b667-080027bcf912">fit_info</value>
17732 
              <value type="string" key="3d9b1f30-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1_idx</value>
17733 
              <value type="string" key="3d9b26c4-a7a1-11e2-b667-080027bcf912">PRIMARY</value>
17734 
              <value type="string" key="3d9b2d86-a7a1-11e2-b667-080027bcf912">taxon_determination_unique</value>
17735 
              <value type="string" key="3d9b3600-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1</value>
17736 
              <value type="string" key="4001ec92-f678-11e2-9716-080027bcf912">party_list</value>
17737 
              <value type="string" key="4001ef9e-f678-11e2-9716-080027bcf912">id</value>
17738 
              <value type="string" key="4001f296-f678-11e2-9716-080027bcf912">count</value>
17739 
              <value type="string" key="4001f692-f678-11e2-9716-080027bcf912">fk_collection_source100</value>
17740 
              <value type="string" key="4001fa52-f678-11e2-9716-080027bcf912">PRIMARY</value>
17741 
              <value type="string" key="400c0dc2-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1</value>
17742 
              <value type="string" key="400c0fac-f6d1-11e2-a35e-080027bcf912">parsed_taxon_assertion</value>
17743 
              <value type="string" key="400c2370-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1_idx</value>
17744 
              <value type="string" key="40e95b66-acfb-11e2-b309-080027bcf912">fk_method_method1</value>
17745 
              <value type="string" key="40e95d64-acfb-11e2-b309-080027bcf912">parent</value>
17746 
              <value type="string" key="40e971d2-acfb-11e2-b309-080027bcf912">fk_method_method1_idx</value>
17747 
              <value type="string" key="415f1a26-ad15-11e2-9617-080027bcf912">specimen_unique_in_individual</value>
17748 
              <value type="string" key="42266085-54CC-4441-8553-68BBE0286A05">default</value>
17749 
              <value type="string" key="42405474-a783-11e2-afd5-080027bcf912">annotations</value>
17750 
              <value type="string" key="426f5d76-1dcd-11e3-b98c-080027bcf912">fk_individual_count_taxon_presence1</value>
17751 
              <value type="string" key="434ef6ca-3132-11e3-8c52-080027bcf912">event_unique_within_parent_by_subject</value>
17752 
              <value type="string" key="43cfb7dc-a790-11e2-84c3-080027bcf912">lat_long_domain_valid</value>
17753 
              <value type="string" key="43f70d90-f679-11e2-9716-080027bcf912">sort_order</value>
17754 
              <value type="string" key="44e36b2c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1</value>
17755 
              <value type="string" key="44e36d02-a7b4-11e2-97d7-080027bcf912">subject</value>
17756 
              <value type="string" key="44e38f6c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1_idx</value>
17757 
              <value type="string" key="45a3f404-ad0f-11e2-b309-080027bcf912">name</value>
17758 
              <value type="string" key="47b3b670-0076-11e3-906b-080027bcf912">diameter_max_m</value>
17759 
              <value type="string" key="4824526a-a791-11e2-84c3-080027bcf912">area_m2</value>
17760 
              <value type="string" key="489c177a-a6ea-11e2-98a6-080027bcf912">referenced_class</value>
17761 
              <value type="string" key="489c19be-a6ea-11e2-98a6-080027bcf912">id</value>
17762 
              <value type="string" key="489c1b62-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
17763 
              <value type="string" key="489c1e64-a6ea-11e2-98a6-080027bcf912">fk_example_record10</value>
17764 
              <value type="string" key="489c25e4-a6ea-11e2-98a6-080027bcf912">base_class</value>
17765 
              <value type="string" key="489c281e-a6ea-11e2-98a6-080027bcf912">id</value>
17766 
              <value type="string" key="489c29c2-a6ea-11e2-98a6-080027bcf912">referenced_class</value>
17767 
              <value type="string" key="489c2b34-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
17768 
              <value type="string" key="489c2e22-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1_idx</value>
17769 
              <value type="string" key="489c325a-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1</value>
17770 
              <value type="string" key="489c3958-a6ea-11e2-98a6-080027bcf912">derived_class</value>
17771 
              <value type="string" key="489c3b9c-a6ea-11e2-98a6-080027bcf912">id</value>
17772 
              <value type="string" key="489c3d40-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
17773 
              <value type="string" key="489c402e-a6ea-11e2-98a6-080027bcf912">fk_derived_class_base_class1</value>
17774 
              <value type="string" key="48af0dca-a795-11e2-84c3-080027bcf912">slope_direction_deg_N</value>
17775 
              <value type="string" key="48c4e182-1dff-11e3-9d67-080027bcf912">event_unique_within_subject_by_date</value>
17776 
              <value type="string" key="49a23428-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2</value>
17777 
              <value type="string" key="49a235d6-f9c5-11e2-9af4-080027bcf912">parent</value>
17778 
              <value type="string" key="49a26722-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2_idx</value>
17779 
              <value type="string" key="4c32a89c-a76a-11e2-92a3-080027bcf912">match_score</value>
17780 
              <value type="string" key="4c3ffc96-a741-11e2-9fbf-080027bcf912">taxon_string</value>
17781 
              <value type="string" key="4c40001a-a741-11e2-9fbf-080027bcf912">string</value>
17782 
              <value type="string" key="4c4005b0-a741-11e2-9fbf-080027bcf912">PRIMARY</value>
17783 
              <value type="string" key="4e34b204-f9c5-11e2-9af4-080027bcf912">fk_subplot_rel_place1</value>
17784 
              <value type="string" key="4ee0a0e2-a794-11e2-84c3-080027bcf912">info</value>
17785 
              <value type="string" key="4f2d2f86-f986-11e2-8a2e-080027bcf912">info</value>
17786 
              <value type="string" key="5077e4de-a748-11e2-9fbf-080027bcf912">taxon</value>
17787 
              <value type="string" key="523d417c-f96b-11e2-9fb4-080027bcf912">parent</value>
17788 
              <value type="string" key="5256ac76-f983-11e2-8a2e-080027bcf912">azimuth_deg_N</value>
17789 
              <value type="string" key="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>
17790 
              <value type="string" key="59b33ca8-f6ba-11e2-aebb-080027bcf912">taxon_absence</value>
17791 
              <value type="string" key="59b33fe6-f6ba-11e2-aebb-080027bcf912">id</value>
17792 
              <value type="string" key="59b34b30-f6ba-11e2-aebb-080027bcf912">PRIMARY</value>
17793 
              <value type="string" key="5a0331b2-f96d-11e2-9fb4-080027bcf912">name</value>
17794 
              <value type="string" key="5a8a530a-1dca-11e3-b98c-080027bcf912">fk_reobservable_taxon_determination1</value>
17795 
              <value type="string" key="5a8a54cc-1dca-11e3-b98c-080027bcf912">orig_observation</value>
17796 
              <value type="string" key="5ac683ea-3132-11e3-8c52-080027bcf912">event_unique_within_subject_by_name</value>
17797 
              <value type="string" key="5b345f5e-f957-11e2-8597-080027bcf912">fk_taxon_determination_taxon_observation1</value>
17798 
              <value type="string" key="5e41c0d2-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1</value>
17799 
              <value type="string" key="5e41cb90-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1_idx</value>
17800 
              <value type="string" key="61c193a8-1dee-11e3-b571-080027bcf912">fk_source_party_list1</value>
17801 
              <value type="string" key="61c1b04a-1dee-11e3-b571-080027bcf912">fk_source_party_list1_idx</value>
17802 
              <value type="string" key="648b8c10-0075-11e3-906b-080027bcf912">fk_layer_stratum1</value>
17803 
              <value type="string" key="65752312-0119-11e3-b872-080027bcf912">cover_percent</value>
17804 
              <value type="string" key="66675a70-f970-11e2-9f36-080027bcf912">fk_geoplace_place1</value>
17805 
              <value type="string" key="66c25c1c-a791-11e2-84c3-080027bcf912">length_m</value>
17806 
              <value type="string" key="67fa5b28-f6c1-11e2-af44-080027bcf912">fk_taxon_observation_sampling_event1</value>
17807 
              <value type="string" key="686ec05a-f9bc-11e2-a599-080027bcf912">fk_subplot_plot1</value>
17808 
              <value type="string" key="687f12b8-a780-11e2-afd5-080027bcf912">taxon_name</value>
17809 
              <value type="string" key="687f1542-a780-11e2-afd5-080027bcf912">id</value>
17810 
              <value type="string" key="687f1718-a780-11e2-afd5-080027bcf912">unique_name</value>
17811 
              <value type="string" key="687f18b2-a780-11e2-afd5-080027bcf912">formal_name</value>
17812 
              <value type="string" key="687f1a6a-a780-11e2-afd5-080027bcf912">taxon_name</value>
17813 
              <value type="string" key="687f1c2c-a780-11e2-afd5-080027bcf912">author</value>
17814 
              <value type="string" key="687f1dda-a780-11e2-afd5-080027bcf912">rank</value>
17815 
              <value type="string" key="687f1f92-a780-11e2-afd5-080027bcf912">PRIMARY</value>
17816 
              <value type="string" key="687f22b2-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10_idx</value>
17817 
              <value type="string" key="687f25a0-a780-11e2-afd5-080027bcf912">fk_taxon_record10</value>
17818 
              <value type="string" key="687f26f4-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10</value>
17819 
              <value type="string" key="687f2f28-a780-11e2-afd5-080027bcf912">taxon_path</value>
17820 
              <value type="string" key="687f31c6-a780-11e2-afd5-080027bcf912">id</value>
17821 
              <value type="string" key="687f339c-a780-11e2-afd5-080027bcf912">family</value>
17822 
              <value type="string" key="687f3590-a780-11e2-afd5-080027bcf912">genus</value>
17823 
              <value type="string" key="687f3752-a780-11e2-afd5-080027bcf912">specific_epithet</value>
17824 
              <value type="string" key="687f3900-a780-11e2-afd5-080027bcf912">ranks</value>
17825 
              <value type="string" key="687f3ae0-a780-11e2-afd5-080027bcf912">PRIMARY</value>
17826 
              <value type="string" key="68bcc4bc-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1</value>
17827 
              <value type="string" key="68bcc6ce-0083-11e3-ac06-080027bcf912">parent</value>
17828 
              <value type="string" key="68bcdca4-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1_idx</value>
17829 
              <value type="string" key="69b7c87c-f970-11e2-9f36-080027bcf912">fk_nested_geoplace_geoplace1</value>
17830 
              <value type="string" key="6a2c268a-1dfc-11e3-bbb6-080027bcf912">fk_record_source2</value>
17831 
              <value type="string" key="6b43aacc-f979-11e2-9f36-080027bcf912">fk_place_geopath1</value>
17832 
              <value type="string" key="6b43ac84-f979-11e2-9f36-080027bcf912">geopath</value>
17833 
              <value type="string" key="6b43c264-f979-11e2-9f36-080027bcf912">fk_place_geopath1_idx</value>
17834 
              <value type="string" key="6b54505e-ad0f-11e2-b309-080027bcf912">collection_unique</value>
17835 
              <value type="string" key="6c2bb9d2-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1</value>
17836 
              <value type="string" key="6c2bbbb2-0083-11e3-ac06-080027bcf912">size_class</value>
17837 
              <value type="string" key="6c2bd08e-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1_idx</value>
17838 
              <value type="string" key="713ff706-2998-11e3-a80d-080027bcf912">taxon_observation_id_fkey1</value>
17839 
              <value type="string" key="713ff8dc-2998-11e3-a80d-080027bcf912">primary_collector</value>
17840 
              <value type="string" key="714100ce-2998-11e3-a80d-080027bcf912">taxon_observation_id_fkey1_idx</value>
17841 
              <value type="string" key="7255cc48-1beb-11e3-8de9-080027bcf912">specimen_unique_in_individual_observation</value>
17842 
              <value type="string" key="74709b22-a795-11e2-84c3-080027bcf912">slope_incline_deg</value>
17843 
              <value type="string" key="760751d2-2324-11e3-a5a2-080027bcf912">fk_dataset_traceable1</value>
17844 
              <value type="string" key="77c740cc-1de8-11e3-b571-080027bcf912">role</value>
17845 
              <value type="string" key="782db00a-a782-11e2-afd5-080027bcf912">match_info</value>
17846 
              <value type="string" key="7afebdc8-0075-11e3-906b-080027bcf912">size_class</value>
17847 
              <value type="string" key="7afec156-0075-11e3-906b-080027bcf912">id</value>
17848 
              <value type="string" key="7afec49e-0075-11e3-906b-080027bcf912">diameter_min_m</value>
17849 
              <value type="string" key="7afec93a-0075-11e3-906b-080027bcf912">fk_layer_stratum10</value>
17850 
              <value type="string" key="7afecb88-0075-11e3-906b-080027bcf912">PRIMARY</value>
17851 
              <value type="string" key="7c31a514-f96f-11e2-9f36-080027bcf912">boundary_WKT</value>
17852 
              <value type="string" key="7cd351c8-1168-11e3-8d7f-080027bcf912">fk_specimen_individual_observation1</value>
17853 
              <value type="string" key="7cd35394-1168-11e3-8d7f-080027bcf912">individual_observation</value>
17854 
              <value type="string" key="7cd372b6-1168-11e3-8d7f-080027bcf912">fk_specimen_individual_observation1_idx</value>
17855 
              <value type="string" key="7d6806c8-f95e-11e2-8597-080027bcf912">description</value>
17856 
              <value type="string" key="7e2aa84c-1dfb-11e3-bbb6-080027bcf912">fk_dataset_source1</value>
17857 
              <value type="string" key="7f176964-f6c0-11e2-af44-080027bcf912">taxa_sampling_event</value>
17858 
              <value type="string" key="7f176d06-f6c0-11e2-af44-080027bcf912">id</value>
17859 
              <value type="string" key="7f177512-f6c0-11e2-af44-080027bcf912">fk_project_event10</value>
17860 
              <value type="string" key="7f177760-f6c0-11e2-af44-080027bcf912">PRIMARY</value>
17861 
              <value type="string" key="7f3654cc-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_barcode</value>
17862 
              <value type="string" key="801a596e-3128-11e3-ac9d-080027bcf912">record_id_fkey2</value>
17863 
              <value type="string" key="801a5b44-3128-11e3-ac9d-080027bcf912">attribution_dataset</value>
17864 
              <value type="string" key="801b49d2-3128-11e3-ac9d-080027bcf912">record_id_fkey2_idx</value>
17865 
              <value type="string" key="803980c8-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1</value>
17866 
              <value type="string" key="8039828a-f6d1-11e2-a35e-080027bcf912">input_string</value>
17867 
              <value type="string" key="80399806-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1_idx</value>
17868 
              <value type="string" key="813d59c4-1de9-11e3-b571-080027bcf912">fk_party_list_entry_party_list1</value>
17869 
              <value type="string" key="813d5bfe-1de9-11e3-b571-080027bcf912">list</value>
17870 
              <value type="string" key="813e36c8-1de9-11e3-b571-080027bcf912">fk_party_list_entry_party_list1_idx</value>
17871 
              <value type="string" key="81937b1c-ad12-11e2-b309-080027bcf912">fk_collection_source1_idx</value>
17872 
              <value type="string" key="83cc6526-236c-11e3-a6f3-080027bcf912">name</value>
17873 
              <value type="string" key="83dbd4da-f6e8-11e2-9cf1-080027bcf912">georeferencing</value>
17874 
              <value type="string" key="83dbd8ae-f6e8-11e2-9cf1-080027bcf912">id</value>
17875 
              <value type="string" key="83dbdbec-f6e8-11e2-9cf1-080027bcf912">input_place</value>
17876 
              <value type="string" key="83dbe060-f6e8-11e2-9cf1-080027bcf912">fk_geovalidation_record100</value>
17877 
              <value type="string" key="83dbe6aa-f6e8-11e2-9cf1-080027bcf912">PRIMARY</value>
17878 
              <value type="string" key="83f063b8-29d4-11e3-a673-080027bcf912">url</value>
17879 
              <value type="string" key="84258cd0-3129-11e3-ac9d-080027bcf912">traceable_id_fkey1</value>
17880 
              <value type="string" key="84258ee2-3129-11e3-ac9d-080027bcf912">authors</value>
17881 
              <value type="string" key="8425b926-3129-11e3-ac9d-080027bcf912">traceable_id_fkey1_idx</value>
17882 
              <value type="string" key="8542fbb8-a793-11e2-84c3-080027bcf912">info</value>
17883 
              <value type="string" key="86be7be2-29ad-11e3-a980-080027bcf912">id_by_source</value>
17884 
              <value type="string" key="86e5a7d8-23ec-11e3-ab7c-080027bcf912">organization_unique</value>
17885 
              <value type="string" key="873d44bc-1df1-11e3-bbb6-080027bcf912">fk_source_party1</value>
17886 
              <value type="string" key="873d473c-1df1-11e3-bbb6-080027bcf912">contacts</value>
17887 
              <value type="string" key="8b8a694e-a792-11e2-84c3-080027bcf912">name</value>
17888 
              <value type="string" key="8c119224-238a-11e3-a6f3-080027bcf912">fk_party_source1</value>
17889 
              <value type="string" key="8cef30ce-3119-11e3-84d1-080027bcf912">data_owner</value>
17890 
              <value type="string" key="8cef351a-3119-11e3-84d1-080027bcf912">id</value>
17891 
              <value type="string" key="8cef4780-3119-11e3-84d1-080027bcf912">fk_party_list_entry_record10</value>
17892 
              <value type="string" key="8cef496a-3119-11e3-84d1-080027bcf912">PRIMARY</value>
17893 
              <value type="string" key="8e39e482-23eb-11e3-ab7c-080027bcf912">name</value>
17894 
              <value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value>
17895 
              <value type="string" key="8f0c3678-f978-11e2-9f36-080027bcf912">rank</value>
17896 
              <value type="string" key="913a6e06-008a-11e3-9629-080027bcf912">fk_soil_observation_record1</value>
17897 
              <value type="string" key="92fc2776-1be6-11e3-af49-080027bcf912">defining_data</value>
17898 
              <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>
17899 
              <value type="string" key="9535924c-29b6-11e3-a024-080027bcf912">party_list_id_fkey1</value>
17900 
              <value type="string" key="98e532e4-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1</value>
17901 
              <value type="string" key="98e534d8-008a-11e3-9629-080027bcf912">place_observation</value>
17902 
              <value type="string" key="98e5491e-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1_idx</value>
17903 
              <value type="string" key="9b006114-f6d2-11e2-a35e-080027bcf912">fk_taxon_scrub_record1</value>
17904 
              <value type="string" key="9b6b7d6a-ad0c-11e2-b309-080027bcf912">fk_parsed_taxon_assertion_taxon_name1_idx</value>
17905 
              <value type="string" key="9d6c9e9a-f678-11e2-9716-080027bcf912">party_list_entry</value>
17906 
              <value type="string" key="9d6ca570-f678-11e2-9716-080027bcf912">id</value>
17907 
              <value type="string" key="9d6ca7aa-f678-11e2-9716-080027bcf912">PRIMARY</value>
17908 
              <value type="string" key="9d6cb042-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1</value>
17909 
              <value type="string" key="9d6cb150-f678-11e2-9716-080027bcf912">party</value>
17910 
              <value type="string" key="9d6cb812-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1_idx</value>
17911 
              <value type="string" key="9f4bd98c-a6fb-11e2-9461-080027bcf912">plot</value>
17912 
              <value type="string" key="9f4bdd10-a6fb-11e2-9461-080027bcf912">id</value>
17913 
              <value type="string" key="9f4be008-a6fb-11e2-9461-080027bcf912">fk_subplot_place1</value>
17914 
              <value type="string" key="9f4be256-a6fb-11e2-9461-080027bcf912">PRIMARY</value>
17915 
              <value type="string" key="9f58576a-a792-11e2-84c3-080027bcf912">name</value>
17916 
              <value type="string" key="9ff2d244-1dfe-11e3-9d67-080027bcf912">event_unique_within_parent_by_name</value>
17917 
              <value type="string" key="a01e225c-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1</value>
17918 
              <value type="string" key="a01e269e-a741-11e2-9fbf-080027bcf912">string</value>
17919 
              <value type="string" key="a01e47fa-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1_idx</value>
17920 
              <value type="string" key="a0266c92-a92a-11e2-93c8-080027bcf912">latitude_deg</value>
17921 
              <value type="string" key="a1698796-29b4-11e3-a980-080027bcf912">taxon_determination_id_fkey1</value>
17922 
              <value type="string" key="a1698958-29b4-11e3-a980-080027bcf912">voucher</value>
17923 
              <value type="string" key="a16a4988-29b4-11e3-a980-080027bcf912">taxon_determination_id_fkey1_idx</value>
17924 
              <value type="string" key="a2c503c8-299a-11e3-a80d-080027bcf912">taxon_observation__unique</value>
17925 
              <value type="string" key="a2eed5e8-3130-11e3-8c52-080027bcf912">fk_event_place1_idx</value>
17926 
              <value type="string" key="a3d77282-3133-11e3-8c52-080027bcf912">taxon_observation_id_fkey3</value>
17927 
              <value type="string" key="a3d77462-3133-11e3-8c52-080027bcf912">subject</value>
17928 
              <value type="string" key="a3d78d6c-3133-11e3-8c52-080027bcf912">taxon_observation_id_fkey3_idx</value>
17929 
              <value type="string" key="a3e070f8-a77c-11e2-afd5-080027bcf912">fk_parsed_taxon_assertion_taxon_name1</value>
17930 
              <value type="string" key="a45bf56a-f980-11e2-8a2e-080027bcf912">fk_subplot_place2</value>
17931 
              <value type="string" key="a60e3a24-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_accession_number</value>
17932 
              <value type="string" key="a76e6760-23ec-11e3-ab7c-080027bcf912">person_unique</value>
17933 
              <value type="string" key="a8348424-a78f-11e2-84c3-080027bcf912">geovalid</value>
17934 
              <value type="string" key="a841b894-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1</value>
17935 
              <value type="string" key="a841ba7e-f6c0-11e2-af44-080027bcf912">subsetting_method</value>
17936 
              <value type="string" key="a842920a-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1_idx</value>
17937 
              <value type="string" key="a882f398-0117-11e3-b872-080027bcf912">count</value>
17938 
              <value type="string" key="a8a2bcc2-311a-11e3-84d1-080027bcf912">use_conditions</value>
17939 
              <value type="string" key="aa191bd2-a92a-11e2-93c8-080027bcf912">longitude_deg</value>
17940 
              <value type="string" key="ab3ef4b0-1dc8-11e3-b98c-080027bcf912">fk_taxon_occurrence_taxon_determination3</value>
17941 
              <value type="string" key="ab3ef6ae-1dc8-11e3-b98c-080027bcf912">current_observation</value>
17942 
              <value type="string" key="ad91aad6-23eb-11e3-ab7c-080027bcf912">dataset_unique</value>
17943 
              <value type="string" key="ae7761fe-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1</value>
17944 
              <value type="string" key="ae7763ca-008a-11e3-9629-080027bcf912">measurement_spot</value>
17945 
              <value type="string" key="ae777b3a-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1_idx</value>
17946 
              <value type="string" key="aed5d5c4-a769-11e2-92a3-080027bcf912">cf_aff</value>
17947 
              <value type="string" key="afc401d4-1df9-11e3-bbb6-080027bcf912">source</value>
17948 
              <value type="string" key="afc4053a-1df9-11e3-bbb6-080027bcf912">id</value>
17949 
              <value type="string" key="afc40c10-1df9-11e3-bbb6-080027bcf912">name</value>
17950 
              <value type="string" key="afc4158e-1df9-11e3-bbb6-080027bcf912">info</value>
17951 
              <value type="string" key="afc41fc0-1df9-11e3-bbb6-080027bcf912">PRIMARY</value>
17952 
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>
17953 
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>
17954 
              <value type="string" key="b7749c3a-2985-11e3-a80d-080027bcf912">taxa_sampling_event_id_fkey1</value>
17955 
              <value type="string" key="b7749e74-2985-11e3-a80d-080027bcf912">place_observation</value>
17956 
              <value type="string" key="b774c534-2985-11e3-a80d-080027bcf912">taxa_sampling_event_id_fkey1_idx</value>
17957 
              <value type="string" key="b8ce339a-a797-11e2-8681-080027bcf912">fk_stem_individual2</value>
17958 
              <value type="string" key="b95efb72-f982-11e2-8a2e-080027bcf912">width_m</value>
17959 
              <value type="string" key="b9695d2e-a793-11e2-84c3-080027bcf912">info</value>
17960 
              <value type="string" key="b9be8c42-acff-11e2-b309-080027bcf912">all_collectors</value>
17961 
              <value type="string" key="bae73e3e-2996-11e3-a80d-080027bcf912">specimen_observation_id_fkey1</value>
17962 
              <value type="string" key="bae73ff6-2996-11e3-a80d-080027bcf912">current_collection</value>
17963 
              <value type="string" key="bae812be-2996-11e3-a80d-080027bcf912">specimen_observation_id_fkey1_idx</value>
17964 
              <value type="string" key="bb86336c-2992-11e3-a80d-080027bcf912">individual_observation_id_fkey1</value>
17965 
              <value type="string" key="bb863556-2992-11e3-a80d-080027bcf912">specimenholder_institutions</value>
17966 
              <value type="string" key="bb865680-2992-11e3-a80d-080027bcf912">individual_observation_id_fkey1_idx</value>
17967 
              <value type="string" key="bbbbdd9c-ad09-11e2-b309-080027bcf912">id_within_individual</value>
17968 
              <value type="string" key="bd75deda-2996-11e3-a80d-080027bcf912">specimen_observation_id_fkey2</value>
17969 
              <value type="string" key="bd75e0a6-2996-11e3-a80d-080027bcf912">owner_collection</value>
17970 
              <value type="string" key="bd76aaea-2996-11e3-a80d-080027bcf912">specimen_observation_id_fkey2_idx</value>
17971 
              <value type="string" key="be8cb246-a6e0-11e2-95e9-080027bcf912">VegCore</value>
17972 
              <value type="string" key="be8cc04c-a6e0-11e2-95e9-080027bcf912">dataset</value>
17973 
              <value type="string" key="be8cc362-a6e0-11e2-95e9-080027bcf912">id</value>
17974 
              <value type="string" key="be8cc75e-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17975 
              <value type="string" key="be8cd56e-a6e0-11e2-95e9-080027bcf912">traceable</value>
17976 
              <value type="string" key="be8cd7b2-a6e0-11e2-95e9-080027bcf912">id</value>
17977 
              <value type="string" key="be8cd956-a6e0-11e2-95e9-080027bcf912">source</value>
17978 
              <value type="string" key="be8cdac8-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17979 
              <value type="string" key="be8ce0b8-a6e0-11e2-95e9-080027bcf912">fk_record_source1</value>
17980 
              <value type="string" key="be8d17d6-a6e0-11e2-95e9-080027bcf912">taxon_assertion</value>
17981 
              <value type="string" key="be8d1ac4-a6e0-11e2-95e9-080027bcf912">id</value>
17982 
              <value type="string" key="be8d1de4-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17983 
              <value type="string" key="be8d249c-a6e0-11e2-95e9-080027bcf912">fk_qualified_taxon_record1</value>
17984 
              <value type="string" key="be8d4a58-a6e0-11e2-95e9-080027bcf912">geoplace</value>
17985 
              <value type="string" key="be8d4cd8-a6e0-11e2-95e9-080027bcf912">id</value>
17986 
              <value type="string" key="be8d4eae-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17987 
              <value type="string" key="be8d8c2a-a6e0-11e2-95e9-080027bcf912">method</value>
17988 
              <value type="string" key="be8d8ea0-a6e0-11e2-95e9-080027bcf912">id</value>
17989 
              <value type="string" key="be8d906c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17990 
              <value type="string" key="be8d93c8-a6e0-11e2-95e9-080027bcf912">fk_method_record1</value>
17991 
              <value type="string" key="be8df962-a6e0-11e2-95e9-080027bcf912">collection</value>
17992 
              <value type="string" key="be8dfbf6-a6e0-11e2-95e9-080027bcf912">id</value>
17993 
              <value type="string" key="be8e0240-a6e0-11e2-95e9-080027bcf912">fk_collection_source1</value>
17994 
              <value type="string" key="be8e3ecc-a6e0-11e2-95e9-080027bcf912">individual</value>
17995 
              <value type="string" key="be8e4142-a6e0-11e2-95e9-080027bcf912">id</value>
17996 
              <value type="string" key="be8e4322-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17997 
              <value type="string" key="be8e4688-a6e0-11e2-95e9-080027bcf912">fk_individual_record1</value>
17998 
              <value type="string" key="be8e6514-a6e0-11e2-95e9-080027bcf912">stem</value>
17999 
              <value type="string" key="be8e679e-a6e0-11e2-95e9-080027bcf912">id</value>
18000 
              <value type="string" key="be8e6974-a6e0-11e2-95e9-080027bcf912">individual</value>
18001 
              <value type="string" key="be8e6b22-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18002 
              <value type="string" key="be8e6e7e-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1_idx</value>
18003 
              <value type="string" key="be8e7360-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1</value>
18004 
              <value type="string" key="be8e7cde-a6e0-11e2-95e9-080027bcf912">stem_observation</value>
18005 
              <value type="string" key="be8e7f5e-a6e0-11e2-95e9-080027bcf912">id</value>
18006 
              <value type="string" key="be8e8134-a6e0-11e2-95e9-080027bcf912">individual_observation</value>
18007 
              <value type="string" key="be8e82ce-a6e0-11e2-95e9-080027bcf912">subject</value>
18008 
              <value type="string" key="be8e8472-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18009 
              <value type="string" key="be8e87d8-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1_idx</value>
18010 
              <value type="string" key="be8e8b20-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1_idx</value>
18011 
              <value type="string" key="be8e8fe4-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1</value>
18012 
              <value type="string" key="be8e9156-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1</value>
18013 
              <value type="string" key="be8e9930-a6e0-11e2-95e9-080027bcf912">individual_count</value>
18014 
              <value type="string" key="be8e9bba-a6e0-11e2-95e9-080027bcf912">id</value>
18015 
              <value type="string" key="be8e9d90-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18016 
              <value type="string" key="be8ea786-a6e0-11e2-95e9-080027bcf912">taxon_presence</value>
18017 
              <value type="string" key="be8eaa06-a6e0-11e2-95e9-080027bcf912">id</value>
18018 
              <value type="string" key="be8f1784-a6e0-11e2-95e9-080027bcf912">community</value>
18019 
              <value type="string" key="be8f1a36-a6e0-11e2-95e9-080027bcf912">id</value>
18020 
              <value type="string" key="be8f1c2a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18021 
              <value type="string" key="be8f1fc2-a6e0-11e2-95e9-080027bcf912">fk_community_record1</value>
18022 
              <value type="string" key="be8f272e-a6e0-11e2-95e9-080027bcf912">geological_context</value>
18023 
              <value type="string" key="be8f29d6-a6e0-11e2-95e9-080027bcf912">id</value>
18024 
              <value type="string" key="be8f2b98-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18025 
              <value type="string" key="be8f2ecc-a6e0-11e2-95e9-080027bcf912">fk_geological_context_record1</value>
18026 
              <value type="string" key="be8f387c-a6e0-11e2-95e9-080027bcf912">place_observation</value>
18027 
              <value type="string" key="be8f3ade-a6e0-11e2-95e9-080027bcf912">id</value>
18028 
              <value type="string" key="be8f3ca0-a6e0-11e2-95e9-080027bcf912">subject</value>
18029 
              <value type="string" key="be8f3e30-a6e0-11e2-95e9-080027bcf912">geological_context</value>
18030 
              <value type="string" key="be8f3fd4-a6e0-11e2-95e9-080027bcf912">community</value>
18031 
              <value type="string" key="be8f416e-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1_idx</value>
18032 
              <value type="string" key="be8f4524-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1_idx</value>
18033 
              <value type="string" key="be8f483a-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1_idx</value>
18034 
              <value type="string" key="be8f4b64-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1</value>
18035 
              <value type="string" key="be8f4d08-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1</value>
18036 
              <value type="string" key="be8f4e98-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1</value>
18037 
              <value type="string" key="be8f58b6-a6e0-11e2-95e9-080027bcf912">soil_observation</value>
18038 
              <value type="string" key="be8f5b5e-a6e0-11e2-95e9-080027bcf912">id</value>
18039 
              <value type="string" key="be8f5d5c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18040 
              <value type="string" key="be8f67e8-a6e0-11e2-95e9-080027bcf912">subplace</value>
18041 
              <value type="string" key="be8f6a86-a6e0-11e2-95e9-080027bcf912">id</value>
18042 
              <value type="string" key="be8f6c7a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18043 
              <value type="string" key="be8f78aa-a6e0-11e2-95e9-080027bcf912">geovalidatable_place</value>
18044 
              <value type="string" key="be8f7b0c-a6e0-11e2-95e9-080027bcf912">id</value>
18045 
              <value type="string" key="be8f8084-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18046 
              <value type="string" key="be8fa0fa-a6e0-11e2-95e9-080027bcf912">project</value>
18047 
              <value type="string" key="be8fa398-a6e0-11e2-95e9-080027bcf912">id</value>
18048 
              <value type="string" key="be8fa58c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18049 
              <value type="string" key="be8fa91a-a6e0-11e2-95e9-080027bcf912">fk_project_event1</value>
18050 
              <value type="string" key="be8fb202-a6e0-11e2-95e9-080027bcf912">taxon_scrub</value>
18051 
              <value type="string" key="be8fb5ae-a6e0-11e2-95e9-080027bcf912">id</value>
18052 
              <value type="string" key="be8fb7a2-a6e0-11e2-95e9-080027bcf912">matched_taxon_concept</value>
18053 
              <value type="string" key="be8fb98c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18054 
              <value type="string" key="be8fe70e-a6e0-11e2-95e9-080027bcf912">party</value>
18055 
              <value type="string" key="be8fe97a-a6e0-11e2-95e9-080027bcf912">id</value>
18056 
              <value type="string" key="be8feb50-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18057 
              <value type="string" key="be8fee8e-a6e0-11e2-95e9-080027bcf912">fk_collection_source10</value>
18058 
              <value type="string" key="c3760d74-a7b3-11e2-8ba6-080027bcf912">specimen_observation</value>
18059 
              <value type="string" key="c376109e-a7b3-11e2-8ba6-080027bcf912">id</value>
18060 
              <value type="string" key="c3762570-a7b3-11e2-8ba6-080027bcf912">fk_specimen_taxon_occurrence10</value>
18061 
              <value type="string" key="c37629b2-a7b3-11e2-8ba6-080027bcf912">PRIMARY</value>
18062 
              <value type="string" key="c6722390-a7a0-11e2-b667-080027bcf912">geopath</value>
18063 
              <value type="string" key="c67225de-a7a0-11e2-b667-080027bcf912">id</value>
18064 
              <value type="string" key="c6722782-a7a0-11e2-b667-080027bcf912">continent</value>
18065 
              <value type="string" key="c6722912-a7a0-11e2-b667-080027bcf912">country</value>
18066 
              <value type="string" key="c6722a98-a7a0-11e2-b667-080027bcf912">state_province</value>
18067 
              <value type="string" key="c6722c1e-a7a0-11e2-b667-080027bcf912">county</value>
18068 
              <value type="string" key="c6722da4-a7a0-11e2-b667-080027bcf912">municipality</value>
18069 
              <value type="string" key="c6722f2a-a7a0-11e2-b667-080027bcf912">ranks</value>
18070 
              <value type="string" key="c67230d8-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18071 
              <value type="string" key="c6723d8a-a7a0-11e2-b667-080027bcf912">place</value>
18072 
              <value type="string" key="c6724000-a7a0-11e2-b667-080027bcf912">id</value>
18073 
              <value type="string" key="c67241b8-a7a0-11e2-b667-080027bcf912">parent</value>
18074 
              <value type="string" key="c672467c-a7a0-11e2-b667-080027bcf912">locality</value>
18075 
              <value type="string" key="c6724820-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18076 
              <value type="string" key="c6724e7e-a7a0-11e2-b667-080027bcf912">fk_place1_idx</value>
18077 
              <value type="string" key="c67254b4-a7a0-11e2-b667-080027bcf912">fk_place_record1</value>
18078 
              <value type="string" key="c6725784-a7a0-11e2-b667-080027bcf912">fk_place1</value>
18079 
              <value type="string" key="c672743a-a7a0-11e2-b667-080027bcf912">event</value>
18080 
              <value type="string" key="c67276b0-a7a0-11e2-b667-080027bcf912">id</value>
18081 
              <value type="string" key="c672785e-a7a0-11e2-b667-080027bcf912">parent</value>
18082 
              <value type="string" key="c6727a2a-a7a0-11e2-b667-080027bcf912">name</value>
18083 
              <value type="string" key="c6727bce-a7a0-11e2-b667-080027bcf912">date_range</value>
18084 
              <value type="string" key="c6727d54-a7a0-11e2-b667-080027bcf912">subject</value>
18085 
              <value type="string" key="c67280b0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18086 
              <value type="string" key="c6728830-a7a0-11e2-b667-080027bcf912">fk_event1_idx</value>
18087 
              <value type="string" key="c6729578-a7a0-11e2-b667-080027bcf912">fk_event_record1</value>
18088 
              <value type="string" key="c672971c-a7a0-11e2-b667-080027bcf912">fk_event_place1</value>
18089 
              <value type="string" key="c672994c-a7a0-11e2-b667-080027bcf912">fk_event1</value>
18090 
              <value type="string" key="c672a8d8-a7a0-11e2-b667-080027bcf912">reobservable</value>
18091 
              <value type="string" key="c672abda-a7a0-11e2-b667-080027bcf912">id</value>
18092 
              <value type="string" key="c672bda0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18093 
              <value type="string" key="c672f914-a7a0-11e2-b667-080027bcf912">specimen</value>
18094 
              <value type="string" key="c672fb6c-a7a0-11e2-b667-080027bcf912">id</value>
18095 
              <value type="string" key="c6730896-a7a0-11e2-b667-080027bcf912">orig_collection</value>
18096 
              <value type="string" key="c6730b98-a7a0-11e2-b667-080027bcf912">barcode</value>
18097 
              <value type="string" key="c6730d78-a7a0-11e2-b667-080027bcf912">accession_number</value>
18098 
              <value type="string" key="c6731048-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18099 
              <value type="string" key="c6731534-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1_idx</value>
18100 
              <value type="string" key="c6731a52-a7a0-11e2-b667-080027bcf912">fk_specimen_taxon_occurrence1</value>
18101 
              <value type="string" key="c6731c28-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1</value>
18102 
              <value type="string" key="c7a57ce0-a92a-11e2-93c8-080027bcf912">lat_long_in_place_ranks</value>
18103 
              <value type="string" key="c7c1e6aa-a91b-11e2-bdec-080027bcf912">fk_source_party2</value>
18104 
              <value type="string" key="c7c1e862-a91b-11e2-bdec-080027bcf912">first_publisher</value>
18105 
              <value type="string" key="c8552b14-a7bc-11e2-8af2-080027bcf912">data_owners</value>
18106 
              <value type="string" key="cb38187e-29d4-11e3-a673-080027bcf912">source__unique</value>
18107 
              <value type="string" key="cfea1514-a790-11e2-84c3-080027bcf912">x_m</value>
18108 
              <value type="string" key="d009232a-f671-11e2-9716-080027bcf912">tag_history</value>
18109 
              <value type="string" key="d0d97d8a-f6c7-11e2-a35e-080027bcf912">coords</value>
18110 
              <value type="string" key="d2081100-f959-11e2-8597-080027bcf912">fk_taxon_presence_taxon_determination1</value>
18111 
              <value type="string" key="d2855d46-1df2-11e3-bbb6-080027bcf912">fk_source_party1_idx</value>
18112 
              <value type="string" key="d2b2ccf6-a794-11e2-84c3-080027bcf912">elevation_m</value>
18113 
              <value type="string" key="d6b1b62e-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
18114 
              <value type="string" key="d7177350-298a-11e3-a80d-080027bcf912">place_observation_id_fkey1</value>
18115 
              <value type="string" key="d717759e-298a-11e3-a80d-080027bcf912">project</value>
18116 
              <value type="string" key="d7179362-298a-11e3-a80d-080027bcf912">place_observation_id_fkey1_idx</value>
18117 
              <value type="string" key="db4e8988-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_observation_taxon_occurrence1</value>
18118 
              <value type="string" key="db4e8bea-1dc6-11e3-838b-410b6ef2c3ca">taxon_occurrence</value>
18119 
              <value type="string" key="db4ea800-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_observation_taxon_occurrence1_idx</value>
18120 
              <value type="string" key="dbe10c36-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1</value>
18121 
              <value type="string" key="dbe121f8-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1_idx</value>
18122 
              <value type="string" key="dc8d1c42-ad19-11e2-9d85-080027bcf912">aggregating_traits</value>
18123 
              <value type="string" key="e4cb84c4-29b1-11e3-a980-080027bcf912">taxon_observation_id_fkey2</value>
18124 
              <value type="string" key="e4cb86c2-29b1-11e3-a980-080027bcf912">parent</value>
18125 
              <value type="string" key="e4cba2d8-29b1-11e3-a980-080027bcf912">taxon_observation_id_fkey2_idx</value>
18126 
              <value type="string" key="e7922292-311f-11e3-9d49-080027bcf912">array</value>
18127 
              <value type="string" key="e95a1e48-1de9-11e3-b571-080027bcf912">fk_party_list_entry_record1</value>
18128 
              <value type="string" key="e96e2084-23eb-11e3-ab7c-080027bcf912">name</value>
18129 
              <value type="string" key="ec1f6aa2-f6c5-11e2-a35e-080027bcf912">shape</value>
18130 
              <value type="string" key="ed1eb2a6-ad0e-11e2-b309-080027bcf912">fk_collection_organization1</value>
18131 
              <value type="string" key="ed1eb468-ad0e-11e2-b309-080027bcf912">institution</value>
18132 
              <value type="string" key="ed1ec98a-ad0e-11e2-b309-080027bcf912">fk_collection_organization1_idx</value>
18133 
              <value type="string" key="f15726c2-011f-11e3-9f3a-080027bcf912">aggregate_observation</value>
18134 
              <value type="string" key="f1572a5a-011f-11e3-9f3a-080027bcf912">id</value>
18135 
              <value type="string" key="f1572d5c-011f-11e3-9f3a-080027bcf912">occurrence_status</value>
18136 
              <value type="string" key="f157336a-011f-11e3-9f3a-080027bcf912">fk_taxon_presence_taxon_determination10</value>
18137 
              <value type="string" key="f1573748-011f-11e3-9f3a-080027bcf912">PRIMARY</value>
18138 
              <value type="string" key="f62bfaf6-a797-11e2-8681-080027bcf912">fk_stem_observation_individual_observation2</value>
18139 
              <value type="string" key="f9d23e32-1dc5-11e3-838b-410b6ef2c3ca">taxon_occurrence</value>
18140 
              <value type="string" key="f9d241ca-1dc5-11e3-838b-410b6ef2c3ca">id</value>
18141 
              <value type="string" key="f9d255c0-1dc5-11e3-838b-410b6ef2c3ca">PRIMARY</value>
18142 
              <value type="string" key="f9d963a4-2326-11e3-a5a2-080027bcf912">id_within_source</value>
18143 
              <value type="string" key="fbf69d1e-a79d-11e2-a346-080027bcf912">traceable_unique</value>
18144 
              <value type="string" key="fc6fbbae-f96e-11e2-9f36-080027bcf912">geoplace</value>
18145 
              <value type="string" key="feccdf38-311a-11e3-84d1-080027bcf912">access_rights</value>
18146 
            </value>
18147 
            <value type="string" key="lastSyncDate"></value>
18148 
            <value type="string" key="name"></value>
18149 
          </value>
18150 
        </value>
17599 18151 
        <value _ptr_="0xb986d88" type="list" content-type="object" content-struct-name="GrtObject" key="tagCategories"/>
17600 18152 
        <value _ptr_="0xb986db8" type="list" content-type="object" content-struct-name="meta.Tag" key="tags"/>
17601 18153 
        <link type="object" struct-name="model.Diagram" key="currentDiagram">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
......
17678 18230 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
17679 18231 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
17680 18232 
      <value type="string" key="caption">New Model</value>
17681 
      <value type="string" key="dateChanged">2013-10-09 16:09</value>
18233 
      <value type="string" key="dateChanged">2013-10-09 16:20</value>
17682 18234 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
17683 18235 
      <value type="string" key="description"></value>
17684 18236 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
640 640 
/*!40000 ALTER TABLE `place` ENABLE KEYS */;
641 641 

  		




  642
  642
  
    
--


  		




  643
  
  
    
-- Table structure for table `place_observation`


  		




  
  643
  
    
-- Table structure for table `place_visit`


  		




  644
  644
  
    
--


  		




  645
  645
  
    

  		




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


  		




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


  		




  648
  
  
    
CREATE TABLE `place_observation` (


  		




  
  648
  
    
CREATE TABLE `place_visit` (


  		




  649
  649
  
    
  `id` varbinary(767) NOT NULL,


  		




  650
  650
  
    
  `subject` varbinary(767) NOT NULL,


  		




  651
  651
  
    
  `project` varbinary(767) DEFAULT NULL,


  		




  ......




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


  		




  670
  670
  
    

  		




  671
  671
  
    
--


  		




  672
  
  
    
-- Dumping data for table `place_observation`


  		




  
  672
  
    
-- Dumping data for table `place_visit`


  		




  673
  673
  
    
--


  		




  674
  674
  
    

  		




  675
  
  
    
/*!40000 ALTER TABLE `place_observation` DISABLE KEYS */;


  		




  676
  
  
    
/*!40000 ALTER TABLE `place_observation` ENABLE KEYS */;


  		




  
  675
  
    
/*!40000 ALTER TABLE `place_visit` DISABLE KEYS */;


  		




  
  676
  
    
/*!40000 ALTER TABLE `place_visit` ENABLE KEYS */;


  		




  677
  677
  
    

  		




  678
  678
  
    
--


  		




  679
  679
  
    
-- Table structure for table `plot`


  		




  ......




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


  		




  826
  826
  
    
CREATE TABLE `soil_observation` (


  		




  827
  827
  
    
  `id` varbinary(767) NOT NULL,


  		




  828
  
  
    
  `place_observation` varbinary(767) NOT NULL,


  		




  
  828
  
    
  `place_visit` varbinary(767) NOT NULL,


  		




  829
  829
  
    
  `measurement_spot` varbinary(767) DEFAULT NULL,


  		




  830
  830
  
    
  `observations` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  831
  831
  
    
  PRIMARY KEY (`id`),


  		




  832
  
  
    
  KEY `fk_soil_observation_place_observation1_idx` (`place_observation`),


  		




  
  832
  
    
  KEY `fk_soil_observation_place_observation1_idx` (`place_visit`),


  		




  833
  833
  
    
  KEY `fk_soil_observation_subplace1_idx` (`measurement_spot`),


  		




  834
  
  
    
  CONSTRAINT `fk_soil_observation_subplace1` FOREIGN KEY (`measurement_spot`) REFERENCES `subplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  835
  
  
    
  CONSTRAINT `fk_soil_observation_place_observation1` FOREIGN KEY (`place_observation`) REFERENCES `place_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  836
  
  
    
  CONSTRAINT `fk_soil_observation_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  834
  
    
  CONSTRAINT `fk_soil_observation_place_observation1` FOREIGN KEY (`place_visit`) REFERENCES `place_visit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  835
  
    
  CONSTRAINT `fk_soil_observation_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  836
  
    
  CONSTRAINT `fk_soil_observation_subplace1` FOREIGN KEY (`measurement_spot`) REFERENCES `subplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  837
  837
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]''s soil';


  		




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


  		




  839
  839
  
    

  		




  ......




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


  		




  1063
  1063
  
    
CREATE TABLE `taxa_sampling_event` (


  		




  1064
  1064
  
    
  `id` varbinary(767) NOT NULL,


  		




  1065
  
  
    
  `place_observation` varbinary(767) NOT NULL,


  		




  
  1065
  
    
  `place_visit` varbinary(767) NOT NULL,


  		




  1066
  1066
  
    
  `subsetting_method` varbinary(767) DEFAULT NULL,


  		




  1067
  1067
  
    
  PRIMARY KEY (`id`),


  		




  1068
  
  
    
  UNIQUE KEY `taxa_sampling_event__unique` (`place_observation`,`subsetting_method`),


  		




  
  1068
  
    
  UNIQUE KEY `taxa_sampling_event__unique` (`place_visit`,`subsetting_method`),


  		




  1069
  1069
  
    
  KEY `fk_sampling_event_method1_idx` (`subsetting_method`),


  		




  1070
  
  
    
  KEY `taxa_sampling_event_id_fkey1_idx` (`place_observation`),


  		




  
  1070
  
    
  KEY `taxa_sampling_event_id_fkey1_idx` (`place_visit`),


  		




  
  1071
  
    
  CONSTRAINT `taxa_sampling_event_id_fkey1` FOREIGN KEY (`place_visit`) REFERENCES `place_visit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1071
  1072
  
    
  CONSTRAINT `fk_project_event10` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1072
  
  
    
  CONSTRAINT `taxa_sampling_event_id_fkey1` FOREIGN KEY (`place_observation`) REFERENCES `place_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1073
  1073
  
    
  CONSTRAINT `fk_sampling_event_method1` FOREIGN KEY (`subsetting_method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  1074
  1074
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?stratum (which was confusingly named)';


  		




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


  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





  642
  642
  
    
/*!40000 ALTER TABLE "place" ENABLE KEYS */;


  		




  643
  643
  
    

  		




  644
  644
  
    
--


  		




  645
  
  
    
-- Table structure for table "place_observation"


  		




  
  645
  
    
-- Table structure for table "place_visit"


  		




  646
  646
  
    
--


  		




  647
  647
  
    

  		




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


  		




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


  		




  650
  
  
    
CREATE TABLE "place_observation" (


  		




  
  650
  
    
CREATE TABLE "place_visit" (


  		




  651
  651
  
    
  "id" text NOT NULL,


  		




  652
  652
  
    
  "subject" text NOT NULL,


  		




  653
  653
  
    
  "project" text DEFAULT NULL,


  		




  ......




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


  		




  672
  672
  
    

  		




  673
  673
  
    
--


  		




  674
  
  
    
-- Dumping data for table "place_observation"


  		




  
  674
  
    
-- Dumping data for table "place_visit"


  		




  675
  675
  
    
--


  		




  676
  676
  
    

  		




  677
  
  
    
/*!40000 ALTER TABLE "place_observation" DISABLE KEYS */;


  		




  678
  
  
    
/*!40000 ALTER TABLE "place_observation" ENABLE KEYS */;


  		




  
  677
  
    
/*!40000 ALTER TABLE "place_visit" DISABLE KEYS */;


  		




  
  678
  
    
/*!40000 ALTER TABLE "place_visit" ENABLE KEYS */;


  		




  679
  679
  
    

  		




  680
  680
  
    
--


  		




  681
  681
  
    
-- Table structure for table "plot"


  		




  ......




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


  		




  828
  828
  
    
CREATE TABLE "soil_observation" (


  		




  829
  829
  
    
  "id" text NOT NULL,


  		




  830
  
  
    
  "place_observation" text NOT NULL,


  		




  
  830
  
    
  "place_visit" text NOT NULL,


  		




  831
  831
  
    
  "measurement_spot" text DEFAULT NULL,


  		




  832
  832
  
    
  "observations" hstore DEFAULT NULL,


  		




  833
  833
  
    
  PRIMARY KEY ("id"),


  		




  834
  
  
    
  /*KEY "fk_soil_observation_place_observation1_idx" ("place_observation")*/CHECK (true),


  		




  
  834
  
    
  /*KEY "fk_soil_observation_place_observation1_idx" ("place_visit")*/CHECK (true),


  		




  835
  835
  
    
  /*KEY "fk_soil_observation_subplace1_idx" ("measurement_spot")*/CHECK (true),


  		




  836
  
  
    
  /*CONSTRAINT "fk_soil_observation_subplace1" FOREIGN KEY ("measurement_spot") REFERENCES "subplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  837
  
  
    
  /*CONSTRAINT "fk_soil_observation_place_observation1" FOREIGN KEY ("place_observation") REFERENCES "place_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  838
  
  
    
  /*CONSTRAINT "fk_soil_observation_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  836
  
    
  /*CONSTRAINT "fk_soil_observation_place_observation1" FOREIGN KEY ("place_visit") REFERENCES "place_visit" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  837
  
    
  /*CONSTRAINT "fk_soil_observation_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  838
  
    
  /*CONSTRAINT "fk_soil_observation_subplace1" FOREIGN KEY ("measurement_spot") REFERENCES "subplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  839
  839
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]''s soil'*/;


  		




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


  		




  841
  841
  
    

  		




  ......




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


  		




  1065
  1065
  
    
CREATE TABLE "taxa_sampling_event" (


  		




  1066
  1066
  
    
  "id" text NOT NULL,


  		




  1067
  
  
    
  "place_observation" text NOT NULL,


  		




  
  1067
  
    
  "place_visit" text NOT NULL,


  		




  1068
  1068
  
    
  "subsetting_method" text DEFAULT NULL,


  		




  1069
  1069
  
    
  PRIMARY KEY ("id"),


  		




  1070
  
  
    
  /*CONSTRAINT "taxa_sampling_event__unique" */UNIQUE ("place_observation","subsetting_method"),


  		




  
  1070
  
    
  /*CONSTRAINT "taxa_sampling_event__unique" */UNIQUE ("place_visit","subsetting_method"),


  		




  1071
  1071
  
    
  /*KEY "fk_sampling_event_method1_idx" ("subsetting_method")*/CHECK (true),


  		




  1072
  
  
    
  /*KEY "taxa_sampling_event_id_fkey1_idx" ("place_observation")*/CHECK (true),


  		




  
  1072
  
    
  /*KEY "taxa_sampling_event_id_fkey1_idx" ("place_visit")*/CHECK (true),


  		




  
  1073
  
    
  /*CONSTRAINT "taxa_sampling_event_id_fkey1" FOREIGN KEY ("place_visit") REFERENCES "place_visit" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1073
  1074
  
    
  /*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1074
  
  
    
  /*CONSTRAINT "taxa_sampling_event_id_fkey1" FOREIGN KEY ("place_observation") REFERENCES "place_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1075
  1075
  
    
  /*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("subsetting_method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1076
  1076
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?stratum (which was confusingly named)'*/;


  		




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


  		












Also available in:  Unified diff