Project

General

Profile

« Previous | Next » 

Revision 11931

inputs/CVS/^taxon_observation.**.sample/create.sql, map.csv: added new project columns

View differences:

inputs/CVS/^taxon_observation.**.sample/create.sql
14 14
, "accessRights"
15 15
, "accessRights_verbatim"
16 16
, "projectID"
17
, "projectName"
18
, "projectStartDate"
19
, "projectEndDate"
17 20
, "locationID"
18 21
, "locationName"
19 22
, "footprintWKT"
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,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
1
sort_col,continent,country,stateProvince,county,landform,locality,decimalLatitude,decimalLongitude,coordinateUncertaintyInMeters,coordinateUncertaintyInMeters__from_coords,coordinateUncertaintyInMeters__from_fuzzing,accessRights,accessRights_verbatim,projectID,projectName,projectStartDate,projectEndDate,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
14 14
accessRights,accessRights,,
15 15
accessRights_verbatim,accessRights_verbatim,,
16 16
projectID,projectID,,
17
projectName,projectName,,
18
projectStartDate,projectStartDate,,
19
projectEndDate,projectEndDate,,
17 20
locationID,locationID,,
18 21
locationName,locationName,,
19 22
footprintWKT,footprintWKT,,
inputs/CVS/^taxon_observation.**.sample/test.xml.ref
16 16
                        <landform>$landform</landform>
17 17
                        <locationevent>
18 18
                            <method_id><method><name>$samplingProtocol</name></method></method_id>
19
                            <project_id><project><sourceaccessioncode>$projectID</sourceaccessioncode></project></project_id>
19
                            <project_id>
20
                                <project>
21
                                    <projectname>$projectName</projectname>
22
                                    <sourceaccessioncode>$projectID</sourceaccessioncode>
23
                                    <startdate>$projectStartDate</startdate>
24
                                    <stopdate>$projectEndDate</stopdate>
25
                                </project>
26
                            </project_id>
20 27
                            <authoreventcode>$authorEventCode</authoreventcode>
21 28
                            <sourceaccessioncode>$eventID</sourceaccessioncode>
22 29
                            <locationevent fkey="parent_id">

Also available in: Unified diff