Revision 11518
Added by Aaron Marcuse-Kubitza about 11 years ago
inputs/VegBank/^taxon_observation.**.sample/create.sql | ||
---|---|---|
44 | 44 |
, "*stratumtype_id" |
45 | 45 |
, "collectorNumber" |
46 | 46 |
, "dateCollected" |
47 |
, "originalScientificName" |
|
48 |
, "originalTaxonName" |
|
49 |
, "originalVernacularName" |
|
50 |
, "scientificName_verbatim" |
|
51 | 47 |
, "dateIdentified" |
48 |
, "taxon_determination__is_current" |
|
49 |
, "taxon_determination__is_original" |
|
52 | 50 |
, "kingdom" |
53 | 51 |
, "*Subkingdom" |
54 | 52 |
, "*Superdivision" |
... | ... | |
59 | 57 |
, "order" |
60 | 58 |
, "family" |
61 | 59 |
, "genus" |
62 |
, "taxonName" |
|
63 | 60 |
, "scientificName" |
64 |
, "scientificName__for_nearest_taxon_concept" |
|
65 |
, "vernacularName" |
|
66 | 61 |
, "occurrenceRemarks" |
67 | 62 |
, "observationGranularity" |
68 | 63 |
, "coverPercent" |
inputs/VegBank/^taxon_observation.**.sample/header.csv | ||
---|---|---|
1 |
sort_col,country,continent,stateProvince,county,landform,locality,decimalLatitude,decimalLongitude,coordinateUncertaintyInMeters,coordinateUncertaintyInMeters__from_coords,coordinateUncertaintyInMeters__from_fuzzing,accessRights,accessRights_verbatim,projectID,locationID,locationName,parentLocationID,footprintWKT,elevationInMeters,slopeAspect,minSlopeAspect,maxSlopeAspect,slopeGradient,minSlopeGradient,maxSlopeGradient,plotArea_m2,eventID,authorEventCode,startDate,endDate,samplingProtocol,organic_percent,texture,sand_percent,silt_percent,clay_percent,ph,cationExchangeCapacity_cmol_kg,baseSaturation_percent,stratum__name,*stratum_id,*stratumtype_id,collectorNumber,dateCollected,originalScientificName,originalTaxonName,originalVernacularName,scientificName_verbatim,dateIdentified,kingdom,*Subkingdom,*Superdivision,*Division,*Subdivision,class,*Subclass,order,family,genus,taxonName,scientificName,scientificName__for_nearest_taxon_concept,vernacularName,occurrenceRemarks,observationGranularity,coverPercent,diameterBreastHeight_cm,height_m,individualCount,taxonOccurrenceID,taxonOccurrenceID__overall_plot,identificationID,identificationType,identificationQualifier,identificationVerificationStatus,aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID,individualID,stemID,accessionNumber |
|
1 |
sort_col,country,continent,stateProvince,county,landform,locality,decimalLatitude,decimalLongitude,coordinateUncertaintyInMeters,coordinateUncertaintyInMeters__from_coords,coordinateUncertaintyInMeters__from_fuzzing,accessRights,accessRights_verbatim,projectID,locationID,locationName,parentLocationID,footprintWKT,elevationInMeters,slopeAspect,minSlopeAspect,maxSlopeAspect,slopeGradient,minSlopeGradient,maxSlopeGradient,plotArea_m2,eventID,authorEventCode,startDate,endDate,samplingProtocol,organic_percent,texture,sand_percent,silt_percent,clay_percent,ph,cationExchangeCapacity_cmol_kg,baseSaturation_percent,stratum__name,*stratum_id,*stratumtype_id,collectorNumber,dateCollected,dateIdentified,taxon_determination__is_current,taxon_determination__is_original,kingdom,*Subkingdom,*Superdivision,*Division,*Subdivision,class,*Subclass,order,family,genus,scientificName,occurrenceRemarks,observationGranularity,coverPercent,diameterBreastHeight_cm,height_m,individualCount,taxonOccurrenceID,taxonOccurrenceID__overall_plot,identificationID,identificationType,identificationQualifier,identificationVerificationStatus,aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID,individualID,stemID,accessionNumber |
inputs/VegBank/^taxon_observation.**.sample/map.csv | ||
---|---|---|
44 | 44 |
*stratumtype_id,*stratumtype_id,, |
45 | 45 |
collectorNumber,collectorNumber,, |
46 | 46 |
dateCollected,dateCollected,, |
47 |
originalScientificName,originalScientificName,, |
|
48 |
originalTaxonName,originalTaxonName,, |
|
49 |
originalVernacularName,originalVernacularName,, |
|
50 |
scientificName_verbatim,scientificName_verbatim,, |
|
51 | 47 |
dateIdentified,dateIdentified,, |
48 |
taxon_determination__is_current,taxon_determination__is_current,, |
|
49 |
taxon_determination__is_original,taxon_determination__is_original,, |
|
52 | 50 |
kingdom,kingdom,, |
53 | 51 |
*Subkingdom,*Subkingdom,, |
54 | 52 |
*Superdivision,*Superdivision,, |
... | ... | |
59 | 57 |
order,order,, |
60 | 58 |
family,family,, |
61 | 59 |
genus,genus,, |
62 |
taxonName,taxonName,, |
|
63 | 60 |
scientificName,scientificName,, |
64 |
scientificName__for_nearest_taxon_concept,scientificName__for_nearest_taxon_concept,, |
|
65 |
vernacularName,vernacularName,, |
|
66 | 61 |
occurrenceRemarks,occurrenceRemarks,, |
67 | 62 |
observationGranularity,observationGranularity,, |
68 | 63 |
coverPercent,coverPercent,, |
inputs/VegBank/^taxon_observation.**.sample/test.xml.ref | ||
---|---|---|
120 | 120 |
<value> |
121 | 121 |
<_alt> |
122 | 122 |
<1>$scientificName</1> |
123 |
<2> |
|
124 |
<_alt> |
|
125 |
<1>$taxonName</1> |
|
126 |
<2><_filter_genus><value>$genus</value></_filter_genus></2> |
|
127 |
</_alt> |
|
128 |
</2> |
|
123 |
<2><_filter_genus><value>$genus</value></_filter_genus></2> |
|
129 | 124 |
</_alt> |
130 | 125 |
</value> |
131 | 126 |
</_merge_prefix> |
... | ... | |
134 | 129 |
</taxonlabel_id> |
135 | 130 |
<family>$family</family> |
136 | 131 |
<genus>$genus</genus> |
137 |
<taxonname>$taxonName</taxonname> |
|
138 | 132 |
<taxonomicname>$scientificName</taxonomicname> |
139 | 133 |
</taxonverbatim> |
140 | 134 |
</taxonverbatim_id> |
141 | 135 |
<determinationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></determinationdate> |
142 | 136 |
<determinationtype>$identificationType</determinationtype> |
137 |
<iscurrent__verbatim>$taxon_determination__is_current</iscurrent__verbatim> |
|
138 |
<isoriginal>$taxon_determination__is_original</isoriginal> |
|
143 | 139 |
<taxonfit>$identificationQualifier</taxonfit> |
144 | 140 |
</taxondetermination> |
145 |
<taxondetermination> |
|
146 |
<isoriginal>true</isoriginal> |
|
147 |
<taxonverbatim_id> |
|
148 |
<taxonverbatim> |
|
149 |
<taxonname>$originalTaxonName</taxonname> |
|
150 |
<taxonomicname>$originalScientificName</taxonomicname> |
|
151 |
</taxonverbatim> |
|
152 |
</taxonverbatim_id> |
|
153 |
</taxondetermination> |
|
154 | 141 |
</taxonoccurrence> |
155 | 142 |
</locationevent> |
156 | 143 |
<obsenddate>$endDate</obsenddate> |
inputs/VegBank/^taxon_observation.**.sample/unmapped_terms.csv | ||
---|---|---|
4 | 4 |
accessRights_verbatim |
5 | 5 |
*stratum_id |
6 | 6 |
*stratumtype_id |
7 |
originalVernacularName |
|
8 |
scientificName_verbatim |
|
9 | 7 |
*Subkingdom |
10 | 8 |
*Superdivision |
11 | 9 |
*Division |
12 | 10 |
*Subdivision |
13 | 11 |
*Subclass |
14 |
scientificName__for_nearest_taxon_concept |
|
15 |
vernacularName |
|
16 | 12 |
taxonOccurrenceID__overall_plot |
17 | 13 |
identificationID |
18 | 14 |
identificationVerificationStatus |
Also available in: Unified diff
inputs/VegBank/^taxon_observation.**.sample/create.sql: synced with taxon_observation.**