Revision 6739
Added by Aaron Marcuse-Kubitza almost 12 years ago
inputs/VegBank/new_terms.csv | ||
---|---|---|
1 |
|
|
2 |
----- |
|
3 |
-----" |
|
4 |
FROM ""VegBank"".taxonimportance |
|
5 |
GROUP BY taxonobservation_id |
|
6 |
HAVING count(distinct taxonimportance_id) > 1 |
|
7 |
SELECT taxonobservation_id, count(distinct taxonimportance_id) |
|
8 |
[1] The following query returns rows: |
|
1 | 9 |
area,plotArea_m2,,"""Total area of the plot in m2"" (area definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename>)" |
2 | 10 |
area|country|territory,country,, |
3 |
authorplantname,verbatimScientificName,,
|
|
4 |
authorplotcode,plotName,,
|
|
11 |
authorplantname,originalTaxonName,,
|
|
12 |
authorplotcode,locationName,,
|
|
5 | 13 |
collectiondate,dateCollected,, |
14 |
confidentialitystatus,coordinateUncertaintyInMeters,"/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription¶ms=1581> |
|
15 |
confidentialitystatus,dcterms:accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription¶ms=1581> |
|
16 |
cover,coverPercent,, |
|
6 | 17 |
elevationrange,UNUSED,, |
7 |
exchangecapacity,cationExchangeCapacity,, |
|
18 |
exchangecapacity,cationExchangeCapacity_cmol_kg,, |
|
19 |
givenname,recordedBy.givenName,, |
|
8 | 20 |
interpretationdate,dateIdentified,, |
9 |
locationaccuracy,coordinateUncertaintyInMeters,, |
|
21 |
locationaccuracy,coordinateUncertaintyInMeters,/_alt/2,
|
|
10 | 22 |
methodnarrative,samplingProtocol,, |
11 | 23 |
museumaccessionnumber,catalogNumber,, |
12 | 24 |
obsenddate,endDate,, |
... | ... | |
15 | 27 |
parent_id,parentLocationID,, |
16 | 28 |
region|state|province,stateProvince,, |
17 | 29 |
shape,footprintWKT,, |
18 |
soilclay,clay,,
|
|
19 |
soilorganic,organic,,
|
|
30 |
soilclay,clay_percent,,"""Percent clay in the soil horizon"" (soilClay definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
31 |
soilorganic,organic_percent,,"""Percent organic content of the soil"" (soilOrganic definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
20 | 32 |
soilph,ph,, |
21 |
soilsand,sand,,
|
|
22 |
soilsilt,silt,,
|
|
33 |
soilsand,sand_percent,,"""Percent sand in the soil horizon"" (soilSand definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
34 |
soilsilt,silt_percent,,"""Percent silt in the soil horizon"" (soilSilt definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
|
|
23 | 35 |
soiltexture,texture,, |
36 |
stemcode,authorStemCode,, |
|
37 |
stemcount_id,individualID,, |
|
38 |
stemdiameter,diameterBreastHeight_cm,,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)" |
|
39 |
stemheight,height_m,,"""The measured height of the stem in meters"" (stemHeight definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)" |
|
40 |
stemlocation_id,stemID,, |
|
41 |
stemxposition,organismX_m,,"""The X-coordinate of the stem position in m"" (stemXPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)" |
|
42 |
stemyposition,organismY_m,,"""The Y-coordinate of the stem position, as above"" (stemYPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)" |
|
43 |
surname,recordedBy.surName,, |
|
44 |
taxonimportance_id,aggregateOccurrenceID,, |
|
24 | 45 |
taxonobservation_id,taxonOccurrenceID,, |
46 |
taxonobservation_id,taxonOccurrenceID,,"Note that taxonimportance is not 1:1 with taxonobservation [1]. |
Also available in: Unified diff
Regenerated inputs/VegBank/new_terms.csv