Project

General

Profile

« Previous | Next » 

Revision 6075

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/bien_web/observation/map.csv: Omit *_index because they are placeholder columns created by the MySQL to PostgreSQL translation

View differences:

inputs/bien_web/observation/map.csv
51 51 
traitValue,*traitValue,,
52 52 
traitUnit,*traitUnit,,
53 53 
traitMethod,*traitMethod,,
54 
observationID_index,*observationID_index,,
55 
dataSourceID_index,*dataSourceID_index,,
56 
dataSourceName_index,*dataSourceName_index,,
57 
dataSourceNamePrimary_index,*dataSourceNamePrimary_index,,
58 
plotID_index,*plotID_index,,
59 
observationType_index,*observationType_index,,
60 
bien2_taxonomyID_index,*bien2_taxonomyID_index,,
61 
bien2_DBPlotID_index,*bien2_DBPlotID_index,,
62 
bien2_ObservationID_index,*bien2_ObservationID_index,,
63 
bien2_OccurID_index,*bien2_OccurID_index,,
64 
taxonAuthorityVerbatim_index,*taxonAuthorityVerbatim_index,,
65 
higherPlantGroup_index,*higherPlantGroup_index,,
66 
family_index,*family_index,,
67 
genus_index,*genus_index,,
68 
species_index,*species_index,,
69 
taxon_index,*taxon_index,,
70 
taxonAuthor_index,*taxonAuthor_index,,
71 
taxonMorphospecies_index,*taxonMorphospecies_index,,
72 
rank_index,*rank_index,,
73 
acceptance_index,*acceptance_index,,
74 
country_index,*country_index,,
75 
stateProvince_index,*stateProvince_index,,
76 
collector_index,*collector_index,,
77 
identifiedBy_index,*identifiedBy_index,,
78 
plotCode_index,*plotCode_index,,
79 
plotAreaHa_index,*plotAreaHa_index,,
80 
plotMinDbh_index,*plotMinDbh_index,,
81 
plotMethod_index,*plotMethod_index,,
82 
isValidLatLong_index,*isValidLatLong_index,,
83 
isGeovalid_index,*isGeovalid_index,,
84 
isNewWorld_index,*isNewWorld_index,,
85 
isCultivated_index,*isCultivated_index,,
86 
isCultivatedReason_index,*isCultivatedReason_index,,
87 
bien2_TraitObservationID_index,*bien2_TraitObservationID_index,,
88 
traitName_index,*traitName_index,,
89 
traitMethod_index,*traitMethod_index,,
90 
traitUnit_index,*traitUnit_index,,
54 
observationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
55 
dataSourceID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
56 
dataSourceName_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
57 
dataSourceNamePrimary_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
58 
plotID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
59 
observationType_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
60 
bien2_taxonomyID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
61 
bien2_DBPlotID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
62 
bien2_ObservationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
63 
bien2_OccurID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
64 
taxonAuthorityVerbatim_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
65 
higherPlantGroup_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
66 
family_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
67 
genus_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
68 
species_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
69 
taxon_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
70 
taxonAuthor_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
71 
taxonMorphospecies_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
72 
rank_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
73 
acceptance_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
74 
country_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
75 
stateProvince_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
76 
collector_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
77 
identifiedBy_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
78 
plotCode_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
79 
plotAreaHa_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
80 
plotMinDbh_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
81 
plotMethod_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
82 
isValidLatLong_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
83 
isGeovalid_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
84 
isNewWorld_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
85 
isCultivated_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
86 
isCultivatedReason_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
87 
bien2_TraitObservationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
88 
traitName_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
89 
traitMethod_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
90 
traitUnit_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
inputs/bien_web/observation/VegBIEN.csv
58 58 
abund10,,** No join mapping for *abund10 **
59 59 
abund2.5,,** No join mapping for *abund2.5 **
60 60 
acceptance,,** No join mapping for *acceptance **
61 
acceptance_index,,** No join mapping for *acceptance_index **
61 
acceptance_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
62 62 
bien2_DBPlotID,,** No join mapping for *bien2_DBPlotID **
63 
bien2_DBPlotID_index,,** No join mapping for *bien2_DBPlotID_index **
63 
bien2_DBPlotID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
64 64 
bien2_ObservationID,,** No join mapping for *bien2_ObservationID **
65 
bien2_ObservationID_index,,** No join mapping for *bien2_ObservationID_index **
65 
bien2_ObservationID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
66 66 
bien2_OccurID,,** No join mapping for *bien2_OccurID **
67 
bien2_OccurID_index,,** No join mapping for *bien2_OccurID_index **
67 
bien2_OccurID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
68 68 
bien2_TraitObservationID,,** No join mapping for *bien2_TraitObservationID **
69 
bien2_TraitObservationID_index,,** No join mapping for *bien2_TraitObservationID_index **
69 
bien2_TraitObservationID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
70 70 
bien2_taxonomyID,,** No join mapping for *bien2_taxonomyID **
71 
bien2_taxonomyID_index,,** No join mapping for *bien2_taxonomyID_index **
72 
collector_index,,** No join mapping for *collector_index **
71 
bien2_taxonomyID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
72 
collector_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
73 73 
countryError,,** No join mapping for *countryError **
74 
country_index,,** No join mapping for *country_index **
74 
country_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
75 75 
dataSourceID,,** No join mapping for *dataSourceID **
76 
dataSourceID_index,,** No join mapping for *dataSourceID_index **
76 
dataSourceID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
77 77 
dataSourceNamePrimary,,** No join mapping for *dataSourceNamePrimary **
78 
dataSourceNamePrimary_index,,** No join mapping for *dataSourceNamePrimary_index **
79 
dataSourceName_index,,** No join mapping for *dataSourceName_index **
80 
family_index,,** No join mapping for *family_index **
81 
genus_index,,** No join mapping for *genus_index **
78 
dataSourceNamePrimary_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
79 
dataSourceName_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
80 
family_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
81 
genus_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
82 82 
higherPlantGroup,,** No join mapping for higherPlantGroup **
83 
higherPlantGroup_index,,** No join mapping for *higherPlantGroup_index **
84 
identifiedBy_index,,** No join mapping for *identifiedBy_index **
83 
higherPlantGroup_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
84 
identifiedBy_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
85 85 
isCultivatedReason,,** No join mapping for cultivatedBasis **
86 
isCultivatedReason_index,,** No join mapping for *isCultivatedReason_index **
87 
isCultivated_index,,** No join mapping for *isCultivated_index **
86 
isCultivatedReason_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
87 
isCultivated_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
88 88 
isGeovalid,,** No join mapping for *isGeovalid **
89 
isGeovalid_index,,** No join mapping for *isGeovalid_index **
89 
isGeovalid_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
90 90 
isNewWorld,,** No join mapping for isNewWorld **
91 
isNewWorld_index,,** No join mapping for *isNewWorld_index **
91 
isNewWorld_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
92 92 
isValidLatLong,,** No join mapping for *isValidLatLong **
93 
isValidLatLong_index,,** No join mapping for *isValidLatLong_index **
93 
isValidLatLong_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
94 94 
localityDescription,,** No join mapping for *localityDescription **
95 95 
observationID,,** No join mapping for *observationID **
96 
observationID_index,,** No join mapping for *observationID_index **
96 
observationID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
97 97 
observationType,,** No join mapping for *observationType **
98 
observationType_index,,** No join mapping for *observationType_index **
99 
plotAreaHa_index,,** No join mapping for *plotAreaHa_index **
100 
plotCode_index,,** No join mapping for *plotCode_index **
101 
plotID_index,,** No join mapping for *plotID_index **
102 
plotMethod_index,,** No join mapping for *plotMethod_index **
98 
observationType_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
99 
plotAreaHa_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
100 
plotCode_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
101 
plotID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
102 
plotMethod_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
103 103 
plotMinDbh,,** No join mapping for *plotMinDbh **
104 
plotMinDbh_index,,** No join mapping for *plotMinDbh_index **
104 
plotMinDbh_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
105 105 
rank,,** No join mapping for *rank **
106 
rank_index,,** No join mapping for *rank_index **
107 
species_index,,** No join mapping for *species_index **
106 
rank_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
107 
species_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
108 108 
stateProvinceError,,** No join mapping for *stateProvinceError **
109 
stateProvince_index,,** No join mapping for *stateProvince_index **
110 
taxonAuthor_index,,** No join mapping for *taxonAuthor_index **
109 
stateProvince_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
110 
taxonAuthor_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
111 111 
taxonAuthorityVerbatim,,** No join mapping for *taxonAuthorityVerbatim **
112 
taxonAuthorityVerbatim_index,,** No join mapping for *taxonAuthorityVerbatim_index **
112 
taxonAuthorityVerbatim_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
113 113 
taxonMorphospecies,,** No join mapping for scientificNameWithMorphospecies **
114 
taxonMorphospecies_index,,** No join mapping for *taxonMorphospecies_index **
115 
taxon_index,,** No join mapping for *taxon_index **
114 
taxonMorphospecies_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
115 
taxon_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
116 116 
traitMethod,,** No join mapping for *traitMethod **
117 
traitMethod_index,,** No join mapping for *traitMethod_index **
117 
traitMethod_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
118 118 
traitName,,** No join mapping for *traitName **
119 
traitName_index,,** No join mapping for *traitName_index **
119 
traitName_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
120 120 
traitUnit,,** No join mapping for *traitUnit **
121 
traitUnit_index,,** No join mapping for *traitUnit_index **
121 
traitUnit_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
122 122 
traitValue,,** No join mapping for *traitValue **
inputs/bien_web/observation/new_terms.csv
11 11 
isCultivated,cultivated,,
12 12 
isCultivatedReason,cultivatedBasis,,
13 13 
pctCover,coverPercent,,
14 
observationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
15 
dataSourceID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
16 
dataSourceName_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
17 
dataSourceNamePrimary_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
18 
plotID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
19 
observationType_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
20 
bien2_taxonomyID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
21 
bien2_DBPlotID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
22 
bien2_ObservationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
23 
bien2_OccurID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
24 
taxonAuthorityVerbatim_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
25 
higherPlantGroup_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
26 
family_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
27 
genus_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
28 
species_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
29 
taxon_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
30 
taxonAuthor_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
31 
taxonMorphospecies_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
32 
rank_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
33 
acceptance_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
34 
country_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
35 
stateProvince_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
36 
collector_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
37 
identifiedBy_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
38 
plotCode_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
39 
plotAreaHa_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
40 
plotMinDbh_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
41 
plotMethod_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
42 
isValidLatLong_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
43 
isGeovalid_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
44 
isNewWorld_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
45 
isCultivated_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
46 
isCultivatedReason_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
47 
bien2_TraitObservationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
48 
traitName_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
49 
traitMethod_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
50 
traitUnit_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
inputs/bien_web/observation/unmapped_terms.csv
28 28 
*traitValue
29 29 
*traitUnit
30 30 
*traitMethod
31 
*observationID_index
32 
*dataSourceID_index
33 
*dataSourceName_index
34 
*dataSourceNamePrimary_index
35 
*plotID_index
36 
*observationType_index
37 
*bien2_taxonomyID_index
38 
*bien2_DBPlotID_index
39 
*bien2_ObservationID_index
40 
*bien2_OccurID_index
41 
*taxonAuthorityVerbatim_index
42 
*higherPlantGroup_index
43 
*family_index
44 
*genus_index
45 
*species_index
46 
*taxon_index
47 
*taxonAuthor_index
48 
*taxonMorphospecies_index
49 
*rank_index
50 
*acceptance_index
51 
*country_index
52 
*stateProvince_index
53 
*collector_index
54 
*identifiedBy_index
55 
*plotCode_index
56 
*plotAreaHa_index
57 
*plotMinDbh_index
58 
*plotMethod_index
59 
*isValidLatLong_index
60 
*isGeovalid_index
61 
*isNewWorld_index
62 
*isCultivated_index
63 
*isCultivatedReason_index
64 
*bien2_TraitObservationID_index
65 
*traitName_index
66 
*traitMethod_index
67 
*traitUnit_index

Also available in: Unified diff