Project

General

Profile

« Previous | Next » 

Revision 7720

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/REMIB/Specimen/map.csv: Mapping NULL-equivalent lat/long to NULL: Fixed bug where need special *=* mapping to pass through values not in the map

View differences:

inputs/REMIB/Specimen/map.csv
16 16 
state,stateProvince,"/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB)"
17 17 
county,county,"/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB)"
18 18 
locality,locality,"/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB)"
19 
long_deg,longitude_deg,"/_map:[./{""-999"",99,999,1000}=]/value",-99 is a valid longitude for Mexico
20 
long_min,longitude_min,"/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
21 
long_sec,longitude_sec,"/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
22 
lat_deg,latitude_deg,"/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
23 
lat_min,latitude_min,"/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
24 
lat_sec,latitude_sec,"/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
19 
long_deg,longitude_deg,"/_map:[./{""-999"",99,999,1000}=,*=*]/value",-99 is a valid longitude for Mexico
20 
long_min,longitude_min,"/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
21 
long_sec,longitude_sec,"/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
22 
lat_deg,latitude_deg,"/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
23 
lat_min,latitude_min,"/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
24 
lat_sec,latitude_sec,"/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
25 25 
coll_day,dayCollected,,
26 26 
coll_month,monthCollected,,
27 27 
coll_year,yearCollected,,
inputs/REMIB/Specimen/VegBIEN.csv
83 83 
-----"
84 84 
locality,"/location/locationnarrative/_merge/1/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB)"
85 85 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB); Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
86 
lat_deg,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/deg/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
87 
lat_min,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/min/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
88 
lat_sec,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/sec/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
89 
long_deg,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/deg/_map:[./{""-999"",99,999,1000}=]/value",-99 is a valid longitude for Mexico
90 
long_min,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/min/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
91 
long_sec,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/sec/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
86 
lat_deg,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/deg/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
87 
lat_min,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/min/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
88 
lat_sec,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/sec/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
89 
long_deg,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/deg/_map:[./{""-999"",99,999,1000}=,*=*]/value",-99 is a valid longitude for Mexico
90 
long_min,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/min/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
91 
long_sec,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/sec/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
92 92 
country,"/location/locationplace/*_id/place/country/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB)"
93 93 
county,"/location/locationplace/*_id/place/county/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB)"
94 
lat_deg,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_dms_to_dd/deg/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
95 
lat_min,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_dms_to_dd/min/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
96 
lat_sec,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_dms_to_dd/sec/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
97 
long_deg,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_dms_to_dd/deg/_map:[./{""-999"",99,999,1000}=]/value",-99 is a valid longitude for Mexico
98 
long_min,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_dms_to_dd/min/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
99 
long_sec,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_dms_to_dd/sec/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
94 
lat_deg,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_dms_to_dd/deg/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
95 
lat_min,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_dms_to_dd/min/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
96 
lat_sec,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_dms_to_dd/sec/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
97 
long_deg,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_dms_to_dd/deg/_map:[./{""-999"",99,999,1000}=,*=*]/value",-99 is a valid longitude for Mexico
98 
long_min,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_dms_to_dd/min/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
99 
long_sec,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_dms_to_dd/sec/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
100 100 
country,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB)"
101 101 
county,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB)"
102 102 
state,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2/_map:[./{ND,NA}=,*=*]/value","""ND = no disponible = not available"" (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking#REMIB)"
inputs/REMIB/Specimen/test.xml.ref
192 192 
                                                            <99></99>
193 193 
                                                            <999></999>
194 194 
                                                            <1000></1000>
195 
                                                            <*>*</*>
195 196 
                                                            <value>$lat_deg</value>
196 197 
                                                        </_map>
197 198 
                                                    </deg>
......
202 203 
                                                            <99></99>
203 204 
                                                            <999></999>
204 205 
                                                            <1000></1000>
206 
                                                            <*>*</*>
205 207 
                                                            <value>$lat_min</value>
206 208 
                                                        </_map>
207 209 
                                                    </min>
......
212 214 
                                                            <99></99>
213 215 
                                                            <999></999>
214 216 
                                                            <1000></1000>
217 
                                                            <*>*</*>
215 218 
                                                            <value>$lat_sec</value>
216 219 
                                                        </_map>
217 220 
                                                    </sec>
......
225 228 
                                                            <99></99>
226 229 
                                                            <999></999>
227 230 
                                                            <1000></1000>
231 
                                                            <*>*</*>
228 232 
                                                            <value>$long_deg</value>
229 233 
                                                        </_map>
230 234 
                                                    </deg>
......
235 239 
                                                            <99></99>
236 240 
                                                            <999></999>
237 241 
                                                            <1000></1000>
242 
                                                            <*>*</*>
238 243 
                                                            <value>$long_min</value>
239 244 
                                                        </_map>
240 245 
                                                    </min>
......
245 250 
                                                            <99></99>
246 251 
                                                            <999></999>
247 252 
                                                            <1000></1000>
253 
                                                            <*>*</*>
248 254 
                                                            <value>$long_sec</value>
249 255 
                                                        </_map>
250 256 
                                                    </sec>
......
283 289 
                                                                    <99></99>
284 290 
                                                                    <999></999>
285 291 
                                                                    <1000></1000>
292 
                                                                    <*>*</*>
286 293 
                                                                    <value>$lat_deg</value>
287 294 
                                                                </_map>
288 295 
                                                            </deg>
......
293 300 
                                                                    <99></99>
294 301 
                                                                    <999></999>
295 302 
                                                                    <1000></1000>
303 
                                                                    <*>*</*>
296 304 
                                                                    <value>$lat_min</value>
297 305 
                                                                </_map>
298 306 
                                                            </min>
......
303 311 
                                                                    <99></99>
304 312 
                                                                    <999></999>
305 313 
                                                                    <1000></1000>
314 
                                                                    <*>*</*>
306 315 
                                                                    <value>$lat_sec</value>
307 316 
                                                                </_map>
308 317 
                                                            </sec>
......
316 325 
                                                                    <99></99>
317 326 
                                                                    <999></999>
318 327 
                                                                    <1000></1000>
328 
                                                                    <*>*</*>
319 329 
                                                                    <value>$long_deg</value>
320 330 
                                                                </_map>
321 331 
                                                            </deg>
......
326 336 
                                                                    <99></99>
327 337 
                                                                    <999></999>
328 338 
                                                                    <1000></1000>
339 
                                                                    <*>*</*>
329 340 
                                                                    <value>$long_min</value>
330 341 
                                                                </_map>
331 342 
                                                            </min>
......
336 347 
                                                                    <99></99>
337 348 
                                                                    <999></999>
338 349 
                                                                    <1000></1000>
350 
                                                                    <*>*</*>
339 351 
                                                                    <value>$long_sec</value>
340 352 
                                                                </_map>
341 353 
                                                            </sec>
inputs/REMIB/Specimen/new_terms.csv
1 1 
acronym,specimenHolders,,
2 
long_deg,longitude_deg,"/_map:[./{""-999"",99,999,1000}=]/value",-99 is a valid longitude for Mexico
3 
long_min,longitude_min,"/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
4 
long_sec,longitude_sec,"/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
5 
lat_deg,latitude_deg,"/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
6 
lat_min,latitude_min,"/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
7 
lat_sec,latitude_sec,"/_map:[./{""-999"",""-99"",99,999,1000}=]/value",
2 
long_deg,longitude_deg,"/_map:[./{""-999"",99,999,1000}=,*=*]/value",-99 is a valid longitude for Mexico
3 
long_min,longitude_min,"/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
4 
long_sec,longitude_sec,"/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
5 
lat_deg,latitude_deg,"/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
6 
lat_min,latitude_min,"/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
7 
lat_sec,latitude_sec,"/_map:[./{""-999"",""-99"",99,999,1000}=,*=*]/value",
8 8 
coll_day,dayCollected,,
9 9 
coll_month,monthCollected,,
10 10 
coll_year,yearCollected,,

Also available in: Unified diff