Project

General

Profile

« Previous | Next » 

Revision 11538

fix: inputs/VegBank/^taxon_observation.**.sample/create.sql: moved continent before country

View differences:

inputs/VegBank/^taxon_observation.**.sample/create.sql
1 1
SELECT
2 2
  "sort_col"
3
, "continent"
3 4
, "country"
4
, "continent"
5 5
, "stateProvince"
6 6
, "county"
7 7
, "landform"
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,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
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,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
1 1
VegBank,VegCore,Filter,Comments
2 2
sort_col,sort_col,,
3
continent,continent,,
3 4
country,country,,
4
continent,continent,,
5 5
stateProvince,stateProvince,,
6 6
county,county,,
7 7
landform,landform,,

Also available in: Unified diff