NASIS_Reports_SQL_MISSING.txt

====================================================================================================
NASIS Pedon Report for: area ---- Area

ACCEPT pedonid_list.
EXEC SQL SELECT

area.areatypeiidref/1 AS areatypeiidref,
area.seqnum AS seqnum,
area.areasymbol AS areasymbol,
area.areaname AS areaname,
area.areaacres AS areaacres,
area.obterm AS obterm,
area.recwlupdated AS recwlupdated,
area.recuseriidref/1 AS recuseriidref,
area.areaiid/1 AS areaiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN areatype ON areatype.grpiidref,atdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN area ON area.areatypeiidref=areatype.areatypeiid;.

TEMPLATE area WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin area".
END SECTION.

SECTION HEADING
USING area
'areatypeiidref',
'seqnum',
'areasymbol',
'areaname',
'areaacres',
'obterm',
'recwlupdated',
'recuseriidref',
'areaiid'.

DATA
USING area
areatypeiidref,
seqnum,
areasymbol,
areaname,
areaacres,
obterm,
recwlupdated,
recuseriidref,
areaiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin area".
USING area
'areatypeiidref',
'seqnum',
'areasymbol',
'areaname',
'areaacres',
'obterm',
'recwlupdated',
'recuseriidref',
'areaiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: areatext ---- Area Text

ACCEPT pedonid_list.
EXEC SQL SELECT

areatext.areaiidref/1 AS areaiidref,
areatext.seqnum AS seqnum,
areatext.recdate AS recdate,
areatext.recauthor AS recauthor,
CODELABEL (areatextkind) AS areatextkind,
areatext.textcat AS textcat,
areatext.textsubcat AS textsubcat,
areatext.textentry AS textentry,
areatext.recwlupdated AS recwlupdated,
areatext.recuseriidref/1 AS recuseriidref,
areatext.areatextiid/1 AS areatextiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN areatype ON areatype.grpiidref,atdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN area ON area.areatypeiidref=areatype.areatypeiid
INNER JOIN areatext ON areatext.areaiidref=area.areaiid;.

TEMPLATE areatext WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin areatext".
END SECTION.

SECTION HEADING
USING areatext
'areaiidref',
'seqnum',
'recdate',
'recauthor',
'areatextkind',
'textcat',
'textsubcat',
'textentry',
'recwlupdated',
'recuseriidref',
'areatextiid'.

DATA
USING areatext
areaiidref,
seqnum,
recdate,
recauthor,
areatextkind,
textcat,
textsubcat,
textentry,
recwlupdated,
recuseriidref,
areatextiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin areatext".
USING areatext
'areaiidref',
'seqnum',
'recdate',
'recauthor',
'areatextkind',
'textcat',
'textsubcat',
'textentry',
'recwlupdated',
'recuseriidref',
'areatextiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: areatype ---- Area Type

ACCEPT pedonid_list.
EXEC SQL SELECT

areatype.areatypename AS areatypename,
areatype.atdbiidref AS atdbiidref,
areatype.grpiidref AS grpiidref,
areatype.objwlupdated AS objwlupdated,
areatype.objuseriidref AS objuseriidref,
areatype.recwlupdated AS recwlupdated,
areatype.recuseriidref/1 AS recuseriidref,
areatype.areatypeiid/1 AS areatypeiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN areatype ON areatype.grpiidref,atdbiidref=nasisgroup.grpiid,nasissiteiidref;.

TEMPLATE areatype WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin areatype".
END SECTION.

SECTION HEADING
USING areatype
'areatypename',
'atdbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'areatypeiid'.

DATA
USING areatype
areatypename,
atdbiidref,
grpiidref,
objwlupdated,
objuseriidref,
recwlupdated,
recuseriidref,
areatypeiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin areatype".
USING areatype
'areatypename',
'atdbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'areatypeiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: basalareatreescounted ---- Basal Area Trees Counted

ACCEPT pedonid_list.
EXEC SQL SELECT

basalareatreescounted.plotspeciebasalareaiidref/1 AS plotspeciebasalareaiidref,
basalareatreescounted.seqnum AS seqnum,
basalareatreescounted.treenumber AS treenumber,
basalareatreescounted.treeheight AS treeheight,
basalareatreescounted.treediameterbreastheight AS treediameterbreastheight,
basalareatreescounted.recwlupdated AS recwlupdated,
basalareatreescounted.recuseriidref/1 AS recuseriidref,
basalareatreescounted.basalareatreescountediid/1 AS basalareatreescountediid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN plotspeciesbasalarea ON plotspeciesbasalarea.plantiidref=plant.plantiid
INNER JOIN basalareatreescounted ON basalareatreescounted.plotspeciebasalareaiidref=plotspeciesbasalarea.plotspeciebasalareaiid;.

TEMPLATE basalareatreescounted WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin basalareatreescounted".
END SECTION.

SECTION HEADING
USING basalareatreescounted
'plotspeciebasalareaiidref',
'seqnum',
'treenumber',
'treeheight',
'treediameterbreastheight',
'recwlupdated',
'recuseriidref',
'basalareatreescountediid'.

DATA
USING basalareatreescounted
plotspeciebasalareaiidref,
seqnum,
treenumber,
treeheight,
treediameterbreastheight,
recwlupdated,
recuseriidref,
basalareatreescountediid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin basalareatreescounted".
USING basalareatreescounted
'plotspeciebasalareaiidref',
'seqnum',
'treenumber',
'treeheight',
'treediameterbreastheight',
'recwlupdated',
'recuseriidref',
'basalareatreescountediid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: beltdata ---- Belt Data

ACCEPT pedonid_list.
EXEC SQL SELECT

beltdata.vegtransplantsummiidref/1 AS vegtransplantsummiidref,
beltdata.seqnum AS seqnum,
beltdata.plantheightcllowerlimit AS plantheightcllowerlimit,
beltdata.plantheightclupperlimit AS plantheightclupperlimit,
beltdata.plantcount AS plantcount,
beltdata.speciesdensity AS speciesdensity,
beltdata.recwlupdated AS recwlupdated,
beltdata.recuseriidref/1 AS recuseriidref,
beltdata.beltdataiid/1 AS beltdataiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN vegtransectplantsummary ON vegtransectplantsummary.plantiidref=plant.plantiid
INNER JOIN beltdata ON beltdata.vegtransplantsummiidref=vegtransectplantsummary.vegtransplantsummiid;.

TEMPLATE beltdata WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin beltdata".
END SECTION.

SECTION HEADING
USING beltdata
'vegtransplantsummiidref',
'seqnum',
'plantheightcllowerlimit',
'plantheightclupperlimit',
'plantcount',
'speciesdensity',
'recwlupdated',
'recuseriidref',
'beltdataiid'.

DATA
USING beltdata
vegtransplantsummiidref,
seqnum,
plantheightcllowerlimit,
plantheightclupperlimit,
plantcount,
speciesdensity,
recwlupdated,
recuseriidref,
beltdataiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin beltdata".
USING beltdata
'vegtransplantsummiidref',
'seqnum',
'plantheightcllowerlimit',
'plantheightclupperlimit',
'plantcount',
'speciesdensity',
'recwlupdated',
'recuseriidref',
'beltdataiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: belttransectsummary ---- Belt Transect Summary

ACCEPT pedonid_list.
EXEC SQL SELECT

belttransectsummary.vegtransectiidref/1 AS vegtransectiidref,
belttransectsummary.seqnum AS seqnum,
belttransectsummary.plantheightcllowerlimit AS plantheightcllowerlimit,
belttransectsummary.plantheightclupperlimit AS plantheightclupperlimit,
belttransectsummary.plantcounttotal AS plantcounttotal,
belttransectsummary.htclassplantdensity AS htclassplantdensity,
belttransectsummary.recwlupdated AS recwlupdated,
belttransectsummary.recuseriidref/1 AS recuseriidref,
belttransectsummary.belttranssummiid/1 AS belttranssummiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN belttransectsummary ON belttransectsummary.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE belttransectsummary WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin belttransectsummary".
END SECTION.

SECTION HEADING
USING belttransectsummary
'vegtransectiidref',
'seqnum',
'plantheightcllowerlimit',
'plantheightclupperlimit',
'plantcounttotal',
'htclassplantdensity',
'recwlupdated',
'recuseriidref',
'belttranssummiid'.

DATA
USING belttransectsummary
vegtransectiidref,
seqnum,
plantheightcllowerlimit,
plantheightclupperlimit,
plantcounttotal,
htclassplantdensity,
recwlupdated,
recuseriidref,
belttranssummiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin belttransectsummary".
USING belttransectsummary
'vegtransectiidref',
'seqnum',
'plantheightcllowerlimit',
'plantheightclupperlimit',
'plantcounttotal',
'htclassplantdensity',
'recwlupdated',
'recuseriidref',
'belttranssummiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: climatestation ---- Climate Station

ACCEPT pedonid_list.
EXEC SQL SELECT

climatestation.siteobsiidref/1 AS siteobsiidref,
climatestation.seqnum AS seqnum,
climatestation.climstaid AS climstaid,
climatestation.climstanm AS climstanm,
climatestation.climstatype AS climstatype,
climatestation.latstddecimaldegrees AS latstddecimaldegrees,
climatestation.longstddecimaldegrees AS longstddecimaldegrees,
climatestation.elev AS elev,
climatestation.distancefromclimstation AS distancefromclimstation,
climatestation.directionfromclimstation AS directionfromclimstation,
climatestation.climatestationurl AS climatestationurl,
climatestation.recwlupdated AS recwlupdated,
climatestation.recuseriidref/1 AS recuseriidref,
climatestation.climatestationiid/1 AS climatestationiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
TEMPLATE climatestation WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin climatestation".
END SECTION.

SECTION HEADING
USING climatestation
'siteobsiidref',
'seqnum',
'climstaid',
'climstanm',
'climstatype',
'latstddecimaldegrees',
'longstddecimaldegrees',
'elev',
'distancefromclimstation',
'directionfromclimstation',
'climatestationurl',
'recwlupdated',
'recuseriidref',
'climatestationiid'.

DATA
USING climatestation
siteobsiidref,
seqnum,
climstaid,
climstanm,
climstatype,
latstddecimaldegrees,
longstddecimaldegrees,
elev,
distancefromclimstation,
directionfromclimstation,
climatestationurl,
recwlupdated,
recuseriidref,
climatestationiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin climatestation".
USING climatestation
'siteobsiidref',
'seqnum',
'climstaid',
'climstanm',
'climstatype',
'latstddecimaldegrees',
'longstddecimaldegrees',
'elev',
'distancefromclimstation',
'directionfromclimstation',
'climatestationurl',
'recwlupdated',
'recuseriidref',
'climatestationiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: comparativeyielddata ---- Comparative Yield Data

ACCEPT pedonid_list.
EXEC SQL SELECT

comparativeyielddata.vegtransectiidref/1 AS vegtransectiidref,
comparativeyielddata.seqnum AS seqnum,
comparativeyielddata.yieldrank AS yieldrank,
comparativeyielddata.tallycount AS tallycount,
comparativeyielddata.rankxtally AS rankxtally,
comparativeyielddata.recwlupdated AS recwlupdated,
comparativeyielddata.recuseriidref/1 AS recuseriidref,
comparativeyielddata.compyielddataiid/1 AS compyielddataiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN comparativeyielddata ON comparativeyielddata.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE comparativeyielddata WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin comparativeyielddata".
END SECTION.

SECTION HEADING
USING comparativeyielddata
'vegtransectiidref',
'seqnum',
'yieldrank',
'tallycount',
'rankxtally',
'recwlupdated',
'recuseriidref',
'compyielddataiid'.

DATA
USING comparativeyielddata
vegtransectiidref,
seqnum,
yieldrank,
tallycount,
rankxtally,
recwlupdated,
recuseriidref,
compyielddataiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin comparativeyielddata".
USING comparativeyielddata
'vegtransectiidref',
'seqnum',
'yieldrank',
'tallycount',
'rankxtally',
'recwlupdated',
'recuseriidref',
'compyielddataiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: comparativeyieldrefquadrats ---- Comparative Yield Reference Quadrats

ACCEPT pedonid_list.
EXEC SQL SELECT

comparativeyieldrefquadrats.vegtransectiidref/1 AS vegtransectiidref,
comparativeyieldrefquadrats.seqnum AS seqnum,
CODELABEL (refyieldrank) AS refyieldrank,
comparativeyieldrefquadrats.quadratsize AS quadratsize,
CODELABEL (quadratshape) AS quadratshape,
comparativeyieldrefquadrats.clippedwtrefquadrat AS clippedwtrefquadrat,
comparativeyieldrefquadrats.compyldconvfactor AS compyldconvfactor,
comparativeyieldrefquadrats.recwlupdated AS recwlupdated,
comparativeyieldrefquadrats.recuseriidref/1 AS recuseriidref,
comparativeyieldrefquadrats.compyldrefquadiid/1 AS compyldrefquadiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN comparativeyieldrefquadrats ON comparativeyieldrefquadrats.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE comparativeyieldrefquadrats WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin comparativeyieldrefquadrats".
END SECTION.

SECTION HEADING
USING comparativeyieldrefquadrats
'vegtransectiidref',
'seqnum',
'refyieldrank',
'quadratsize',
'quadratshape',
'clippedwtrefquadrat',
'compyldconvfactor',
'recwlupdated',
'recuseriidref',
'compyldrefquadiid'.

DATA
USING comparativeyieldrefquadrats
vegtransectiidref,
seqnum,
refyieldrank,
quadratsize,
quadratshape,
clippedwtrefquadrat,
compyldconvfactor,
recwlupdated,
recuseriidref,
compyldrefquadiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin comparativeyieldrefquadrats".
USING comparativeyieldrefquadrats
'vegtransectiidref',
'seqnum',
'refyieldrank',
'quadratsize',
'quadratshape',
'clippedwtrefquadrat',
'compyldconvfactor',
'recwlupdated',
'recuseriidref',
'compyldrefquadiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: croptreedetails ---- Crop Tree Details

ACCEPT pedonid_list.
EXEC SQL SELECT

croptreedetails.croptreesummiidref/1 AS croptreesummiidref,
croptreedetails.seqnum AS seqnum,
croptreedetails.treenumber AS treenumber,
croptreedetails.plantiidref AS plantiidref,
croptreedetails.treediameterbreastheight AS treediameterbreastheight,
CODELABEL (croptreeprimarycat) AS croptreeprimarycat,
CODELABEL (croptreesecondarycat) AS croptreesecondarycat,
croptreedetails.cuttreeindicator AS cuttreeindicator,
croptreedetails.recwlupdated AS recwlupdated,
croptreedetails.recuseriidref/1 AS recuseriidref,
croptreedetails.croptreedetailsiid/1 AS croptreedetailsiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN croptreesummary ON croptreesummary.vegplotiidref=vegplot.vegplotiid
INNER JOIN croptreedetails ON croptreedetails.croptreesummiidref=croptreesummary.croptreesummaryiid;.

TEMPLATE croptreedetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin croptreedetails".
END SECTION.

SECTION HEADING
USING croptreedetails
'croptreesummiidref',
'seqnum',
'treenumber',
'plantiidref',
'treediameterbreastheight',
'croptreeprimarycat',
'croptreesecondarycat',
'cuttreeindicator',
'recwlupdated',
'recuseriidref',
'croptreedetailsiid'.

DATA
USING croptreedetails
croptreesummiidref,
seqnum,
treenumber,
plantiidref,
treediameterbreastheight,
croptreeprimarycat,
croptreesecondarycat,
cuttreeindicator,
recwlupdated,
recuseriidref,
croptreedetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin croptreedetails".
USING croptreedetails
'croptreesummiidref',
'seqnum',
'treenumber',
'plantiidref',
'treediameterbreastheight',
'croptreeprimarycat',
'croptreesecondarycat',
'cuttreeindicator',
'recwlupdated',
'recuseriidref',
'croptreedetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: croptreesubplotdetails ---- Crop Tree Subplot Details

ACCEPT pedonid_list.
EXEC SQL SELECT

croptreesubplotdetails.croptreesummiidref/1 AS croptreesummiidref,
croptreesubplotdetails.seqnum AS seqnum,
croptreesubplotdetails.subplotnumber AS subplotnumber,
croptreesubplotdetails.leavetreebasalarea AS leavetreebasalarea,
croptreesubplotdetails.cuttreebasalarea AS cuttreebasalarea,
croptreesubplotdetails.basalareasubplottotal AS basalareasubplottotal,
croptreesubplotdetails.recwlupdated AS recwlupdated,
croptreesubplotdetails.recuseriidref/1 AS recuseriidref,
croptreesubplotdetails.croptreesubplotdetailsiid/1 AS croptreesubplotdetailsiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN croptreesummary ON croptreesummary.vegplotiidref=vegplot.vegplotiid
INNER JOIN croptreesubplotdetails ON croptreesubplotdetails.croptreesummiidref=croptreesummary.croptreesummaryiid;.

TEMPLATE croptreesubplotdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin croptreesubplotdetails".
END SECTION.

SECTION HEADING
USING croptreesubplotdetails
'croptreesummiidref',
'seqnum',
'subplotnumber',
'leavetreebasalarea',
'cuttreebasalarea',
'basalareasubplottotal',
'recwlupdated',
'recuseriidref',
'croptreesubplotdetailsiid'.

DATA
USING croptreesubplotdetails
croptreesummiidref,
seqnum,
subplotnumber,
leavetreebasalarea,
cuttreebasalarea,
basalareasubplottotal,
recwlupdated,
recuseriidref,
croptreesubplotdetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin croptreesubplotdetails".
USING croptreesubplotdetails
'croptreesummiidref',
'seqnum',
'subplotnumber',
'leavetreebasalarea',
'cuttreebasalarea',
'basalareasubplottotal',
'recwlupdated',
'recuseriidref',
'croptreesubplotdetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: croptreesummary ---- Crop Tree Summary

ACCEPT pedonid_list.
EXEC SQL SELECT

croptreesummary.vegplotiidref/1 AS vegplotiidref,
croptreesummary.seqnum AS seqnum,
croptreesummary.treecounttotal AS treecounttotal,
croptreesummary.currenttreedensity AS currenttreedensity,
croptreesummary.currentbasalarea AS currentbasalarea,
croptreesummary.currentplotavedbh AS currentplotavedbh,
croptreesummary.cuttreebasalareaave AS cuttreebasalareaave,
croptreesummary.leavetreebasalareaave AS leavetreebasalareaave,
croptreesummary.cuttreecount AS cuttreecount,
croptreesummary.cuttreedensity AS cuttreedensity,
croptreesummary.cuttreeavedbh AS cuttreeavedbh,
croptreesummary.recwlupdated AS recwlupdated,
croptreesummary.recuseriidref/1 AS recuseriidref,
croptreesummary.croptreesummaryiid/1 AS croptreesummaryiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN croptreesummary ON croptreesummary.vegplotiidref=vegplot.vegplotiid;.

TEMPLATE croptreesummary WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin croptreesummary".
END SECTION.

SECTION HEADING
USING croptreesummary
'vegplotiidref',
'seqnum',
'treecounttotal',
'currenttreedensity',
'currentbasalarea',
'currentplotavedbh',
'cuttreebasalareaave',
'leavetreebasalareaave',
'cuttreecount',
'cuttreedensity',
'cuttreeavedbh',
'recwlupdated',
'recuseriidref',
'croptreesummaryiid'.

DATA
USING croptreesummary
vegplotiidref,
seqnum,
treecounttotal,
currenttreedensity,
currentbasalarea,
currentplotavedbh,
cuttreebasalareaave,
leavetreebasalareaave,
cuttreecount,
cuttreedensity,
cuttreeavedbh,
recwlupdated,
recuseriidref,
croptreesummaryiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin croptreesummary".
USING croptreesummary
'vegplotiidref',
'seqnum',
'treecounttotal',
'currenttreedensity',
'currentbasalarea',
'currentplotavedbh',
'cuttreebasalareaave',
'leavetreebasalareaave',
'cuttreecount',
'cuttreedensity',
'cuttreeavedbh',
'recwlupdated',
'recuseriidref',
'croptreesummaryiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: croptreetotals ---- Crop Tree Totals

ACCEPT pedonid_list.
EXEC SQL SELECT

croptreetotals.croptreesummiidref/1 AS croptreesummiidref,
croptreetotals.seqnum AS seqnum,
CODELABEL (croptreeprimarycat) AS croptreeprimarycat,
croptreetotals.categorytreecount AS categorytreecount,
croptreetotals.categorytreedensity AS categorytreedensity,
croptreetotals.categorydbhave AS categorydbhave,
croptreetotals.recwlupdated AS recwlupdated,
croptreetotals.recuseriidref/1 AS recuseriidref,
croptreetotals.croptreetotalsiid/1 AS croptreetotalsiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN croptreesummary ON croptreesummary.vegplotiidref=vegplot.vegplotiid
INNER JOIN croptreetotals ON croptreetotals.croptreesummiidref=croptreesummary.croptreesummaryiid;.

TEMPLATE croptreetotals WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin croptreetotals".
END SECTION.

SECTION HEADING
USING croptreetotals
'croptreesummiidref',
'seqnum',
'croptreeprimarycat',
'categorytreecount',
'categorytreedensity',
'categorydbhave',
'recwlupdated',
'recuseriidref',
'croptreetotalsiid'.

DATA
USING croptreetotals
croptreesummiidref,
seqnum,
croptreeprimarycat,
categorytreecount,
categorytreedensity,
categorydbhave,
recwlupdated,
recuseriidref,
croptreetotalsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin croptreetotals".
USING croptreetotals
'croptreesummiidref',
'seqnum',
'croptreeprimarycat',
'categorytreecount',
'categorytreedensity',
'categorydbhave',
'recwlupdated',
'recuseriidref',
'croptreetotalsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: daubenmirecancovclasssumm ---- Daubenmire Canopy Cover Class Summary

ACCEPT pedonid_list.
EXEC SQL SELECT

daubenmirecancovclasssumm.vegtransplantsummiidref/1 AS vegtransplantsummiidref,
daubenmirecancovclasssumm.seqnum AS seqnum,
CODELABEL (daubcancovclass) AS daubcancovclass,
daubenmirecancovclasssumm.cancovclassmidpoint AS cancovclassmidpoint,
daubenmirecancovclasssumm.cancovclasscount AS cancovclasscount,
daubenmirecancovclasssumm.cancovproduct AS cancovproduct,
daubenmirecancovclasssumm.recwlupdated AS recwlupdated,
daubenmirecancovclasssumm.recuseriidref/1 AS recuseriidref,
daubenmirecancovclasssumm.daubcancovclsummiid/1 AS daubcancovclsummiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN vegtransectplantsummary ON vegtransectplantsummary.plantiidref=plant.plantiid
INNER JOIN daubenmirecancovclasssumm ON daubenmirecancovclasssumm.vegtransplantsummiidref=vegtransectplantsummary.vegtransplantsummiid;.

TEMPLATE daubenmirecancovclasssumm WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin daubenmirecancovclasssumm".
END SECTION.

SECTION HEADING
USING daubenmirecancovclasssumm
'vegtransplantsummiidref',
'seqnum',
'daubcancovclass',
'cancovclassmidpoint',
'cancovclasscount',
'cancovproduct',
'recwlupdated',
'recuseriidref',
'daubcancovclsummiid'.

DATA
USING daubenmirecancovclasssumm
vegtransplantsummiidref,
seqnum,
daubcancovclass,
cancovclassmidpoint,
cancovclasscount,
cancovproduct,
recwlupdated,
recuseriidref,
daubcancovclsummiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin daubenmirecancovclasssumm".
USING daubenmirecancovclasssumm
'vegtransplantsummiidref',
'seqnum',
'daubcancovclass',
'cancovclassmidpoint',
'cancovclasscount',
'cancovproduct',
'recwlupdated',
'recuseriidref',
'daubcancovclsummiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: daubenmirecancovquaddetail ---- Daubenmire Canopy Cover Quad Details

ACCEPT pedonid_list.
EXEC SQL SELECT

daubenmirecancovquaddetail.daubcancovclsummiidref/1 AS daubcancovclsummiidref,
daubenmirecancovquaddetail.seqnum AS seqnum,
daubenmirecancovquaddetail.quadratnumber AS quadratnumber,
daubenmirecancovquaddetail.recwlupdated AS recwlupdated,
daubenmirecancovquaddetail.recuseriidref/1 AS recuseriidref,
daubenmirecancovquaddetail.daubcancovquaddetailiid/1 AS daubcancovquaddetailiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN vegtransectplantsummary ON vegtransectplantsummary.plantiidref=plant.plantiid
INNER JOIN daubenmirecancovclasssumm ON daubenmirecancovclasssumm.vegtransplantsummiidref=vegtransectplantsummary.vegtransplantsummiid
INNER JOIN daubenmirecancovquaddetail ON daubenmirecancovquaddetail.daubcancovclsummiidref=daubenmirecancovclasssumm.daubcancovclsummiid;.

TEMPLATE daubenmirecancovquaddetail WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin daubenmirecancovquaddetail".
END SECTION.

SECTION HEADING
USING daubenmirecancovquaddetail
'daubcancovclsummiidref',
'seqnum',
'quadratnumber',
'recwlupdated',
'recuseriidref',
'daubcancovquaddetailiid'.

DATA
USING daubenmirecancovquaddetail
daubcancovclsummiidref,
seqnum,
quadratnumber,
recwlupdated,
recuseriidref,
daubcancovquaddetailiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin daubenmirecancovquaddetail".
USING daubenmirecancovquaddetail
'daubcancovclsummiidref',
'seqnum',
'quadratnumber',
'recwlupdated',
'recuseriidref',
'daubcancovquaddetailiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: densityquadratdetails ---- Density Quadrat Details

ACCEPT pedonid_list.
EXEC SQL SELECT

densityquadratdetails.vegtransplantsummiidref/1 AS vegtransplantsummiidref,
densityquadratdetails.seqnum AS seqnum,
densityquadratdetails.quadratnumber AS quadratnumber,
densityquadratdetails.transectpointlocation AS transectpointlocation,
densityquadratdetails.maturecount AS maturecount,
densityquadratdetails.seedlingcount AS seedlingcount,
densityquadratdetails.recwlupdated AS recwlupdated,
densityquadratdetails.recuseriidref/1 AS recuseriidref,
densityquadratdetails.densityquaddetailsiid/1 AS densityquaddetailsiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN vegtransectplantsummary ON vegtransectplantsummary.plantiidref=plant.plantiid
INNER JOIN densityquadratdetails ON densityquadratdetails.vegtransplantsummiidref=vegtransectplantsummary.vegtransplantsummiid;.

TEMPLATE densityquadratdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin densityquadratdetails".
END SECTION.

SECTION HEADING
USING densityquadratdetails
'vegtransplantsummiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'maturecount',
'seedlingcount',
'recwlupdated',
'recuseriidref',
'densityquaddetailsiid'.

DATA
USING densityquadratdetails
vegtransplantsummiidref,
seqnum,
quadratnumber,
transectpointlocation,
maturecount,
seedlingcount,
recwlupdated,
recuseriidref,
densityquaddetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin densityquadratdetails".
USING densityquadratdetails
'vegtransplantsummiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'maturecount',
'seedlingcount',
'recwlupdated',
'recuseriidref',
'densityquaddetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: domaindetail ---- Domain Detail

ACCEPT pedonid_list.
EXEC SQL SELECT

domaindetail.domiidref/1 AS domiidref,
domaindetail.choseq AS choseq,
domaindetail.choid AS choid,
domaindetail.chodetxt AS chodetxt,
domaindetail.cholabtxt AS cholabtxt,
domaindetail.choaltetxt AS choaltetxt,
domaindetail.chodesc AS chodesc,
domaindetail.choobbool AS choobbool,
CODELABEL (pendact) AS pendact,
CODELABEL (pendstat) AS pendstat,
domaindetail.recwlupdated AS recwlupdated,
domaindetail.recuseriidref/1 AS recuseriidref,
domaindetail.domdetiid/1 AS domdetiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN domaingroup ON domaingroup.grpiidref,domgrpdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN domainmaster ON domainmaster.domgrpiidref=domaingroup.domgrpiid
INNER JOIN domaindetail ON domaindetail.domiidref=domainmaster.domiid;.

TEMPLATE domaindetail WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin domaindetail".
END SECTION.

SECTION HEADING
USING domaindetail
'domiidref',
'choseq',
'choid',
'chodetxt',
'cholabtxt',
'choaltetxt',
'chodesc',
'choobbool',
'pendact',
'pendstat',
'recwlupdated',
'recuseriidref',
'domdetiid'.

DATA
USING domaindetail
domiidref,
choseq,
choid,
chodetxt,
cholabtxt,
choaltetxt,
chodesc,
choobbool,
pendact,
pendstat,
recwlupdated,
recuseriidref,
domdetiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin domaindetail".
USING domaindetail
'domiidref',
'choseq',
'choid',
'chodetxt',
'cholabtxt',
'choaltetxt',
'chodesc',
'choobbool',
'pendact',
'pendstat',
'recwlupdated',
'recuseriidref',
'domdetiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: domaingroup ---- Domain Group

ACCEPT pedonid_list.
EXEC SQL SELECT

domaingroup.domgrpname AS domgrpname,
domaingroup.domgrpdesc AS domgrpdesc,
domaingroup.domgrpdbiidref AS domgrpdbiidref,
domaingroup.grpiidref AS grpiidref,
domaingroup.objwlupdated AS objwlupdated,
domaingroup.objuseriidref AS objuseriidref,
domaingroup.recwlupdated AS recwlupdated,
domaingroup.recuseriidref/1 AS recuseriidref,
domaingroup.domgrpiid/1 AS domgrpiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN domaingroup ON domaingroup.grpiidref,domgrpdbiidref=nasisgroup.grpiid,nasissiteiidref;.

TEMPLATE domaingroup WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin domaingroup".
END SECTION.

SECTION HEADING
USING domaingroup
'domgrpname',
'domgrpdesc',
'domgrpdbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'domgrpiid'.

DATA
USING domaingroup
domgrpname,
domgrpdesc,
domgrpdbiidref,
grpiidref,
objwlupdated,
objuseriidref,
recwlupdated,
recuseriidref,
domgrpiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin domaingroup".
USING domaingroup
'domgrpname',
'domgrpdesc',
'domgrpdbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'domgrpiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: domainhist ---- Domain History

ACCEPT pedonid_list.
EXEC SQL SELECT

domainhist.domiidref/1 AS domiidref,
domainhist.notedate AS notedate,
domainhist.notes AS notes,
domainhist.recwlupdated AS recwlupdated,
domainhist.recuseriidref/1 AS recuseriidref,
domainhist.domnoteiid/1 AS domnoteiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN domaingroup ON domaingroup.grpiidref,domgrpdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN domainmaster ON domainmaster.domgrpiidref=domaingroup.domgrpiid
INNER JOIN domainhist ON domainhist.domiidref=domainmaster.domiid;.

TEMPLATE domainhist WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin domainhist".
END SECTION.

SECTION HEADING
USING domainhist
'domiidref',
'notedate',
'notes',
'recwlupdated',
'recuseriidref',
'domnoteiid'.

DATA
USING domainhist
domiidref,
notedate,
notes,
recwlupdated,
recuseriidref,
domnoteiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin domainhist".
USING domainhist
'domiidref',
'notedate',
'notes',
'recwlupdated',
'recuseriidref',
'domnoteiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: domainmaster ---- Domain

ACCEPT pedonid_list.
EXEC SQL SELECT

domainmaster.domgrpiidref/1 AS domgrpiidref,
domainmaster.domnm AS domnm,
CODELABEL (domording) AS domording,
domainmaster.domordbool AS domordbool,
domainmaster.domdlabbool AS domdlabbool,
domainmaster.domcustbool AS domcustbool,
domainmaster.domdesc AS domdesc,
domainmaster.domainid AS domainid,
CODELABEL (pendact) AS pendact,
CODELABEL (pendstat) AS pendstat,
domainmaster.recwlupdated AS recwlupdated,
domainmaster.recuseriidref/1 AS recuseriidref,
domainmaster.domiid/1 AS domiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN domaingroup ON domaingroup.grpiidref,domgrpdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN domainmaster ON domainmaster.domgrpiidref=domaingroup.domgrpiid;.

TEMPLATE domainmaster WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin domainmaster".
END SECTION.

SECTION HEADING
USING domainmaster
'domgrpiidref',
'domnm',
'domording',
'domordbool',
'domdlabbool',
'domcustbool',
'domdesc',
'domainid',
'pendact',
'pendstat',
'recwlupdated',
'recuseriidref',
'domiid'.

DATA
USING domainmaster
domgrpiidref,
domnm,
domording,
domordbool,
domdlabbool,
domcustbool,
domdesc,
domainid,
pendact,
pendstat,
recwlupdated,
recuseriidref,
domiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin domainmaster".
USING domainmaster
'domgrpiidref',
'domnm',
'domording',
'domordbool',
'domdlabbool',
'domcustbool',
'domdesc',
'domainid',
'pendact',
'pendstat',
'recwlupdated',
'recuseriidref',
'domiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: domdethist ---- Domain Detail History

ACCEPT pedonid_list.
EXEC SQL SELECT

domdethist.domdetiidref/1 AS domdetiidref,
domdethist.notedate AS notedate,
domdethist.notes AS notes,
domdethist.recwlupdated AS recwlupdated,
domdethist.recuseriidref/1 AS recuseriidref,
domdethist.domdetnoteiid/1 AS domdetnoteiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN domaingroup ON domaingroup.grpiidref,domgrpdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN domainmaster ON domainmaster.domgrpiidref=domaingroup.domgrpiid
INNER JOIN domaindetail ON domaindetail.domiidref=domainmaster.domiid
INNER JOIN domdethist ON domdethist.domdetiidref=domaindetail.domdetiid;.

TEMPLATE domdethist WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin domdethist".
END SECTION.

SECTION HEADING
USING domdethist
'domdetiidref',
'notedate',
'notes',
'recwlupdated',
'recuseriidref',
'domdetnoteiid'.

DATA
USING domdethist
domdetiidref,
notedate,
notes,
recwlupdated,
recuseriidref,
domdetnoteiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin domdethist".
USING domdethist
'domdetiidref',
'notedate',
'notes',
'recwlupdated',
'recuseriidref',
'domdetnoteiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: dwrquadratdetails ---- Dry Weight Rank Quadrat Details

ACCEPT pedonid_list.
EXEC SQL SELECT

dwrquadratdetails.vegtransplantsummiidref/1 AS vegtransplantsummiidref,
dwrquadratdetails.seqnum AS seqnum,
dwrquadratdetails.quadratnumber AS quadratnumber,
dwrquadratdetails.transectpointlocation AS transectpointlocation,
dwrquadratdetails.dwrone AS dwrone,
dwrquadratdetails.dwrtwo AS dwrtwo,
dwrquadratdetails.dwrthree AS dwrthree,
dwrquadratdetails.recwlupdated AS recwlupdated,
dwrquadratdetails.recuseriidref/1 AS recuseriidref,
dwrquadratdetails.dwrquaddetailsiid/1 AS dwrquaddetailsiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN vegtransectplantsummary ON vegtransectplantsummary.plantiidref=plant.plantiid
INNER JOIN dwrquadratdetails ON dwrquadratdetails.vegtransplantsummiidref=vegtransectplantsummary.vegtransplantsummiid;.

TEMPLATE dwrquadratdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin dwrquadratdetails".
END SECTION.

SECTION HEADING
USING dwrquadratdetails
'vegtransplantsummiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'dwrone',
'dwrtwo',
'dwrthree',
'recwlupdated',
'recuseriidref',
'dwrquaddetailsiid'.

DATA
USING dwrquadratdetails
vegtransplantsummiidref,
seqnum,
quadratnumber,
transectpointlocation,
dwrone,
dwrtwo,
dwrthree,
recwlupdated,
recuseriidref,
dwrquaddetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin dwrquadratdetails".
USING dwrquadratdetails
'vegtransplantsummiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'dwrone',
'dwrtwo',
'dwrthree',
'recwlupdated',
'recuseriidref',
'dwrquaddetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: ecologicalsite ---- Ecological Site

ACCEPT pedonid_list.
EXEC SQL SELECT

ecologicalsite.ecositeid AS ecositeid,
ecologicalsite.ecositenm AS ecositenm,
ecologicalsite.ecositestatus AS ecositestatus,
ecologicalsite.ecositepublished AS ecositepublished,
CODELABEL (ecositetype) AS ecositetype,
CODELABEL (ecositemlra) AS ecositemlra,
CODELABEL (ecositelru) AS ecositelru,
ecologicalsite.ecositenumber AS ecositenumber,
CODELABEL (ecositestate) AS ecositestate,
ecologicalsite.ecositepnm AS ecositepnm,
ecologicalsite.ecositesnm AS ecositesnm,
ecologicalsite.ecositetnm AS ecositetnm,
ecologicalsite.ecositeidnew AS ecositeidnew,
CODELABEL (ecositelrrnew) AS ecositelrrnew,
CODELABEL (ecositemlranew) AS ecositemlranew,
CODELABEL (ecositelrunew) AS ecositelrunew,
ecologicalsite.ecositenumbernew AS ecositenumbernew,
ecologicalsite.ecositenasisiid AS ecositenasisiid,
ecologicalsite.obterm AS obterm,
ecologicalsite.ecositedbiidref AS ecositedbiidref,
ecologicalsite.grpiidref AS grpiidref,
ecologicalsite.objwlupdated AS objwlupdated,
ecologicalsite.objuseriidref AS objuseriidref,
ecologicalsite.recwlupdated AS recwlupdated,
ecologicalsite.recuseriidref/1 AS recuseriidref,
ecologicalsite.ecositeiid/1 AS ecositeiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN ecologicalsite ON ecologicalsite.grpiidref,ecositedbiidref=nasisgroup.grpiid,nasissiteiidref;.

TEMPLATE ecologicalsite WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin ecologicalsite".
END SECTION.

SECTION HEADING
USING ecologicalsite
'ecositeid',
'ecositenm',
'ecositestatus',
'ecositepublished',
'ecositetype',
'ecositemlra',
'ecositelru',
'ecositenumber',
'ecositestate',
'ecositepnm',
'ecositesnm',
'ecositetnm',
'ecositeidnew',
'ecositelrrnew',
'ecositemlranew',
'ecositelrunew',
'ecositenumbernew',
'ecositenasisiid',
'obterm',
'ecositedbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'ecositeiid'.

DATA
USING ecologicalsite
ecositeid,
ecositenm,
ecositestatus,
ecositepublished,
ecositetype,
ecositemlra,
ecositelru,
ecositenumber,
ecositestate,
ecositepnm,
ecositesnm,
ecositetnm,
ecositeidnew,
ecositelrrnew,
ecositemlranew,
ecositelrunew,
ecositenumbernew,
ecositenasisiid,
obterm,
ecositedbiidref,
grpiidref,
objwlupdated,
objuseriidref,
recwlupdated,
recuseriidref,
ecositeiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin ecologicalsite".
USING ecologicalsite
'ecositeid',
'ecositenm',
'ecositestatus',
'ecositepublished',
'ecositetype',
'ecositemlra',
'ecositelru',
'ecositenumber',
'ecositestate',
'ecositepnm',
'ecositesnm',
'ecositetnm',
'ecositeidnew',
'ecositelrrnew',
'ecositemlranew',
'ecositelrunew',
'ecositenumbernew',
'ecositenasisiid',
'obterm',
'ecositedbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'ecositeiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: frequencyquadratdetails ---- Frequency Quadrat Details

ACCEPT pedonid_list.
EXEC SQL SELECT

frequencyquadratdetails.vegtransplantsummiidref/1 AS vegtransplantsummiidref,
frequencyquadratdetails.seqnum AS seqnum,
frequencyquadratdetails.quadratnumber AS quadratnumber,
frequencyquadratdetails.transectpointlocation AS transectpointlocation,
frequencyquadratdetails.speciespresentindicator AS speciespresentindicator,
frequencyquadratdetails.recwlupdated AS recwlupdated,
frequencyquadratdetails.recuseriidref/1 AS recuseriidref,
frequencyquadratdetails.freqquaddetailsiid/1 AS freqquaddetailsiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN vegtransectplantsummary ON vegtransectplantsummary.plantiidref=plant.plantiid
INNER JOIN frequencyquadratdetails ON frequencyquadratdetails.vegtransplantsummiidref=vegtransectplantsummary.vegtransplantsummiid;.

TEMPLATE frequencyquadratdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin frequencyquadratdetails".
END SECTION.

SECTION HEADING
USING frequencyquadratdetails
'vegtransplantsummiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'speciespresentindicator',
'recwlupdated',
'recuseriidref',
'freqquaddetailsiid'.

DATA
USING frequencyquadratdetails
vegtransplantsummiidref,
seqnum,
quadratnumber,
transectpointlocation,
speciespresentindicator,
recwlupdated,
recuseriidref,
freqquaddetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin frequencyquadratdetails".
USING frequencyquadratdetails
'vegtransplantsummiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'speciespresentindicator',
'recwlupdated',
'recuseriidref',
'freqquaddetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: groundcovdetails ---- Ground Cover Details

ACCEPT pedonid_list.
EXEC SQL SELECT

groundcovdetails.transectgrcoviidref/1 AS transectgrcoviidref,
groundcovdetails.seqnum AS seqnum,
groundcovdetails.transectpointlocation AS transectpointlocation,
groundcovdetails.quadratnumber AS quadratnumber,
groundcovdetails.quadratcoverpct AS quadratcoverpct,
groundcovdetails.recwlupdated AS recwlupdated,
groundcovdetails.recuseriidref/1 AS recuseriidref,
groundcovdetails.groundcovdetailsiid/1 AS groundcovdetailsiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN transectgroundcover ON transectgroundcover.vegtransectiidref=vegtransect.vegtransectiid
INNER JOIN groundcovdetails ON groundcovdetails.transectgrcoviidref=transectgroundcover.transectgroundcoveriid;.

TEMPLATE groundcovdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin groundcovdetails".
END SECTION.

SECTION HEADING
USING groundcovdetails
'transectgrcoviidref',
'seqnum',
'transectpointlocation',
'quadratnumber',
'quadratcoverpct',
'recwlupdated',
'recuseriidref',
'groundcovdetailsiid'.

DATA
USING groundcovdetails
transectgrcoviidref,
seqnum,
transectpointlocation,
quadratnumber,
quadratcoverpct,
recwlupdated,
recuseriidref,
groundcovdetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin groundcovdetails".
USING groundcovdetails
'transectgrcoviidref',
'seqnum',
'transectpointlocation',
'quadratnumber',
'quadratcoverpct',
'recwlupdated',
'recuseriidref',
'groundcovdetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: groundsurfcovdetails ---- Ground Surface Cover Details

ACCEPT pedonid_list.
EXEC SQL SELECT

groundsurfcovdetails.transectgrsurfcoviidref/1 AS transectgrsurfcoviidref,
groundsurfcovdetails.seqnum AS seqnum,
groundsurfcovdetails.transectpointlocation AS transectpointlocation,
groundsurfcovdetails.quadratnumber AS quadratnumber,
groundsurfcovdetails.quadratcoverpct AS quadratcoverpct,
groundsurfcovdetails.recwlupdated AS recwlupdated,
groundsurfcovdetails.recuseriidref/1 AS recuseriidref,
groundsurfcovdetails.groundsurfcovdetailsiid/1 AS groundsurfcovdetailsiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN transectgroundsurfcover ON transectgroundsurfcover.vegtransectiidref=vegtransect.vegtransectiid
INNER JOIN groundsurfcovdetails ON groundsurfcovdetails.transectgrsurfcoviidref=transectgroundsurfcover.transectgroundsurfcoveriid;.

TEMPLATE groundsurfcovdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin groundsurfcovdetails".
END SECTION.

SECTION HEADING
USING groundsurfcovdetails
'transectgrsurfcoviidref',
'seqnum',
'transectpointlocation',
'quadratnumber',
'quadratcoverpct',
'recwlupdated',
'recuseriidref',
'groundsurfcovdetailsiid'.

DATA
USING groundsurfcovdetails
transectgrsurfcoviidref,
seqnum,
transectpointlocation,
quadratnumber,
quadratcoverpct,
recwlupdated,
recuseriidref,
groundsurfcovdetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin groundsurfcovdetails".
USING groundsurfcovdetails
'transectgrsurfcoviidref',
'seqnum',
'transectpointlocation',
'quadratnumber',
'quadratcoverpct',
'recwlupdated',
'recuseriidref',
'groundsurfcovdetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: nasisgroup ---- NASIS Group

ACCEPT pedonid_list.
EXEC SQL SELECT

nasisgroup.nasissiteiidref/1 AS nasissiteiidref,
nasisgroup.grpname AS grpname,
nasisgroup.grpdesc AS grpdesc,
nasisgroup.grpcontact AS grpcontact,
nasisgroup.grpphone AS grpphone,
nasisgroup.recwlupdated AS recwlupdated,
nasisgroup.grpiid/1 AS grpiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid;.

TEMPLATE nasisgroup WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin nasisgroup".
END SECTION.

SECTION HEADING
USING nasisgroup
'nasissiteiidref',
'grpname',
'grpdesc',
'grpcontact',
'grpphone',
'recwlupdated',
'grpiid'.

DATA
USING nasisgroup
nasissiteiidref,
grpname,
grpdesc,
grpcontact,
grpphone,
recwlupdated,
grpiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin nasisgroup".
USING nasisgroup
'nasissiteiidref',
'grpname',
'grpdesc',
'grpcontact',
'grpphone',
'recwlupdated',
'grpiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: nasisgroupmember ---- NASIS Group Member

ACCEPT pedonid_list.
EXEC SQL SELECT

nasisgroupmember.grpiidref/1 AS grpiidref,
nasisgroupmember.useriidref AS useriidref,
nasisgroupmember.recwlupdated AS recwlupdated,
nasisgroupmember.grpmemiid/1 AS grpmemiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN nasisgroupmember ON nasisgroupmember.grpiidref=nasisgroup.grpiid;.

TEMPLATE nasisgroupmember WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin nasisgroupmember".
END SECTION.

SECTION HEADING
USING nasisgroupmember
'grpiidref',
'useriidref',
'recwlupdated',
'grpmemiid'.

DATA
USING nasisgroupmember
grpiidref,
useriidref,
recwlupdated,
grpmemiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin nasisgroupmember".
USING nasisgroupmember
'grpiidref',
'useriidref',
'recwlupdated',
'grpmemiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: nasissite ---- NASIS Site

ACCEPT pedonid_list.
EXEC SQL SELECT

nasissite.nasissitename AS nasissitename,
nasissite.nasissitedesc AS nasissitedesc,
CODELABEL (nasissitestate) AS nasissitestate,
nasissite.nasissitecounty AS nasissitecounty,
nasissite.nasissitecity AS nasissitecity,
CODELABEL (nasissiteofficetype) AS nasissiteofficetype,
nasissite.nasissitecontact AS nasissitecontact,
nasissite.nasissitephone AS nasissitephone,
nasissite.objwlupdated AS objwlupdated,
nasissite.recwlupdated AS recwlupdated,
nasissite.nasissiteiid/1 AS nasissiteiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
TEMPLATE nasissite WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin nasissite".
END SECTION.

SECTION HEADING
USING nasissite
'nasissitename',
'nasissitedesc',
'nasissitestate',
'nasissitecounty',
'nasissitecity',
'nasissiteofficetype',
'nasissitecontact',
'nasissitephone',
'objwlupdated',
'recwlupdated',
'nasissiteiid'.

DATA
USING nasissite
nasissitename,
nasissitedesc,
nasissitestate,
nasissitecounty,
nasissitecity,
nasissiteofficetype,
nasissitecontact,
nasissitephone,
objwlupdated,
recwlupdated,
nasissiteiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin nasissite".
USING nasissite
'nasissitename',
'nasissitedesc',
'nasissitestate',
'nasissitecounty',
'nasissitecity',
'nasissiteofficetype',
'nasissitecontact',
'nasissitephone',
'objwlupdated',
'recwlupdated',
'nasissiteiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: nasissiteadmin ---- NASIS Site Administrator

ACCEPT pedonid_list.
EXEC SQL SELECT

nasissiteadmin.nasissiteiidref/1 AS nasissiteiidref,
nasissiteadmin.useriidref AS useriidref,
nasissiteadmin.recwlupdated AS recwlupdated,
nasissiteadmin.nasissiteadminiid/1 AS nasissiteadminiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasissiteadmin ON nasissiteadmin.nasissiteiidref=nasissite.nasissiteiid;.

TEMPLATE nasissiteadmin WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin nasissiteadmin".
END SECTION.

SECTION HEADING
USING nasissiteadmin
'nasissiteiidref',
'useriidref',
'recwlupdated',
'nasissiteadminiid'.

DATA
USING nasissiteadmin
nasissiteiidref,
useriidref,
recwlupdated,
nasissiteadminiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin nasissiteadmin".
USING nasissiteadmin
'nasissiteiidref',
'useriidref',
'recwlupdated',
'nasissiteadminiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: nestedfreqquadratdetails ---- Nested Frequency Quadrat Details

ACCEPT pedonid_list.
EXEC SQL SELECT

nestedfreqquadratdetails.vegtransplantsummiidref/1 AS vegtransplantsummiidref,
nestedfreqquadratdetails.seqnum AS seqnum,
nestedfreqquadratdetails.quadratnumber AS quadratnumber,
nestedfreqquadratdetails.transectpointlocation AS transectpointlocation,
nestedfreqquadratdetails.smallestquadratin AS smallestquadratin,
nestedfreqquadratdetails.recwlupdated AS recwlupdated,
nestedfreqquadratdetails.recuseriidref/1 AS recuseriidref,
nestedfreqquadratdetails.nestedfreqquaddetailsiid/1 AS nestedfreqquaddetailsiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN vegtransectplantsummary ON vegtransectplantsummary.plantiidref=plant.plantiid
INNER JOIN nestedfreqquadratdetails ON nestedfreqquadratdetails.vegtransplantsummiidref=vegtransectplantsummary.vegtransplantsummiid;.

TEMPLATE nestedfreqquadratdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin nestedfreqquadratdetails".
END SECTION.

SECTION HEADING
USING nestedfreqquadratdetails
'vegtransplantsummiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'smallestquadratin',
'recwlupdated',
'recuseriidref',
'nestedfreqquaddetailsiid'.

DATA
USING nestedfreqquadratdetails
vegtransplantsummiidref,
seqnum,
quadratnumber,
transectpointlocation,
smallestquadratin,
recwlupdated,
recuseriidref,
nestedfreqquaddetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin nestedfreqquadratdetails".
USING nestedfreqquadratdetails
'vegtransplantsummiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'smallestquadratin',
'recwlupdated',
'recuseriidref',
'nestedfreqquaddetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: nestedfrequencysummary ---- Nested Frequency Summary

ACCEPT pedonid_list.
EXEC SQL SELECT

nestedfrequencysummary.vegtransplantsummiidref/1 AS vegtransplantsummiidref,
nestedfrequencysummary.seqnum AS seqnum,
nestedfrequencysummary.subquadratnumber AS subquadratnumber,
nestedfrequencysummary.subquadratsize AS subquadratsize,
nestedfrequencysummary.subquadrathitcount AS subquadrathitcount,
nestedfrequencysummary.subquadratspeciesfreq AS subquadratspeciesfreq,
nestedfrequencysummary.recwlupdated AS recwlupdated,
nestedfrequencysummary.recuseriidref/1 AS recuseriidref,
nestedfrequencysummary.nestedfreqsummaryiid/1 AS nestedfreqsummaryiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN vegtransectplantsummary ON vegtransectplantsummary.plantiidref=plant.plantiid
INNER JOIN nestedfrequencysummary ON nestedfrequencysummary.vegtransplantsummiidref=vegtransectplantsummary.vegtransplantsummiid;.

TEMPLATE nestedfrequencysummary WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin nestedfrequencysummary".
END SECTION.

SECTION HEADING
USING nestedfrequencysummary
'vegtransplantsummiidref',
'seqnum',
'subquadratnumber',
'subquadratsize',
'subquadrathitcount',
'subquadratspeciesfreq',
'recwlupdated',
'recuseriidref',
'nestedfreqsummaryiid'.

DATA
USING nestedfrequencysummary
vegtransplantsummiidref,
seqnum,
subquadratnumber,
subquadratsize,
subquadrathitcount,
subquadratspeciesfreq,
recwlupdated,
recuseriidref,
nestedfreqsummaryiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin nestedfrequencysummary".
USING nestedfrequencysummary
'vegtransplantsummiidref',
'seqnum',
'subquadratnumber',
'subquadratsize',
'subquadrathitcount',
'subquadratspeciesfreq',
'recwlupdated',
'recuseriidref',
'nestedfreqsummaryiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: othvegclass ---- Other Vegetative Classification

ACCEPT pedonid_list.
EXEC SQL SELECT

othvegclass.ovegcltypiidref/1 AS ovegcltypiidref,
othvegclass.seqnum AS seqnum,
othvegclass.ovegclid AS ovegclid,
othvegclass.ovegclname AS ovegclname,
othvegclass.ovegcldesc AS ovegcldesc,
othvegclass.obterm AS obterm,
othvegclass.recwlupdated AS recwlupdated,
othvegclass.recuseriidref/1 AS recuseriidref,
othvegclass.ovegcliid/1 AS ovegcliid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN othvegclasstype ON othvegclasstype.grpiidref,ovegcltypdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN othvegclass ON othvegclass.ovegcltypiidref=othvegclasstype.ovegcltypiid;.

TEMPLATE othvegclass WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin othvegclass".
END SECTION.

SECTION HEADING
USING othvegclass
'ovegcltypiidref',
'seqnum',
'ovegclid',
'ovegclname',
'ovegcldesc',
'obterm',
'recwlupdated',
'recuseriidref',
'ovegcliid'.

DATA
USING othvegclass
ovegcltypiidref,
seqnum,
ovegclid,
ovegclname,
ovegcldesc,
obterm,
recwlupdated,
recuseriidref,
ovegcliid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin othvegclass".
USING othvegclass
'ovegcltypiidref',
'seqnum',
'ovegclid',
'ovegclname',
'ovegcldesc',
'obterm',
'recwlupdated',
'recuseriidref',
'ovegcliid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: othvegclasstype ---- Other Vegetative Classification Type

ACCEPT pedonid_list.
EXEC SQL SELECT

othvegclasstype.ovegcltypname AS ovegcltypname,
othvegclasstype.ovegcltypref AS ovegcltypref,
othvegclasstype.ovegcltypdesc AS ovegcltypdesc,
othvegclasstype.ovegcltypdbiidref AS ovegcltypdbiidref,
othvegclasstype.grpiidref AS grpiidref,
othvegclasstype.objwlupdated AS objwlupdated,
othvegclasstype.objuseriidref AS objuseriidref,
othvegclasstype.recwlupdated AS recwlupdated,
othvegclasstype.recuseriidref/1 AS recuseriidref,
othvegclasstype.ovegcltypiid/1 AS ovegcltypiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN othvegclasstype ON othvegclasstype.grpiidref,ovegcltypdbiidref=nasisgroup.grpiid,nasissiteiidref;.

TEMPLATE othvegclasstype WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin othvegclasstype".
END SECTION.

SECTION HEADING
USING othvegclasstype
'ovegcltypname',
'ovegcltypref',
'ovegcltypdesc',
'ovegcltypdbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'ovegcltypiid'.

DATA
USING othvegclasstype
ovegcltypname,
ovegcltypref,
ovegcltypdesc,
ovegcltypdbiidref,
grpiidref,
objwlupdated,
objuseriidref,
recwlupdated,
recuseriidref,
ovegcltypiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin othvegclasstype".
USING othvegclasstype
'ovegcltypname',
'ovegcltypref',
'ovegcltypdesc',
'ovegcltypdbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'ovegcltypiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: paoccurrence ---- Plant Area Occurrence

ACCEPT pedonid_list.
EXEC SQL SELECT

paoccurrence.plantiidref/1 AS plantiidref,
paoccurrence.seqnum AS seqnum,
paoccurrence.areaiidref AS areaiidref,
paoccurrence.plantareacomnm AS plantareacomnm,
paoccurrence.recwlupdated AS recwlupdated,
paoccurrence.recuseriidref/1 AS recuseriidref,
paoccurrence.plantareaociid/1 AS plantareaociid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN areatype ON areatype.grpiidref,atdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN area ON area.areatypeiidref=areatype.areatypeiid
INNER JOIN paoccurrence ON paoccurrence.areaiidref=area.areaiid;.

TEMPLATE paoccurrence WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin paoccurrence".
END SECTION.

SECTION HEADING
USING paoccurrence
'plantiidref',
'seqnum',
'areaiidref',
'plantareacomnm',
'recwlupdated',
'recuseriidref',
'plantareaociid'.

DATA
USING paoccurrence
plantiidref,
seqnum,
areaiidref,
plantareacomnm,
recwlupdated,
recuseriidref,
plantareaociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin paoccurrence".
USING paoccurrence
'plantiidref',
'seqnum',
'areaiidref',
'plantareacomnm',
'recwlupdated',
'recuseriidref',
'plantareaociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: pediagfeatrefecmdoc ---- Pedon Diagnostic Features Reference ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

pediagfeatrefecmdoc.pediagfeatiidref/1 AS pediagfeatiidref,
pediagfeatrefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
pediagfeatrefecmdoc.ecmdocname AS ecmdocname,
pediagfeatrefecmdoc.ecmdockeyurl AS ecmdockeyurl,
pediagfeatrefecmdoc.recwlupdated AS recwlupdated,
pediagfeatrefecmdoc.recuseriidref/1 AS recuseriidref,
pediagfeatrefecmdoc.pediagfeatrefecmdociid/1 AS pediagfeatrefecmdociid

FROM pedon
INNER JOIN pediagfeatures ON pediagfeatures.peiidref=pedon.peiid AND peiid IN ($pedonid_list)
INNER JOIN pediagfeatrefecmdoc ON pediagfeatrefecmdoc.pediagfeatiidref=pediagfeatures.pediagfeatiid;.

TEMPLATE pediagfeatrefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin pediagfeatrefecmdoc".
END SECTION.

SECTION HEADING
USING pediagfeatrefecmdoc
'pediagfeatiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'pediagfeatrefecmdociid'.

DATA
USING pediagfeatrefecmdoc
pediagfeatiidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
pediagfeatrefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin pediagfeatrefecmdoc".
USING pediagfeatrefecmdoc
'pediagfeatiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'pediagfeatrefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: pedonrefecmdoc ---- Pedon Reference ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

pedonrefecmdoc.peiidref/1 AS peiidref,
pedonrefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
pedonrefecmdoc.ecmdocname AS ecmdocname,
pedonrefecmdoc.ecmdockeyurl AS ecmdockeyurl,
pedonrefecmdoc.recwlupdated AS recwlupdated,
pedonrefecmdoc.recuseriidref/1 AS recuseriidref,
pedonrefecmdoc.pedonrefecmdociid/1 AS pedonrefecmdociid

FROM pedon
INNER JOIN pedonrefecmdoc ON pedonrefecmdoc.peiidref=pedon.peiid AND peiid IN ($pedonid_list);.

TEMPLATE pedonrefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin pedonrefecmdoc".
END SECTION.

SECTION HEADING
USING pedonrefecmdoc
'peiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'pedonrefecmdociid'.

DATA
USING pedonrefecmdoc
peiidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
pedonrefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin pedonrefecmdoc".
USING pedonrefecmdoc
'peiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'pedonrefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: peinfilcornelldata ---- Pedon Infiltration Cornell Infiltrometer Data

ACCEPT pedonid_list.
EXEC SQL SELECT

peinfilcornelldata.peinfilcornelliidref/1 AS peinfilcornelliidref,
peinfilcornelldata.infiltrationrunnum AS infiltrationrunnum,
peinfilcornelldata.deltatime AS deltatime,
peinfilcornelldata.volwatercollected AS volwatercollected,
peinfilcornelldata.infiltrationmeasured AS infiltrationmeasured,
peinfilcornelldata.incrrunoffrate AS incrrunoffrate,
peinfilcornelldata.incrinfiltrationrate AS incrinfiltrationrate,
peinfilcornelldata.steadystateflag AS steadystateflag,
peinfilcornelldata.recwlupdated AS recwlupdated,
peinfilcornelldata.recuseriidref/1 AS recuseriidref,
peinfilcornelldata.peinfilcornelldataiid/1 AS peinfilcornelldataiid

FROM pedon
INNER JOIN peinfiltrationsummary ON peinfiltrationsummary.peiidref=pedon.peiid AND peiid IN ($pedonid_list)
INNER JOIN peinfilncornell ON peinfilncornell.peinfilsumiidref=peinfiltrationsummary.pedoninfilsumiid
INNER JOIN peinfilcornelldata ON peinfilcornelldata.peinfilcornelliidref=peinfilncornell.peinfilsumiid;.

TEMPLATE peinfilcornelldata WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin peinfilcornelldata".
END SECTION.

SECTION HEADING
USING peinfilcornelldata
'peinfilcornelliidref',
'infiltrationrunnum',
'deltatime',
'volwatercollected',
'infiltrationmeasured',
'incrrunoffrate',
'incrinfiltrationrate',
'steadystateflag',
'recwlupdated',
'recuseriidref',
'peinfilcornelldataiid'.

DATA
USING peinfilcornelldata
peinfilcornelliidref,
infiltrationrunnum,
deltatime,
volwatercollected,
infiltrationmeasured,
incrrunoffrate,
incrinfiltrationrate,
steadystateflag,
recwlupdated,
recuseriidref,
peinfilcornelldataiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin peinfilcornelldata".
USING peinfilcornelldata
'peinfilcornelliidref',
'infiltrationrunnum',
'deltatime',
'volwatercollected',
'infiltrationmeasured',
'incrrunoffrate',
'incrinfiltrationrate',
'steadystateflag',
'recwlupdated',
'recuseriidref',
'peinfilcornelldataiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: peinfilncornell ---- Pedon Infiltration Cornell Infiltrometer

ACCEPT pedonid_list.
EXEC SQL SELECT

peinfilncornell.peinfilsumiidref/1 AS peinfilsumiidref,
peinfilncornell.testdate AS testdate,
peinfilncornell.repnum AS repnum,
peinfilncornell.notes AS notes,
peinfilncornell.ringinsertiondepth AS ringinsertiondepth,
peinfilncornell.ringradius AS ringradius,
peinfilncornell.rainfallheight AS rainfallheight,
peinfilncornell.beginwaterheight AS beginwaterheight,
peinfilncornell.endwaterheight AS endwaterheight,
peinfilncornell.calibratedsprinklerate AS calibratedsprinklerate,
peinfilncornell.timetorunoff AS timetorunoff,
peinfilncornell.totaltime AS totaltime,
CODELABEL (soiltypeconversion) AS soiltypeconversion,
peinfilncornell.representativerainfallrate AS representativerainfallrate,
peinfilncornell.infiltrationrate AS infiltrationrate,
peinfilncornell.runoffrate AS runoffrate,
peinfilncornell.sorptivity AS sorptivity,
peinfilncornell.fieldsaturatedinfiltrability AS fieldsaturatedinfiltrability,
peinfilncornell.recwlupdated AS recwlupdated,
peinfilncornell.recuseriidref/1 AS recuseriidref,
peinfilncornell.peinfilcornelliid/1 AS peinfilcornelliid

FROM pedon
INNER JOIN peinfiltrationsummary ON peinfiltrationsummary.peiidref=pedon.peiid AND peiid IN ($pedonid_list)
INNER JOIN peinfilncornell ON peinfilncornell.peinfilsumiidref=peinfiltrationsummary.pedoninfilsumiid;.

TEMPLATE peinfilncornell WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin peinfilncornell".
END SECTION.

SECTION HEADING
USING peinfilncornell
'peinfilsumiidref',
'testdate',
'repnum',
'notes',
'ringinsertiondepth',
'ringradius',
'rainfallheight',
'beginwaterheight',
'endwaterheight',
'calibratedsprinklerate',
'timetorunoff',
'totaltime',
'soiltypeconversion',
'representativerainfallrate',
'infiltrationrate',
'runoffrate',
'sorptivity',
'fieldsaturatedinfiltrability',
'recwlupdated',
'recuseriidref',
'peinfilcornelliid'.

DATA
USING peinfilncornell
peinfilsumiidref,
testdate,
repnum,
notes,
ringinsertiondepth,
ringradius,
rainfallheight,
beginwaterheight,
endwaterheight,
calibratedsprinklerate,
timetorunoff,
totaltime,
soiltypeconversion,
representativerainfallrate,
infiltrationrate,
runoffrate,
sorptivity,
fieldsaturatedinfiltrability,
recwlupdated,
recuseriidref,
peinfilcornelliid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin peinfilncornell".
USING peinfilncornell
'peinfilsumiidref',
'testdate',
'repnum',
'notes',
'ringinsertiondepth',
'ringradius',
'rainfallheight',
'beginwaterheight',
'endwaterheight',
'calibratedsprinklerate',
'timetorunoff',
'totaltime',
'soiltypeconversion',
'representativerainfallrate',
'infiltrationrate',
'runoffrate',
'sorptivity',
'fieldsaturatedinfiltrability',
'recwlupdated',
'recuseriidref',
'peinfilcornelliid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: perestrictionsrefecmdoc ---- Pedon Restrictions Reference ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

perestrictionsrefecmdoc.perestrictionsiidref/1 AS perestrictionsiidref,
perestrictionsrefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
perestrictionsrefecmdoc.ecmdocname AS ecmdocname,
perestrictionsrefecmdoc.ecmdockeyurl AS ecmdockeyurl,
perestrictionsrefecmdoc.recwlupdated AS recwlupdated,
perestrictionsrefecmdoc.recuseriidref/1 AS recuseriidref,
perestrictionsrefecmdoc.perestrictsrefecmdociid/1 AS perestrictsrefecmdociid

FROM pedon
INNER JOIN perestrictions ON perestrictions.peiidref=pedon.peiid AND peiid IN ($pedonid_list)
INNER JOIN perestrictionsrefecmdoc ON perestrictionsrefecmdoc.perestrictionsiidref=perestrictions.perestrictiid;.

TEMPLATE perestrictionsrefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin perestrictionsrefecmdoc".
END SECTION.

SECTION HEADING
USING perestrictionsrefecmdoc
'perestrictionsiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'perestrictsrefecmdociid'.

DATA
USING perestrictionsrefecmdoc
perestrictionsiidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
perestrictsrefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin perestrictionsrefecmdoc".
USING perestrictionsrefecmdoc
'perestrictionsiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'perestrictsrefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: phhuartrefecmdoc ---- Pedon Horizon Human Artifacts Reference ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

phhuartrefecmdoc.phhumartiidref/1 AS phhumartiidref,
phhuartrefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
phhuartrefecmdoc.ecmdocname AS ecmdocname,
phhuartrefecmdoc.ecmdockeyurl AS ecmdockeyurl,
phhuartrefecmdoc.recwlupdated AS recwlupdated,
phhuartrefecmdoc.recuseriidref/1 AS recuseriidref,
phhuartrefecmdoc.phhuartrefecmdociid/1 AS phhuartrefecmdociid

FROM pedon
INNER JOIN phorizon ON phorizon.peiidref=pedon.peiid AND peiid IN ($pedonid_list)
INNER JOIN phhuarts ON phhuarts.phiidref=phorizon.phiid
INNER JOIN phhuartrefecmdoc ON phhuartrefecmdoc.phhumartiidref=phhuarts.phhuartiid;.

TEMPLATE phhuartrefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin phhuartrefecmdoc".
END SECTION.

SECTION HEADING
USING phhuartrefecmdoc
'phhumartiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'phhuartrefecmdociid'.

DATA
USING phhuartrefecmdoc
phhumartiidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
phhuartrefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin phhuartrefecmdoc".
USING phhuartrefecmdoc
'phhumartiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'phhuartrefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: phorizonrefecmdoc ---- Pedon Horizon Reference ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

phorizonrefecmdoc.phiidref/1 AS phiidref,
phorizonrefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
phorizonrefecmdoc.ecmdocname AS ecmdocname,
phorizonrefecmdoc.ecmdockeyurl AS ecmdockeyurl,
phorizonrefecmdoc.recwlupdated AS recwlupdated,
phorizonrefecmdoc.recuseriidref/1 AS recuseriidref,
phorizonrefecmdoc.phorizonrefecmdociid/1 AS phorizonrefecmdociid

FROM pedon
INNER JOIN phorizon ON phorizon.peiidref=pedon.peiid AND peiid IN ($pedonid_list)
INNER JOIN phorizonrefecmdoc ON phorizonrefecmdoc.phiidref=phorizon.phiid;.

TEMPLATE phorizonrefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin phorizonrefecmdoc".
END SECTION.

SECTION HEADING
USING phorizonrefecmdoc
'phiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'phorizonrefecmdociid'.

DATA
USING phorizonrefecmdoc
phiidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
phorizonrefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin phorizonrefecmdoc".
USING phorizonrefecmdoc
'phiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'phorizonrefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: phvnirscan ---- Pedon Horizon VNIR Scan

ACCEPT pedonid_list.
EXEC SQL SELECT

phvnirscan.phiidref/1 AS phiidref,
phvnirscan.vnirdepthtop AS vnirdepthtop,
phvnirscan.vnirdepthbottom AS vnirdepthbottom,
CODELABEL (vnirsamplecondition) AS vnirsamplecondition,
CODELABEL (vnirlightsource) AS vnirlightsource,
phvnirscan.vnirscandate AS vnirscandate,
phvnirscan.vnirfilename AS vnirfilename,
phvnirscan.recwlupdated AS recwlupdated,
phvnirscan.recuseriidref/1 AS recuseriidref,
phvnirscan.phvnirscaniid/1 AS phvnirscaniid

FROM pedon
INNER JOIN phorizon ON phorizon.peiidref=pedon.peiid AND peiid IN ($pedonid_list)
INNER JOIN phvnirscan ON phvnirscan.phiidref=phorizon.phiid;.

TEMPLATE phvnirscan WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin phvnirscan".
END SECTION.

SECTION HEADING
USING phvnirscan
'phiidref',
'vnirdepthtop',
'vnirdepthbottom',
'vnirsamplecondition',
'vnirlightsource',
'vnirscandate',
'vnirfilename',
'recwlupdated',
'recuseriidref',
'phvnirscaniid'.

DATA
USING phvnirscan
phiidref,
vnirdepthtop,
vnirdepthbottom,
vnirsamplecondition,
vnirlightsource,
vnirscandate,
vnirfilename,
recwlupdated,
recuseriidref,
phvnirscaniid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin phvnirscan".
USING phvnirscan
'phiidref',
'vnirdepthtop',
'vnirdepthbottom',
'vnirsamplecondition',
'vnirlightsource',
'vnirscandate',
'vnirfilename',
'recwlupdated',
'recuseriidref',
'phvnirscaniid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: phvnirscanrawdata ---- Pedon Horizon VNIR Scan Raw Data

ACCEPT pedonid_list.
EXEC SQL SELECT

phvnirscanrawdata.phvnirscaniidref/1 AS phvnirscaniidref,
phvnirscanrawdata.vnirdata AS vnirdata,
phvnirscanrawdata.phvnirscanrawdataiid/1 AS phvnirscanrawdataiid

FROM pedon
INNER JOIN phorizon ON phorizon.peiidref=pedon.peiid AND peiid IN ($pedonid_list)
INNER JOIN phvnirscan ON phvnirscan.phiidref=phorizon.phiid
INNER JOIN phvnirscanrawdata ON phvnirscanrawdata.phvnirscaniidref=phvnirscan.phvnirscaniid;.

TEMPLATE phvnirscanrawdata WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin phvnirscanrawdata".
END SECTION.

SECTION HEADING
USING phvnirscanrawdata
'phvnirscaniidref',
'vnirdata',
'phvnirscanrawdataiid'.

DATA
USING phvnirscanrawdata
phvnirscaniidref,
vnirdata,
phvnirscanrawdataiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin phvnirscanrawdata".
USING phvnirscanrawdata
'phvnirscaniidref',
'vnirdata',
'phvnirscanrawdataiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: phvnirscanresult ---- Pedon Horizon VNIR Scan Result

ACCEPT pedonid_list.
EXEC SQL SELECT

phvnirscanresult.phvnirscaniidref/1 AS phvnirscaniidref,
phvnirscanresult.vnirmodelid AS vnirmodelid,
phvnirscanresult.vnirmodelrundate AS vnirmodelrundate,
phvnirscanresult.carbontotalpct AS carbontotalpct,
phvnirscanresult.carboninorganicpct AS carboninorganicpct,
phvnirscanresult.carbonorganicpct AS carbonorganicpct,
phvnirscanresult.recwlupdated AS recwlupdated,
phvnirscanresult.recuseriidref/1 AS recuseriidref,
phvnirscanresult.phvnirscanresultiid/1 AS phvnirscanresultiid

FROM pedon
INNER JOIN phorizon ON phorizon.peiidref=pedon.peiid AND peiid IN ($pedonid_list)
INNER JOIN phvnirscan ON phvnirscan.phiidref=phorizon.phiid
INNER JOIN phvnirscanresult ON phvnirscanresult.phvnirscaniidref=phvnirscan.phvnirscaniid;.

TEMPLATE phvnirscanresult WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin phvnirscanresult".
END SECTION.

SECTION HEADING
USING phvnirscanresult
'phvnirscaniidref',
'vnirmodelid',
'vnirmodelrundate',
'carbontotalpct',
'carboninorganicpct',
'carbonorganicpct',
'recwlupdated',
'recuseriidref',
'phvnirscanresultiid'.

DATA
USING phvnirscanresult
phvnirscaniidref,
vnirmodelid,
vnirmodelrundate,
carbontotalpct,
carboninorganicpct,
carbonorganicpct,
recwlupdated,
recuseriidref,
phvnirscanresultiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin phvnirscanresult".
USING phvnirscanresult
'phvnirscaniidref',
'vnirmodelid',
'vnirmodelrundate',
'carbontotalpct',
'carboninorganicpct',
'carbonorganicpct',
'recwlupdated',
'recuseriidref',
'phvnirscanresultiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plant ---- Plant

ACCEPT pedonid_list.
EXEC SQL SELECT

plant.plantsym AS plantsym,
plant.plantsciname AS plantsciname,
plant.plantnatvernm AS plantnatvernm,
plant.plantgenus AS plantgenus,
plant.plantspecies AS plantspecies,
plant.plantsubspecies AS plantsubspecies,
plant.plantvariety AS plantvariety,
plant.obterm AS obterm,
plant.plantdbiidref AS plantdbiidref,
plant.grpiidref AS grpiidref,
plant.objwlupdated AS objwlupdated,
plant.objuseriidref AS objuseriidref,
plant.recwlupdated AS recwlupdated,
plant.recuseriidref/1 AS recuseriidref,
plant.plantiid/1 AS plantiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref;.

TEMPLATE plant WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plant".
END SECTION.

SECTION HEADING
USING plant
'plantsym',
'plantsciname',
'plantnatvernm',
'plantgenus',
'plantspecies',
'plantsubspecies',
'plantvariety',
'obterm',
'plantdbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'plantiid'.

DATA
USING plant
plantsym,
plantsciname,
plantnatvernm,
plantgenus,
plantspecies,
plantsubspecies,
plantvariety,
obterm,
plantdbiidref,
grpiidref,
objwlupdated,
objuseriidref,
recwlupdated,
recuseriidref,
plantiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plant".
USING plant
'plantsym',
'plantsciname',
'plantnatvernm',
'plantgenus',
'plantspecies',
'plantsubspecies',
'plantvariety',
'obterm',
'plantdbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'plantiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plantprodquadratdetails ---- Plant Production Quadrat Details

ACCEPT pedonid_list.
EXEC SQL SELECT

plantprodquadratdetails.vegtransplantsummiidref/1 AS vegtransplantsummiidref,
plantprodquadratdetails.seqnum AS seqnum,
plantprodquadratdetails.quadratnumber AS quadratnumber,
plantprodquadratdetails.transectpointlocation AS transectpointlocation,
plantprodquadratdetails.quadratclippedindicator AS quadratclippedindicator,
plantprodquadratdetails.specieswtairdry AS specieswtairdry,
plantprodquadratdetails.specieswtclipped AS specieswtclipped,
plantprodquadratdetails.specieswtestimated AS specieswtestimated,
plantprodquadratdetails.speciestraceamtflag AS speciestraceamtflag,
plantprodquadratdetails.weightunitcount AS weightunitcount,
plantprodquadratdetails.speciescancovpct AS speciescancovpct,
CODELABEL (speciescancovclass) AS speciescancovclass,
plantprodquadratdetails.recwlupdated AS recwlupdated,
plantprodquadratdetails.recuseriidref/1 AS recuseriidref,
plantprodquadratdetails.plantprodquaddetailsiid/1 AS plantprodquaddetailsiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN vegtransectplantsummary ON vegtransectplantsummary.plantiidref=plant.plantiid
INNER JOIN plantprodquadratdetails ON plantprodquadratdetails.vegtransplantsummiidref=vegtransectplantsummary.vegtransplantsummiid;.

TEMPLATE plantprodquadratdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plantprodquadratdetails".
END SECTION.

SECTION HEADING
USING plantprodquadratdetails
'vegtransplantsummiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'quadratclippedindicator',
'specieswtairdry',
'specieswtclipped',
'specieswtestimated',
'speciestraceamtflag',
'weightunitcount',
'speciescancovpct',
'speciescancovclass',
'recwlupdated',
'recuseriidref',
'plantprodquaddetailsiid'.

DATA
USING plantprodquadratdetails
vegtransplantsummiidref,
seqnum,
quadratnumber,
transectpointlocation,
quadratclippedindicator,
specieswtairdry,
specieswtclipped,
specieswtestimated,
speciestraceamtflag,
weightunitcount,
speciescancovpct,
speciescancovclass,
recwlupdated,
recuseriidref,
plantprodquaddetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plantprodquadratdetails".
USING plantprodquadratdetails
'vegtransplantsummiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'quadratclippedindicator',
'specieswtairdry',
'specieswtclipped',
'specieswtestimated',
'speciestraceamtflag',
'weightunitcount',
'speciescancovpct',
'speciescancovclass',
'recwlupdated',
'recuseriidref',
'plantprodquaddetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plantsyn ---- Plant Synonym

ACCEPT pedonid_list.
EXEC SQL SELECT

plantsyn.plantiidref/1 AS plantiidref,
plantsyn.seqnum AS seqnum,
plantsyn.plantiidref2 AS plantiidref2,
plantsyn.recwlupdated AS recwlupdated,
plantsyn.recuseriidref/1 AS recuseriidref,
plantsyn.plantsyniid/1 AS plantsyniid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN plantsyn ON plantsyn.plantiidref=plant.plantiid;.

TEMPLATE plantsyn WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plantsyn".
END SECTION.

SECTION HEADING
USING plantsyn
'plantiidref',
'seqnum',
'plantiidref2',
'recwlupdated',
'recuseriidref',
'plantsyniid'.

DATA
USING plantsyn
plantiidref,
seqnum,
plantiidref2,
recwlupdated,
recuseriidref,
plantsyniid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plantsyn".
USING plantsyn
'plantiidref',
'seqnum',
'plantiidref2',
'recwlupdated',
'recuseriidref',
'plantsyniid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plotdisturbance ---- Plot Disturbance

ACCEPT pedonid_list.
EXEC SQL SELECT

plotdisturbance.vegplotiidref/1 AS vegplotiidref,
plotdisturbance.seqnum AS seqnum,
CODELABEL (disturbancetype) AS disturbancetype,
CODELABEL (disturbancefrequency) AS disturbancefrequency,
CODELABEL (disturbanceimpact) AS disturbanceimpact,
CODELABEL (disturbancelastapplied) AS disturbancelastapplied,
plotdisturbance.notes AS notes,
plotdisturbance.recwlupdated AS recwlupdated,
plotdisturbance.recuseriidref/1 AS recuseriidref,
plotdisturbance.plotdisturbanceiid/1 AS plotdisturbanceiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN plotdisturbance ON plotdisturbance.vegplotiidref=vegplot.vegplotiid;.

TEMPLATE plotdisturbance WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plotdisturbance".
END SECTION.

SECTION HEADING
USING plotdisturbance
'vegplotiidref',
'seqnum',
'disturbancetype',
'disturbancefrequency',
'disturbanceimpact',
'disturbancelastapplied',
'notes',
'recwlupdated',
'recuseriidref',
'plotdisturbanceiid'.

DATA
USING plotdisturbance
vegplotiidref,
seqnum,
disturbancetype,
disturbancefrequency,
disturbanceimpact,
disturbancelastapplied,
notes,
recwlupdated,
recuseriidref,
plotdisturbanceiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plotdisturbance".
USING plotdisturbance
'vegplotiidref',
'seqnum',
'disturbancetype',
'disturbancefrequency',
'disturbanceimpact',
'disturbancelastapplied',
'notes',
'recwlupdated',
'recuseriidref',
'plotdisturbanceiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plotdisturbrefecmdoc ---- Plot Disturbance Reference ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

plotdisturbrefecmdoc.plotdisturbiidref/1 AS plotdisturbiidref,
plotdisturbrefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
plotdisturbrefecmdoc.ecmdocname AS ecmdocname,
plotdisturbrefecmdoc.ecmdockeyurl AS ecmdockeyurl,
plotdisturbrefecmdoc.recwlupdated AS recwlupdated,
plotdisturbrefecmdoc.recuseriidref/1 AS recuseriidref,
plotdisturbrefecmdoc.plotdisturbrefecmdociid/1 AS plotdisturbrefecmdociid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN plotdisturbance ON plotdisturbance.vegplotiidref=vegplot.vegplotiid
INNER JOIN plotdisturbrefecmdoc ON plotdisturbrefecmdoc.plotdisturbiidref=plotdisturbance.plotdisturbanceiid;.

TEMPLATE plotdisturbrefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plotdisturbrefecmdoc".
END SECTION.

SECTION HEADING
USING plotdisturbrefecmdoc
'plotdisturbiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'plotdisturbrefecmdociid'.

DATA
USING plotdisturbrefecmdoc
plotdisturbiidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
plotdisturbrefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plotdisturbrefecmdoc".
USING plotdisturbrefecmdoc
'plotdisturbiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'plotdisturbrefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plotgrazerefecmdoc ---- Plot Grazing Reference ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

plotgrazerefecmdoc.plotgrazinguseiidref/1 AS plotgrazinguseiidref,
plotgrazerefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
plotgrazerefecmdoc.ecmdocname AS ecmdocname,
plotgrazerefecmdoc.ecmdockeyurl AS ecmdockeyurl,
plotgrazerefecmdoc.recwlupdated AS recwlupdated,
plotgrazerefecmdoc.recuseriidref/1 AS recuseriidref,
plotgrazerefecmdoc.plotgrazeuserefecmdociid/1 AS plotgrazeuserefecmdociid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN plotgrazinguse ON plotgrazinguse.vegplotiidref=vegplot.vegplotiid
INNER JOIN plotgrazerefecmdoc ON plotgrazerefecmdoc.plotgrazinguseiidref=plotgrazinguse.plotgrazinguseiid;.

TEMPLATE plotgrazerefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plotgrazerefecmdoc".
END SECTION.

SECTION HEADING
USING plotgrazerefecmdoc
'plotgrazinguseiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'plotgrazeuserefecmdociid'.

DATA
USING plotgrazerefecmdoc
plotgrazinguseiidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
plotgrazeuserefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plotgrazerefecmdoc".
USING plotgrazerefecmdoc
'plotgrazinguseiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'plotgrazeuserefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plotgrazinguse ---- Plot Grazing Use

ACCEPT pedonid_list.
EXEC SQL SELECT

plotgrazinguse.vegplotiidref/1 AS vegplotiidref,
plotgrazinguse.seqnum AS seqnum,
CODELABEL (animalkind) AS animalkind,
CODELABEL (usefrequency) AS usefrequency,
CODELABEL (seasonofuse) AS seasonofuse,
CODELABEL (stockingratecl) AS stockingratecl,
CODELABEL (akgrazingplantgroup) AS akgrazingplantgroup,
CODELABEL (akgrazingimpact) AS akgrazingimpact,
plotgrazinguse.recwlupdated AS recwlupdated,
plotgrazinguse.recuseriidref/1 AS recuseriidref,
plotgrazinguse.plotgrazinguseiid/1 AS plotgrazinguseiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN plotgrazinguse ON plotgrazinguse.vegplotiidref=vegplot.vegplotiid;.

TEMPLATE plotgrazinguse WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plotgrazinguse".
END SECTION.

SECTION HEADING
USING plotgrazinguse
'vegplotiidref',
'seqnum',
'animalkind',
'usefrequency',
'seasonofuse',
'stockingratecl',
'akgrazingplantgroup',
'akgrazingimpact',
'recwlupdated',
'recuseriidref',
'plotgrazinguseiid'.

DATA
USING plotgrazinguse
vegplotiidref,
seqnum,
animalkind,
usefrequency,
seasonofuse,
stockingratecl,
akgrazingplantgroup,
akgrazingimpact,
recwlupdated,
recuseriidref,
plotgrazinguseiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plotgrazinguse".
USING plotgrazinguse
'vegplotiidref',
'seqnum',
'animalkind',
'usefrequency',
'seasonofuse',
'stockingratecl',
'akgrazingplantgroup',
'akgrazingimpact',
'recwlupdated',
'recuseriidref',
'plotgrazinguseiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plotmainforeststanddetails ---- Main Forest Stand Details

ACCEPT pedonid_list.
EXEC SQL SELECT

plotmainforeststanddetails.vegplotiidref/1 AS vegplotiidref,
plotmainforeststanddetails.seqnum AS seqnum,
plotmainforeststanddetails.treenumber AS treenumber,
plotmainforeststanddetails.distancefromprevious AS distancefromprevious,
plotmainforeststanddetails.plantiidref AS plantiidref,
plotmainforeststanddetails.treediameterbreastheight AS treediameterbreastheight,
CODELABEL (treeconditions) AS treeconditions,
plotmainforeststanddetails.notes AS notes,
plotmainforeststanddetails.recwlupdated AS recwlupdated,
plotmainforeststanddetails.recuseriidref/1 AS recuseriidref,
plotmainforeststanddetails.plotmainforstanddetailiid/1 AS plotmainforstanddetailiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN plotmainforeststanddetails ON plotmainforeststanddetails.plantiidref=plant.plantiid;.

TEMPLATE plotmainforeststanddetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plotmainforeststanddetails".
END SECTION.

SECTION HEADING
USING plotmainforeststanddetails
'vegplotiidref',
'seqnum',
'treenumber',
'distancefromprevious',
'plantiidref',
'treediameterbreastheight',
'treeconditions',
'notes',
'recwlupdated',
'recuseriidref',
'plotmainforstanddetailiid'.

DATA
USING plotmainforeststanddetails
vegplotiidref,
seqnum,
treenumber,
distancefromprevious,
plantiidref,
treediameterbreastheight,
treeconditions,
notes,
recwlupdated,
recuseriidref,
plotmainforstanddetailiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plotmainforeststanddetails".
USING plotmainforeststanddetails
'vegplotiidref',
'seqnum',
'treenumber',
'distancefromprevious',
'plantiidref',
'treediameterbreastheight',
'treeconditions',
'notes',
'recwlupdated',
'recuseriidref',
'plotmainforstanddetailiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plotplantinventory ---- Plot Plant Inventory

ACCEPT pedonid_list.
EXEC SQL SELECT

plotplantinventory.vegplotiidref/1 AS vegplotiidref,
plotplantinventory.seqnum AS seqnum,
plotplantinventory.plantiidref AS plantiidref,
CODELABEL (planttypegroup) AS planttypegroup,
CODELABEL (akstratumcoverclass) AS akstratumcoverclass,
plotplantinventory.plantheightcllowerlimit AS plantheightcllowerlimit,
plotplantinventory.plantheightclupperlimit AS plantheightclupperlimit,
CODELABEL (plantnativity) AS plantnativity,
CODELABEL (sociabilityclass) AS sociabilityclass,
plotplantinventory.livecanopyhtbottom AS livecanopyhtbottom,
plotplantinventory.livecanopyhttop AS livecanopyhttop,
plotplantinventory.overstorydbhmin AS overstorydbhmin,
plotplantinventory.overstorydbhmax AS overstorydbhmax,
plotplantinventory.speciescancovpct AS speciescancovpct,
CODELABEL (speciescancovclass) AS speciescancovclass,
plotplantinventory.speciescomppct AS speciescomppct,
plotplantinventory.speciesdbhaverage AS speciesdbhaverage,
plotplantinventory.speciescompbywtpct AS speciescompbywtpct,
plotplantinventory.speciestreecount AS speciestreecount,
plotplantinventory.speciestraceamtflag AS speciestraceamtflag,
plotplantinventory.speciesbasalarea AS speciesbasalarea,
plotplantinventory.understorygrcovpct AS understorygrcovpct,
CODELABEL (understorygrcovclass) AS understorygrcovclass,
CODELABEL (seedlingdensityclass) AS seedlingdensityclass,
CODELABEL (maturedensityclass) AS maturedensityclass,
CODELABEL (vegetationstratalevel) AS vegetationstratalevel,
plotplantinventory.orderofdominance AS orderofdominance,
plotplantinventory.outsideplotindicator AS outsideplotindicator,
plotplantinventory.estannualprod AS estannualprod,
plotplantinventory.esdannualprod AS esdannualprod,
plotplantinventory.allowableannualprod AS allowableannualprod,
plotplantinventory.palatableannualprod AS palatableannualprod,
CODELABEL (akfunctionalgroup) AS akfunctionalgroup,
plotplantinventory.akstratumcoverclasspct AS akstratumcoverclasspct,
plotplantinventory.recwlupdated AS recwlupdated,
plotplantinventory.recuseriidref/1 AS recuseriidref,
plotplantinventory.plotplantinventoryiid/1 AS plotplantinventoryiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN plotplantinventory ON plotplantinventory.plantiidref=plant.plantiid;.

TEMPLATE plotplantinventory WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plotplantinventory".
END SECTION.

SECTION HEADING
USING plotplantinventory
'vegplotiidref',
'seqnum',
'plantiidref',
'planttypegroup',
'akstratumcoverclass',
'plantheightcllowerlimit',
'plantheightclupperlimit',
'plantnativity',
'sociabilityclass',
'livecanopyhtbottom',
'livecanopyhttop',
'overstorydbhmin',
'overstorydbhmax',
'speciescancovpct',
'speciescancovclass',
'speciescomppct',
'speciesdbhaverage',
'speciescompbywtpct',
'speciestreecount',
'speciestraceamtflag',
'speciesbasalarea',
'understorygrcovpct',
'understorygrcovclass',
'seedlingdensityclass',
'maturedensityclass',
'vegetationstratalevel',
'orderofdominance',
'outsideplotindicator',
'estannualprod',
'esdannualprod',
'allowableannualprod',
'palatableannualprod',
'akfunctionalgroup',
'akstratumcoverclasspct',
'recwlupdated',
'recuseriidref',
'plotplantinventoryiid'.

DATA
USING plotplantinventory
vegplotiidref,
seqnum,
plantiidref,
planttypegroup,
akstratumcoverclass,
plantheightcllowerlimit,
plantheightclupperlimit,
plantnativity,
sociabilityclass,
livecanopyhtbottom,
livecanopyhttop,
overstorydbhmin,
overstorydbhmax,
speciescancovpct,
speciescancovclass,
speciescomppct,
speciesdbhaverage,
speciescompbywtpct,
speciestreecount,
speciestraceamtflag,
speciesbasalarea,
understorygrcovpct,
understorygrcovclass,
seedlingdensityclass,
maturedensityclass,
vegetationstratalevel,
orderofdominance,
outsideplotindicator,
estannualprod,
esdannualprod,
allowableannualprod,
palatableannualprod,
akfunctionalgroup,
akstratumcoverclasspct,
recwlupdated,
recuseriidref,
plotplantinventoryiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plotplantinventory".
USING plotplantinventory
'vegplotiidref',
'seqnum',
'plantiidref',
'planttypegroup',
'akstratumcoverclass',
'plantheightcllowerlimit',
'plantheightclupperlimit',
'plantnativity',
'sociabilityclass',
'livecanopyhtbottom',
'livecanopyhttop',
'overstorydbhmin',
'overstorydbhmax',
'speciescancovpct',
'speciescancovclass',
'speciescomppct',
'speciesdbhaverage',
'speciescompbywtpct',
'speciestreecount',
'speciestraceamtflag',
'speciesbasalarea',
'understorygrcovpct',
'understorygrcovclass',
'seedlingdensityclass',
'maturedensityclass',
'vegetationstratalevel',
'orderofdominance',
'outsideplotindicator',
'estannualprod',
'esdannualprod',
'allowableannualprod',
'palatableannualprod',
'akfunctionalgroup',
'akstratumcoverclasspct',
'recwlupdated',
'recuseriidref',
'plotplantinventoryiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plotplanttypecanopycover ---- Plot Plant Type Canopy Cover

ACCEPT pedonid_list.
EXEC SQL SELECT

plotplanttypecanopycover.vegplotiidref/1 AS vegplotiidref,
plotplanttypecanopycover.seqnum AS seqnum,
CODELABEL (planttypegroup) AS planttypegroup,
plotplanttypecanopycover.plantheightcllowerlimit AS plantheightcllowerlimit,
plotplanttypecanopycover.plantheightclupperlimit AS plantheightclupperlimit,
plotplanttypecanopycover.planttypecancovpct AS planttypecancovpct,
CODELABEL (planttypecancovclass) AS planttypecancovclass,
CODELABEL (cancovassessmethod) AS cancovassessmethod,
plotplanttypecanopycover.recwlupdated AS recwlupdated,
plotplanttypecanopycover.recuseriidref/1 AS recuseriidref,
plotplanttypecanopycover.plotplanttypecancoviid/1 AS plotplanttypecancoviid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN plotplanttypecanopycover ON plotplanttypecanopycover.vegplotiidref=vegplot.vegplotiid;.

TEMPLATE plotplanttypecanopycover WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plotplanttypecanopycover".
END SECTION.

SECTION HEADING
USING plotplanttypecanopycover
'vegplotiidref',
'seqnum',
'planttypegroup',
'plantheightcllowerlimit',
'plantheightclupperlimit',
'planttypecancovpct',
'planttypecancovclass',
'cancovassessmethod',
'recwlupdated',
'recuseriidref',
'plotplanttypecancoviid'.

DATA
USING plotplanttypecanopycover
vegplotiidref,
seqnum,
planttypegroup,
plantheightcllowerlimit,
plantheightclupperlimit,
planttypecancovpct,
planttypecancovclass,
cancovassessmethod,
recwlupdated,
recuseriidref,
plotplanttypecancoviid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plotplanttypecanopycover".
USING plotplanttypecanopycover
'vegplotiidref',
'seqnum',
'planttypegroup',
'plantheightcllowerlimit',
'plantheightclupperlimit',
'planttypecancovpct',
'planttypecancovclass',
'cancovassessmethod',
'recwlupdated',
'recuseriidref',
'plotplanttypecancoviid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plotsamplingprotocolused ---- Plot Sampling Protocol Used

ACCEPT pedonid_list.
EXEC SQL SELECT

plotsamplingprotocolused.vegplotiidref/1 AS vegplotiidref,
plotsamplingprotocolused.seqnum AS seqnum,
CODELABEL (plotsampprotocolname) AS plotsampprotocolname,
plotsamplingprotocolused.datacollector AS datacollector,
plotsamplingprotocolused.datarecorder AS datarecorder,
CODELABEL (samplingintensity) AS samplingintensity,
plotsamplingprotocolused.recwlupdated AS recwlupdated,
plotsamplingprotocolused.recuseriidref/1 AS recuseriidref,
plotsamplingprotocolused.plotsampprotocolusediid/1 AS plotsampprotocolusediid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN plotsamplingprotocolused ON plotsamplingprotocolused.vegplotiidref=vegplot.vegplotiid;.

TEMPLATE plotsamplingprotocolused WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plotsamplingprotocolused".
END SECTION.

SECTION HEADING
USING plotsamplingprotocolused
'vegplotiidref',
'seqnum',
'plotsampprotocolname',
'datacollector',
'datarecorder',
'samplingintensity',
'recwlupdated',
'recuseriidref',
'plotsampprotocolusediid'.

DATA
USING plotsamplingprotocolused
vegplotiidref,
seqnum,
plotsampprotocolname,
datacollector,
datarecorder,
samplingintensity,
recwlupdated,
recuseriidref,
plotsampprotocolusediid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plotsamplingprotocolused".
USING plotsamplingprotocolused
'vegplotiidref',
'seqnum',
'plotsampprotocolname',
'datacollector',
'datarecorder',
'samplingintensity',
'recwlupdated',
'recuseriidref',
'plotsampprotocolusediid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plotsampprotocolrefecmdoc ---- Plot Samplie Protocol ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

plotsampprotocolrefecmdoc.plotsampprotoclusediidref/1 AS plotsampprotoclusediidref,
plotsampprotocolrefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
plotsampprotocolrefecmdoc.ecmdocname AS ecmdocname,
plotsampprotocolrefecmdoc.ecmdockeyurl AS ecmdockeyurl,
plotsampprotocolrefecmdoc.recwlupdated AS recwlupdated,
plotsampprotocolrefecmdoc.recuseriidref/1 AS recuseriidref,
plotsampprotocolrefecmdoc.plotsamprotrefecmdociid/1 AS plotsamprotrefecmdociid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN plotsamplingprotocolused ON plotsamplingprotocolused.vegplotiidref=vegplot.vegplotiid
INNER JOIN plotsampprotocolrefecmdoc ON plotsampprotocolrefecmdoc.plotsampprotoclusediidref=plotsamplingprotocolused.plotsampprotocolusediid;.

TEMPLATE plotsampprotocolrefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plotsampprotocolrefecmdoc".
END SECTION.

SECTION HEADING
USING plotsampprotocolrefecmdoc
'plotsampprotoclusediidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'plotsamprotrefecmdociid'.

DATA
USING plotsampprotocolrefecmdoc
plotsampprotoclusediidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
plotsamprotrefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plotsampprotocolrefecmdoc".
USING plotsampprotocolrefecmdoc
'plotsampprotoclusediidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'plotsamprotrefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plotspeciesbasalarea ---- Plot Species Basal Area

ACCEPT pedonid_list.
EXEC SQL SELECT

plotspeciesbasalarea.vegplotiidref/1 AS vegplotiidref,
plotspeciesbasalarea.seqnum AS seqnum,
plotspeciesbasalarea.plantiidref AS plantiidref,
CODELABEL (basalareafactor) AS basalareafactor,
plotspeciesbasalarea.speciesnumbertreesin AS speciesnumbertreesin,
plotspeciesbasalarea.speciesbasalarea AS speciesbasalarea,
plotspeciesbasalarea.recwlupdated AS recwlupdated,
plotspeciesbasalarea.recuseriidref/1 AS recuseriidref,
plotspeciesbasalarea.plotspeciebasalareaiid/1 AS plotspeciebasalareaiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN plotspeciesbasalarea ON plotspeciesbasalarea.plantiidref=plant.plantiid;.

TEMPLATE plotspeciesbasalarea WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plotspeciesbasalarea".
END SECTION.

SECTION HEADING
USING plotspeciesbasalarea
'vegplotiidref',
'seqnum',
'plantiidref',
'basalareafactor',
'speciesnumbertreesin',
'speciesbasalarea',
'recwlupdated',
'recuseriidref',
'plotspeciebasalareaiid'.

DATA
USING plotspeciesbasalarea
vegplotiidref,
seqnum,
plantiidref,
basalareafactor,
speciesnumbertreesin,
speciesbasalarea,
recwlupdated,
recuseriidref,
plotspeciebasalareaiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plotspeciesbasalarea".
USING plotspeciesbasalarea
'vegplotiidref',
'seqnum',
'plantiidref',
'basalareafactor',
'speciesnumbertreesin',
'speciesbasalarea',
'recwlupdated',
'recuseriidref',
'plotspeciebasalareaiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plottreeinventory ---- Plot Tree Inventory

ACCEPT pedonid_list.
EXEC SQL SELECT

plottreeinventory.vegplotiidref/1 AS vegplotiidref,
plottreeinventory.seqnum AS seqnum,
plottreeinventory.plantiidref AS plantiidref,
plottreeinventory.speciestreecount AS speciestreecount,
plottreeinventory.speciescomppct AS speciescomppct,
plottreeinventory.speciesdbhaverage AS speciesdbhaverage,
plottreeinventory.speciesbasalarea AS speciesbasalarea,
plottreeinventory.plottreeinventoryiid/1 AS plottreeinventoryiid,
plottreeinventory.recwlupdated AS recwlupdated,
plottreeinventory.recuseriidref/1 AS recuseriidref

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN plottreeinventory ON plottreeinventory.plantiidref=plant.plantiid;.

TEMPLATE plottreeinventory WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plottreeinventory".
END SECTION.

SECTION HEADING
USING plottreeinventory
'vegplotiidref',
'seqnum',
'plantiidref',
'speciestreecount',
'speciescomppct',
'speciesdbhaverage',
'speciesbasalarea',
'plottreeinventoryiid',
'recwlupdated',
'recuseriidref'.

DATA
USING plottreeinventory
vegplotiidref,
seqnum,
plantiidref,
speciestreecount,
speciescomppct,
speciesdbhaverage,
speciesbasalarea,
plottreeinventoryiid,
recwlupdated,
recuseriidref.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plottreeinventory".
USING plottreeinventory
'vegplotiidref',
'seqnum',
'plantiidref',
'speciestreecount',
'speciescomppct',
'speciesdbhaverage',
'speciesbasalarea',
'plottreeinventoryiid',
'recwlupdated',
'recuseriidref'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plottreescounted ---- Plot Trees Counted

ACCEPT pedonid_list.
EXEC SQL SELECT

plottreescounted.plottreeinventoryiidref/1 AS plottreeinventoryiidref,
plottreescounted.seqnum AS seqnum,
plottreescounted.dbhclassmidpoint AS dbhclassmidpoint,
plottreescounted.dbhclassspeciestreecount AS dbhclassspeciestreecount,
plottreescounted.recwlupdated AS recwlupdated,
plottreescounted.recuseriidref/1 AS recuseriidref,
plottreescounted.plottreescountediid/1 AS plottreescountediid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN plottreeinventory ON plottreeinventory.plantiidref=plant.plantiid
INNER JOIN plottreescounted ON plottreescounted.plottreeinventoryiidref=plottreeinventory.plottreeinventoryiid;.

TEMPLATE plottreescounted WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plottreescounted".
END SECTION.

SECTION HEADING
USING plottreescounted
'plottreeinventoryiidref',
'seqnum',
'dbhclassmidpoint',
'dbhclassspeciestreecount',
'recwlupdated',
'recuseriidref',
'plottreescountediid'.

DATA
USING plottreescounted
plottreeinventoryiidref,
seqnum,
dbhclassmidpoint,
dbhclassspeciestreecount,
recwlupdated,
recuseriidref,
plottreescountediid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plottreescounted".
USING plottreescounted
'plottreeinventoryiidref',
'seqnum',
'dbhclassmidpoint',
'dbhclassspeciestreecount',
'recwlupdated',
'recuseriidref',
'plottreescountediid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plottreesiteindexdetails ---- Plot Tree Site Index Details

ACCEPT pedonid_list.
EXEC SQL SELECT

plottreesiteindexdetails.plottreesiteindsumiidref/1 AS plottreesiteindsumiidref,
plottreesiteindexdetails.seqnum AS seqnum,
plottreesiteindexdetails.treenumber AS treenumber,
CODELABEL (crownclass) AS crownclass,
CODELABEL (reproductionsource) AS reproductionsource,
plottreesiteindexdetails.treediameterbreastheight AS treediameterbreastheight,
plottreesiteindexdetails.tenyeargrowthradius AS tenyeargrowthradius,
plottreesiteindexdetails.growthringcount AS growthringcount,
plottreesiteindexdetails.growthringcountheight AS growthringcountheight,
plottreesiteindexdetails.growthringcountage AS growthringcountage,
plottreesiteindexdetails.treeage AS treeage,
plottreesiteindexdetails.treecanopyhtbottom AS treecanopyhtbottom,
plottreesiteindexdetails.treecanopyhttop AS treecanopyhttop,
plottreesiteindexdetails.aknoringsinlastinch AS aknoringsinlastinch,
CODELABEL (akcrownclass) AS akcrownclass,
plottreesiteindexdetails.recwlupdated AS recwlupdated,
plottreesiteindexdetails.recuseriidref/1 AS recuseriidref,
plottreesiteindexdetails.plottreesiteinddetailsiid/1 AS plottreesiteinddetailsiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN plottreesiteindexsummary ON plottreesiteindexsummary.plantiidref=plant.plantiid
INNER JOIN plottreesiteindexdetails ON plottreesiteindexdetails.plottreesiteindsumiidref=plottreesiteindexsummary.plottreesiteindsumiid;.

TEMPLATE plottreesiteindexdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plottreesiteindexdetails".
END SECTION.

SECTION HEADING
USING plottreesiteindexdetails
'plottreesiteindsumiidref',
'seqnum',
'treenumber',
'crownclass',
'reproductionsource',
'treediameterbreastheight',
'tenyeargrowthradius',
'growthringcount',
'growthringcountheight',
'growthringcountage',
'treeage',
'treecanopyhtbottom',
'treecanopyhttop',
'aknoringsinlastinch',
'akcrownclass',
'recwlupdated',
'recuseriidref',
'plottreesiteinddetailsiid'.

DATA
USING plottreesiteindexdetails
plottreesiteindsumiidref,
seqnum,
treenumber,
crownclass,
reproductionsource,
treediameterbreastheight,
tenyeargrowthradius,
growthringcount,
growthringcountheight,
growthringcountage,
treeage,
treecanopyhtbottom,
treecanopyhttop,
aknoringsinlastinch,
akcrownclass,
recwlupdated,
recuseriidref,
plottreesiteinddetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plottreesiteindexdetails".
USING plottreesiteindexdetails
'plottreesiteindsumiidref',
'seqnum',
'treenumber',
'crownclass',
'reproductionsource',
'treediameterbreastheight',
'tenyeargrowthradius',
'growthringcount',
'growthringcountheight',
'growthringcountage',
'treeage',
'treecanopyhtbottom',
'treecanopyhttop',
'aknoringsinlastinch',
'akcrownclass',
'recwlupdated',
'recuseriidref',
'plottreesiteinddetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plottreesiteindexsummary ---- Plot Tree Site Index Summary

ACCEPT pedonid_list.
EXEC SQL SELECT

plottreesiteindexsummary.vegplotiidref/1 AS vegplotiidref,
plottreesiteindexsummary.seqnum AS seqnum,
plottreesiteindexsummary.plantiidref AS plantiidref,
CODELABEL (plantnativity) AS plantnativity,
CODELABEL (siteindexbase) AS siteindexbase,
plottreesiteindexsummary.speciestreecount AS speciestreecount,
plottreesiteindexsummary.siteindexplotave AS siteindexplotave,
plottreesiteindexsummary.speciesdbhaverage AS speciesdbhaverage,
plottreesiteindexsummary.treeageave AS treeageave,
plottreesiteindexsummary.treecanopyhttopave AS treecanopyhttopave,
plottreesiteindexsummary.recwlupdated AS recwlupdated,
plottreesiteindexsummary.recuseriidref/1 AS recuseriidref,
plottreesiteindexsummary.plottreesiteindsumiid/1 AS plottreesiteindsumiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN plottreesiteindexsummary ON plottreesiteindexsummary.plantiidref=plant.plantiid;.

TEMPLATE plottreesiteindexsummary WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plottreesiteindexsummary".
END SECTION.

SECTION HEADING
USING plottreesiteindexsummary
'vegplotiidref',
'seqnum',
'plantiidref',
'plantnativity',
'siteindexbase',
'speciestreecount',
'siteindexplotave',
'speciesdbhaverage',
'treeageave',
'treecanopyhttopave',
'recwlupdated',
'recuseriidref',
'plottreesiteindsumiid'.

DATA
USING plottreesiteindexsummary
vegplotiidref,
seqnum,
plantiidref,
plantnativity,
siteindexbase,
speciestreecount,
siteindexplotave,
speciesdbhaverage,
treeageave,
treecanopyhttopave,
recwlupdated,
recuseriidref,
plottreesiteindsumiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plottreesiteindexsummary".
USING plottreesiteindexsummary
'vegplotiidref',
'seqnum',
'plantiidref',
'plantnativity',
'siteindexbase',
'speciestreecount',
'siteindexplotave',
'speciesdbhaverage',
'treeageave',
'treecanopyhttopave',
'recwlupdated',
'recuseriidref',
'plottreesiteindsumiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: plottreesummary ---- Plot Tree Summary

ACCEPT pedonid_list.
EXEC SQL SELECT

plottreesummary.vegplotiidref/1 AS vegplotiidref,
plottreesummary.seqnum AS seqnum,
plottreesummary.dbhclassmidpoint AS dbhclassmidpoint,
plottreesummary.dbhclasstreecount AS dbhclasstreecount,
plottreesummary.dbhclassbasalarea AS dbhclassbasalarea,
plottreesummary.dbhclasstreedensity AS dbhclasstreedensity,
plottreesummary.recwlupdated AS recwlupdated,
plottreesummary.recuseriidref/1 AS recuseriidref,
plottreesummary.plottreesummaryiid/1 AS plottreesummaryiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN plottreesummary ON plottreesummary.vegplotiidref=vegplot.vegplotiid;.

TEMPLATE plottreesummary WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin plottreesummary".
END SECTION.

SECTION HEADING
USING plottreesummary
'vegplotiidref',
'seqnum',
'dbhclassmidpoint',
'dbhclasstreecount',
'dbhclassbasalarea',
'dbhclasstreedensity',
'recwlupdated',
'recuseriidref',
'plottreesummaryiid'.

DATA
USING plottreesummary
vegplotiidref,
seqnum,
dbhclassmidpoint,
dbhclasstreecount,
dbhclassbasalarea,
dbhclasstreedensity,
recwlupdated,
recuseriidref,
plottreesummaryiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin plottreesummary".
USING plottreesummary
'vegplotiidref',
'seqnum',
'dbhclassmidpoint',
'dbhclasstreecount',
'dbhclassbasalarea',
'dbhclasstreedensity',
'recwlupdated',
'recuseriidref',
'plottreesummaryiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: pointplantcoverdetails ---- Point Plant Cover Details

ACCEPT pedonid_list.
EXEC SQL SELECT

pointplantcoverdetails.vegtransplantsummiidref/1 AS vegtransplantsummiidref,
pointplantcoverdetails.seqnum AS seqnum,
pointplantcoverdetails.transectpointlocation AS transectpointlocation,
pointplantcoverdetails.livecanopyhtbottom AS livecanopyhtbottom,
pointplantcoverdetails.livecanopyhttop AS livecanopyhttop,
pointplantcoverdetails.canopycoverpresent AS canopycoverpresent,
pointplantcoverdetails.foliarcoverpresent AS foliarcoverpresent,
pointplantcoverdetails.basalcoverpresent AS basalcoverpresent,
pointplantcoverdetails.recwlupdated AS recwlupdated,
pointplantcoverdetails.recuseriidref/1 AS recuseriidref,
pointplantcoverdetails.pointplantcovdetailsiid/1 AS pointplantcovdetailsiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN vegtransectplantsummary ON vegtransectplantsummary.plantiidref=plant.plantiid
INNER JOIN pointplantcoverdetails ON pointplantcoverdetails.vegtransplantsummiidref=vegtransectplantsummary.vegtransplantsummiid;.

TEMPLATE pointplantcoverdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin pointplantcoverdetails".
END SECTION.

SECTION HEADING
USING pointplantcoverdetails
'vegtransplantsummiidref',
'seqnum',
'transectpointlocation',
'livecanopyhtbottom',
'livecanopyhttop',
'canopycoverpresent',
'foliarcoverpresent',
'basalcoverpresent',
'recwlupdated',
'recuseriidref',
'pointplantcovdetailsiid'.

DATA
USING pointplantcoverdetails
vegtransplantsummiidref,
seqnum,
transectpointlocation,
livecanopyhtbottom,
livecanopyhttop,
canopycoverpresent,
foliarcoverpresent,
basalcoverpresent,
recwlupdated,
recuseriidref,
pointplantcovdetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin pointplantcoverdetails".
USING pointplantcoverdetails
'vegtransplantsummiidref',
'seqnum',
'transectpointlocation',
'livecanopyhtbottom',
'livecanopyhttop',
'canopycoverpresent',
'foliarcoverpresent',
'basalcoverpresent',
'recwlupdated',
'recuseriidref',
'pointplantcovdetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: siteassoc ---- Site Association

ACCEPT pedonid_list.
EXEC SQL SELECT

siteassoc.usiteassocid AS usiteassocid,
siteassoc.sadbiidref AS sadbiidref,
siteassoc.grpiidref AS grpiidref,
siteassoc.objwlupdated AS objwlupdated,
siteassoc.objuseriidref AS objuseriidref,
siteassoc.recwlupdated AS recwlupdated,
siteassoc.recuseriidref/1 AS recuseriidref,
siteassoc.siteassociid/1 AS siteassociid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN siteassoc ON siteassoc.grpiidref,sadbiidref=nasisgroup.grpiid,nasissiteiidref;.

TEMPLATE siteassoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin siteassoc".
END SECTION.

SECTION HEADING
USING siteassoc
'usiteassocid',
'sadbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'siteassociid'.

DATA
USING siteassoc
usiteassocid,
sadbiidref,
grpiidref,
objwlupdated,
objuseriidref,
recwlupdated,
recuseriidref,
siteassociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin siteassoc".
USING siteassoc
'usiteassocid',
'sadbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'siteassociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: siteassocsite ---- Site Association Site

ACCEPT pedonid_list.
EXEC SQL SELECT

siteassocsite.siteassociidref/1 AS siteassociidref,
siteassocsite.seqnum AS seqnum,
siteassocsite.siteiidref AS siteiidref,
siteassocsite.recwlupdated AS recwlupdated,
siteassocsite.recuseriidref/1 AS recuseriidref,
siteassocsite.siteasiteiid/1 AS siteasiteiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN areatype ON areatype.grpiidref,atdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN area ON area.areatypeiidref=areatype.areatypeiid
INNER JOIN site ON site.countyareaiidref,countyareatypeiidref=area.areaiid,areatypeiidref
INNER JOIN siteassocsite ON siteassocsite.siteiidref=site.siteiid;.

TEMPLATE siteassocsite WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin siteassocsite".
END SECTION.

SECTION HEADING
USING siteassocsite
'siteassociidref',
'seqnum',
'siteiidref',
'recwlupdated',
'recuseriidref',
'siteasiteiid'.

DATA
USING siteassocsite
siteassociidref,
seqnum,
siteiidref,
recwlupdated,
recuseriidref,
siteasiteiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin siteassocsite".
USING siteassocsite
'siteassociidref',
'seqnum',
'siteiidref',
'recwlupdated',
'recuseriidref',
'siteasiteiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: siteassoctext ---- Site Association Text

ACCEPT pedonid_list.
EXEC SQL SELECT

siteassoctext.siteassociidref/1 AS siteassociidref,
siteassoctext.seqnum AS seqnum,
siteassoctext.recdate AS recdate,
siteassoctext.recauthor AS recauthor,
CODELABEL (siteassoctextkind) AS siteassoctextkind,
siteassoctext.textcat AS textcat,
siteassoctext.textsubcat AS textsubcat,
siteassoctext.textentry AS textentry,
siteassoctext.recwlupdated AS recwlupdated,
siteassoctext.recuseriidref/1 AS recuseriidref,
siteassoctext.siteatextiid/1 AS siteatextiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN siteassoc ON siteassoc.grpiidref,sadbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN siteassoctext ON siteassoctext.siteassociidref=siteassoc.siteassociid;.

TEMPLATE siteassoctext WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin siteassoctext".
END SECTION.

SECTION HEADING
USING siteassoctext
'siteassociidref',
'seqnum',
'recdate',
'recauthor',
'siteassoctextkind',
'textcat',
'textsubcat',
'textentry',
'recwlupdated',
'recuseriidref',
'siteatextiid'.

DATA
USING siteassoctext
siteassociidref,
seqnum,
recdate,
recauthor,
siteassoctextkind,
textcat,
textsubcat,
textentry,
recwlupdated,
recuseriidref,
siteatextiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin siteassoctext".
USING siteassoctext
'siteassociidref',
'seqnum',
'recdate',
'recauthor',
'siteassoctextkind',
'textcat',
'textsubcat',
'textentry',
'recwlupdated',
'recuseriidref',
'siteatextiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: siteinundationtype ---- Site Inundation Type

ACCEPT pedonid_list.
EXEC SQL SELECT

siteinundationtype.siteobsiidref/1 AS siteobsiidref,
CODELABEL (inundationtype) AS inundationtype,
siteinundationtype.recwlupdated AS recwlupdated,
siteinundationtype.recuseriidref/1 AS recuseriidref,
siteinundationtype.siteinundationtypeiid/1 AS siteinundationtypeiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
TEMPLATE siteinundationtype WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin siteinundationtype".
END SECTION.

SECTION HEADING
USING siteinundationtype
'siteobsiidref',
'inundationtype',
'recwlupdated',
'recuseriidref',
'siteinundationtypeiid'.

DATA
USING siteinundationtype
siteobsiidref,
inundationtype,
recwlupdated,
recuseriidref,
siteinundationtypeiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin siteinundationtype".
USING siteinundationtype
'siteobsiidref',
'inundationtype',
'recwlupdated',
'recuseriidref',
'siteinundationtypeiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: siteiristubeimage ---- Site IRIS Tube Image

ACCEPT pedonid_list.
EXEC SQL SELECT

siteiristubeimage.siteiristubedataiidref/1 AS siteiristubedataiidref,
siteiristubeimage.iristubeimagescan AS iristubeimagescan,
siteiristubeimage.siteiristubeimageiid/1 AS siteiristubeimageiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN siteiristubeimage ON siteiristubeimage.siteiristubedataiidref=siteiristubedata.siteiristubedataiid;.

TEMPLATE siteiristubeimage WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin siteiristubeimage".
END SECTION.

SECTION HEADING
USING siteiristubeimage
'siteiristubedataiidref',
'iristubeimagescan',
'siteiristubeimageiid'.

DATA
USING siteiristubeimage
siteiristubedataiidref,
iristubeimagescan,
siteiristubeimageiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin siteiristubeimage".
USING siteiristubeimage
'siteiristubedataiidref',
'iristubeimagescan',
'siteiristubeimageiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: siteobsrefecmdoc ---- Site Observation Reference ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

siteobsrefecmdoc.siteobsiidref/1 AS siteobsiidref,
siteobsrefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
siteobsrefecmdoc.ecmdocname AS ecmdocname,
siteobsrefecmdoc.ecmdockeyurl AS ecmdockeyurl,
siteobsrefecmdoc.recwlupdated AS recwlupdated,
siteobsrefecmdoc.recuseriidref/1 AS recuseriidref,
siteobsrefecmdoc.siteobsrefecmdociid/1 AS siteobsrefecmdociid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
TEMPLATE siteobsrefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin siteobsrefecmdoc".
END SECTION.

SECTION HEADING
USING siteobsrefecmdoc
'siteobsiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'siteobsrefecmdociid'.

DATA
USING siteobsrefecmdoc
siteobsiidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
siteobsrefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin siteobsrefecmdoc".
USING siteobsrefecmdoc
'siteobsiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'siteobsrefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: siterefecmdoc ---- Site Reference ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

siterefecmdoc.siteiidref/1 AS siteiidref,
siterefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
siterefecmdoc.ecmdocname AS ecmdocname,
siterefecmdoc.ecmdockeyurl AS ecmdockeyurl,
siterefecmdoc.recwlupdated AS recwlupdated,
siterefecmdoc.recuseriidref/1 AS recuseriidref,
siterefecmdoc.siterefecmdociid/1 AS siterefecmdociid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN areatype ON areatype.grpiidref,atdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN area ON area.areatypeiidref=areatype.areatypeiid
INNER JOIN site ON site.countyareaiidref,countyareatypeiidref=area.areaiid,areatypeiidref
INNER JOIN siterefecmdoc ON siterefecmdoc.siteiidref=site.siteiid;.

TEMPLATE siterefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin siterefecmdoc".
END SECTION.

SECTION HEADING
USING siterefecmdoc
'siteiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'siterefecmdociid'.

DATA
USING siterefecmdoc
siteiidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
siterefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin siterefecmdoc".
USING siterefecmdoc
'siteiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'siterefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: sitetreescounted ---- Site Trees Counted

ACCEPT pedonid_list.
EXEC SQL SELECT

sitetreescounted.sitewoodybasalareaiidref/1 AS sitewoodybasalareaiidref,
sitetreescounted.seqnum AS seqnum,
sitetreescounted.treediameterbreastheight AS treediameterbreastheight,
sitetreescounted.treeheight AS treeheight,
sitetreescounted.recwlupdated AS recwlupdated,
sitetreescounted.recuseriidref/1 AS recuseriidref,
sitetreescounted.treescountediid/1 AS treescountediid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN sitewoodybasalarea ON sitewoodybasalarea.vegplotiidref=vegplot.vegplotiid
INNER JOIN sitetreescounted ON sitetreescounted.sitewoodybasalareaiidref=sitewoodybasalarea.sitewoodybasalareaiid;.

TEMPLATE sitetreescounted WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin sitetreescounted".
END SECTION.

SECTION HEADING
USING sitetreescounted
'sitewoodybasalareaiidref',
'seqnum',
'treediameterbreastheight',
'treeheight',
'recwlupdated',
'recuseriidref',
'treescountediid'.

DATA
USING sitetreescounted
sitewoodybasalareaiidref,
seqnum,
treediameterbreastheight,
treeheight,
recwlupdated,
recuseriidref,
treescountediid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin sitetreescounted".
USING sitetreescounted
'sitewoodybasalareaiidref',
'seqnum',
'treediameterbreastheight',
'treeheight',
'recwlupdated',
'recuseriidref',
'treescountediid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: siteusgsquadrangleoverlap ---- Site USGS Quadrangle Overlap

ACCEPT pedonid_list.
EXEC SQL SELECT

siteusgsquadrangleoverlap.siteiidref/1 AS siteiidref,
siteusgsquadrangleoverlap.seqnum AS seqnum,
siteusgsquadrangleoverlap.usgsquadrangleiidref AS usgsquadrangleiidref,
siteusgsquadrangleoverlap.recwlupdated AS recwlupdated,
siteusgsquadrangleoverlap.recuseriidref/1 AS recuseriidref,
siteusgsquadrangleoverlap.siteusgsquadoviid/1 AS siteusgsquadoviid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN areatype ON areatype.grpiidref,atdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN area ON area.areatypeiidref=areatype.areatypeiid
INNER JOIN site ON site.countyareaiidref,countyareatypeiidref=area.areaiid,areatypeiidref
INNER JOIN siteusgsquadrangleoverlap ON siteusgsquadrangleoverlap.siteiidref=site.siteiid;.

TEMPLATE siteusgsquadrangleoverlap WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin siteusgsquadrangleoverlap".
END SECTION.

SECTION HEADING
USING siteusgsquadrangleoverlap
'siteiidref',
'seqnum',
'usgsquadrangleiidref',
'recwlupdated',
'recuseriidref',
'siteusgsquadoviid'.

DATA
USING siteusgsquadrangleoverlap
siteiidref,
seqnum,
usgsquadrangleiidref,
recwlupdated,
recuseriidref,
siteusgsquadoviid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin siteusgsquadrangleoverlap".
USING siteusgsquadrangleoverlap
'siteiidref',
'seqnum',
'usgsquadrangleiidref',
'recwlupdated',
'recuseriidref',
'siteusgsquadoviid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: sitewoodybasalarea ---- Site Woody Basal Area

ACCEPT pedonid_list.
EXEC SQL SELECT

sitewoodybasalarea.vegplotiidref/1 AS vegplotiidref,
sitewoodybasalarea.seqnum AS seqnum,
CODELABEL (basalareafactor) AS basalareafactor,
sitewoodybasalarea.basalareasubplottotal AS basalareasubplottotal,
sitewoodybasalarea.numberoftreesin AS numberoftreesin,
sitewoodybasalarea.recwlupdated AS recwlupdated,
sitewoodybasalarea.recuseriidref/1 AS recuseriidref,
sitewoodybasalarea.sitewoodybasalareaiid/1 AS sitewoodybasalareaiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN sitewoodybasalarea ON sitewoodybasalarea.vegplotiidref=vegplot.vegplotiid;.

TEMPLATE sitewoodybasalarea WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin sitewoodybasalarea".
END SECTION.

SECTION HEADING
USING sitewoodybasalarea
'vegplotiidref',
'seqnum',
'basalareafactor',
'basalareasubplottotal',
'numberoftreesin',
'recwlupdated',
'recuseriidref',
'sitewoodybasalareaiid'.

DATA
USING sitewoodybasalarea
vegplotiidref,
seqnum,
basalareafactor,
basalareasubplottotal,
numberoftreesin,
recwlupdated,
recuseriidref,
sitewoodybasalareaiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin sitewoodybasalarea".
USING sitewoodybasalarea
'vegplotiidref',
'seqnum',
'basalareafactor',
'basalareasubplottotal',
'numberoftreesin',
'recwlupdated',
'recuseriidref',
'sitewoodybasalareaiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: subplotplantdetails ---- Subplot Plant Details

ACCEPT pedonid_list.
EXEC SQL SELECT

subplotplantdetails.plotplantinventoryiidref/1 AS plotplantinventoryiidref,
subplotplantdetails.seqnum AS seqnum,
subplotplantdetails.subplotnumber AS subplotnumber,
subplotplantdetails.subplotsize AS subplotsize,
subplotplantdetails.stemcount AS stemcount,
subplotplantdetails.stemdiameteraverage AS stemdiameteraverage,
subplotplantdetails.recwlupdated AS recwlupdated,
subplotplantdetails.recuseriidref/1 AS recuseriidref,
subplotplantdetails.subplotplantdetailsiid/1 AS subplotplantdetailsiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN plotplantinventory ON plotplantinventory.plantiidref=plant.plantiid
INNER JOIN subplotplantdetails ON subplotplantdetails.plotplantinventoryiidref=plotplantinventory.plotplantinventoryiid;.

TEMPLATE subplotplantdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin subplotplantdetails".
END SECTION.

SECTION HEADING
USING subplotplantdetails
'plotplantinventoryiidref',
'seqnum',
'subplotnumber',
'subplotsize',
'stemcount',
'stemdiameteraverage',
'recwlupdated',
'recuseriidref',
'subplotplantdetailsiid'.

DATA
USING subplotplantdetails
plotplantinventoryiidref,
seqnum,
subplotnumber,
subplotsize,
stemcount,
stemdiameteraverage,
recwlupdated,
recuseriidref,
subplotplantdetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin subplotplantdetails".
USING subplotplantdetails
'plotplantinventoryiidref',
'seqnum',
'subplotnumber',
'subplotsize',
'stemcount',
'stemdiameteraverage',
'recwlupdated',
'recuseriidref',
'subplotplantdetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: totalquadratharvest ---- Total Quadrat Harvest

ACCEPT pedonid_list.
EXEC SQL SELECT

totalquadratharvest.vegtransectiidref/1 AS vegtransectiidref,
totalquadratharvest.seqnum AS seqnum,
totalquadratharvest.quadratnumber AS quadratnumber,
totalquadratharvest.transectpointlocation AS transectpointlocation,
totalquadratharvest.quadrattotwtclippedfresh AS quadrattotwtclippedfresh,
totalquadratharvest.recuseriidref/1 AS recuseriidref,
totalquadratharvest.recwlupdated AS recwlupdated,
totalquadratharvest.totalquadratharvestiid/1 AS totalquadratharvestiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN totalquadratharvest ON totalquadratharvest.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE totalquadratharvest WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin totalquadratharvest".
END SECTION.

SECTION HEADING
USING totalquadratharvest
'vegtransectiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'quadrattotwtclippedfresh',
'recuseriidref',
'recwlupdated',
'totalquadratharvestiid'.

DATA
USING totalquadratharvest
vegtransectiidref,
seqnum,
quadratnumber,
transectpointlocation,
quadrattotwtclippedfresh,
recuseriidref,
recwlupdated,
totalquadratharvestiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin totalquadratharvest".
USING totalquadratharvest
'vegtransectiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'quadrattotwtclippedfresh',
'recuseriidref',
'recwlupdated',
'totalquadratharvestiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: transectgapdetails ---- Transect Gap Details

ACCEPT pedonid_list.
EXEC SQL SELECT

transectgapdetails.vegtransectiidref/1 AS vegtransectiidref,
transectgapdetails.seqnum AS seqnum,
transectgapdetails.gapnumber AS gapnumber,
CODELABEL (gapkind) AS gapkind,
transectgapdetails.gapstartpoint AS gapstartpoint,
transectgapdetails.gapendpoint AS gapendpoint,
transectgapdetails.gaplength AS gaplength,
transectgapdetails.recwlupdated AS recwlupdated,
transectgapdetails.recuseriidref/1 AS recuseriidref,
transectgapdetails.transectgapdetailsiid/1 AS transectgapdetailsiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN transectgapdetails ON transectgapdetails.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE transectgapdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin transectgapdetails".
END SECTION.

SECTION HEADING
USING transectgapdetails
'vegtransectiidref',
'seqnum',
'gapnumber',
'gapkind',
'gapstartpoint',
'gapendpoint',
'gaplength',
'recwlupdated',
'recuseriidref',
'transectgapdetailsiid'.

DATA
USING transectgapdetails
vegtransectiidref,
seqnum,
gapnumber,
gapkind,
gapstartpoint,
gapendpoint,
gaplength,
recwlupdated,
recuseriidref,
transectgapdetailsiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin transectgapdetails".
USING transectgapdetails
'vegtransectiidref',
'seqnum',
'gapnumber',
'gapkind',
'gapstartpoint',
'gapendpoint',
'gaplength',
'recwlupdated',
'recuseriidref',
'transectgapdetailsiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: transectgroundcover ---- Transect Ground Cover

ACCEPT pedonid_list.
EXEC SQL SELECT

transectgroundcover.vegtransectiidref/1 AS vegtransectiidref,
transectgroundcover.seqnum AS seqnum,
CODELABEL (groundcovertype) AS groundcovertype,
transectgroundcover.groundcoverptcount AS groundcoverptcount,
transectgroundcover.groundcoverptpct AS groundcoverptpct,
transectgroundcover.quadratsize AS quadratsize,
CODELABEL (quadratshape) AS quadratshape,
transectgroundcover.groundcoverquadpctave AS groundcoverquadpctave,
transectgroundcover.recwlupdated AS recwlupdated,
transectgroundcover.recuseriidref/1 AS recuseriidref,
transectgroundcover.transectgroundcoveriid/1 AS transectgroundcoveriid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN transectgroundcover ON transectgroundcover.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE transectgroundcover WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin transectgroundcover".
END SECTION.

SECTION HEADING
USING transectgroundcover
'vegtransectiidref',
'seqnum',
'groundcovertype',
'groundcoverptcount',
'groundcoverptpct',
'quadratsize',
'quadratshape',
'groundcoverquadpctave',
'recwlupdated',
'recuseriidref',
'transectgroundcoveriid'.

DATA
USING transectgroundcover
vegtransectiidref,
seqnum,
groundcovertype,
groundcoverptcount,
groundcoverptpct,
quadratsize,
quadratshape,
groundcoverquadpctave,
recwlupdated,
recuseriidref,
transectgroundcoveriid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin transectgroundcover".
USING transectgroundcover
'vegtransectiidref',
'seqnum',
'groundcovertype',
'groundcoverptcount',
'groundcoverptpct',
'quadratsize',
'quadratshape',
'groundcoverquadpctave',
'recwlupdated',
'recuseriidref',
'transectgroundcoveriid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: transectgroundcoverdatalegacy ---- Transect Ground Cover Data - Legacy

ACCEPT pedonid_list.
EXEC SQL SELECT

transectgroundcoverdatalegacy.vegtransectiidref/1 AS vegtransectiidref,
transectgroundcoverdatalegacy.seqnum AS seqnum,
transectgroundcoverdatalegacy.quadratnumber AS quadratnumber,
transectgroundcoverdatalegacy.quadratbaregrpct AS quadratbaregrpct,
transectgroundcoverdatalegacy.quadratcancovpct AS quadratcancovpct,
transectgroundcoverdatalegacy.quadratrockfragcovpct AS quadratrockfragcovpct,
transectgroundcoverdatalegacy.quadratmulchwt AS quadratmulchwt,
transectgroundcoverdatalegacy.recwlupdated AS recwlupdated,
transectgroundcoverdatalegacy.recuseriidref/1 AS recuseriidref,
transectgroundcoverdatalegacy.transgrcovlegacydataiid/1 AS transgrcovlegacydataiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN transectgroundcoverdatalegacy ON transectgroundcoverdatalegacy.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE transectgroundcoverdatalegacy WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin transectgroundcoverdatalegacy".
END SECTION.

SECTION HEADING
USING transectgroundcoverdatalegacy
'vegtransectiidref',
'seqnum',
'quadratnumber',
'quadratbaregrpct',
'quadratcancovpct',
'quadratrockfragcovpct',
'quadratmulchwt',
'recwlupdated',
'recuseriidref',
'transgrcovlegacydataiid'.

DATA
USING transectgroundcoverdatalegacy
vegtransectiidref,
seqnum,
quadratnumber,
quadratbaregrpct,
quadratcancovpct,
quadratrockfragcovpct,
quadratmulchwt,
recwlupdated,
recuseriidref,
transgrcovlegacydataiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin transectgroundcoverdatalegacy".
USING transectgroundcoverdatalegacy
'vegtransectiidref',
'seqnum',
'quadratnumber',
'quadratbaregrpct',
'quadratcancovpct',
'quadratrockfragcovpct',
'quadratmulchwt',
'recwlupdated',
'recuseriidref',
'transgrcovlegacydataiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: transectgroundsurfcover ---- Transect Ground Surface Cover

ACCEPT pedonid_list.
EXEC SQL SELECT

transectgroundsurfcover.vegtransectiidref/1 AS vegtransectiidref,
transectgroundsurfcover.seqnum AS seqnum,
CODELABEL (groundsurfcovtype) AS groundsurfcovtype,
transectgroundsurfcover.groundcoverptcount AS groundcoverptcount,
transectgroundsurfcover.groundcoverptpct AS groundcoverptpct,
transectgroundsurfcover.quadratsize AS quadratsize,
CODELABEL (quadratshape) AS quadratshape,
transectgroundsurfcover.groundcoverquadpctave AS groundcoverquadpctave,
transectgroundsurfcover.recwlupdated AS recwlupdated,
transectgroundsurfcover.recuseriidref/1 AS recuseriidref,
transectgroundsurfcover.transectgroundsurfcoveriid/1 AS transectgroundsurfcoveriid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN transectgroundsurfcover ON transectgroundsurfcover.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE transectgroundsurfcover WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin transectgroundsurfcover".
END SECTION.

SECTION HEADING
USING transectgroundsurfcover
'vegtransectiidref',
'seqnum',
'groundsurfcovtype',
'groundcoverptcount',
'groundcoverptpct',
'quadratsize',
'quadratshape',
'groundcoverquadpctave',
'recwlupdated',
'recuseriidref',
'transectgroundsurfcoveriid'.

DATA
USING transectgroundsurfcover
vegtransectiidref,
seqnum,
groundsurfcovtype,
groundcoverptcount,
groundcoverptpct,
quadratsize,
quadratshape,
groundcoverquadpctave,
recwlupdated,
recuseriidref,
transectgroundsurfcoveriid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin transectgroundsurfcover".
USING transectgroundsurfcover
'vegtransectiidref',
'seqnum',
'groundsurfcovtype',
'groundcoverptcount',
'groundcoverptpct',
'quadratsize',
'quadratshape',
'groundcoverquadpctave',
'recwlupdated',
'recuseriidref',
'transectgroundsurfcoveriid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: transectoverstorycanopycover ---- Transect Overstory Canopy Cover

ACCEPT pedonid_list.
EXEC SQL SELECT

transectoverstorycanopycover.vegtransectiidref/1 AS vegtransectiidref,
transectoverstorycanopycover.seqnum AS seqnum,
transectoverstorycanopycover.transectpointlocation AS transectpointlocation,
transectoverstorycanopycover.overstorycanopypresent AS overstorycanopypresent,
transectoverstorycanopycover.densiometerquadscovered AS densiometerquadscovered,
transectoverstorycanopycover.overstorycancovpctpoint AS overstorycancovpctpoint,
CODELABEL (overstorycancovclpoint) AS overstorycancovclpoint,
transectoverstorycanopycover.recwlupdated AS recwlupdated,
transectoverstorycanopycover.recuseriidref/1 AS recuseriidref,
transectoverstorycanopycover.transoverstorycancoviid/1 AS transoverstorycancoviid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN transectoverstorycanopycover ON transectoverstorycanopycover.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE transectoverstorycanopycover WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin transectoverstorycanopycover".
END SECTION.

SECTION HEADING
USING transectoverstorycanopycover
'vegtransectiidref',
'seqnum',
'transectpointlocation',
'overstorycanopypresent',
'densiometerquadscovered',
'overstorycancovpctpoint',
'overstorycancovclpoint',
'recwlupdated',
'recuseriidref',
'transoverstorycancoviid'.

DATA
USING transectoverstorycanopycover
vegtransectiidref,
seqnum,
transectpointlocation,
overstorycanopypresent,
densiometerquadscovered,
overstorycancovpctpoint,
overstorycancovclpoint,
recwlupdated,
recuseriidref,
transoverstorycancoviid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin transectoverstorycanopycover".
USING transectoverstorycanopycover
'vegtransectiidref',
'seqnum',
'transectpointlocation',
'overstorycanopypresent',
'densiometerquadscovered',
'overstorycancovpctpoint',
'overstorycancovclpoint',
'recwlupdated',
'recuseriidref',
'transoverstorycancoviid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: transectrefecmdoc ---- Transect Reference ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

transectrefecmdoc.tsectiidref/1 AS tsectiidref,
transectrefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
transectrefecmdoc.ecmdocname AS ecmdocname,
transectrefecmdoc.ecmdockeyurl AS ecmdockeyurl,
transectrefecmdoc.recwlupdated AS recwlupdated,
transectrefecmdoc.recuseriidref/1 AS recuseriidref,
transectrefecmdoc.transectrefecmdociid/1 AS transectrefecmdociid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN transect ON transect.grpiidref,tsectdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN transectrefecmdoc ON transectrefecmdoc.tsectiidref=transect.tsectiid;.

TEMPLATE transectrefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin transectrefecmdoc".
END SECTION.

SECTION HEADING
USING transectrefecmdoc
'tsectiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'transectrefecmdociid'.

DATA
USING transectrefecmdoc
tsectiidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
transectrefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin transectrefecmdoc".
USING transectrefecmdoc
'tsectiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'transectrefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: transectsamplingprotocolused ---- Transect Sampling Protocol Used

ACCEPT pedonid_list.
EXEC SQL SELECT

transectsamplingprotocolused.vegtransectiidref/1 AS vegtransectiidref,
transectsamplingprotocolused.seqnum AS seqnum,
CODELABEL (transsampprotocolname) AS transsampprotocolname,
transectsamplingprotocolused.datacollector AS datacollector,
transectsamplingprotocolused.datarecorder AS datarecorder,
CODELABEL (samplingintensity) AS samplingintensity,
transectsamplingprotocolused.recwlupdated AS recwlupdated,
transectsamplingprotocolused.recuseriidref/1 AS recuseriidref,
transectsamplingprotocolused.transsampprotocolusediid/1 AS transsampprotocolusediid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN transectsamplingprotocolused ON transectsamplingprotocolused.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE transectsamplingprotocolused WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin transectsamplingprotocolused".
END SECTION.

SECTION HEADING
USING transectsamplingprotocolused
'vegtransectiidref',
'seqnum',
'transsampprotocolname',
'datacollector',
'datarecorder',
'samplingintensity',
'recwlupdated',
'recuseriidref',
'transsampprotocolusediid'.

DATA
USING transectsamplingprotocolused
vegtransectiidref,
seqnum,
transsampprotocolname,
datacollector,
datarecorder,
samplingintensity,
recwlupdated,
recuseriidref,
transsampprotocolusediid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin transectsamplingprotocolused".
USING transectsamplingprotocolused
'vegtransectiidref',
'seqnum',
'transsampprotocolname',
'datacollector',
'datarecorder',
'samplingintensity',
'recwlupdated',
'recuseriidref',
'transsampprotocolusediid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: transectstandingbiomassdetails ---- Transect Standing Biomass Details

ACCEPT pedonid_list.
EXEC SQL SELECT

transectstandingbiomassdetails.vegtransectiidref/1 AS vegtransectiidref,
transectstandingbiomassdetails.seqnum AS seqnum,
transectstandingbiomassdetails.quadratnumber AS quadratnumber,
transectstandingbiomassdetails.transectpointlocation AS transectpointlocation,
transectstandingbiomassdetails.quadratsize AS quadratsize,
CODELABEL (quadratshape) AS quadratshape,
transectstandingbiomassdetails.herbbiomasswtgreen AS herbbiomasswtgreen,
transectstandingbiomassdetails.herbbiomasswtairdry AS herbbiomasswtairdry,
transectstandingbiomassdetails.recwlupdated AS recwlupdated,
transectstandingbiomassdetails.recuseriidref/1 AS recuseriidref,
transectstandingbiomassdetails.transstandbiomassdetailiid/1 AS transstandbiomassdetailiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN transectstandingbiomassdetails ON transectstandingbiomassdetails.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE transectstandingbiomassdetails WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin transectstandingbiomassdetails".
END SECTION.

SECTION HEADING
USING transectstandingbiomassdetails
'vegtransectiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'quadratsize',
'quadratshape',
'herbbiomasswtgreen',
'herbbiomasswtairdry',
'recwlupdated',
'recuseriidref',
'transstandbiomassdetailiid'.

DATA
USING transectstandingbiomassdetails
vegtransectiidref,
seqnum,
quadratnumber,
transectpointlocation,
quadratsize,
quadratshape,
herbbiomasswtgreen,
herbbiomasswtairdry,
recwlupdated,
recuseriidref,
transstandbiomassdetailiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin transectstandingbiomassdetails".
USING transectstandingbiomassdetails
'vegtransectiidref',
'seqnum',
'quadratnumber',
'transectpointlocation',
'quadratsize',
'quadratshape',
'herbbiomasswtgreen',
'herbbiomasswtairdry',
'recwlupdated',
'recuseriidref',
'transstandbiomassdetailiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: vegplot ---- Vegetation Plot

ACCEPT pedonid_list.
EXEC SQL SELECT

vegplot.siteobsiidref AS siteobsiidref,
vegplot.vegplotid AS vegplotid,
vegplot.vegplotname AS vegplotname,
vegplot.primarydatacollector AS primarydatacollector,
vegplot.datacollectionpurpose AS datacollectionpurpose,
CODELABEL (vegdataorigin) AS vegdataorigin,
vegplot.soilprofileindicator AS soilprofileindicator,
vegplot.assocuserpedonid AS assocuserpedonid,
vegplot.soil232idlegacy AS soil232idlegacy,
vegplot.ahorizondepth AS ahorizondepth,
CODELABEL (alkalinesalineindicator) AS alkalinesalineindicator,
vegplot.alkalineaffected AS alkalineaffected,
CODELABEL (salinityclass) AS salinityclass,
vegplot.restrictivelayerdepthlegacy AS restrictivelayerdepthlegacy,
vegplot.legacysoilcompname AS legacysoilcompname,
vegplot.legacysoilphase AS legacysoilphase,
vegplot.legacylocalsoilphase AS legacylocalsoilphase,
CODELABEL (legacysoilsurftext) AS legacysoilsurftext,
CODELABEL (legacysurftextmod) AS legacysurftextmod,
CODELABEL (legacyterminlieu) AS legacyterminlieu,
CODELABEL (erosionclasslegacy) AS erosionclasslegacy,
CODELABEL (landformgrouplegacy) AS landformgrouplegacy,
CODELABEL (cryptogamcovcllegacy) AS cryptogamcovcllegacy,
CODELABEL (rangelandusehistory) AS rangelandusehistory,
vegplot.cancovpctplotave AS cancovpctplotave,
vegplot.cancovtotalpct AS cancovtotalpct,
CODELABEL (cancovtotalclass) AS cancovtotalclass,
vegplot.overstorycancontotalpct AS overstorycancontotalpct,
CODELABEL (overstorycancovtotalclass) AS overstorycancovtotalclass,
vegplot.dblsampannualprodave AS dblsampannualprodave,
vegplot.compyieldproductionave AS compyieldproductionave,
vegplot.abovegroundbiomasstotave AS abovegroundbiomasstotave,
CODELABEL (understoryreprodabundance) AS understoryreprodabundance,
CODELABEL (woodyunderstoryabundance) AS woodyunderstoryabundance,
CODELABEL (herbundertoryabundance) AS herbundertoryabundance,
CODELABEL (lichensunderstoryabundance) AS lichensunderstoryabundance,
vegplot.crowncanclosurepct AS crowncanclosurepct,
CODELABEL (crowncancloseassessmethod) AS crowncancloseassessmethod,
vegplot.crowncompfactorlpp AS crowncompfactorlpp,
vegplot.crowncomplppavedbh AS crowncomplppavedbh,
vegplot.basalcoverpctave AS basalcoverpctave,
vegplot.basalareaplottotal AS basalareaplottotal,
CODELABEL (basalareaassessmethod) AS basalareaassessmethod,
CODELABEL (constreeshrubgrp) AS constreeshrubgrp,
CODELABEL (windbreakrowonedirection) AS windbreakrowonedirection,
vegplot.windbreaktrappedsoildepth AS windbreaktrappedsoildepth,
CODELABEL (windbreaktrappedsoiltexture) AS windbreaktrappedsoiltexture,
vegplot.understorydescindicator AS understorydescindicator,
vegplot.mensurationdataindicator AS mensurationdataindicator,
CODELABEL (vigorclasslegacy) AS vigorclasslegacy,
vegplot.siteconditionlegacy AS siteconditionlegacy,
vegplot.overstoryspecieslegacy AS overstoryspecieslegacy,
CODELABEL (plantmoiststate) AS plantmoiststate,
vegplot.currenttreedensity AS currenttreedensity,
vegplot.currenttreespacing AS currenttreespacing,
vegplot.currentdxspacing AS currentdxspacing,
vegplot.currentplotavedbh AS currentplotavedbh,
CODELABEL (plotbasalareafactor) AS plotbasalareafactor,
vegplot.currentbasalarea AS currentbasalarea,
CODELABEL (foreststandtype) AS foreststandtype,
CODELABEL (foreststratainventoried) AS foreststratainventoried,
CODELABEL (foreststandregen) AS foreststandregen,
CODELABEL (foreststandquality) AS foreststandquality,
vegplot.desiredtreedensity AS desiredtreedensity,
vegplot.desireddxspacing AS desireddxspacing,
vegplot.desiredbasalarea AS desiredbasalarea,
vegplot.excessbasalarea AS excessbasalarea,
vegplot.excesstreedensity AS excesstreedensity,
vegplot.stockingchangepct AS stockingchangepct,
vegplot.treepctgoodcondition AS treepctgoodcondition,
vegplot.treepctfaircondition AS treepctfaircondition,
vegplot.treepctpoorcondition AS treepctpoorcondition,
vegplot.treecounttotal AS treecounttotal,
vegplot.treesnagdensityhard AS treesnagdensityhard,
vegplot.treesnagdensitysoft AS treesnagdensitysoft,
CODELABEL (rhiannualprod) AS rhiannualprod,
CODELABEL (rhibareground) AS rhibareground,
CODELABEL (rhicompactionlayer) AS rhicompactionlayer,
CODELABEL (rhifuncstructgroups) AS rhifuncstructgroups,
CODELABEL (rhierosionresistance) AS rhierosionresistance,
CODELABEL (rhigullies) AS rhigullies,
CODELABEL (rhirills) AS rhirills,
CODELABEL (rhipedastalsterracettes) AS rhipedastalsterracettes,
CODELABEL (rhiinfilrunoff) AS rhiinfilrunoff,
CODELABEL (rhilitteramount) AS rhilitteramount,
CODELABEL (rhilittermovement) AS rhilittermovement,
CODELABEL (rhiplantmortality) AS rhiplantmortality,
CODELABEL (rhireprodcapability) AS rhireprodcapability,
CODELABEL (rhiinvasiveplants) AS rhiinvasiveplants,
CODELABEL (rhisoilsurfdegradation) AS rhisoilsurfdegradation,
CODELABEL (rhiwaterflowpatterns) AS rhiwaterflowpatterns,
CODELABEL (rhiwindscourareas) AS rhiwindscourareas,
CODELABEL (rhisoilsitestabsumm) AS rhisoilsitestabsumm,
CODELABEL (rhibioticintegritysumm) AS rhibioticintegritysumm,
CODELABEL (rhihydrofunctionsumm) AS rhihydrofunctionsumm,
vegplot.pastureforagetype AS pastureforagetype,
vegplot.pasturestanddensityave AS pasturestanddensityave,
vegplot.pastureplanthtave AS pastureplanthtave,
vegplot.pastureprodave AS pastureprodave,
CODELABEL (pcidesirableplants) AS pcidesirableplants,
CODELABEL (pciplantcover) AS pciplantcover,
CODELABEL (pciplantdiversity) AS pciplantdiversity,
CODELABEL (pcigroundcovresidue) AS pcigroundcovresidue,
CODELABEL (pcistandingdeadforage) AS pcistandingdeadforage,
vegplot.pciplantresiduecompscore AS pciplantresiduecompscore,
CODELABEL (pciplantvigor) AS pciplantvigor,
CODELABEL (pcilegumepctclass) AS pcilegumepctclass,
CODELABEL (pciuseuniformity) AS pciuseuniformity,
CODELABEL (pcilivestockconcareas) AS pcilivestockconcareas,
CODELABEL (pcisoilcompaction) AS pcisoilcompaction,
CODELABEL (pcisheetrillerosion) AS pcisheetrillerosion,
CODELABEL (pciwinderosion) AS pciwinderosion,
CODELABEL (pcistreamshoreerosion) AS pcistreamshoreerosion,
CODELABEL (pcigullyerosion) AS pcigullyerosion,
vegplot.pcierosioncompscore AS pcierosioncompscore,
vegplot.pcipastureconditionscore AS pcipastureconditionscore,
vegplot.refplantcommunity AS refplantcommunity,
vegplot.repannualprod AS repannualprod,
vegplot.totestannualprod AS totestannualprod,
vegplot.totallowableannualprod AS totallowableannualprod,
vegplot.totpalatableannualprod AS totpalatableannualprod,
vegplot.similarityindex AS similarityindex,
vegplot.annualuseableprod AS annualuseableprod,
vegplot.harvesteffpct AS harvesteffpct,
vegplot.takehalfleavehalf AS takehalfleavehalf,
vegplot.acresperaum AS acresperaum,
vegplot.aumperacre AS aumperacre,
vegplot.audperacre AS audperacre,
CODELABEL (desirableplantvigor) AS desirableplantvigor,
CODELABEL (desirableseedlingabundance) AS desirableseedlingabundance,
CODELABEL (decadentplantabundance) AS decadentplantabundance,
CODELABEL (plantresidueadequacy) AS plantresidueadequacy,
CODELABEL (undesirableinvadingspecies) AS undesirableinvadingspecies,
vegplot.majorinvadingspecies AS majorinvadingspecies,
vegplot.invadingspeciescancovpct AS invadingspeciescancovpct,
CODELABEL (soilsurferosion) AS soilsurferosion,
CODELABEL (soilcrusting) AS soilcrusting,
CODELABEL (soilcompaction) AS soilcompaction,
vegplot.baregroundpct AS baregroundpct,
CODELABEL (gullyrillpresence) AS gullyrillpresence,
CODELABEL (soildegradationrating) AS soildegradationrating,
CODELABEL (rangetrendcurrent) AS rangetrendcurrent,
CODELABEL (rangetrendplanned) AS rangetrendplanned,
vegplot.qcreviewperson AS qcreviewperson,
vegplot.qcreviewdate AS qcreviewdate,
vegplot.qareviewperson AS qareviewperson,
vegplot.qareviewdate AS qareviewdate,
vegplot.swcdlegacy AS swcdlegacy,
vegplot.fieldofficelegacy AS fieldofficelegacy,
vegplot.nrcsarealegacy AS nrcsarealegacy,
vegplot.aktotallichencoverpct AS aktotallichencoverpct,
vegplot.aktotallitter1coverpct AS aktotallitter1coverpct,
vegplot.aktotallitter2coverpct AS aktotallitter2coverpct,
vegplot.aktotalmosscoverpct AS aktotalmosscoverpct,
vegplot.aktotalrockcoverpct AS aktotalrockcoverpct,
vegplot.aktotalsoilcoverpct AS aktotalsoilcoverpct,
vegplot.aktotalwatercoverpct AS aktotalwatercoverpct,
CODELABEL (akecologicalsitestatus) AS akecologicalsitestatus,
vegplot.aktotalbedrockcoverpct AS aktotalbedrockcoverpct,
vegplot.akfieldecositeid AS akfieldecositeid,
CODELABEL (obsintensity) AS obsintensity,
vegplot.vegplotdbiidref AS vegplotdbiidref,
vegplot.grpiidref AS grpiidref,
vegplot.objwlupdated AS objwlupdated,
vegplot.objuseriidref AS objuseriidref,
vegplot.recwlupdated AS recwlupdated,
vegplot.recuseriidref/1 AS recuseriidref,
vegplot.vegplotiid/1 AS vegplotiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
TEMPLATE vegplot WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin vegplot".
END SECTION.

SECTION HEADING
USING vegplot
'siteobsiidref',
'vegplotid',
'vegplotname',
'primarydatacollector',
'datacollectionpurpose',
'vegdataorigin',
'soilprofileindicator',
'assocuserpedonid',
'soil232idlegacy',
'ahorizondepth',
'alkalinesalineindicator',
'alkalineaffected',
'salinityclass',
'restrictivelayerdepthlegacy',
'legacysoilcompname',
'legacysoilphase',
'legacylocalsoilphase',
'legacysoilsurftext',
'legacysurftextmod',
'legacyterminlieu',
'erosionclasslegacy',
'landformgrouplegacy',
'cryptogamcovcllegacy',
'rangelandusehistory',
'cancovpctplotave',
'cancovtotalpct',
'cancovtotalclass',
'overstorycancontotalpct',
'overstorycancovtotalclass',
'dblsampannualprodave',
'compyieldproductionave',
'abovegroundbiomasstotave',
'understoryreprodabundance',
'woodyunderstoryabundance',
'herbundertoryabundance',
'lichensunderstoryabundance',
'crowncanclosurepct',
'crowncancloseassessmethod',
'crowncompfactorlpp',
'crowncomplppavedbh',
'basalcoverpctave',
'basalareaplottotal',
'basalareaassessmethod',
'constreeshrubgrp',
'windbreakrowonedirection',
'windbreaktrappedsoildepth',
'windbreaktrappedsoiltexture',
'understorydescindicator',
'mensurationdataindicator',
'vigorclasslegacy',
'siteconditionlegacy',
'overstoryspecieslegacy',
'plantmoiststate',
'currenttreedensity',
'currenttreespacing',
'currentdxspacing',
'currentplotavedbh',
'plotbasalareafactor',
'currentbasalarea',
'foreststandtype',
'foreststratainventoried',
'foreststandregen',
'foreststandquality',
'desiredtreedensity',
'desireddxspacing',
'desiredbasalarea',
'excessbasalarea',
'excesstreedensity',
'stockingchangepct',
'treepctgoodcondition',
'treepctfaircondition',
'treepctpoorcondition',
'treecounttotal',
'treesnagdensityhard',
'treesnagdensitysoft',
'rhiannualprod',
'rhibareground',
'rhicompactionlayer',
'rhifuncstructgroups',
'rhierosionresistance',
'rhigullies',
'rhirills',
'rhipedastalsterracettes',
'rhiinfilrunoff',
'rhilitteramount',
'rhilittermovement',
'rhiplantmortality',
'rhireprodcapability',
'rhiinvasiveplants',
'rhisoilsurfdegradation',
'rhiwaterflowpatterns',
'rhiwindscourareas',
'rhisoilsitestabsumm',
'rhibioticintegritysumm',
'rhihydrofunctionsumm',
'pastureforagetype',
'pasturestanddensityave',
'pastureplanthtave',
'pastureprodave',
'pcidesirableplants',
'pciplantcover',
'pciplantdiversity',
'pcigroundcovresidue',
'pcistandingdeadforage',
'pciplantresiduecompscore',
'pciplantvigor',
'pcilegumepctclass',
'pciuseuniformity',
'pcilivestockconcareas',
'pcisoilcompaction',
'pcisheetrillerosion',
'pciwinderosion',
'pcistreamshoreerosion',
'pcigullyerosion',
'pcierosioncompscore',
'pcipastureconditionscore',
'refplantcommunity',
'repannualprod',
'totestannualprod',
'totallowableannualprod',
'totpalatableannualprod',
'similarityindex',
'annualuseableprod',
'harvesteffpct',
'takehalfleavehalf',
'acresperaum',
'aumperacre',
'audperacre',
'desirableplantvigor',
'desirableseedlingabundance',
'decadentplantabundance',
'plantresidueadequacy',
'undesirableinvadingspecies',
'majorinvadingspecies',
'invadingspeciescancovpct',
'soilsurferosion',
'soilcrusting',
'soilcompaction',
'baregroundpct',
'gullyrillpresence',
'soildegradationrating',
'rangetrendcurrent',
'rangetrendplanned',
'qcreviewperson',
'qcreviewdate',
'qareviewperson',
'qareviewdate',
'swcdlegacy',
'fieldofficelegacy',
'nrcsarealegacy',
'aktotallichencoverpct',
'aktotallitter1coverpct',
'aktotallitter2coverpct',
'aktotalmosscoverpct',
'aktotalrockcoverpct',
'aktotalsoilcoverpct',
'aktotalwatercoverpct',
'akecologicalsitestatus',
'aktotalbedrockcoverpct',
'akfieldecositeid',
'obsintensity',
'vegplotdbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'vegplotiid'.

DATA
USING vegplot
siteobsiidref,
vegplotid,
vegplotname,
primarydatacollector,
datacollectionpurpose,
vegdataorigin,
soilprofileindicator,
assocuserpedonid,
soil232idlegacy,
ahorizondepth,
alkalinesalineindicator,
alkalineaffected,
salinityclass,
restrictivelayerdepthlegacy,
legacysoilcompname,
legacysoilphase,
legacylocalsoilphase,
legacysoilsurftext,
legacysurftextmod,
legacyterminlieu,
erosionclasslegacy,
landformgrouplegacy,
cryptogamcovcllegacy,
rangelandusehistory,
cancovpctplotave,
cancovtotalpct,
cancovtotalclass,
overstorycancontotalpct,
overstorycancovtotalclass,
dblsampannualprodave,
compyieldproductionave,
abovegroundbiomasstotave,
understoryreprodabundance,
woodyunderstoryabundance,
herbundertoryabundance,
lichensunderstoryabundance,
crowncanclosurepct,
crowncancloseassessmethod,
crowncompfactorlpp,
crowncomplppavedbh,
basalcoverpctave,
basalareaplottotal,
basalareaassessmethod,
constreeshrubgrp,
windbreakrowonedirection,
windbreaktrappedsoildepth,
windbreaktrappedsoiltexture,
understorydescindicator,
mensurationdataindicator,
vigorclasslegacy,
siteconditionlegacy,
overstoryspecieslegacy,
plantmoiststate,
currenttreedensity,
currenttreespacing,
currentdxspacing,
currentplotavedbh,
plotbasalareafactor,
currentbasalarea,
foreststandtype,
foreststratainventoried,
foreststandregen,
foreststandquality,
desiredtreedensity,
desireddxspacing,
desiredbasalarea,
excessbasalarea,
excesstreedensity,
stockingchangepct,
treepctgoodcondition,
treepctfaircondition,
treepctpoorcondition,
treecounttotal,
treesnagdensityhard,
treesnagdensitysoft,
rhiannualprod,
rhibareground,
rhicompactionlayer,
rhifuncstructgroups,
rhierosionresistance,
rhigullies,
rhirills,
rhipedastalsterracettes,
rhiinfilrunoff,
rhilitteramount,
rhilittermovement,
rhiplantmortality,
rhireprodcapability,
rhiinvasiveplants,
rhisoilsurfdegradation,
rhiwaterflowpatterns,
rhiwindscourareas,
rhisoilsitestabsumm,
rhibioticintegritysumm,
rhihydrofunctionsumm,
pastureforagetype,
pasturestanddensityave,
pastureplanthtave,
pastureprodave,
pcidesirableplants,
pciplantcover,
pciplantdiversity,
pcigroundcovresidue,
pcistandingdeadforage,
pciplantresiduecompscore,
pciplantvigor,
pcilegumepctclass,
pciuseuniformity,
pcilivestockconcareas,
pcisoilcompaction,
pcisheetrillerosion,
pciwinderosion,
pcistreamshoreerosion,
pcigullyerosion,
pcierosioncompscore,
pcipastureconditionscore,
refplantcommunity,
repannualprod,
totestannualprod,
totallowableannualprod,
totpalatableannualprod,
similarityindex,
annualuseableprod,
harvesteffpct,
takehalfleavehalf,
acresperaum,
aumperacre,
audperacre,
desirableplantvigor,
desirableseedlingabundance,
decadentplantabundance,
plantresidueadequacy,
undesirableinvadingspecies,
majorinvadingspecies,
invadingspeciescancovpct,
soilsurferosion,
soilcrusting,
soilcompaction,
baregroundpct,
gullyrillpresence,
soildegradationrating,
rangetrendcurrent,
rangetrendplanned,
qcreviewperson,
qcreviewdate,
qareviewperson,
qareviewdate,
swcdlegacy,
fieldofficelegacy,
nrcsarealegacy,
aktotallichencoverpct,
aktotallitter1coverpct,
aktotallitter2coverpct,
aktotalmosscoverpct,
aktotalrockcoverpct,
aktotalsoilcoverpct,
aktotalwatercoverpct,
akecologicalsitestatus,
aktotalbedrockcoverpct,
akfieldecositeid,
obsintensity,
vegplotdbiidref,
grpiidref,
objwlupdated,
objuseriidref,
recwlupdated,
recuseriidref,
vegplotiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin vegplot".
USING vegplot
'siteobsiidref',
'vegplotid',
'vegplotname',
'primarydatacollector',
'datacollectionpurpose',
'vegdataorigin',
'soilprofileindicator',
'assocuserpedonid',
'soil232idlegacy',
'ahorizondepth',
'alkalinesalineindicator',
'alkalineaffected',
'salinityclass',
'restrictivelayerdepthlegacy',
'legacysoilcompname',
'legacysoilphase',
'legacylocalsoilphase',
'legacysoilsurftext',
'legacysurftextmod',
'legacyterminlieu',
'erosionclasslegacy',
'landformgrouplegacy',
'cryptogamcovcllegacy',
'rangelandusehistory',
'cancovpctplotave',
'cancovtotalpct',
'cancovtotalclass',
'overstorycancontotalpct',
'overstorycancovtotalclass',
'dblsampannualprodave',
'compyieldproductionave',
'abovegroundbiomasstotave',
'understoryreprodabundance',
'woodyunderstoryabundance',
'herbundertoryabundance',
'lichensunderstoryabundance',
'crowncanclosurepct',
'crowncancloseassessmethod',
'crowncompfactorlpp',
'crowncomplppavedbh',
'basalcoverpctave',
'basalareaplottotal',
'basalareaassessmethod',
'constreeshrubgrp',
'windbreakrowonedirection',
'windbreaktrappedsoildepth',
'windbreaktrappedsoiltexture',
'understorydescindicator',
'mensurationdataindicator',
'vigorclasslegacy',
'siteconditionlegacy',
'overstoryspecieslegacy',
'plantmoiststate',
'currenttreedensity',
'currenttreespacing',
'currentdxspacing',
'currentplotavedbh',
'plotbasalareafactor',
'currentbasalarea',
'foreststandtype',
'foreststratainventoried',
'foreststandregen',
'foreststandquality',
'desiredtreedensity',
'desireddxspacing',
'desiredbasalarea',
'excessbasalarea',
'excesstreedensity',
'stockingchangepct',
'treepctgoodcondition',
'treepctfaircondition',
'treepctpoorcondition',
'treecounttotal',
'treesnagdensityhard',
'treesnagdensitysoft',
'rhiannualprod',
'rhibareground',
'rhicompactionlayer',
'rhifuncstructgroups',
'rhierosionresistance',
'rhigullies',
'rhirills',
'rhipedastalsterracettes',
'rhiinfilrunoff',
'rhilitteramount',
'rhilittermovement',
'rhiplantmortality',
'rhireprodcapability',
'rhiinvasiveplants',
'rhisoilsurfdegradation',
'rhiwaterflowpatterns',
'rhiwindscourareas',
'rhisoilsitestabsumm',
'rhibioticintegritysumm',
'rhihydrofunctionsumm',
'pastureforagetype',
'pasturestanddensityave',
'pastureplanthtave',
'pastureprodave',
'pcidesirableplants',
'pciplantcover',
'pciplantdiversity',
'pcigroundcovresidue',
'pcistandingdeadforage',
'pciplantresiduecompscore',
'pciplantvigor',
'pcilegumepctclass',
'pciuseuniformity',
'pcilivestockconcareas',
'pcisoilcompaction',
'pcisheetrillerosion',
'pciwinderosion',
'pcistreamshoreerosion',
'pcigullyerosion',
'pcierosioncompscore',
'pcipastureconditionscore',
'refplantcommunity',
'repannualprod',
'totestannualprod',
'totallowableannualprod',
'totpalatableannualprod',
'similarityindex',
'annualuseableprod',
'harvesteffpct',
'takehalfleavehalf',
'acresperaum',
'aumperacre',
'audperacre',
'desirableplantvigor',
'desirableseedlingabundance',
'decadentplantabundance',
'plantresidueadequacy',
'undesirableinvadingspecies',
'majorinvadingspecies',
'invadingspeciescancovpct',
'soilsurferosion',
'soilcrusting',
'soilcompaction',
'baregroundpct',
'gullyrillpresence',
'soildegradationrating',
'rangetrendcurrent',
'rangetrendplanned',
'qcreviewperson',
'qcreviewdate',
'qareviewperson',
'qareviewdate',
'swcdlegacy',
'fieldofficelegacy',
'nrcsarealegacy',
'aktotallichencoverpct',
'aktotallitter1coverpct',
'aktotallitter2coverpct',
'aktotalmosscoverpct',
'aktotalrockcoverpct',
'aktotalsoilcoverpct',
'aktotalwatercoverpct',
'akecologicalsitestatus',
'aktotalbedrockcoverpct',
'akfieldecositeid',
'obsintensity',
'vegplotdbiidref',
'grpiidref',
'objwlupdated',
'objuseriidref',
'recwlupdated',
'recuseriidref',
'vegplotiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: vegplotrefecmdoc ---- Veg Plot Reference ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

vegplotrefecmdoc.vegplotiidref/1 AS vegplotiidref,
vegplotrefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
vegplotrefecmdoc.ecmdocname AS ecmdocname,
vegplotrefecmdoc.ecmdockeyurl AS ecmdockeyurl,
vegplotrefecmdoc.recwlupdated AS recwlupdated,
vegplotrefecmdoc.recuseriidref/1 AS recuseriidref,
vegplotrefecmdoc.vegplotrefecmdociid/1 AS vegplotrefecmdociid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegplotrefecmdoc ON vegplotrefecmdoc.vegplotiidref=vegplot.vegplotiid;.

TEMPLATE vegplotrefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin vegplotrefecmdoc".
END SECTION.

SECTION HEADING
USING vegplotrefecmdoc
'vegplotiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'vegplotrefecmdociid'.

DATA
USING vegplotrefecmdoc
vegplotiidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
vegplotrefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin vegplotrefecmdoc".
USING vegplotrefecmdoc
'vegplotiidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'vegplotrefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: vegplottext ---- Vegetation Plot Text

ACCEPT pedonid_list.
EXEC SQL SELECT

vegplottext.vegplotiidref/1 AS vegplotiidref,
vegplottext.seqnum AS seqnum,
vegplottext.recdate AS recdate,
vegplottext.recauthor AS recauthor,
CODELABEL (vegplottextkind) AS vegplottextkind,
vegplottext.textcat AS textcat,
vegplottext.textsubcat AS textsubcat,
vegplottext.textentry AS textentry,
vegplottext.recwlupdated AS recwlupdated,
vegplottext.recuseriidref/1 AS recuseriidref,
vegplottext.vegplottextiid/1 AS vegplottextiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegplottext ON vegplottext.vegplotiidref=vegplot.vegplotiid;.

TEMPLATE vegplottext WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin vegplottext".
END SECTION.

SECTION HEADING
USING vegplottext
'vegplotiidref',
'seqnum',
'recdate',
'recauthor',
'vegplottextkind',
'textcat',
'textsubcat',
'textentry',
'recwlupdated',
'recuseriidref',
'vegplottextiid'.

DATA
USING vegplottext
vegplotiidref,
seqnum,
recdate,
recauthor,
vegplottextkind,
textcat,
textsubcat,
textentry,
recwlupdated,
recuseriidref,
vegplottextiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin vegplottext".
USING vegplottext
'vegplotiidref',
'seqnum',
'recdate',
'recauthor',
'vegplottextkind',
'textcat',
'textsubcat',
'textentry',
'recwlupdated',
'recuseriidref',
'vegplottextiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: vegtransect ---- Vegetation Transect

ACCEPT pedonid_list.
EXEC SQL SELECT

vegtransect.vegplotiidref/1 AS vegplotiidref,
vegtransect.seqnum AS seqnum,
vegtransect.vegtransectid AS vegtransectid,
vegtransect.transectstartlatitude AS transectstartlatitude,
vegtransect.transectstartlongitude AS transectstartlongitude,
vegtransect.transectendlatitude AS transectendlatitude,
vegtransect.transectendlongitude AS transectendlongitude,
vegtransect.transectazimuth AS transectazimuth,
vegtransect.transectlength AS transectlength,
vegtransect.transectstartelevation AS transectstartelevation,
vegtransect.transectendelevation AS transectendelevation,
vegtransect.dblsampquadratssampled AS dblsampquadratssampled,
vegtransect.dblsampquadratsclipped AS dblsampquadratsclipped,
vegtransect.nestedfreqquadratssampled AS nestedfreqquadratssampled,
vegtransect.freqquadratssampled AS freqquadratssampled,
vegtransect.dwrquadratssampled AS dwrquadratssampled,
vegtransect.daubenmirequadratssampled AS daubenmirequadratssampled,
vegtransect.quadratsizedomlegacy AS quadratsizedomlegacy,
vegtransect.quadratsizeseclegacy AS quadratsizeseclegacy,
CODELABEL (quadratshapedomlegacy) AS quadratshapedomlegacy,
CODELABEL (quadratshapeseclegacy) AS quadratshapeseclegacy,
vegtransect.beltwidth AS beltwidth,
vegtransect.dblsampannualprod AS dblsampannualprod,
vegtransect.totharvestannualprod AS totharvestannualprod,
vegtransect.wtunitannualprod AS wtunitannualprod,
vegtransect.dwrannualprod AS dwrannualprod,
vegtransect.comparativeyieldprod AS comparativeyieldprod,
vegtransect.comparativeyieldranktotal AS comparativeyieldranktotal,
vegtransect.comparativeyieldrankave AS comparativeyieldrankave,
vegtransect.comparativerefclipwtave AS comparativerefclipwtave,
vegtransect.abovegroundbiomasstotal AS abovegroundbiomasstotal,
vegtransect.standingherbbiomass AS standingherbbiomass,
vegtransect.transectbasalcovpct AS transectbasalcovpct,
vegtransect.basalcovpcttotal AS basalcovpcttotal,
vegtransect.basalgapsizemin AS basalgapsizemin,
vegtransect.canopygapsizemin AS canopygapsizemin,
vegtransect.gapsmeasuredbetween AS gapsmeasuredbetween,
vegtransect.canopygaplengthtotal AS canopygaplengthtotal,
vegtransect.canopygappcttotal AS canopygappcttotal,
vegtransect.basalgaplengthtotal AS basalgaplengthtotal,
vegtransect.basalgappcttotal AS basalgappcttotal,
CODELABEL (understoryreprodabundance) AS understoryreprodabundance,
CODELABEL (woodyunderstoryabundance) AS woodyunderstoryabundance,
CODELABEL (herbundertoryabundance) AS herbundertoryabundance,
CODELABEL (lichensunderstoryabundance) AS lichensunderstoryabundance,
vegtransect.cancovpcttotaltrans AS cancovpcttotaltrans,
CODELABEL (cancovtotalclasstrans) AS cancovtotalclasstrans,
CODELABEL (cancovassessmethod) AS cancovassessmethod,
vegtransect.crowncanclosurepct AS crowncanclosurepct,
CODELABEL (crowncancloseassessmethod) AS crowncancloseassessmethod,
vegtransect.crowncompfactorlpp AS crowncompfactorlpp,
vegtransect.crowncomplppavedbh AS crowncomplppavedbh,
vegtransect.overstorycancovpcttrans AS overstorycancovpcttrans,
CODELABEL (overstorycancovclasstrans) AS overstorycancovclasstrans,
CODELABEL (groundcovassessmethod) AS groundcovassessmethod,
vegtransect.groundcovquadratssampled AS groundcovquadratssampled,
vegtransect.groundcovpointssampled AS groundcovpointssampled,
CODELABEL (groundsurfcovassessmethod) AS groundsurfcovassessmethod,
vegtransect.groundsurfcovquadratsamp AS groundsurfcovquadratsamp,
vegtransect.groundsurfcovpointssamp AS groundsurfcovpointssamp,
vegtransect.lpiobsinterval AS lpiobsinterval,
vegtransect.totalpointssampledcount AS totalpointssampledcount,
vegtransect.topcanopyhtave AS topcanopyhtave,
vegtransect.topcanopyhtstddev AS topcanopyhtstddev,
vegtransect.totalnumplantsbelt AS totalnumplantsbelt,
vegtransect.totalnumspeciesbelt AS totalnumspeciesbelt,
vegtransect.totalplantdensitybelt AS totalplantdensitybelt,
vegtransect.recwlupdated AS recwlupdated,
vegtransect.recuseriidref/1 AS recuseriidref,
vegtransect.vegtransectiid/1 AS vegtransectiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid;.

TEMPLATE vegtransect WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin vegtransect".
END SECTION.

SECTION HEADING
USING vegtransect
'vegplotiidref',
'seqnum',
'vegtransectid',
'transectstartlatitude',
'transectstartlongitude',
'transectendlatitude',
'transectendlongitude',
'transectazimuth',
'transectlength',
'transectstartelevation',
'transectendelevation',
'dblsampquadratssampled',
'dblsampquadratsclipped',
'nestedfreqquadratssampled',
'freqquadratssampled',
'dwrquadratssampled',
'daubenmirequadratssampled',
'quadratsizedomlegacy',
'quadratsizeseclegacy',
'quadratshapedomlegacy',
'quadratshapeseclegacy',
'beltwidth',
'dblsampannualprod',
'totharvestannualprod',
'wtunitannualprod',
'dwrannualprod',
'comparativeyieldprod',
'comparativeyieldranktotal',
'comparativeyieldrankave',
'comparativerefclipwtave',
'abovegroundbiomasstotal',
'standingherbbiomass',
'transectbasalcovpct',
'basalcovpcttotal',
'basalgapsizemin',
'canopygapsizemin',
'gapsmeasuredbetween',
'canopygaplengthtotal',
'canopygappcttotal',
'basalgaplengthtotal',
'basalgappcttotal',
'understoryreprodabundance',
'woodyunderstoryabundance',
'herbundertoryabundance',
'lichensunderstoryabundance',
'cancovpcttotaltrans',
'cancovtotalclasstrans',
'cancovassessmethod',
'crowncanclosurepct',
'crowncancloseassessmethod',
'crowncompfactorlpp',
'crowncomplppavedbh',
'overstorycancovpcttrans',
'overstorycancovclasstrans',
'groundcovassessmethod',
'groundcovquadratssampled',
'groundcovpointssampled',
'groundsurfcovassessmethod',
'groundsurfcovquadratsamp',
'groundsurfcovpointssamp',
'lpiobsinterval',
'totalpointssampledcount',
'topcanopyhtave',
'topcanopyhtstddev',
'totalnumplantsbelt',
'totalnumspeciesbelt',
'totalplantdensitybelt',
'recwlupdated',
'recuseriidref',
'vegtransectiid'.

DATA
USING vegtransect
vegplotiidref,
seqnum,
vegtransectid,
transectstartlatitude,
transectstartlongitude,
transectendlatitude,
transectendlongitude,
transectazimuth,
transectlength,
transectstartelevation,
transectendelevation,
dblsampquadratssampled,
dblsampquadratsclipped,
nestedfreqquadratssampled,
freqquadratssampled,
dwrquadratssampled,
daubenmirequadratssampled,
quadratsizedomlegacy,
quadratsizeseclegacy,
quadratshapedomlegacy,
quadratshapeseclegacy,
beltwidth,
dblsampannualprod,
totharvestannualprod,
wtunitannualprod,
dwrannualprod,
comparativeyieldprod,
comparativeyieldranktotal,
comparativeyieldrankave,
comparativerefclipwtave,
abovegroundbiomasstotal,
standingherbbiomass,
transectbasalcovpct,
basalcovpcttotal,
basalgapsizemin,
canopygapsizemin,
gapsmeasuredbetween,
canopygaplengthtotal,
canopygappcttotal,
basalgaplengthtotal,
basalgappcttotal,
understoryreprodabundance,
woodyunderstoryabundance,
herbundertoryabundance,
lichensunderstoryabundance,
cancovpcttotaltrans,
cancovtotalclasstrans,
cancovassessmethod,
crowncanclosurepct,
crowncancloseassessmethod,
crowncompfactorlpp,
crowncomplppavedbh,
overstorycancovpcttrans,
overstorycancovclasstrans,
groundcovassessmethod,
groundcovquadratssampled,
groundcovpointssampled,
groundsurfcovassessmethod,
groundsurfcovquadratsamp,
groundsurfcovpointssamp,
lpiobsinterval,
totalpointssampledcount,
topcanopyhtave,
topcanopyhtstddev,
totalnumplantsbelt,
totalnumspeciesbelt,
totalplantdensitybelt,
recwlupdated,
recuseriidref,
vegtransectiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin vegtransect".
USING vegtransect
'vegplotiidref',
'seqnum',
'vegtransectid',
'transectstartlatitude',
'transectstartlongitude',
'transectendlatitude',
'transectendlongitude',
'transectazimuth',
'transectlength',
'transectstartelevation',
'transectendelevation',
'dblsampquadratssampled',
'dblsampquadratsclipped',
'nestedfreqquadratssampled',
'freqquadratssampled',
'dwrquadratssampled',
'daubenmirequadratssampled',
'quadratsizedomlegacy',
'quadratsizeseclegacy',
'quadratshapedomlegacy',
'quadratshapeseclegacy',
'beltwidth',
'dblsampannualprod',
'totharvestannualprod',
'wtunitannualprod',
'dwrannualprod',
'comparativeyieldprod',
'comparativeyieldranktotal',
'comparativeyieldrankave',
'comparativerefclipwtave',
'abovegroundbiomasstotal',
'standingherbbiomass',
'transectbasalcovpct',
'basalcovpcttotal',
'basalgapsizemin',
'canopygapsizemin',
'gapsmeasuredbetween',
'canopygaplengthtotal',
'canopygappcttotal',
'basalgaplengthtotal',
'basalgappcttotal',
'understoryreprodabundance',
'woodyunderstoryabundance',
'herbundertoryabundance',
'lichensunderstoryabundance',
'cancovpcttotaltrans',
'cancovtotalclasstrans',
'cancovassessmethod',
'crowncanclosurepct',
'crowncancloseassessmethod',
'crowncompfactorlpp',
'crowncomplppavedbh',
'overstorycancovpcttrans',
'overstorycancovclasstrans',
'groundcovassessmethod',
'groundcovquadratssampled',
'groundcovpointssampled',
'groundsurfcovassessmethod',
'groundsurfcovquadratsamp',
'groundsurfcovpointssamp',
'lpiobsinterval',
'totalpointssampledcount',
'topcanopyhtave',
'topcanopyhtstddev',
'totalnumplantsbelt',
'totalnumspeciesbelt',
'totalplantdensitybelt',
'recwlupdated',
'recuseriidref',
'vegtransectiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: vegtransectplantsummary ---- Vegetation Transect Plant Summary

ACCEPT pedonid_list.
EXEC SQL SELECT

vegtransectplantsummary.vegtransectiidref/1 AS vegtransectiidref,
vegtransectplantsummary.seqnum AS seqnum,
vegtransectplantsummary.plantiidref AS plantiidref,
CODELABEL (plantnativity) AS plantnativity,
CODELABEL (planttypegroup) AS planttypegroup,
vegtransectplantsummary.plantheightcllowerlimit AS plantheightcllowerlimit,
vegtransectplantsummary.plantheightclupperlimit AS plantheightclupperlimit,
CODELABEL (sociabilityclass) AS sociabilityclass,
vegtransectplantsummary.specieslivecanhtbotave AS specieslivecanhtbotave,
vegtransectplantsummary.specieslivecanhttopave AS specieslivecanhttopave,
vegtransectplantsummary.overstorydbhmin AS overstorydbhmin,
vegtransectplantsummary.overstorydbhmax AS overstorydbhmax,
vegtransectplantsummary.speciesovercancovpct AS speciesovercancovpct,
CODELABEL (speciesovercancovclass) AS speciesovercancovclass,
vegtransectplantsummary.plantprodquadratsize AS plantprodquadratsize,
CODELABEL (plantprodquadratshape) AS plantprodquadratshape,
vegtransectplantsummary.nestedfreqquadratsize AS nestedfreqquadratsize,
CODELABEL (nestedfreqquadratshape) AS nestedfreqquadratshape,
vegtransectplantsummary.frequencyquadratsize AS frequencyquadratsize,
CODELABEL (frequencyquadratshape) AS frequencyquadratshape,
vegtransectplantsummary.dwrquadratsize AS dwrquadratsize,
CODELABEL (dwrquadratshape) AS dwrquadratshape,
vegtransectplantsummary.densityquadratsize AS densityquadratsize,
CODELABEL (densityquadratshape) AS densityquadratshape,
vegtransectplantsummary.speciestotwtclippedest AS speciestotwtclippedest,
vegtransectplantsummary.speciestotwtclippedfresh AS speciestotwtclippedfresh,
vegtransectplantsummary.speciestotwtclippedairdry AS speciestotwtclippedairdry,
vegtransectplantsummary.speciestotwtairdry AS speciestotwtairdry,
vegtransectplantsummary.speciestotwtest AS speciestotwtest,
vegtransectplantsummary.speciestotwtexisting AS speciestotwtexisting,
vegtransectplantsummary.speciesdrywtpct AS speciesdrywtpct,
vegtransectplantsummary.speciestotwt AS speciestotwt,
vegtransectplantsummary.speciesaveyielddblsamp AS speciesaveyielddblsamp,
vegtransectplantsummary.speciescomppctdblsamp AS speciescomppctdblsamp,
vegtransectplantsummary.speciescomppctdaubenmire AS speciescomppctdaubenmire,
vegtransectplantsummary.speciescomppctlineintercept AS speciescomppctlineintercept,
vegtransectplantsummary.speciestraceamtflag AS speciestraceamtflag,
vegtransectplantsummary.weightconvfactor AS weightconvfactor,
vegtransectplantsummary.dblsampcorrectionfactor AS dblsampcorrectionfactor,
vegtransectplantsummary.airdrywtadjustment AS airdrywtadjustment,
vegtransectplantsummary.utilizationadjustment AS utilizationadjustment,
vegtransectplantsummary.growthadjustment AS growthadjustment,
vegtransectplantsummary.weatheradjustment AS weatheradjustment,
vegtransectplantsummary.numberofquadratsin AS numberofquadratsin,
vegtransectplantsummary.speciesfreqdaubenmire AS speciesfreqdaubenmire,
vegtransectplantsummary.dwronetally AS dwronetally,
vegtransectplantsummary.dwrtwotally AS dwrtwotally,
vegtransectplantsummary.dwrthreetally AS dwrthreetally,
vegtransectplantsummary.dwrweightedtally AS dwrweightedtally,
vegtransectplantsummary.speciescomppctdwr AS speciescomppctdwr,
vegtransectplantsummary.speciesaveyielddwr AS speciesaveyielddwr,
vegtransectplantsummary.wtunitweight AS wtunitweight,
vegtransectplantsummary.wtunitcounttotal AS wtunitcounttotal,
vegtransectplantsummary.speciesaveyieldwtunit AS speciesaveyieldwtunit,
vegtransectplantsummary.wtunitwtclippedtotal AS wtunitwtclippedtotal,
vegtransectplantsummary.speciescancovhitcount AS speciescancovhitcount,
vegtransectplantsummary.speciescancovpct AS speciescancovpct,
vegtransectplantsummary.speciescancovpctavedaub AS speciescancovpctavedaub,
CODELABEL (speciescancovaveclass) AS speciescancovaveclass,
vegtransectplantsummary.speciesfoliarcovhitcount AS speciesfoliarcovhitcount,
vegtransectplantsummary.speciesfoliarcovpctlineint AS speciesfoliarcovpctlineint,
vegtransectplantsummary.speciestotfoliarcovlineint AS speciestotfoliarcovlineint,
vegtransectplantsummary.speciesbasalcovhitcount AS speciesbasalcovhitcount,
vegtransectplantsummary.speciesbasalcovpctlineint AS speciesbasalcovpctlineint,
vegtransectplantsummary.speciestotbasalcovlineint AS speciestotbasalcovlineint,
vegtransectplantsummary.maturecounttotal AS maturecounttotal,
vegtransectplantsummary.maturedensityave AS maturedensityave,
CODELABEL (maturedensityaveclass) AS maturedensityaveclass,
vegtransectplantsummary.seedlingcounttotal AS seedlingcounttotal,
vegtransectplantsummary.seedlingdensityave AS seedlingdensityave,
CODELABEL (seedlingdensityaveclass) AS seedlingdensityaveclass,
CODELABEL (speciesgroundcovabundclass) AS speciesgroundcovabundclass,
vegtransectplantsummary.speciescancovportion AS speciescancovportion,
vegtransectplantsummary.speciesbasalarea AS speciesbasalarea,
CODELABEL (basalareaassessmethod) AS basalareaassessmethod,
vegtransectplantsummary.recwlupdated AS recwlupdated,
vegtransectplantsummary.recuseriidref/1 AS recuseriidref,
vegtransectplantsummary.vegtransplantsummiid/1 AS vegtransplantsummiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN vegtransectplantsummary ON vegtransectplantsummary.plantiidref=plant.plantiid;.

TEMPLATE vegtransectplantsummary WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin vegtransectplantsummary".
END SECTION.

SECTION HEADING
USING vegtransectplantsummary
'vegtransectiidref',
'seqnum',
'plantiidref',
'plantnativity',
'planttypegroup',
'plantheightcllowerlimit',
'plantheightclupperlimit',
'sociabilityclass',
'specieslivecanhtbotave',
'specieslivecanhttopave',
'overstorydbhmin',
'overstorydbhmax',
'speciesovercancovpct',
'speciesovercancovclass',
'plantprodquadratsize',
'plantprodquadratshape',
'nestedfreqquadratsize',
'nestedfreqquadratshape',
'frequencyquadratsize',
'frequencyquadratshape',
'dwrquadratsize',
'dwrquadratshape',
'densityquadratsize',
'densityquadratshape',
'speciestotwtclippedest',
'speciestotwtclippedfresh',
'speciestotwtclippedairdry',
'speciestotwtairdry',
'speciestotwtest',
'speciestotwtexisting',
'speciesdrywtpct',
'speciestotwt',
'speciesaveyielddblsamp',
'speciescomppctdblsamp',
'speciescomppctdaubenmire',
'speciescomppctlineintercept',
'speciestraceamtflag',
'weightconvfactor',
'dblsampcorrectionfactor',
'airdrywtadjustment',
'utilizationadjustment',
'growthadjustment',
'weatheradjustment',
'numberofquadratsin',
'speciesfreqdaubenmire',
'dwronetally',
'dwrtwotally',
'dwrthreetally',
'dwrweightedtally',
'speciescomppctdwr',
'speciesaveyielddwr',
'wtunitweight',
'wtunitcounttotal',
'speciesaveyieldwtunit',
'wtunitwtclippedtotal',
'speciescancovhitcount',
'speciescancovpct',
'speciescancovpctavedaub',
'speciescancovaveclass',
'speciesfoliarcovhitcount',
'speciesfoliarcovpctlineint',
'speciestotfoliarcovlineint',
'speciesbasalcovhitcount',
'speciesbasalcovpctlineint',
'speciestotbasalcovlineint',
'maturecounttotal',
'maturedensityave',
'maturedensityaveclass',
'seedlingcounttotal',
'seedlingdensityave',
'seedlingdensityaveclass',
'speciesgroundcovabundclass',
'speciescancovportion',
'speciesbasalarea',
'basalareaassessmethod',
'recwlupdated',
'recuseriidref',
'vegtransplantsummiid'.

DATA
USING vegtransectplantsummary
vegtransectiidref,
seqnum,
plantiidref,
plantnativity,
planttypegroup,
plantheightcllowerlimit,
plantheightclupperlimit,
sociabilityclass,
specieslivecanhtbotave,
specieslivecanhttopave,
overstorydbhmin,
overstorydbhmax,
speciesovercancovpct,
speciesovercancovclass,
plantprodquadratsize,
plantprodquadratshape,
nestedfreqquadratsize,
nestedfreqquadratshape,
frequencyquadratsize,
frequencyquadratshape,
dwrquadratsize,
dwrquadratshape,
densityquadratsize,
densityquadratshape,
speciestotwtclippedest,
speciestotwtclippedfresh,
speciestotwtclippedairdry,
speciestotwtairdry,
speciestotwtest,
speciestotwtexisting,
speciesdrywtpct,
speciestotwt,
speciesaveyielddblsamp,
speciescomppctdblsamp,
speciescomppctdaubenmire,
speciescomppctlineintercept,
speciestraceamtflag,
weightconvfactor,
dblsampcorrectionfactor,
airdrywtadjustment,
utilizationadjustment,
growthadjustment,
weatheradjustment,
numberofquadratsin,
speciesfreqdaubenmire,
dwronetally,
dwrtwotally,
dwrthreetally,
dwrweightedtally,
speciescomppctdwr,
speciesaveyielddwr,
wtunitweight,
wtunitcounttotal,
speciesaveyieldwtunit,
wtunitwtclippedtotal,
speciescancovhitcount,
speciescancovpct,
speciescancovpctavedaub,
speciescancovaveclass,
speciesfoliarcovhitcount,
speciesfoliarcovpctlineint,
speciestotfoliarcovlineint,
speciesbasalcovhitcount,
speciesbasalcovpctlineint,
speciestotbasalcovlineint,
maturecounttotal,
maturedensityave,
maturedensityaveclass,
seedlingcounttotal,
seedlingdensityave,
seedlingdensityaveclass,
speciesgroundcovabundclass,
speciescancovportion,
speciesbasalarea,
basalareaassessmethod,
recwlupdated,
recuseriidref,
vegtransplantsummiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin vegtransectplantsummary".
USING vegtransectplantsummary
'vegtransectiidref',
'seqnum',
'plantiidref',
'plantnativity',
'planttypegroup',
'plantheightcllowerlimit',
'plantheightclupperlimit',
'sociabilityclass',
'specieslivecanhtbotave',
'specieslivecanhttopave',
'overstorydbhmin',
'overstorydbhmax',
'speciesovercancovpct',
'speciesovercancovclass',
'plantprodquadratsize',
'plantprodquadratshape',
'nestedfreqquadratsize',
'nestedfreqquadratshape',
'frequencyquadratsize',
'frequencyquadratshape',
'dwrquadratsize',
'dwrquadratshape',
'densityquadratsize',
'densityquadratshape',
'speciestotwtclippedest',
'speciestotwtclippedfresh',
'speciestotwtclippedairdry',
'speciestotwtairdry',
'speciestotwtest',
'speciestotwtexisting',
'speciesdrywtpct',
'speciestotwt',
'speciesaveyielddblsamp',
'speciescomppctdblsamp',
'speciescomppctdaubenmire',
'speciescomppctlineintercept',
'speciestraceamtflag',
'weightconvfactor',
'dblsampcorrectionfactor',
'airdrywtadjustment',
'utilizationadjustment',
'growthadjustment',
'weatheradjustment',
'numberofquadratsin',
'speciesfreqdaubenmire',
'dwronetally',
'dwrtwotally',
'dwrthreetally',
'dwrweightedtally',
'speciescomppctdwr',
'speciesaveyielddwr',
'wtunitweight',
'wtunitcounttotal',
'speciesaveyieldwtunit',
'wtunitwtclippedtotal',
'speciescancovhitcount',
'speciescancovpct',
'speciescancovpctavedaub',
'speciescancovaveclass',
'speciesfoliarcovhitcount',
'speciesfoliarcovpctlineint',
'speciestotfoliarcovlineint',
'speciesbasalcovhitcount',
'speciesbasalcovpctlineint',
'speciestotbasalcovlineint',
'maturecounttotal',
'maturedensityave',
'maturedensityaveclass',
'seedlingcounttotal',
'seedlingdensityave',
'seedlingdensityaveclass',
'speciesgroundcovabundclass',
'speciescancovportion',
'speciesbasalarea',
'basalareaassessmethod',
'recwlupdated',
'recuseriidref',
'vegtransplantsummiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: vegtransecttext ---- Vegetation Transect Text

ACCEPT pedonid_list.
EXEC SQL SELECT

vegtransecttext.vegtransectiidref/1 AS vegtransectiidref,
vegtransecttext.seqnum AS seqnum,
vegtransecttext.recdate AS recdate,
vegtransecttext.recauthor AS recauthor,
CODELABEL (vegtransecttextkind) AS vegtransecttextkind,
vegtransecttext.textcat AS textcat,
vegtransecttext.textsubcat AS textsubcat,
vegtransecttext.textentry AS textentry,
vegtransecttext.recwlupdated AS recwlupdated,
vegtransecttext.recuseriidref/1 AS recuseriidref,
vegtransecttext.vegtranstextiid/1 AS vegtranstextiid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN vegtransecttext ON vegtransecttext.vegtransectiidref=vegtransect.vegtransectiid;.

TEMPLATE vegtransecttext WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin vegtransecttext".
END SECTION.

SECTION HEADING
USING vegtransecttext
'vegtransectiidref',
'seqnum',
'recdate',
'recauthor',
'vegtransecttextkind',
'textcat',
'textsubcat',
'textentry',
'recwlupdated',
'recuseriidref',
'vegtranstextiid'.

DATA
USING vegtransecttext
vegtransectiidref,
seqnum,
recdate,
recauthor,
vegtransecttextkind,
textcat,
textsubcat,
textentry,
recwlupdated,
recuseriidref,
vegtranstextiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin vegtransecttext".
USING vegtransecttext
'vegtransectiidref',
'seqnum',
'recdate',
'recauthor',
'vegtransecttextkind',
'textcat',
'textsubcat',
'textentry',
'recwlupdated',
'recuseriidref',
'vegtranstextiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: vegtranssmpprotusedrefecmdoc ---- Veg Trans Sample Protocol Ref ECM Documents

ACCEPT pedonid_list.
EXEC SQL SELECT

vegtranssmpprotusedrefecmdoc.transsampprotocusediidref/1 AS transsampprotocusediidref,
vegtranssmpprotusedrefecmdoc.seqnum AS seqnum,
CODELABEL (ecmdoctype) AS ecmdoctype,
vegtranssmpprotusedrefecmdoc.ecmdocname AS ecmdocname,
vegtranssmpprotusedrefecmdoc.ecmdockeyurl AS ecmdockeyurl,
vegtranssmpprotusedrefecmdoc.recwlupdated AS recwlupdated,
vegtranssmpprotusedrefecmdoc.recuseriidref/1 AS recuseriidref,
vegtranssmpprotusedrefecmdoc.vegtransmethoddrefecmdociid/1 AS vegtransmethoddrefecmdociid

FROM pedon
INNER JOIN siteobs ON siteobs.siteiidref=site.siteiid
INNER JOIN pedon ON pedon.siteobsiidref=siteobs.siteobsiid AND peiid IN ($pedonid_list)
INNER JOIN vegtransect ON vegtransect.vegplotiidref=vegplot.vegplotiid
INNER JOIN transectsamplingprotocolused ON transectsamplingprotocolused.vegtransectiidref=vegtransect.vegtransectiid
INNER JOIN vegtranssmpprotusedrefecmdoc ON vegtranssmpprotusedrefecmdoc.transsampprotocusediidref=transectsamplingprotocolused.transsampprotocolusediid;.

TEMPLATE vegtranssmpprotusedrefecmdoc WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin vegtranssmpprotusedrefecmdoc".
END SECTION.

SECTION HEADING
USING vegtranssmpprotusedrefecmdoc
'transsampprotocusediidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'vegtransmethoddrefecmdociid'.

DATA
USING vegtranssmpprotusedrefecmdoc
transsampprotocusediidref,
seqnum,
ecmdoctype,
ecmdocname,
ecmdockeyurl,
recwlupdated,
recuseriidref,
vegtransmethoddrefecmdociid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin vegtranssmpprotusedrefecmdoc".
USING vegtranssmpprotusedrefecmdoc
'transsampprotocusediidref',
'seqnum',
'ecmdoctype',
'ecmdocname',
'ecmdockeyurl',
'recwlupdated',
'recuseriidref',
'vegtransmethoddrefecmdociid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

====================================================================================================
NASIS Pedon Report for: windbreakrowdata ---- Windbreak Row Data

ACCEPT pedonid_list.
EXEC SQL SELECT

windbreakrowdata.vegplotiidref/1 AS vegplotiidref,
windbreakrowdata.seqnum AS seqnum,
windbreakrowdata.windbreakrowid AS windbreakrowid,
windbreakrowdata.plantiidref AS plantiidref,
windbreakrowdata.growingseasoncount AS growingseasoncount,
CODELABEL (speiescondition) AS speiescondition,
windbreakrowdata.crownspreadleft AS crownspreadleft,
windbreakrowdata.crownspreadright AS crownspreadright,
windbreakrowdata.spacingbetweenrows AS spacingbetweenrows,
windbreakrowdata.spacingwithinrow AS spacingwithinrow,
CODELABEL (cultivationpast) AS cultivationpast,
CODELABEL (cultivationpresent) AS cultivationpresent,
windbreakrowdata.speciesdbhaverage AS speciesdbhaverage,
CODELABEL (diseasekind) AS diseasekind,
CODELABEL (diseasedamagedegree) AS diseasedamagedegree,
CODELABEL (injurykind) AS injurykind,
CODELABEL (injurydamagedegree) AS injurydamagedegree,
CODELABEL (insectkind) AS insectkind,
CODELABEL (insectdamagedegree) AS insectdamagedegree,
CODELABEL (groundcoverextent) AS groundcoverextent,
windbreakrowdata.heightlivecrownleft AS heightlivecrownleft,
windbreakrowdata.heightlivecrownright AS heightlivecrownright,
windbreakrowdata.survivalpct AS survivalpct,
windbreakrowdata.windbreakrowhtave AS windbreakrowhtave,
windbreakrowdata.windbreakrowhtmaxave AS windbreakrowhtmaxave,
CODELABEL (reprodabundanceclass) AS reprodabundanceclass,
windbreakrowdata.rootdepthfew AS rootdepthfew,
windbreakrowdata.rootdepthcommon AS rootdepthcommon,
windbreakrowdata.rootdepthmany AS rootdepthmany,
CODELABEL (suppressiondegreeleft) AS suppressiondegreeleft,
windbreakrowdata.suppressionrowleft AS suppressionrowleft,
CODELABEL (suppressiondegreeright) AS suppressiondegreeright,
windbreakrowdata.suppressionrowright AS suppressionrowright,
windbreakrowdata.vitalnotesindicator AS vitalnotesindicator,
windbreakrowdata.soiltaxonrangeindicator AS soiltaxonrangeindicator,
windbreakrowdata.notes AS notes,
windbreakrowdata.recwlupdated AS recwlupdated,
windbreakrowdata.recuseriidref/1 AS recuseriidref,
windbreakrowdata.windbreakrowdataiid/1 AS windbreakrowdataiid

FROM pedon
RELATIONSHIP TO PEDON TABLE COULD NOT BE ESTABLISHED
INNER JOIN nasisgroup ON nasisgroup.nasissiteiidref=nasissite.nasissiteiid
INNER JOIN plant ON plant.grpiidref,plantdbiidref=nasisgroup.grpiid,nasissiteiidref
INNER JOIN windbreakrowdata ON windbreakrowdata.plantiidref=plant.plantiid;.

TEMPLATE windbreakrowdata WIDTH UNLIMITED SEPARATOR"|"
AT LEFT FIELD SEPARATOR  "",
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD,
FIELD.

SECTION WHEN AT START
HEADING
AT LEFT "@begin windbreakrowdata".
END SECTION.

SECTION HEADING
USING windbreakrowdata
'vegplotiidref',
'seqnum',
'windbreakrowid',
'plantiidref',
'growingseasoncount',
'speiescondition',
'crownspreadleft',
'crownspreadright',
'spacingbetweenrows',
'spacingwithinrow',
'cultivationpast',
'cultivationpresent',
'speciesdbhaverage',
'diseasekind',
'diseasedamagedegree',
'injurykind',
'injurydamagedegree',
'insectkind',
'insectdamagedegree',
'groundcoverextent',
'heightlivecrownleft',
'heightlivecrownright',
'survivalpct',
'windbreakrowhtave',
'windbreakrowhtmaxave',
'reprodabundanceclass',
'rootdepthfew',
'rootdepthcommon',
'rootdepthmany',
'suppressiondegreeleft',
'suppressionrowleft',
'suppressiondegreeright',
'suppressionrowright',
'vitalnotesindicator',
'soiltaxonrangeindicator',
'notes',
'recwlupdated',
'recuseriidref',
'windbreakrowdataiid'.

DATA
USING windbreakrowdata
vegplotiidref,
seqnum,
windbreakrowid,
plantiidref,
growingseasoncount,
speiescondition,
crownspreadleft,
crownspreadright,
spacingbetweenrows,
spacingwithinrow,
cultivationpast,
cultivationpresent,
speciesdbhaverage,
diseasekind,
diseasedamagedegree,
injurykind,
injurydamagedegree,
insectkind,
insectdamagedegree,
groundcoverextent,
heightlivecrownleft,
heightlivecrownright,
survivalpct,
windbreakrowhtave,
windbreakrowhtmaxave,
reprodabundanceclass,
rootdepthfew,
rootdepthcommon,
rootdepthmany,
suppressiondegreeleft,
suppressionrowleft,
suppressiondegreeright,
suppressionrowright,
vitalnotesindicator,
soiltaxonrangeindicator,
notes,
recwlupdated,
recuseriidref,
windbreakrowdataiid.
END SECTION.

SECTION WHEN NO DATA
DATA
AT LEFT "@begin windbreakrowdata".
USING windbreakrowdata
'vegplotiidref',
'seqnum',
'windbreakrowid',
'plantiidref',
'growingseasoncount',
'speiescondition',
'crownspreadleft',
'crownspreadright',
'spacingbetweenrows',
'spacingwithinrow',
'cultivationpast',
'cultivationpresent',
'speciesdbhaverage',
'diseasekind',
'diseasedamagedegree',
'injurykind',
'injurydamagedegree',
'insectkind',
'insectdamagedegree',
'groundcoverextent',
'heightlivecrownleft',
'heightlivecrownright',
'survivalpct',
'windbreakrowhtave',
'windbreakrowhtmaxave',
'reprodabundanceclass',
'rootdepthfew',
'rootdepthcommon',
'rootdepthmany',
'suppressiondegreeleft',
'suppressionrowleft',
'suppressiondegreeright',
'suppressionrowright',
'vitalnotesindicator',
'soiltaxonrangeindicator',
'notes',
'recwlupdated',
'recuseriidref',
'windbreakrowdataiid'.
AT LEFT "@end".
END SECTION.

SECTION WHEN AT END DATA
AT LEFT "@end".
END SECTION.

>>>