Project

General

Profile

« Previous | Next » 

Revision 11537

inputs/VegBank/^taxon_observation.**.sample/create.sql: added missing columns that were recently mapped to VegBIEN (identifiedBy)

View differences:

inputs/VegBank/^taxon_observation.**.sample/create.sql
44 44
, "*stratumtype_id"
45 45
, "collectorNumber"
46 46
, "dateCollected"
47
, "identifiedBy"
47 48
, "dateIdentified"
48 49
, "taxon_determination__is_current"
49 50
, "taxon_determination__is_original"
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,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,*Superdivision,*Division,*Subdivision,class,*Subclass,order,family,genus,scientificName,occurrenceRemarks,observationGranularity,coverPercent,diameterBreastHeight_cm,height_m,taxonOccurrenceID,taxonOccurrenceID__overall_plot,identificationID,identificationType,identificationQualifier,identificationVerificationStatus,aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID,individualCount,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,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,*Superdivision,*Division,*Subdivision,class,*Subclass,order,family,genus,scientificName,occurrenceRemarks,observationGranularity,coverPercent,diameterBreastHeight_cm,height_m,taxonOccurrenceID,taxonOccurrenceID__overall_plot,identificationID,identificationType,identificationQualifier,identificationVerificationStatus,aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID,individualCount,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
identifiedBy,identifiedBy,,
47 48
dateIdentified,dateIdentified,,
48 49
taxon_determination__is_current,taxon_determination__is_current,,
49 50
taxon_determination__is_original,taxon_determination__is_original,,
inputs/VegBank/^taxon_observation.**.sample/test.xml.ref
46 46
                                    <authortaxoncode>$collectorNumber</authortaxoncode>
47 47
                                    <sourceaccessioncode>$taxonOccurrenceID</sourceaccessioncode>
48 48
                                    <taxondetermination>
49
                                        <party_id><party><fullname>$identifiedBy</fullname></party></party_id>
49 50
                                        <taxonverbatim_id>
50 51
                                            <taxonverbatim>
51 52
                                                <taxonlabel_id>
......
240 241
        </path>
241 242
    </_setDefault>
242 243
</VegBIEN>
243
Inserted 30 new rows into database
244
Inserted 31 new rows into database

Also available in: Unified diff