Project

General

Profile

« Previous | Next » 

Revision 11518

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/VegBank/^taxon_observation.**.sample/create.sql: synced with taxon_observation.**

View differences:

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