Revision 7670
Added by Aaron Marcuse-Kubitza almost 12 years ago
inputs/TEX/Specimen/map.csv | ||
---|---|---|
15 | 15 |
INFRA NAME,infraspecificEpithet,, |
16 | 16 |
INFRA AUTHORITY,*INFRA AUTHORITY,, |
17 | 17 |
DETERMINED BY,identifiedBy,, |
18 |
LAT DEGREES,decimalLatitude,,
|
|
19 |
LAT MINUTES,*LAT MINUTES,,
|
|
20 |
LAT SECONDS,*LAT SECONDS,,
|
|
18 |
LAT DEGREES,latitude_deg,,
|
|
19 |
LAT MINUTES,latitude_min,,
|
|
20 |
LAT SECONDS,latitude_sec,,
|
|
21 | 21 |
LAT NS,*LAT NS,, |
22 |
LONG DEGREES,decimalLongitude,,
|
|
23 |
LONG MINUTES,*LONG MINUTES,,
|
|
24 |
LONG SECONDS,*LONG SECONDS,,
|
|
22 |
LONG DEGREES,longitude_deg,,
|
|
23 |
LONG MINUTES,longitude_min,,
|
|
24 |
LONG SECONDS,longitude_sec,,
|
|
25 | 25 |
LONG EW,*LONG EW,, |
26 | 26 |
SOURCE OF LATLONG,*SOURCE OF LATLONG,, |
27 | 27 |
STATE,stateProvince,, |
inputs/TEX/Specimen/VegBIEN.csv | ||
---|---|---|
41 | 41 |
COLLECTOR NUMBER,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then", |
42 | 42 |
LOCATION,/location/locationnarrative/_merge/1, |
43 | 43 |
ECOLOGICAL INFORMATION,"/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?" |
44 |
LAT DEGREES,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
45 |
LONG DEGREES,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
44 |
LAT DEGREES,/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/deg, |
|
45 |
LAT MINUTES,/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/min, |
|
46 |
LAT SECONDS,/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/sec, |
|
47 |
LONG DEGREES,/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/deg, |
|
48 |
LONG MINUTES,/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/min, |
|
49 |
LONG SECONDS,/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/sec, |
|
46 | 50 |
COUNTY,/location/locationplace/*_id/place/county, |
47 |
LAT DEGREES,"/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" |
|
48 |
LONG DEGREES,"/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" |
|
51 |
LAT DEGREES,"/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", |
|
52 |
LAT MINUTES,"/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", |
|
53 |
LAT SECONDS,"/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", |
|
54 |
LONG DEGREES,"/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", |
|
55 |
LONG MINUTES,"/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", |
|
56 |
LONG SECONDS,"/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", |
|
49 | 57 |
COUNTY,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
50 | 58 |
STATE,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
51 | 59 |
STATE,/location/locationplace/*_id/place/stateprovince, |
... | ... | |
56 | 64 |
DET NOTES,,** No join mapping for identificationRemarks ** |
57 | 65 |
INFRA AUTHORITY,,** No join mapping for *INFRA AUTHORITY ** |
58 | 66 |
INFRA RANK,,** No join mapping for infraspecificRank ** |
59 |
LAT MINUTES,,** No join mapping for *LAT MINUTES ** |
|
60 | 67 |
LAT NS,,** No join mapping for *LAT NS ** |
61 |
LAT SECONDS,,** No join mapping for *LAT SECONDS ** |
|
62 | 68 |
LONG EW,,** No join mapping for *LONG EW ** |
63 |
LONG MINUTES,,** No join mapping for *LONG MINUTES ** |
|
64 |
LONG SECONDS,,** No join mapping for *LONG SECONDS ** |
|
65 | 69 |
SOURCE OF LATLONG,,** No join mapping for *SOURCE OF LATLONG ** |
66 | 70 |
UTM,,** No join mapping for *UTM ** |
inputs/TEX/Specimen/test.xml.ref | ||
---|---|---|
161 | 161 |
<coordinates_id> |
162 | 162 |
<coordinates> |
163 | 163 |
<latitude_deg> |
164 |
<_nullIf>
|
|
165 |
<null>0</null>
|
|
166 |
<type>float</type>
|
|
167 |
<value>$LAT DEGREES</value>
|
|
168 |
</_nullIf>
|
|
164 |
<_dms_to_dd>
|
|
165 |
<deg>$LAT DEGREES</deg>
|
|
166 |
<min>$LAT MINUTES</min>
|
|
167 |
<sec>$LAT SECONDS</sec>
|
|
168 |
</_dms_to_dd>
|
|
169 | 169 |
</latitude_deg> |
170 | 170 |
<longitude_deg> |
171 |
<_nullIf>
|
|
172 |
<null>0</null>
|
|
173 |
<type>float</type>
|
|
174 |
<value>$LONG DEGREES</value>
|
|
175 |
</_nullIf>
|
|
171 |
<_dms_to_dd>
|
|
172 |
<deg>$LONG DEGREES</deg>
|
|
173 |
<min>$LONG MINUTES</min>
|
|
174 |
<sec>$LONG SECONDS</sec>
|
|
175 |
</_dms_to_dd>
|
|
176 | 176 |
</longitude_deg> |
177 | 177 |
</coordinates> |
178 | 178 |
</coordinates_id> |
... | ... | |
184 | 184 |
<coordinates> |
185 | 185 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
186 | 186 |
<latitude_deg> |
187 |
<_nullIf>
|
|
188 |
<null>0</null>
|
|
189 |
<type>float</type>
|
|
190 |
<value>$LAT DEGREES</value>
|
|
191 |
</_nullIf>
|
|
187 |
<_dms_to_dd>
|
|
188 |
<deg>$LAT DEGREES</deg>
|
|
189 |
<min>$LAT MINUTES</min>
|
|
190 |
<sec>$LAT SECONDS</sec>
|
|
191 |
</_dms_to_dd>
|
|
192 | 192 |
</latitude_deg> |
193 | 193 |
<longitude_deg> |
194 |
<_nullIf>
|
|
195 |
<null>0</null>
|
|
196 |
<type>float</type>
|
|
197 |
<value>$LONG DEGREES</value>
|
|
198 |
</_nullIf>
|
|
194 |
<_dms_to_dd>
|
|
195 |
<deg>$LONG DEGREES</deg>
|
|
196 |
<min>$LONG MINUTES</min>
|
|
197 |
<sec>$LONG SECONDS</sec>
|
|
198 |
</_dms_to_dd>
|
|
199 | 199 |
</longitude_deg> |
200 | 200 |
</coordinates> |
201 | 201 |
</coordinates_id> |
inputs/TEX/Specimen/new_terms.csv | ||
---|---|---|
8 | 8 |
INFRA RANK,infraspecificRank,, |
9 | 9 |
INFRA NAME,infraspecificEpithet,, |
10 | 10 |
DETERMINED BY,identifiedBy,, |
11 |
LAT DEGREES,decimalLatitude,, |
|
12 |
LONG DEGREES,decimalLongitude,, |
|
11 |
LAT DEGREES,latitude_deg,, |
|
12 |
LAT MINUTES,latitude_min,, |
|
13 |
LAT SECONDS,latitude_sec,, |
|
14 |
LONG DEGREES,longitude_deg,, |
|
15 |
LONG MINUTES,longitude_min,, |
|
16 |
LONG SECONDS,longitude_sec,, |
|
13 | 17 |
LOCATION,locality,, |
14 | 18 |
ECOLOGICAL INFORMATION,habitat,, |
15 | 19 |
SPECIMEN NOTES,organismNotes,, |
inputs/TEX/Specimen/unmapped_terms.csv | ||
---|---|---|
1 | 1 |
infraspecificRank |
2 | 2 |
*INFRA AUTHORITY |
3 |
*LAT MINUTES |
|
4 |
*LAT SECONDS |
|
5 | 3 |
*LAT NS |
6 |
*LONG MINUTES |
|
7 |
*LONG SECONDS |
|
8 | 4 |
*LONG EW |
9 | 5 |
*SOURCE OF LATLONG |
10 | 6 |
*UTM |
Also available in: Unified diff
inputs/TEX/Specimen/map.csv: Remapped LAT/LONG_DEGREES,MINUTES,SECONDS to new latitude/longitude_deg,min,sec, allowing the DMS coordinates to be translated