Revision 4754
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/Madidi/Plot/VegBIEN.csv | ||
|---|---|---|
| 22 | 22 |
Locality description,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,Often begins with the text in Vegetation type |
| 23 | 23 |
First evaluation,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value, |
| 24 | 24 |
First evaluation,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value, |
| 25 |
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/acidity, |
|
| 26 |
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",/location/locationevent/soilobs/calcium, |
|
| 27 |
"Carbón Orgánico (WSP S-9,10–%–0.06)",/location/locationevent/soilobs/carbon, |
|
| 28 |
CIC (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/cationexchangecapacity, |
|
| 29 |
Arcilla (DIN 18 123–%–1),/location/locationevent/soilobs/clay, |
|
| 25 |
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/acidity_frac,
|
|
| 26 |
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",/location/locationevent/soilobs/calcium_frac,
|
|
| 27 |
"Carbón Orgánico (WSP S-9,10–%–0.06)",/location/locationevent/soilobs/carbon_frac,
|
|
| 28 |
CIC (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
|
|
| 29 |
Arcilla (DIN 18 123–%–1),/location/locationevent/soilobs/clay_frac,
|
|
| 30 | 30 |
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),/location/locationevent/soilobs/conductivity, |
| 31 |
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/magnesium, |
|
| 32 |
Nitrógeno total (ISRIC 6–%–0.0014),/location/locationevent/soilobs/nitrogen, |
|
| 33 |
"Materia Orgánica (WSP S-9,10–%–0.1)",/location/locationevent/soilobs/organic, |
|
| 31 |
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/magnesium_frac,
|
|
| 32 |
Nitrógeno total (ISRIC 6–%–0.0014),/location/locationevent/soilobs/nitrogen_frac,
|
|
| 33 |
"Materia Orgánica (WSP S-9,10–%–0.1)",/location/locationevent/soilobs/organic_frac,
|
|
| 34 | 34 |
pH acuoso (ISRIC 4–– 1 - 14),/location/locationevent/soilobs/ph, |
| 35 |
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),/location/locationevent/soilobs/phosphorus, |
|
| 36 |
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",/location/locationevent/soilobs/potassium, |
|
| 37 |
Arena (DIN 18 123–%–2.5),/location/locationevent/soilobs/sand, |
|
| 38 |
Limo (DIN 18 123–%–1),/location/locationevent/soilobs/silt, |
|
| 39 |
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/sodium, |
|
| 35 |
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),/location/locationevent/soilobs/phosphorus_frac,
|
|
| 36 |
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",/location/locationevent/soilobs/potassium_frac,
|
|
| 37 |
Arena (DIN 18 123–%–2.5),/location/locationevent/soilobs/sand_frac,
|
|
| 38 |
Limo (DIN 18 123–%–1),/location/locationevent/soilobs/silt_frac,
|
|
| 39 |
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/sodium_frac,
|
|
| 40 | 40 |
Textural class,/location/locationevent/soilobs/texture, |
| 41 | 41 |
Locality,/location/locationnarrative/_merge/1, |
| 42 | 42 |
Observaciones,/location/notespublic, |
| inputs/Madidi/Plot/test.xml.ref | ||
|---|---|---|
| 135 | 135 |
<obsenddate><_date><date><_dateRangeEnd><value>$First evaluation</value></_dateRangeEnd></date></_date></obsenddate> |
| 136 | 136 |
<obsstartdate><_date><date><_dateRangeStart><value>$First evaluation</value></_dateRangeStart></date></_date></obsstartdate> |
| 137 | 137 |
<soilobs> |
| 138 |
<acidity>$Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05)</acidity>
|
|
| 139 |
<calcium>$Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)</calcium>
|
|
| 140 |
<carbon>$Carbón Orgánico (WSP S-9,10–%–0.06)</carbon>
|
|
| 141 |
<cationexchangecapacity>$CIC (ISRIC 11–cmolc/Kg–0.05)</cationexchangecapacity>
|
|
| 142 |
<clay>$Arcilla (DIN 18 123–%–1)</clay>
|
|
| 138 |
<acidity_frac>$Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05)</acidity_frac>
|
|
| 139 |
<calcium_frac>$Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)</calcium_frac>
|
|
| 140 |
<carbon_frac>$Carbón Orgánico (WSP S-9,10–%–0.06)</carbon_frac>
|
|
| 141 |
<cationexchangecapacity_cmol_kg>$CIC (ISRIC 11–cmolc/Kg–0.05)</cationexchangecapacity_cmol_kg>
|
|
| 142 |
<clay_frac>$Arcilla (DIN 18 123–%–1)</clay_frac>
|
|
| 143 | 143 |
<conductivity>$Conductividad electrica (ASPT 6–µS/cm– 1 - 10000)</conductivity> |
| 144 |
<magnesium>$Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)</magnesium>
|
|
| 145 |
<nitrogen>$Nitrógeno total (ISRIC 6–%–0.0014)</nitrogen>
|
|
| 146 |
<organic>$Materia Orgánica (WSP S-9,10–%–0.1)</organic>
|
|
| 144 |
<magnesium_frac>$Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)</magnesium_frac>
|
|
| 145 |
<nitrogen_frac>$Nitrógeno total (ISRIC 6–%–0.0014)</nitrogen_frac>
|
|
| 146 |
<organic_frac>$Materia Orgánica (WSP S-9,10–%–0.1)</organic_frac>
|
|
| 147 | 147 |
<ph>$pH acuoso (ISRIC 4–– 1 - 14)</ph> |
| 148 |
<phosphorus>$Fósforo disponible (ISRIC 14-2–mg/Kg–1.5)</phosphorus>
|
|
| 149 |
<potassium>$Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)</potassium>
|
|
| 150 |
<sand>$Arena (DIN 18 123–%–2.5)</sand>
|
|
| 151 |
<silt>$Limo (DIN 18 123–%–1)</silt>
|
|
| 152 |
<sodium>$Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)</sodium>
|
|
| 148 |
<phosphorus_frac>$Fósforo disponible (ISRIC 14-2–mg/Kg–1.5)</phosphorus_frac>
|
|
| 149 |
<potassium_frac>$Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)</potassium_frac>
|
|
| 150 |
<sand_frac>$Arena (DIN 18 123–%–2.5)</sand_frac>
|
|
| 151 |
<silt_frac>$Limo (DIN 18 123–%–1)</silt_frac>
|
|
| 152 |
<sodium_frac>$Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)</sodium_frac>
|
|
| 153 | 153 |
<texture>$Textural class</texture> |
| 154 | 154 |
</soilobs> |
| 155 | 155 |
</locationevent> |
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 29 | 29 |
HAVING count(DISTINCT census_date) > 1 |
| 30 | 30 |
-----" |
| 31 | 31 |
no_of_individuals,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this." |
| 32 |
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
|
| 32 |
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_frac,
|
|
| 33 | 33 |
census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 34 |
intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,"Brad: This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance." |
|
| 34 |
intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m,"Brad: This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
|
|
| 35 | 35 |
individual_code,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| 36 | 36 |
OBSERVATION_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| 37 | 37 |
det_type,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen." |
| inputs/SALVIAS-CSV/Organism/test.xml.ref | ||
|---|---|---|
| 17 | 17 |
<taxonoccurrence> |
| 18 | 18 |
<aggregateoccurrence> |
| 19 | 19 |
<count>$no_of_individuals</count> |
| 20 |
<cover>$cover_percent</cover>
|
|
| 20 |
<cover_frac>$cover_percent</cover_frac>
|
|
| 21 | 21 |
<definedvalue fkey="tablerecord_id"> |
| 22 | 22 |
<userdefined_id> |
| 23 | 23 |
<userdefined> |
| ... | ... | |
| 27 | 27 |
</userdefined_id> |
| 28 | 28 |
<definedvalue>$census_no</definedvalue> |
| 29 | 29 |
</definedvalue> |
| 30 |
<linecover>$intercept_cm</linecover>
|
|
| 30 |
<linecover_m>$intercept_cm</linecover_m>
|
|
| 31 | 31 |
<plantobservation> |
| 32 | 32 |
<collectionnumber>$individual_code</collectionnumber> |
| 33 | 33 |
<sourceaccessioncode>$OBSERVATION_ID</sourceaccessioncode> |
| inputs/SALVIAS-CSV/Plot/VegBIEN.csv | ||
|---|---|---|
| 22 | 22 |
date_finish,/location/locationevent/obsenddate/_*/date/_alt/1, |
| 23 | 23 |
date_start,/location/locationevent/obsstartdate/_*/date/_alt/1, |
| 24 | 24 |
precip_mm,/location/locationevent/precipitation_m, |
| 25 |
soil_acidity,"/location/locationevent/soilobs/acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value", |
|
| 26 |
soil_base,"/location/locationevent/soilobs/basesaturation/_units:[default=""%"",to=]/value", |
|
| 27 |
soil_Ca,"/location/locationevent/soilobs/calcium/_units:[default=""%"",to=]/value", |
|
| 28 |
soil_C,"/location/locationevent/soilobs/carbon/_units:[default=""%"",to=]/value", |
|
| 29 |
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity, |
|
| 30 |
clay_percent,"/location/locationevent/soilobs/clay/_units:[default=""%"",to=]/value", |
|
| 25 |
soil_acidity,"/location/locationevent/soilobs/acidity_frac/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
|
|
| 26 |
soil_base,"/location/locationevent/soilobs/basesaturation_frac/_units:[default=""%"",to=]/value",
|
|
| 27 |
soil_Ca,"/location/locationevent/soilobs/calcium_frac/_units:[default=""%"",to=]/value",
|
|
| 28 |
soil_C,"/location/locationevent/soilobs/carbon_frac/_units:[default=""%"",to=]/value",
|
|
| 29 |
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
|
|
| 30 |
clay_percent,"/location/locationevent/soilobs/clay_frac/_units:[default=""%"",to=]/value",
|
|
| 31 | 31 |
soil_conductivity,/location/locationevent/soilobs/conductivity, |
| 32 |
soil_Mg,"/location/locationevent/soilobs/magnesium/_units:[default=""%"",to=]/value", |
|
| 33 |
soil_N,"/location/locationevent/soilobs/nitrogen/_units:[default=""%"",to=]/value", |
|
| 34 |
organic_percent,"/location/locationevent/soilobs/organic/_units:[default=""%"",to=]/value", |
|
| 32 |
soil_Mg,"/location/locationevent/soilobs/magnesium_frac/_units:[default=""%"",to=]/value",
|
|
| 33 |
soil_N,"/location/locationevent/soilobs/nitrogen_frac/_units:[default=""%"",to=]/value",
|
|
| 34 |
organic_percent,"/location/locationevent/soilobs/organic_frac/_units:[default=""%"",to=]/value",
|
|
| 35 | 35 |
pH,/location/locationevent/soilobs/ph,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss." |
| 36 |
soil_P,"/location/locationevent/soilobs/phosphorus/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value", |
|
| 37 |
soil_K,"/location/locationevent/soilobs/potassium/_units:[default=""%"",to=]/value", |
|
| 38 |
sand_percent,"/location/locationevent/soilobs/sand/_units:[default=""%"",to=]/value", |
|
| 39 |
silt_percent,"/location/locationevent/soilobs/silt/_units:[default=""%"",to=]/value", |
|
| 40 |
soil_Na,"/location/locationevent/soilobs/sodium/_units:[default=""%"",to=]/value", |
|
| 36 |
soil_P,"/location/locationevent/soilobs/phosphorus_frac/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
|
|
| 37 |
soil_K,"/location/locationevent/soilobs/potassium_frac/_units:[default=""%"",to=]/value",
|
|
| 38 |
sand_percent,"/location/locationevent/soilobs/sand_frac/_units:[default=""%"",to=]/value",
|
|
| 39 |
silt_percent,"/location/locationevent/soilobs/silt_frac/_units:[default=""%"",to=]/value",
|
|
| 40 |
soil_Na,"/location/locationevent/soilobs/sodium_frac/_units:[default=""%"",to=]/value",
|
|
| 41 | 41 |
soil_texture,/location/locationevent/soilobs/texture, |
| 42 | 42 |
temp_c,/location/locationevent/temperature_c, |
| 43 | 43 |
locality_description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX" |
| inputs/SALVIAS-CSV/Plot/test.xml.ref | ||
|---|---|---|
| 132 | 132 |
<obsstartdate><_date><date>$date_start</date></_date></obsstartdate> |
| 133 | 133 |
<precipitation_m>$precip_mm</precipitation_m> |
| 134 | 134 |
<soilobs> |
| 135 |
<acidity> |
|
| 135 |
<acidity_frac>
|
|
| 136 | 136 |
<_units> |
| 137 | 137 |
<default>%</default> |
| 138 | 138 |
<to></to> |
| ... | ... | |
| 144 | 144 |
</_map> |
| 145 | 145 |
</value> |
| 146 | 146 |
</_units> |
| 147 |
</acidity> |
|
| 148 |
<basesaturation> |
|
| 147 |
</acidity_frac>
|
|
| 148 |
<basesaturation_frac>
|
|
| 149 | 149 |
<_units> |
| 150 | 150 |
<default>%</default> |
| 151 | 151 |
<to></to> |
| 152 | 152 |
<value>$soil_base</value> |
| 153 | 153 |
</_units> |
| 154 |
</basesaturation> |
|
| 155 |
<calcium> |
|
| 154 |
</basesaturation_frac>
|
|
| 155 |
<calcium_frac>
|
|
| 156 | 156 |
<_units> |
| 157 | 157 |
<default>%</default> |
| 158 | 158 |
<to></to> |
| 159 | 159 |
<value>$soil_Ca</value> |
| 160 | 160 |
</_units> |
| 161 |
</calcium> |
|
| 162 |
<carbon> |
|
| 161 |
</calcium_frac>
|
|
| 162 |
<carbon_frac>
|
|
| 163 | 163 |
<_units> |
| 164 | 164 |
<default>%</default> |
| 165 | 165 |
<to></to> |
| 166 | 166 |
<value>$soil_C</value> |
| 167 | 167 |
</_units> |
| 168 |
</carbon> |
|
| 169 |
<cationexchangecapacity>$soil_cation_cap</cationexchangecapacity>
|
|
| 170 |
<clay> |
|
| 168 |
</carbon_frac>
|
|
| 169 |
<cationexchangecapacity_cmol_kg>$soil_cation_cap</cationexchangecapacity_cmol_kg>
|
|
| 170 |
<clay_frac>
|
|
| 171 | 171 |
<_units> |
| 172 | 172 |
<default>%</default> |
| 173 | 173 |
<to></to> |
| 174 | 174 |
<value>$clay_percent</value> |
| 175 | 175 |
</_units> |
| 176 |
</clay> |
|
| 176 |
</clay_frac>
|
|
| 177 | 177 |
<conductivity>$soil_conductivity</conductivity> |
| 178 |
<magnesium> |
|
| 178 |
<magnesium_frac>
|
|
| 179 | 179 |
<_units> |
| 180 | 180 |
<default>%</default> |
| 181 | 181 |
<to></to> |
| 182 | 182 |
<value>$soil_Mg</value> |
| 183 | 183 |
</_units> |
| 184 |
</magnesium> |
|
| 185 |
<nitrogen> |
|
| 184 |
</magnesium_frac>
|
|
| 185 |
<nitrogen_frac>
|
|
| 186 | 186 |
<_units> |
| 187 | 187 |
<default>%</default> |
| 188 | 188 |
<to></to> |
| 189 | 189 |
<value>$soil_N</value> |
| 190 | 190 |
</_units> |
| 191 |
</nitrogen> |
|
| 192 |
<organic> |
|
| 191 |
</nitrogen_frac>
|
|
| 192 |
<organic_frac>
|
|
| 193 | 193 |
<_units> |
| 194 | 194 |
<default>%</default> |
| 195 | 195 |
<to></to> |
| 196 | 196 |
<value>$organic_percent</value> |
| 197 | 197 |
</_units> |
| 198 |
</organic> |
|
| 198 |
</organic_frac>
|
|
| 199 | 199 |
<ph>$pH</ph> |
| 200 |
<phosphorus> |
|
| 200 |
<phosphorus_frac>
|
|
| 201 | 201 |
<_units> |
| 202 | 202 |
<default>%</default> |
| 203 | 203 |
<to></to> |
| ... | ... | |
| 209 | 209 |
</_map> |
| 210 | 210 |
</value> |
| 211 | 211 |
</_units> |
| 212 |
</phosphorus> |
|
| 213 |
<potassium> |
|
| 212 |
</phosphorus_frac>
|
|
| 213 |
<potassium_frac>
|
|
| 214 | 214 |
<_units> |
| 215 | 215 |
<default>%</default> |
| 216 | 216 |
<to></to> |
| 217 | 217 |
<value>$soil_K</value> |
| 218 | 218 |
</_units> |
| 219 |
</potassium> |
|
| 220 |
<sand> |
|
| 219 |
</potassium_frac>
|
|
| 220 |
<sand_frac>
|
|
| 221 | 221 |
<_units> |
| 222 | 222 |
<default>%</default> |
| 223 | 223 |
<to></to> |
| 224 | 224 |
<value>$sand_percent</value> |
| 225 | 225 |
</_units> |
| 226 |
</sand> |
|
| 227 |
<silt> |
|
| 226 |
</sand_frac>
|
|
| 227 |
<silt_frac>
|
|
| 228 | 228 |
<_units> |
| 229 | 229 |
<default>%</default> |
| 230 | 230 |
<to></to> |
| 231 | 231 |
<value>$silt_percent</value> |
| 232 | 232 |
</_units> |
| 233 |
</silt> |
|
| 234 |
<sodium> |
|
| 233 |
</silt_frac>
|
|
| 234 |
<sodium_frac>
|
|
| 235 | 235 |
<_units> |
| 236 | 236 |
<default>%</default> |
| 237 | 237 |
<to></to> |
| 238 | 238 |
<value>$soil_Na</value> |
| 239 | 239 |
</_units> |
| 240 |
</sodium> |
|
| 240 |
</sodium_frac>
|
|
| 241 | 241 |
<texture>$soil_texture</texture> |
| 242 | 242 |
</soilobs> |
| 243 | 243 |
<temperature_c>$temp_c</temperature_c> |
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 7 | 7 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
| 8 | 8 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
| 9 | 9 |
obsStartDate,/location/locationevent/obsstartdate/_*/date/_alt/1, |
| 10 |
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
|
| 10 |
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_frac,
|
|
| 11 | 11 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/3, |
| 12 | 12 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/scientificname, |
| 13 | 13 |
county,/location/locationplace/*_id/placepath/county, |
| inputs/CVS/Organism/test.xml.ref | ||
|---|---|---|
| 26 | 26 |
<authoreventcode>$authorObsCode</authoreventcode> |
| 27 | 27 |
<obsstartdate><_date><date>$obsStartDate</date></_date></obsstartdate> |
| 28 | 28 |
<taxonoccurrence> |
| 29 |
<aggregateoccurrence><cover>$%cover</cover></aggregateoccurrence>
|
|
| 29 |
<aggregateoccurrence><cover_frac>$%cover</cover_frac></aggregateoccurrence>
|
|
| 30 | 30 |
<authortaxoncode>$currentTaxonName sec Weakley 2006</authortaxoncode> |
| 31 | 31 |
<taxondetermination><taxonpath_id><taxonpath><scientificname>$currentTaxonName sec Weakley 2006</scientificname></taxonpath></taxonpath_id></taxondetermination> |
| 32 | 32 |
</taxonoccurrence> |
| inputs/SALVIAS/plotMetadata/VegBIEN.csv | ||
|---|---|---|
| 22 | 22 |
date_finish,/location/locationevent/obsenddate/_*/date/_alt/1, |
| 23 | 23 |
date_start,/location/locationevent/obsstartdate/_*/date/_alt/1, |
| 24 | 24 |
Precip,/location/locationevent/precipitation_m, |
| 25 |
soil_acidity,"/location/locationevent/soilobs/acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value", |
|
| 26 |
soil_base,"/location/locationevent/soilobs/basesaturation/_units:[default=""%"",to=]/value", |
|
| 27 |
soil_Ca,"/location/locationevent/soilobs/calcium/_units:[default=""%"",to=]/value", |
|
| 28 |
soil_C,"/location/locationevent/soilobs/carbon/_units:[default=""%"",to=]/value", |
|
| 29 |
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity, |
|
| 30 |
clay_percent,"/location/locationevent/soilobs/clay/_units:[default=""%"",to=]/value", |
|
| 25 |
soil_acidity,"/location/locationevent/soilobs/acidity_frac/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
|
|
| 26 |
soil_base,"/location/locationevent/soilobs/basesaturation_frac/_units:[default=""%"",to=]/value",
|
|
| 27 |
soil_Ca,"/location/locationevent/soilobs/calcium_frac/_units:[default=""%"",to=]/value",
|
|
| 28 |
soil_C,"/location/locationevent/soilobs/carbon_frac/_units:[default=""%"",to=]/value",
|
|
| 29 |
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
|
|
| 30 |
clay_percent,"/location/locationevent/soilobs/clay_frac/_units:[default=""%"",to=]/value",
|
|
| 31 | 31 |
soil_conductivity,/location/locationevent/soilobs/conductivity, |
| 32 |
soil_Mg,"/location/locationevent/soilobs/magnesium/_units:[default=""%"",to=]/value", |
|
| 33 |
soil_N,"/location/locationevent/soilobs/nitrogen/_units:[default=""%"",to=]/value", |
|
| 34 |
organic_percent,"/location/locationevent/soilobs/organic/_units:[default=""%"",to=]/value", |
|
| 32 |
soil_Mg,"/location/locationevent/soilobs/magnesium_frac/_units:[default=""%"",to=]/value",
|
|
| 33 |
soil_N,"/location/locationevent/soilobs/nitrogen_frac/_units:[default=""%"",to=]/value",
|
|
| 34 |
organic_percent,"/location/locationevent/soilobs/organic_frac/_units:[default=""%"",to=]/value",
|
|
| 35 | 35 |
pH,/location/locationevent/soilobs/ph,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss." |
| 36 |
soil_P,"/location/locationevent/soilobs/phosphorus/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value", |
|
| 37 |
soil_K,"/location/locationevent/soilobs/potassium/_units:[default=""%"",to=]/value", |
|
| 38 |
sand_percent,"/location/locationevent/soilobs/sand/_units:[default=""%"",to=]/value", |
|
| 39 |
silt_percent,"/location/locationevent/soilobs/silt/_units:[default=""%"",to=]/value", |
|
| 40 |
soil_Na,"/location/locationevent/soilobs/sodium/_units:[default=""%"",to=]/value", |
|
| 36 |
soil_P,"/location/locationevent/soilobs/phosphorus_frac/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
|
|
| 37 |
soil_K,"/location/locationevent/soilobs/potassium_frac/_units:[default=""%"",to=]/value",
|
|
| 38 |
sand_percent,"/location/locationevent/soilobs/sand_frac/_units:[default=""%"",to=]/value",
|
|
| 39 |
silt_percent,"/location/locationevent/soilobs/silt_frac/_units:[default=""%"",to=]/value",
|
|
| 40 |
soil_Na,"/location/locationevent/soilobs/sodium_frac/_units:[default=""%"",to=]/value",
|
|
| 41 | 41 |
soil_texture,"/location/locationevent/soilobs/texture/_units:[default=""%"",to=]/value", |
| 42 | 42 |
Temp,/location/locationevent/temperature_c, |
| 43 | 43 |
Locality_Description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX" |
| inputs/SALVIAS/plotMetadata/test.xml.ref | ||
|---|---|---|
| 132 | 132 |
<obsstartdate><_date><date>$date_start</date></_date></obsstartdate> |
| 133 | 133 |
<precipitation_m>$Precip</precipitation_m> |
| 134 | 134 |
<soilobs> |
| 135 |
<acidity> |
|
| 135 |
<acidity_frac>
|
|
| 136 | 136 |
<_units> |
| 137 | 137 |
<default>%</default> |
| 138 | 138 |
<to></to> |
| ... | ... | |
| 144 | 144 |
</_map> |
| 145 | 145 |
</value> |
| 146 | 146 |
</_units> |
| 147 |
</acidity> |
|
| 148 |
<basesaturation> |
|
| 147 |
</acidity_frac>
|
|
| 148 |
<basesaturation_frac>
|
|
| 149 | 149 |
<_units> |
| 150 | 150 |
<default>%</default> |
| 151 | 151 |
<to></to> |
| 152 | 152 |
<value>$soil_base</value> |
| 153 | 153 |
</_units> |
| 154 |
</basesaturation> |
|
| 155 |
<calcium> |
|
| 154 |
</basesaturation_frac>
|
|
| 155 |
<calcium_frac>
|
|
| 156 | 156 |
<_units> |
| 157 | 157 |
<default>%</default> |
| 158 | 158 |
<to></to> |
| 159 | 159 |
<value>$soil_Ca</value> |
| 160 | 160 |
</_units> |
| 161 |
</calcium> |
|
| 162 |
<carbon> |
|
| 161 |
</calcium_frac>
|
|
| 162 |
<carbon_frac>
|
|
| 163 | 163 |
<_units> |
| 164 | 164 |
<default>%</default> |
| 165 | 165 |
<to></to> |
| 166 | 166 |
<value>$soil_C</value> |
| 167 | 167 |
</_units> |
| 168 |
</carbon> |
|
| 169 |
<cationexchangecapacity>$soil_cation_cap</cationexchangecapacity>
|
|
| 170 |
<clay> |
|
| 168 |
</carbon_frac>
|
|
| 169 |
<cationexchangecapacity_cmol_kg>$soil_cation_cap</cationexchangecapacity_cmol_kg>
|
|
| 170 |
<clay_frac>
|
|
| 171 | 171 |
<_units> |
| 172 | 172 |
<default>%</default> |
| 173 | 173 |
<to></to> |
| 174 | 174 |
<value>$clay_percent</value> |
| 175 | 175 |
</_units> |
| 176 |
</clay> |
|
| 176 |
</clay_frac>
|
|
| 177 | 177 |
<conductivity>$soil_conductivity</conductivity> |
| 178 |
<magnesium> |
|
| 178 |
<magnesium_frac>
|
|
| 179 | 179 |
<_units> |
| 180 | 180 |
<default>%</default> |
| 181 | 181 |
<to></to> |
| 182 | 182 |
<value>$soil_Mg</value> |
| 183 | 183 |
</_units> |
| 184 |
</magnesium> |
|
| 185 |
<nitrogen> |
|
| 184 |
</magnesium_frac>
|
|
| 185 |
<nitrogen_frac>
|
|
| 186 | 186 |
<_units> |
| 187 | 187 |
<default>%</default> |
| 188 | 188 |
<to></to> |
| 189 | 189 |
<value>$soil_N</value> |
| 190 | 190 |
</_units> |
| 191 |
</nitrogen> |
|
| 192 |
<organic> |
|
| 191 |
</nitrogen_frac>
|
|
| 192 |
<organic_frac>
|
|
| 193 | 193 |
<_units> |
| 194 | 194 |
<default>%</default> |
| 195 | 195 |
<to></to> |
| 196 | 196 |
<value>$organic_percent</value> |
| 197 | 197 |
</_units> |
| 198 |
</organic> |
|
| 198 |
</organic_frac>
|
|
| 199 | 199 |
<ph>$pH</ph> |
| 200 |
<phosphorus> |
|
| 200 |
<phosphorus_frac>
|
|
| 201 | 201 |
<_units> |
| 202 | 202 |
<default>%</default> |
| 203 | 203 |
<to></to> |
| ... | ... | |
| 209 | 209 |
</_map> |
| 210 | 210 |
</value> |
| 211 | 211 |
</_units> |
| 212 |
</phosphorus> |
|
| 213 |
<potassium> |
|
| 212 |
</phosphorus_frac>
|
|
| 213 |
<potassium_frac>
|
|
| 214 | 214 |
<_units> |
| 215 | 215 |
<default>%</default> |
| 216 | 216 |
<to></to> |
| 217 | 217 |
<value>$soil_K</value> |
| 218 | 218 |
</_units> |
| 219 |
</potassium> |
|
| 220 |
<sand> |
|
| 219 |
</potassium_frac>
|
|
| 220 |
<sand_frac>
|
|
| 221 | 221 |
<_units> |
| 222 | 222 |
<default>%</default> |
| 223 | 223 |
<to></to> |
| 224 | 224 |
<value>$sand_percent</value> |
| 225 | 225 |
</_units> |
| 226 |
</sand> |
|
| 227 |
<silt> |
|
| 226 |
</sand_frac>
|
|
| 227 |
<silt_frac>
|
|
| 228 | 228 |
<_units> |
| 229 | 229 |
<default>%</default> |
| 230 | 230 |
<to></to> |
| 231 | 231 |
<value>$silt_percent</value> |
| 232 | 232 |
</_units> |
| 233 |
</silt> |
|
| 234 |
<sodium> |
|
| 233 |
</silt_frac>
|
|
| 234 |
<sodium_frac>
|
|
| 235 | 235 |
<_units> |
| 236 | 236 |
<default>%</default> |
| 237 | 237 |
<to></to> |
| 238 | 238 |
<value>$soil_Na</value> |
| 239 | 239 |
</_units> |
| 240 |
</sodium> |
|
| 240 |
</sodium_frac>
|
|
| 241 | 241 |
<texture> |
| 242 | 242 |
<_units> |
| 243 | 243 |
<default>%</default> |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 29 | 29 |
HAVING count(DISTINCT census_date) > 1 |
| 30 | 30 |
-----" |
| 31 | 31 |
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this." |
| 32 |
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
|
| 32 |
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_frac,
|
|
| 33 | 33 |
census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 34 |
intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,"Brad: This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance." |
|
| 34 |
intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m,"Brad: This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
|
|
| 35 | 35 |
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
| 36 | 36 |
Ind,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| 37 | 37 |
PlotObsID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| inputs/SALVIAS/plotObservations/test.xml.ref | ||
|---|---|---|
| 17 | 17 |
<taxonoccurrence> |
| 18 | 18 |
<aggregateoccurrence> |
| 19 | 19 |
<count>$NoInd</count> |
| 20 |
<cover>$cover_percent</cover>
|
|
| 20 |
<cover_frac>$cover_percent</cover_frac>
|
|
| 21 | 21 |
<definedvalue fkey="tablerecord_id"> |
| 22 | 22 |
<userdefined_id> |
| 23 | 23 |
<userdefined> |
| ... | ... | |
| 27 | 27 |
</userdefined_id> |
| 28 | 28 |
<definedvalue>$census_no</definedvalue> |
| 29 | 29 |
</definedvalue> |
| 30 |
<linecover>$intercept_cm</linecover>
|
|
| 30 |
<linecover_m>$intercept_cm</linecover_m>
|
|
| 31 | 31 |
<notes>$Notes</notes> |
| 32 | 32 |
<plantobservation> |
| 33 | 33 |
<collectionnumber>$Ind</collectionnumber> |
| inputs/VegBank/observation_/VegBIEN.csv | ||
|---|---|---|
| 14 | 14 |
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
| 15 | 15 |
obsenddate,/location/locationevent/obsenddate/_*/date/_alt/1, |
| 16 | 16 |
obsstartdate,/location/locationevent/obsstartdate/_*/date/_alt/1, |
| 17 |
basesaturation,/location/locationevent/soilobs/basesaturation, |
|
| 18 |
exchangecapacity,/location/locationevent/soilobs/cationexchangecapacity, |
|
| 19 |
soilclay,/location/locationevent/soilobs/clay, |
|
| 20 |
soilorganic,/location/locationevent/soilobs/organic, |
|
| 17 |
basesaturation,/location/locationevent/soilobs/basesaturation_frac,
|
|
| 18 |
exchangecapacity,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
|
|
| 19 |
soilclay,/location/locationevent/soilobs/clay_frac,
|
|
| 20 |
soilorganic,/location/locationevent/soilobs/organic_frac,
|
|
| 21 | 21 |
soilph,/location/locationevent/soilobs/ph, |
| 22 |
soilsand,/location/locationevent/soilobs/sand, |
|
| 23 |
soilsilt,/location/locationevent/soilobs/silt, |
|
| 22 |
soilsand,/location/locationevent/soilobs/sand_frac,
|
|
| 23 |
soilsilt,/location/locationevent/soilobs/silt_frac,
|
|
| 24 | 24 |
soiltexture,/location/locationevent/soilobs/texture, |
| 25 | 25 |
accessioncode,,** No join mapping for accessioncode ** |
| 26 | 26 |
autotaxoncover,,** No join mapping for autotaxoncover ** |
| inputs/VegBank/observation_/test.xml.ref | ||
|---|---|---|
| 13 | 13 |
<obsenddate><_date><date>$obsenddate</date></_date></obsenddate> |
| 14 | 14 |
<obsstartdate><_date><date>$obsstartdate</date></_date></obsstartdate> |
| 15 | 15 |
<soilobs> |
| 16 |
<basesaturation>$basesaturation</basesaturation>
|
|
| 17 |
<cationexchangecapacity>$exchangecapacity</cationexchangecapacity>
|
|
| 18 |
<clay>$soilclay</clay>
|
|
| 19 |
<organic>$soilorganic</organic>
|
|
| 16 |
<basesaturation_frac>$basesaturation</basesaturation_frac>
|
|
| 17 |
<cationexchangecapacity_cmol_kg>$exchangecapacity</cationexchangecapacity_cmol_kg>
|
|
| 18 |
<clay_frac>$soilclay</clay_frac>
|
|
| 19 |
<organic_frac>$soilorganic</organic_frac>
|
|
| 20 | 20 |
<ph>$soilph</ph> |
| 21 |
<sand>$soilsand</sand>
|
|
| 22 |
<silt>$soilsilt</silt>
|
|
| 21 |
<sand_frac>$soilsand</sand_frac>
|
|
| 22 |
<silt_frac>$soilsilt</silt_frac>
|
|
| 23 | 23 |
<texture>$soiltexture</texture> |
| 24 | 24 |
</soilobs> |
| 25 | 25 |
</locationevent> |
| schemas/vegbien.my.sql | ||
|---|---|---|
| 171 | 171 |
sourceaccessioncode text, |
| 172 | 172 |
taxonoccurrence_id int(11) NOT NULL, |
| 173 | 173 |
collectiondate timestamp NULL, |
| 174 |
cover double precision, |
|
| 175 |
linecover double precision, |
|
| 176 |
basalarea double precision, |
|
| 177 |
biomass double precision, |
|
| 178 |
inferencearea double precision, |
|
| 174 |
cover_frac double precision,
|
|
| 175 |
linecover_m double precision,
|
|
| 176 |
basalarea_m2 double precision,
|
|
| 177 |
biomass_kg_m2 double precision,
|
|
| 178 |
inferencearea_m2 double precision,
|
|
| 179 | 179 |
count int(11), |
| 180 | 180 |
stratum_id int(11), |
| 181 | 181 |
coverindex_id int(11), |
| ... | ... | |
| 194 | 194 |
|
| 195 | 195 |
|
| 196 | 196 |
-- |
| 197 |
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: - |
|
| 197 |
-- Name: COLUMN aggregateoccurrence.linecover_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 198 | 198 |
-- |
| 199 | 199 |
|
| 200 | 200 |
|
| ... | ... | |
| 433 | 433 |
reference_id int(11), |
| 434 | 434 |
name text NOT NULL, |
| 435 | 435 |
description text, |
| 436 |
diameterheight double precision, |
|
| 437 |
mindiameter double precision, |
|
| 438 |
maxdiameter double precision, |
|
| 439 |
minheight double precision, |
|
| 440 |
maxheight double precision, |
|
| 436 |
diameterheight_m double precision,
|
|
| 437 |
mindiameter_m double precision,
|
|
| 438 |
maxdiameter_m double precision,
|
|
| 439 |
minheight_m double precision,
|
|
| 440 |
maxheight_m double precision,
|
|
| 441 | 441 |
observationtype text, |
| 442 | 442 |
observationmeasure text, |
| 443 | 443 |
covermethod_id int(11), |
| ... | ... | |
| 445 | 445 |
coverbasis text, |
| 446 | 446 |
stemsamplemethod text, |
| 447 | 447 |
shape text, |
| 448 |
length double precision, |
|
| 449 |
width double precision, |
|
| 450 |
radius double precision, |
|
| 451 |
area double precision, |
|
| 452 |
samplearea double precision, |
|
| 453 |
subplotspacing double precision, |
|
| 448 |
length_m double precision,
|
|
| 449 |
width_m double precision,
|
|
| 450 |
radius_m double precision,
|
|
| 451 |
area_m2 double precision,
|
|
| 452 |
samplearea_m2 double precision,
|
|
| 453 |
subplotspacing_m double precision,
|
|
| 454 | 454 |
subplotmethod_id int(11), |
| 455 | 455 |
pointsperline int(11), |
| 456 | 456 |
accessioncode text |
| ... | ... | |
| 486 | 486 |
|
| 487 | 487 |
|
| 488 | 488 |
-- |
| 489 |
-- Name: COLUMN method.diameterheight; Type: COMMENT; Schema: public; Owner: - |
|
| 489 |
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 490 | 490 |
-- |
| 491 | 491 |
|
| 492 | 492 |
|
| 493 | 493 |
|
| 494 | 494 |
|
| 495 | 495 |
-- |
| 496 |
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: - |
|
| 496 |
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 497 | 497 |
-- |
| 498 | 498 |
|
| 499 | 499 |
|
| 500 | 500 |
|
| 501 | 501 |
|
| 502 | 502 |
-- |
| 503 |
-- Name: COLUMN method.maxdiameter; Type: COMMENT; Schema: public; Owner: - |
|
| 503 |
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 504 | 504 |
-- |
| 505 | 505 |
|
| 506 | 506 |
|
| 507 | 507 |
|
| 508 | 508 |
|
| 509 | 509 |
-- |
| 510 |
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: - |
|
| 510 |
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 511 | 511 |
-- |
| 512 | 512 |
|
| 513 | 513 |
|
| 514 | 514 |
|
| 515 | 515 |
|
| 516 | 516 |
-- |
| 517 |
-- Name: COLUMN method.maxheight; Type: COMMENT; Schema: public; Owner: - |
|
| 517 |
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 518 | 518 |
-- |
| 519 | 519 |
|
| 520 | 520 |
|
| ... | ... | |
| 563 | 563 |
|
| 564 | 564 |
|
| 565 | 565 |
-- |
| 566 |
-- Name: COLUMN method.length; Type: COMMENT; Schema: public; Owner: - |
|
| 566 |
-- Name: COLUMN method.length_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 567 | 567 |
-- |
| 568 | 568 |
|
| 569 | 569 |
|
| 570 | 570 |
|
| 571 | 571 |
|
| 572 | 572 |
-- |
| 573 |
-- Name: COLUMN method.width; Type: COMMENT; Schema: public; Owner: - |
|
| 573 |
-- Name: COLUMN method.width_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 574 | 574 |
-- |
| 575 | 575 |
|
| 576 | 576 |
|
| 577 | 577 |
|
| 578 | 578 |
|
| 579 | 579 |
-- |
| 580 |
-- Name: COLUMN method.radius; Type: COMMENT; Schema: public; Owner: - |
|
| 580 |
-- Name: COLUMN method.radius_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 581 | 581 |
-- |
| 582 | 582 |
|
| 583 | 583 |
|
| 584 | 584 |
|
| 585 | 585 |
|
| 586 | 586 |
-- |
| 587 |
-- Name: COLUMN method.area; Type: COMMENT; Schema: public; Owner: - |
|
| 587 |
-- Name: COLUMN method.area_m2; Type: COMMENT; Schema: public; Owner: -
|
|
| 588 | 588 |
-- |
| 589 | 589 |
|
| 590 | 590 |
|
| 591 | 591 |
|
| 592 | 592 |
|
| 593 | 593 |
-- |
| 594 |
-- Name: COLUMN method.samplearea; Type: COMMENT; Schema: public; Owner: - |
|
| 594 |
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
|
|
| 595 | 595 |
-- |
| 596 | 596 |
|
| 597 | 597 |
|
| 598 | 598 |
|
| 599 | 599 |
|
| 600 | 600 |
-- |
| 601 |
-- Name: COLUMN method.subplotspacing; Type: COMMENT; Schema: public; Owner: - |
|
| 601 |
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 602 | 602 |
-- |
| 603 | 603 |
|
| 604 | 604 |
|
| ... | ... | |
| 862 | 862 |
-- |
| 863 | 863 |
|
| 864 | 864 |
CREATE VIEW analytical_db_view AS |
| 865 |
SELECT datasource.organizationname AS `dataSourceName`, taxonpath.family, taxonpath.genus, taxonpath.species, COALESCE(taxonpath.scientificnamewithauthor, taxonpath.scientificname) AS taxon, taxonpath.scientificnameauthor AS `taxonAuthor`, taxonpath.variety AS `taxonMorphospecies`, placepath.country, placepath.stateprovince AS `stateProvince`, placepath.county AS `countyParish`, taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS `collectionNumber`, array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], CAST(' ' AS text)) AS `identifiedBy`, aggregateoccurrence.collectiondate AS `observationDate`, location.authorlocationcode AS `plotCode`, location.area_m2 AS `plotAreaHa`, method.name AS `plotMethod`, locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS `isCultivated`, taxonoccurrence.cultivatedbasis AS `isCultivatedReason`, aggregateoccurrence.cover AS `pctCover` FROM (((((((((((((location JOIN party datasource ON (((datasource.party_id = location.datasource_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonpath USING (taxonpath_id)) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
|
|
| 865 |
SELECT datasource.organizationname AS `dataSourceName`, taxonpath.family, taxonpath.genus, taxonpath.species, COALESCE(taxonpath.scientificnamewithauthor, taxonpath.scientificname) AS taxon, taxonpath.scientificnameauthor AS `taxonAuthor`, taxonpath.variety AS `taxonMorphospecies`, placepath.country, placepath.stateprovince AS `stateProvince`, placepath.county AS `countyParish`, taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS `collectionNumber`, array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], CAST(' ' AS text)) AS `identifiedBy`, aggregateoccurrence.collectiondate AS `observationDate`, location.authorlocationcode AS `plotCode`, location.area_m2 AS `plotAreaHa`, method.name AS `plotMethod`, locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS `isCultivated`, taxonoccurrence.cultivatedbasis AS `isCultivatedReason`, aggregateoccurrence.cover_frac AS `pctCover` FROM (((((((((((((location JOIN party datasource ON (((datasource.party_id = location.datasource_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonpath USING (taxonpath_id)) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
|
|
| 866 | 866 |
|
| 867 | 867 |
|
| 868 | 868 |
-- |
| ... | ... | |
| 2059 | 2059 |
locationevent_id int(11) NOT NULL, |
| 2060 | 2060 |
horizon text DEFAULT 'unknown' NOT NULL, |
| 2061 | 2061 |
description text, |
| 2062 |
depthtop double precision, |
|
| 2063 |
depthbottom double precision, |
|
| 2062 |
depthtop_m double precision,
|
|
| 2063 |
depthbottom_m double precision,
|
|
| 2064 | 2064 |
color text, |
| 2065 | 2065 |
texture text, |
| 2066 |
organic double precision, |
|
| 2067 |
sand double precision, |
|
| 2068 |
silt double precision, |
|
| 2069 |
clay double precision, |
|
| 2070 |
coarse double precision, |
|
| 2066 |
organic_frac double precision,
|
|
| 2067 |
sand_frac double precision,
|
|
| 2068 |
silt_frac double precision,
|
|
| 2069 |
clay_frac double precision,
|
|
| 2070 |
coarse_frac double precision,
|
|
| 2071 | 2071 |
ph double precision, |
| 2072 |
acidity double precision, |
|
| 2073 |
basesaturation double precision, |
|
| 2074 |
cationexchangecapacity double precision, |
|
| 2072 |
acidity_frac double precision,
|
|
| 2073 |
basesaturation_frac double precision,
|
|
| 2074 |
cationexchangecapacity_cmol_kg double precision,
|
|
| 2075 | 2075 |
conductivity double precision, |
| 2076 |
carbon double precision, |
|
| 2077 |
phosphorus double precision, |
|
| 2078 |
potassium double precision, |
|
| 2079 |
magnesium double precision, |
|
| 2080 |
nitrogen double precision, |
|
| 2081 |
calcium double precision, |
|
| 2082 |
sodium double precision |
|
| 2076 |
carbon_frac double precision,
|
|
| 2077 |
phosphorus_frac double precision,
|
|
| 2078 |
potassium_frac double precision,
|
|
| 2079 |
magnesium_frac double precision,
|
|
| 2080 |
nitrogen_frac double precision,
|
|
| 2081 |
calcium_frac double precision,
|
|
| 2082 |
sodium_frac double precision
|
|
| 2083 | 2083 |
); |
| 2084 | 2084 |
|
| 2085 | 2085 |
|
| 2086 | 2086 |
-- |
| 2087 |
-- Name: COLUMN soilobs.organic; Type: COMMENT; Schema: public; Owner: - |
|
| 2087 |
-- Name: COLUMN soilobs.organic_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2088 | 2088 |
-- |
| 2089 | 2089 |
|
| 2090 | 2090 |
|
| 2091 | 2091 |
|
| 2092 | 2092 |
|
| 2093 | 2093 |
-- |
| 2094 |
-- Name: COLUMN soilobs.sand; Type: COMMENT; Schema: public; Owner: - |
|
| 2094 |
-- Name: COLUMN soilobs.sand_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2095 | 2095 |
-- |
| 2096 | 2096 |
|
| 2097 | 2097 |
|
| 2098 | 2098 |
|
| 2099 | 2099 |
|
| 2100 | 2100 |
-- |
| 2101 |
-- Name: COLUMN soilobs.silt; Type: COMMENT; Schema: public; Owner: - |
|
| 2101 |
-- Name: COLUMN soilobs.silt_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2102 | 2102 |
-- |
| 2103 | 2103 |
|
| 2104 | 2104 |
|
| 2105 | 2105 |
|
| 2106 | 2106 |
|
| 2107 | 2107 |
-- |
| 2108 |
-- Name: COLUMN soilobs.clay; Type: COMMENT; Schema: public; Owner: - |
|
| 2108 |
-- Name: COLUMN soilobs.clay_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2109 | 2109 |
-- |
| 2110 | 2110 |
|
| 2111 | 2111 |
|
| 2112 | 2112 |
|
| 2113 | 2113 |
|
| 2114 | 2114 |
-- |
| 2115 |
-- Name: COLUMN soilobs.coarse; Type: COMMENT; Schema: public; Owner: - |
|
| 2115 |
-- Name: COLUMN soilobs.coarse_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2116 | 2116 |
-- |
| 2117 | 2117 |
|
| 2118 | 2118 |
|
| 2119 | 2119 |
|
| 2120 | 2120 |
|
| 2121 | 2121 |
-- |
| 2122 |
-- Name: COLUMN soilobs.acidity; Type: COMMENT; Schema: public; Owner: - |
|
| 2122 |
-- Name: COLUMN soilobs.acidity_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2123 | 2123 |
-- |
| 2124 | 2124 |
|
| 2125 | 2125 |
|
| 2126 | 2126 |
|
| 2127 | 2127 |
|
| 2128 | 2128 |
-- |
| 2129 |
-- Name: COLUMN soilobs.basesaturation; Type: COMMENT; Schema: public; Owner: - |
|
| 2129 |
-- Name: COLUMN soilobs.basesaturation_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2130 | 2130 |
-- |
| 2131 | 2131 |
|
| 2132 | 2132 |
|
| 2133 | 2133 |
|
| 2134 | 2134 |
|
| 2135 | 2135 |
-- |
| 2136 |
-- Name: COLUMN soilobs.carbon; Type: COMMENT; Schema: public; Owner: - |
|
| 2136 |
-- Name: COLUMN soilobs.carbon_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2137 | 2137 |
-- |
| 2138 | 2138 |
|
| 2139 | 2139 |
|
| 2140 | 2140 |
|
| 2141 | 2141 |
|
| 2142 | 2142 |
-- |
| 2143 |
-- Name: COLUMN soilobs.phosphorus; Type: COMMENT; Schema: public; Owner: - |
|
| 2143 |
-- Name: COLUMN soilobs.phosphorus_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2144 | 2144 |
-- |
| 2145 | 2145 |
|
| 2146 | 2146 |
|
| 2147 | 2147 |
|
| 2148 | 2148 |
|
| 2149 | 2149 |
-- |
| 2150 |
-- Name: COLUMN soilobs.potassium; Type: COMMENT; Schema: public; Owner: - |
|
| 2150 |
-- Name: COLUMN soilobs.potassium_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2151 | 2151 |
-- |
| 2152 | 2152 |
|
| 2153 | 2153 |
|
| 2154 | 2154 |
|
| 2155 | 2155 |
|
| 2156 | 2156 |
-- |
| 2157 |
-- Name: COLUMN soilobs.magnesium; Type: COMMENT; Schema: public; Owner: - |
|
| 2157 |
-- Name: COLUMN soilobs.magnesium_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2158 | 2158 |
-- |
| 2159 | 2159 |
|
| 2160 | 2160 |
|
| 2161 | 2161 |
|
| 2162 | 2162 |
|
| 2163 | 2163 |
-- |
| 2164 |
-- Name: COLUMN soilobs.nitrogen; Type: COMMENT; Schema: public; Owner: - |
|
| 2164 |
-- Name: COLUMN soilobs.nitrogen_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2165 | 2165 |
-- |
| 2166 | 2166 |
|
| 2167 | 2167 |
|
| 2168 | 2168 |
|
| 2169 | 2169 |
|
| 2170 | 2170 |
-- |
| 2171 |
-- Name: COLUMN soilobs.calcium; Type: COMMENT; Schema: public; Owner: - |
|
| 2171 |
-- Name: COLUMN soilobs.calcium_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2172 | 2172 |
-- |
| 2173 | 2173 |
|
| 2174 | 2174 |
|
| 2175 | 2175 |
|
| 2176 | 2176 |
|
| 2177 | 2177 |
-- |
| 2178 |
-- Name: COLUMN soilobs.sodium; Type: COMMENT; Schema: public; Owner: - |
|
| 2178 |
-- Name: COLUMN soilobs.sodium_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2179 | 2179 |
-- |
| 2180 | 2180 |
|
| 2181 | 2181 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 418 | 418 |
sourceaccessioncode text, |
| 419 | 419 |
taxonoccurrence_id integer NOT NULL, |
| 420 | 420 |
collectiondate timestamp with time zone, |
| 421 |
cover double precision, |
|
| 422 |
linecover double precision, |
|
| 423 |
basalarea double precision, |
|
| 424 |
biomass double precision, |
|
| 425 |
inferencearea double precision, |
|
| 421 |
cover_frac double precision,
|
|
| 422 |
linecover_m double precision,
|
|
| 423 |
basalarea_m2 double precision,
|
|
| 424 |
biomass_kg_m2 double precision,
|
|
| 425 |
inferencearea_m2 double precision,
|
|
| 426 | 426 |
count integer, |
| 427 | 427 |
stratum_id integer, |
| 428 | 428 |
coverindex_id integer, |
| ... | ... | |
| 441 | 441 |
|
| 442 | 442 |
|
| 443 | 443 |
-- |
| 444 |
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: - |
|
| 444 |
-- Name: COLUMN aggregateoccurrence.linecover_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 445 | 445 |
-- |
| 446 | 446 |
|
| 447 |
COMMENT ON COLUMN aggregateoccurrence.linecover IS 'The distance in m along which this occurrence intercepts a line subplot.'; |
|
| 447 |
COMMENT ON COLUMN aggregateoccurrence.linecover_m IS 'The distance in m along which this occurrence intercepts a line subplot.';
|
|
| 448 | 448 |
|
| 449 | 449 |
|
| 450 | 450 |
-- |
| ... | ... | |
| 687 | 687 |
reference_id integer, |
| 688 | 688 |
name text NOT NULL, |
| 689 | 689 |
description text, |
| 690 |
diameterheight double precision, |
|
| 691 |
mindiameter double precision, |
|
| 692 |
maxdiameter double precision, |
|
| 693 |
minheight double precision, |
|
| 694 |
maxheight double precision, |
|
| 690 |
diameterheight_m double precision,
|
|
| 691 |
mindiameter_m double precision,
|
|
| 692 |
maxdiameter_m double precision,
|
|
| 693 |
minheight_m double precision,
|
|
| 694 |
maxheight_m double precision,
|
|
| 695 | 695 |
observationtype text, |
| 696 | 696 |
observationmeasure text, |
| 697 | 697 |
covermethod_id integer, |
| ... | ... | |
| 699 | 699 |
coverbasis text, |
| 700 | 700 |
stemsamplemethod text, |
| 701 | 701 |
shape text, |
| 702 |
length double precision, |
|
| 703 |
width double precision, |
|
| 704 |
radius double precision, |
|
| 705 |
area double precision, |
|
| 706 |
samplearea double precision, |
|
| 707 |
subplotspacing double precision, |
|
| 702 |
length_m double precision,
|
|
| 703 |
width_m double precision,
|
|
| 704 |
radius_m double precision,
|
|
| 705 |
area_m2 double precision,
|
|
| 706 |
samplearea_m2 double precision,
|
|
| 707 |
subplotspacing_m double precision,
|
|
| 708 | 708 |
subplotmethod_id integer, |
| 709 | 709 |
pointsperline integer, |
| 710 | 710 |
accessioncode text |
| ... | ... | |
| 742 | 742 |
|
| 743 | 743 |
|
| 744 | 744 |
-- |
| 745 |
-- Name: COLUMN method.diameterheight; Type: COMMENT; Schema: public; Owner: - |
|
| 745 |
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 746 | 746 |
-- |
| 747 | 747 |
|
| 748 |
COMMENT ON COLUMN method.diameterheight IS 'The height in m at which the diameter is measured. e.g. 1.37 m for breast height (DBH).'; |
|
| 748 |
COMMENT ON COLUMN method.diameterheight_m IS 'The height in m at which the diameter is measured. e.g. 1.37 m for breast height (DBH).';
|
|
| 749 | 749 |
|
| 750 | 750 |
|
| 751 | 751 |
-- |
| 752 |
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: - |
|
| 752 |
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 753 | 753 |
-- |
| 754 | 754 |
|
| 755 |
COMMENT ON COLUMN method.mindiameter IS 'Lower diameter limit in m for inclusion of a tree.'; |
|
| 755 |
COMMENT ON COLUMN method.mindiameter_m IS 'Lower diameter limit in m for inclusion of a tree.';
|
|
| 756 | 756 |
|
| 757 | 757 |
|
| 758 | 758 |
-- |
| 759 |
-- Name: COLUMN method.maxdiameter; Type: COMMENT; Schema: public; Owner: - |
|
| 759 |
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 760 | 760 |
-- |
| 761 | 761 |
|
| 762 |
COMMENT ON COLUMN method.maxdiameter IS 'Upper diameter limit in m for inclusion of a tree.'; |
|
| 762 |
COMMENT ON COLUMN method.maxdiameter_m IS 'Upper diameter limit in m for inclusion of a tree.';
|
|
| 763 | 763 |
|
| 764 | 764 |
|
| 765 | 765 |
-- |
| 766 |
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: - |
|
| 766 |
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 767 | 767 |
-- |
| 768 | 768 |
|
| 769 |
COMMENT ON COLUMN method.minheight IS 'Lower height limit in m for inclusion of a tree.'; |
|
| 769 |
COMMENT ON COLUMN method.minheight_m IS 'Lower height limit in m for inclusion of a tree.';
|
|
| 770 | 770 |
|
| 771 | 771 |
|
| 772 | 772 |
-- |
| 773 |
-- Name: COLUMN method.maxheight; Type: COMMENT; Schema: public; Owner: - |
|
| 773 |
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 774 | 774 |
-- |
| 775 | 775 |
|
| 776 |
COMMENT ON COLUMN method.maxheight IS 'Upper height limit in m for inclusion of a tree.'; |
|
| 776 |
COMMENT ON COLUMN method.maxheight_m IS 'Upper height limit in m for inclusion of a tree.';
|
|
| 777 | 777 |
|
| 778 | 778 |
|
| 779 | 779 |
-- |
| ... | ... | |
| 840 | 840 |
|
| 841 | 841 |
|
| 842 | 842 |
-- |
| 843 |
-- Name: COLUMN method.length; Type: COMMENT; Schema: public; Owner: - |
|
| 843 |
-- Name: COLUMN method.length_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 844 | 844 |
-- |
| 845 | 845 |
|
| 846 |
COMMENT ON COLUMN method.length IS 'Units: m'; |
|
| 846 |
COMMENT ON COLUMN method.length_m IS 'Units: m';
|
|
| 847 | 847 |
|
| 848 | 848 |
|
| 849 | 849 |
-- |
| 850 |
-- Name: COLUMN method.width; Type: COMMENT; Schema: public; Owner: - |
|
| 850 |
-- Name: COLUMN method.width_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 851 | 851 |
-- |
| 852 | 852 |
|
| 853 |
COMMENT ON COLUMN method.width IS 'Units: m'; |
|
| 853 |
COMMENT ON COLUMN method.width_m IS 'Units: m';
|
|
| 854 | 854 |
|
| 855 | 855 |
|
| 856 | 856 |
-- |
| 857 |
-- Name: COLUMN method.radius; Type: COMMENT; Schema: public; Owner: - |
|
| 857 |
-- Name: COLUMN method.radius_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 858 | 858 |
-- |
| 859 | 859 |
|
| 860 |
COMMENT ON COLUMN method.radius IS 'Units: m'; |
|
| 860 |
COMMENT ON COLUMN method.radius_m IS 'Units: m';
|
|
| 861 | 861 |
|
| 862 | 862 |
|
| 863 | 863 |
-- |
| 864 |
-- Name: COLUMN method.area; Type: COMMENT; Schema: public; Owner: - |
|
| 864 |
-- Name: COLUMN method.area_m2; Type: COMMENT; Schema: public; Owner: -
|
|
| 865 | 865 |
-- |
| 866 | 866 |
|
| 867 |
COMMENT ON COLUMN method.area IS 'Units: m^2'; |
|
| 867 |
COMMENT ON COLUMN method.area_m2 IS 'Units: m^2';
|
|
| 868 | 868 |
|
| 869 | 869 |
|
| 870 | 870 |
-- |
| 871 |
-- Name: COLUMN method.samplearea; Type: COMMENT; Schema: public; Owner: - |
|
| 871 |
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
|
|
| 872 | 872 |
-- |
| 873 | 873 |
|
| 874 |
COMMENT ON COLUMN method.samplearea IS 'The total surface area 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 interstitial space. |
|
| 874 |
COMMENT ON COLUMN method.samplearea_m2 IS 'The total surface area 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 interstitial space.
|
|
| 875 | 875 |
|
| 876 | 876 |
Units: m^2'; |
| 877 | 877 |
|
| 878 | 878 |
|
| 879 | 879 |
-- |
| 880 |
-- Name: COLUMN method.subplotspacing; Type: COMMENT; Schema: public; Owner: - |
|
| 880 |
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 881 | 881 |
-- |
| 882 | 882 |
|
| 883 |
COMMENT ON COLUMN method.subplotspacing IS 'Spacing in m between adjacent subplots, lines (line-intercept data), or points (point-intercept data).'; |
|
| 883 |
COMMENT ON COLUMN method.subplotspacing_m IS 'Spacing in m between adjacent subplots, lines (line-intercept data), or points (point-intercept data).';
|
|
| 884 | 884 |
|
| 885 | 885 |
|
| 886 | 886 |
-- |
| ... | ... | |
| 1142 | 1142 |
-- |
| 1143 | 1143 |
|
| 1144 | 1144 |
CREATE VIEW analytical_db_view AS |
| 1145 |
SELECT datasource.organizationname AS "dataSourceName", taxonpath.family, taxonpath.genus, taxonpath.species, COALESCE(taxonpath.scientificnamewithauthor, taxonpath.scientificname) AS taxon, taxonpath.scientificnameauthor AS "taxonAuthor", taxonpath.variety AS "taxonMorphospecies", placepath.country, placepath.stateprovince AS "stateProvince", placepath.county AS "countyParish", taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS "collectionNumber", array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], ' '::text) AS "identifiedBy", aggregateoccurrence.collectiondate AS "observationDate", location.authorlocationcode AS "plotCode", location.area_m2 AS "plotAreaHa", method.name AS "plotMethod", locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS "isCultivated", taxonoccurrence.cultivatedbasis AS "isCultivatedReason", aggregateoccurrence.cover AS "pctCover" FROM (((((((((((((location JOIN party datasource ON (((datasource.party_id = location.datasource_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonpath USING (taxonpath_id)) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id)); |
|
| 1145 |
SELECT datasource.organizationname AS "dataSourceName", taxonpath.family, taxonpath.genus, taxonpath.species, COALESCE(taxonpath.scientificnamewithauthor, taxonpath.scientificname) AS taxon, taxonpath.scientificnameauthor AS "taxonAuthor", taxonpath.variety AS "taxonMorphospecies", placepath.country, placepath.stateprovince AS "stateProvince", placepath.county AS "countyParish", taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS "collectionNumber", array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], ' '::text) AS "identifiedBy", aggregateoccurrence.collectiondate AS "observationDate", location.authorlocationcode AS "plotCode", location.area_m2 AS "plotAreaHa", method.name AS "plotMethod", locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS "isCultivated", taxonoccurrence.cultivatedbasis AS "isCultivatedReason", aggregateoccurrence.cover_frac AS "pctCover" FROM (((((((((((((location JOIN party datasource ON (((datasource.party_id = location.datasource_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonpath USING (taxonpath_id)) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
|
|
| 1146 | 1146 |
|
| 1147 | 1147 |
|
| 1148 | 1148 |
-- |
| ... | ... | |
| 2561 | 2561 |
locationevent_id integer NOT NULL, |
| 2562 | 2562 |
horizon text DEFAULT 'unknown'::text NOT NULL, |
| 2563 | 2563 |
description text, |
| 2564 |
depthtop double precision, |
|
| 2565 |
depthbottom double precision, |
|
| 2564 |
depthtop_m double precision,
|
|
| 2565 |
depthbottom_m double precision,
|
|
| 2566 | 2566 |
color text, |
| 2567 | 2567 |
texture text, |
| 2568 |
organic double precision, |
|
| 2569 |
sand double precision, |
|
| 2570 |
silt double precision, |
|
| 2571 |
clay double precision, |
|
| 2572 |
coarse double precision, |
|
| 2568 |
organic_frac double precision,
|
|
| 2569 |
sand_frac double precision,
|
|
| 2570 |
silt_frac double precision,
|
|
| 2571 |
clay_frac double precision,
|
|
| 2572 |
coarse_frac double precision,
|
|
| 2573 | 2573 |
ph double precision, |
| 2574 |
acidity double precision, |
|
| 2575 |
basesaturation double precision, |
|
| 2576 |
cationexchangecapacity double precision, |
|
| 2574 |
acidity_frac double precision,
|
|
| 2575 |
basesaturation_frac double precision,
|
|
| 2576 |
cationexchangecapacity_cmol_kg double precision,
|
|
| 2577 | 2577 |
conductivity double precision, |
| 2578 |
carbon double precision, |
|
| 2579 |
phosphorus double precision, |
|
| 2580 |
potassium double precision, |
|
| 2581 |
magnesium double precision, |
|
| 2582 |
nitrogen double precision, |
|
| 2583 |
calcium double precision, |
|
| 2584 |
sodium double precision |
|
| 2578 |
carbon_frac double precision,
|
|
| 2579 |
phosphorus_frac double precision,
|
|
| 2580 |
potassium_frac double precision,
|
|
| 2581 |
magnesium_frac double precision,
|
|
| 2582 |
nitrogen_frac double precision,
|
|
| 2583 |
calcium_frac double precision,
|
|
| 2584 |
sodium_frac double precision
|
|
| 2585 | 2585 |
); |
| 2586 | 2586 |
|
| 2587 | 2587 |
|
| 2588 | 2588 |
-- |
| 2589 |
-- Name: COLUMN soilobs.organic; Type: COMMENT; Schema: public; Owner: - |
|
| 2589 |
-- Name: COLUMN soilobs.organic_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2590 | 2590 |
-- |
| 2591 | 2591 |
|
| 2592 |
COMMENT ON COLUMN soilobs.organic IS 'fraction'; |
|
| 2592 |
COMMENT ON COLUMN soilobs.organic_frac IS 'fraction';
|
|
| 2593 | 2593 |
|
| 2594 | 2594 |
|
| 2595 | 2595 |
-- |
| 2596 |
-- Name: COLUMN soilobs.sand; Type: COMMENT; Schema: public; Owner: - |
|
| 2596 |
-- Name: COLUMN soilobs.sand_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2597 | 2597 |
-- |
| 2598 | 2598 |
|
| 2599 |
COMMENT ON COLUMN soilobs.sand IS 'fraction'; |
|
| 2599 |
COMMENT ON COLUMN soilobs.sand_frac IS 'fraction';
|
|
| 2600 | 2600 |
|
| 2601 | 2601 |
|
| 2602 | 2602 |
-- |
| 2603 |
-- Name: COLUMN soilobs.silt; Type: COMMENT; Schema: public; Owner: - |
|
| 2603 |
-- Name: COLUMN soilobs.silt_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2604 | 2604 |
-- |
| 2605 | 2605 |
|
| 2606 |
COMMENT ON COLUMN soilobs.silt IS 'fraction'; |
|
| 2606 |
COMMENT ON COLUMN soilobs.silt_frac IS 'fraction';
|
|
| 2607 | 2607 |
|
| 2608 | 2608 |
|
| 2609 | 2609 |
-- |
| 2610 |
-- Name: COLUMN soilobs.clay; Type: COMMENT; Schema: public; Owner: - |
|
| 2610 |
-- Name: COLUMN soilobs.clay_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2611 | 2611 |
-- |
| 2612 | 2612 |
|
| 2613 |
COMMENT ON COLUMN soilobs.clay IS 'fraction'; |
|
| 2613 |
COMMENT ON COLUMN soilobs.clay_frac IS 'fraction';
|
|
| 2614 | 2614 |
|
| 2615 | 2615 |
|
| 2616 | 2616 |
-- |
| 2617 |
-- Name: COLUMN soilobs.coarse; Type: COMMENT; Schema: public; Owner: - |
|
| 2617 |
-- Name: COLUMN soilobs.coarse_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2618 | 2618 |
-- |
| 2619 | 2619 |
|
| 2620 |
COMMENT ON COLUMN soilobs.coarse IS 'fraction'; |
|
| 2620 |
COMMENT ON COLUMN soilobs.coarse_frac IS 'fraction';
|
|
| 2621 | 2621 |
|
| 2622 | 2622 |
|
| 2623 | 2623 |
-- |
| 2624 |
-- Name: COLUMN soilobs.acidity; Type: COMMENT; Schema: public; Owner: - |
|
| 2624 |
-- Name: COLUMN soilobs.acidity_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2625 | 2625 |
-- |
| 2626 | 2626 |
|
| 2627 |
COMMENT ON COLUMN soilobs.acidity IS 'fraction'; |
|
| 2627 |
COMMENT ON COLUMN soilobs.acidity_frac IS 'fraction';
|
|
| 2628 | 2628 |
|
| 2629 | 2629 |
|
| 2630 | 2630 |
-- |
| 2631 |
-- Name: COLUMN soilobs.basesaturation; Type: COMMENT; Schema: public; Owner: - |
|
| 2631 |
-- Name: COLUMN soilobs.basesaturation_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2632 | 2632 |
-- |
| 2633 | 2633 |
|
| 2634 |
COMMENT ON COLUMN soilobs.basesaturation IS 'fraction'; |
|
| 2634 |
COMMENT ON COLUMN soilobs.basesaturation_frac IS 'fraction';
|
|
| 2635 | 2635 |
|
| 2636 | 2636 |
|
| 2637 | 2637 |
-- |
| 2638 |
-- Name: COLUMN soilobs.carbon; Type: COMMENT; Schema: public; Owner: - |
|
| 2638 |
-- Name: COLUMN soilobs.carbon_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2639 | 2639 |
-- |
| 2640 | 2640 |
|
| 2641 |
COMMENT ON COLUMN soilobs.carbon IS 'fraction'; |
|
| 2641 |
COMMENT ON COLUMN soilobs.carbon_frac IS 'fraction';
|
|
| 2642 | 2642 |
|
| 2643 | 2643 |
|
| 2644 | 2644 |
-- |
| 2645 |
-- Name: COLUMN soilobs.phosphorus; Type: COMMENT; Schema: public; Owner: - |
|
| 2645 |
-- Name: COLUMN soilobs.phosphorus_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2646 | 2646 |
-- |
| 2647 | 2647 |
|
| 2648 |
COMMENT ON COLUMN soilobs.phosphorus IS 'fraction'; |
|
| 2648 |
COMMENT ON COLUMN soilobs.phosphorus_frac IS 'fraction';
|
|
| 2649 | 2649 |
|
| 2650 | 2650 |
|
| 2651 | 2651 |
-- |
| 2652 |
-- Name: COLUMN soilobs.potassium; Type: COMMENT; Schema: public; Owner: - |
|
| 2652 |
-- Name: COLUMN soilobs.potassium_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2653 | 2653 |
-- |
| 2654 | 2654 |
|
| 2655 |
COMMENT ON COLUMN soilobs.potassium IS 'fraction'; |
|
| 2655 |
COMMENT ON COLUMN soilobs.potassium_frac IS 'fraction';
|
|
| 2656 | 2656 |
|
| 2657 | 2657 |
|
| 2658 | 2658 |
-- |
| 2659 |
-- Name: COLUMN soilobs.magnesium; Type: COMMENT; Schema: public; Owner: - |
|
| 2659 |
-- Name: COLUMN soilobs.magnesium_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2660 | 2660 |
-- |
| 2661 | 2661 |
|
| 2662 |
COMMENT ON COLUMN soilobs.magnesium IS 'fraction'; |
|
| 2662 |
COMMENT ON COLUMN soilobs.magnesium_frac IS 'fraction';
|
|
| 2663 | 2663 |
|
| 2664 | 2664 |
|
| 2665 | 2665 |
-- |
| 2666 |
-- Name: COLUMN soilobs.nitrogen; Type: COMMENT; Schema: public; Owner: - |
|
| 2666 |
-- Name: COLUMN soilobs.nitrogen_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2667 | 2667 |
-- |
| 2668 | 2668 |
|
| 2669 |
COMMENT ON COLUMN soilobs.nitrogen IS 'fraction'; |
|
| 2669 |
COMMENT ON COLUMN soilobs.nitrogen_frac IS 'fraction';
|
|
| 2670 | 2670 |
|
| 2671 | 2671 |
|
| 2672 | 2672 |
-- |
| 2673 |
-- Name: COLUMN soilobs.calcium; Type: COMMENT; Schema: public; Owner: - |
|
| 2673 |
-- Name: COLUMN soilobs.calcium_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2674 | 2674 |
-- |
| 2675 | 2675 |
|
| 2676 |
COMMENT ON COLUMN soilobs.calcium IS 'fraction'; |
|
| 2676 |
COMMENT ON COLUMN soilobs.calcium_frac IS 'fraction';
|
|
| 2677 | 2677 |
|
| 2678 | 2678 |
|
| 2679 | 2679 |
-- |
| 2680 |
-- Name: COLUMN soilobs.sodium; Type: COMMENT; Schema: public; Owner: - |
|
| 2680 |
-- Name: COLUMN soilobs.sodium_frac; Type: COMMENT; Schema: public; Owner: -
|
|
| 2681 | 2681 |
-- |
| 2682 | 2682 |
|
| 2683 |
COMMENT ON COLUMN soilobs.sodium IS 'fraction'; |
|
| 2683 |
COMMENT ON COLUMN soilobs.sodium_frac IS 'fraction';
|
|
| 2684 | 2684 |
|
| 2685 | 2685 |
|
| 2686 | 2686 |
-- |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 49 | 49 |
startDate,/location/locationevent/obsstartdate/_*/date/_alt/1, |
| 50 | 50 |
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value, |
| 51 | 51 |
precipitation,/location/locationevent/precipitation_m, |
| 52 |
acidity,/location/locationevent/soilobs/acidity, |
|
| 53 |
baseSaturation,/location/locationevent/soilobs/basesaturation, |
|
| 54 |
calcium,/location/locationevent/soilobs/calcium, |
|
| 55 |
carbon,/location/locationevent/soilobs/carbon, |
|
| 56 |
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity, |
|
| 57 |
clay,/location/locationevent/soilobs/clay, |
|
| 52 |
acidity,/location/locationevent/soilobs/acidity_frac,
|
|
| 53 |
baseSaturation,/location/locationevent/soilobs/basesaturation_frac,
|
|
| 54 |
calcium,/location/locationevent/soilobs/calcium_frac,
|
|
| 55 |
carbon,/location/locationevent/soilobs/carbon_frac,
|
|
| 56 |
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity_cmol_kg,
|
|
| 57 |
clay,/location/locationevent/soilobs/clay_frac,
|
|
| 58 | 58 |
conductivity,/location/locationevent/soilobs/conductivity, |
| 59 |
magnesium,/location/locationevent/soilobs/magnesium, |
|
| 60 |
nitrogen,/location/locationevent/soilobs/nitrogen, |
|
| 61 |
organic,/location/locationevent/soilobs/organic, |
|
| 59 |
magnesium,/location/locationevent/soilobs/magnesium_frac,
|
|
| 60 |
nitrogen,/location/locationevent/soilobs/nitrogen_frac,
|
|
| 61 |
organic,/location/locationevent/soilobs/organic_frac,
|
|
| 62 | 62 |
ph,/location/locationevent/soilobs/ph, |
| 63 |
phosphorus,/location/locationevent/soilobs/phosphorus, |
|
| 64 |
potassium,/location/locationevent/soilobs/potassium, |
|
| 65 |
sand,/location/locationevent/soilobs/sand, |
|
| 66 |
silt,/location/locationevent/soilobs/silt, |
|
| 67 |
sodium,/location/locationevent/soilobs/sodium, |
|
| 63 |
phosphorus,/location/locationevent/soilobs/phosphorus_frac,
|
|
| 64 |
potassium,/location/locationevent/soilobs/potassium_frac,
|
|
| 65 |
sand,/location/locationevent/soilobs/sand_frac,
|
|
| 66 |
silt,/location/locationevent/soilobs/silt_frac,
|
|
| 67 |
sodium,/location/locationevent/soilobs/sodium_frac,
|
|
| 68 | 68 |
texture,/location/locationevent/soilobs/texture, |
| 69 | 69 |
dateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
| 70 | 70 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 71 | 71 |
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 72 | 72 |
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 73 | 73 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 74 |
coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
|
| 74 |
coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_frac,
|
|
| 75 | 75 |
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue", |
| 76 |
volumeCanopy,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover, |
|
| 76 |
volumeCanopy,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m,
|
|
| 77 | 77 |
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
| 78 | 78 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber, |
| 79 | 79 |
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 49 | 49 |
startDate,//locationevent/obsstartdate/_*/date, |
| 50 | 50 |
eventDate,//locationevent/obsstartdate/_*/date, |
| 51 | 51 |
precipitation,//locationevent/precipitation_m, |
| 52 |
acidity,//soilobs/acidity, |
|
| 53 |
baseSaturation,//soilobs/basesaturation, |
|
| 54 |
calcium,//soilobs/calcium, |
|
| 55 |
carbon,//soilobs/carbon, |
|
| 56 |
cationExchangeCapacity,//soilobs/cationexchangecapacity, |
|
| 57 |
clay,//soilobs/clay, |
|
| 52 |
acidity,//soilobs/acidity_frac,
|
|
| 53 |
baseSaturation,//soilobs/basesaturation_frac,
|
|
| 54 |
calcium,//soilobs/calcium_frac,
|
|
| 55 |
carbon,//soilobs/carbon_frac,
|
|
| 56 |
cationExchangeCapacity,//soilobs/cationexchangecapacity_cmol_kg,
|
|
| 57 |
clay,//soilobs/clay_frac,
|
|
| 58 | 58 |
conductivity,//soilobs/conductivity, |
| 59 |
magnesium,//soilobs/magnesium, |
|
| 60 |
nitrogen,//soilobs/nitrogen, |
|
| 61 |
organic,//soilobs/organic, |
|
| 59 |
magnesium,//soilobs/magnesium_frac,
|
|
| 60 |
nitrogen,//soilobs/nitrogen_frac,
|
|
| 61 |
organic,//soilobs/organic_frac,
|
|
| 62 | 62 |
ph,//soilobs/ph, |
| 63 |
phosphorus,//soilobs/phosphorus, |
|
| 64 |
potassium,//soilobs/potassium, |
|
| 65 |
sand,//soilobs/sand, |
|
| 66 |
silt,//soilobs/silt, |
|
| 67 |
sodium,//soilobs/sodium, |
|
| 63 |
phosphorus,//soilobs/phosphorus_frac,
|
|
| 64 |
potassium,//soilobs/potassium_frac,
|
|
| 65 |
sand,//soilobs/sand_frac,
|
|
| 66 |
silt,//soilobs/silt_frac,
|
|
| 67 |
sodium,//soilobs/sodium_frac,
|
|
| 68 | 68 |
texture,//soilobs/texture, |
| 69 | 69 |
dateCollected,//aggregateoccurrence/collectiondate/_*/date, |
| 70 | 70 |
dayCollected,//aggregateoccurrence/collectiondate, |
| 71 | 71 |
monthCollected,//aggregateoccurrence/collectiondate, |
| 72 | 72 |
yearCollected,//aggregateoccurrence/collectiondate, |
| 73 | 73 |
individualCount,//aggregateoccurrence/count, |
| 74 |
coverPercent,//aggregateoccurrence/cover, |
|
| 74 |
coverPercent,//aggregateoccurrence/cover_frac,
|
|
| 75 | 75 |
censusNumber,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]/definedvalue", |
| 76 |
volumeCanopy,//aggregateoccurrence/linecover, |
|
| 76 |
volumeCanopy,//aggregateoccurrence/linecover_m,
|
|
| 77 | 77 |
fieldNotes,//aggregateoccurrence/notes, |
| 78 | 78 |
recordNumber,//plantobservation/collectionnumber, |
| 79 | 79 |
sex,"//plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
Also available in: Unified diff
schemas/vegbien.sql: Added units suffix to additional VegBIEN fields that have units