Delivered-To: aaronmk.nceas@gmail.com

Received: by 10.227.8.195 with SMTP id i3csp225529wbi;

        Tue, 21 Jan 2014 09:28:36 -0800 (PST)

X-Received: by 10.43.57.19 with SMTP id we19mr984884icb.89.1390325316294;

        Tue, 21 Jan 2014 09:28:36 -0800 (PST)

Return-Path: <aaronmk+caf_=aaronmk.nceas=gmail.com@nceas.ucsb.edu>

Received: from mail-ig0-f175.google.com (mail-ig0-f175.google.com [209.85.213.175])

        by mx.google.com with ESMTPS id ih5si8753154icb.88.2014.01.21.09.28.35

        for <aaronmk.nceas@gmail.com>

        (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);

        Tue, 21 Jan 2014 09:28:36 -0800 (PST)

Received-SPF: pass (google.com: domain of aaronmk+caf_=aaronmk.nceas=gmail.com@nceas.ucsb.edu designates 209.85.213.175 as permitted sender) client-ip=209.85.213.175;

Authentication-Results: mx.google.com;

       spf=pass (google.com: domain of aaronmk+caf_=aaronmk.nceas=gmail.com@nceas.ucsb.edu designates 209.85.213.175 as permitted sender) smtp.mail=aaronmk+caf_=aaronmk.nceas=gmail.com@nceas.ucsb.edu

Received: by mail-ig0-f175.google.com with SMTP id uq10so11413036igb.2

        for <aaronmk.nceas@gmail.com>; Tue, 21 Jan 2014 09:28:35 -0800 (PST)

X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;

        d=1e100.net; s=20130820;

        h=x-original-authentication-results:x-gm-message-state:delivered-to

         :from:to:cc:subject:thread-topic:thread-index:date:message-id

         :accept-language:content-language:content-type:mime-version;

        bh=jW8VMIT0ZJ8vhylqj6a58Zye+3is5CCvjT1FpxlWYhM=;

        b=Egi87IJCv43kM5+kDEfXE01cF3s0nEQO2Scoq3omKcsk3ijl27mgUM/WUNOkjDQWTx

         M5wS+K+oTuPhaZ3qbm77T4PgmYjzzsKLIop8vO5sYPIqpZekCgQC2SxrM/LpAg4zoWTj

         QoBICO1ziLRkiMJSGEKeG0rOVC1olSZkD9vdkPHu7Kr8mWTrucMgHjk7NbDcfZUKknrM

         tgHvhiTl6zlrmEKraTcu+/QJTPkREtv/eh5VUXHcuGrdYjIXy5pdfJvOWkP97yVVKH4Z

         cjsg+cwusHKQW8kdgq31gjotInDRxpazFWSKIv/wJN80bGZoMuXN2CuWsS1HrZKX0/CE

         SV1Q==

X-Original-Authentication-Results: mx.google.com;       spf=pass (google.com: best guess record for domain of bboyle@email.arizona.edu designates 128.196.130.201 as permitted sender) smtp.mail=bboyle@email.arizona.edu

X-Gm-Message-State: ALoCoQnzuzXZgMVll/jdavmV7tgBhs/RyGOrxyP3nKlH1tqplKeIQjwN+rPdkGMB51yWp/0joIpf

X-Received: by 10.50.66.101 with SMTP id e5mr18932898igt.26.1390325315747;

        Tue, 21 Jan 2014 09:28:35 -0800 (PST)

X-Forwarded-To: aaronmk.nceas@gmail.com

X-Forwarded-For: aaronmk@nceas.ucsb.edu aaronmk.nceas@gmail.com

Delivered-To: aaronmk@nceas.ucsb.edu

Received: by 10.64.70.226 with SMTP id p2csp21787ieu;

        Tue, 21 Jan 2014 09:28:34 -0800 (PST)

X-Received: by 10.182.114.132 with SMTP id jg4mr22145705obb.29.1390325314395;

        Tue, 21 Jan 2014 09:28:34 -0800 (PST)

Return-Path: <bboyle@email.arizona.edu>

Received: from mailgator.email.arizona.edu (mailgator-s1-n1.email.arizona.edu. [128.196.130.201])

        by mx.google.com with ESMTP id jb8si3262708obb.53.2014.01.21.09.28.34

        for <aaronmk@nceas.ucsb.edu>;

        Tue, 21 Jan 2014 09:28:34 -0800 (PST)

Received-SPF: pass (google.com: best guess record for domain of bboyle@email.arizona.edu designates 128.196.130.201 as permitted sender) client-ip=128.196.130.201;

Received: from mailgators_amavis (acyc.email.arizona.edu [128.196.130.235])

	by mailgator.email.arizona.edu (Postfix) with ESMTP id A7D51120979;

	Tue, 21 Jan 2014 10:28:33 -0700 (MST)

X-Virus-Scanned: amavisd-new at email.arizona.edu

Received: from smtp.catnet.arizona.edu (bobsled.catnet.arizona.edu [10.140.53.100])

	by smtpgate.email.arizona.edu (Postfix) with ESMTPS id D3A3B8D84A6;

	Tue, 21 Jan 2014 10:28:32 -0700 (MST)

Received: from Carousel.catnet.arizona.edu ([169.254.5.32]) by

 BobSled.catnet.arizona.edu ([10.140.53.100]) with mapi id 14.03.0174.001;

 Tue, 21 Jan 2014 10:28:32 -0700

From: "Boyle, Bradley L - (bboyle)" <bboyle@email.arizona.edu>

To: Aaron Marcuse-Kubitza <aaronmk@nceas.ucsb.edu>

CC: Martha Narro <narro@iplantcollaborative.org>, BIEN Database Working Group

	<bien-db@iplantcollaborative.org>

Subject: Qualitative validations for traits, plus revised task list

Thread-Topic: Qualitative validations for traits, plus revised task list

Thread-Index: AQHPFs40E9fYzYyVSkyRktxAppKEww==

Date: Tue, 21 Jan 2014 17:28:31 +0000

Message-ID: <D9E5B32B-49BA-4419-A2A0-7F70D706D8AE@email.arizona.edu>

Accept-Language: en-US

Content-Language: en-US

X-MS-Has-Attach: yes

X-MS-TNEF-Correlator:

x-originating-ip: [24.121.32.39]

Content-Type: multipart/mixed;

	boundary="_005_D9E5B32B49BA4419A2A07F70D706D8AEemailarizonaedu_"

MIME-Version: 1.0

--_005_D9E5B32B49BA4419A2A07F70D706D8AEemailarizonaedu_

Content-Type: multipart/alternative;

	boundary="_000_D9E5B32B49BA4419A2A07F70D706D8AEemailarizonaedu_"

--_000_D9E5B32B49BA4419A2A07F70D706D8AEemailarizonaedu_

Content-Type: text/plain; charset="us-ascii"

Content-Transfer-Encoding: quoted-printable

Hi Aaron,

Attached are the two sets of quantitative validations for traits: one set o=

f mysql queries against the original table in BIEN2, and another set of pos=

tgres queries against the trait table in BIEN3 (vegbien). There are eight q=

ueries total. The BIEN2 queries are complete; however, I will need you to w=

rite the BIEN3 queries 5, 6 and 8. The latter queries involve taxon names a=

nd I am not confident that I understand how you form the verbatim taxon nam=

e in vegbien. Note that the taxon name includes the family ONLY IF the genu=

s (or lower taxon) is unknown.

Please send the BIEN3 queries to me after you have written the missing quer=

ies. That will help me to understand how you are handling taxonomy so I can=

 write these queries myself in the future.

In the process of writing these validations, I discovered a few issues with=

 the trait data that needed to be fixed. After you have completed the queri=

es, but before you run the validations, please reload the trait data from t=

he original.

Also, in the process of writing the SALVIAS validations (which I sent to yo=

u on the weekend) I also discovered some issues. I fixed these as well. The=

y are all relatively minor issues, but will nonetheless cause the quantitat=

ive validations to fail when you run them without reloading the revised dat=

a. So, please reload the SALVIAS data before running the SALVIAS validation=

s.

Because of the need to reload data suggests some changes to your task list =

from our last meeting. Apart from step 1, I would like you to complete the =

trait validations first as they are simplest. Please complete the following=

 tasks in the order of priority indicated:

1. SALVIAS data contributors

        Make any necessary revisions to vegbien schema and scripts to accom=

modate  the SALVIAS plot and project data contributors, as described in my =

"High priority tasks" email message of Dec. 17/18. Do not reload the SALVIA=

S data yet; you will do that later  in step 3.

2. Trait validations

        2.a. Complete the queries for the Trait validations against vegbien=

.

        2.b.     Compare carefully the two sets of queries to ensure they p=

rovide identical output (assuming identical content). Check especially that=

 aliases and sort orders are identical. Revise if necessary. Send the finis=

hed queries to me when you are done.

        2.c. Automate the Trait validations using the diff approach you hav=

e proposed. The automation validation process should produce a report detai=

ling which queries passed and which failed.

        2.d. Reload the trait data from the original table in BIEN2.

        2.e. Run the trait validations and report the results to Martha and=

 myself.

3. SALVIAS validations

        3.a. Complete the queries for the SALVIAS validations against vegbi=

en. The missing queries either involve taxon names or subplots, or infer th=

e observation method (individuals, species counts, percent cover, etc).

        3.b.     Compare carefully the two sets of queries to ensure they p=

rovide identical output (assuming identical content). Check especially that=

 aliases and sort orders are identical. Revise if necessary. Send the finis=

hed queries to me when you are done.

        3.c. Automate the SALVIAS validations using the diff approach you h=

ave proposed. The automation validation process should produce a report det=

ailing which queries passed and which failed.

        3.d. Reload the SALVIAS data from the original table in BIEN2.

        3.e. Run the SALVIAS validations and report the results to Martha a=

nd myself.

Don't hesitate to ask me right away if you have questions. These validation=

s are not simple and perfecting them may require a bit of experimentation a=

nd discussion. The validations themselves will likely uncover problems that=

 will need to be fixed. However, the effort we put in now will pay off in t=

he long run. Extending these queries to other data sources should get faste=

r as we go along, and we can be confident about releasing the data once it =

passes validation.

Thanks,

Brad

--_000_D9E5B32B49BA4419A2A07F70D706D8AEemailarizonaedu_

Content-Type: text/html; charset="us-ascii"

Content-ID: <DDA3479128EB2242B1E34FC448D35A6A@email.arizona.edu>

Content-Transfer-Encoding: quoted-printable

<html>

<head>

<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=

>

</head>

<body>

<div class=3D"BodyFragment"><font size=3D"2"><span style=3D"font-size:10pt;=

">

<div class=3D"PlainText">Hi Aaron,<br>

<br>

Attached are the two sets of quantitative validations for traits: one set o=

f mysql queries against the original table in BIEN2, and another set of pos=

tgres queries against the trait table in BIEN3 (vegbien). There are eight q=

ueries total. The BIEN2 queries

 are complete; however, I will need you to write the BIEN3 queries 5, 6 and=

 8. The latter queries involve taxon names and I am not confident that I un=

derstand how you form the verbatim taxon name in vegbien. Note that the tax=

on name includes the family ONLY

 IF the genus (or lower taxon) is unknown.<br>

<br>

Please send the BIEN3 queries to me after you have written the missing quer=

ies. That will help me to understand how you are handling taxonomy so I can=

 write these queries myself in the future.<br>

<br>

In the process of writing these validations, I discovered a few issues with=

 the trait data that needed to be fixed. After you have completed the queri=

es, but before you run the validations, please reload the trait data from t=

he original.<br>

<br>

Also, in the process of writing the SALVIAS validations (which I sent to yo=

u on the weekend) I also discovered some issues. I fixed these as well. The=

y are all relatively minor issues, but will nonetheless cause the quantitat=

ive validations to fail when you

 run them without reloading the revised data. So, please reload the SALVIAS=

 data before running the SALVIAS validations.<br>

<br>

Because of the need to reload data suggests some changes to your task list =

from our last meeting. Apart from step 1, I would like you to complete the =

trait validations first as they are simplest. Please complete the following=

 tasks in the order of priority

 indicated:<br>

<br>

1. SALVIAS data contributors<br>

<br>

        Make any necessary revisions to =

vegbien schema and scripts to accommodate  the SALVIAS plot and projec=

t data contributors, as described in my "High priority tasks" ema=

il message of Dec. 17/18. Do not reload the SALVIAS data yet; you will do t=

hat later 

 in step 3.<br>

<br>

2. Trait validations<br>

<br>

        2.a. Complete the queries for th=

e Trait validations against vegbien.<br>

        2.b.     Com=

pare carefully the two sets of queries to ensure they provide identical out=

put (assuming identical content). Check especially that aliases and sort or=

ders are identical. Revise if necessary. Send the finished queries to me wh=

en you are done.<br>

        2.c. Automate the Trait validati=

ons using the diff approach you have proposed. The automation validation pr=

ocess should produce a report detailing which queries passed and which fail=

ed.<br>

        2.d. Reload the trait data from =

the original table in BIEN2.<br>

        2.e. Run the trait validations a=

nd report the results to Martha and myself.<br>

<br>

3. SALVIAS validations<br>

        3.a. Complete the queries for th=

e SALVIAS validations against vegbien. The missing queries either involve t=

axon names or subplots, or infer the observation method (individuals, speci=

es counts, percent cover, etc).

<br>

        3.b.     Com=

pare carefully the two sets of queries to ensure they provide identical out=

put (assuming identical content). Check especially that aliases and sort or=

ders are identical. Revise if necessary. Send the finished queries to me wh=

en you are done.<br>

        3.c. Automate the SALVIAS valida=

tions using the diff approach you have proposed. The automation validation =

process should produce a report detailing which queries passed and which fa=

iled.<br>

        3.d. Reload the SALVIAS data fro=

m the original table in BIEN2.<br>

        3.e. Run the SALVIAS validations=

 and report the results to Martha and myself.<br>

<br>

Don't hesitate to ask me right away if you have questions. These validation=

s are not simple and perfecting them may require a bit of experimentation a=

nd discussion. The validations themselves will likely uncover problems that=

 will need to be fixed. However,

 the effort we put in now will pay off in the long run. Extending these que=

ries to other data sources should get faster as we go along, and we can be =

confident about releasing the data once it passes validation.<br>

<br>

Thanks,<br>

Brad<br>

<br>

</div>

</span></font></div>

<div class=3D"BodyFragment"><font size=3D"2"><span style=3D"font-size:10pt;=

">

<div class=3D"PlainText"><br>

<br>

<br>

</div>

</span></font></div>

</body>

</html>

--_000_D9E5B32B49BA4419A2A07F70D706D8AEemailarizonaedu_--

--_005_D9E5B32B49BA4419A2A07F70D706D8AEemailarizonaedu_

Content-Type: application/octet-stream;

	name="bien3_validations_traits_bien3.sql"

Content-Description: bien3_validations_traits_bien3.sql

Content-Disposition: attachment;

	filename="bien3_validations_traits_bien3.sql"; size=1630;

	creation-date="Tue, 21 Jan 2014 17:28:31 GMT";

	modification-date="Tue, 21 Jan 2014 17:28:31 GMT"

Content-ID: <928E6BC69350AD42B890F48FC642442B@email.arizona.edu>

Content-Transfer-Encoding: base64

LS0gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t

LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KLS0gUXVhbnRpdGF0aXZlIHZhbGlkYXRpb24gcXVl

cmllcyBhZ2FpbnN0IHRhYmxlIFRyYWl0IGluIEJJRU4zIHBvc3RncmVzIGRiDQotLSANCi0tIERC

OiB2ZWdiaWVuDQotLSBIb3N0OiB2ZWdiaWVuZGV2Lm5jZWFzLnVjc2IuZWR1DQotLSAtLS0tLS0t

LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t

LS0tLS0tLS0tLS0tLS0tDQoNCi0tIC0tLS0tLS0tLS0tLS0tLS0tLQ0KLS0gMS4gQ291bnQgcmVj

b3Jkcw0KLS0gLS0tLS0tLS0tLS0tLS0tLS0tDQpTRUxFQ1QgQ09VTlQoKikgQVMgdG90YWxSZWNv

cmRzDQpGUk9NIHRyYWl0Ow0KDQotLSAtLS0tLS0tLS0tLS0tLS0tLS0NCi0tIDIuIENvdW50IHRy

YWl0IG5hbWVzDQotLSAtLS0tLS0tLS0tLS0tLS0tLS0NClNFTEVDVCBDT1VOVChESVNUSU5DVCBu

YW1lKSBBUyB0cmFpdHMNCkZST00gdHJhaXQ7DQoNCi0tIC0tLS0tLS0tLS0tLS0tLS0tLQ0KLS0g

My4gTGlzdCB0cmFpdCBuYW1lcw0KLS0gLS0tLS0tLS0tLS0tLS0tLS0tDQpTRUxFQ1QgRElTVElO

Q1QgbmFtZSBBUyB0cmFpdA0KRlJPTSB0cmFpdA0KT1JERVIgQlkgbmFtZTsNCg0KLS0gLS0tLS0t

LS0tLS0tLS0tLS0tDQotLSA0LiBDb3VudCByZWNvcmRzIHBlciB0cmFpdA0KLS0gLS0tLS0tLS0t

LS0tLS0tLS0tDQpTRUxFQ1QgbmFtZSBBUyB0cmFpdCwgQ09VTlQoKikgQVMgbWVhc3VyZW1lbnRz

DQpGUk9NIHRyYWl0DQpHUk9VUCBCWSBuYW1lDQpPUkRFUiBCWSBuYW1lOw0KDQotLSAtLS0tLS0t

LS0tLS0tLS0tLS0NCi0tIDUuIENvdW50IHRheGENCi0tIA0KLS0gTm90ZTogTm8gbW9ycGhvc3Bl

Y2llcyBpbiB0cmFpdCB0YWJsZSwgdGhlcmVmb3JlIGNvdW50DQotLSAJCXRheG9uICsgYXV0aG9y

aXR5IG9ubHkNCi0tIC0tLS0tLS0tLS0tLS0tLS0tLQ0KVE8gQkUgQ09NUExFVEVEIEJZIEFBUk9O

DQoNCg0KLS0gLS0tLS0tLS0tLS0tLS0tLS0tDQotLSA2LiBMaXN0IHRheGENCi0tIA0KLS0gTm90

ZSAxOiBObyBtb3JwaG9zcGVjaWVzIGluIHRyYWl0IHRhYmxlLCB1c2UgdGF4b24gKyBhdXRob3Jp

dHkgDQotLSBOb3RlIDI6IE5vdGUgZm9ybWF0aW9uIG9mIHRheG9uQ29ycmVjdGVkOiBpbmNsdWRl

cyBmYW1pbHkgT05MWSBpZg0KLS0gdGF4b24gaXMgbm90IGRldGVybWluZWQgYXQgbGVhc3QgdG8g

Z2VudXMNCi0tIC0tLS0tLS0tLS0tLS0tLS0tLQ0KVE8gQkUgQ09NUExFVEVEIEJZIEFBUk9ODQoN

Ci0tIC0tLS0tLS0tLS0tLS0tLS0tLQ0KLS0gNy4gVHJhaXQsIHZhbHVlIGFuZCB1bml0cyBmb3Ig

Zmlyc3QgNTAwMCByZWNvcmRzIA0KLS0gLS0tLS0tLS0tLS0tLS0tLS0tDQpTRUxFQ1QgbmFtZSBB

UyB0cmFpdCwgdmFsdWUsIHVuaXRzDQpGUk9NIHRyYWl0DQpPUkRFUiBCWSBuYW1lLCB2YWx1ZSwg

dW5pdHMNCkxJTUlUIDUwMDA7DQoNCi0tIC0tLS0tLS0tLS0tLS0tLS0tLQ0KLS0gOC4gVGF4b24s

IHRyYWl0IGFuZCB2YWx1ZSBmb3IgZmlyc3QgNTAwMCByZWNvcmRzIA0KLS0gLS0tLS0tLS0tLS0t

LS0tLS0tDQpUTyBCRSBDT01QTEVURUQgQlkgQUFST04NCg==

--_005_D9E5B32B49BA4419A2A07F70D706D8AEemailarizonaedu_

Content-Type: application/octet-stream;

	name="bien3_validations_traits_original.sql"

Content-Description: bien3_validations_traits_original.sql

Content-Disposition: attachment;

	filename="bien3_validations_traits_original.sql"; size=2171;

	creation-date="Tue, 21 Jan 2014 17:28:31 GMT";

	modification-date="Tue, 21 Jan 2014 17:28:31 GMT"

Content-ID: <EC973F8AC42F2141B8A1CCAD41665C60@email.arizona.edu>

Content-Transfer-Encoding: base64

LS0gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t

LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KLS0gUXVhbnRpdGF0aXZlIHZhbGlkYXRpb24gcXVl

cmllcyBhZ2FpbnN0IHRoZSB0cmFpdCB0YWJsZSBpbiBkYiBiaWVuMiBvbiBuaW1veQ0KLS0gLS0t

LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t

LS0tLS0tLS0tLS0tLS0tLS0tLQ0KDQpVU0UgYmllbjI7DQoNCi0tIC0tLS0tLS0tLS0tLS0tLS0t

LQ0KLS0gMS4gQ291bnQgcmVjb3Jkcw0KLS0gLS0tLS0tLS0tLS0tLS0tLS0tDQpTRUxFQ1QgQ09V

TlQoKikgQVMgdG90YWxyZWNvcmRzDQpGUk9NIFRyYWl0T2JzZXJ2YXRpb247DQoNCi0tIC0tLS0t

LS0tLS0tLS0tLS0tLQ0KLS0gMi4gQ291bnQgdHJhaXQgbmFtZXMNCi0tIC0tLS0tLS0tLS0tLS0t

LS0tLQ0KU0VMRUNUIENPVU5UKERJU1RJTkNUIFRyYWl0TmFtZSkgQVMgdHJhaXRzDQpGUk9NIFRy

YWl0T2JzZXJ2YXRpb247DQoNCi0tIC0tLS0tLS0tLS0tLS0tLS0tLQ0KLS0gMy4gTGlzdCB0cmFp

dCBuYW1lcw0KLS0gLS0tLS0tLS0tLS0tLS0tLS0tDQpTRUxFQ1QgRElTVElOQ1QgVHJhaXROYW1l

IEFTIHRyYWl0DQpGUk9NIFRyYWl0T2JzZXJ2YXRpb24NCk9SREVSIEJZIFRyYWl0TmFtZTsNCg0K

LS0gLS0tLS0tLS0tLS0tLS0tLS0tDQotLSA0LiBDb3VudCByZWNvcmRzIHBlciB0cmFpdA0KLS0g

LS0tLS0tLS0tLS0tLS0tLS0tDQpTRUxFQ1QgVHJhaXROYW1lIEFTIHRyYWl0LCBDT1VOVCgqKSBB

UyBtZWFzdXJlbWVudHMNCkZST00gVHJhaXRPYnNlcnZhdGlvbg0KR1JPVVAgQlkgVHJhaXROYW1l

DQpPUkRFUiBCWSBUcmFpdE5hbWU7DQoNCi0tIC0tLS0tLS0tLS0tLS0tLS0tLQ0KLS0gNS4gQ291

bnQgdGF4YQ0KLS0gDQotLSBOb3RlOiBObyBtb3JwaG9zcGVjaWVzIGluIHRyYWl0IHRhYmxlLCB0

aGVyZWZvcmUgY291bnQNCi0tIAkJdGF4b24gKyBhdXRob3JpdHkgb25seQ0KLS0gLS0tLS0tLS0t

LS0tLS0tLS0tDQpTRUxFQ1QgQ09VTlQoRElTVElOQ1QgVFJJTShDT05DQVQodGF4b25Db3JyZWN0

ZWQsJyAnLElGTlVMTChhdXRob3JpdHlDb3JyZWN0ZWQsJycpKSkpIEFTIHRheGENCkZST00gVHJh

aXRPYnNlcnZhdGlvbg0KV0hFUkUgdGF4b25Db3JyZWN0ZWQgSVMgTk9UIE5VTEw7DQoNCi0tIC0t

LS0tLS0tLS0tLS0tLS0tLQ0KLS0gNi4gTGlzdCB0YXhhDQotLSANCi0tIE5vdGUgMTogTm8gbW9y

cGhvc3BlY2llcyBpbiB0cmFpdCB0YWJsZSwgdXNlIHRheG9uICsgYXV0aG9yaXR5IA0KLS0gTm90

ZSAyOiBOb3RlIGZvcm1hdGlvbiBvZiB0YXhvbkNvcnJlY3RlZDogaW5jbHVkZXMgZmFtaWx5IE9O

TFkgaWYNCi0tIHRheG9uIGlzIG5vdCBkZXRlcm1pbmVkIGF0IGxlYXN0IHRvIGdlbnVzDQotLSAt

LS0tLS0tLS0tLS0tLS0tLS0NClNFTEVDVCBESVNUSU5DVCBUUklNKENPTkNBVChJRk5VTEwodGF4

b25Db3JyZWN0ZWQsJycpLCcgJyxJRk5VTEwoYXV0aG9yaXR5Q29ycmVjdGVkLCcnKSkpIEFTIHRh

eG9ud2l0aGF1dGhvcg0KRlJPTSBUcmFpdE9ic2VydmF0aW9uDQpPUkRFUiBCWSB0YXhvbldpdGhB

dXRob3I7DQoNCi0tIC0tLS0tLS0tLS0tLS0tLS0tLQ0KLS0gNy4gVHJhaXQsIHZhbHVlIGFuZCB1

bml0cyBmb3IgZmlyc3QgNTAwMCByZWNvcmRzIA0KLS0gLS0tLS0tLS0tLS0tLS0tLS0tDQpTRUxF

Q1QgVHJhaXROYW1lIEFTIHRyYWl0LCBUcmFpdFZhbHVlIEFTIHZhbHVlLCBVbml0IEFTIHVuaXRz

DQpGUk9NIFRyYWl0T2JzZXJ2YXRpb24NCk9SREVSIEJZIFRyYWl0TmFtZSwgVHJhaXRWYWx1ZSwg

VW5pdA0KTElNSVQgNTAwMDsNCg0KLS0gLS0tLS0tLS0tLS0tLS0tLS0tDQotLSA4LiBUYXhvbiwg

dHJhaXQgYW5kIHZhbHVlIGZvciBmaXJzdCA1MDAwIHJlY29yZHMgDQotLSAtLS0tLS0tLS0tLS0t

LS0tLS0NClNFTEVDVCBUUklNKENPTkNBVChJRk5VTEwodGF4b25Db3JyZWN0ZWQsJycpLCcgJyxJ

Rk5VTEwoYXV0aG9yaXR5Q29ycmVjdGVkLCcnKSkpIEFTIHRheG9ud2l0aGF1dGhvciwNClRyYWl0

TmFtZSBBUyB0cmFpdCwgVHJhaXRWYWx1ZSBBUyB2YWx1ZQ0KRlJPTSBUcmFpdE9ic2VydmF0aW9u

DQpPUkRFUiBCWSB0YXhvbldpdGhBdXRob3IsIFRyYWl0TmFtZSwgVHJhaXRWYWx1ZQ0KTElNSVQg

NTAwMDs=

--_005_D9E5B32B49BA4419A2A07F70D706D8AEemailarizonaedu_--