Project

General

Profile

« Previous | Next » 

Revision 11916

bugfix: inputs/CVS/^taxon_observation.**.sample/create.sql: include taxonName in the subset of columns that's imported for the validation, because it is _alt-ed with scientificName for forming the TNRS input name. this is unique to CVS, which is why it was not part of the validation subset copied from the VegBank subset.

View differences:

inputs/CVS/^taxon_observation.**.sample/create.sql
59 59
, "subgenus"
60 60
, "*section"
61 61
, "scientificName"
62
, "taxonName"
62 63
, "occurrenceRemarks"
63 64
, "observationGranularity"
64 65
, "coverPercent"
inputs/CVS/^taxon_observation.**.sample/header.csv
1
sort_col,continent,country,stateProvince,county,landform,locality,decimalLatitude,decimalLongitude,coordinateUncertaintyInMeters,coordinateUncertaintyInMeters__from_coords,coordinateUncertaintyInMeters__from_fuzzing,accessRights,accessRights_verbatim,projectID,locationID,locationName,footprintWKT,eventID,authorEventCode,startDate,endDate,elevationInMeters,slopeAspect,minSlopeAspect,maxSlopeAspect,slopeGradient,minSlopeGradient,maxSlopeGradient,plotArea_m2,samplingProtocol,organic_percent,texture,sand_percent,silt_percent,clay_percent,ph,cationExchangeCapacity_cmol_kg,baseSaturation_percent,stratum__name,*STRATUM_ID,*STRATUMTYPE_ID,collectorNumber,dateCollected,identifiedBy,dateIdentified,taxon_determination__is_current,taxon_determination__is_original,kingdom,*Subkingdom,*division,class,*Subclass,order,family,*tribe,genus,subgenus,*section,scientificName,occurrenceRemarks,observationGranularity,coverPercent,diameterBreastHeight_cm,height_m,taxonOccurrenceID,taxonOccurrenceID__overall_plot,identificationID,identificationType,identificationQualifier,identificationVerificationStatus,aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID,individualCount,accessionNumber
1
sort_col,continent,country,stateProvince,county,landform,locality,decimalLatitude,decimalLongitude,coordinateUncertaintyInMeters,coordinateUncertaintyInMeters__from_coords,coordinateUncertaintyInMeters__from_fuzzing,accessRights,accessRights_verbatim,projectID,locationID,locationName,footprintWKT,eventID,authorEventCode,startDate,endDate,elevationInMeters,slopeAspect,minSlopeAspect,maxSlopeAspect,slopeGradient,minSlopeGradient,maxSlopeGradient,plotArea_m2,samplingProtocol,organic_percent,texture,sand_percent,silt_percent,clay_percent,ph,cationExchangeCapacity_cmol_kg,baseSaturation_percent,stratum__name,*STRATUM_ID,*STRATUMTYPE_ID,collectorNumber,dateCollected,identifiedBy,dateIdentified,taxon_determination__is_current,taxon_determination__is_original,kingdom,*Subkingdom,*division,class,*Subclass,order,family,*tribe,genus,subgenus,*section,scientificName,taxonName,occurrenceRemarks,observationGranularity,coverPercent,diameterBreastHeight_cm,height_m,taxonOccurrenceID,taxonOccurrenceID__overall_plot,identificationID,identificationType,identificationQualifier,identificationVerificationStatus,aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID,individualCount,accessionNumber
inputs/CVS/^taxon_observation.**.sample/map.csv
59 59
subgenus,subgenus,,
60 60
*section,*section,,
61 61
scientificName,scientificName,,
62
taxonName,taxonName,,
62 63
occurrenceRemarks,occurrenceRemarks,,
63 64
observationGranularity,observationGranularity,,
64 65
coverPercent,coverPercent,,
inputs/CVS/^taxon_observation.**.sample/test.xml.ref
119 119
                                                                <value>
120 120
                                                                    <_alt>
121 121
                                                                        <1>$scientificName</1>
122
                                                                        <2><_filter_genus><value>$genus</value></_filter_genus></2>
122
                                                                        <2>
123
                                                                            <_alt>
124
                                                                                <1>$taxonName</1>
125
                                                                                <2><_filter_genus><value>$genus</value></_filter_genus></2>
126
                                                                            </_alt>
127
                                                                        </2>
123 128
                                                                    </_alt>
124 129
                                                                </value>
125 130
                                                            </_merge_prefix>
......
128 133
                                                </taxonlabel_id>
129 134
                                                <family>$family</family>
130 135
                                                <genus>$genus</genus>
136
                                                <taxonname>$taxonName</taxonname>
131 137
                                                <taxonomicname>$scientificName</taxonomicname>
132 138
                                            </taxonverbatim>
133 139
                                        </taxonverbatim_id>

Also available in: Unified diff