Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by clamav X-Spam-Status: No, hits=-2.312 required=5 tests=BAYES_00 autolearn=no X-Scanned-By: Digested by UGA Mail Gateway on 128.192.1.75 X-Scanned-By: MIMEDefang 2.53 on 129.89.7.40 -------- Original Message -------- Subject: RE: MAPS-L: First steps to coordinates in LC authority records (fwd) (2) Date: Thu, 2 Feb 2006 10:47:44 -0800 From: Charles E Robinson <[log in to unmask]> To: Maps, Air Photo & Geospatial Systems Forum <[log in to unmask]> Colleen, Here is a Microsoft help file with the Visual Basic programming in Excel to do the formula conversions. http://support.microsoft.com/?kbid=213449 Chuck Robinson Map & Document Technician University of Nevada Reno DeLaMare Library/MS 262 1664 N. Virginia Street Reno, NV 89557-0044 Ph. (775)784-6945, Ext. 228 Fax (775)784-6949 [log in to unmask] -----Original Message----- From: Maps, Air Photo & Geospatial Systems Forum [mailto:[log in to unmask]] On Behalf Of Angie Cope, AGSL Sent: Thursday, February 02, 2006 10:15 AM To: [log in to unmask] Subject: MAPS-L: First steps to coordinates in LC authority records (fwd) -------- Original Message -------- Subject: First steps to coordinates in LC authority records (fwd) Date: Thu, 2 Feb 2006 09:06:34 -0500 (EST) From: Colleen Cahill <[log in to unmask]> To: Maps, Air Photo & Geospatial Systems Forum <[log in to unmask]> This has also been posted at [log in to unmask] ____________________________________ At the mid-Winter ALA in San Antonio, MARBI (Machine-Readable Bibliographic Information) Committee agreed to moving forward on Discussion Paper No. 2006-DP01: Recording geographic coordinates in the MARC 21 Authority Format <http://www.loc.gov/marc/marbi/2006/2006-dp01.html>. This discussion paper was brought forward through the work of Jimmie Lundgren, Science and Social Science Cataloging Unit Head, George A. Smathers Libraries, University of Florida and Rebecca Gunther, Senior Networking and Standards Specialist, Network Development and MARC Standards Office, Library of Congress, with the encouragement of many, many people. My personal thanks to all who helped with this success! The next step will be to form a purposal, which Rebecca Guenther will be working on in the future. While this is going on, there will be opportunities for us to begin gathering data and coordinate tools to manipulate this data. One piece I am looking for is a program that will batch convert decimal coordinates to format of degrees, minutes, seconds used in the MARC standard 034 for bibligraphic records and also from the 034 format to decimal degrees. I have a Excel file of over 3000 records I can start testing with: this would be the modern bounding box coordinates for the counties in the United States. If anyone knows of such a program, please let me know. Colleen Colleen R. Cahill | [log in to unmask] Digital Production Coordinator | (202)707-8540 & Recommending Officer for | FAX (202)707-8531 Science Fiction & Fantasy | Library of Congress These opinions are mine, Mine, Mine! | Washington, DC 20540-4652