Project

General

Profile

« Previous | Next » 

Revision 11820

inputs/CVS/^taxon_observation.**.sample/create.sql: uncommented identifiedBy since this is now part of taxonObservation_

View differences:

inputs/CVS/^taxon_observation.**.sample/create.sql
43 43
, "*STRATUMTYPE_ID"
44 44
, "collectorNumber"
45 45
, "dateCollected"
46
--, "identifiedBy"
46
, "identifiedBy"
47 47
, "dateIdentified"
48 48
, "taxon_determination__is_current"
49 49
, "taxon_determination__is_original"
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,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,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
43 43
*STRATUMTYPE_ID,*STRATUMTYPE_ID,,
44 44
collectorNumber,collectorNumber,,
45 45
dateCollected,dateCollected,,
46
identifiedBy,identifiedBy,,
46 47
dateIdentified,dateIdentified,,
47 48
taxon_determination__is_current,taxon_determination__is_current,,
48 49
taxon_determination__is_original,taxon_determination__is_original,,
inputs/CVS/^taxon_observation.**.sample/test.xml.ref
44 44
                                    <authortaxoncode>$collectorNumber</authortaxoncode>
45 45
                                    <sourceaccessioncode>$taxonOccurrenceID</sourceaccessioncode>
46 46
                                    <taxondetermination>
47
                                        <party_id><party><fullname>$identifiedBy</fullname></party></party_id>
47 48
                                        <taxonverbatim_id>
48 49
                                            <taxonverbatim>
49 50
                                                <taxonlabel_id>
......
237 238
        </path>
238 239
    </_setDefault>
239 240
</VegBIEN>
240
Inserted 33 new rows into database
241
Inserted 34 new rows into database

Also available in: Unified diff