Project

General

Profile

« Previous | Next » 

Revision 10571

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/U/Specimen/map.csv: Gazetteer/Newgazett: remapped to county, which is the closest equivalent for Guyana/Suriname

View differences:

inputs/U/Specimen/map.csv
16 16 
cf,identificationQualifier,,
17 17 
Detby,identifiedBy,,
18 18 
Detyy,yearIdentified,,
19 
Gazetteer,verbatimLocality,"/_join/1/_label[label=""gazetteer""]/value/_alt/1",
20 
Newgazett,verbatimLocality,"/_join/1/_label[label=""gazetteer""]/value/_alt/2","only used in 1 row. only one of Gazetteer, Newgazett is ever populated."
19 
Gazetteer,county,/_alt/1,
20 
Newgazett,county,/_alt/2,"only used in 1 row. only one of Gazetteer, Newgazett is ever populated."
21 21 
Majorarea,*Majorarea,,
22 22 
Country,country,,
23 
Locnotes,verbatimLocality,/_join/2,
23 
Locnotes,verbatimLocality,,
24 24 
Coorsyst,*Coorsyst,,
25 25 
Lat,decimalLatitude,,
26 26 
NS,*NS,,
inputs/U/Specimen/VegBIEN.csv
9 9 
:U,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2",
10 10 
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
11 11 
Number,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
12 
Gazetteer,"/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2/_join/1/_label[label=""gazetteer""]/value/_alt/1",
13 
Newgazett,"/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2/_join/1/_label[label=""gazetteer""]/value/_alt/2","only used in 1 row. only one of Gazetteer, Newgazett is ever populated."
14 
Locnotes,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2/_join/2,
12 
Locnotes,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2,
15 13 
Ecology,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3,
16 14 
Detyy,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
17 15 
cf,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit",
......
45 43 
cf,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
46 44 
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
47 45 
Number,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",
48 
Gazetteer,"/location/locationnarrative/_merge/2/_join/1/_label[label=""gazetteer""]/value/_alt/1",
49 
Newgazett,"/location/locationnarrative/_merge/2/_join/1/_label[label=""gazetteer""]/value/_alt/2","only used in 1 row. only one of Gazetteer, Newgazett is ever populated."
50 
Locnotes,/location/locationnarrative/_merge/2/_join/2,
46 
Locnotes,/location/locationnarrative/_merge/2,
51 47 
Ecology,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
52 48 
Lat,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
53 49 
Long,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
54 50 
Country,/location/locationplace/*_id/place/country,
51 
Gazetteer,/location/locationplace/*_id/place/county/_alt/1,
52 
Newgazett,/location/locationplace/*_id/place/county/_alt/2,"only used in 1 row. only one of Gazetteer, Newgazett is ever populated."
55 53 
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"
56 54 
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"
57 55 
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,
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."
58 58 
Alt,,** No join mapping for *Alt ** What is this?
59 59 
Alt2,,** No join mapping for *Alt2 ** What is this?
60 60 
Coorsyst,,** No join mapping for *Coorsyst **
inputs/U/Specimen/test.xml.ref
22 22 
                            <_locationnarrative_is_cultivated>
23 23 
                                <locationnarrative>
24 24 
                                    <_join>
25 
                                        <2>
26 
                                            <_join>
27 
                                                <1>
28 
                                                    <_label>
29 
                                                        <label>gazetteer</label>
30 
                                                        <value>
31 
                                                            <_alt>
32 
                                                                <1>$Gazetteer</1>
33 
                                                                <2>$Newgazett</2>
34 
                                                            </_alt>
35 
                                                        </value>
36 
                                                    </_label>
37 
                                                </1>
38 
                                                <2>$Locnotes</2>
39 
                                            </_join>
40 
                                        </2>
25 
                                        <2>$Locnotes</2>
41 26 
                                        <3>$Ecology</3>
42 27 
                                    </_join>
43 28 
                                </locationnarrative>
......
182 167 
                        </locationevent>
183 168 
                        <locationnarrative>
184 169 
                            <_merge>
185 
                                <2>
186 
                                    <_join>
187 
                                        <1>
188 
                                            <_label>
189 
                                                <label>gazetteer</label>
190 
                                                <value>
191 
                                                    <_alt>
192 
                                                        <1>$Gazetteer</1>
193 
                                                        <2>$Newgazett</2>
194 
                                                    </_alt>
195 
                                                </value>
196 
                                            </_label>
197 
                                        </1>
198 
                                        <2>$Locnotes</2>
199 
                                    </_join>
200 
                                </2>
170 
                                <2>$Locnotes</2>
201 171 
                                <3>
202 172 
                                    <_label>
203 173 
                                        <label>habitat</label>
......
228 198 
                                        </coordinates>
229 199 
                                    </coordinates_id>
230 200 
                                    <country>$Country</country>
201 
                                    <county>
202 
                                        <_alt>
203 
                                            <1>$Gazetteer</1>
204 
                                            <2>$Newgazett</2>
205 
                                        </_alt>
206 
                                    </county>
231 207 
                                    <matched_place_id>
232 208 
                                        <place>
233 209 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
......
251 227 
                                                </coordinates>
252 228 
                                            </coordinates_id>
253 229 
                                            <country>$Country</country>
230 
                                            <county>
231 
                                                <_alt>
232 
                                                    <1>$Gazetteer</1>
233 
                                                    <2>$Newgazett</2>
234 
                                                </_alt>
235 
                                            </county>
254 236 
                                        </place>
255 237 
                                    </matched_place_id>
256 238 
                                </place>
inputs/U/Specimen/new_terms.csv
6 6 
cf,identificationQualifier,,
7 7 
Detby,identifiedBy,,
8 8 
Detyy,yearIdentified,,
9 
Gazetteer,verbatimLocality,"/_join/1/_label[label=""gazetteer""]/value/_alt/1",
10 
Newgazett,verbatimLocality,"/_join/1/_label[label=""gazetteer""]/value/_alt/2","only used in 1 row. only one of Gazetteer, Newgazett is ever populated."
11 
Locnotes,verbatimLocality,/_join/2,
9 
Gazetteer,county,/_alt/1,
10 
Newgazett,county,/_alt/2,"only used in 1 row. only one of Gazetteer, Newgazett is ever populated."
11 
Locnotes,verbatimLocality,,
12 12 
Lat,decimalLatitude,,
13 13 
Long,decimalLongitude,,
14 14 
Ecology,habitat,,

Also available in: Unified diff