Revision 10574
Added by Aaron Marcuse-Kubitza almost 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