Project

General

Profile

« Previous | Next » 

Revision 11803

inputs/CVS/^taxon_observation.**.sample/create.sql: removed parentLocationID, since this is unused in CVS

View differences:

inputs/CVS/^taxon_observation.**.sample/create.sql
16 16
, "projectID"
17 17
, "locationID"
18 18
, "locationName"
19
, "parentLocationID"
20 19
, "footprintWKT"
21 20
, "eventID"
22 21
, "authorEventCode"
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,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,*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,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
16 16
projectID,projectID,,
17 17
locationID,locationID,,
18 18
locationName,locationName,,
19
parentLocationID,parentLocationID,,
20 19
footprintWKT,footprintWKT,,
21 20
eventID,eventID,,
22 21
authorEventCode,authorEventCode,,
inputs/CVS/^taxon_observation.**.sample/test.xml.ref
209 209
                                </place>
210 210
                            </place_id>
211 211
                        </locationplace>
212
                        <parent_id><location><sourceaccessioncode>$parentLocationID</sourceaccessioncode></location></parent_id>
213 212
                        <slopeaspect_deg>
214 213
                            <_alt>
215 214
                                <1><_compass><value>$slopeAspect</value></_compass></1>

Also available in: Unified diff