Open-ILS/tests/datasets/sql/bibs_maps.sql

   1 \set bib_tag '''IMPORT MAPS'''
   2
   3 INSERT INTO marcxml_import (tag, marc) VALUES
   4
   5 (:bib_tag,'<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/MARC21/slim" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"><leader>03311cem a2200529 a 4500</leader><controlfield tag="001">13683783</controlfield><controlfield tag="005">20090125221700.0</controlfield><controlfield tag="007">aj canzn</controlfield><controlfield tag="008">040811s1989    cauae  bh b  s  0   eng</controlfield><datafield tag="906" ind1=" " ind2=" "><subfield code="a">7</subfield><subfield code="b">cbc</subfield><subfield code="c">origcop</subfield><subfield code="d">u</subfield><subfield code="e">ncip</subfield><subfield code="f">20</subfield><subfield code="g">n-geogmaps</subfield></datafield><datafield tag="955" ind1=" " ind2=" "><subfield code="a">ga09 2004-08-16 sent to CMT</subfield></datafield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2004631763</subfield></datafield><datafield tag="034" ind1="1" ind2=" "><subfield code="a">a</subfield><subfield code="b">250000</subfield><subfield code="d">W1260000</subfield><subfield code="e">W1240000</subfield><subfield code="f">N0420000</subfield><subfield code="g">N0400000</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DLC</subfield><subfield code="c">DLC</subfield></datafield><datafield tag="050" ind1="0" ind2="0"><subfield code="a">G4362.C6C5 s250</subfield><subfield code="b">.C37</subfield></datafield><datafield tag="052" ind1=" " ind2=" "><subfield code="a">4362</subfield><subfield code="b">C6</subfield></datafield><datafield tag="110" ind1="1" ind2=" "><subfield code="a">California.</subfield><subfield code="b">Division of Mines and Geology.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Geology of the northern California continental margin /</subfield><subfield code="c">H. Gary Greene and Michael P. Kennedy, editors ; [graphics by Ross Martin].</subfield></datafield><datafield tag="255" ind1=" " ind2=" "><subfield code="a">Scale 1:250,000 ;</subfield><subfield code="b">transverse Mercator proj.</subfield><subfield code="c"/></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">[Sacramento, Calif.] :</subfield><subfield code="b">State of California, Resources Agency, Dept. of Conservation ;</subfield><subfield code="a">[Reston, Va.] :</subfield><subfield code="b">United States Geological Survey,</subfield><subfield code="c">1989.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">4 maps :</subfield><subfield code="b">col. ;</subfield><subfield code="c">each 91 x 69 cm., on sheets 116 x 99 cm. or smaller, folded in envelope 31 x 26 cm.</subfield></datafield><datafield tag="440" ind1=" " ind2="0"><subfield code="a">California continental margin geologic map series ;</subfield><subfield code="v">map no. 7A-7D</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Depths shown by contours and soundings.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Title from envelope cover.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">"Northern California continental margin--Area 7 of 7"--Envelope cover.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Maps attributed to various authors, compilers, and contributors.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">The California continental margin geologic map series was developed cooperatively by the State of California Dept. of Conservation, Division of Mines and Geology, and the United States Geological Survey.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Some sheets include chart of geophysical tracklines and data sources.</subfield></datafield><datafield tag="504" ind1=" " ind2=" "><subfield code="a">Bibliography.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes geologic explanation and location diagram.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Map no. 7A. Geologic map of the northern California continental margin -- Map no. 7B. Earthquake epicenters and selected fault plane solutions of the northern California continental margin -- Map no. 7C. Bouguer gravity and magnetic anomaly map of the northern California continental margin -- Map no. 7D. Well location, geophysical trackline, and data source map of the northern California continental margin.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Geology</subfield><subfield code="z">California</subfield><subfield code="z">Pacific Coast Region</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Faults (Geology)</subfield><subfield code="z">California</subfield><subfield code="z">Pacific Coast Region</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Gravity anomalies</subfield><subfield code="z">California</subfield><subfield code="z">Pacific Coast Region</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Continental shelf</subfield><subfield code="z">California</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Coasts</subfield><subfield code="z">California</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Submerged lands</subfield><subfield code="z">California</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Greene, H. G.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Kennedy, Michael P.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Martin, Ross,</subfield><subfield code="c">cartographer.</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Geological Survey (U.S.)</subfield></datafield><datafield tag="740" ind1="0" ind2="2"><subfield code="a">Geologic map of the northern California continental margin.</subfield></datafield><datafield tag="740" ind1="0" ind2="2"><subfield code="a">Earthquake epicenters and selected fault plane solutions of the northern California continental margin.</subfield></datafield><datafield tag="740" ind1="0" ind2="2"><subfield code="a">Bouguer gravity and magnetic anomaly map of the northern California continental margin.</subfield></datafield><datafield tag="740" ind1="0" ind2="2"><subfield code="a">Well location, geophysical trackline, and data source map of the northern California continental margin.</subfield></datafield><datafield tag="901" ind1=" " ind2=" "><subfield code="a">13683783</subfield><subfield code="b">System Local</subfield><subfield code="c">1</subfield></datafield><datafield tag="852" ind1="4" ind2=" "><subfield code="a">gaaagpl</subfield><subfield code="b">BR1</subfield><subfield code="b">BR1</subfield><subfield code="c">Stacks</subfield><subfield code="j">G4362.C6C5 s250.C37</subfield><subfield code="p">11223344</subfield><subfield code="y">0.00</subfield><subfield code="x">nonreference</subfield><subfield code="x">holdable</subfield><subfield code="x">circulating</subfield><subfield code="x">visible</subfield><subfield code="z">Available</subfield></datafield></record>'),
   6 (:bib_tag,'<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/MARC21/slim" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"><leader>01918cem a22003854a 4500</leader><controlfield tag="001">14933689</controlfield><controlfield tag="005">20090127030616.0</controlfield><controlfield tag="007">aj canzn</controlfield><controlfield tag="008">070719s2007    vauabg cp a  f  0   eng</controlfield><datafield tag="906" ind1=" " ind2=" "><subfield code="a">7</subfield><subfield code="b">cbc</subfield><subfield code="c">origcop</subfield><subfield code="d">u</subfield><subfield code="e">ncip</subfield><subfield code="f">20</subfield><subfield code="g">y-geogmaps</subfield></datafield><datafield tag="955" ind1=" " ind2=" "><subfield code="a">ga09 2007-07-19 sent to CMT</subfield></datafield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2007631309</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1411318013</subfield></datafield><datafield tag="034" ind1="1" ind2=" "><subfield code="a">a</subfield><subfield code="b">24000</subfield><subfield code="d">W1194500</subfield><subfield code="e">W1192910</subfield><subfield code="f">N0374705</subfield><subfield code="g">N0374200</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DLC</subfield><subfield code="c">DLC</subfield></datafield><datafield tag="050" ind1="0" ind2="0"><subfield code="a">G4362.Y62 2007</subfield><subfield code="b">.G4</subfield></datafield><datafield tag="052" ind1=" " ind2=" "><subfield code="a">4362</subfield><subfield code="b">Y62</subfield><subfield code="b">Y6</subfield></datafield><datafield tag="110" ind1="2" ind2=" "><subfield code="a">Geological Survey (U.S.)</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Map of Yosemite Valley, Yosemite National Park and Wilderness, California, Mariposa County /</subfield><subfield code="c">United States, Department of the Interior, Geological Survey.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Shaded relief ed., limited revision 1970.</subfield></datafield><datafield tag="255" ind1=" " ind2=" "><subfield code="a">Scale 1:24,000 ;</subfield><subfield code="b">polyconic proj.</subfield><subfield code="c"/></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Reston, Va. :</subfield><subfield code="b">Geological Survey,</subfield><subfield code="c">2007.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 map :</subfield><subfield code="b">col. ;</subfield><subfield code="c">40 x 97 cm.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Relief shown by contours, shading, and spot heights.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">"Interior--Geological Survey ... 1995."</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">On verso: The geologic story of Yosemite Valley / by N. king Huber, in the footsteps of Fran&#xA9;&#x2B9;ois E. Matthes. 2007.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes descriptive list of "Elevations of principal points" and location map.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Map of California showing location of Yosemite National Park and ill. (some col.) on verso.</subfield></datafield><datafield tag="651" ind1=" " ind2="0"><subfield code="a">Yosemite Valley (Calif.)</subfield><subfield code="v">Maps, Topographic.</subfield></datafield><datafield tag="651" ind1=" " ind2="0"><subfield code="a">Yosemite National Park (Calif.)</subfield><subfield code="v">Maps, Topographic.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Geology</subfield><subfield code="z">California</subfield><subfield code="z">Yosemite Valley</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="700" ind1="1" ind2="2"><subfield code="a">Huber, N. King</subfield><subfield code="q">(Norman King),</subfield><subfield code="d">1926-</subfield><subfield code="t">Geologic story of Yosemite Valley.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Matthes, Fran&#xA9;&#x2B9;ois,</subfield><subfield code="d">1874-1948.</subfield></datafield><datafield tag="901" ind1=" " ind2=" "><subfield code="a">14933689</subfield><subfield code="b">System Local</subfield><subfield code="c">3</subfield></datafield><datafield tag="852" ind1="4" ind2=" "><subfield code="a">gaaagpl</subfield><subfield code="b">BR1</subfield><subfield code="b">BR1</subfield><subfield code="c">Stacks</subfield><subfield code="j">G4362.Y62 2007.G4</subfield><subfield code="p">1090109</subfield><subfield code="y">0.00</subfield><subfield code="x">nonreference</subfield><subfield code="x">holdable</subfield><subfield code="x">circulating</subfield><subfield code="x">visible</subfield><subfield code="z">In process</subfield></datafield></record>'),
   7 (:bib_tag,'<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/MARC21/slim" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"><leader>03375cem a2200529 a 4500</leader><controlfield tag="001">13683740</controlfield><controlfield tag="005">20090126032558.0</controlfield><controlfield tag="007">aj canzn</controlfield><controlfield tag="008">040811s1987    cauae  bh b  s  0   eng</controlfield><datafield tag="906" ind1=" " ind2=" "><subfield code="a">7</subfield><subfield code="b">cbc</subfield><subfield code="c">origcop</subfield><subfield code="d">u</subfield><subfield code="e">ncip</subfield><subfield code="f">20</subfield><subfield code="g">n-geogmaps</subfield></datafield><datafield tag="955" ind1=" " ind2=" "><subfield code="a">ga09 2004-08-16 sent to CMT</subfield></datafield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2004631762</subfield></datafield><datafield tag="034" ind1="1" ind2=" "><subfield code="a">a</subfield><subfield code="b">250000</subfield><subfield code="d">W1220000</subfield><subfield code="e">W1180000</subfield><subfield code="f">N0340000</subfield><subfield code="g">N0320000</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DLC</subfield><subfield code="c">DLC</subfield></datafield><datafield tag="050" ind1="0" ind2="0"><subfield code="a">G4362.C6C5 s250</subfield><subfield code="b">.C33</subfield></datafield><datafield tag="052" ind1=" " ind2=" "><subfield code="a">4362</subfield><subfield code="b">C6</subfield></datafield><datafield tag="110" ind1="1" ind2=" "><subfield code="a">California.</subfield><subfield code="b">Division of Mines and Geology.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Geology of the outer-southern California continental margin /</subfield><subfield code="c">H. Gary Greene and Michael P. Kennedy, editors ; [graphics by James Dennis Williams].</subfield></datafield><datafield tag="255" ind1=" " ind2=" "><subfield code="a">Scale 1:250,000 ;</subfield><subfield code="b">transverse Mercator proj.</subfield><subfield code="c"/></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">[Sacramento, Calif.] :</subfield><subfield code="b">State of California, Resources Agency, Dept. of Conservation ;</subfield><subfield code="a">[Reston, Va.] :</subfield><subfield code="b">United States Geological Survey,</subfield><subfield code="c">1987.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">4 maps :</subfield><subfield code="b">col. ;</subfield><subfield code="c">each 91 x 78 cm., on sheets 140 x 85 cm. or smaller, folded in envelope 31 x 26 cm.</subfield></datafield><datafield tag="440" ind1=" " ind2="0"><subfield code="a">California continental margin geologic map series ;</subfield><subfield code="v">map no. 3A-3D</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Depths shown by contours and soundings.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Title from envelope cover.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">"Outer-southern California continental margin--Area 3 of 7"--Envelope cover.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Maps attributed to various authors, compilers, and contributors.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">The California continental margin geologic map series was developed cooperatively by the State of California Dept. of Conservation, Division of Mines and Geology, and the United States Geological Survey.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Some sheets include chart of geophysical tracklines and data sources.</subfield></datafield><datafield tag="504" ind1=" " ind2=" "><subfield code="a">Bibliography.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes geologic explanation and location diagram.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Map no. 3A. Geologic map of the outer-southern California continental margin -- Map no. 3B. Earthquake epicenters and selected fault plane solutions of the outer-southern California continental margin -- Map no. 3C. Bouguer gravity and magnetic anomaly map of the outer-southern California continental margin -- Map no. 3D. Well location, geophysical trackline, and data source map of the outer-southern California continental margin.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Geology</subfield><subfield code="z">California</subfield><subfield code="z">Pacific Coast Region</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Faults (Geology)</subfield><subfield code="z">California</subfield><subfield code="z">Pacific Coast Region</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Gravity anomalies</subfield><subfield code="z">California</subfield><subfield code="z">Pacific Coast Region</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Continental shelf</subfield><subfield code="z">California</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Coasts</subfield><subfield code="z">California</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Submerged lands</subfield><subfield code="z">California</subfield><subfield code="v">Maps.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Greene, H. G.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Kennedy, Michael P.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Williams, James Dennis.</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Geological Survey (U.S.)</subfield></datafield><datafield tag="740" ind1="0" ind2="2"><subfield code="a">Geologic map of the outer-southern California continental margin.</subfield></datafield><datafield tag="740" ind1="0" ind2="2"><subfield code="a">Earthquake epicenters and selected fault plane solutions of the outer-southern California continental margin.</subfield></datafield><datafield tag="740" ind1="0" ind2="2"><subfield code="a">Bouguer gravity and magnetic anomaly map of the outer-southern California continental margin.</subfield></datafield><datafield tag="740" ind1="0" ind2="2"><subfield code="a">Well location, geophysical trackline, and data source map of the outer-southern California continental margin.</subfield></datafield><datafield tag="901" ind1=" " ind2=" "><subfield code="a">13683740</subfield><subfield code="b">System Local</subfield><subfield code="c">2</subfield></datafield><datafield tag="852" ind1="4" ind2=" "><subfield code="a">gaaagpl</subfield><subfield code="b">BR1</subfield><subfield code="b">BR1</subfield><subfield code="c">Stacks</subfield><subfield code="j">G4362.C6C5 s250.C33</subfield><subfield code="p">2233444</subfield><subfield code="y">0.00</subfield><subfield code="x">nonreference</subfield><subfield code="x">holdable</subfield><subfield code="x">circulating</subfield><subfield code="x">visible</subfield><subfield code="z">Available</subfield></datafield></record>')
   8 ;