Project

General

Profile

« Previous | Next » 

Revision 11518

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