Project

General

Profile

« Previous | Next » 

Revision 11248

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/VegBank/taxon_observation.**.sample/create.sql: reordered columns in the same order as analytical_plot, for easier validation

View differences:

inputs/VegBank/taxon_observation.**.sample/create.sql
1 1 
SELECT
2 2 
  "sort_col"
3 
, "country"
4 
, "continent"
5 
, "stateProvince"
6 
, "county"
7 
, "landform"
8 
, "locality"
9 
, "decimalLatitude"
10 
, "decimalLongitude"
11 
, "coordinateUncertaintyInMeters"
12 
, "coordinateUncertaintyInMeters__from_coords"
13 
, "coordinateUncertaintyInMeters__from_fuzzing"
14 
, "accessRights"
15 
, "accessRights_verbatim"
16 
, "projectID"
3 17 
, "locationID"
18 
, "locationName"
19 
, "parentLocationID"
20 
, "footprintWKT"
21 
, "elevationInMeters"
22 
, "slopeAspect"
23 
, "minSlopeAspect"
24 
, "maxSlopeAspect"
25 
, "slopeGradient"
26 
, "minSlopeGradient"
27 
, "maxSlopeGradient"
28 
, "plotArea_m2"
4 29 
, "eventID"
30 
, "authorEventCode"
31 
, "startDate"
32 
, "endDate"
33 
, "samplingProtocol"
34 
, "organic_percent"
35 
, "texture"
36 
, "sand_percent"
37 
, "silt_percent"
38 
, "clay_percent"
39 
, "ph"
40 
, "cationExchangeCapacity_cmol_kg"
41 
, "baseSaturation_percent"
42 
, "emb_soilobs"
43 
, "stratum__name"
44 
, "*stratum_id"
5 45 
, "*stratumtype_id"
6 
, "*stratum_id"
7 
, "aggregateOrganismObservationID__taxon_presence"
8 
, "aggregateOrganismObservationID__individual_count"
9 
, "aggregateOrganismObservationID"
10 
, "taxonOccurrenceID__overall_plot"
11 
, "identificationID"
12 
, "identificationType"
13 
, "identificationQualifier"
14 
, "identificationVerificationStatus"
15 46 
, "collectorNumber"
16 
, "accessionNumber"
17 
, "occurrenceRemarks"
18 
, "dateIdentified"
19 47 
, "dateCollected"
20 48 
, "originalScientificName"
21 49 
, "originalTaxonName"
22 50 
, "originalVernacularName"
23 51 
, "scientificName_verbatim"
24 
, "taxonName"
25 
, "vernacularName"
26 
, "scientificName__for_nearest_taxon_concept"
52 
, "dateIdentified"
27 53 
, "kingdom"
28 54 
, "*Subkingdom"
29 55 
, "*Superdivision"
......
34 60 
, "order"
35 61 
, "family"
36 62 
, "genus"
63 
, "taxonName"
64 
, "scientificName"
65 
, "scientificName__for_nearest_taxon_concept"
66 
, "vernacularName"
67 
, "occurrenceRemarks"
37 68 
, "observationGranularity"
38 
, "scientificName"
39 69 
, "coverPercent"
40 70 
, "diameterBreastHeight_cm"
41 71 
, "height_m"
42 72 
, "individualCount"
73 
, "taxonOccurrenceID"
74 
, "taxonOccurrenceID__overall_plot"
75 
, "identificationID"
76 
, "identificationType"
77 
, "identificationQualifier"
78 
, "identificationVerificationStatus"
79 
, "aggregateOrganismObservationID__taxon_presence"
80 
, "aggregateOrganismObservationID__individual_count"
81 
, "aggregateOrganismObservationID"
82 
, "individualID"
43 83 
, "stemID"
44 
, "individualID"
45 
, "stratum__name"
46 
, "projectID"
47 
, "authorEventCode"
48 
, "samplingProtocol"
49 
, "startDate"
50 
, "endDate"
51 
, "organic_percent"
52 
, "texture"
53 
, "sand_percent"
54 
, "silt_percent"
55 
, "clay_percent"
56 
, "ph"
57 
, "cationExchangeCapacity_cmol_kg"
58 
, "baseSaturation_percent"
59 
, "emb_soilobs"
60 
, "locationName"
61 
, "parentLocationID"
62 
, "coordinateUncertaintyInMeters__from_coords"
63 
, "accessRights_verbatim"
64 
, "decimalLatitude"
65 
, "decimalLongitude"
66 
, "locality"
67 
, "footprintWKT"
68 
, "plotArea_m2"
69 
, "elevationInMeters"
70 
, "slopeAspect"
71 
, "minSlopeAspect"
72 
, "maxSlopeAspect"
73 
, "slopeGradient"
74 
, "minSlopeGradient"
75 
, "maxSlopeGradient"
76 
, "landform"
77 
, "stateProvince"
78 
, "country"
79 
, "continent"
80 
, "county"
81 
, "accessRights"
82 
, "coordinateUncertaintyInMeters__from_fuzzing"
83 
, "coordinateUncertaintyInMeters"
84 
, "taxonOccurrenceID"
84 
, "accessionNumber"
85 85 
FROM "taxon_observation.**"
86 86 
WHERE "locationID" IN (/*Heritage*/27581, /*CVS*/80476, /*NPS*/25572, /*GAP*/46073, /*Jennings*/11862, /*soil*/27234)
87 87 
	-- see wiki.vegpath.org/Spot-checking#VegBank
inputs/VegBank/taxon_observation.**.sample/header.csv
1 
sort_col,locationID,eventID,*stratumtype_id,*stratum_id,aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID,taxonOccurrenceID__overall_plot,identificationID,identificationType,identificationQualifier,identificationVerificationStatus,collectorNumber,accessionNumber,occurrenceRemarks,dateIdentified,dateCollected,originalScientificName,originalTaxonName,originalVernacularName,scientificName_verbatim,taxonName,vernacularName,scientificName__for_nearest_taxon_concept,kingdom,*Subkingdom,*Superdivision,*Division,*Subdivision,class,*Subclass,order,family,genus,observationGranularity,scientificName,coverPercent,diameterBreastHeight_cm,height_m,individualCount,stemID,individualID,stratum__name,projectID,authorEventCode,samplingProtocol,startDate,endDate,organic_percent,texture,sand_percent,silt_percent,clay_percent,ph,cationExchangeCapacity_cmol_kg,baseSaturation_percent,emb_soilobs,locationName,parentLocationID,coordinateUncertaintyInMeters__from_coords,accessRights_verbatim,decimalLatitude,decimalLongitude,locality,footprintWKT,plotArea_m2,elevationInMeters,slopeAspect,minSlopeAspect,maxSlopeAspect,slopeGradient,minSlopeGradient,maxSlopeGradient,landform,stateProvince,country,continent,county,accessRights,coordinateUncertaintyInMeters__from_fuzzing,coordinateUncertaintyInMeters,taxonOccurrenceID
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,emb_soilobs,stratum__name,*stratum_id,*stratumtype_id,collectorNumber,dateCollected,originalScientificName,originalTaxonName,originalVernacularName,scientificName_verbatim,dateIdentified,kingdom,*Subkingdom,*Superdivision,*Division,*Subdivision,class,*Subclass,order,family,genus,taxonName,scientificName,scientificName__for_nearest_taxon_concept,vernacularName,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
inputs/VegBank/taxon_observation.**.sample/map.csv
1 1 
VegBank,VegCore,Filter,Comments
2 2 
sort_col,sort_col,,
3 
country,country,,
4 
continent,continent,,
5 
stateProvince,stateProvince,,
6 
county,county,,
7 
landform,landform,,
8 
locality,locality,,
9 
decimalLatitude,decimalLatitude,,
10 
decimalLongitude,decimalLongitude,,
11 
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,
12 
coordinateUncertaintyInMeters__from_coords,coordinateUncertaintyInMeters__from_coords,,
13 
coordinateUncertaintyInMeters__from_fuzzing,coordinateUncertaintyInMeters__from_fuzzing,,
14 
accessRights,accessRights,,
15 
accessRights_verbatim,accessRights_verbatim,,
16 
projectID,projectID,,
3 17 
locationID,locationID,,
18 
locationName,locationName,,
19 
parentLocationID,parentLocationID,,
20 
footprintWKT,footprintWKT,,
21 
elevationInMeters,elevationInMeters,,
22 
slopeAspect,slopeAspect,,
23 
minSlopeAspect,minSlopeAspect,,
24 
maxSlopeAspect,maxSlopeAspect,,
25 
slopeGradient,slopeGradient,,
26 
minSlopeGradient,minSlopeGradient,,
27 
maxSlopeGradient,maxSlopeGradient,,
28 
plotArea_m2,plotArea_m2,,
4 29 
eventID,eventID,,
30 
authorEventCode,authorEventCode,,
31 
startDate,startDate,,
32 
endDate,endDate,,
33 
samplingProtocol,samplingProtocol,,
34 
organic_percent,organic_percent,,
35 
texture,texture,,
36 
sand_percent,sand_percent,,
37 
silt_percent,silt_percent,,
38 
clay_percent,clay_percent,,
39 
ph,ph,,
40 
cationExchangeCapacity_cmol_kg,cationExchangeCapacity_cmol_kg,,
41 
baseSaturation_percent,baseSaturation_percent,,
42 
emb_soilobs,emb_soilobs,,
43 
stratum__name,stratum__name,,
44 
*stratum_id,*stratum_id,,
5 45 
*stratumtype_id,*stratumtype_id,,
6 
*stratum_id,*stratum_id,,
7 
aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__taxon_presence,,
8 
aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID__individual_count,,
9 
aggregateOrganismObservationID,aggregateOrganismObservationID,,
10 
taxonOccurrenceID__overall_plot,taxonOccurrenceID__overall_plot,,
11 
identificationID,identificationID,,
12 
identificationType,identificationType,,
13 
identificationQualifier,identificationQualifier,,
14 
identificationVerificationStatus,identificationVerificationStatus,,
15 46 
collectorNumber,collectorNumber,,
16 
accessionNumber,accessionNumber,,
17 
occurrenceRemarks,occurrenceRemarks,,
18 
dateIdentified,dateIdentified,,
19 47 
dateCollected,dateCollected,,
20 48 
originalScientificName,originalScientificName,,
21 49 
originalTaxonName,originalTaxonName,,
22 50 
originalVernacularName,originalVernacularName,,
23 51 
scientificName_verbatim,scientificName_verbatim,,
24 
taxonName,taxonName,,
25 
vernacularName,vernacularName,,
26 
scientificName__for_nearest_taxon_concept,scientificName__for_nearest_taxon_concept,,
52 
dateIdentified,dateIdentified,,
27 53 
kingdom,kingdom,,
28 54 
*Subkingdom,*Subkingdom,,
29 55 
*Superdivision,*Superdivision,,
......
34 60 
order,order,,
35 61 
family,family,,
36 62 
genus,genus,,
63 
taxonName,taxonName,,
64 
scientificName,scientificName,,
65 
scientificName__for_nearest_taxon_concept,scientificName__for_nearest_taxon_concept,,
66 
vernacularName,vernacularName,,
67 
occurrenceRemarks,occurrenceRemarks,,
37 68 
observationGranularity,observationGranularity,,
38 
scientificName,scientificName,,
39 69 
coverPercent,coverPercent,,
40 70 
diameterBreastHeight_cm,diameterBreastHeight_cm,,
41 71 
height_m,height_m,,
42 72 
individualCount,individualCount,,
73 
taxonOccurrenceID,taxonOccurrenceID,,
74 
taxonOccurrenceID__overall_plot,taxonOccurrenceID__overall_plot,,
75 
identificationID,identificationID,,
76 
identificationType,identificationType,,
77 
identificationQualifier,identificationQualifier,,
78 
identificationVerificationStatus,identificationVerificationStatus,,
79 
aggregateOrganismObservationID__taxon_presence,aggregateOrganismObservationID__taxon_presence,,
80 
aggregateOrganismObservationID__individual_count,aggregateOrganismObservationID__individual_count,,
81 
aggregateOrganismObservationID,aggregateOrganismObservationID,,
82 
individualID,individualID,,
43 83 
stemID,stemID,,
44 
individualID,individualID,,
45 
stratum__name,stratum__name,,
46 
projectID,projectID,,
47 
authorEventCode,authorEventCode,,
48 
samplingProtocol,samplingProtocol,,
49 
startDate,startDate,,
50 
endDate,endDate,,
51 
organic_percent,organic_percent,,
52 
texture,texture,,
53 
sand_percent,sand_percent,,
54 
silt_percent,silt_percent,,
55 
clay_percent,clay_percent,,
56 
ph,ph,,
57 
cationExchangeCapacity_cmol_kg,cationExchangeCapacity_cmol_kg,,
58 
baseSaturation_percent,baseSaturation_percent,,
59 
emb_soilobs,emb_soilobs,,
60 
locationName,locationName,,
61 
parentLocationID,parentLocationID,,
62 
coordinateUncertaintyInMeters__from_coords,coordinateUncertaintyInMeters__from_coords,,
63 
accessRights_verbatim,accessRights_verbatim,,
64 
decimalLatitude,decimalLatitude,,
65 
decimalLongitude,decimalLongitude,,
66 
locality,locality,,
67 
footprintWKT,footprintWKT,,
68 
plotArea_m2,plotArea_m2,,
69 
elevationInMeters,elevationInMeters,,
70 
slopeAspect,slopeAspect,,
71 
minSlopeAspect,minSlopeAspect,,
72 
maxSlopeAspect,maxSlopeAspect,,
73 
slopeGradient,slopeGradient,,
74 
minSlopeGradient,minSlopeGradient,,
75 
maxSlopeGradient,maxSlopeGradient,,
76 
landform,landform,,
77 
stateProvince,stateProvince,,
78 
country,country,,
79 
continent,continent,,
80 
county,county,,
81 
accessRights,accessRights,,
82 
coordinateUncertaintyInMeters__from_fuzzing,coordinateUncertaintyInMeters__from_fuzzing,,
83 
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,
84 
taxonOccurrenceID,taxonOccurrenceID,,
84 
accessionNumber,accessionNumber,,
inputs/VegBank/taxon_observation.**.sample/unmapped_terms.csv
1 1 
sort_col
2 
coordinateUncertaintyInMeters__from_coords
3 
coordinateUncertaintyInMeters__from_fuzzing
4 
accessRights_verbatim
5 
emb_soilobs
6 
*stratum_id
2 7 
*stratumtype_id
3 
*stratum_id
4 
aggregateOrganismObservationID__taxon_presence
5 
aggregateOrganismObservationID__individual_count
6 
taxonOccurrenceID__overall_plot
7 
identificationID
8 
identificationVerificationStatus
9 8 
originalVernacularName
10 9 
scientificName_verbatim
11 
vernacularName
12 
scientificName__for_nearest_taxon_concept
13 10 
*Subkingdom
14 11 
*Superdivision
15 12 
*Division
16 13 
*Subdivision
17 14 
*Subclass
18 
emb_soilobs
19 
coordinateUncertaintyInMeters__from_coords
20 
accessRights_verbatim
21 
coordinateUncertaintyInMeters__from_fuzzing
15 
scientificName__for_nearest_taxon_concept
16 
vernacularName
17 
taxonOccurrenceID__overall_plot
18 
identificationID
19 
identificationVerificationStatus
20 
aggregateOrganismObservationID__taxon_presence
21 
aggregateOrganismObservationID__individual_count

Also available in: Unified diff