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

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

                      <value type="string" key="comment">the parent geoplace</value>

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

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

                    </value>

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

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

                    </value>

                  </value>

                  <value _ptr_="0xac9ffb0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">

                    <value type="object" struct-name="db.mysql.Index" id="be8f8084-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">

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

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

                    </value>

                  </value>

                  <value type="string" key="maxRows"></value>

                  <value type="string" key="mergeInsert"></value>

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

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

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

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

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

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

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

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

                <link type="object" struct-name="db.ForeignKey" key="foreignKey">69b7c87c-f970-11e2-9f36-080027bcf912</link>

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

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

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

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

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

              </value>

              <value type="object" struct-name="workbench.physical.Connection" id="2d3c5d86-0078-11e3-906b-080027bcf912" struct-checksum="0x9baebc92">

                <value type="string" key="caption">fk_place_observation_event1</value>

                <value type="real" key="captionXOffs">0.e+00</value>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                <value type="real" key="width">7.e+01</value>

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

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

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

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

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

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

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

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

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

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

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

              </value>

              <value type="object" struct-name="workbench.model.NoteFigure" id="d1d0a2b8-0130-11e3-8d80-080027bcf912" struct-checksum="0x56ccd040">

                <value type="string" key="color">#ffffff</value>

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

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

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

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

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

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

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

              </value>

              <value type="object" struct-name="workbench.physical.TableFigure" id="f9d27532-1dc5-11e3-838b-410b6ef2c3ca" struct-checksum="0x3b14eccb">

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

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

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

            </value>

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

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

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

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

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

        <value _ptr_="0xa49c310" type="dict" key="syncProfiles">

              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>

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

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

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

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

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

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

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

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `geovalidatable_place` (

  `id` varbinary(767) NOT NULL,

  PRIMARY KEY (`id`),

  CONSTRAINT `fk_nested_geoplace_geoplace1` FOREIGN KEY (`id`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores only scrubbed geoplaces (GADM places, and distinct point coordinates that GNRS says should be located within them)';

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "geovalidatable_place" (

  "id" text NOT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "fk_nested_geoplace_geoplace1" FOREIGN KEY ("id") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores only scrubbed geoplaces (GADM places, and distinct point coordinates that GNRS says should be located within them)'*/;

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