Revision 11923
Added by Aaron Marcuse-Kubitza almost 11 years ago
inputs/TEX/Specimen/map.csv | ||
---|---|---|
36 | 36 |
DATA ENTRY BY,*DATA ENTRY BY,, |
37 | 37 |
DATA ENTRY DATE,*DATA ENTRY DATE,, |
38 | 38 |
DATA EDITED DATE,modified,, |
39 |
:TEX,specimenHolderInstitutions,, |
|
40 |
:United States,country,, |
inputs/TEX/Specimen/test.xml.ref | ||
---|---|---|
9 | 9 |
<location> |
10 | 10 |
<authorlocationcode> |
11 | 11 |
<_join> |
12 |
<1>TEX</1> |
|
12 | 13 |
<2>$collection</2> |
13 | 14 |
<3>$accessionNumber</3> |
14 | 15 |
</_join> |
... | ... | |
43 | 44 |
<catalognumber_dwc>$accessionNumber</catalognumber_dwc> |
44 | 45 |
<collectioncode_dwc>$collection</collectioncode_dwc> |
45 | 46 |
<collectionnumber>$collectorNumber</collectionnumber> |
47 |
<institution_id> |
|
48 |
<sourcelist> |
|
49 |
<name>TEX</name> |
|
50 |
<sourcename> |
|
51 |
<name> |
|
52 |
<_split> |
|
53 |
<separator>[,;] *</separator> |
|
54 |
<value>TEX</value> |
|
55 |
</_split> |
|
56 |
</name> |
|
57 |
</sourcename> |
|
58 |
</sourcelist> |
|
59 |
</institution_id> |
|
46 | 60 |
</specimenreplicate> |
47 | 61 |
</plantobservation> |
48 | 62 |
</aggregateoccurrence> |
... | ... | |
173 | 187 |
</longitude_deg> |
174 | 188 |
</coordinates> |
175 | 189 |
</coordinates_id> |
190 |
<country>United States</country> |
|
176 | 191 |
<county>$county</county> |
177 | 192 |
<matched_place_id> |
178 | 193 |
<place> |
... | ... | |
196 | 211 |
</longitude_deg> |
197 | 212 |
</coordinates> |
198 | 213 |
</coordinates_id> |
214 |
<country>United States</country> |
|
199 | 215 |
<county>$county</county> |
200 | 216 |
<stateprovince>$stateProvince</stateprovince> |
201 | 217 |
</place> |
... | ... | |
211 | 227 |
</path> |
212 | 228 |
</_setDefault> |
213 | 229 |
</VegBIEN> |
214 |
Inserted 38 new rows into database |
|
230 |
Inserted 40 new rows into database |
inputs/TEX/Specimen2/map.csv | ||
---|---|---|
44 | 44 |
DET DATE,dateIdentified,, |
45 | 45 |
DETERMINER INSTITUTION,*DETERMINER INSTITUTION,, |
46 | 46 |
DET NOTES,identificationRemarks,, |
47 |
:TEX,specimenHolderInstitutions,, |
|
48 |
:United States,country,, |
inputs/TEX/Specimen2/test.xml.ref | ||
---|---|---|
9 | 9 |
<location> |
10 | 10 |
<authorlocationcode> |
11 | 11 |
<_join> |
12 |
<1>TEX</1> |
|
12 | 13 |
<2>$collection</2> |
13 | 14 |
<3>$accessionNumber</3> |
14 | 15 |
</_join> |
... | ... | |
43 | 44 |
<catalognumber_dwc>$accessionNumber</catalognumber_dwc> |
44 | 45 |
<collectioncode_dwc>$collection</collectioncode_dwc> |
45 | 46 |
<collectionnumber>$collectorNumber</collectionnumber> |
47 |
<institution_id> |
|
48 |
<sourcelist> |
|
49 |
<name>TEX</name> |
|
50 |
<sourcename> |
|
51 |
<name> |
|
52 |
<_split> |
|
53 |
<separator>[,;] *</separator> |
|
54 |
<value>TEX</value> |
|
55 |
</_split> |
|
56 |
</name> |
|
57 |
</sourcename> |
|
58 |
</sourcelist> |
|
59 |
</institution_id> |
|
46 | 60 |
</specimenreplicate> |
47 | 61 |
</plantobservation> |
48 | 62 |
</aggregateoccurrence> |
... | ... | |
172 | 186 |
<verbatimlongitude>$longitude_DMS</verbatimlongitude> |
173 | 187 |
</coordinates> |
174 | 188 |
</coordinates_id> |
189 |
<country>United States</country> |
|
175 | 190 |
<county>$county</county> |
176 | 191 |
<matched_place_id> |
177 | 192 |
<place> |
... | ... | |
183 | 198 |
<longitude_deg><_dms_to_dd><value>$longitude_DMS</value></_dms_to_dd></longitude_deg> |
184 | 199 |
</coordinates> |
185 | 200 |
</coordinates_id> |
201 |
<country>United States</country> |
|
186 | 202 |
<county>$county</county> |
187 | 203 |
<stateprovince>$stateProvince</stateprovince> |
188 | 204 |
</place> |
... | ... | |
198 | 214 |
</path> |
199 | 215 |
</_setDefault> |
200 | 216 |
</VegBIEN> |
201 |
Inserted 29 new rows into database |
|
217 |
Inserted 31 new rows into database |
Also available in: Unified diff
fix: inputs/TEX/Specimen*/map.csv: mapped constant values for specimenHolderInstitutions, country. these have to be added with `rm=1 ./inputs/TEX/Specimen.../run postprocess`.