Revision 10574
Added by Aaron Marcuse-Kubitza over 11 years ago
inputs/U/Specimen/map.csv | ||
---|---|---|
16 | 16 |
cf,identificationQualifier,, |
17 | 17 |
Detby,identifiedBy,, |
18 | 18 |
Detyy,yearIdentified,, |
19 |
Gazetteer,county,/_alt/1,closest equivalent for Guyana/Suriname
|
|
20 |
Newgazett,county,/_alt/2,"only used in 1 row. only one of Gazetteer, Newgazett is ever populated."
|
|
19 |
Gazetteer,county.main,,closest equivalent for Guyana/Suriname
|
|
20 |
Newgazett,county.alt,,"only used in 1 row. only one of Gazetteer, Newgazett is ever populated."
|
|
21 | 21 |
Majorarea,stateProvince,,closest equivalent for Guyana/Suriname |
22 | 22 |
Country,country,, |
23 | 23 |
Locnotes,verbatimLocality,, |
... | ... | |
32 | 32 |
Phenology,reproductiveCondition,, |
33 | 33 |
Notes,occurrenceRemarks,, |
34 | 34 |
:U,specimenHolderInstitutions,, |
35 |
county,county,, |
inputs/U/Specimen/VegBIEN.csv | ||
---|---|---|
48 | 48 |
Lat,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
49 | 49 |
Long,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
50 | 50 |
Country,/location/locationplace/*_id/place/country, |
51 |
Gazetteer,/location/locationplace/*_id/place/county/_alt/1,closest equivalent for Guyana/Suriname |
|
52 |
Newgazett,/location/locationplace/*_id/place/county/_alt/2,"only used in 1 row. only one of Gazetteer, Newgazett is ever populated." |
|
51 |
county,/location/locationplace/*_id/place/county, |
|
53 | 52 |
Lat,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
54 | 53 |
Long,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
55 | 54 |
Country,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2, |
56 |
Gazetteer,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2/_alt/1,closest equivalent for Guyana/Suriname |
|
57 |
Newgazett,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2/_alt/2,"only used in 1 row. only one of Gazetteer, Newgazett is ever populated." |
|
55 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
|
58 | 56 |
Majorarea,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,closest equivalent for Guyana/Suriname |
59 | 57 |
Majorarea,/location/locationplace/*_id/place/stateprovince,closest equivalent for Guyana/Suriname |
60 | 58 |
Alt,,** No join mapping for *Alt ** What is this? |
... | ... | |
62 | 60 |
Coorsyst,,** No join mapping for *Coorsyst ** |
63 | 61 |
DateInfo,,** No non-empty join mapping for UNUSED#DateInfo ** |
64 | 62 |
EW,,** No join mapping for *EW ** |
63 |
Gazetteer,,** No join mapping for county.main ** closest equivalent for Guyana/Suriname |
|
65 | 64 |
NS,,** No join mapping for *NS ** |
65 |
Newgazett,,"** No join mapping for county.alt ** only used in 1 row. only one of Gazetteer, Newgazett is ever populated." |
|
66 | 66 |
Prefix,,** No non-empty join mapping for UNUSED#Prefix ** |
67 | 67 |
Suffix,,** No non-empty join mapping for UNUSED#Suffix ** |
68 | 68 |
row_num,,** No join mapping for *row_num ** |
inputs/U/Specimen/test.xml.ref | ||
---|---|---|
198 | 198 |
</coordinates> |
199 | 199 |
</coordinates_id> |
200 | 200 |
<country>$Country</country> |
201 |
<county> |
|
202 |
<_alt> |
|
203 |
<1>$Gazetteer</1> |
|
204 |
<2>$Newgazett</2> |
|
205 |
</_alt> |
|
206 |
</county> |
|
201 |
<county>$county</county> |
|
207 | 202 |
<matched_place_id> |
208 | 203 |
<place> |
209 | 204 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
... | ... | |
227 | 222 |
</coordinates> |
228 | 223 |
</coordinates_id> |
229 | 224 |
<country>$Country</country> |
230 |
<county> |
|
231 |
<_alt> |
|
232 |
<1>$Gazetteer</1> |
|
233 |
<2>$Newgazett</2> |
|
234 |
</_alt> |
|
235 |
</county> |
|
225 |
<county>$county</county> |
|
236 | 226 |
<stateprovince>$Majorarea</stateprovince> |
237 | 227 |
</place> |
238 | 228 |
</matched_place_id> |
inputs/U/Specimen/new_terms.csv | ||
---|---|---|
6 | 6 |
cf,identificationQualifier,, |
7 | 7 |
Detby,identifiedBy,, |
8 | 8 |
Detyy,yearIdentified,, |
9 |
Gazetteer,county,/_alt/1,closest equivalent for Guyana/Suriname
|
|
10 |
Newgazett,county,/_alt/2,"only used in 1 row. only one of Gazetteer, Newgazett is ever populated."
|
|
9 |
Gazetteer,county.main,,closest equivalent for Guyana/Suriname
|
|
10 |
Newgazett,county.alt,,"only used in 1 row. only one of Gazetteer, Newgazett is ever populated."
|
|
11 | 11 |
Majorarea,stateProvince,,closest equivalent for Guyana/Suriname |
12 | 12 |
Locnotes,verbatimLocality,, |
13 | 13 |
Lat,decimalLatitude,, |
inputs/U/Specimen/unmapped_terms.csv | ||
---|---|---|
1 | 1 |
*row_num |
2 |
county.main |
|
3 |
county.alt |
|
2 | 4 |
*Coorsyst |
3 | 5 |
*NS |
4 | 6 |
*EW |
Also available in: Unified diff
inputs/U/Specimen/: translated some multi-column filters to postprocessing derived columns, using the steps at http://wiki.vegpath.org/Adding_new-style_import_to_a_datasource#Translating-filters-to-postprocessing-derived-columns