VegBank

submodule,TableName,FieldName,LeeTake,Nulls,key,dataType,FieldSize,References,ClosedList,FieldNotes,FieldDefinition

vegplot,plot,confidentialityReason,what if public?,No,n/a,text,200,n/a,no,n/a,"The reason for confidentiality.  This field should not be open to public view.  Reasons might include specific rare species, ownership, prepublication embargo, or many other reason"

vegplot,observation,taxonObservationArea,what if plotless?,No,n/a,Double,8,n/a,no,default = plot.area,"the total surface area (in m2) used for cover estimates and for which a complete species list is provided.  If subplots were used, this would be the total area of the subplots without intersticial space."

vegplot,plot,area,what if plotless?,No ,n/a,Double,8,n/a,no,n/a,"Total area of the plot in m2.  If many subplots, this area includes the subplots and the intersticial space

		"

vegplot,observation,STRATUMMETHOD_ID,what if no strata?,No,FK,Long Integer,,stratumMethod.STRATUMMETHOD_ID,no,Foreign key into the stratumMethod table,Link to the definitions of strata used in recording taxon-specific values of cover.

vegplot,observation,autoTaxonCover,what if no cover?,No,n/a,yes/no,,n/a,no,default = FALSE,TRUE indicates that taxonObservation.taxonCover was automatically calculated from the values of all stratumObservation.taxonStratumCover

vegplot,observation,coverDispersion,what if no cover?,No,n/a,text,30,n/a,yes,closed list; default = contiguous,"Were cover values for the total taxon list collected from one contiguous area or dispersed subplots (e.g., continguous, dispersed-regular, dispered-random)?"

vegplot,observation,COVERMETHOD_ID,what if no cover?,No ,FK,Long Integer,,coverMethod.COVERMETHOD_ID,no,Foreign key into the coverMethod table.,"Link to the scale used to estimate taxon cover. The database stores estimated cover to the nearest percent, but the conversion details are recovered by reference to the specific scale employed."

vegplot,observationSynonym,classStartDate,ok,No,n/a,date/time,,n/a,no,n/a ,Start date for the synonymization event.

vegplot,party,owner,ok,No,FK,Long Integer,,party.PARTY_ID,no,n/a,Recursive foreign key to the Party who owns this party record and who has exclusive rights to update the information content.

vegplot,plot,confidentialityStatus,ok,No,n/a,Long Integer,,n/a,yes,"closed list, default=0","Are the data to be considered confidential? 0=no, 1= 1km radius, 2=10km radius, 3=100km radius, 4=location embargo, 5=public embargo on all plot data, 6=full embargo on all plot data. This applies also to region. "

vegplot,plot,Latitude,ok,No,n/a ,Double,8,n/a ,no,n/a,"Latitude of the plot origin in degrees and decimals, datum =WGS84, fuzzing applied "

vegplot,plot,Longitude,ok,No,n/a,Double,8,n/a,no,n/a,"Longitude of the plot origin in degrees and decimals, datum = WGS84, fuzzing applied"

vegplot,plot,realLatitude,ok,No ,n/a ,Double,8,n/a ,no,n/a,"Latitude of the plot origin in degrees and decimals, datum =WGS84 "

vegplot,plot,realLongitude,ok,No,n/a,Double,8,n/a,no,n/a,"Longitude of the plot origin in degrees and decimals, datum = WGS84"

vegplot,soilObs,soilHorizon,ok,No,n/a,text,15,n/a,yes,closed list - USDA,The horizon to which this observation applies.

vegplot,soilTaxon,soilLevel,ok,No,n/a,Long Integer,,n/a,no,n/a,"Hierarchical level; 1=Order, 2=Suborder, 3=GreatGroup, 4=SubGroup, 5=Family, 6=Series"

vegplot,stemCount,stemCount,ok,No,n/a ,Long Integer,,n/a ,no,"The default value is 1.  This field is not logically necessary, but allows for more compact entry and storage of tree stem tally data.",The number of stems of a single species that have these specific stem diameter and height data in common.

vegplot,stratumComposition,taxonStratumCover,ok,No,n/a,Double,8,n/a,no,n/a,Percent cover of taxon in stratum

vegplot,stratumMethod,stratumMethodName,ok,No ,n/a ,text,30,n/a ,no,n/a,"Name of the stratum method (e.g., Braun-Blanquet, TNC-ABI, NC Vegetation Survey #1, NC Vegetation Survey #2, etc.)"

vegplot,stratumType,stratumIndex,ok,No,n/a,text,10,n/a,no,n/a,Short code used to identify the stratum

vegplot,taxonInterpretation,currentInterpretation,ok,No,n/a,yes/no,,n/a,no,n/a,This interpretation is the most accurate and precise interpretation currently available.

vegplot,taxonInterpretation,interpretationDate,ok,No ,n/a ,date/time,,n/a ,no,n/a ,The date that the interpretation was made. 

vegplot,taxonInterpretation,originalInterpretation,ok,No,n/a,yes/no,,n/a,no,n/a,"This interpretation corrsponds to the original interpretation of the plot author, as best as can be determined.  There is no requirement that the authority match the authority of the author; only that the concepts are synonymous."

vegplot,telephone,phoneNumber,ok,No,n/a,text,30,n/a,no,n/a,Telephone number.

vegplot,telephone,phoneType,ok,No,n/a,text,20,n/a,yes,closed list,"This is the type of telephone: home, work, fax, cell, secretary, other."

vegplot,userDefined,userDefinedType,ok,No,n/a,text,20,n/a,no,n/a ,Database data type of the user-defined variable.