Revision 7670
Added by Aaron Marcuse-Kubitza over 11 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