Project

General

Profile

« Previous | Next » 

Revision 10959

schemas/VegCore/VegCore.ERD.mwb: taxon_observation: allow any taxon_observation to link directly to a taxa_sampling_event, not just aggregate_observation. this allows any taxon_observation's methodology information to be found directly by joining to taxa_sampling_event. previously, one had to join to event.parent and then taxa_sampling_event, and it was not clear that event.parent would even be a taxa_sampling_event.

View differences:

schemas/VegCore/VegCore.pg.sql
1256 1256
CREATE TABLE "taxon_observation" (
1257 1257
  "id" text NOT NULL,
1258 1258
  "taxon_occurrence" text NOT NULL,
1259
  "sampling_event" text DEFAULT NULL,
1259 1260
  "observation_in_parent_place" text DEFAULT NULL /*COMMENT 'points to the observation of the same taxon/individual in the parent place; = VegBank.vegpath.org?taxonImportance.taxonObservation_ID'*/,
1260 1261
  "collectors" text DEFAULT NULL,
1261 1262
  "collector_number" text DEFAULT NULL,
......
1266 1267
  /*KEY "fk_taxon_observation_party_list1_idx" ("collectors")*/CHECK (true),
1267 1268
  /*KEY "fk_taxon_observation_taxon_observation1_idx" ("observation_in_parent_place")*/CHECK (true),
1268 1269
  /*KEY "fk_taxon_observation_taxon_occurrence1_idx" ("taxon_occurrence")*/CHECK (true),
1270
  /*KEY "fk_taxon_observation_taxa_sampling_event1_idx" ("sampling_event")*/CHECK (true),
1269 1271
  /*CONSTRAINT "fk_taxon_observation_taxon_observation1" FOREIGN KEY ("observation_in_parent_place") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1270
  /*CONSTRAINT "fk_taxon_observation_taxon_occurrence1" FOREIGN KEY ("taxon_occurrence") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1271 1272
  /*CONSTRAINT "fk_taxon_observation_party_list1" FOREIGN KEY ("collectors") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1272
  /*CONSTRAINT "fk_taxon_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1273
  /*CONSTRAINT "fk_taxon_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1274
  /*CONSTRAINT "fk_taxon_observation_taxa_sampling_event1" FOREIGN KEY ("sampling_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1275
  /*CONSTRAINT "fk_taxon_observation_taxon_occurrence1" FOREIGN KEY ("taxon_occurrence") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1273 1276
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
1274 1277
/*!40101 SET character_set_client = @saved_cs_client */;
1275 1278

  
schemas/VegCore/document.mwb.xml
3360 3360
                      <value type="string" key="oldName">taxon_occurrence</value>
3361 3361
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3362 3362
                    </value>
3363
                    <value type="object" struct-name="db.mysql.Column" id="07e2f45e-1dde-11e3-bd5f-080027bcf912" struct-checksum="0x783b5183">
3364
                      <value type="int" key="autoIncrement">0</value>
3365
                      <value type="string" key="characterSetName"></value>
3366
                      <value _ptr_="0xcb559b0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
3367
                      <value type="string" key="collationName"></value>
3368
                      <value type="string" key="datatypeExplicitParams"></value>
3369
                      <value type="string" key="defaultValue"></value>
3370
                      <value type="int" key="defaultValueIsNull">1</value>
3371
                      <value _ptr_="0xc7576a8" type="list" content-type="string" key="flags"/>
3372
                      <value type="int" key="isNotNull">0</value>
3373
                      <value type="int" key="length">767</value>
3374
                      <value type="int" key="precision">-1</value>
3375
                      <value type="int" key="scale">-1</value>
3376
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
3377
                      <value type="string" key="comment"></value>
3378
                      <value type="string" key="name">sampling_event</value>
3379
                      <value type="string" key="oldName">sampling_event</value>
3380
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3381
                    </value>
3363 3382
                    <value type="object" struct-name="db.mysql.Column" id="c1256108-0840-11e3-98e3-080027bcf912" struct-checksum="0x783b5183">
3364 3383
                      <value type="int" key="autoIncrement">0</value>
3365 3384
                      <value type="string" key="characterSetName"></value>
......
3542 3561
                      <value type="string" key="name">fk_taxon_observation_sampling_event1</value>
3543 3562
                      <value type="string" key="oldName">fk_taxon_observation_sampling_event1</value>
3544 3563
                    </value>
3564
                    <value type="object" struct-name="db.mysql.ForeignKey" id="07e2f24c-1dde-11e3-bd5f-080027bcf912" struct-checksum="0x70a8fc40">
3565
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">7f176964-f6c0-11e2-af44-080027bcf912</link>
3566
                      <value _ptr_="0xcb558f0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
3567
                        <link type="object">07e2f45e-1dde-11e3-bd5f-080027bcf912</link>
3568
                      </value>
3569
                      <value type="int" key="deferability">0</value>
3570
                      <value type="string" key="deleteRule">CASCADE</value>
3571
                      <link type="object" struct-name="db.Index" key="index">07e3e7c4-1dde-11e3-bd5f-080027bcf912</link>
3572
                      <value type="int" key="mandatory">1</value>
3573
                      <value type="int" key="many">1</value>
3574
                      <value type="int" key="modelOnly">0</value>
3575
                      <link type="object" struct-name="db.Table" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3576
                      <value _ptr_="0xcb55980" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
3577
                        <link type="object">7f176d06-f6c0-11e2-af44-080027bcf912</link>
3578
                      </value>
3579
                      <value type="int" key="referencedMandatory">0</value>
3580
                      <value type="string" key="updateRule">CASCADE</value>
3581
                      <value type="string" key="comment"></value>
3582
                      <value type="string" key="name">fk_taxon_observation_taxa_sampling_event1</value>
3583
                      <value type="string" key="oldName">fk_taxon_observation_taxa_sampling_event1</value>
3584
                    </value>
3545 3585
                    <value type="object" struct-name="db.mysql.ForeignKey" id="db4e8988-1dc6-11e3-838b-410b6ef2c3ca" struct-checksum="0x70a8fc40">
3546 3586
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">f9d23e32-1dc5-11e3-838b-410b6ef2c3ca</link>
3547 3587
                      <value _ptr_="0xb7c04b8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
3657 3697
                      <value type="string" key="oldName">fk_taxon_observation_taxon_occurrence1_idx</value>
3658 3698
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3659 3699
                    </value>
3700
                    <value type="object" struct-name="db.mysql.Index" id="07e3e7c4-1dde-11e3-bd5f-080027bcf912" struct-checksum="0x309b847a">
3701
                      <value _ptr_="0xcc34db0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
3702
                        <value type="object" struct-name="db.mysql.IndexColumn" id="07e42f18-1dde-11e3-bd5f-080027bcf912" struct-checksum="0x62630b3c">
3703
                          <value type="int" key="columnLength">0</value>
3704
                          <value type="string" key="comment"></value>
3705
                          <value type="int" key="descend">0</value>
3706
                          <link type="object" struct-name="db.Column" key="referencedColumn">07e2f45e-1dde-11e3-bd5f-080027bcf912</link>
3707
                          <value type="string" key="name"></value>
3708
                          <link type="object" struct-name="GrtObject" key="owner">07e3e7c4-1dde-11e3-bd5f-080027bcf912</link>
3709
                        </value>
3710
                      </value>
3711
                      <value type="string" key="indexKind"></value>
3712
                      <value type="int" key="keyBlockSize">0</value>
3713
                      <value type="string" key="withParser"></value>
3714
                      <value type="string" key="comment"></value>
3715
                      <value type="int" key="deferability">0</value>
3716
                      <value type="string" key="indexType">INDEX</value>
3717
                      <value type="int" key="isPrimary">0</value>
3718
                      <value type="string" key="name">fk_taxon_observation_taxa_sampling_event1_idx</value>
3719
                      <value type="int" key="unique">0</value>
3720
                      <value type="string" key="oldName">fk_taxon_observation_taxa_sampling_event1_idx</value>
3721
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3722
                    </value>
3660 3723
                  </value>
3661 3724
                  <value type="string" key="maxRows"></value>
3662 3725
                  <value type="string" key="mergeInsert"></value>
......
3688 3751
                  <value type="int" key="commentedOut">0</value>
3689 3752
                  <value type="string" key="createDate">2013-04-17 13:52</value>
3690 3753
                  <value _ptr_="0xb7bcdc0" type="dict" key="customData"/>
3691
                  <value type="string" key="lastChangeDate">2013-09-14 22:30</value>
3754
                  <value type="string" key="lastChangeDate">2013-09-15 01:10</value>
3692 3755
                  <value type="int" key="modelOnly">0</value>
3693 3756
                  <value type="string" key="name">taxon_observation</value>
3694 3757
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12176 12239
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12177 12240
                      <value type="string" key="comment"></value>
12178 12241
                      <value type="string" key="name">sampling_event</value>
12179
                      <value type="string" key="oldName">taxa_sampling_event_id</value>
12242
                      <value type="string" key="oldName">sampling_event</value>
12180 12243
                      <link type="object" struct-name="GrtObject" key="owner">f15726c2-011f-11e3-9f3a-080027bcf912</link>
12181 12244
                    </value>
12182 12245
                    <value type="object" struct-name="db.mysql.Column" id="f1572d5c-011f-11e3-9f3a-080027bcf912" struct-checksum="0x783b5183">
......
12309 12372
                      <value type="int" key="isPrimary">0</value>
12310 12373
                      <value type="string" key="name">fk_aggregate_observation_taxa_sampling_event1_idx</value>
12311 12374
                      <value type="int" key="unique">0</value>
12312
                      <value type="string" key="oldName">fk_aggregate_observation_taxa_sampling_event1</value>
12375
                      <value type="string" key="oldName">fk_aggregate_observation_taxa_sampling_event1_idx</value>
12313 12376
                      <link type="object" struct-name="GrtObject" key="owner">f15726c2-011f-11e3-9f3a-080027bcf912</link>
12314 12377
                    </value>
12315 12378
                  </value>
......
14630 14693
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
14631 14694
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
14632 14695
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">686ec05a-f9bc-11e2-a599-080027bcf912</link>
14633
                <value type="real" key="middleSegmentOffset">6.616848308009821266750805079936981201171875e+00</value>
14696
                <value type="real" key="middleSegmentOffset">3.2323156221970066326321102678775787353515625e+00</value>
14634 14697
                <value type="real" key="startCaptionXOffs">0.e+00</value>
14635 14698
                <value type="real" key="startCaptionYOffs">0.e+00</value>
14636 14699
                <value type="int" key="drawSplit">0</value>
......
15417 15480
                <value type="int" key="visible">1</value>
15418 15481
                <value type="string" key="name"></value>
15419 15482
              </value>
15483
              <value type="object" struct-name="workbench.physical.Connection" id="07e46488-1dde-11e3-bd5f-080027bcf912" struct-checksum="0x9baebc92">
15484
                <value type="string" key="caption">fk_taxon_observation_taxa_sampling_event1</value>
15485
                <value type="real" key="captionXOffs">0.e+00</value>
15486
                <value type="real" key="captionYOffs">0.e+00</value>
15487
                <value type="string" key="comment"></value>
15488
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15489
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15490
                <value type="string" key="extraCaption"></value>
15491
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15492
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15493
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">07e2f24c-1dde-11e3-bd5f-080027bcf912</link>
15494
                <value type="real" key="middleSegmentOffset">-8.2460935756276512620388530194759368896484375e+01</value>
15495
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15496
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15497
                <value type="int" key="drawSplit">0</value>
15498
                <link type="object" struct-name="model.Figure" key="endFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
15499
                <link type="object" struct-name="model.Figure" key="startFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
15500
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15501
                <value type="int" key="visible">1</value>
15502
                <value type="string" key="name"></value>
15503
              </value>
15420 15504
            </value>
15421 15505
            <value type="string" key="description"></value>
15422 15506
            <value _ptr_="0xb847598" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
15646 15730
                <value type="int" key="expanded">1</value>
15647 15731
                <value type="real" key="height">1.46e+02</value>
15648 15732
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15649
                <value type="real" key="left">6.76e+02</value>
15733
                <value type="real" key="left">6.65e+02</value>
15650 15734
                <value type="int" key="locked">0</value>
15651 15735
                <value type="int" key="manualSizing">0</value>
15652
                <value type="real" key="top">2.3e+01</value>
15736
                <value type="real" key="top">2.7e+01</value>
15653 15737
                <value type="real" key="width">1.02e+02</value>
15654 15738
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15655 15739
                <value type="int" key="visible">1</value>
......
16315 16399
                <value type="real" key="left">6.2e+02</value>
16316 16400
                <value type="int" key="locked">0</value>
16317 16401
                <value type="int" key="manualSizing">0</value>
16318
                <value type="real" key="top">1.95e+02</value>
16402
                <value type="real" key="top">2.02e+02</value>
16319 16403
                <value type="real" key="width">9.9e+01</value>
16320 16404
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16321 16405
                <value type="int" key="visible">1</value>
......
16430 16514
                <value type="int" key="triggersExpanded">0</value>
16431 16515
                <value type="string" key="color">#FFFF00</value>
16432 16516
                <value type="int" key="expanded">1</value>
16433
                <value type="real" key="height">2.15e+02</value>
16517
                <value type="real" key="height">2.38e+02</value>
16434 16518
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16435 16519
                <value type="real" key="left">8.56e+02</value>
16436 16520
                <value type="int" key="locked">0</value>
16437 16521
                <value type="int" key="manualSizing">0</value>
16438
                <value type="real" key="top">1.72e+02</value>
16522
                <value type="real" key="top">1.66e+02</value>
16439 16523
                <value type="real" key="width">1.63e+02</value>
16440 16524
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16441 16525
                <value type="int" key="visible">1</value>
......
16851 16935
                <value type="int" key="expanded">1</value>
16852 16936
                <value type="real" key="height">7.7e+01</value>
16853 16937
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16854
                <value type="real" key="left">6.74e+02</value>
16938
                <value type="real" key="left">6.63e+02</value>
16855 16939
                <value type="int" key="locked">0</value>
16856 16940
                <value type="int" key="manualSizing">0</value>
16857
                <value type="real" key="top">4.73e+02</value>
16941
                <value type="real" key="top">4.74e+02</value>
16858 16942
                <value type="real" key="width">9.3e+01</value>
16859 16943
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16860 16944
                <value type="int" key="visible">1</value>
......
17138 17222
              <value type="int" key="visible">1</value>
17139 17223
              <value type="string" key="name"></value>
17140 17224
            </value>
17141
            <value _ptr_="0xb847670" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17225
            <value _ptr_="0xb847670" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17226
              <link type="object">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
17227
            </value>
17142 17228
            <value type="int" key="updateBlocked">0</value>
17143 17229
            <value type="real" key="width">1.6215e+03</value>
17144 17230
            <value type="real" key="x">0.e+00</value>
......
17150 17236
        <value _ptr_="0xb79df90" type="list" content-type="object" content-struct-name="GrtStoredNote" key="notes"/>
17151 17237
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17152 17238
        <value _ptr_="0xb79dfc0" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17153
        <value _ptr_="0xada6440" type="dict" key="syncProfiles"/>
17239
        <value _ptr_="0xada6440" type="dict" key="syncProfiles">
17240
          <value type="object" struct-name="db.mgmt.SyncProfile" id="7f189cfe-1dde-11e3-bd5f-080027bcf912" struct-checksum="0xc64972c2" key="">
17241
            <value _ptr_="0xc5acfc8" type="dict" key="lastKnownDBNames">
17242
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17243
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17244
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
17245
              <value type="string" key="04149c40-fa90-11e2-83d9-080027bcf912">official_name</value>
17246
              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>
17247
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>
17248
              <value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value>
17249
              <value type="string" key="049e0370-a91b-11e2-bdec-080027bcf912">PRIMARY</value>
17250
              <value type="string" key="07e2f24c-1dde-11e3-bd5f-080027bcf912">fk_taxon_observation_taxa_sampling_event1</value>
17251
              <value type="string" key="07e2f45e-1dde-11e3-bd5f-080027bcf912">sampling_event</value>
17252
              <value type="string" key="07e3e7c4-1dde-11e3-bd5f-080027bcf912">fk_taxon_observation_taxa_sampling_event1_idx</value>
17253
              <value type="string" key="08481eda-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>
17254
              <value type="string" key="08483334-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>
17255
              <value type="string" key="09a29b5c-1dd2-11e3-b98c-080027bcf912">fk_taxon_occurrence_place1</value>
17256
              <value type="string" key="09a29d14-1dd2-11e3-b98c-080027bcf912">within_place</value>
17257
              <value type="string" key="09a2b70e-1dd2-11e3-b98c-080027bcf912">fk_taxon_occurrence_place1_idx</value>
17258
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">boundary_WKT</value>
17259
              <value type="string" key="0ab9880e-a7a1-11e2-b667-080027bcf912">individual_observation</value>
17260
              <value type="string" key="0ab98a66-a7a1-11e2-b667-080027bcf912">id</value>
17261
              <value type="string" key="0ab98c50-a7a1-11e2-b667-080027bcf912">individual</value>
17262
              <value type="string" key="0ab98e12-a7a1-11e2-b667-080027bcf912">traits</value>
17263
              <value type="string" key="0ab99006-a7a1-11e2-b667-080027bcf912">PRIMARY</value>
17264
              <value type="string" key="0ab99376-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1_idx</value>
17265
              <value type="string" key="0ab99696-a7a1-11e2-b667-080027bcf912">fk_individual_observation_taxon_occurrence1</value>
17266
              <value type="string" key="0ab99812-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1</value>
17267
              <value type="string" key="10b01930-1dcb-11e3-b98c-080027bcf912">fk_taxon_occurrence_taxon_determination3_idx</value>
17268
              <value type="string" key="110c72d2-a73f-11e2-9fbf-080027bcf912">stem_observation_unique</value>
17269
              <value type="string" key="11b487b4-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1</value>
17270
              <value type="string" key="11b489bc-f97f-11e2-8a2e-080027bcf912">taxon_path</value>
17271
              <value type="string" key="11b49e5c-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1_idx</value>
17272
              <value type="string" key="11c10cc8-a90c-11e2-8576-080027bcf912">source_unique</value>
17273
              <value type="string" key="1388436e-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1</value>
17274
              <value type="string" key="13884530-f9c5-11e2-9af4-080027bcf912">parent</value>
17275
              <value type="string" key="13885958-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1_idx</value>
17276
              <value type="string" key="1427502e-1bf0-11e3-849d-080027bcf912">fk_reobservable_presence_reobservable2</value>
17277
              <value type="string" key="14276b0e-1bf0-11e3-849d-080027bcf912">fk_reobservable_presence_reobservable2_idx</value>
17278
              <value type="string" key="16537a20-a7a7-11e2-8ba6-080027bcf912">taxon_observation</value>
17279
              <value type="string" key="16537d54-a7a7-11e2-8ba6-080027bcf912">id</value>
17280
              <value type="string" key="16538808-a7a7-11e2-8ba6-080027bcf912">growth_form</value>
17281
              <value type="string" key="165389fc-a7a7-11e2-8ba6-080027bcf912">cultivated</value>
17282
              <value type="string" key="16538c2c-a7a7-11e2-8ba6-080027bcf912">traits</value>
17283
              <value type="string" key="165395c8-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
17284
              <value type="string" key="177949e8-f9c8-11e2-b815-080027bcf912">fk_individual_place1</value>
17285
              <value type="string" key="17796428-f9c8-11e2-b815-080027bcf912">fk_individual_place1_idx</value>
17286
              <value type="string" key="17d59e68-a794-11e2-84c3-080027bcf912">info</value>
17287
              <value type="string" key="181c8a8a-0077-11e3-906b-080027bcf912">height_min_m</value>
17288
              <value type="string" key="1832712c-a77d-11e2-afd5-080027bcf912">taxon_concept</value>
17289
              <value type="string" key="18327370-a77d-11e2-afd5-080027bcf912">id</value>
17290
              <value type="string" key="18327514-a77d-11e2-afd5-080027bcf912">according_to</value>
17291
              <value type="string" key="18327686-a77d-11e2-afd5-080027bcf912">parent</value>
17292
              <value type="string" key="183277ee-a77d-11e2-afd5-080027bcf912">accepted_taxon_concept</value>
17293
              <value type="string" key="1832797e-a77d-11e2-afd5-080027bcf912">PRIMARY</value>
17294
              <value type="string" key="18327c76-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1_idx</value>
17295
              <value type="string" key="18327f64-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1_idx</value>
17296
              <value type="string" key="1832823e-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1_idx</value>
17297
              <value type="string" key="18328522-a77d-11e2-afd5-080027bcf912">taxon_concept_unique_name</value>
17298
              <value type="string" key="183287f2-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1</value>
17299
              <value type="string" key="18328950-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1</value>
17300
              <value type="string" key="18328a9a-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1</value>
17301
              <value type="string" key="18328be4-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_name1</value>
17302
              <value type="string" key="184d9a4a-a793-11e2-84c3-080027bcf912">observations</value>
17303
              <value type="string" key="18e739f0-a91b-11e2-bdec-080027bcf912">fk_organization_party1</value>
17304
              <value type="string" key="1b07bbcc-1dcb-11e3-b98c-080027bcf912">fk_reobservable_taxon_determination1_idx</value>
17305
              <value type="string" key="1b1bf6e4-0077-11e3-906b-080027bcf912">height_max_m</value>
17306
              <value type="string" key="1c952e1c-a791-11e2-84c3-080027bcf912">y_m</value>
17307
              <value type="string" key="1e711948-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_occurrence_record1</value>
17308
              <value type="string" key="21b40060-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1</value>
17309
              <value type="string" key="21b41366-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1_idx</value>
17310
              <value type="string" key="21c8f928-fa8d-11e2-9ba8-080027bcf912">fk_geovalidation_georeferencing1</value>
17311
              <value type="string" key="2213caf6-f971-11e2-9f36-080027bcf912">fk_georeferencing_geoplace1</value>
17312
              <value type="string" key="2213dee2-f971-11e2-9f36-080027bcf912">fk_georeferencing_geoplace1_idx</value>
17313
              <value type="string" key="238b4ae4-a700-11e2-9461-080027bcf912">stratum</value>
17314
              <value type="string" key="238b4f6c-a700-11e2-9461-080027bcf912">id</value>
17315
              <value type="string" key="238b53d6-a700-11e2-9461-080027bcf912">fk_place_path_record10</value>
17316
              <value type="string" key="23ec4078-0075-11e3-906b-080027bcf912">layer</value>
17317
              <value type="string" key="23ec4406-0075-11e3-906b-080027bcf912">id</value>
17318
              <value type="string" key="23ec4726-0075-11e3-906b-080027bcf912">name</value>
17319
              <value type="string" key="23ec49ec-0075-11e3-906b-080027bcf912">info</value>
17320
              <value type="string" key="23ec4e92-0075-11e3-906b-080027bcf912">PRIMARY</value>
17321
              <value type="string" key="245083fa-a763-11e2-aa10-080027bcf912">geovalidation</value>
17322
              <value type="string" key="24508724-a763-11e2-aa10-080027bcf912">id</value>
17323
              <value type="string" key="2450919c-a763-11e2-aa10-080027bcf912">PRIMARY</value>
17324
              <value type="string" key="251c29a8-f67b-11e2-aebb-080027bcf912">fk_event_party_list1</value>
17325
              <value type="string" key="251c2b92-f67b-11e2-aebb-080027bcf912">participants</value>
17326
              <value type="string" key="251c57de-f67b-11e2-aebb-080027bcf912">fk_event_party_list1_idx</value>
17327
              <value type="string" key="2673b9ee-f9bc-11e2-a599-080027bcf912">subplot</value>
17328
              <value type="string" key="2673bdc2-f9bc-11e2-a599-080027bcf912">id</value>
17329
              <value type="string" key="2673d532-f9bc-11e2-a599-080027bcf912">PRIMARY</value>
17330
              <value type="string" key="26b22c2a-011d-11e3-9f3a-080027bcf912">fk_taxon_absence_taxa_sampling_event1</value>
17331
              <value type="string" key="273737e8-a796-11e2-84c3-080027bcf912">tag</value>
17332
              <value type="string" key="293dc5b4-0085-11e3-ac06-080027bcf912">fk_reobservable_presence_taxon_presence1</value>
17333
              <value type="string" key="29c29602-a7a4-11e2-8ba6-080027bcf912">common_name</value>
17334
              <value type="string" key="2a08cd96-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1</value>
17335
              <value type="string" key="2a08de6c-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1_idx</value>
17336
              <value type="string" key="2d3c42f6-0078-11e3-906b-080027bcf912">fk_place_observation_event1</value>
17337
              <value type="string" key="2ed4b280-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1</value>
17338
              <value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value>
17339
              <value type="string" key="2f07b8cc-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1</value>
17340
              <value type="string" key="2f07bade-0127-11e3-9f3a-080027bcf912">identifying_place</value>
17341
              <value type="string" key="2f07d0b4-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1_idx</value>
17342
              <value type="string" key="2f5fcbcc-a793-11e2-84c3-080027bcf912">observations</value>
17343
              <value type="string" key="323a36d4-011b-11e3-b872-080027bcf912">fk_individual_observation_place1</value>
17344
              <value type="string" key="323a39a4-011b-11e3-b872-080027bcf912">place_observed_at</value>
17345
              <value type="string" key="323a5f56-011b-11e3-b872-080027bcf912">fk_individual_observation_place1_idx</value>
17346
              <value type="string" key="3292225e-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1</value>
17347
              <value type="string" key="3292247a-f6df-11e2-b6d1-080027bcf912">input_geoplace</value>
17348
              <value type="string" key="329238b6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1_idx</value>
17349
              <value type="string" key="3587a3e0-1dc6-11e3-838b-410b6ef2c3ca">fk_reobservable_taxon_occurrence1</value>
17350
              <value type="string" key="35cce77e-f6df-11e2-b6d1-080027bcf912">corrected_geoplace</value>
17351
              <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">verbatim</value>
17352
              <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>
17353
              <value type="string" key="3d9b13d2-a7a1-11e2-b667-080027bcf912">id</value>
17354
              <value type="string" key="3d9b17ba-a7a1-11e2-b667-080027bcf912">taxon_assertion</value>
17355
              <value type="string" key="3d9b197c-a7a1-11e2-b667-080027bcf912">identified_by</value>
17356
              <value type="string" key="3d9b1d28-a7a1-11e2-b667-080027bcf912">fit_info</value>
17357
              <value type="string" key="3d9b1f30-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1_idx</value>
17358
              <value type="string" key="3d9b26c4-a7a1-11e2-b667-080027bcf912">PRIMARY</value>
17359
              <value type="string" key="3d9b2d86-a7a1-11e2-b667-080027bcf912">taxon_determination_unique</value>
17360
              <value type="string" key="3d9b3600-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1</value>
17361
              <value type="string" key="4001ec92-f678-11e2-9716-080027bcf912">party_list</value>
17362
              <value type="string" key="4001ef9e-f678-11e2-9716-080027bcf912">id</value>
17363
              <value type="string" key="4001f296-f678-11e2-9716-080027bcf912">count</value>
17364
              <value type="string" key="4001f692-f678-11e2-9716-080027bcf912">fk_collection_source100</value>
17365
              <value type="string" key="4001fa52-f678-11e2-9716-080027bcf912">PRIMARY</value>
17366
              <value type="string" key="400c0dc2-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1</value>
17367
              <value type="string" key="400c0fac-f6d1-11e2-a35e-080027bcf912">parsed_taxon_assertion</value>
17368
              <value type="string" key="400c2370-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1_idx</value>
17369
              <value type="string" key="40e95b66-acfb-11e2-b309-080027bcf912">fk_method_method1</value>
17370
              <value type="string" key="40e95d64-acfb-11e2-b309-080027bcf912">parent</value>
17371
              <value type="string" key="40e971d2-acfb-11e2-b309-080027bcf912">fk_method_method1_idx</value>
17372
              <value type="string" key="415f1a26-ad15-11e2-9617-080027bcf912">specimen_unique_in_individual</value>
17373
              <value type="string" key="42266085-54CC-4441-8553-68BBE0286A05">default</value>
17374
              <value type="string" key="42405474-a783-11e2-afd5-080027bcf912">annotations</value>
17375
              <value type="string" key="426f5d76-1dcd-11e3-b98c-080027bcf912">fk_individual_count_taxon_presence1</value>
17376
              <value type="string" key="43cfb7dc-a790-11e2-84c3-080027bcf912">lat_long_domain_valid</value>
17377
              <value type="string" key="43f62c16-ad1a-11e2-9d85-080027bcf912">info</value>
17378
              <value type="string" key="43f70d90-f679-11e2-9716-080027bcf912">sort_order</value>
17379
              <value type="string" key="44e36b2c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1</value>
17380
              <value type="string" key="44e36d02-a7b4-11e2-97d7-080027bcf912">specimen</value>
17381
              <value type="string" key="44e38f6c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1_idx</value>
17382
              <value type="string" key="45a3f404-ad0f-11e2-b309-080027bcf912">name</value>
17383
              <value type="string" key="47b3b670-0076-11e3-906b-080027bcf912">diameter_max_m</value>
17384
              <value type="string" key="4824526a-a791-11e2-84c3-080027bcf912">area_m2</value>
17385
              <value type="string" key="489c177a-a6ea-11e2-98a6-080027bcf912">referenced_class</value>
17386
              <value type="string" key="489c19be-a6ea-11e2-98a6-080027bcf912">id</value>
17387
              <value type="string" key="489c1b62-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
17388
              <value type="string" key="489c1e64-a6ea-11e2-98a6-080027bcf912">fk_example_record10</value>
17389
              <value type="string" key="489c25e4-a6ea-11e2-98a6-080027bcf912">base_class</value>
17390
              <value type="string" key="489c281e-a6ea-11e2-98a6-080027bcf912">id</value>
17391
              <value type="string" key="489c29c2-a6ea-11e2-98a6-080027bcf912">referenced_class</value>
17392
              <value type="string" key="489c2b34-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
17393
              <value type="string" key="489c2e22-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1_idx</value>
17394
              <value type="string" key="489c325a-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1</value>
17395
              <value type="string" key="489c3958-a6ea-11e2-98a6-080027bcf912">derived_class</value>
17396
              <value type="string" key="489c3b9c-a6ea-11e2-98a6-080027bcf912">id</value>
17397
              <value type="string" key="489c3d40-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
17398
              <value type="string" key="489c402e-a6ea-11e2-98a6-080027bcf912">fk_derived_class_base_class1</value>
17399
              <value type="string" key="48af0dca-a795-11e2-84c3-080027bcf912">slope_direction_deg_N</value>
17400
              <value type="string" key="49a23428-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2</value>
17401
              <value type="string" key="49a235d6-f9c5-11e2-9af4-080027bcf912">parent_plot</value>
17402
              <value type="string" key="49a26722-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2_idx</value>
17403
              <value type="string" key="4c32a89c-a76a-11e2-92a3-080027bcf912">match_score</value>
17404
              <value type="string" key="4c3ffc96-a741-11e2-9fbf-080027bcf912">taxon_string</value>
17405
              <value type="string" key="4c40001a-a741-11e2-9fbf-080027bcf912">string</value>
17406
              <value type="string" key="4c4005b0-a741-11e2-9fbf-080027bcf912">PRIMARY</value>
17407
              <value type="string" key="4e241b94-ad15-11e2-9617-080027bcf912">specimen_unique_by_collection_event</value>
17408
              <value type="string" key="4e34b204-f9c5-11e2-9af4-080027bcf912">fk_subplot_rel_place1</value>
17409
              <value type="string" key="4ee0a0e2-a794-11e2-84c3-080027bcf912">info</value>
17410
              <value type="string" key="4f2d2f86-f986-11e2-8a2e-080027bcf912">info</value>
17411
              <value type="string" key="5077e4de-a748-11e2-9fbf-080027bcf912">taxon</value>
17412
              <value type="string" key="523d417c-f96b-11e2-9fb4-080027bcf912">parent_geoplace</value>
17413
              <value type="string" key="5256ac76-f983-11e2-8a2e-080027bcf912">azimuth_deg_N</value>
17414
              <value type="string" key="54dd4bd4-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1</value>
17415
              <value type="string" key="54dd4d82-f67d-11e2-aebb-080027bcf912">specimenholder_institutions</value>
17416
              <value type="string" key="54dd6466-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1_idx</value>
17417
              <value type="string" key="57512c00-ac86-11e2-aa54-080027bcf912">PRIMARY</value>
17418
              <value type="string" key="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>
17419
              <value type="string" key="59b33ca8-f6ba-11e2-aebb-080027bcf912">taxon_absence</value>
17420
              <value type="string" key="59b33fe6-f6ba-11e2-aebb-080027bcf912">id</value>
17421
              <value type="string" key="59b34b30-f6ba-11e2-aebb-080027bcf912">PRIMARY</value>
17422
              <value type="string" key="5a0331b2-f96d-11e2-9fb4-080027bcf912">name</value>
17423
              <value type="string" key="5a8a530a-1dca-11e3-b98c-080027bcf912">fk_reobservable_taxon_determination1</value>
17424
              <value type="string" key="5a8a54cc-1dca-11e3-b98c-080027bcf912">original_observation</value>
17425
              <value type="string" key="5b345f5e-f957-11e2-8597-080027bcf912">fk_taxon_determination_taxon_observation1</value>
17426
              <value type="string" key="5c62b4f2-ad03-11e2-b309-080027bcf912">code</value>
17427
              <value type="string" key="5e41c0d2-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1</value>
17428
              <value type="string" key="5e41cb90-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1_idx</value>
17429
              <value type="string" key="648b8c10-0075-11e3-906b-080027bcf912">fk_layer_stratum1</value>
17430
              <value type="string" key="65752312-0119-11e3-b872-080027bcf912">cover_percent</value>
17431
              <value type="string" key="66675a70-f970-11e2-9f36-080027bcf912">fk_geoplace_place1</value>
17432
              <value type="string" key="66c25c1c-a791-11e2-84c3-080027bcf912">length_m</value>
17433
              <value type="string" key="67fa5b28-f6c1-11e2-af44-080027bcf912">fk_taxon_observation_sampling_event1</value>
17434
              <value type="string" key="6856853a-a796-11e2-84c3-080027bcf912">traits</value>
17435
              <value type="string" key="686ec05a-f9bc-11e2-a599-080027bcf912">fk_subplot_plot1</value>
17436
              <value type="string" key="687f12b8-a780-11e2-afd5-080027bcf912">taxon_name</value>
17437
              <value type="string" key="687f1542-a780-11e2-afd5-080027bcf912">id</value>
17438
              <value type="string" key="687f1718-a780-11e2-afd5-080027bcf912">unique_name</value>
17439
              <value type="string" key="687f18b2-a780-11e2-afd5-080027bcf912">formal_name</value>
17440
              <value type="string" key="687f1a6a-a780-11e2-afd5-080027bcf912">taxon_name</value>
17441
              <value type="string" key="687f1c2c-a780-11e2-afd5-080027bcf912">author</value>
17442
              <value type="string" key="687f1dda-a780-11e2-afd5-080027bcf912">rank</value>
17443
              <value type="string" key="687f1f92-a780-11e2-afd5-080027bcf912">PRIMARY</value>
17444
              <value type="string" key="687f22b2-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10_idx</value>
17445
              <value type="string" key="687f25a0-a780-11e2-afd5-080027bcf912">fk_taxon_record10</value>
17446
              <value type="string" key="687f26f4-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10</value>
17447
              <value type="string" key="687f2f28-a780-11e2-afd5-080027bcf912">taxon_path</value>
17448
              <value type="string" key="687f31c6-a780-11e2-afd5-080027bcf912">id</value>
17449
              <value type="string" key="687f339c-a780-11e2-afd5-080027bcf912">family</value>
17450
              <value type="string" key="687f3590-a780-11e2-afd5-080027bcf912">genus</value>
17451
              <value type="string" key="687f3752-a780-11e2-afd5-080027bcf912">specific_epithet</value>
17452
              <value type="string" key="687f3900-a780-11e2-afd5-080027bcf912">ranks</value>
17453
              <value type="string" key="687f3ae0-a780-11e2-afd5-080027bcf912">PRIMARY</value>
17454
              <value type="string" key="68bcc4bc-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1</value>
17455
              <value type="string" key="68bcc6ce-0083-11e3-ac06-080027bcf912">taxon</value>
17456
              <value type="string" key="68bcdca4-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1_idx</value>
17457
              <value type="string" key="69b7c87c-f970-11e2-9f36-080027bcf912">fk_nested_geoplace_geoplace1</value>
17458
              <value type="string" key="6b43aacc-f979-11e2-9f36-080027bcf912">fk_place_geopath1</value>
17459
              <value type="string" key="6b43ac84-f979-11e2-9f36-080027bcf912">geopath</value>
17460
              <value type="string" key="6b43c264-f979-11e2-9f36-080027bcf912">fk_place_geopath1_idx</value>
17461
              <value type="string" key="6b54505e-ad0f-11e2-b309-080027bcf912">collection_unique</value>
17462
              <value type="string" key="6c2bb9d2-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1</value>
17463
              <value type="string" key="6c2bbbb2-0083-11e3-ac06-080027bcf912">size_class</value>
17464
              <value type="string" key="6c2bd08e-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1_idx</value>
17465
              <value type="string" key="6ec4a89c-ad05-11e2-b309-080027bcf912">fk_specimen_individual1</value>
17466
              <value type="string" key="6ec4aa86-ad05-11e2-b309-080027bcf912">individual</value>
17467
              <value type="string" key="6ec4c2fa-ad05-11e2-b309-080027bcf912">fk_specimen_individual1_idx</value>
17468
              <value type="string" key="7255cc48-1beb-11e3-8de9-080027bcf912">specimen_unique_in_individual_observation</value>
17469
              <value type="string" key="74709b22-a795-11e2-84c3-080027bcf912">slope_incline_deg</value>
17470
              <value type="string" key="782db00a-a782-11e2-afd5-080027bcf912">match_info</value>
17471
              <value type="string" key="7afebdc8-0075-11e3-906b-080027bcf912">size_class</value>
17472
              <value type="string" key="7afec156-0075-11e3-906b-080027bcf912">id</value>
17473
              <value type="string" key="7afec49e-0075-11e3-906b-080027bcf912">diameter_min_m</value>
17474
              <value type="string" key="7afec6ec-0075-11e3-906b-080027bcf912">info</value>
17475
              <value type="string" key="7afec93a-0075-11e3-906b-080027bcf912">fk_layer_stratum10</value>
17476
              <value type="string" key="7afecb88-0075-11e3-906b-080027bcf912">PRIMARY</value>
17477
              <value type="string" key="7c31a514-f96f-11e2-9f36-080027bcf912">boundary_WKT</value>
17478
              <value type="string" key="7cd351c8-1168-11e3-8d7f-080027bcf912">fk_specimen_individual_observation1</value>
17479
              <value type="string" key="7cd35394-1168-11e3-8d7f-080027bcf912">individual_observation</value>
17480
              <value type="string" key="7cd372b6-1168-11e3-8d7f-080027bcf912">fk_specimen_individual_observation1_idx</value>
17481
              <value type="string" key="7d6806c8-f95e-11e2-8597-080027bcf912">description</value>
17482
              <value type="string" key="7f176964-f6c0-11e2-af44-080027bcf912">taxa_sampling_event</value>
17483
              <value type="string" key="7f176d06-f6c0-11e2-af44-080027bcf912">id</value>
17484
              <value type="string" key="7f177512-f6c0-11e2-af44-080027bcf912">fk_project_event10</value>
17485
              <value type="string" key="7f177760-f6c0-11e2-af44-080027bcf912">PRIMARY</value>
17486
              <value type="string" key="7f3654cc-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_barcode</value>
17487
              <value type="string" key="803980c8-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1</value>
17488
              <value type="string" key="8039828a-f6d1-11e2-a35e-080027bcf912">input_string</value>
17489
              <value type="string" key="80399806-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1_idx</value>
17490
              <value type="string" key="81937b1c-ad12-11e2-b309-080027bcf912">fk_collection_source1_idx</value>
17491
              <value type="string" key="83dbd4da-f6e8-11e2-9cf1-080027bcf912">georeferencing</value>
17492
              <value type="string" key="83dbd8ae-f6e8-11e2-9cf1-080027bcf912">id</value>
17493
              <value type="string" key="83dbdbec-f6e8-11e2-9cf1-080027bcf912">input_place</value>
17494
              <value type="string" key="83dbe060-f6e8-11e2-9cf1-080027bcf912">fk_geovalidation_record100</value>
17495
              <value type="string" key="83dbe6aa-f6e8-11e2-9cf1-080027bcf912">PRIMARY</value>
17496
              <value type="string" key="8535dbc2-006c-11e3-895c-080027bcf912">stratum_event</value>
17497
              <value type="string" key="8535dfbe-006c-11e3-895c-080027bcf912">id</value>
17498
              <value type="string" key="8535e306-006c-11e3-895c-080027bcf912">stratum</value>
17499
              <value type="string" key="8535e982-006c-11e3-895c-080027bcf912">PRIMARY</value>
17500
              <value type="string" key="8542fbb8-a793-11e2-84c3-080027bcf912">info</value>
17501
              <value type="string" key="8b8a694e-a792-11e2-84c3-080027bcf912">name</value>
17502
              <value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value>
17503
              <value type="string" key="8f0c3678-f978-11e2-9f36-080027bcf912">rank</value>
17504
              <value type="string" key="913a6e06-008a-11e3-9629-080027bcf912">fk_soil_observation_record1</value>
17505
              <value type="string" key="92fc2776-1be6-11e3-af49-080027bcf912">defining_data</value>
17506
              <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>
17507
              <value type="string" key="95e0feca-a793-11e2-84c3-080027bcf912">info</value>
17508
              <value type="string" key="978ed2dc-f9c4-11e2-9af4-080027bcf912">within_place</value>
17509
              <value type="string" key="98e532e4-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1</value>
17510
              <value type="string" key="98e534d8-008a-11e3-9629-080027bcf912">place_observation</value>
17511
              <value type="string" key="98e5491e-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1_idx</value>
17512
              <value type="string" key="9b006114-f6d2-11e2-a35e-080027bcf912">fk_taxon_scrub_record1</value>
17513
              <value type="string" key="9b6b7d6a-ad0c-11e2-b309-080027bcf912">fk_parsed_taxon_assertion_taxon_name1_idx</value>
17514
              <value type="string" key="9d6c9e9a-f678-11e2-9716-080027bcf912">party_list_entry</value>
17515
              <value type="string" key="9d6ca408-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party_list1</value>
17516
              <value type="string" key="9d6ca570-f678-11e2-9716-080027bcf912">id</value>
17517
              <value type="string" key="9d6ca7aa-f678-11e2-9716-080027bcf912">PRIMARY</value>
17518
              <value type="string" key="9d6cb042-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1</value>
17519
              <value type="string" key="9d6cb150-f678-11e2-9716-080027bcf912">entry</value>
17520
              <value type="string" key="9d6cb812-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1_idx</value>
17521
              <value type="string" key="9d6cbbd2-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party_list1_idx</value>
17522
              <value type="string" key="9f4bd98c-a6fb-11e2-9461-080027bcf912">plot</value>
17523
              <value type="string" key="9f4bdd10-a6fb-11e2-9461-080027bcf912">id</value>
17524
              <value type="string" key="9f4be008-a6fb-11e2-9461-080027bcf912">fk_subplot_place1</value>
17525
              <value type="string" key="9f4be256-a6fb-11e2-9461-080027bcf912">PRIMARY</value>
17526
              <value type="string" key="9f58576a-a792-11e2-84c3-080027bcf912">name</value>
17527
              <value type="string" key="a01e225c-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1</value>
17528
              <value type="string" key="a01e269e-a741-11e2-9fbf-080027bcf912">string</value>
17529
              <value type="string" key="a01e47fa-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1_idx</value>
17530
              <value type="string" key="a0266c92-a92a-11e2-93c8-080027bcf912">latitude_deg</value>
17531
              <value type="string" key="a09e45d4-a79d-11e2-a346-080027bcf912">source_record_id</value>
17532
              <value type="string" key="a2fe2068-a790-11e2-84c3-080027bcf912">name</value>
17533
              <value type="string" key="a3e070f8-a77c-11e2-afd5-080027bcf912">fk_parsed_taxon_assertion_taxon_name1</value>
17534
              <value type="string" key="a45bf56a-f980-11e2-8a2e-080027bcf912">fk_subplot_place2</value>
17535
              <value type="string" key="a60e3a24-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_accession_number</value>
17536
              <value type="string" key="a8348424-a78f-11e2-84c3-080027bcf912">geovalid</value>
17537
              <value type="string" key="a841b894-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1</value>
17538
              <value type="string" key="a841ba7e-f6c0-11e2-af44-080027bcf912">method</value>
17539
              <value type="string" key="a842920a-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1_idx</value>
17540
              <value type="string" key="a882f398-0117-11e3-b872-080027bcf912">count</value>
17541
              <value type="string" key="aa191bd2-a92a-11e2-93c8-080027bcf912">longitude_deg</value>
17542
              <value type="string" key="ab3ef4b0-1dc8-11e3-b98c-080027bcf912">fk_taxon_occurrence_taxon_determination3</value>
17543
              <value type="string" key="ab3ef6ae-1dc8-11e3-b98c-080027bcf912">current_observation</value>
17544
              <value type="string" key="ab56b99c-1ddc-11e3-bd5f-080027bcf912">fk_aggregate_observation_taxa_sampling_event1</value>
17545
              <value type="string" key="ab56bc12-1ddc-11e3-bd5f-080027bcf912">sampling_event</value>
17546
              <value type="string" key="ab56d2f6-1ddc-11e3-bd5f-080027bcf912">fk_aggregate_observation_taxa_sampling_event1_idx</value>
17547
              <value type="string" key="ae7761fe-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1</value>
17548
              <value type="string" key="ae7763ca-008a-11e3-9629-080027bcf912">measurement_spot</value>
17549
              <value type="string" key="ae777b3a-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1_idx</value>
17550
              <value type="string" key="aed5d5c4-a769-11e2-92a3-080027bcf912">cf_aff</value>
17551
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>
17552
              <value type="string" key="b3ac613c-0086-11e3-ac06-080027bcf912">fk_reobservable_presence_reobservable1</value>
17553
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>
17554
              <value type="string" key="b8ce339a-a797-11e2-8681-080027bcf912">fk_stem_individual2</value>
17555
              <value type="string" key="b922e5ba-006c-11e3-895c-080027bcf912">fk_stratum_event_stratum1</value>
17556
              <value type="string" key="b922fa5a-006c-11e3-895c-080027bcf912">fk_stratum_event_stratum1_idx</value>
17557
              <value type="string" key="b95efb72-f982-11e2-8a2e-080027bcf912">width_m</value>
17558
              <value type="string" key="b9695d2e-a793-11e2-84c3-080027bcf912">info</value>
17559
              <value type="string" key="b9be8c42-acff-11e2-b309-080027bcf912">collectors</value>
17560
              <value type="string" key="bb0eaf44-ad10-11e2-b309-080027bcf912">current_collection</value>
17561
              <value type="string" key="bbbbdd9c-ad09-11e2-b309-080027bcf912">code_in_individual</value>
17562
              <value type="string" key="be8cb246-a6e0-11e2-95e9-080027bcf912">VegCore</value>
17563
              <value type="string" key="be8cc04c-a6e0-11e2-95e9-080027bcf912">source</value>
17564
              <value type="string" key="be8cc362-a6e0-11e2-95e9-080027bcf912">id</value>
17565
              <value type="string" key="be8cc59c-a6e0-11e2-95e9-080027bcf912">parent</value>
17566
              <value type="string" key="be8cc75e-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17567
              <value type="string" key="be8ccb14-a6e0-11e2-95e9-080027bcf912">fk_source1_idx</value>
17568
              <value type="string" key="be8cce5c-a6e0-11e2-95e9-080027bcf912">fk_source1</value>
17569
              <value type="string" key="be8cd56e-a6e0-11e2-95e9-080027bcf912">record</value>
17570
              <value type="string" key="be8cd7b2-a6e0-11e2-95e9-080027bcf912">id</value>
17571
              <value type="string" key="be8cd956-a6e0-11e2-95e9-080027bcf912">source</value>
17572
              <value type="string" key="be8cdac8-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17573
              <value type="string" key="be8cddca-a6e0-11e2-95e9-080027bcf912">fk_record_source1_idx</value>
17574
              <value type="string" key="be8ce0b8-a6e0-11e2-95e9-080027bcf912">fk_record_source1</value>
17575
              <value type="string" key="be8ce932-a6e0-11e2-95e9-080027bcf912">relationship</value>
17576
              <value type="string" key="be8cebb2-a6e0-11e2-95e9-080027bcf912">id</value>
17577
              <value type="string" key="be8ced88-a6e0-11e2-95e9-080027bcf912">record</value>
17578
              <value type="string" key="be8cef2c-a6e0-11e2-95e9-080027bcf912">related_record</value>
17579
              <value type="string" key="be8cf0d0-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17580
              <value type="string" key="be8cf42c-a6e0-11e2-95e9-080027bcf912">fk_relationship_record1_idx</value>
17581
              <value type="string" key="be8cf71a-a6e0-11e2-95e9-080027bcf912">fk_relationship_related_record_idx</value>
17582
              <value type="string" key="be8cf9fe-a6e0-11e2-95e9-080027bcf912">fk_relationship_record1</value>
17583
              <value type="string" key="be8cfb66-a6e0-11e2-95e9-080027bcf912">fk_relationship_record2</value>
17584
              <value type="string" key="be8cfcb0-a6e0-11e2-95e9-080027bcf912">fk_relationship_related_record</value>
17585
              <value type="string" key="be8d17d6-a6e0-11e2-95e9-080027bcf912">taxon_assertion</value>
17586
              <value type="string" key="be8d1ac4-a6e0-11e2-95e9-080027bcf912">id</value>
17587
              <value type="string" key="be8d1de4-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17588
              <value type="string" key="be8d249c-a6e0-11e2-95e9-080027bcf912">fk_qualified_taxon_record1</value>
17589
              <value type="string" key="be8d4a58-a6e0-11e2-95e9-080027bcf912">geoplace</value>
17590
              <value type="string" key="be8d4cd8-a6e0-11e2-95e9-080027bcf912">id</value>
17591
              <value type="string" key="be8d4eae-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17592
              <value type="string" key="be8d8c2a-a6e0-11e2-95e9-080027bcf912">method</value>
17593
              <value type="string" key="be8d8ea0-a6e0-11e2-95e9-080027bcf912">id</value>
17594
              <value type="string" key="be8d906c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17595
              <value type="string" key="be8d93c8-a6e0-11e2-95e9-080027bcf912">fk_method_record1</value>
17596
              <value type="string" key="be8df962-a6e0-11e2-95e9-080027bcf912">collection</value>
17597
              <value type="string" key="be8dfbf6-a6e0-11e2-95e9-080027bcf912">id</value>
17598
              <value type="string" key="be8e0240-a6e0-11e2-95e9-080027bcf912">fk_collection_source1</value>
17599
              <value type="string" key="be8e3ecc-a6e0-11e2-95e9-080027bcf912">individual</value>
17600
              <value type="string" key="be8e4142-a6e0-11e2-95e9-080027bcf912">id</value>
17601
              <value type="string" key="be8e4322-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17602
              <value type="string" key="be8e4688-a6e0-11e2-95e9-080027bcf912">fk_individual_record1</value>
17603
              <value type="string" key="be8e6514-a6e0-11e2-95e9-080027bcf912">stem</value>
17604
              <value type="string" key="be8e679e-a6e0-11e2-95e9-080027bcf912">id</value>
17605
              <value type="string" key="be8e6974-a6e0-11e2-95e9-080027bcf912">individual</value>
17606
              <value type="string" key="be8e6b22-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17607
              <value type="string" key="be8e6e7e-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1_idx</value>
17608
              <value type="string" key="be8e7360-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1</value>
17609
              <value type="string" key="be8e7cde-a6e0-11e2-95e9-080027bcf912">stem_observation</value>
17610
              <value type="string" key="be8e7f5e-a6e0-11e2-95e9-080027bcf912">id</value>
17611
              <value type="string" key="be8e8134-a6e0-11e2-95e9-080027bcf912">individual_observation</value>
17612
              <value type="string" key="be8e82ce-a6e0-11e2-95e9-080027bcf912">stem</value>
17613
              <value type="string" key="be8e8472-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17614
              <value type="string" key="be8e87d8-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1_idx</value>
17615
              <value type="string" key="be8e8b20-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1_idx</value>
17616
              <value type="string" key="be8e8fe4-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1</value>
17617
              <value type="string" key="be8e9156-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1</value>
17618
              <value type="string" key="be8e9930-a6e0-11e2-95e9-080027bcf912">individual_count</value>
17619
              <value type="string" key="be8e9bba-a6e0-11e2-95e9-080027bcf912">id</value>
17620
              <value type="string" key="be8e9d90-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17621
              <value type="string" key="be8ea786-a6e0-11e2-95e9-080027bcf912">taxon_presence</value>
17622
              <value type="string" key="be8eaa06-a6e0-11e2-95e9-080027bcf912">id</value>
17623
              <value type="string" key="be8f1784-a6e0-11e2-95e9-080027bcf912">community</value>
17624
              <value type="string" key="be8f1a36-a6e0-11e2-95e9-080027bcf912">id</value>
17625
              <value type="string" key="be8f1c2a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17626
              <value type="string" key="be8f1fc2-a6e0-11e2-95e9-080027bcf912">fk_community_record1</value>
17627
              <value type="string" key="be8f272e-a6e0-11e2-95e9-080027bcf912">geological_context</value>
17628
              <value type="string" key="be8f29d6-a6e0-11e2-95e9-080027bcf912">id</value>
17629
              <value type="string" key="be8f2b98-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17630
              <value type="string" key="be8f2ecc-a6e0-11e2-95e9-080027bcf912">fk_geological_context_record1</value>
17631
              <value type="string" key="be8f387c-a6e0-11e2-95e9-080027bcf912">place_observation</value>
17632
              <value type="string" key="be8f3ade-a6e0-11e2-95e9-080027bcf912">id</value>
17633
              <value type="string" key="be8f3ca0-a6e0-11e2-95e9-080027bcf912">place</value>
17634
              <value type="string" key="be8f3e30-a6e0-11e2-95e9-080027bcf912">geological_context</value>
17635
              <value type="string" key="be8f3fd4-a6e0-11e2-95e9-080027bcf912">community</value>
17636
              <value type="string" key="be8f416e-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1_idx</value>
17637
              <value type="string" key="be8f4524-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1_idx</value>
17638
              <value type="string" key="be8f483a-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1_idx</value>
17639
              <value type="string" key="be8f4b64-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1</value>
17640
              <value type="string" key="be8f4d08-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1</value>
17641
              <value type="string" key="be8f4e98-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1</value>
17642
              <value type="string" key="be8f58b6-a6e0-11e2-95e9-080027bcf912">soil_observation</value>
17643
              <value type="string" key="be8f5b5e-a6e0-11e2-95e9-080027bcf912">id</value>
17644
              <value type="string" key="be8f5d5c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17645
              <value type="string" key="be8f67e8-a6e0-11e2-95e9-080027bcf912">subplace</value>
17646
              <value type="string" key="be8f6a86-a6e0-11e2-95e9-080027bcf912">id</value>
17647
              <value type="string" key="be8f6c7a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17648
              <value type="string" key="be8f78aa-a6e0-11e2-95e9-080027bcf912">geovalidatable_place</value>
17649
              <value type="string" key="be8f7b0c-a6e0-11e2-95e9-080027bcf912">id</value>
17650
              <value type="string" key="be8f8084-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17651
              <value type="string" key="be8fa0fa-a6e0-11e2-95e9-080027bcf912">project</value>
17652
              <value type="string" key="be8fa398-a6e0-11e2-95e9-080027bcf912">id</value>
17653
              <value type="string" key="be8fa58c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17654
              <value type="string" key="be8fa91a-a6e0-11e2-95e9-080027bcf912">fk_project_event1</value>
17655
              <value type="string" key="be8fb202-a6e0-11e2-95e9-080027bcf912">taxon_scrub</value>
17656
              <value type="string" key="be8fb5ae-a6e0-11e2-95e9-080027bcf912">id</value>
17657
              <value type="string" key="be8fb7a2-a6e0-11e2-95e9-080027bcf912">matched_taxon_concept</value>
17658
              <value type="string" key="be8fb98c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17659
              <value type="string" key="be8fe70e-a6e0-11e2-95e9-080027bcf912">party</value>
17660
              <value type="string" key="be8fe97a-a6e0-11e2-95e9-080027bcf912">id</value>
17661
              <value type="string" key="be8feb50-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
17662
              <value type="string" key="be8fee8e-a6e0-11e2-95e9-080027bcf912">fk_collection_source10</value>
17663
              <value type="string" key="c1255f1e-0840-11e3-98e3-080027bcf912">fk_taxon_observation_taxon_observation1</value>
17664
              <value type="string" key="c1256108-0840-11e3-98e3-080027bcf912">observation_in_parent_place</value>
17665
              <value type="string" key="c1257e9a-0840-11e3-98e3-080027bcf912">fk_taxon_observation_taxon_observation1_idx</value>
17666
              <value type="string" key="c20b4bce-ad13-11e2-b309-080027bcf912">fk_specimen_organization3_idx</value>
17667
              <value type="string" key="c3760d74-a7b3-11e2-8ba6-080027bcf912">specimen_observation</value>
17668
              <value type="string" key="c376109e-a7b3-11e2-8ba6-080027bcf912">id</value>
17669
              <value type="string" key="c3762570-a7b3-11e2-8ba6-080027bcf912">fk_specimen_taxon_occurrence10</value>
17670
              <value type="string" key="c37629b2-a7b3-11e2-8ba6-080027bcf912">PRIMARY</value>
17671
              <value type="string" key="c4391d16-006c-11e3-895c-080027bcf912">fk_stratum_event_sampling_event1</value>
17672
              <value type="string" key="c540c5c0-ad19-11e2-9d85-080027bcf912">traits</value>
17673
              <value type="string" key="c66112f6-ad10-11e2-b309-080027bcf912">fk_specimen_collection2</value>
17674
              <value type="string" key="c6612660-ad10-11e2-b309-080027bcf912">fk_specimen_collection2_idx</value>
17675
              <value type="string" key="c6722390-a7a0-11e2-b667-080027bcf912">geopath</value>
17676
              <value type="string" key="c67225de-a7a0-11e2-b667-080027bcf912">id</value>
17677
              <value type="string" key="c6722782-a7a0-11e2-b667-080027bcf912">continent</value>
17678
              <value type="string" key="c6722912-a7a0-11e2-b667-080027bcf912">country</value>
17679
              <value type="string" key="c6722a98-a7a0-11e2-b667-080027bcf912">state_province</value>
17680
              <value type="string" key="c6722c1e-a7a0-11e2-b667-080027bcf912">county</value>
17681
              <value type="string" key="c6722da4-a7a0-11e2-b667-080027bcf912">municipality</value>
17682
              <value type="string" key="c6722f2a-a7a0-11e2-b667-080027bcf912">ranks</value>
17683
              <value type="string" key="c67230d8-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
17684
              <value type="string" key="c6723d8a-a7a0-11e2-b667-080027bcf912">place</value>
17685
              <value type="string" key="c6724000-a7a0-11e2-b667-080027bcf912">id</value>
17686
              <value type="string" key="c67241b8-a7a0-11e2-b667-080027bcf912">parent</value>
17687
              <value type="string" key="c672467c-a7a0-11e2-b667-080027bcf912">locality</value>
17688
              <value type="string" key="c6724820-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
17689
              <value type="string" key="c6724e7e-a7a0-11e2-b667-080027bcf912">fk_place1_idx</value>
17690
              <value type="string" key="c67254b4-a7a0-11e2-b667-080027bcf912">fk_place_record1</value>
17691
              <value type="string" key="c6725784-a7a0-11e2-b667-080027bcf912">fk_place1</value>
17692
              <value type="string" key="c672743a-a7a0-11e2-b667-080027bcf912">event</value>
17693
              <value type="string" key="c67276b0-a7a0-11e2-b667-080027bcf912">id</value>
17694
              <value type="string" key="c672785e-a7a0-11e2-b667-080027bcf912">parent</value>
17695
              <value type="string" key="c6727a2a-a7a0-11e2-b667-080027bcf912">name</value>
17696
              <value type="string" key="c6727bce-a7a0-11e2-b667-080027bcf912">date_range</value>
17697
              <value type="string" key="c6727d54-a7a0-11e2-b667-080027bcf912">place</value>
17698
              <value type="string" key="c67280b0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
17699
              <value type="string" key="c67283da-a7a0-11e2-b667-080027bcf912">fk_event_place1_idx</value>
17700
              <value type="string" key="c6728830-a7a0-11e2-b667-080027bcf912">fk_event1_idx</value>
17701
              <value type="string" key="c6729578-a7a0-11e2-b667-080027bcf912">fk_event_record1</value>
17702
              <value type="string" key="c672971c-a7a0-11e2-b667-080027bcf912">fk_event_place1</value>
17703
              <value type="string" key="c672994c-a7a0-11e2-b667-080027bcf912">fk_event1</value>
17704
              <value type="string" key="c672a8d8-a7a0-11e2-b667-080027bcf912">reobservable</value>
17705
              <value type="string" key="c672abda-a7a0-11e2-b667-080027bcf912">id</value>
17706
              <value type="string" key="c672bda0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
17707
              <value type="string" key="c672f914-a7a0-11e2-b667-080027bcf912">specimen</value>
17708
              <value type="string" key="c672fb6c-a7a0-11e2-b667-080027bcf912">id</value>
17709
              <value type="string" key="c673038c-a7a0-11e2-b667-080027bcf912">owner_collection</value>
17710
              <value type="string" key="c6730896-a7a0-11e2-b667-080027bcf912">orig_collection</value>
17711
              <value type="string" key="c6730b98-a7a0-11e2-b667-080027bcf912">barcode</value>
17712
              <value type="string" key="c6730d78-a7a0-11e2-b667-080027bcf912">accession_number</value>
17713
              <value type="string" key="c6731048-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
17714
              <value type="string" key="c6731534-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1_idx</value>
17715
              <value type="string" key="c6731a52-a7a0-11e2-b667-080027bcf912">fk_specimen_taxon_occurrence1</value>
17716
              <value type="string" key="c6731c28-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1</value>
17717
              <value type="string" key="c7a57ce0-a92a-11e2-93c8-080027bcf912">lat_long_in_place_ranks</value>
17718
              <value type="string" key="c7c1e6aa-a91b-11e2-bdec-080027bcf912">fk_source_party2</value>
17719
              <value type="string" key="c7c1e862-a91b-11e2-bdec-080027bcf912">first_publisher</value>
17720
              <value type="string" key="c7c2089c-a91b-11e2-bdec-080027bcf912">fk_source_party2_idx</value>
17721
              <value type="string" key="c8552934-a7bc-11e2-8af2-080027bcf912">fk_source_party1</value>
17722
              <value type="string" key="c8552b14-a7bc-11e2-8af2-080027bcf912">owner</value>
17723
              <value type="string" key="c8554edc-a7bc-11e2-8af2-080027bcf912">fk_source_party1_idx</value>
17724
              <value type="string" key="c8868c00-a793-11e2-84c3-080027bcf912">info</value>
17725
              <value type="string" key="cfea1514-a790-11e2-84c3-080027bcf912">x_m</value>
17726
              <value type="string" key="d009232a-f671-11e2-9716-080027bcf912">tag_history</value>
17727
              <value type="string" key="d0d97d8a-f6c7-11e2-a35e-080027bcf912">coords</value>
17728
              <value type="string" key="d2081100-f959-11e2-8597-080027bcf912">fk_taxon_presence_taxon_determination1</value>
17729
              <value type="string" key="d2b2ccf6-a794-11e2-84c3-080027bcf912">elevation_m</value>
17730
              <value type="string" key="d6b1b62e-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
17731
              <value type="string" key="d72de448-ad19-11e2-9d85-080027bcf912">traits</value>
17732
              <value type="string" key="d9b5781e-a90b-11e2-8576-080027bcf912">name</value>
17733
              <value type="string" key="db4e8988-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_observation_taxon_occurrence1</value>
17734
              <value type="string" key="db4e8bea-1dc6-11e3-838b-410b6ef2c3ca">taxon_occurrence</value>
17735
              <value type="string" key="db4ea800-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_observation_taxon_occurrence1_idx</value>
17736
              <value type="string" key="dbe10c36-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1</value>
17737
              <value type="string" key="dbe121f8-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1_idx</value>
17738
              <value type="string" key="dc8d1c42-ad19-11e2-9d85-080027bcf912">aggregating_traits</value>
17739
              <value type="string" key="dda7bbf8-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2</value>
17740
              <value type="string" key="dda7bdec-0072-11e3-906b-080027bcf912">parent_event</value>
17741
              <value type="string" key="dda7d480-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2_idx</value>
17742
              <value type="string" key="e5155806-a793-11e2-84c3-080027bcf912">info</value>
17743
              <value type="string" key="e550209e-f676-11e2-9716-080027bcf912">fk_party_organization1</value>
17744
              <value type="string" key="e5502346-f676-11e2-9716-080027bcf912">organization</value>
17745
              <value type="string" key="e550389a-f676-11e2-9716-080027bcf912">fk_party_organization1_idx</value>
17746
              <value type="string" key="e5d27f54-a792-11e2-84c3-080027bcf912">info</value>
17747
              <value type="string" key="ea3bec44-acef-11e2-bdae-080027bcf912">source_id_scope</value>
17748
              <value type="string" key="eb778868-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1</value>
17749
              <value type="string" key="eb778aac-ad01-11e2-b309-080027bcf912">collection_event</value>
17750
              <value type="string" key="eb77b1da-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1_idx</value>
17751
              <value type="string" key="ec1f6aa2-f6c5-11e2-a35e-080027bcf912">shape</value>
17752
              <value type="string" key="ec6965f0-a925-11e2-acee-080027bcf912">fk_specimen_organization3</value>
17753
              <value type="string" key="ed1eb2a6-ad0e-11e2-b309-080027bcf912">fk_collection_organization1</value>
17754
              <value type="string" key="ed1eb468-ad0e-11e2-b309-080027bcf912">institution</value>
17755
              <value type="string" key="ed1ec98a-ad0e-11e2-b309-080027bcf912">fk_collection_organization1_idx</value>
17756
              <value type="string" key="ed551182-011b-11e3-b872-080027bcf912">fk_taxa_sampling_event_place1</value>
17757
              <value type="string" key="ed551376-011b-11e3-b872-080027bcf912">within_place</value>
17758
              <value type="string" key="ed55f9e4-011b-11e3-b872-080027bcf912">fk_taxa_sampling_event_place1_idx</value>
17759
              <value type="string" key="f15726c2-011f-11e3-9f3a-080027bcf912">aggregate_observation</value>
17760
              <value type="string" key="f1572a5a-011f-11e3-9f3a-080027bcf912">id</value>
17761
              <value type="string" key="f1572d5c-011f-11e3-9f3a-080027bcf912">occurrence_status</value>
17762
              <value type="string" key="f1573162-011f-11e3-9f3a-080027bcf912">traits</value>
17763
              <value type="string" key="f157336a-011f-11e3-9f3a-080027bcf912">fk_taxon_presence_taxon_determination10</value>
17764
              <value type="string" key="f1573748-011f-11e3-9f3a-080027bcf912">PRIMARY</value>
17765
              <value type="string" key="f62bfaf6-a797-11e2-8681-080027bcf912">fk_stem_observation_individual_observation2</value>
17766
              <value type="string" key="f903388e-0084-11e3-ac06-080027bcf912">reobservable_presence</value>
17767
              <value type="string" key="f9033c9e-0084-11e3-ac06-080027bcf912">id</value>
17768
              <value type="string" key="f903400e-0084-11e3-ac06-080027bcf912">voucher</value>
17769
              <value type="string" key="f903472a-0084-11e3-ac06-080027bcf912">PRIMARY</value>
17770
              <value type="string" key="f9d23e32-1dc5-11e3-838b-410b6ef2c3ca">taxon_occurrence</value>
17771
              <value type="string" key="f9d241ca-1dc5-11e3-838b-410b6ef2c3ca">id</value>
17772
              <value type="string" key="f9d255c0-1dc5-11e3-838b-410b6ef2c3ca">PRIMARY</value>
17773
              <value type="string" key="fbf69d1e-a79d-11e2-a346-080027bcf912">record_unique</value>
17774
              <value type="string" key="fc6fbbae-f96e-11e2-9f36-080027bcf912">geoplace</value>
17775
            </value>
17776
            <value type="string" key="lastSyncDate"></value>
17777
            <value type="string" key="name"></value>
17778
          </value>
17779
        </value>
17154 17780
        <value _ptr_="0xb79dff0" type="list" content-type="object" content-struct-name="GrtObject" key="tagCategories"/>
17155 17781
        <value _ptr_="0xb79e020" type="list" content-type="object" content-struct-name="meta.Tag" key="tags"/>
17156 17782
        <link type="object" struct-name="model.Diagram" key="currentDiagram">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
......
17233 17859
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
17234 17860
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
17235 17861
      <value type="string" key="caption">New Model</value>
17236
      <value type="string" key="dateChanged">2013-09-15 01:04</value>
17862
      <value type="string" key="dateChanged">2013-09-15 01:12</value>
17237 17863
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
17238 17864
      <value type="string" key="description"></value>
17239 17865
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
1254 1254
CREATE TABLE `taxon_observation` (
1255 1255
  `id` varbinary(767) NOT NULL,
1256 1256
  `taxon_occurrence` varbinary(767) NOT NULL,
1257
  `sampling_event` varbinary(767) DEFAULT NULL,
1257 1258
  `observation_in_parent_place` varbinary(767) DEFAULT NULL COMMENT 'points to the observation of the same taxon/individual in the parent place; = VegBank.vegpath.org?taxonImportance.taxonObservation_ID',
1258 1259
  `collectors` varbinary(767) DEFAULT NULL,
1259 1260
  `collector_number` varbinary(767) DEFAULT NULL,
......
1264 1265
  KEY `fk_taxon_observation_party_list1_idx` (`collectors`),
1265 1266
  KEY `fk_taxon_observation_taxon_observation1_idx` (`observation_in_parent_place`),
1266 1267
  KEY `fk_taxon_observation_taxon_occurrence1_idx` (`taxon_occurrence`),
1268
  KEY `fk_taxon_observation_taxa_sampling_event1_idx` (`sampling_event`),
1267 1269
  CONSTRAINT `fk_taxon_observation_taxon_observation1` FOREIGN KEY (`observation_in_parent_place`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1268
  CONSTRAINT `fk_taxon_observation_taxon_occurrence1` FOREIGN KEY (`taxon_occurrence`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1269 1270
  CONSTRAINT `fk_taxon_observation_party_list1` FOREIGN KEY (`collectors`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1270
  CONSTRAINT `fk_taxon_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1271
  CONSTRAINT `fk_taxon_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1272
  CONSTRAINT `fk_taxon_observation_taxa_sampling_event1` FOREIGN KEY (`sampling_event`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1273
  CONSTRAINT `fk_taxon_observation_taxon_occurrence1` FOREIGN KEY (`taxon_occurrence`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1271 1274
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1272 1275
/*!40101 SET character_set_client = @saved_cs_client */;
1273 1276

  

Also available in: Unified diff