Revision 12029
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/inputs/.geoscrub/county_centroids/VegBIEN.csv | ||
|---|---|---|
| 1 |
link ../../../mappings/VegCore-VegBIEN.csv |
|
| 0 | 2 | |
| trunk/inputs/.geoscrub/county_centroids/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>geoscrub.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationplace> |
|
| 11 |
<place_id> |
|
| 12 |
<place> |
|
| 13 |
<coordinates_id> |
|
| 14 |
<coordinates> |
|
| 15 |
<latitude_deg> |
|
| 16 |
<_nullIf> |
|
| 17 |
<null>0</null> |
|
| 18 |
<type>float</type> |
|
| 19 |
<value>$decimalLatitude</value> |
|
| 20 |
</_nullIf> |
|
| 21 |
</latitude_deg> |
|
| 22 |
<longitude_deg> |
|
| 23 |
<_nullIf> |
|
| 24 |
<null>0</null> |
|
| 25 |
<type>float</type> |
|
| 26 |
<value>$decimalLongitude</value> |
|
| 27 |
</_nullIf> |
|
| 28 |
</longitude_deg> |
|
| 29 |
</coordinates> |
|
| 30 |
</coordinates_id> |
|
| 31 |
<county>$county</county> |
|
| 32 |
<matched_place_id> |
|
| 33 |
<place> |
|
| 34 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
|
| 35 |
<coordinates_id> |
|
| 36 |
<coordinates> |
|
| 37 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
|
| 38 |
<latitude_deg> |
|
| 39 |
<_nullIf> |
|
| 40 |
<null>0</null> |
|
| 41 |
<type>float</type> |
|
| 42 |
<value>$decimalLatitude</value> |
|
| 43 |
</_nullIf> |
|
| 44 |
</latitude_deg> |
|
| 45 |
<longitude_deg> |
|
| 46 |
<_nullIf> |
|
| 47 |
<null>0</null> |
|
| 48 |
<type>float</type> |
|
| 49 |
<value>$decimalLongitude</value> |
|
| 50 |
</_nullIf> |
|
| 51 |
</longitude_deg> |
|
| 52 |
</coordinates> |
|
| 53 |
</coordinates_id> |
|
| 54 |
<county>$county</county> |
|
| 55 |
<stateprovince>$stateProvince</stateprovince> |
|
| 56 |
</place> |
|
| 57 |
</matched_place_id> |
|
| 58 |
<stateprovince>$stateProvince</stateprovince> |
|
| 59 |
</place> |
|
| 60 |
</place_id> |
|
| 61 |
</locationplace> |
|
| 62 |
</location> |
|
| 63 |
</path> |
|
| 64 |
</_simplifyPath> |
|
| 65 |
</path> |
|
| 66 |
</_setDefault> |
|
| 67 |
</VegBIEN> |
|
| 68 |
Inserted 10 new rows into database |
|
| trunk/inputs/.NCBI/names.src/VegBIEN.csv | ||
|---|---|---|
| 1 |
link ../../../mappings/VegCore-VegBIEN.csv |
|
| 0 | 2 | |
| trunk/inputs/.NCBI/names.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>NCBI.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationevent> |
|
| 11 |
<locationevent fkey="parent_id"> |
|
| 12 |
<taxonoccurrence> |
|
| 13 |
<taxondetermination> |
|
| 14 |
<taxonverbatim_id> |
|
| 15 |
<taxonverbatim> |
|
| 16 |
<taxonlabel_id> |
|
| 17 |
<taxonlabel> |
|
| 18 |
<sourceaccessioncode>$taxonID</sourceaccessioncode> |
|
| 19 |
<taxonomicname>$taxonNameOrEpithet</taxonomicname> |
|
| 20 |
</taxonlabel> |
|
| 21 |
</taxonlabel_id> |
|
| 22 |
</taxonverbatim> |
|
| 23 |
</taxonverbatim_id> |
|
| 24 |
</taxondetermination> |
|
| 25 |
</taxonoccurrence> |
|
| 26 |
</locationevent> |
|
| 27 |
</locationevent> |
|
| 28 |
</location> |
|
| 29 |
</path> |
|
| 30 |
</_simplifyPath> |
|
| 31 |
</path> |
|
| 32 |
</_setDefault> |
|
| 33 |
</VegBIEN> |
|
| 34 |
Inserted 3 new rows into database |
|
| trunk/inputs/.NCBI/nodes.src/VegBIEN.csv | ||
|---|---|---|
| 1 |
link ../../../mappings/VegCore-VegBIEN.csv |
|
| 0 | 2 | |
| trunk/inputs/.NCBI/nodes.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>NCBI.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationevent> |
|
| 11 |
<locationevent fkey="parent_id"> |
|
| 12 |
<taxonoccurrence> |
|
| 13 |
<taxondetermination> |
|
| 14 |
<taxonverbatim_id> |
|
| 15 |
<taxonverbatim> |
|
| 16 |
<taxonlabel_id> |
|
| 17 |
<taxonlabel> |
|
| 18 |
<_taxonlabel_set_parent_id><parent_id><taxonlabel><sourceaccessioncode>$parentTaxonID</sourceaccessioncode></taxonlabel></parent_id></_taxonlabel_set_parent_id> |
|
| 19 |
<rank>$taxonRank</rank> |
|
| 20 |
<sourceaccessioncode>$taxonID</sourceaccessioncode> |
|
| 21 |
</taxonlabel> |
|
| 22 |
</taxonlabel_id> |
|
| 23 |
<verbatimrank>$taxonRank</verbatimrank> |
|
| 24 |
</taxonverbatim> |
|
| 25 |
</taxonverbatim_id> |
|
| 26 |
</taxondetermination> |
|
| 27 |
</taxonoccurrence> |
|
| 28 |
</locationevent> |
|
| 29 |
</locationevent> |
|
| 30 |
</location> |
|
| 31 |
</path> |
|
| 32 |
</_simplifyPath> |
|
| 33 |
</path> |
|
| 34 |
</_setDefault> |
|
| 35 |
</VegBIEN> |
|
| 36 |
Inserted 6 new rows into database |
|
Also available in: Unified diff
inputs/.geoscrub/county_centroids/test.xml.ref, inputs/.NCBI/{names.src,nodes.src}/test.xml.ref: accepted test outputs (generated now that these tables are in import_order.txt)