Project

General

Profile

« Previous | Next » 

Revision 6123

mappings/VegCore-VegBIEN.csv: matched place's coordinates: Fixed bug where coordinates entry itself needed to have its datasource (reference) set to geoscrub, in addition to the place entry that uses it, in order to match up properly with geoscrub's corresponding input place (whose coordinates as well as place are owned by the geoscrub datasource)

View differences:

inputs/FIA/Organism/test.xml.ref
137 137
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
138 138
                                    <coordinates_id>
139 139
                                        <coordinates>
140
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
140 141
                                            <latitude_deg>
141 142
                                                <_nullIf>
142 143
                                                    <null>0</null>
......
164 165
        </path>
165 166
    </_simplifyPath>
166 167
</VegBIEN>
167
Inserted 24 new rows into database
168
Inserted 25 new rows into database
inputs/NCU-NCSC/Specimen/VegBIEN.csv
20 20
Long (-=W),"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
21 21
Country,/location/locationplace/*_id/place/country,
22 22
County,/location/locationplace/*_id/place/county,
23
Lat (-=S),"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",""".,"" sorts it with other coordinates mappings"
24
Long (-=W),"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",""".,"" sorts it with other coordinates mappings"
23
Lat (-=S),"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",""".,"" sorts it with other coordinates mappings"
24
Long (-=W),"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",""".,"" sorts it with other coordinates mappings"
25 25
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
26 26
State,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
27 27
State,/location/locationplace/*_id/place/stateprovince,
inputs/MO/Specimen/test.xml.ref
223 223
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
224 224
                                    <coordinates_id>
225 225
                                        <coordinates>
226
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
226 227
                                            <latitude_deg>
227 228
                                                <_nullIf>
228 229
                                                    <null>0</null>
inputs/Madidi/Plot/VegBIEN.csv
91 91
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
92 92
Latitude (DMS),/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,
93 93
Longitude (DMS),/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,
94
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
95
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
94
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
95
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
96 96
Inventory code,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then",
97 97
Observaciones,/location/notespublic,
98 98
Direction,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/1,Part files provide either this field or OrientaciĆ³n
inputs/CVS/Organism/VegBIEN.csv
16 16
publicLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
17 17
publicLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
18 18
county,/location/locationplace/*_id/place/county,
19
publicLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
20
publicLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
19
publicLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
20
publicLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
21 21
state,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
22 22
state,/location/locationplace/*_id/place/stateprovince,
23 23
confidentialityStatus,,** No join mapping for *confidentialityStatus ** 
inputs/SALVIAS-CSV/Plot/VegBIEN.csv
47 47
major_geo,/location/locationplace/*_id/place/continent,
48 48
country,/location/locationplace/*_id/place/country,
49 49
pol2,/location/locationplace/*_id/place/county,Brad: No pol2=countyParish
50
lat_decimal,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
51
long_decimal,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
50
lat_decimal,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
51
long_decimal,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
52 52
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
53 53
pol1,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,Brad: No; pol1=stateProvince
54 54
PLOT_ID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
inputs/REMIB/Specimen/VegBIEN.csv
61 61
long_deg,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
62 62
country,/location/locationplace/*_id/place/country,
63 63
county,/location/locationplace/*_id/place/county,
64
lat_deg,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
65
long_deg,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
64
lat_deg,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
65
long_deg,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
66 66
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
67 67
state,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
68 68
state,/location/locationplace/*_id/place/stateprovince,
inputs/FIA/Organism/VegBIEN.csv
26 26
DecimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
27 27
DecimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
28 28
County,/location/locationplace/*_id/place/county,
29
DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
30
DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
29
DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
30
DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
31 31
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
32 32
PlotCD,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then",
33 33
StateProvince,/location/locationplace/*_id/place/stateprovince,
inputs/ARIZ/Specimen/test.xml.ref
312 312
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
313 313
                                    <coordinates_id>
314 314
                                        <coordinates>
315
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
315 316
                                            <latitude_deg>
316 317
                                                <_nullIf>
317 318
                                                    <null>0</null>
inputs/MO/Specimen/VegBIEN.csv
50 50
ContinentOcean,/location/locationplace/*_id/place/continent,
51 51
Country,/location/locationplace/*_id/place/country,
52 52
County,/location/locationplace/*_id/place/county,
53
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
54
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
53
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
54
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
55 55
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
56 56
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
57 57
StateProvince,/location/locationplace/*_id/place/stateprovince,
inputs/XAL/Specimen/VegBIEN.csv
62 62
darwin:ContinentOcean,/location/locationplace/*_id/place/continent,
63 63
darwin:Country,/location/locationplace/*_id/place/country,
64 64
darwin:County,/location/locationplace/*_id/place/county,
65
darwin:Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
66
darwin:Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
65
darwin:Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
66
darwin:Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
67 67
darwin:Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
68 68
darwin:StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
69 69
darwin:StateProvince,/location/locationplace/*_id/place/stateprovince,
inputs/TEAM/VL/VegBIEN.csv
40 40
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
41 41
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
42 42
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
43
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
44
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
43
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
44
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
45 45
Subplot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists",
46 46
1ha Plot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",
47 47
Subplot Number,/location/sourceaccessioncode/_join/2,
inputs/TEAM/VL/test.xml.ref
152 152
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
153 153
                                    <coordinates_id>
154 154
                                        <coordinates>
155
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
155 156
                                            <latitude_deg>
156 157
                                                <_nullIf>
157 158
                                                    <null>0</null>
inputs/TEAM/VT/VegBIEN.csv
40 40
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
41 41
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
42 42
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
43
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
44
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
43
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
44
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
45 45
Subplot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists",
46 46
1ha Plot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",
47 47
Subplot Number,/location/sourceaccessioncode/_join/2,
inputs/TEAM/VT/test.xml.ref
152 152
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
153 153
                                    <coordinates_id>
154 154
                                        <coordinates>
155
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
155 156
                                            <latitude_deg>
156 157
                                                <_nullIf>
157 158
                                                    <null>0</null>
inputs/TEAM/TEAM_Sites/VegBIEN.csv
11 11
Name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
12 12
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
13 13
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
14
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
15
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
14
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
15
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
16 16
Name,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",
17 17
1ha Plot Coordinate,,** No join mapping for *1ha Plot Coordinate ** 
inputs/TEAM/TEAM_Sites/test.xml.ref
36 36
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
37 37
                                    <coordinates_id>
38 38
                                        <coordinates>
39
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
39 40
                                            <latitude_deg>
40 41
                                                <_nullIf>
41 42
                                                    <null>0</null>
......
61 62
        </path>
62 63
    </_simplifyPath>
63 64
</VegBIEN>
64
Inserted 15 new rows into database
65
Inserted 17 new rows into database
inputs/.geoscrub/geoscrub_cleaned_unique/VegBIEN.csv
3 3
latitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
4 4
longitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
5 5
countryVerbatim,/location/locationplace/*_id/place/country,
6
latitudeDecimalVerbatim,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
7
longitudeDecimalVerbatim,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
6
latitudeDecimalVerbatim,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
7
longitudeDecimalVerbatim,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
8 8
countryStd,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/country/_first/1",
9 9
stateProvinceStd,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/stateprovince/_first/1",
10 10
countryVerbatim,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
inputs/.geoscrub/geoscrub_cleaned_unique/test.xml.ref
31 31
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
32 32
                                    <coordinates_id>
33 33
                                        <coordinates>
34
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
34 35
                                            <latitude_deg>
35 36
                                                <_nullIf>
36 37
                                                    <null>0</null>
inputs/ACAD/Specimen/VegBIEN.csv
68 68
continent,/location/locationplace/*_id/place/continent,
69 69
country,/location/locationplace/*_id/place/country,
70 70
county,/location/locationplace/*_id/place/county,
71
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
72
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
71
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
72
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
73 73
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
74 74
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
75 75
stateProvince,/location/locationplace/*_id/place/stateprovince,
inputs/ACAD/Specimen/test.xml.ref
250 250
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
251 251
                                    <coordinates_id>
252 252
                                        <coordinates>
253
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
253 254
                                            <latitude_deg>
254 255
                                                <_nullIf>
255 256
                                                    <null>0</null>
......
279 280
        </path>
280 281
    </_simplifyPath>
281 282
</VegBIEN>
282
Inserted 42 new rows into database
283
Inserted 44 new rows into database
inputs/CTFS/Plot/VegBIEN.csv
24 24
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
25 25
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
26 26
CountryName,/location/locationplace/*_id/place/country,
27
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
28
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
27
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
28
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
29 29
CountryName,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
30 30
PlotID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then",
31 31
PlotID,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/1",
inputs/CTFS/Plot/test.xml.ref
42 42
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
43 43
                                    <coordinates_id>
44 44
                                        <coordinates>
45
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
45 46
                                            <latitude_deg>
46 47
                                                <_nullIf>
47 48
                                                    <null>0</null>
inputs/SALVIAS/plotMetadata_/VegBIEN.csv
48 48
MajorGeo,/location/locationplace/*_id/place/continent,
49 49
Country,/location/locationplace/*_id/place/country,
50 50
pol2,/location/locationplace/*_id/place/county,Brad: No pol2=countyParish
51
LatDec,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
52
LongDec,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
51
LatDec,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
52
LongDec,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
53 53
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
54 54
PolDiv1,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,Brad: No; pol1=stateProvince
55 55
PlotID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
inputs/SALVIAS/plotMetadata_/test.xml.ref
115 115
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
116 116
                                    <coordinates_id>
117 117
                                        <coordinates>
118
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
118 119
                                            <latitude_deg>
119 120
                                                <_nullIf>
120 121
                                                    <null>0</null>
......
146 147
        </path>
147 148
    </_simplifyPath>
148 149
</VegBIEN>
149
Inserted 26 new rows into database
150
Inserted 28 new rows into database
inputs/U/Specimen/VegBIEN.csv
35 35
Lat,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
36 36
Long,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
37 37
Country,/location/locationplace/*_id/place/country,
38
Lat,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
39
Long,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
38
Lat,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
39
Long,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
40 40
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
41 41
Alt,,** No join mapping for *Alt ** What is this?
42 42
Alt2,,** No join mapping for *Alt2 ** What is this?
inputs/U/Specimen/test.xml.ref
203 203
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
204 204
                                    <coordinates_id>
205 205
                                        <coordinates>
206
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
206 207
                                            <latitude_deg>
207 208
                                                <_nullIf>
208 209
                                                    <null>0</null>
......
229 230
        </path>
230 231
    </_simplifyPath>
231 232
</VegBIEN>
232
Inserted 33 new rows into database
233
Inserted 34 new rows into database
inputs/GBIF/Specimen/VegBIEN.csv
55 55
VerbatimLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
56 56
Country,/location/locationplace/*_id/place/country,
57 57
County,/location/locationplace/*_id/place/county,
58
VerbatimLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
59
VerbatimLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
58
VerbatimLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
59
VerbatimLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
60 60
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
61 61
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
62 62
StateProvince,/location/locationplace/*_id/place/stateprovince,
inputs/GBIF/Specimen/test.xml.ref
251 251
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
252 252
                                    <coordinates_id>
253 253
                                        <coordinates>
254
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
254 255
                                            <latitude_deg>
255 256
                                                <_nullIf>
256 257
                                                    <null>0</null>
inputs/SpeciesLink/Specimen/VegBIEN.csv
214 214
conceptual_darwin_2003_1_0_County,/location/locationplace/*_id/place/county,
215 215
dwc_dwcore_County,/location/locationplace/*_id/place/county,
216 216
dwc_terms_county,/location/locationplace/*_id/place/county,
217
conceptual_darwin_2003_1_0_Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
218
dwc_geospatial_DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
219
dwc_terms_decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
220
conceptual_darwin_2003_1_0_Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
221
dwc_geospatial_DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
222
dwc_terms_decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
217
conceptual_darwin_2003_1_0_Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
218
dwc_geospatial_DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
219
dwc_terms_decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
220
conceptual_darwin_2003_1_0_Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
221
dwc_geospatial_DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
222
dwc_terms_decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
223 223
conceptual_darwin_2003_1_0_Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
224 224
dwc_dwcore_Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
225 225
dwc_terms_country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
inputs/SpeciesLink/Specimen/test.xml.ref
640 640
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
641 641
                                    <coordinates_id>
642 642
                                        <coordinates>
643
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
643 644
                                            <latitude_deg>
644 645
                                                <_nullIf>
645 646
                                                    <null>0</null>
inputs/bien_web/observation/VegBIEN.csv
45 45
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
46 46
country,/location/locationplace/*_id/place/country,
47 47
countyParish,/location/locationplace/*_id/place/county,
48
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
49
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
48
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
49
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
50 50
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
51 51
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
52 52
plotID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then",
inputs/bien_web/observation/test.xml.ref
157 157
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
158 158
                                    <coordinates_id>
159 159
                                        <coordinates>
160
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
160 161
                                            <latitude_deg>
161 162
                                                <_nullIf>
162 163
                                                    <null>0</null>
inputs/NY/Specimen/VegBIEN.csv
70 70
ContinentOcean,/location/locationplace/*_id/place/continent,
71 71
Country,/location/locationplace/*_id/place/country,
72 72
County,/location/locationplace/*_id/place/county,
73
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
74
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
73
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
74
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
75 75
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
76 76
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
77 77
StateProvince,/location/locationplace/*_id/place/stateprovince,
inputs/NY/Specimen/test.xml.ref
336 336
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
337 337
                                    <coordinates_id>
338 338
                                        <coordinates>
339
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
339 340
                                            <latitude_deg>
340 341
                                                <_nullIf>
341 342
                                                    <null>0</null>
......
364 365
        </path>
365 366
    </_simplifyPath>
366 367
</VegBIEN>
367
Inserted 41 new rows into database
368
Inserted 43 new rows into database
inputs/Madidi/Plot/test.xml.ref
92 92
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
93 93
                                    <coordinates_id>
94 94
                                        <coordinates>
95
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
95 96
                                            <latitude_deg>
96 97
                                                <_nullIf>
97 98
                                                    <null>0</null>
inputs/CVS/Organism/test.xml.ref
59 59
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
60 60
                                    <coordinates_id>
61 61
                                        <coordinates>
62
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
62 63
                                            <latitude_deg>
63 64
                                                <_nullIf>
64 65
                                                    <null>0</null>
......
86 87
        </path>
87 88
    </_simplifyPath>
88 89
</VegBIEN>
89
Inserted 21 new rows into database
90
Inserted 22 new rows into database
inputs/SALVIAS-CSV/Plot/test.xml.ref
105 105
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
106 106
                                    <coordinates_id>
107 107
                                        <coordinates>
108
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
108 109
                                            <latitude_deg>
109 110
                                                <_nullIf>
110 111
                                                    <null>0</null>
......
135 136
        </path>
136 137
    </_simplifyPath>
137 138
</VegBIEN>
138
Inserted 17 new rows into database
139
Inserted 18 new rows into database
inputs/REMIB/Specimen/test.xml.ref
169 169
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
170 170
                                    <coordinates_id>
171 171
                                        <coordinates>
172
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
172 173
                                            <latitude_deg>
173 174
                                                <_nullIf>
174 175
                                                    <null>0</null>
......
197 198
        </path>
198 199
    </_simplifyPath>
199 200
</VegBIEN>
200
Inserted 29 new rows into database
201
Inserted 30 new rows into database
inputs/ARIZ/Specimen/VegBIEN.csv
74 74
ContinentOcean,/location/locationplace/*_id/place/continent,
75 75
Country,/location/locationplace/*_id/place/country,
76 76
County,/location/locationplace/*_id/place/county,
77
DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
78
DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
77
DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
78
DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
79 79
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
80 80
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
81 81
StateProvince,/location/locationplace/*_id/place/stateprovince,
inputs/NCU-NCSC/Specimen/test.xml.ref
95 95
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
96 96
                                    <coordinates_id>
97 97
                                        <coordinates>
98
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
98 99
                                            <latitude_deg>
99 100
                                                <_nullIf>
100 101
                                                    <null>0</null>
inputs/VegBank/plot_/VegBIEN.csv
20 20
area|country|territory,/location/locationplace/*_id/place/country,
21 21
country,/location/locationplace/*_id/place/country,
22 22
county,/location/locationplace/*_id/place/county,
23
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
24
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
23
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
24
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
25 25
area|country|territory,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
26 26
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
27 27
region|state|province,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
inputs/QMOR/Specimen/VegBIEN.csv
76 76
continent,/location/locationplace/*_id/place/continent,
77 77
country,/location/locationplace/*_id/place/country,
78 78
county,/location/locationplace/*_id/place/county,
79
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
80
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
79
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
80
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
81 81
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,
82 82
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
83 83
stateProvince,/location/locationplace/*_id/place/stateprovince,
inputs/VegBank/plot_/test.xml.ref
46 46
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
47 47
                                    <coordinates_id>
48 48
                                        <coordinates>
49
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
49 50
                                            <latitude_deg>
50 51
                                                <_nullIf>
51 52
                                                    <null>0</null>
......
112 113
        </path>
113 114
    </_simplifyPath>
114 115
</VegBIEN>
115
Inserted 11 new rows into database
116
Inserted 12 new rows into database
inputs/QMOR/Specimen/test.xml.ref
275 275
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
276 276
                                    <coordinates_id>
277 277
                                        <coordinates>
278
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
278 279
                                            <latitude_deg>
279 280
                                                <_nullIf>
280 281
                                                    <null>0</null>
mappings/VegCore-VegBIEN.csv
324 324
continent,/location/locationplace/*_id/place/continent,
325 325
country,/location/locationplace/*_id/place/country,
326 326
county,/location/locationplace/*_id/place/county,
327
acceptedDecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub,matched_place_id=0]/*_id/coordinates/_first/1/latitude_deg",""".,"" sorts it with other coordinates mappings"
328
acceptedDecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub,matched_place_id=0]/*_id/coordinates/_first/1/longitude_deg",""".,"" sorts it with other coordinates mappings"
329
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
330
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
327
acceptedDecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub,matched_place_id=0]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/1/latitude_deg",""".,"" sorts it with other coordinates mappings"
328
acceptedDecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub,matched_place_id=0]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/1/longitude_deg",""".,"" sorts it with other coordinates mappings"
329
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
330
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
331 331
acceptedCountry,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/country/_first/1",
332 332
acceptedStateProvince,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/stateprovince/_first/1",
333 333
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2,

Also available in: Unified diff