Project

General

Profile

« Previous | Next » 

Revision 11535

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/VegBank/^taxon_observation.**.sample/create.sql: synced column order to analytical_plot

View differences:

inputs/VegBank/^taxon_observation.**.sample/create.sql
18 18 
, "locationName"
19 19 
, "parentLocationID"
20 20 
, "footprintWKT"
21 
, "eventID"
22 
, "authorEventCode"
23 
, "startDate"
24 
, "endDate"
21 25 
, "elevationInMeters"
22 26 
, "slopeAspect"
23 27 
, "minSlopeAspect"
......
26 30 
, "minSlopeGradient"
27 31 
, "maxSlopeGradient"
28 32 
, "plotArea_m2"
29 
, "eventID"
30 
, "authorEventCode"
31 
, "startDate"
32 
, "endDate"
33 33 
, "samplingProtocol"
34 34 
, "organic_percent"
35 35 
, "texture"
......
63 63 
, "coverPercent"
64 64 
, "diameterBreastHeight_cm"
65 65 
, "height_m"
66 
, "individualCount"
67 66 
, "taxonOccurrenceID"
68 67 
, "taxonOccurrenceID__overall_plot"
69 68 
, "identificationID"
......
73 72 
, "aggregateOrganismObservationID__taxon_presence"
74 73 
, "aggregateOrganismObservationID__individual_count"
75 74 
, "aggregateOrganismObservationID"
75 
, "individualCount"
76 76 
, "individualID"
77 77 
, "stemID"
78 78 
, "accessionNumber"
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,elevationInMeters,slopeAspect,minSlopeAspect,maxSlopeAspect,slopeGradient,minSlopeGradient,maxSlopeGradient,plotArea_m2,eventID,authorEventCode,startDate,endDate,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,individualCount,taxonOccurrenceID,taxonOccurrenceID__overall_plot,identificationID,identificationType,identificationQualifier,identificationVerificationStatus,aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID,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,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

Also available in: Unified diff