Revision 7669
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/REMIB/Specimen/map.csv | ||
|---|---|---|
| 16 | 16 |
state,stateProvince,, |
| 17 | 17 |
county,county,, |
| 18 | 18 |
locality,locality,, |
| 19 |
long_deg,decimalLongitude,,
|
|
| 20 |
long_min,*long_min,,
|
|
| 21 |
long_sec,*long_sec,,
|
|
| 22 |
lat_deg,decimalLatitude,,
|
|
| 23 |
lat_min,*lat_min,,
|
|
| 24 |
lat_sec,*lat_sec,,
|
|
| 19 |
long_deg,longitude_deg,,
|
|
| 20 |
long_min,longitude_min,,
|
|
| 21 |
long_sec,longitude_sec,,
|
|
| 22 |
lat_deg,latitude_deg,,
|
|
| 23 |
lat_min,latitude_min,,
|
|
| 24 |
lat_sec,latitude_sec,,
|
|
| 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, |
| 85 | 85 |
habitat,"/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?" |
| 86 |
lat_deg,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 87 |
long_deg,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 86 |
lat_deg,/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/deg, |
|
| 87 |
lat_min,/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/min, |
|
| 88 |
lat_sec,/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/sec, |
|
| 89 |
long_deg,/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/deg, |
|
| 90 |
long_min,/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/min, |
|
| 91 |
long_sec,/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/sec, |
|
| 88 | 92 |
country,/location/locationplace/*_id/place/country, |
| 89 | 93 |
county,/location/locationplace/*_id/place/county, |
| 90 |
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/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
|
| 91 |
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/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
|
| 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", |
|
| 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", |
|
| 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", |
|
| 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", |
|
| 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", |
|
| 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", |
|
| 92 | 100 |
country,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2, |
| 93 | 101 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
| 94 | 102 |
state,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
| 95 | 103 |
state,/location/locationplace/*_id/place/stateprovince, |
| 96 |
lat_min,,** No join mapping for *lat_min ** |
|
| 97 |
lat_sec,,** No join mapping for *lat_sec ** |
|
| 98 |
long_min,,** No join mapping for *long_min ** |
|
| 99 |
long_sec,,** No join mapping for *long_sec ** |
|
| 100 | 104 |
preparation,,** No join mapping for preparations ** |
| inputs/REMIB/Specimen/test.xml.ref | ||
|---|---|---|
| 156 | 156 |
<coordinates_id> |
| 157 | 157 |
<coordinates> |
| 158 | 158 |
<latitude_deg> |
| 159 |
<_nullIf>
|
|
| 160 |
<null>0</null>
|
|
| 161 |
<type>float</type>
|
|
| 162 |
<value>$lat_deg</value>
|
|
| 163 |
</_nullIf>
|
|
| 159 |
<_dms_to_dd>
|
|
| 160 |
<deg>$lat_deg</deg>
|
|
| 161 |
<min>$lat_min</min>
|
|
| 162 |
<sec>$lat_sec</sec>
|
|
| 163 |
</_dms_to_dd>
|
|
| 164 | 164 |
</latitude_deg> |
| 165 | 165 |
<longitude_deg> |
| 166 |
<_nullIf>
|
|
| 167 |
<null>0</null>
|
|
| 168 |
<type>float</type>
|
|
| 169 |
<value>$long_deg</value>
|
|
| 170 |
</_nullIf>
|
|
| 166 |
<_dms_to_dd>
|
|
| 167 |
<deg>$long_deg</deg>
|
|
| 168 |
<min>$long_min</min>
|
|
| 169 |
<sec>$long_sec</sec>
|
|
| 170 |
</_dms_to_dd>
|
|
| 171 | 171 |
</longitude_deg> |
| 172 | 172 |
</coordinates> |
| 173 | 173 |
</coordinates_id> |
| ... | ... | |
| 180 | 180 |
<coordinates> |
| 181 | 181 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
| 182 | 182 |
<latitude_deg> |
| 183 |
<_nullIf>
|
|
| 184 |
<null>0</null>
|
|
| 185 |
<type>float</type>
|
|
| 186 |
<value>$lat_deg</value>
|
|
| 187 |
</_nullIf>
|
|
| 183 |
<_dms_to_dd>
|
|
| 184 |
<deg>$lat_deg</deg>
|
|
| 185 |
<min>$lat_min</min>
|
|
| 186 |
<sec>$lat_sec</sec>
|
|
| 187 |
</_dms_to_dd>
|
|
| 188 | 188 |
</latitude_deg> |
| 189 | 189 |
<longitude_deg> |
| 190 |
<_nullIf>
|
|
| 191 |
<null>0</null>
|
|
| 192 |
<type>float</type>
|
|
| 193 |
<value>$long_deg</value>
|
|
| 194 |
</_nullIf>
|
|
| 190 |
<_dms_to_dd>
|
|
| 191 |
<deg>$long_deg</deg>
|
|
| 192 |
<min>$long_min</min>
|
|
| 193 |
<sec>$long_sec</sec>
|
|
| 194 |
</_dms_to_dd>
|
|
| 195 | 195 |
</longitude_deg> |
| 196 | 196 |
</coordinates> |
| 197 | 197 |
</coordinates_id> |
| inputs/REMIB/Specimen/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
acronym,specimenHolders,, |
| 2 |
long_deg,decimalLongitude,, |
|
| 3 |
lat_deg,decimalLatitude,, |
|
| 2 |
long_deg,longitude_deg,, |
|
| 3 |
long_min,longitude_min,, |
|
| 4 |
long_sec,longitude_sec,, |
|
| 5 |
lat_deg,latitude_deg,, |
|
| 6 |
lat_min,latitude_min,, |
|
| 7 |
lat_sec,latitude_sec,, |
|
| 4 | 8 |
coll_day,dayCollected,, |
| 5 | 9 |
coll_month,monthCollected,, |
| 6 | 10 |
coll_year,yearCollected,, |
| inputs/REMIB/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 1 |
*long_min |
|
| 2 |
*long_sec |
|
| 3 |
*lat_min |
|
| 4 |
*lat_sec |
|
| 5 | 1 |
preparations |
Also available in: Unified diff
inputs/REMIB/Specimen/map.csv: Remapped lat/long_deg,min,sec to new latitude/longitude_deg,min,sec, allowing the DMS coordinates to be translated