Project

General

Profile

« Previous | Next » 

Revision 10499

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/VegCore.ERD.mwb: plot: replaced bounding_box_rect with length_m, width_m, since the bounding box was intended to store plot dimensions (along the plot azimuth) rather than an actual bounding box aligned to the compass directions. added azimuth_deg_N, which is used to resolve plot element x/y coordinates to absolute geocoordinates while taking into account the rotation of the plot.

View differences:

schemas/VegCore/document.mwb.xml
8250 8250 
                      <value type="int" key="scale">-1</value>
8251 8251 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
8252 8252 
                      <value type="string" key="comment"></value>
8253 
                      <value type="string" key="name">bounding_box_rect</value>
8254 
                      <value type="string" key="oldName">bounding_box_rect</value>
8253 
                      <value type="string" key="name">length_m</value>
8254 
                      <value type="string" key="oldName">length_m</value>
8255 8255 
                      <link type="object" struct-name="GrtObject" key="owner">9f4bd98c-a6fb-11e2-9461-080027bcf912</link>
8256 8256 
                    </value>
8257 
                    <value type="object" struct-name="db.mysql.Column" id="b95efb72-f982-11e2-8a2e-080027bcf912" struct-checksum="0x783b5183">
8258 
                      <value type="int" key="autoIncrement">0</value>
8259 
                      <value type="string" key="characterSetName"></value>
8260 
                      <value _ptr_="0xbfa31a0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
8261 
                      <value type="string" key="collationName"></value>
8262 
                      <value type="string" key="datatypeExplicitParams"></value>
8263 
                      <value type="string" key="defaultValue"></value>
8264 
                      <value type="int" key="defaultValueIsNull">1</value>
8265 
                      <value _ptr_="0xc1956d0" type="list" content-type="string" key="flags"/>
8266 
                      <value type="int" key="isNotNull">0</value>
8267 
                      <value type="int" key="length">767</value>
8268 
                      <value type="int" key="precision">-1</value>
8269 
                      <value type="int" key="scale">-1</value>
8270 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
8271 
                      <value type="string" key="comment"></value>
8272 
                      <value type="string" key="name">width_m</value>
8273 
                      <value type="string" key="oldName">width_m</value>
8274 
                      <link type="object" struct-name="GrtObject" key="owner">9f4bd98c-a6fb-11e2-9461-080027bcf912</link>
8275 
                    </value>
8276 
                    <value type="object" struct-name="db.mysql.Column" id="5256ac76-f983-11e2-8a2e-080027bcf912" struct-checksum="0x783b5183">
8277 
                      <value type="int" key="autoIncrement">0</value>
8278 
                      <value type="string" key="characterSetName"></value>
8279 
                      <value _ptr_="0xc503b68" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
8280 
                      <value type="string" key="collationName"></value>
8281 
                      <value type="string" key="datatypeExplicitParams"></value>
8282 
                      <value type="string" key="defaultValue"></value>
8283 
                      <value type="int" key="defaultValueIsNull">1</value>
8284 
                      <value _ptr_="0xc503ad8" type="list" content-type="string" key="flags"/>
8285 
                      <value type="int" key="isNotNull">0</value>
8286 
                      <value type="int" key="length">767</value>
8287 
                      <value type="int" key="precision">-1</value>
8288 
                      <value type="int" key="scale">-1</value>
8289 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
8290 
                      <value type="string" key="comment"></value>
8291 
                      <value type="string" key="name">azimuth_deg_N</value>
8292 
                      <value type="string" key="oldName">azimuth_deg_N</value>
8293 
                      <link type="object" struct-name="GrtObject" key="owner">9f4bd98c-a6fb-11e2-9461-080027bcf912</link>
8294 
                    </value>
8257 8295 
                    <value type="object" struct-name="db.mysql.Column" id="0a33807e-f6c5-11e2-af44-080027bcf912" struct-checksum="0x783b5183">
8258 8296 
                      <value type="int" key="autoIncrement">0</value>
8259 8297 
                      <value type="string" key="characterSetName"></value>
......
8375 8413 
                  <value type="int" key="commentedOut">0</value>
8376 8414 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
8377 8415 
                  <value _ptr_="0xabede10" type="dict" key="customData"/>
8378 
                  <value type="string" key="lastChangeDate">2013-07-27 07:19</value>
8416 
                  <value type="string" key="lastChangeDate">2013-07-30 18:48</value>
8379 8417 
                  <value type="int" key="modelOnly">0</value>
8380 8418 
                  <value type="string" key="name">plot</value>
8381 8419 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
13567 13605 
                <value type="int" key="triggersExpanded">0</value>
13568 13606 
                <value type="string" key="color">#ffcc33</value>
13569 13607 
                <value type="int" key="expanded">1</value>
13570 
                <value type="real" key="height">1.92e+02</value>
13608 
                <value type="real" key="height">2.38e+02</value>
13571 13609 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13572 13610 
                <value type="real" key="left">6.41e+02</value>
13573 13611 
                <value type="int" key="locked">0</value>
......
14100 14138 
              <value type="string" key="name"></value>
14101 14139 
            </value>
14102 14140 
            <value _ptr_="0xac125c8" type="list" content-type="object" content-struct-name="model.Object" key="selection">
14103 
              <link type="object">8932D751-419A-4213-960A-F4E3E44763CD</link>
14141 
              <link type="object">9f4be6e8-a6fb-11e2-9461-080027bcf912</link>
14104 14142 
            </value>
14105 14143 
            <value type="int" key="updateBlocked">0</value>
14106 14144 
            <value type="real" key="width">1.6215e+03</value>
......
14114 14152 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
14115 14153 
        <value _ptr_="0xab85450" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
14116 14154 
        <value _ptr_="0xa229c20" type="dict" key="syncProfiles">
14117 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="1daf169e-f982-11e2-8a2e-080027bcf912" struct-checksum="0xc64972c2" key="">
14118 
            <value _ptr_="0xc071f60" type="dict" key="lastKnownDBNames">
14155 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="8da696b0-f983-11e2-8a2e-080027bcf912" struct-checksum="0xc64972c2" key="">
14156 
            <value _ptr_="0xc52a240" type="dict" key="lastKnownDBNames">
14119 14157 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
14120 14158 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
14121 14159 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
14245 14283 
              <value type="string" key="523d3e7a-f96b-11e2-9fb4-080027bcf912">fk_geoplace_geoplace1</value>
14246 14284 
              <value type="string" key="523d417c-f96b-11e2-9fb4-080027bcf912">parent_geoplace</value>
14247 14285 
              <value type="string" key="523e1160-f96b-11e2-9fb4-080027bcf912">fk_geoplace_geoplace1_idx</value>
14286 
              <value type="string" key="5256ac76-f983-11e2-8a2e-080027bcf912">azimuth_deg_N</value>
14248 14287 
              <value type="string" key="54dd4bd4-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1</value>
14249 14288 
              <value type="string" key="54dd4d82-f67d-11e2-aebb-080027bcf912">specimenholder_institutions</value>
14250 14289 
              <value type="string" key="54dd6466-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1_idx</value>
......
14261 14300 
              <value type="string" key="5e41c0d2-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1</value>
14262 14301 
              <value type="string" key="5e41cb90-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1_idx</value>
14263 14302 
              <value type="string" key="66675a70-f970-11e2-9f36-080027bcf912">fk_geoplace_place1</value>
14264 
              <value type="string" key="66c25c1c-a791-11e2-84c3-080027bcf912">bounding_box_rect</value>
14303 
              <value type="string" key="66c25c1c-a791-11e2-84c3-080027bcf912">length_m</value>
14265 14304 
              <value type="string" key="67fa5b28-f6c1-11e2-af44-080027bcf912">fk_taxon_observation_sampling_event1</value>
14266 14305 
              <value type="string" key="6856853a-a796-11e2-84c3-080027bcf912">traits</value>
14267 14306 
              <value type="string" key="687f12b8-a780-11e2-afd5-080027bcf912">taxon_name</value>
......
14347 14386 
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>
14348 14387 
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>
14349 14388 
              <value type="string" key="b8ce339a-a797-11e2-8681-080027bcf912">fk_stem_individual2</value>
14389 
              <value type="string" key="b95efb72-f982-11e2-8a2e-080027bcf912">width_m</value>
14350 14390 
              <value type="string" key="b9695d2e-a793-11e2-84c3-080027bcf912">info</value>
14351 14391 
              <value type="string" key="b9be8c42-acff-11e2-b309-080027bcf912">collectors</value>
14352 14392 
              <value type="string" key="bb0eaf44-ad10-11e2-b309-080027bcf912">current_collection</value>
......
14637 14677 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14638 14678 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14639 14679 
      <value type="string" key="caption">New Model</value>
14640 
      <value type="string" key="dateChanged">2013-07-30 18:40</value>
14680 
      <value type="string" key="dateChanged">2013-07-30 18:50</value>
14641 14681 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14642 14682 
      <value type="string" key="description"></value>
14643 14683 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
521 521 
  `name` varbinary(767) DEFAULT NULL,
522 522 
  `area_m2` double DEFAULT NULL,
523 523 
  `shape` varbinary(767) DEFAULT NULL,
524 
  `bounding_box_rect` varbinary(767) DEFAULT NULL,
524 
  `length_m` varbinary(767) DEFAULT NULL,
525 
  `width_m` varbinary(767) DEFAULT NULL,
526 
  `azimuth_deg_N` varbinary(767) DEFAULT NULL,
525 527 
  `footprint_geom_WKT` varbinary(767) DEFAULT NULL,
526 528 
  `dimensions` set('hstore') COLLATE utf8_bin DEFAULT NULL,
527 529 
  PRIMARY KEY (`id`),
schemas/VegCore/VegCore.pg.sql
523 523 
  "name" text DEFAULT NULL,
524 524 
  "area_m2" double precision DEFAULT NULL,
525 525 
  "shape" text DEFAULT NULL,
526 
  "bounding_box_rect" text DEFAULT NULL,
526 
  "length_m" text DEFAULT NULL,
527 
  "width_m" text DEFAULT NULL,
528 
  "azimuth_deg_N" text DEFAULT NULL,
527 529 
  "footprint_geom_WKT" text DEFAULT NULL,
528 530 
  "dimensions" hstore DEFAULT NULL,
529 531 
  PRIMARY KEY ("id"),

Also available in: Unified diff