--- The following SQL definition describes VegBank, including picklist values
--- This contains all changes through beta 2.0
---------------------CREATE TABLES ----------------------------

CREATE TABLE commConcept
(
COMMCONCEPT_ID serial ,
COMMNAME_ID Integer NOT NULL ,
COMMREFERENCE_ID Integer ,
ceglCode varchar (20) ,
conceptDescription text ,

PRIMARY KEY ( COMMCONCEPT_ID )
);

CREATE TABLE commCorrelation
(
COMMCORRELATION_ID serial ,
COMMSTATUS_ID Integer ,
COMMCONCEPT_ID Integer ,
commConvergence varchar (20) ,
correlationStart Date ,
correlationStop Date ,

PRIMARY KEY ( COMMCORRELATION_ID )
);

CREATE TABLE commLineage
(
COMMLINEAGE_ID serial ,
COMMSTATUS1_ID Integer NOT NULL ,
COMMSTATUS2_ID Integer NOT NULL ,

PRIMARY KEY ( COMMLINEAGE_ID )
);

CREATE TABLE commName
(
COMMNAME_ID serial ,
commName text NOT NULL ,
COMMREFERENCE_ID Integer ,
dateEntered Date ,

PRIMARY KEY ( COMMNAME_ID )
);

CREATE TABLE commParty
(
COMMPARTY_ID serial ,
salutation varchar (20) ,
givenName varchar (50) ,
middleName varchar (50) ,
surName varchar (50) ,
organizationName varchar (100) ,
currentName Integer ,
contactInstructions text ,
owner Integer ,

PRIMARY KEY ( COMMPARTY_ID )
);

CREATE TABLE commStatus
(
COMMSTATUS_ID serial ,
COMMCONCEPT_ID Integer NOT NULL ,
COMMREFERENCE_ID Integer ,
commConceptStatus varchar (20) NOT NULL ,
commParent Integer ,
commLevel varchar (80) ,
startDate Date NOT NULL ,
stopDate Date ,
partyComments text ,
COMMPARTY_ID Integer NOT NULL ,

PRIMARY KEY ( COMMSTATUS_ID )
);

CREATE TABLE commUsage
(
COMMUSAGE_ID serial ,
COMMNAME_ID Integer NOT NULL ,
commName text ,
COMMCONCEPT_ID Integer NOT NULL ,
ceglCode varchar (200) ,
usageStart Date ,
usageStop Date ,
commNameStatus varchar (20) ,
COMMPARTY_ID Integer ,
classSystem varchar (50) ,

PRIMARY KEY ( COMMUSAGE_ID )
);

CREATE TABLE commReference
(
commReference_ID Integer NOT NULL ,
shortName varchar (250) ,
commReferenceType varchar (250) ,
title varchar (250) ,
titleSuperior varchar (250) ,
pubDate Date ,
accessDate Date ,
conferenceDate Date ,
commReferenceJournal_ID Integer ,
volume varchar (250) ,
issue varchar (250) ,
pageRange varchar (250) ,
totalPages Integer ,
publisher varchar (250) ,
publicationPlace varchar (250) ,
isbn varchar (250) ,
edition varchar (250) ,
numberOfVolumes Integer ,
chapterNumber Integer ,
reportNumber Integer ,
communicationType varchar (250) ,
degree varchar (250) ,
url text ,
doi text ,
additionalInfo text ,

PRIMARY KEY ( commReference_ID )
);

CREATE TABLE commReferenceAlternateIdentifier
(
commReferenceAlternateIdentifier_ID Integer NOT NULL ,
commReference_ID Integer NOT NULL ,
system varchar (250) ,
identifier varchar (250) NOT NULL ,

PRIMARY KEY ( commReferenceAlternateIdentifier_ID )
);

CREATE TABLE commReferenceContributor
(
commReferenceContributor_ID Integer NOT NULL ,
commReference_ID Integer NOT NULL ,
commReferenceParty_ID Integer NOT NULL ,
roleType varchar (250) ,
order Integer ,

PRIMARY KEY ( commReferenceContributor_ID )
);

CREATE TABLE commReferenceParty
(
commReferenceParty_ID Integer NOT NULL ,
type varchar (250) ,
positionName varchar (250) ,
salutation varchar (250) ,
givenName varchar (250) ,
surname varchar (250) ,
suffix varchar (250) ,
organizationName varchar (250) ,
currentParty Integer ,

PRIMARY KEY ( commReferenceParty_ID )
);

CREATE TABLE commReferenceJournal
(
commReferenceJournal_ID Integer NOT NULL ,
journal varchar (250) NOT NULL ,
issn varchar (250) ,
abbreviation varchar (250) ,

PRIMARY KEY ( commReferenceJournal_ID )
);

CREATE TABLE plantConcept
(
PLANTCONCEPT_ID serial ,
PLANTNAME_ID Integer NOT NULL ,
PLANTREFERENCE_ID Integer NOT NULL ,
plantname varchar (200) ,
plantCode varchar (23) ,
plantDescription text ,

PRIMARY KEY ( PLANTCONCEPT_ID )
);

CREATE TABLE plantCorrelation
(
PLANTCORRELATION_ID serial ,
PLANTSTATUS_ID Integer NOT NULL ,
PLANTCONCEPT_ID Integer NOT NULL ,
plantConvergence varchar (20) NOT NULL ,
correlationStart Date NOT NULL ,
correlationStop Date ,

PRIMARY KEY ( PLANTCORRELATION_ID )
);

CREATE TABLE plantLineage
(
PLANTLINEAGE_ID serial ,
PLANTSTATUS1_ID Integer ,
PLANTSTATUS2_ID Integer ,

PRIMARY KEY ( PLANTLINEAGE_ID )
);

CREATE TABLE plantName
(
PLANTNAME_ID serial ,
plantName varchar (255) NOT NULL ,
PLANTREFERENCE_ID Integer ,
dateEntered Date ,

PRIMARY KEY ( PLANTNAME_ID )
);

CREATE TABLE plantParty
(
PLANTPARTY_ID serial ,
salutation varchar (20) ,
givenName varchar (50) ,
middleName varchar (50) ,
surName varchar (50) ,
organizationName varchar (100) ,
currentName Integer ,
contactInstructions text ,
owner Integer ,
email varchar (120) ,

PRIMARY KEY ( PLANTPARTY_ID )
);

CREATE TABLE plantStatus
(
PLANTSTATUS_ID serial ,
PLANTCONCEPT_ID Integer NOT NULL ,
PLANTREFERENCE_ID Integer ,
plantConceptStatus varchar (20) NOT NULL ,
startDate Date NOT NULL ,
stopDate Date ,
plantPartyComments text ,
PLANTPARTY_ID Integer NOT NULL ,
plantParentName varchar (200) ,
plantParentConcept_id Integer ,
plantParent Integer ,
plantLevel varchar (80) ,

PRIMARY KEY ( PLANTSTATUS_ID )
);

CREATE TABLE plantUsage
(
PLANTUSAGE_ID serial ,
PLANTNAME_ID Integer NOT NULL ,
PLANTCONCEPT_ID Integer NOT NULL ,
usageStart Date ,
usageStop Date ,
plantNameStatus varchar (20) ,
plantName varchar (220) ,
PLANTPARTY_ID Integer ,
classSystem varchar (50) ,
acceptedSynonym varchar (220) ,

PRIMARY KEY ( PLANTUSAGE_ID )
);

CREATE TABLE plantReference
(
plantReference_ID Integer NOT NULL ,
shortName varchar (250) ,
plantReferenceType varchar (250) ,
title varchar (250) ,
titleSuperior varchar (250) ,
pubDate Date ,
accessDate Date ,
conferenceDate Date ,
plantReferenceJournal_ID Integer ,
volume varchar (250) ,
issue varchar (250) ,
pageRange varchar (250) ,
totalPages Integer ,
publisher varchar (250) ,
publicationPlace varchar (250) ,
isbn varchar (250) ,
edition varchar (250) ,
numberOfVolumes Integer ,
chapterNumber Integer ,
reportNumber Integer ,
communicationType varchar (250) ,
degree varchar (250) ,
url text ,
doi text ,
additionalInfo text ,

PRIMARY KEY ( plantReference_ID )
);

CREATE TABLE plantReferenceAlternateIdentifier
(
plantReferenceAlternateIdentifier_ID Integer NOT NULL ,
plantReference_ID Integer NOT NULL ,
system varchar (250) ,
identifier varchar (250) NOT NULL ,

PRIMARY KEY ( plantReferenceAlternateIdentifier_ID )
);

CREATE TABLE plantReferenceContributor
(
plantReferenceContributor_ID Integer NOT NULL ,
plantReference_ID Integer NOT NULL ,
plantReferenceParty_ID Integer NOT NULL ,
roleType varchar (250) ,
order Integer ,

PRIMARY KEY ( plantReferenceContributor_ID )
);

CREATE TABLE plantReferenceParty
(
plantReferenceParty_ID Integer NOT NULL ,
type varchar (250) ,
positionName varchar (250) ,
salutation varchar (250) ,
givenName varchar (250) ,
surname varchar (250) ,
suffix varchar (250) ,
organizationName varchar (250) ,
currentParty Integer ,

PRIMARY KEY ( plantReferenceParty_ID )
);

CREATE TABLE plantReferenceJournal
(
plantReferenceJournal_ID Integer NOT NULL ,
journal varchar (250) NOT NULL ,
issn varchar (250) ,
abbreviation varchar (250) ,

PRIMARY KEY ( plantReferenceJournal_ID )
);

CREATE TABLE address
(
ADDRESS_ID serial ,
PARTY_ID Integer NOT NULL ,
ORGANIZATION_ID Integer ,
orgPosition varchar (50) ,
email varchar (100) ,
deliveryPoint varchar (200) ,
city varchar (50) ,
administrativeArea varchar (50) ,
postalCode varchar (10) ,
country varchar (50) ,
currentFlag Boolean ,
addressStartDate Date ,

PRIMARY KEY ( ADDRESS_ID )
);

CREATE TABLE aux_Role
(
ROLE_ID serial ,
roleCode varchar (30) NOT NULL ,
roleDescription varchar (200) ,
roleProject Integer ,
roleObservation Integer ,
roleTaxonInt Integer ,
roleClassInt Integer ,

PRIMARY KEY ( ROLE_ID )
);

CREATE TABLE citation
(
citation_ID Integer NOT NULL ,
shortName varchar (250) ,
citationType varchar (250) ,
title varchar (250) ,
titleSuperior varchar (250) ,
pubDate Date ,
accessDate Date ,
conferenceDate Date ,
citationJournal_ID Integer ,
volume varchar (250) ,
issue varchar (250) ,
pageRange varchar (250) ,
totalPages Integer ,
publisher varchar (250) ,
publicationPlace varchar (250) ,
isbn varchar (250) ,
edition varchar (250) ,
numberOfVolumes Integer ,
chapterNumber Integer ,
reportNumber Integer ,
communicationType varchar (250) ,
degree varchar (250) ,
url text ,
doi text ,
additionalInfo text ,

PRIMARY KEY ( citation_ID )
);

CREATE TABLE citationAlternateIdentifier
(
citationAlternateIdentifier_ID Integer NOT NULL ,
citation_ID Integer NOT NULL ,
system varchar (250) ,
identifier varchar (250) NOT NULL ,

PRIMARY KEY ( citationAlternateIdentifier_ID )
);

CREATE TABLE citationContributor
(
citationContributor_ID Integer NOT NULL ,
citation_ID Integer NOT NULL ,
citationParty_ID Integer NOT NULL ,
roleType varchar (250) ,
order Integer ,

PRIMARY KEY ( citationContributor_ID )
);

CREATE TABLE citationParty
(
citationParty_ID Integer NOT NULL ,
type varchar (250) ,
positionName varchar (250) ,
salutation varchar (250) ,
givenName varchar (250) ,
surname varchar (250) ,
suffix varchar (250) ,
organizationName varchar (250) ,
currentParty Integer ,

PRIMARY KEY ( citationParty_ID )
);

CREATE TABLE citationJournal
(
citationJournal_ID Integer NOT NULL ,
journal varchar (250) NOT NULL ,
issn varchar (250) ,
abbreviation varchar (250) ,

PRIMARY KEY ( citationJournal_ID )
);

CREATE TABLE classContributor
(
CLASSCONTRIBUTOR_ID serial ,
COMMCLASS_ID Integer NOT NULL ,
PARTY_ID Integer NOT NULL ,
ROLE_ID Integer ,

PRIMARY KEY ( CLASSCONTRIBUTOR_ID )
);

CREATE TABLE commClass
(
COMMCLASS_ID serial ,
OBSERVATION_ID Integer NOT NULL ,
classStartDate Date ,
classStopDate Date ,
inspection Boolean ,
tableAnalysis Boolean ,
multivariateAnalysis Boolean ,
expertSystem Boolean ,
classPublication_ID Integer ,
classNotes text ,
commName varchar (200) ,
commCode varchar (200) ,
commFramework varchar (200) ,
commLevel varchar (200) ,

PRIMARY KEY ( COMMCLASS_ID )
);

CREATE TABLE commInterpretation
(
COMMINTERPRETATION_ID serial ,
COMMCLASS_ID Integer NOT NULL ,
COMMCONCEPT_ID Integer ,
commcode varchar (34) ,
commname varchar (200) ,
classFit varchar (50) ,
classConfidence varchar (15) ,
commAuthority_ID Integer ,
notes text ,
type Boolean ,

PRIMARY KEY ( COMMINTERPRETATION_ID )
);

CREATE TABLE coverIndex
(
COVERINDEX_ID serial ,
COVERMETHOD_ID Integer NOT NULL ,
coverCode varchar (10) NOT NULL ,
upperLimit Float ,
lowerLimit Float ,
coverPercent Float NOT NULL ,
indexDescription text ,

PRIMARY KEY ( COVERINDEX_ID )
);

CREATE TABLE coverMethod
(
COVERMETHOD_ID serial ,
CITATION_ID Integer ,
coverType varchar (30) NOT NULL ,

PRIMARY KEY ( COVERMETHOD_ID )
);

CREATE TABLE definedValue
(
DEFINEDVALUE_ID serial ,
USERDEFINED_ID Integer NOT NULL ,
value varchar (255) NOT NULL ,
tableRecord_ID Integer NOT NULL ,

PRIMARY KEY ( DEFINEDVALUE_ID )
);

CREATE TABLE disturbanceObs
(
disturbanceObs serial ,
OBSERVATION_ID Integer NOT NULL ,
disturbanceType varchar (30) NOT NULL ,
disturbanceIntensity varchar (30) ,
disturbanceAge Float ,
disturbanceExtent Float ,
disturbanceComment text ,

PRIMARY KEY ( disturbanceObs )
);

CREATE TABLE graphic
(
GRAPHIC_ID serial ,
OBSERVATION_ID Integer NOT NULL ,
graphicName varchar (30) ,
graphicLocation text ,
graphicDescription text ,
graphicType varchar (20) ,
graphicDate Date ,
graphicData BLOB ,

PRIMARY KEY ( GRAPHIC_ID )
);

CREATE TABLE namedPlace
(
NAMEDPLACE_ID serial ,
placeSystem varchar (50) ,
placeName varchar (100) NOT NULL ,
placeDescription text ,
placeCode varchar (15) ,
owner varchar (100) ,
CITATION_ID Integer ,

PRIMARY KEY ( NAMEDPLACE_ID )
);

CREATE TABLE note
(
NOTE_ID serial ,
NOTELINK_ID Integer NOT NULL ,
PARTY_ID Integer NOT NULL ,
ROLE_ID Integer NOT NULL ,
noteDate Date ,
noteType varchar (20) NOT NULL ,
noteText text NOT NULL ,

PRIMARY KEY ( NOTE_ID )
);

CREATE TABLE noteLink
(
NOTELINK_ID serial ,
tableName varchar (50) NOT NULL ,
attributeName varchar (50) NOT NULL ,
tableRecord Integer NOT NULL ,

PRIMARY KEY ( NOTELINK_ID )
);

CREATE TABLE observation
(
OBSERVATION_ID serial ,
PREVIOUSOBS_ID Integer ,
PLOT_ID Integer NOT NULL ,
PROJECT_ID Integer ,
authorObsCode varchar (30) ,
obsStartDate Date ,
obsEndDate Date ,
dateAccuracy varchar (30) ,
COVERMETHOD_ID Integer NOT NULL ,
STRATUMMETHOD_ID Integer NOT NULL ,
stemSizeLimit Float ,
methodNarrative text ,
taxonObservationArea Float NOT NULL ,
coverDispersion varchar (30) NOT NULL ,
autoTaxonCover Boolean NOT NULL ,
stemObservationArea Float ,
stemSampleMethod varchar (30) ,
originalData text ,
effortLevel varchar (30) ,
plotValidationLevel varchar (60) ,
floristicQuality varchar (30) ,
bryophyteQuality varchar (30) ,
lichenQuality varchar (30) ,
observationNarrative text ,
landscapeNarrative text ,
homogeneity varchar (50) ,
phenologicAspect varchar (30) ,
representativeness varchar (255) ,
basalArea Float ,
hydrologicRegime varchar (30) ,
soilMoistureRegime varchar (30) ,
soilDrainage varchar (30) ,
waterSalinity varchar (30) ,
waterDepth Float ,
shoreDistance Float ,
soilDepth Float ,
organicDepth Float ,
percentBedRock Float ,
percentRockGravel Float ,
percentWood Float ,
percentLitter Float ,
percentBareSoil Float ,
percentWater Float ,
percentOther Float ,
nameOther varchar (30) ,
standMaturity varchar (50) ,
successionalStatus text ,
treeHt Float ,
shrubHt Float ,
fieldHt Float ,
nonvascularHt Float ,
submergedHt Float ,
treeCover Float ,
shrubCover Float ,
fieldCover Float ,
nonvascularCover Float ,
floatingCover Float ,
submergedCover Float ,
dominantStratum varchar (40) ,
growthform1Type varchar (40) ,
growthform2Type varchar (40) ,
growthform3Type varchar (40) ,
growthform1Cover Float ,
growthform2Cover Float ,
growthform3Cover Float ,
SOILTAXON_ID Integer ,
soilTaxonSrc varchar (200) ,
notesPublic Boolean ,
notesMgt Boolean ,
revisions Boolean ,

PRIMARY KEY ( OBSERVATION_ID )
);

CREATE TABLE observationContributor
(
PLOTCONTRIBUTOR_ID serial ,
OBSERVATION_ID Integer NOT NULL ,
PARTY_ID Integer NOT NULL ,
ROLE_ID Integer NOT NULL ,
contributionDate Date ,

PRIMARY KEY ( PLOTCONTRIBUTOR_ID )
);

CREATE TABLE observationSynonym
(
OBSERVATIONSYNONYM_ID serial ,
OBSERVATION_ID Integer NOT NULL ,
PRIMARYOBS_ID Integer NOT NULL ,
PARTY_ID Integer NOT NULL ,
ROLE_ID Integer NOT NULL ,
classStartDate Date NOT NULL ,
classStopDate Date ,
SynonymComment text ,

PRIMARY KEY ( OBSERVATIONSYNONYM_ID )
);

CREATE TABLE party
(
PARTY_ID serial ,
salutation varchar (20) ,
givenName varchar (50) ,
middleName varchar (50) ,
surName varchar (50) ,
organizationName varchar (100) ,
currentName Integer ,
contactInstructions text ,
owner Integer ,
email varchar (120) ,

PRIMARY KEY ( PARTY_ID )
);

CREATE TABLE place
(
PLOTPLACE_ID serial ,
PLOT_ID Integer NOT NULL ,
Calculated Boolean ,
NAMEDPLACE_ID Integer NOT NULL ,

PRIMARY KEY ( PLOTPLACE_ID )
);

CREATE TABLE plot
(
PLOT_ID serial ,
authorPlotCode varchar (30) NOT NULL ,
PROJECT_ID Integer ,
CITATION_ID Integer ,
PARENT_ID Integer ,
realLatitude Float ,
realLongitude Float ,
locationAccuracy Float ,
confidentialityStatus Integer NOT NULL ,
confidentialityReason varchar (200) NOT NULL ,
Latitude Float ,
Longitude Float ,
authorE varchar (20) ,
authorN varchar (20) ,
authorZone varchar (20) ,
authorDatum varchar (20) ,
authorLocation varchar (200) ,
locationNarrative text ,
azimuth Float ,
dsgpoly text ,
shape varchar (50) ,
area Float NOT NULL ,
standSize varchar (50) ,
placementMethod varchar (50) ,
permanence Boolean ,
layoutNarative text ,
elevation Float ,
elevationAccuracy Float ,
elevationRange Float ,
slopeAspect Float ,
minSlopeAspect Float ,
maxSlopeAspect Float ,
slopeGradient Float ,
minSlopeGradient Float ,
maxSlopeGradient Float ,
topoPosition varchar (90) ,
landform varchar (50) ,
geology varchar (90) ,
notesPublic Boolean ,
notesMgt Boolean ,
revisions Boolean ,
state varchar (55) ,
country varchar (100) ,
accession_number varchar (200) ,
dateentered Date ,
submitter_surname varchar (100) ,
submitter_givenname varchar (100) ,
submitter_email varchar (100) ,

PRIMARY KEY ( PLOT_ID )
);

CREATE TABLE project
(
PROJECT_ID serial ,
projectName varchar (150) NOT NULL ,
projectDescription text ,
startDate Date ,
stopDate Date ,

PRIMARY KEY ( PROJECT_ID )
);

CREATE TABLE projectContributor
(
PROJECTCONTRIBUTOR_ID serial ,
PROJECT_ID Integer NOT NULL ,
PARTY_ID Integer NOT NULL ,
ROLE_ID Integer ,
surname varchar (50) ,
role varchar (50) ,

PRIMARY KEY ( PROJECTCONTRIBUTOR_ID )
);

CREATE TABLE revision
(
REVISION_ID serial ,
tableName varchar (50) NOT NULL ,
tableAttribute varchar (50) NOT NULL ,
tableRecord Integer NOT NULL ,
revisionDate Date NOT NULL ,
previousValueText text NOT NULL ,
previousValueType varchar (20) NOT NULL ,
previousRevision_ID Integer ,

PRIMARY KEY ( REVISION_ID )
);

CREATE TABLE soilObs
(
SOILOBS_ID serial ,
OBSERVATION_ID Integer NOT NULL ,
soilHorizon varchar (15) NOT NULL ,
soilDepthTop Float ,
soilDepthBottom Float ,
soilColor varchar (30) ,
soilOrganic Float ,
soilTexture varchar (20) ,
soilSand Float ,
soilSilt Float ,
soilClay Float ,
soilCoarse Float ,
soilPH Float ,
exchangeCapacity Float ,
baseSaturation Float ,
soilDescription text ,

PRIMARY KEY ( SOILOBS_ID )
);

CREATE TABLE soilTaxon
(
SOILTAXON_ID serial ,
soilCode varchar (15) ,
soilName varchar (100) ,
soilLevel Integer ,
SOILPARENT_ID Integer ,
soilFramework varchar (33) ,

PRIMARY KEY ( SOILTAXON_ID )
);

CREATE TABLE stemCount
(
STEMCOUNT_ID serial ,
TAXONOBSERVATION_ID Integer NOT NULL ,
stemDiameter Float ,
stemDiameterAccuracy Float ,
stemHeight Float ,
stemHeightAccuracy Float ,
stemCount Integer NOT NULL ,
stemTaxonArea Float ,

PRIMARY KEY ( STEMCOUNT_ID )
);

CREATE TABLE stemLocation
(
STEMLOCATION_ID serial ,
STEMCOUNT_ID Integer NOT NULL ,
stemCode varchar (20) ,
stemXPosition Float ,
stemYPosition Float ,

PRIMARY KEY ( STEMLOCATION_ID )
);

CREATE TABLE stratum
(
STRATUM_ID serial ,
OBSERVATION_ID Integer NOT NULL ,
STRATUMTYPE_ID Integer NOT NULL ,
STRATUMMETHOD_ID Integer ,
stratumName varchar (30) ,
stratumHeight Float ,
stratumBase Float ,
stratumCover Float ,
stratumDescription varchar (200) ,

PRIMARY KEY ( STRATUM_ID )
);

CREATE TABLE stratumComposition
(
STRATUMCOMPOSITION_ID serial ,
TAXONOBSERVATION_ID Integer NOT NULL ,
STRATUM_ID Integer NOT NULL ,
taxonStratumCover Float NOT NULL ,
cheatstratumname varchar (200) ,
cheatplantname varchar (200) ,

PRIMARY KEY ( STRATUMCOMPOSITION_ID )
);

CREATE TABLE stratumMethod
(
STRATUMMETHOD_ID serial ,
CITATION_ID Integer ,
stratumMethodName varchar (30) NOT NULL ,
stratumMethodDescription text ,

PRIMARY KEY ( STRATUMMETHOD_ID )
);

CREATE TABLE stratumType
(
STRATUMTYPE_ID serial ,
STRATUMMETHOD_ID Integer NOT NULL ,
stratumIndex varchar (10) ,
stratumName varchar (30) ,
stratumDescription text ,

PRIMARY KEY ( STRATUMTYPE_ID )
);

CREATE TABLE taxonInterpretation
(
TAXONINTERPRETATION_ID serial ,
TAXONOBSERVATION_ID Integer NOT NULL ,
PLANTCONCEPT_ID Integer NOT NULL ,
interpretationDate Date NOT NULL ,
PLANTNAME_ID Integer ,
PARTY_ID Integer NOT NULL ,
ROLE_ID Integer NOT NULL ,
interpretationType varchar (30) ,
CITATION_ID Integer ,
originalInterpretation Boolean NOT NULL ,
currentInterpretation Boolean NOT NULL ,
notes text ,
notesPublic Boolean ,
notesMgt Boolean ,
revisions Boolean ,

PRIMARY KEY ( TAXONINTERPRETATION_ID )
);

CREATE TABLE taxonObservation
(
TAXONOBSERVATION_ID serial ,
OBSERVATION_ID Integer NOT NULL ,
PLANTNAME_ID Integer ,
PLANTREFERENCE_ID Integer ,
taxonCollection varchar (100) ,
taxonCover Float ,
taxonBasalArea Float ,
taxonInferenceArea Float ,
cheatplantname varchar (200) ,

PRIMARY KEY ( TAXONOBSERVATION_ID )
);

CREATE TABLE telephone
(
TELEPHONE_ID serial ,
PARTY_ID Integer NOT NULL ,
phoneNumber varchar (30) NOT NULL ,
phoneType varchar (20) NOT NULL ,

PRIMARY KEY ( TELEPHONE_ID )
);

CREATE TABLE userDefined
(
USERDEFINED_ID serial ,
userDefinedName varchar (50) ,
userDefinedMetadata text ,
userDefinedCategory varchar (30) ,
userDefinedType varchar (20) NOT NULL ,
tableName varchar (50) NOT NULL ,

PRIMARY KEY ( USERDEFINED_ID )
);

---------------CREATE RELATIONSHIPS -------------------------

ALTER TABLE commConcept
  ADD CONSTRAINT RelNum1 FOREIGN KEY (COMMNAME_ID)
  REFERENCES commName (COMMNAME_ID );

ALTER TABLE commConcept
  ADD CONSTRAINT RelNum2 FOREIGN KEY (COMMREFERENCE_ID)
  REFERENCES commReference (COMMREFERENCE_ID );

ALTER TABLE commCorrelation
  ADD CONSTRAINT RelNum3 FOREIGN KEY (COMMSTATUS_ID)
  REFERENCES commStatus (COMMSTATUS_ID );

ALTER TABLE commCorrelation
  ADD CONSTRAINT RelNum4 FOREIGN KEY (COMMCONCEPT_ID)
  REFERENCES commConcept (COMMCONCEPT_ID );

ALTER TABLE commLineage
  ADD CONSTRAINT RelNum5 FOREIGN KEY (COMMSTATUS1_ID)
  REFERENCES commStatus (COMMSTATUS_ID );

ALTER TABLE commLineage
  ADD CONSTRAINT RelNum6 FOREIGN KEY (COMMSTATUS2_ID)
  REFERENCES commStatus (COMMSTATUS_ID );

ALTER TABLE commName
  ADD CONSTRAINT RelNum7 FOREIGN KEY (COMMREFERENCE_ID)
  REFERENCES commReference (COMMREFERENCE_ID );

ALTER TABLE commParty
  ADD CONSTRAINT RelNum8 FOREIGN KEY (currentName)
  REFERENCES commParty (COMMPARTY_ID );

ALTER TABLE commParty
  ADD CONSTRAINT RelNum9 FOREIGN KEY (owner)
  REFERENCES commParty (COMMPARTY_ID );

ALTER TABLE commStatus
  ADD CONSTRAINT RelNum10 FOREIGN KEY (COMMCONCEPT_ID)
  REFERENCES commConcept (COMMCONCEPT_ID );

ALTER TABLE commStatus
  ADD CONSTRAINT RelNum11 FOREIGN KEY (COMMREFERENCE_ID)
  REFERENCES commReference (COMMREFERENCE_ID );

ALTER TABLE commStatus
  ADD CONSTRAINT RelNum12 FOREIGN KEY (commParent)
  REFERENCES commConcept (COMMCONCEPT_ID );

ALTER TABLE commStatus
  ADD CONSTRAINT RelNum13 FOREIGN KEY (COMMPARTY_ID)
  REFERENCES commParty (COMMPARTY_ID );

ALTER TABLE commUsage
  ADD CONSTRAINT RelNum14 FOREIGN KEY (COMMNAME_ID)
  REFERENCES commName (COMMNAME_ID );

ALTER TABLE commUsage
  ADD CONSTRAINT RelNum15 FOREIGN KEY (COMMCONCEPT_ID)
  REFERENCES commConcept (COMMCONCEPT_ID );

ALTER TABLE commUsage
  ADD CONSTRAINT RelNum16 FOREIGN KEY (COMMPARTY_ID)
  REFERENCES commParty (COMMPARTY_ID );

ALTER TABLE commReference
  ADD CONSTRAINT RelNum17 FOREIGN KEY (commReferenceJournal_ID)
  REFERENCES commReferenceJournal (commReferenceJournal_ID );

ALTER TABLE commReferenceAlternateIdentifier
  ADD CONSTRAINT RelNum18 FOREIGN KEY (commReference_ID)
  REFERENCES commReference (commReference_ID );

ALTER TABLE commReferenceContributor
  ADD CONSTRAINT RelNum19 FOREIGN KEY (commReference_ID)
  REFERENCES commReference (commReference_ID );

ALTER TABLE commReferenceContributor
  ADD CONSTRAINT RelNum20 FOREIGN KEY (commReferenceParty_ID)
  REFERENCES commReferenceParty (commReferenceParty_ID );

ALTER TABLE commReferenceParty
  ADD CONSTRAINT RelNum21 FOREIGN KEY (currentParty)
  REFERENCES commReferenceParty (commReferenceParty_ID );

ALTER TABLE plantConcept
  ADD CONSTRAINT RelNum22 FOREIGN KEY (PLANTNAME_ID)
  REFERENCES plantName (PLANTNAME_ID );

ALTER TABLE plantConcept
  ADD CONSTRAINT RelNum23 FOREIGN KEY (PLANTREFERENCE_ID)
  REFERENCES plantReference (PLANTREFERENCE_ID );

ALTER TABLE plantCorrelation
  ADD CONSTRAINT RelNum24 FOREIGN KEY (PLANTSTATUS_ID)
  REFERENCES plantStatus (PLANTSTATUS_ID );

ALTER TABLE plantCorrelation
  ADD CONSTRAINT RelNum25 FOREIGN KEY (PLANTCONCEPT_ID)
  REFERENCES plantConcept (PLANTCONCEPT_ID );

ALTER TABLE plantLineage
  ADD CONSTRAINT RelNum26 FOREIGN KEY (PLANTSTATUS1_ID)
  REFERENCES plantStatus (PLANTSTATUS_ID );

ALTER TABLE plantLineage
  ADD CONSTRAINT RelNum27 FOREIGN KEY (PLANTSTATUS2_ID)
  REFERENCES plantStatus (PLANTSTATUS_ID );

ALTER TABLE plantName
  ADD CONSTRAINT RelNum28 FOREIGN KEY (PLANTREFERENCE_ID)
  REFERENCES plantReference (PLANTREFERENCE_ID );

ALTER TABLE plantParty
  ADD CONSTRAINT RelNum29 FOREIGN KEY (currentName)
  REFERENCES plantParty (PLANTPARTY_ID );

ALTER TABLE plantParty
  ADD CONSTRAINT RelNum30 FOREIGN KEY (owner)
  REFERENCES plantParty (PLANTPARTY_ID );

ALTER TABLE plantStatus
  ADD CONSTRAINT RelNum31 FOREIGN KEY (PLANTCONCEPT_ID)
  REFERENCES plantConcept (PLANTCONCEPT_ID );

ALTER TABLE plantStatus
  ADD CONSTRAINT RelNum32 FOREIGN KEY (PLANTREFERENCE_ID)
  REFERENCES plantReference (PLANTREFERENCE_ID );

ALTER TABLE plantStatus
  ADD CONSTRAINT RelNum33 FOREIGN KEY (PLANTPARTY_ID)
  REFERENCES plantParty (PLANTPARTY_ID );

ALTER TABLE plantStatus
  ADD CONSTRAINT RelNum34 FOREIGN KEY (plantParent)
  REFERENCES plantConcept (PLANTCONCEPT_ID );

ALTER TABLE plantUsage
  ADD CONSTRAINT RelNum35 FOREIGN KEY (PLANTNAME_ID)
  REFERENCES plantName (PLANTNAME_ID );

ALTER TABLE plantUsage
  ADD CONSTRAINT RelNum36 FOREIGN KEY (PLANTCONCEPT_ID)
  REFERENCES plantConcept (PLANTCONCEPT_ID );

ALTER TABLE plantUsage
  ADD CONSTRAINT RelNum37 FOREIGN KEY (PLANTPARTY_ID)
  REFERENCES plantParty (PLANTPARTY_ID );

ALTER TABLE plantReference
  ADD CONSTRAINT RelNum38 FOREIGN KEY (plantReferenceJournal_ID)
  REFERENCES plantReferenceJournal (plantReferenceJournal_ID );

ALTER TABLE plantReferenceAlternateIdentifier
  ADD CONSTRAINT RelNum39 FOREIGN KEY (plantReference_ID)
  REFERENCES plantReference (plantReference_ID );

ALTER TABLE plantReferenceContributor
  ADD CONSTRAINT RelNum40 FOREIGN KEY (plantReference_ID)
  REFERENCES plantReference (plantReference_ID );

ALTER TABLE plantReferenceContributor
  ADD CONSTRAINT RelNum41 FOREIGN KEY (plantReferenceParty_ID)
  REFERENCES plantReferenceParty (plantReferenceParty_ID );

ALTER TABLE plantReferenceParty
  ADD CONSTRAINT RelNum42 FOREIGN KEY (currentParty)
  REFERENCES plantReferenceParty (plantReferenceParty_ID );

ALTER TABLE address
  ADD CONSTRAINT RelNum43 FOREIGN KEY (PARTY_ID)
  REFERENCES party (PARTY_ID );

ALTER TABLE address
  ADD CONSTRAINT RelNum44 FOREIGN KEY (ORGANIZATION_ID)
  REFERENCES party (PARTY_ID );

ALTER TABLE citation
  ADD CONSTRAINT RelNum45 FOREIGN KEY (citationJournal_ID)
  REFERENCES citationJournal (citationJournal_ID );

ALTER TABLE citationAlternateIdentifier
  ADD CONSTRAINT RelNum46 FOREIGN KEY (citation_ID)
  REFERENCES citation (citation_ID );

ALTER TABLE citationContributor
  ADD CONSTRAINT RelNum47 FOREIGN KEY (citation_ID)
  REFERENCES citation (citation_ID );

ALTER TABLE citationContributor
  ADD CONSTRAINT RelNum48 FOREIGN KEY (citationParty_ID)
  REFERENCES citationParty (citationParty_ID );

ALTER TABLE citationParty
  ADD CONSTRAINT RelNum49 FOREIGN KEY (currentParty)
  REFERENCES citationParty (citationParty_ID );

ALTER TABLE classContributor
  ADD CONSTRAINT RelNum50 FOREIGN KEY (COMMCLASS_ID)
  REFERENCES commClass (COMMCLASS_ID );

ALTER TABLE classContributor
  ADD CONSTRAINT RelNum51 FOREIGN KEY (PARTY_ID)
  REFERENCES party (PARTY_ID );

ALTER TABLE classContributor
  ADD CONSTRAINT RelNum52 FOREIGN KEY (ROLE_ID)
  REFERENCES aux_Role (ROLE_ID );

ALTER TABLE commClass
  ADD CONSTRAINT RelNum53 FOREIGN KEY (OBSERVATION_ID)
  REFERENCES observation (OBSERVATION_ID );

ALTER TABLE commClass
  ADD CONSTRAINT RelNum54 FOREIGN KEY (classPublication_ID)
  REFERENCES citation (CITATION_ID );

ALTER TABLE commInterpretation
  ADD CONSTRAINT RelNum55 FOREIGN KEY (COMMCLASS_ID)
  REFERENCES commClass (COMMCLASS_ID );

ALTER TABLE commInterpretation
  ADD CONSTRAINT RelNum56 FOREIGN KEY (COMMCONCEPT_ID)
  REFERENCES commConcept (COMMCONCEPT_ID );

ALTER TABLE commInterpretation
  ADD CONSTRAINT RelNum57 FOREIGN KEY (commAuthority_ID)
  REFERENCES citation (CITATION_ID );

ALTER TABLE coverIndex
  ADD CONSTRAINT RelNum58 FOREIGN KEY (COVERMETHOD_ID)
  REFERENCES coverMethod (COVERMETHOD_ID );

ALTER TABLE coverMethod
  ADD CONSTRAINT RelNum59 FOREIGN KEY (CITATION_ID)
  REFERENCES citation (CITATION_ID );

ALTER TABLE definedValue
  ADD CONSTRAINT RelNum60 FOREIGN KEY (USERDEFINED_ID)
  REFERENCES userDefined (USERDEFINED_ID );

ALTER TABLE disturbanceObs
  ADD CONSTRAINT RelNum61 FOREIGN KEY (OBSERVATION_ID)
  REFERENCES observation (OBSERVATION_ID );

ALTER TABLE graphic
  ADD CONSTRAINT RelNum62 FOREIGN KEY (OBSERVATION_ID)
  REFERENCES observation (OBSERVATION_ID );

ALTER TABLE namedPlace
  ADD CONSTRAINT RelNum63 FOREIGN KEY (CITATION_ID)
  REFERENCES citation (CITATION_ID );

ALTER TABLE note
  ADD CONSTRAINT RelNum64 FOREIGN KEY (NOTELINK_ID)
  REFERENCES noteLink (NOTELINK_ID );

ALTER TABLE note
  ADD CONSTRAINT RelNum65 FOREIGN KEY (PARTY_ID)
  REFERENCES party (PARTY_ID );

ALTER TABLE note
  ADD CONSTRAINT RelNum66 FOREIGN KEY (ROLE_ID)
  REFERENCES aux_Role (ROLE_ID );

ALTER TABLE observation
  ADD CONSTRAINT RelNum67 FOREIGN KEY (PREVIOUSOBS_ID)
  REFERENCES observation (OBSERVATION_ID );

ALTER TABLE observation
  ADD CONSTRAINT RelNum68 FOREIGN KEY (PLOT_ID)
  REFERENCES plot (PLOT_ID );

ALTER TABLE observation
  ADD CONSTRAINT RelNum69 FOREIGN KEY (PROJECT_ID)
  REFERENCES project (PROJECT_ID );

ALTER TABLE observation
  ADD CONSTRAINT RelNum70 FOREIGN KEY (COVERMETHOD_ID)
  REFERENCES coverMethod (coverMethod_ID );

ALTER TABLE observation
  ADD CONSTRAINT RelNum71 FOREIGN KEY (STRATUMMETHOD_ID)
  REFERENCES stratumMethod (stratumMethod_ID );

ALTER TABLE observation
  ADD CONSTRAINT RelNum72 FOREIGN KEY (SOILTAXON_ID)
  REFERENCES soilTaxon (soilTaxon_ID );

ALTER TABLE observationContributor
  ADD CONSTRAINT RelNum73 FOREIGN KEY (OBSERVATION_ID)
  REFERENCES observation (OBSERVATION_ID );

ALTER TABLE observationContributor
  ADD CONSTRAINT RelNum74 FOREIGN KEY (PARTY_ID)
  REFERENCES party (PARTY_ID );

ALTER TABLE observationContributor
  ADD CONSTRAINT RelNum75 FOREIGN KEY (ROLE_ID)
  REFERENCES aux_Role (ROLE_ID );

ALTER TABLE observationSynonym
  ADD CONSTRAINT RelNum76 FOREIGN KEY (OBSERVATION_ID)
  REFERENCES observation (OBSERVATION_ID );

ALTER TABLE observationSynonym
  ADD CONSTRAINT RelNum77 FOREIGN KEY (PRIMARYOBS_ID)
  REFERENCES observation (OBSERVATION_ID );

ALTER TABLE observationSynonym
  ADD CONSTRAINT RelNum78 FOREIGN KEY (PARTY_ID)
  REFERENCES party (PARTY_ID );

ALTER TABLE observationSynonym
  ADD CONSTRAINT RelNum79 FOREIGN KEY (ROLE_ID)
  REFERENCES aux_Role (ROLE_ID );

ALTER TABLE party
  ADD CONSTRAINT RelNum80 FOREIGN KEY (currentName)
  REFERENCES party (PARTY_ID );

ALTER TABLE party
  ADD CONSTRAINT RelNum81 FOREIGN KEY (owner)
  REFERENCES party (PARTY_ID );

ALTER TABLE place
  ADD CONSTRAINT RelNum82 FOREIGN KEY (PLOT_ID)
  REFERENCES plot (PLOT_ID );

ALTER TABLE place
  ADD CONSTRAINT RelNum83 FOREIGN KEY (NAMEDPLACE_ID)
  REFERENCES namedPlace (NAMEDPLACE_ID );

ALTER TABLE plot
  ADD CONSTRAINT RelNum84 FOREIGN KEY (CITATION_ID)
  REFERENCES citation (CITATION_ID );

ALTER TABLE plot
  ADD CONSTRAINT RelNum85 FOREIGN KEY (PARENT_ID)
  REFERENCES plot (PLOT_ID );

ALTER TABLE projectContributor
  ADD CONSTRAINT RelNum86 FOREIGN KEY (PROJECT_ID)
  REFERENCES project (PROJECT_ID );

ALTER TABLE projectContributor
  ADD CONSTRAINT RelNum87 FOREIGN KEY (PARTY_ID)
  REFERENCES party (PARTY_ID );

ALTER TABLE projectContributor
  ADD CONSTRAINT RelNum88 FOREIGN KEY (ROLE_ID)
  REFERENCES aux_Role (ROLE_ID );

ALTER TABLE revision
  ADD CONSTRAINT RelNum89 FOREIGN KEY (previousRevision_ID)
  REFERENCES revision (REVISION_ID );

ALTER TABLE soilObs
  ADD CONSTRAINT RelNum90 FOREIGN KEY (OBSERVATION_ID)
  REFERENCES observation (observation_ID );

ALTER TABLE soilTaxon
  ADD CONSTRAINT RelNum91 FOREIGN KEY (SOILPARENT_ID)
  REFERENCES soilTaxon (SOILTAXON_ID );

ALTER TABLE stemCount
  ADD CONSTRAINT RelNum92 FOREIGN KEY (TAXONOBSERVATION_ID)
  REFERENCES taxonObservation (TAXONOBSERVATION_ID );

ALTER TABLE stemLocation
  ADD CONSTRAINT RelNum93 FOREIGN KEY (STEMCOUNT_ID)
  REFERENCES stemCount (STEMCOUNT_ID );

ALTER TABLE stratum
  ADD CONSTRAINT RelNum94 FOREIGN KEY (OBSERVATION_ID)
  REFERENCES observation (observation_ID );

ALTER TABLE stratum
  ADD CONSTRAINT RelNum95 FOREIGN KEY (STRATUMTYPE_ID)
  REFERENCES stratumType (STRATUMTYPE_ID );

ALTER TABLE stratum
  ADD CONSTRAINT RelNum96 FOREIGN KEY (STRATUMMETHOD_ID)
  REFERENCES stratumMethod (STRATUMMETHOD_ID );

ALTER TABLE stratumComposition
  ADD CONSTRAINT RelNum97 FOREIGN KEY (TAXONOBSERVATION_ID)
  REFERENCES taxonObservation (TAXONOBSERVATION_ID );

ALTER TABLE stratumComposition
  ADD CONSTRAINT RelNum98 FOREIGN KEY (STRATUM_ID)
  REFERENCES stratum (STRATUM_ID );

ALTER TABLE stratumMethod
  ADD CONSTRAINT RelNum99 FOREIGN KEY (CITATION_ID)
  REFERENCES citation (CITATION_ID );

ALTER TABLE stratumType
  ADD CONSTRAINT RelNum100 FOREIGN KEY (STRATUMMETHOD_ID)
  REFERENCES stratumMethod (STRATUMMETHOD_ID );

ALTER TABLE taxonInterpretation
  ADD CONSTRAINT RelNum101 FOREIGN KEY (TAXONOBSERVATION_ID)
  REFERENCES taxonObservation (TAXONOBSERVATION_ID );

ALTER TABLE taxonInterpretation
  ADD CONSTRAINT RelNum102 FOREIGN KEY (PLANTCONCEPT_ID)
  REFERENCES plantConcept (PLANTCONCEPT_ID );

ALTER TABLE taxonInterpretation
  ADD CONSTRAINT RelNum103 FOREIGN KEY (PLANTNAME_ID)
  REFERENCES plantName (PLANTNAME_ID );

ALTER TABLE taxonInterpretation
  ADD CONSTRAINT RelNum104 FOREIGN KEY (PARTY_ID)
  REFERENCES party (PARTY_ID );

ALTER TABLE taxonInterpretation
  ADD CONSTRAINT RelNum105 FOREIGN KEY (ROLE_ID)
  REFERENCES aux_Role (ROLE_ID );

ALTER TABLE taxonInterpretation
  ADD CONSTRAINT RelNum106 FOREIGN KEY (CITATION_ID)
  REFERENCES citation (CITATION_ID );

ALTER TABLE taxonObservation
  ADD CONSTRAINT RelNum107 FOREIGN KEY (OBSERVATION_ID)
  REFERENCES observation (observation_ID );

ALTER TABLE taxonObservation
  ADD CONSTRAINT RelNum108 FOREIGN KEY (PLANTNAME_ID)
  REFERENCES plantName (plantName_ID );

ALTER TABLE taxonObservation
  ADD CONSTRAINT RelNum109 FOREIGN KEY (PLANTREFERENCE_ID)
  REFERENCES plantReference (plantReference_ID );

ALTER TABLE telephone
  ADD CONSTRAINT RelNum110 FOREIGN KEY (PARTY_ID)
  REFERENCES party (PARTY_ID );

----------CREATE CLOSED LIST AUX_TABLES-----------------

CREATE TABLE aux_commCorrelation_commConvergence
(
values varchar (20) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE commCorrelation
  ADD CONSTRAINT RelNum_aux1 FOREIGN KEY (commConvergence)
  REFERENCES aux_commCorrelation_commConvergence ( values );

CREATE TABLE aux_commStatus_commConceptStatus
(
values varchar (20) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE commStatus
  ADD CONSTRAINT RelNum_aux2 FOREIGN KEY (commConceptStatus)
  REFERENCES aux_commStatus_commConceptStatus ( values );

CREATE TABLE aux_commStatus_commLevel
(
values varchar (80) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE commStatus
  ADD CONSTRAINT RelNum_aux3 FOREIGN KEY (commLevel)
  REFERENCES aux_commStatus_commLevel ( values );

CREATE TABLE aux_commUsage_commNameStatus
(
values varchar (20) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE commUsage
  ADD CONSTRAINT RelNum_aux4 FOREIGN KEY (commNameStatus)
  REFERENCES aux_commUsage_commNameStatus ( values );

CREATE TABLE aux_commUsage_classSystem
(
values varchar (50) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

CREATE TABLE aux_commReference_commReferenceType
(
values varchar (250) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE commReference
  ADD CONSTRAINT RelNum_aux6 FOREIGN KEY (commReferenceType)
  REFERENCES aux_commReference_commReferenceType ( values );

CREATE TABLE aux_commReferenceContributor_roleType
(
values varchar (250) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE commReferenceContributor
  ADD CONSTRAINT RelNum_aux7 FOREIGN KEY (roleType)
  REFERENCES aux_commReferenceContributor_roleType ( values );

CREATE TABLE aux_plantCorrelation_plantConvergence
(
values varchar (20) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE plantCorrelation
  ADD CONSTRAINT RelNum_aux8 FOREIGN KEY (plantConvergence)
  REFERENCES aux_plantCorrelation_plantConvergence ( values );

CREATE TABLE aux_plantStatus_plantConceptStatus
(
values varchar (20) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE plantStatus
  ADD CONSTRAINT RelNum_aux9 FOREIGN KEY (plantConceptStatus)
  REFERENCES aux_plantStatus_plantConceptStatus ( values );

CREATE TABLE aux_plantStatus_plantLevel
(
values varchar (80) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE plantStatus
  ADD CONSTRAINT RelNum_aux10 FOREIGN KEY (plantLevel)
  REFERENCES aux_plantStatus_plantLevel ( values );

CREATE TABLE aux_plantUsage_plantNameStatus
(
values varchar (20) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE plantUsage
  ADD CONSTRAINT RelNum_aux11 FOREIGN KEY (plantNameStatus)
  REFERENCES aux_plantUsage_plantNameStatus ( values );

CREATE TABLE aux_plantUsage_classSystem
(
values varchar (50) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

CREATE TABLE aux_plantReference_plantReferenceType
(
values varchar (250) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE plantReference
  ADD CONSTRAINT RelNum_aux13 FOREIGN KEY (plantReferenceType)
  REFERENCES aux_plantReference_plantReferenceType ( values );

CREATE TABLE aux_plantReferenceContributor_roleType
(
values varchar (250) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE plantReferenceContributor
  ADD CONSTRAINT RelNum_aux14 FOREIGN KEY (roleType)
  REFERENCES aux_plantReferenceContributor_roleType ( values );

CREATE TABLE aux_citation_citationType
(
values varchar (250) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE citation
  ADD CONSTRAINT RelNum_aux15 FOREIGN KEY (citationType)
  REFERENCES aux_citation_citationType ( values );

CREATE TABLE aux_citationContributor_roleType
(
values varchar (250) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE citationContributor
  ADD CONSTRAINT RelNum_aux16 FOREIGN KEY (roleType)
  REFERENCES aux_citationContributor_roleType ( values );

CREATE TABLE aux_commInterpretation_classFit
(
values varchar (50) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE commInterpretation
  ADD CONSTRAINT RelNum_aux17 FOREIGN KEY (classFit)
  REFERENCES aux_commInterpretation_classFit ( values );

CREATE TABLE aux_commInterpretation_classConfidence
(
values varchar (15) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE commInterpretation
  ADD CONSTRAINT RelNum_aux18 FOREIGN KEY (classConfidence)
  REFERENCES aux_commInterpretation_classConfidence ( values );

CREATE TABLE aux_disturbanceObs_disturbanceType
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE disturbanceObs
  ADD CONSTRAINT RelNum_aux19 FOREIGN KEY (disturbanceType)
  REFERENCES aux_disturbanceObs_disturbanceType ( values );

CREATE TABLE aux_disturbanceObs_disturbanceIntensity
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE disturbanceObs
  ADD CONSTRAINT RelNum_aux20 FOREIGN KEY (disturbanceIntensity)
  REFERENCES aux_disturbanceObs_disturbanceIntensity ( values );

CREATE TABLE aux_namedPlace_placeSystem
(
values varchar (50) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE namedPlace
  ADD CONSTRAINT RelNum_aux21 FOREIGN KEY (placeSystem)
  REFERENCES aux_namedPlace_placeSystem ( values );

CREATE TABLE aux_namedPlace_placeName
(
values varchar (100) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE namedPlace
  ADD CONSTRAINT RelNum_aux22 FOREIGN KEY (placeName)
  REFERENCES aux_namedPlace_placeName ( values );

CREATE TABLE aux_note_noteType
(
values varchar (20) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE note
  ADD CONSTRAINT RelNum_aux23 FOREIGN KEY (noteType)
  REFERENCES aux_note_noteType ( values );

CREATE TABLE aux_observation_dateAccuracy
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux24 FOREIGN KEY (dateAccuracy)
  REFERENCES aux_observation_dateAccuracy ( values );

CREATE TABLE aux_observation_coverDispersion
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux25 FOREIGN KEY (coverDispersion)
  REFERENCES aux_observation_coverDispersion ( values );

CREATE TABLE aux_observation_stemSampleMethod
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux26 FOREIGN KEY (stemSampleMethod)
  REFERENCES aux_observation_stemSampleMethod ( values );

CREATE TABLE aux_observation_effortLevel
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux27 FOREIGN KEY (effortLevel)
  REFERENCES aux_observation_effortLevel ( values );

CREATE TABLE aux_observation_plotValidationLevel
(
values varchar (60) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux28 FOREIGN KEY (plotValidationLevel)
  REFERENCES aux_observation_plotValidationLevel ( values );

CREATE TABLE aux_observation_floristicQuality
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux29 FOREIGN KEY (floristicQuality)
  REFERENCES aux_observation_floristicQuality ( values );

CREATE TABLE aux_observation_bryophyteQuality
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux30 FOREIGN KEY (bryophyteQuality)
  REFERENCES aux_observation_bryophyteQuality ( values );

CREATE TABLE aux_observation_lichenQuality
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux31 FOREIGN KEY (lichenQuality)
  REFERENCES aux_observation_lichenQuality ( values );

CREATE TABLE aux_observation_homogeneity
(
values varchar (50) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux32 FOREIGN KEY (homogeneity)
  REFERENCES aux_observation_homogeneity ( values );

CREATE TABLE aux_observation_phenologicAspect
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux33 FOREIGN KEY (phenologicAspect)
  REFERENCES aux_observation_phenologicAspect ( values );

CREATE TABLE aux_observation_hydrologicRegime
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux34 FOREIGN KEY (hydrologicRegime)
  REFERENCES aux_observation_hydrologicRegime ( values );

CREATE TABLE aux_observation_soilMoistureRegime
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux35 FOREIGN KEY (soilMoistureRegime)
  REFERENCES aux_observation_soilMoistureRegime ( values );

CREATE TABLE aux_observation_soilDrainage
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux36 FOREIGN KEY (soilDrainage)
  REFERENCES aux_observation_soilDrainage ( values );

CREATE TABLE aux_observation_waterSalinity
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux37 FOREIGN KEY (waterSalinity)
  REFERENCES aux_observation_waterSalinity ( values );

CREATE TABLE aux_observation_standMaturity
(
values varchar (50) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux38 FOREIGN KEY (standMaturity)
  REFERENCES aux_observation_standMaturity ( values );

CREATE TABLE aux_observation_dominantStratum
(
values varchar (40) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux39 FOREIGN KEY (dominantStratum)
  REFERENCES aux_observation_dominantStratum ( values );

CREATE TABLE aux_observation_growthform1Type
(
values varchar (40) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux40 FOREIGN KEY (growthform1Type)
  REFERENCES aux_observation_growthform1Type ( values );

CREATE TABLE aux_observation_growthform2Type
(
values varchar (40) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux41 FOREIGN KEY (growthform2Type)
  REFERENCES aux_observation_growthform2Type ( values );

CREATE TABLE aux_observation_growthform3Type
(
values varchar (40) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux42 FOREIGN KEY (growthform3Type)
  REFERENCES aux_observation_growthform3Type ( values );

CREATE TABLE aux_observation_soilTaxonSrc
(
values varchar (200) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE observation
  ADD CONSTRAINT RelNum_aux43 FOREIGN KEY (soilTaxonSrc)
  REFERENCES aux_observation_soilTaxonSrc ( values );

CREATE TABLE aux_plot_confidentialityStatus
(
values Integer NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE plot
  ADD CONSTRAINT RelNum_aux44 FOREIGN KEY (confidentialityStatus)
  REFERENCES aux_plot_confidentialityStatus ( values );

CREATE TABLE aux_plot_shape
(
values varchar (50) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

CREATE TABLE aux_plot_standSize
(
values varchar (50) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE plot
  ADD CONSTRAINT RelNum_aux46 FOREIGN KEY (standSize)
  REFERENCES aux_plot_standSize ( values );

CREATE TABLE aux_plot_placementMethod
(
values varchar (50) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE plot
  ADD CONSTRAINT RelNum_aux47 FOREIGN KEY (placementMethod)
  REFERENCES aux_plot_placementMethod ( values );

CREATE TABLE aux_plot_topoPosition
(
values varchar (90) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE plot
  ADD CONSTRAINT RelNum_aux48 FOREIGN KEY (topoPosition)
  REFERENCES aux_plot_topoPosition ( values );

CREATE TABLE aux_plot_landform
(
values varchar (50) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

CREATE TABLE aux_plot_geology
(
values varchar (90) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE plot
  ADD CONSTRAINT RelNum_aux50 FOREIGN KEY (geology)
  REFERENCES aux_plot_geology ( values );

CREATE TABLE aux_soilObs_soilHorizon
(
values varchar (15) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE soilObs
  ADD CONSTRAINT RelNum_aux51 FOREIGN KEY (soilHorizon)
  REFERENCES aux_soilObs_soilHorizon ( values );

CREATE TABLE aux_soilObs_soilTexture
(
values varchar (20) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE soilObs
  ADD CONSTRAINT RelNum_aux52 FOREIGN KEY (soilTexture)
  REFERENCES aux_soilObs_soilTexture ( values );

CREATE TABLE aux_taxonInterpretation_interpretationType
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE taxonInterpretation
  ADD CONSTRAINT RelNum_aux53 FOREIGN KEY (interpretationType)
  REFERENCES aux_taxonInterpretation_interpretationType ( values );

CREATE TABLE aux_telephone_phoneType
(
values varchar (20) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE telephone
  ADD CONSTRAINT RelNum_aux54 FOREIGN KEY (phoneType)
  REFERENCES aux_telephone_phoneType ( values );

CREATE TABLE aux_userDefined_userDefinedName
(
values varchar (50) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

CREATE TABLE aux_userDefined_userDefinedCategory
(
values varchar (30) NOT NULL,
valueDescription text,
sortOrd integer,
PRIMARY KEY (values)
);

--- *closed* list---
ALTER TABLE userDefined
  ADD CONSTRAINT RelNum_aux56 FOREIGN KEY (userDefinedCategory)
  REFERENCES aux_userDefined_userDefinedCategory ( values );


------------POPULATE CLOSED LISTS------------------

INSERT INTO aux_commCorrelation_commConvergence (values,valueDescription,sortOrd) select 'equal', null, 1 ;

INSERT INTO aux_commCorrelation_commConvergence (values,valueDescription,sortOrd) select 'greater than', null, 2 ;

INSERT INTO aux_commCorrelation_commConvergence (values,valueDescription,sortOrd) select 'less than', null, 3 ;

INSERT INTO aux_commCorrelation_commConvergence (values,valueDescription,sortOrd) select 'not equal', null, 4 ;

INSERT INTO aux_commCorrelation_commConvergence (values,valueDescription,sortOrd) select 'overlapping', null, 5 ;

INSERT INTO aux_commCorrelation_commConvergence (values,valueDescription,sortOrd) select 'undetermined', null, 6 ;

INSERT INTO aux_commStatus_commConceptStatus (values,valueDescription,sortOrd) select 'accepted', null, 1 ;

INSERT INTO aux_commStatus_commConceptStatus (values,valueDescription,sortOrd) select 'not accepted', null, 2 ;

INSERT INTO aux_commStatus_commConceptStatus (values,valueDescription,sortOrd) select 'undetermined', null, 3 ;

INSERT INTO aux_commStatus_commLevel (values,valueDescription,sortOrd) select 'alliance', null, 6 ;

INSERT INTO aux_commStatus_commLevel (values,valueDescription,sortOrd) select 'association', null, 7 ;

INSERT INTO aux_commStatus_commLevel (values,valueDescription,sortOrd) select 'class', null, 1 ;

INSERT INTO aux_commStatus_commLevel (values,valueDescription,sortOrd) select 'formation', null, 5 ;

INSERT INTO aux_commStatus_commLevel (values,valueDescription,sortOrd) select 'group', null, 3 ;

INSERT INTO aux_commStatus_commLevel (values,valueDescription,sortOrd) select 'other', null, 9 ;

INSERT INTO aux_commStatus_commLevel (values,valueDescription,sortOrd) select 'phase', null, 8 ;

INSERT INTO aux_commStatus_commLevel (values,valueDescription,sortOrd) select 'subclass', null, 2 ;

INSERT INTO aux_commStatus_commLevel (values,valueDescription,sortOrd) select 'subgroup', null, 4 ;

INSERT INTO aux_commUsage_commNameStatus (values,valueDescription,sortOrd) select 'not standard', null, 2 ;

INSERT INTO aux_commUsage_commNameStatus (values,valueDescription,sortOrd) select 'standard', null, 1 ;

INSERT INTO aux_commUsage_commNameStatus (values,valueDescription,sortOrd) select 'undetermined', null, 3 ;

INSERT INTO aux_commUsage_classSystem (values,valueDescription,sortOrd) select 'Code', null, 3 ;

INSERT INTO aux_commUsage_classSystem (values,valueDescription,sortOrd) select 'English Common', null, 4 ;

INSERT INTO aux_commUsage_classSystem (values,valueDescription,sortOrd) select 'Other', null, 6 ;

INSERT INTO aux_commUsage_classSystem (values,valueDescription,sortOrd) select 'Scientific', null, 1 ;

INSERT INTO aux_commUsage_classSystem (values,valueDescription,sortOrd) select 'Scientific translated', null, 2 ;

INSERT INTO aux_commUsage_classSystem (values,valueDescription,sortOrd) select 'Spanish Common', null, 5 ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'Article', null, null ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'Book', null, null ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'Chapter', null, null ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'EditedBook', null, null ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'Manuscript', null, null ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'Report', null, null ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'Thesis', null, null ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'ConferenceProceedings', null, null ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'PersonalCommunication', null, null ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'Presentation', null, null ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'Website', null, null ;

INSERT INTO aux_commReference_commReferenceType (values,valueDescription,sortOrd) select 'Generic', null, null ;

INSERT INTO aux_commReferenceContributor_roleType (values,valueDescription,sortOrd) select 'Author', null, null ;

INSERT INTO aux_commReferenceContributor_roleType (values,valueDescription,sortOrd) select 'Editor', null, null ;

INSERT INTO aux_commReferenceContributor_roleType (values,valueDescription,sortOrd) select 'Originator', null, null ;

INSERT INTO aux_commReferenceContributor_roleType (values,valueDescription,sortOrd) select 'Performer', null, null ;

INSERT INTO aux_commReferenceContributor_roleType (values,valueDescription,sortOrd) select 'Recipient', null, null ;

INSERT INTO aux_commReferenceContributor_roleType (values,valueDescription,sortOrd) select 'CustodianSteward', null, null ;

INSERT INTO aux_plantCorrelation_plantConvergence (values,valueDescription,sortOrd) select 'equal', null, 1 ;

INSERT INTO aux_plantCorrelation_plantConvergence (values,valueDescription,sortOrd) select 'greater than', null, 2 ;

INSERT INTO aux_plantCorrelation_plantConvergence (values,valueDescription,sortOrd) select 'less than', null, 3 ;

INSERT INTO aux_plantCorrelation_plantConvergence (values,valueDescription,sortOrd) select 'not equal', null, 4 ;

INSERT INTO aux_plantCorrelation_plantConvergence (values,valueDescription,sortOrd) select 'overlapping', null, 5 ;

INSERT INTO aux_plantCorrelation_plantConvergence (values,valueDescription,sortOrd) select 'undetermined', null, 6 ;

INSERT INTO aux_plantStatus_plantConceptStatus (values,valueDescription,sortOrd) select 'accepted', null, 1 ;

INSERT INTO aux_plantStatus_plantConceptStatus (values,valueDescription,sortOrd) select 'not accepted', null, 2 ;

INSERT INTO aux_plantStatus_plantConceptStatus (values,valueDescription,sortOrd) select 'undetermined', null, 3 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Class', null, 5 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Cultivar/Forma', null, 20 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Division', null, 4 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Family', null, 9 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Genus', null, 13 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Kingdom', null, 1 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Order', null, 7 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Section', null, 15 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Species', null, 17 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Species Aggregate', null, 16 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Subclass', null, 6 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Subfamily', null, 10 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Subgenus', null, 14 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Subkingdom', null, 2 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Suborder', null, 8 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Subspecies', null, 18 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Subtribe', null, 12 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Superdivision', null, 3 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Tribe', null, 11 ;

INSERT INTO aux_plantStatus_plantLevel (values,valueDescription,sortOrd) select 'Variety', null, 19 ;

INSERT INTO aux_plantUsage_plantNameStatus (values,valueDescription,sortOrd) select 'not standard', null, 2 ;

INSERT INTO aux_plantUsage_plantNameStatus (values,valueDescription,sortOrd) select 'standard', null, 1 ;

INSERT INTO aux_plantUsage_plantNameStatus (values,valueDescription,sortOrd) select 'undetermined', null, 3 ;

INSERT INTO aux_plantUsage_classSystem (values,valueDescription,sortOrd) select 'Code', null, 3 ;

INSERT INTO aux_plantUsage_classSystem (values,valueDescription,sortOrd) select 'English Common', null, 4 ;

INSERT INTO aux_plantUsage_classSystem (values,valueDescription,sortOrd) select 'Other', null, 6 ;

INSERT INTO aux_plantUsage_classSystem (values,valueDescription,sortOrd) select 'Scientific', null, 1 ;

INSERT INTO aux_plantUsage_classSystem (values,valueDescription,sortOrd) select 'Scientific without authors', null, 2 ;

INSERT INTO aux_plantUsage_classSystem (values,valueDescription,sortOrd) select 'Spanish Common', null, 5 ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'Article', null, null ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'Book', null, null ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'Chapter', null, null ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'EditedBook', null, null ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'Manuscript', null, null ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'Report', null, null ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'Thesis', null, null ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'ConferenceProceedings', null, null ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'PersonalCommunication', null, null ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'Presentation', null, null ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'Website', null, null ;

INSERT INTO aux_plantReference_plantReferenceType (values,valueDescription,sortOrd) select 'Generic', null, null ;

INSERT INTO aux_plantReferenceContributor_roleType (values,valueDescription,sortOrd) select 'Author', null, null ;

INSERT INTO aux_plantReferenceContributor_roleType (values,valueDescription,sortOrd) select 'Editor', null, null ;

INSERT INTO aux_plantReferenceContributor_roleType (values,valueDescription,sortOrd) select 'Originator', null, null ;

INSERT INTO aux_plantReferenceContributor_roleType (values,valueDescription,sortOrd) select 'Performer', null, null ;

INSERT INTO aux_plantReferenceContributor_roleType (values,valueDescription,sortOrd) select 'Recipient', null, null ;

INSERT INTO aux_plantReferenceContributor_roleType (values,valueDescription,sortOrd) select 'CustodianSteward', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'Article', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'Book', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'Chapter', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'EditedBook', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'Manuscript', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'Report', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'Thesis', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'ConferenceProceedings', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'PersonalCommunication', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'Presentation', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'Website', null, null ;

INSERT INTO aux_citation_citationType (values,valueDescription,sortOrd) select 'Generic', null, null ;

INSERT INTO aux_citationContributor_roleType (values,valueDescription,sortOrd) select 'Author', null, null ;

INSERT INTO aux_citationContributor_roleType (values,valueDescription,sortOrd) select 'Editor', null, null ;

INSERT INTO aux_citationContributor_roleType (values,valueDescription,sortOrd) select 'Originator', null, null ;

INSERT INTO aux_citationContributor_roleType (values,valueDescription,sortOrd) select 'Performer', null, null ;

INSERT INTO aux_citationContributor_roleType (values,valueDescription,sortOrd) select 'Recipient', null, null ;

INSERT INTO aux_citationContributor_roleType (values,valueDescription,sortOrd) select 'CustodianSteward', null, null ;

INSERT INTO aux_commInterpretation_classFit (values,valueDescription,sortOrd) select 'Absolutely Right', null, 5 ;

INSERT INTO aux_commInterpretation_classFit (values,valueDescription,sortOrd) select 'Absolutely wrong', null, 1 ;

INSERT INTO aux_commInterpretation_classFit (values,valueDescription,sortOrd) select 'Good answer', null, 4 ;

INSERT INTO aux_commInterpretation_classFit (values,valueDescription,sortOrd) select 'Reasonable or acceptable answer', null, 3 ;

INSERT INTO aux_commInterpretation_classFit (values,valueDescription,sortOrd) select 'Understandable but wrong', null, 2 ;

INSERT INTO aux_commInterpretation_classConfidence (values,valueDescription,sortOrd) select 'High', null, 1 ;

INSERT INTO aux_commInterpretation_classConfidence (values,valueDescription,sortOrd) select 'Low', null, 3 ;

INSERT INTO aux_commInterpretation_classConfidence (values,valueDescription,sortOrd) select 'Medium', null, 2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Cryoturbation', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Cultivation', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Erosion', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Fire suppression', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Fire, canopy', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Fire, ground', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Floods or tides', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Grazing, domestic stock', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Grazing, native ungulates', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Ground fire', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Herbicide or chemical', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Herbivory, invertebrates', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Herbivory, vertebrates', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Hydrologic alteration', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Ice', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Mowing', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Other disturbances', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Plant disease', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Roads and vehicular traffic', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Salt spray', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Timber harvest, clearcut', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Timber harvest, selective', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Trampling and trails', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceType (values,valueDescription,sortOrd) select 'Wind', null, -2 ;

INSERT INTO aux_disturbanceObs_disturbanceIntensity (values,valueDescription,sortOrd) select 'High', null, 1 ;

INSERT INTO aux_disturbanceObs_disturbanceIntensity (values,valueDescription,sortOrd) select 'Low', null, 3 ;

INSERT INTO aux_disturbanceObs_disturbanceIntensity (values,valueDescription,sortOrd) select 'Medium', null, 2 ;

INSERT INTO aux_namedPlace_placeSystem (values,valueDescription,sortOrd) select 'area|country|territory', null, -2 ;

INSERT INTO aux_namedPlace_placeSystem (values,valueDescription,sortOrd) select 'continent', null, -2 ;

INSERT INTO aux_namedPlace_placeSystem (values,valueDescription,sortOrd) select 'county', null, -2 ;

INSERT INTO aux_namedPlace_placeSystem (values,valueDescription,sortOrd) select 'Geographic Name', 'User named places', -2 ;

INSERT INTO aux_namedPlace_placeSystem (values,valueDescription,sortOrd) select 'HUC ', null, -2 ;

INSERT INTO aux_namedPlace_placeSystem (values,valueDescription,sortOrd) select 'NatureServe Ecoregion', null, -2 ;

INSERT INTO aux_namedPlace_placeSystem (values,valueDescription,sortOrd) select 'quadrangle', null, -2 ;

INSERT INTO aux_namedPlace_placeSystem (values,valueDescription,sortOrd) select 'region|state|province', null, -2 ;

INSERT INTO aux_namedPlace_placeSystem (values,valueDescription,sortOrd) select 'US EPA Ecoregion', null, -2 ;

INSERT INTO aux_note_noteType (values,valueDescription,sortOrd) select 'Database Management', null, -2 ;

INSERT INTO aux_note_noteType (values,valueDescription,sortOrd) select 'Database User', null, -2 ;

INSERT INTO aux_note_noteType (values,valueDescription,sortOrd) select 'Internal', null, -2 ;

INSERT INTO aux_note_noteType (values,valueDescription,sortOrd) select 'Observation Author', null, -2 ;

INSERT INTO aux_observation_dateAccuracy (values,valueDescription,sortOrd) select 'Exact', null, 1 ;

INSERT INTO aux_observation_dateAccuracy (values,valueDescription,sortOrd) select 'Greater than ten years', null, 7 ;

INSERT INTO aux_observation_dateAccuracy (values,valueDescription,sortOrd) select 'One month', null, 2 ;

INSERT INTO aux_observation_dateAccuracy (values,valueDescription,sortOrd) select 'One year', null, 4 ;

INSERT INTO aux_observation_dateAccuracy (values,valueDescription,sortOrd) select 'Ten years', null, 6 ;

INSERT INTO aux_observation_dateAccuracy (values,valueDescription,sortOrd) select 'Three months', null, 3 ;

INSERT INTO aux_observation_dateAccuracy (values,valueDescription,sortOrd) select 'Three years', null, 5 ;

INSERT INTO aux_observation_coverDispersion (values,valueDescription,sortOrd) select 'Contiguous', null, 1 ;

INSERT INTO aux_observation_coverDispersion (values,valueDescription,sortOrd) select 'Dispersed-random', null, 3 ;

INSERT INTO aux_observation_coverDispersion (values,valueDescription,sortOrd) select 'Dispersed-regular', null, 2 ;

INSERT INTO aux_observation_stemSampleMethod (values,valueDescription,sortOrd) select 'Bitterlich', null, 4 ;

INSERT INTO aux_observation_stemSampleMethod (values,valueDescription,sortOrd) select 'Full census', null, 1 ;

INSERT INTO aux_observation_stemSampleMethod (values,valueDescription,sortOrd) select 'Other', null, 5 ;

INSERT INTO aux_observation_stemSampleMethod (values,valueDescription,sortOrd) select 'Point quarter', null, 2 ;

INSERT INTO aux_observation_stemSampleMethod (values,valueDescription,sortOrd) select 'Random pairs', null, 3 ;

INSERT INTO aux_observation_effortLevel (values,valueDescription,sortOrd) select 'Accurate', null, 2 ;

INSERT INTO aux_observation_effortLevel (values,valueDescription,sortOrd) select 'Hurried', null, 3 ;

INSERT INTO aux_observation_effortLevel (values,valueDescription,sortOrd) select 'Very thorough', null, 1 ;

INSERT INTO aux_observation_plotValidationLevel (values,valueDescription,sortOrd) select '(1) sufficient for determining type occurrence', null, 1 ;

INSERT INTO aux_observation_plotValidationLevel (values,valueDescription,sortOrd) select '(2) sufficient for inclusion in a classification revision', null, 2 ;

INSERT INTO aux_observation_plotValidationLevel (values,valueDescription,sortOrd) select '(3) fully compliant with recommendations', null, 3 ;

INSERT INTO aux_observation_floristicQuality (values,valueDescription,sortOrd) select 'High ', null, 2 ;

INSERT INTO aux_observation_floristicQuality (values,valueDescription,sortOrd) select 'High but incomplete', null, 3 ;

INSERT INTO aux_observation_floristicQuality (values,valueDescription,sortOrd) select 'Highest', null, 1 ;

INSERT INTO aux_observation_floristicQuality (values,valueDescription,sortOrd) select 'Low', null, 6 ;

INSERT INTO aux_observation_floristicQuality (values,valueDescription,sortOrd) select 'Moderate', null, 4 ;

INSERT INTO aux_observation_floristicQuality (values,valueDescription,sortOrd) select 'Moderate but incomplete', null, 5 ;

INSERT INTO aux_observation_bryophyteQuality (values,valueDescription,sortOrd) select 'High', null, 2 ;

INSERT INTO aux_observation_bryophyteQuality (values,valueDescription,sortOrd) select 'High but incomplete', null, 3 ;

INSERT INTO aux_observation_bryophyteQuality (values,valueDescription,sortOrd) select 'Highest', null, 1 ;

INSERT INTO aux_observation_bryophyteQuality (values,valueDescription,sortOrd) select 'Low', null, 6 ;

INSERT INTO aux_observation_bryophyteQuality (values,valueDescription,sortOrd) select 'Moderate', null, 4 ;

INSERT INTO aux_observation_bryophyteQuality (values,valueDescription,sortOrd) select 'Moderate but incomplete', null, 5 ;

INSERT INTO aux_observation_bryophyteQuality (values,valueDescription,sortOrd) select 'Not examined', null, 8 ;

INSERT INTO aux_observation_bryophyteQuality (values,valueDescription,sortOrd) select 'Very incomplete', null, 7 ;

INSERT INTO aux_observation_lichenQuality (values,valueDescription,sortOrd) select 'High ', null, 2 ;

INSERT INTO aux_observation_lichenQuality (values,valueDescription,sortOrd) select 'High but incomplete', null, 3 ;

INSERT INTO aux_observation_lichenQuality (values,valueDescription,sortOrd) select 'Highest', null, 1 ;

INSERT INTO aux_observation_lichenQuality (values,valueDescription,sortOrd) select 'Low', null, 6 ;

INSERT INTO aux_observation_lichenQuality (values,valueDescription,sortOrd) select 'Moderate', null, 4 ;

INSERT INTO aux_observation_lichenQuality (values,valueDescription,sortOrd) select 'Moderate but incomplete', null, 5 ;

INSERT INTO aux_observation_lichenQuality (values,valueDescription,sortOrd) select 'Not examined', null, 8 ;

INSERT INTO aux_observation_lichenQuality (values,valueDescription,sortOrd) select 'Very incomplete', null, 7 ;

INSERT INTO aux_observation_homogeneity (values,valueDescription,sortOrd) select 'compositional trend across plot', null, 2 ;

INSERT INTO aux_observation_homogeneity (values,valueDescription,sortOrd) select 'conspicuous inclusions', null, 3 ;

INSERT INTO aux_observation_homogeneity (values,valueDescription,sortOrd) select 'homogeneous', null, 1 ;

INSERT INTO aux_observation_homogeneity (values,valueDescription,sortOrd) select 'irregular or pattern mosaic', null, 4 ;

INSERT INTO aux_observation_phenologicAspect (values,valueDescription,sortOrd) select 'aestival', null, 4 ;

INSERT INTO aux_observation_phenologicAspect (values,valueDescription,sortOrd) select 'autumnal', null, 6 ;

INSERT INTO aux_observation_phenologicAspect (values,valueDescription,sortOrd) select 'dry ', null, 9 ;

INSERT INTO aux_observation_phenologicAspect (values,valueDescription,sortOrd) select 'early wet ', null, 3 ;

INSERT INTO aux_observation_phenologicAspect (values,valueDescription,sortOrd) select 'irregular ephemeral phase', null, 10 ;

INSERT INTO aux_observation_phenologicAspect (values,valueDescription,sortOrd) select 'late wet', null, 7 ;

INSERT INTO aux_observation_phenologicAspect (values,valueDescription,sortOrd) select 'Typical growing season', null, 1 ;

INSERT INTO aux_observation_phenologicAspect (values,valueDescription,sortOrd) select 'vernal', null, 2 ;

INSERT INTO aux_observation_phenologicAspect (values,valueDescription,sortOrd) select 'wet', null, 5 ;

INSERT INTO aux_observation_phenologicAspect (values,valueDescription,sortOrd) select 'winter', null, 8 ;

INSERT INTO aux_observation_hydrologicRegime (values,valueDescription,sortOrd) select 'Intermittently flooded', null, 6 ;

INSERT INTO aux_observation_hydrologicRegime (values,valueDescription,sortOrd) select 'Permanently flooded', null, 7 ;

INSERT INTO aux_observation_hydrologicRegime (values,valueDescription,sortOrd) select 'Permanently flooded - tidal', null, 8 ;

INSERT INTO aux_observation_hydrologicRegime (values,valueDescription,sortOrd) select 'Saturated', null, 3 ;

INSERT INTO aux_observation_hydrologicRegime (values,valueDescription,sortOrd) select 'Seasonally flooded', null, 2 ;

INSERT INTO aux_observation_hydrologicRegime (values,valueDescription,sortOrd) select 'Seasonally saturated', null, 4 ;

INSERT INTO aux_observation_hydrologicRegime (values,valueDescription,sortOrd) select 'Semipermanently flooded', null, 1 ;

INSERT INTO aux_observation_hydrologicRegime (values,valueDescription,sortOrd) select 'Temporarily flooded', null, 5 ;

INSERT INTO aux_observation_hydrologicRegime (values,valueDescription,sortOrd) select 'Tidally flooded', null, 9 ;

INSERT INTO aux_observation_hydrologicRegime (values,valueDescription,sortOrd) select 'Unknown', null, 11 ;

INSERT INTO aux_observation_hydrologicRegime (values,valueDescription,sortOrd) select 'Wind-tidally flooded', null, 10 ;

INSERT INTO aux_observation_soilMoistureRegime (values,valueDescription,sortOrd) select 'Hydric ', null, 9 ;

INSERT INTO aux_observation_soilMoistureRegime (values,valueDescription,sortOrd) select 'Hygric', null, 7 ;

INSERT INTO aux_observation_soilMoistureRegime (values,valueDescription,sortOrd) select 'Mesic', null, 5 ;

INSERT INTO aux_observation_soilMoistureRegime (values,valueDescription,sortOrd) select 'Subhydric', null, 8 ;

INSERT INTO aux_observation_soilMoistureRegime (values,valueDescription,sortOrd) select 'Subhygric', null, 6 ;

INSERT INTO aux_observation_soilMoistureRegime (values,valueDescription,sortOrd) select 'Submesic', null, 4 ;

INSERT INTO aux_observation_soilMoistureRegime (values,valueDescription,sortOrd) select 'Subxeric', null, 3 ;

INSERT INTO aux_observation_soilMoistureRegime (values,valueDescription,sortOrd) select 'Very xeric', null, 1 ;

INSERT INTO aux_observation_soilMoistureRegime (values,valueDescription,sortOrd) select 'Xeric', null, 2 ;

INSERT INTO aux_observation_soilDrainage (values,valueDescription,sortOrd) select 'Moderately well drained', null, 3 ;

INSERT INTO aux_observation_soilDrainage (values,valueDescription,sortOrd) select 'Poorly drained', null, 5 ;

INSERT INTO aux_observation_soilDrainage (values,valueDescription,sortOrd) select 'Rapidly drained', null, 1 ;

INSERT INTO aux_observation_soilDrainage (values,valueDescription,sortOrd) select 'Somewhat poorly drained', null, 4 ;

INSERT INTO aux_observation_soilDrainage (values,valueDescription,sortOrd) select 'Very poorly drained', null, 6 ;

INSERT INTO aux_observation_soilDrainage (values,valueDescription,sortOrd) select 'Well drained', null, 2 ;

INSERT INTO aux_observation_waterSalinity (values,valueDescription,sortOrd) select 'Brackish (0.5-30 ppt)', null, 2 ;

INSERT INTO aux_observation_waterSalinity (values,valueDescription,sortOrd) select 'Freshwater (<0.5 ppt)', null, 3 ;

INSERT INTO aux_observation_waterSalinity (values,valueDescription,sortOrd) select 'Saltwater (>30 ppt)', null, 1 ;

INSERT INTO aux_observation_standMaturity (values,valueDescription,sortOrd) select 'Even-age, aggrading', null, 2 ;

INSERT INTO aux_observation_standMaturity (values,valueDescription,sortOrd) select 'Mature, even-age', null, 3 ;

INSERT INTO aux_observation_standMaturity (values,valueDescription,sortOrd) select 'Oldgrowth, all-age', null, 5 ;

INSERT INTO aux_observation_standMaturity (values,valueDescription,sortOrd) select 'Transition, breakup', null, 4 ;

INSERT INTO aux_observation_standMaturity (values,valueDescription,sortOrd) select 'Young, regenetative', null, 1 ;

INSERT INTO aux_observation_dominantStratum (values,valueDescription,sortOrd) select 'Floating', null, 5 ;

INSERT INTO aux_observation_dominantStratum (values,valueDescription,sortOrd) select 'Herb', null, 3 ;

INSERT INTO aux_observation_dominantStratum (values,valueDescription,sortOrd) select 'Nonvascular', null, 4 ;

INSERT INTO aux_observation_dominantStratum (values,valueDescription,sortOrd) select 'Shrub', null, 2 ;

INSERT INTO aux_observation_dominantStratum (values,valueDescription,sortOrd) select 'Submerged', null, 6 ;

INSERT INTO aux_observation_dominantStratum (values,valueDescription,sortOrd) select 'Tree', null, 1 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Alga', null, 26 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Aquatic herb', null, 23 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Bamboo', null, 9 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Broad-leaved deciduous shrub', null, 11 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Broad-leaved deciduous tree', null, 2 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Broad-leaved evergreen shrub', null, 12 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Broad-leaved evergreen tree', null, 3 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Bryophyte', null, 24 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Dwarf-shrub', null, 16 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Epiphyte', null, 27 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Evergreen sclerophyllous shrub', null, 14 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Evergreen sclerophyllous tree', null, 5 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Fern', null, 20 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Forb', null, 19 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Graminoid', null, 21 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Lichen ', null, 25 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Needle-leaved shrub', null, 10 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Needle-leaved tree', null, 1 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Palm shrub ', null, 15 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Palm tree ', null, 7 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Semi-shrub', null, 17 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Succulent forb', null, 22 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Succulent shrub', null, 18 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Succulent tree', null, 6 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Thorn shrub', null, 13 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Thorn tree', null, 4 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Tree fern', null, 8 ;

INSERT INTO aux_observation_growthform1Type (values,valueDescription,sortOrd) select 'Vine/Liana (woody climbers or vines)', null, 28 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Alga', null, 26 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Aquatic herb', null, 23 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Bamboo', null, 9 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Broad-leaved deciduous shrub', null, 11 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Broad-leaved deciduous tree', null, 2 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Broad-leaved evergreen shrub', null, 12 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Broad-leaved evergreen tree', null, 3 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Bryophyte', null, 24 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Dwarf-shrub', null, 16 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Epiphyte', null, 27 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Evergreen sclerophyllous shrub', null, 14 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Evergreen sclerophyllous tree', null, 5 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Fern', null, 20 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Forb', null, 19 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Graminoid', null, 21 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Lichen ', null, 25 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Needle-leaved shrub', null, 10 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Needle-leaved tree', null, 1 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Palm shrub ', null, 15 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Palm tree ', null, 7 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Semi-shrub', null, 17 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Succulent forb', null, 22 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Succulent shrub', null, 18 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Succulent tree', null, 6 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Thorn shrub', null, 13 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Thorn tree', null, 4 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Tree fern', null, 8 ;

INSERT INTO aux_observation_growthform2Type (values,valueDescription,sortOrd) select 'Vine/Liana (woody climbers or vines)', null, 28 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Alga', null, 26 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Aquatic herb', null, 23 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Bamboo', null, 9 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Broad-leaved deciduous shrub', null, 11 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Broad-leaved deciduous tree', null, 2 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Broad-leaved evergreen shrub', null, 12 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Broad-leaved evergreen tree', null, 3 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Bryophyte', null, 24 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Dwarf-shrub', null, 16 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Epiphyte', null, 27 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Evergreen sclerophyllous shrub', null, 14 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Evergreen sclerophyllous tree', null, 5 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Fern', null, 20 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Forb', null, 19 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Graminoid', null, 21 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Lichen ', null, 25 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Needle-leaved shrub', null, 10 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Needle-leaved tree', null, 1 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Palm shrub ', null, 15 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Palm tree ', null, 7 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Semi-shrub', null, 17 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Succulent forb', null, 22 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Succulent shrub', null, 18 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Succulent tree', null, 6 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Thorn shrub', null, 13 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Thorn tree', null, 4 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Tree fern', null, 8 ;

INSERT INTO aux_observation_growthform3Type (values,valueDescription,sortOrd) select 'Vine/Liana (woody climbers or vines)', null, 28 ;

INSERT INTO aux_observation_soilTaxonSrc (values,valueDescription,sortOrd) select 'Field observation', null, 1 ;

INSERT INTO aux_observation_soilTaxonSrc (values,valueDescription,sortOrd) select 'Other soil map', null, 3 ;

INSERT INTO aux_observation_soilTaxonSrc (values,valueDescription,sortOrd) select 'USDA county soil survey', null, 2 ;

INSERT INTO aux_plot_confidentialityStatus (values,valueDescription,sortOrd) select '0', 'Public ', 1 ;

INSERT INTO aux_plot_confidentialityStatus (values,valueDescription,sortOrd) select '1', '1 km radius', 2 ;

INSERT INTO aux_plot_confidentialityStatus (values,valueDescription,sortOrd) select '2', '10 km radius', 3 ;

INSERT INTO aux_plot_confidentialityStatus (values,valueDescription,sortOrd) select '3', '100 km radius', 4 ;

INSERT INTO aux_plot_confidentialityStatus (values,valueDescription,sortOrd) select '4', 'Location embargo', 5 ;

INSERT INTO aux_plot_confidentialityStatus (values,valueDescription,sortOrd) select '5', 'Public embargo on data', 6 ;

INSERT INTO aux_plot_confidentialityStatus (values,valueDescription,sortOrd) select '6', 'Full embargo on data', 7 ;

INSERT INTO aux_plot_shape (values,valueDescription,sortOrd) select 'Circle', null, 3 ;

INSERT INTO aux_plot_shape (values,valueDescription,sortOrd) select 'Diffuse ', null, 6 ;

INSERT INTO aux_plot_shape (values,valueDescription,sortOrd) select 'Plotless', null, 5 ;

INSERT INTO aux_plot_shape (values,valueDescription,sortOrd) select 'Rectangular', null, 1 ;

INSERT INTO aux_plot_shape (values,valueDescription,sortOrd) select 'Square', null, 2 ;

INSERT INTO aux_plot_shape (values,valueDescription,sortOrd) select 'Transect/Strip', null, 4 ;

INSERT INTO aux_plot_standSize (values,valueDescription,sortOrd) select 'Extensive (>100x plot)', null, 2 ;

INSERT INTO aux_plot_standSize (values,valueDescription,sortOrd) select 'Large (10-100x plot)', null, 3 ;

INSERT INTO aux_plot_standSize (values,valueDescription,sortOrd) select 'Small (3-10x plot)', null, 4 ;

INSERT INTO aux_plot_standSize (values,valueDescription,sortOrd) select 'Very Extensive (>1000x plot)', null, 1 ;

INSERT INTO aux_plot_standSize (values,valueDescription,sortOrd) select 'Very small (1-3x plot)', null, 5 ;

INSERT INTO aux_plot_placementMethod (values,valueDescription,sortOrd) select 'Capture specific feature', null, 6 ;

INSERT INTO aux_plot_placementMethod (values,valueDescription,sortOrd) select 'Random', null, 2 ;

INSERT INTO aux_plot_placementMethod (values,valueDescription,sortOrd) select 'Regular', null, 1 ;

INSERT INTO aux_plot_placementMethod (values,valueDescription,sortOrd) select 'Representative', null, 5 ;

INSERT INTO aux_plot_placementMethod (values,valueDescription,sortOrd) select 'Stratified random', null, 3 ;

INSERT INTO aux_plot_placementMethod (values,valueDescription,sortOrd) select 'Transect component', null, 4 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'Backslope (dipslope)', null, 5 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'Basin floor (depression)', null, 12 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'Channel bed (narrow valley bottom, gully arroyo)', null, 11 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'Channel wall (bank)', null, 10 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'High level (mesa)', null, 3 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'High slope (shoulder slope, upper slope, convex creep slope)', null, 2 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'Interfluve (crest, summit, ridge)', null, 1 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'Low level (terrace)', null, 9 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'Lowslope (lower slope, foot slope, colluvial footslope)', null, 7 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'Midslope (transportational midslope, middle slope)', null, 4 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'Step in slope (ledge, terracette)', null, 6 ;

INSERT INTO aux_plot_topoPosition (values,valueDescription,sortOrd) select 'Toeslope (alluvial toeslope)', null, 8 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'alluvial fan', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'alluvial flat', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'alluvial terrace', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'backshore terrace', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'backwater', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'badlands', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'bald', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'bank', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'bar', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'barrier beach', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'barrier flat', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'barrier island(s)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'barrier reef', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'basin', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'basin floor', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'bay', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'bayou', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'beach', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'beach ridge', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'bench', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'blowout', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'bottomlands', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'butte', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'caldera', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'canyon', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'carolina bay', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'channel', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'chenier', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'chenier plain', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'cirque', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'cirque floor', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'cirque headwall', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'cliff', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'coast', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'coastal plain', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'col', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'collapse sinkhole', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'colluvial shoulder', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'colluvial slope', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'cove', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'cuesta', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'debris slide', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'delta', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'delta plain', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'depositional levee', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'depositional stream terrace', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'depression', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'desert pavement', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'dike', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'doline', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'dome', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'drainage', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'drainage channel (undifferentiated)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'draw', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'drumlin', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'dune (undifferentiated)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'dune field', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'earth flow', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'earth hummock', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'eroded bench', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'eroding stream channel system', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'erosional stream terrace', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'escarpment', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'esker', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'estuary', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'exogenous dome', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'fan piedmont', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'fault scarp', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'fault terrace', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'fissure', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'fissure vent', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'flood plain', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'fluvial', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'foothills', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'foredune', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'frost creep slope', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'frost mound', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'frost scar', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'gap', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'glaciated uplands', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'glacier', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'gorge', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'graben', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'ground moraine', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'gulch', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'hanging valley', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'headland', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'highland', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'hills', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'hillslope bedrock outcrop', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'hogback', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'hoodoo', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'hummock', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'inlet', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'inselberg', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'interdune flat', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'interfluve', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'island', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'kame', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'kame moraine', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'kame terrace', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'karst', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'karst tower', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'karst window', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'kegel karst', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'kettle', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'kettled outwash plain', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'knob', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'knoll', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'lagoon', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'lake', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'lake bed', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'lake plain', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'lake terrace', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'lateral moraine', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'lateral scarp (undifferentiated)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'lava flow (undifferentiated)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'ledge', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'levee', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'loess deposit (undifferentiated)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'longshore bar', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'lowland', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'marine terrace (undifferentiated)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'meander belt', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'meander scar', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'mesa', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'mid slope', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'mima mound', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'monadnock', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'moraine (undifferentiated)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'mound', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'mountain valley', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'mountain(s)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'mountain-valley fan', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'mud flat', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'noseslope', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'outwash fan', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'outwash plain', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'outwash terrace', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'oxbow', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'patterned ground (undifferentiated)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'peat dome', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'periglacial boulderfield', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'piedmont', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'pimple mounds', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'pingo', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'pinnacle', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'plain', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'plateau', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'playa', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'polygon (high-centered)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'polygon (low-centered)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'pothole', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'raised beach', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'raised estuary', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'raised mudflat', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'raised tidal flat', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'ravine', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'relict coastline', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'ridge', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'ridge and valley', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'ridgetop bedrock outcrop', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'rift valley', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'rim', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'riverbed', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'rock fall avalanche', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'saddle', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'sag pond', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'sandhills', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'scarp', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'scarp slope', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'scour', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'scoured basin', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'sea cliff', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'seep', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'shoal', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'shoreline', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'sinkhole (undifferentiated)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'slide', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'slope', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'slough', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'slump and topple prone slope', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'slump pond', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'soil creep slope', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'solution sinkhole', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'spit', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'splay', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'stone circle', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'stone stripe', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'stream terrace (undifferentiated)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'streambed', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'subjacent karst collapse sinkhole', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'subsidence sinkhole', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'swale', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'talus', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'tarn', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'tidal flat', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'tidal gut', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'till plain', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'toe slope', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'toe zone (undifferentiated)', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'transverse dune', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'trench', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'trough', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'valley', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'valley floor', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'wave-built terrace', null, -2 ;

INSERT INTO aux_plot_landform (values,valueDescription,sortOrd) select 'wave-cut platform', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Aeolian Deposits: Aeolian sand flats', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Aeolian Deposits: Cover sands', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Aeolian Deposits: Dunes', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Aeolian Deposits: Loess deposits', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Flat (n/a)', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Glacial Deposits: Bedrock and till', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Glacial Deposits: Deltaic deposits', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Glacial Deposits: Glacial-fluvial deposits', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Glacial Deposits: Lacustrine and fluvial deposits', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Glacial Deposits: Marine deposits', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Glacial Deposits: Moraine', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Glacial Deposits: Till', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Glacial Deposits: Undifferentiated glacial deposit', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Igneous Rocks: Dioritic', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Igneous Rocks: Gabbroic', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Igneous Rocks: Granitic', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Metamorphic Rocks: Gneiss', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Metamorphic Rocks: Marble', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Metamorphic Rocks: Schist', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Metamorphic Rocks: Serpentine', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Metamorphic Rocks: Slate and Phyllite', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Organic Deposits: Marsh: regularly flooded by lake or river', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Organic Deposits: Muck', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Organic Deposits: Peat', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Sedimentary Rocks: Conglomerates and Breccias', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Sedimentary Rocks: Gypsum', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Sedimentary Rocks: Limestone and Dolomite', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Sedimentary Rocks: Marl', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Sedimentary Rocks: Sandstone', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Sedimentary Rocks: Shale', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Sedimentary Rocks: Siltstone', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Slope & Modified Deposits: Colluvial', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Slope & Modified Deposits: Solifluction, landslide', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Slope & Modified Deposits: Talus and scree slopes', null, -2 ;

INSERT INTO aux_plot_geology (values,valueDescription,sortOrd) select 'Variable', null, -2 ;

INSERT INTO aux_soilObs_soilHorizon (values,valueDescription,sortOrd) select 'A', null, 3 ;

INSERT INTO aux_soilObs_soilHorizon (values,valueDescription,sortOrd) select 'B', null, 5 ;

INSERT INTO aux_soilObs_soilHorizon (values,valueDescription,sortOrd) select 'C', null, 6 ;

INSERT INTO aux_soilObs_soilHorizon (values,valueDescription,sortOrd) select 'E', null, 4 ;

INSERT INTO aux_soilObs_soilHorizon (values,valueDescription,sortOrd) select 'L', null, 1 ;

INSERT INTO aux_soilObs_soilHorizon (values,valueDescription,sortOrd) select 'O', null, 2 ;

INSERT INTO aux_soilObs_soilHorizon (values,valueDescription,sortOrd) select 'R', null, 7 ;

INSERT INTO aux_soilObs_soilTexture (values,valueDescription,sortOrd) select 'Clay', null, 6 ;

INSERT INTO aux_soilObs_soilTexture (values,valueDescription,sortOrd) select 'Clay loam', null, 5 ;

INSERT INTO aux_soilObs_soilTexture (values,valueDescription,sortOrd) select 'Loam', null, 3 ;

INSERT INTO aux_soilObs_soilTexture (values,valueDescription,sortOrd) select 'Muck', null, 8 ;

INSERT INTO aux_soilObs_soilTexture (values,valueDescription,sortOrd) select 'Peat', null, 7 ;

INSERT INTO aux_soilObs_soilTexture (values,valueDescription,sortOrd) select 'Sand', null, 1 ;

INSERT INTO aux_soilObs_soilTexture (values,valueDescription,sortOrd) select 'Sandy loam', null, 2 ;

INSERT INTO aux_soilObs_soilTexture (values,valueDescription,sortOrd) select 'Silt loam', null, 4 ;

INSERT INTO aux_taxonInterpretation_interpretationType (values,valueDescription,sortOrd) select 'Author', null, 1 ;

INSERT INTO aux_taxonInterpretation_interpretationType (values,valueDescription,sortOrd) select 'Computer (automated)', null, 2 ;

INSERT INTO aux_taxonInterpretation_interpretationType (values,valueDescription,sortOrd) select 'Correction', null, 4 ;

INSERT INTO aux_taxonInterpretation_interpretationType (values,valueDescription,sortOrd) select 'Finer resolution', null, 6 ;

INSERT INTO aux_taxonInterpretation_interpretationType (values,valueDescription,sortOrd) select 'Simplification for analysis', null, 3 ;

INSERT INTO aux_taxonInterpretation_interpretationType (values,valueDescription,sortOrd) select 'Taxonomic revision', null, 5 ;

INSERT INTO aux_telephone_phoneType (values,valueDescription,sortOrd) select 'Cell', null, 3 ;

INSERT INTO aux_telephone_phoneType (values,valueDescription,sortOrd) select 'Fax', null, 4 ;

INSERT INTO aux_telephone_phoneType (values,valueDescription,sortOrd) select 'Home', null, 2 ;

INSERT INTO aux_telephone_phoneType (values,valueDescription,sortOrd) select 'Not specified', null, 6 ;

INSERT INTO aux_telephone_phoneType (values,valueDescription,sortOrd) select 'Secretary', null, 5 ;

INSERT INTO aux_telephone_phoneType (values,valueDescription,sortOrd) select 'Work', null, 1 ;

INSERT INTO aux_userDefined_userDefinedName (values,valueDescription,sortOrd) select 'Depth to permafrost', null, 3 ;

INSERT INTO aux_userDefined_userDefinedName (values,valueDescription,sortOrd) select 'Microbial biomass', null, 1 ;

INSERT INTO aux_userDefined_userDefinedName (values,valueDescription,sortOrd) select 'Slope convexity', null, 2 ;

INSERT INTO aux_userDefined_userDefinedCategory (values,valueDescription,sortOrd) select 'Disturbance & land use', null, 7 ;

INSERT INTO aux_userDefined_userDefinedCategory (values,valueDescription,sortOrd) select 'Environment', null, 5 ;

INSERT INTO aux_userDefined_userDefinedCategory (values,valueDescription,sortOrd) select 'Geology & geomorphology', null, 3 ;

INSERT INTO aux_userDefined_userDefinedCategory (values,valueDescription,sortOrd) select 'Moisture', null, 4 ;

INSERT INTO aux_userDefined_userDefinedCategory (values,valueDescription,sortOrd) select 'Not specified', null, 9 ;

INSERT INTO aux_userDefined_userDefinedCategory (values,valueDescription,sortOrd) select 'Soil, chemical attributes', null, 2 ;

INSERT INTO aux_userDefined_userDefinedCategory (values,valueDescription,sortOrd) select 'Soil, physical attributes', null, 1 ;

INSERT INTO aux_userDefined_userDefinedCategory (values,valueDescription,sortOrd) select 'Subplots', null, 8 ;

INSERT INTO aux_userDefined_userDefinedCategory (values,valueDescription,sortOrd) select 'Topography', null, 6 ;