Revision 7718
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/REMIB/Specimen/map.csv | ||
|---|---|---|
| 16 | 16 |
state,stateProvince,, |
| 17 | 17 |
county,county,, |
| 18 | 18 |
locality,locality,, |
| 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,, |
|
| 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, |
| 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/_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,
|
|
| 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, |
| 93 | 93 |
county,/location/locationplace/*_id/place/county, |
| 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", |
|
| 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, |
| 101 | 101 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
| 102 | 102 |
state,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
| inputs/REMIB/Specimen/test.xml.ref | ||
|---|---|---|
| 157 | 157 |
<coordinates> |
| 158 | 158 |
<latitude_deg> |
| 159 | 159 |
<_dms_to_dd> |
| 160 |
<deg>$lat_deg</deg> |
|
| 161 |
<min>$lat_min</min> |
|
| 162 |
<sec>$lat_sec</sec> |
|
| 160 |
<deg> |
|
| 161 |
<_map> |
|
| 162 |
<-999></-999> |
|
| 163 |
<-99></-99> |
|
| 164 |
<99></99> |
|
| 165 |
<999></999> |
|
| 166 |
<1000></1000> |
|
| 167 |
<value>$lat_deg</value> |
|
| 168 |
</_map> |
|
| 169 |
</deg> |
|
| 170 |
<min> |
|
| 171 |
<_map> |
|
| 172 |
<-999></-999> |
|
| 173 |
<-99></-99> |
|
| 174 |
<99></99> |
|
| 175 |
<999></999> |
|
| 176 |
<1000></1000> |
|
| 177 |
<value>$lat_min</value> |
|
| 178 |
</_map> |
|
| 179 |
</min> |
|
| 180 |
<sec> |
|
| 181 |
<_map> |
|
| 182 |
<-999></-999> |
|
| 183 |
<-99></-99> |
|
| 184 |
<99></99> |
|
| 185 |
<999></999> |
|
| 186 |
<1000></1000> |
|
| 187 |
<value>$lat_sec</value> |
|
| 188 |
</_map> |
|
| 189 |
</sec> |
|
| 163 | 190 |
</_dms_to_dd> |
| 164 | 191 |
</latitude_deg> |
| 165 | 192 |
<longitude_deg> |
| 166 | 193 |
<_dms_to_dd> |
| 167 |
<deg>$long_deg</deg> |
|
| 168 |
<min>$long_min</min> |
|
| 169 |
<sec>$long_sec</sec> |
|
| 194 |
<deg> |
|
| 195 |
<_map> |
|
| 196 |
<-999></-999> |
|
| 197 |
<99></99> |
|
| 198 |
<999></999> |
|
| 199 |
<1000></1000> |
|
| 200 |
<value>$long_deg</value> |
|
| 201 |
</_map> |
|
| 202 |
</deg> |
|
| 203 |
<min> |
|
| 204 |
<_map> |
|
| 205 |
<-999></-999> |
|
| 206 |
<-99></-99> |
|
| 207 |
<99></99> |
|
| 208 |
<999></999> |
|
| 209 |
<1000></1000> |
|
| 210 |
<value>$long_min</value> |
|
| 211 |
</_map> |
|
| 212 |
</min> |
|
| 213 |
<sec> |
|
| 214 |
<_map> |
|
| 215 |
<-999></-999> |
|
| 216 |
<-99></-99> |
|
| 217 |
<99></99> |
|
| 218 |
<999></999> |
|
| 219 |
<1000></1000> |
|
| 220 |
<value>$long_sec</value> |
|
| 221 |
</_map> |
|
| 222 |
</sec> |
|
| 170 | 223 |
</_dms_to_dd> |
| 171 | 224 |
</longitude_deg> |
| 172 | 225 |
</coordinates> |
| ... | ... | |
| 181 | 234 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
| 182 | 235 |
<latitude_deg> |
| 183 | 236 |
<_dms_to_dd> |
| 184 |
<deg>$lat_deg</deg> |
|
| 185 |
<min>$lat_min</min> |
|
| 186 |
<sec>$lat_sec</sec> |
|
| 237 |
<deg> |
|
| 238 |
<_map> |
|
| 239 |
<-999></-999> |
|
| 240 |
<-99></-99> |
|
| 241 |
<99></99> |
|
| 242 |
<999></999> |
|
| 243 |
<1000></1000> |
|
| 244 |
<value>$lat_deg</value> |
|
| 245 |
</_map> |
|
| 246 |
</deg> |
|
| 247 |
<min> |
|
| 248 |
<_map> |
|
| 249 |
<-999></-999> |
|
| 250 |
<-99></-99> |
|
| 251 |
<99></99> |
|
| 252 |
<999></999> |
|
| 253 |
<1000></1000> |
|
| 254 |
<value>$lat_min</value> |
|
| 255 |
</_map> |
|
| 256 |
</min> |
|
| 257 |
<sec> |
|
| 258 |
<_map> |
|
| 259 |
<-999></-999> |
|
| 260 |
<-99></-99> |
|
| 261 |
<99></99> |
|
| 262 |
<999></999> |
|
| 263 |
<1000></1000> |
|
| 264 |
<value>$lat_sec</value> |
|
| 265 |
</_map> |
|
| 266 |
</sec> |
|
| 187 | 267 |
</_dms_to_dd> |
| 188 | 268 |
</latitude_deg> |
| 189 | 269 |
<longitude_deg> |
| 190 | 270 |
<_dms_to_dd> |
| 191 |
<deg>$long_deg</deg> |
|
| 192 |
<min>$long_min</min> |
|
| 193 |
<sec>$long_sec</sec> |
|
| 271 |
<deg> |
|
| 272 |
<_map> |
|
| 273 |
<-999></-999> |
|
| 274 |
<99></99> |
|
| 275 |
<999></999> |
|
| 276 |
<1000></1000> |
|
| 277 |
<value>$long_deg</value> |
|
| 278 |
</_map> |
|
| 279 |
</deg> |
|
| 280 |
<min> |
|
| 281 |
<_map> |
|
| 282 |
<-999></-999> |
|
| 283 |
<-99></-99> |
|
| 284 |
<99></99> |
|
| 285 |
<999></999> |
|
| 286 |
<1000></1000> |
|
| 287 |
<value>$long_min</value> |
|
| 288 |
</_map> |
|
| 289 |
</min> |
|
| 290 |
<sec> |
|
| 291 |
<_map> |
|
| 292 |
<-999></-999> |
|
| 293 |
<-99></-99> |
|
| 294 |
<99></99> |
|
| 295 |
<999></999> |
|
| 296 |
<1000></1000> |
|
| 297 |
<value>$long_sec</value> |
|
| 298 |
</_map> |
|
| 299 |
</sec> |
|
| 194 | 300 |
</_dms_to_dd> |
| 195 | 301 |
</longitude_deg> |
| 196 | 302 |
</coordinates> |
| ... | ... | |
| 210 | 316 |
</path> |
| 211 | 317 |
</_setDefault> |
| 212 | 318 |
</VegBIEN> |
| 213 |
Inserted 31 new rows into database |
|
| 319 |
Inserted 29 new rows into database |
|
| inputs/REMIB/Specimen/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
acronym,specimenHolders,, |
| 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,, |
|
| 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
inputs/REMIB/Specimen/map.csv: Map NULL-equivalent lat/long to NULL