OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Data for playing with- Announcement

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
MSPhobe
Super User
Super User


Joined: 29 Sep 2005
Posts: 529
Location: England

PostPosted: Wed Jun 17, 2009 11:57 pm    Post subject: Data for playing with- Announcement Reply with quote

Someone else was asking in this forum about accessing some Access data. The issues around that are being dealt with in the "USDA" thread.

I thought others might find the following interesting, as data to play with... or because they actually want access, via ooBase, to some data which will be useful in some circumstances.

The US Department of Agriculture has put some data online. It seems to be about that is in different foodstuffs.

If you go to http://www.ars.usda.gov/Services/docs.htm?docid=17478

... you will find links to download....

Quote:


ASCII (6.0Mb) - This file contains the SR21 data in ASCII, delimited files. These tables are organized in a relational format, and are best used with a relational database management system (RDBMS), which will allow you to form your own queries of the database and generate custom reports.

ACCESS (16.5Mb) - This file contains the SR21 data imported into a Micrsoft Access database. It includes relationships between files and a few sample queries and reports. You need Micrsoft Access 2000 or later to use this file.

Abbreviated - The following files contain data for all food items, but not all nutrient values--individual fatty acids, amino acids, alcohol, caffeine, theobromine, phytosterols, starch, individual sugars and vitamin D are not included.

ASCII (0.7Mb) - delimited file suitable for importing into many programs.

Excel (1.6Mb) - for use with Micrsoft Excel, but can also be used by many other spreadsheet programs.


What they call "delimited files" I call CSV files, and they are easy to import into ooBase tables. (See http://sheepdogguides.com/fdb/fdb1imp1.htm)

If that's too hard, then you can get the abbreviated data into an ooBase database by loading the cut down version from the Excel files into ooCalc, and move the data from there into ooBase simply enough.

Maybe some kind person will do the conversion work and republish the data somehwere that others can fetch it? I would, but I don't think my ISP would be very pleased with me if I started serving up a 6MB file too often. Sigh. If you would put the result on your website, I would consider trying to move the data to ooBase. (Answers on THAT to me as a private message, please. No point in cluttering the forum with stuff not of general interest.)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group