Home | Search Database | Data Files | Animations | Educational Resources | Glossary | FAQ
Login
Get Account

Being logged in allows you to access advanced search features such as saved queries and saved diagrams. Membership is free. Please login or get a new account

Output Data outputdata

5007 samples found

Create an HTML Table, Excel File, or Tab-delimited Text File for viewing data createtable

Please select from the following list of options on how you would like the data presented.

Text File is tab-delimited and can be downloaded and opened in a spreadsheet application.
Advanced Excel Output and Advanced Text Output allow you to specify which fields to show.

All data files include Sample ID, References, Age, and Location.

With >2000 samples, the file may take several minutes to appear.

Major Element 4573 samples
Trace Element 4029 samples
Isotopes 427 samples 		Major, Trace Elements 3821 samples
Major, Trace, Isotopes 174 samples
All Data 5007 samples

HTML Table  Excel File  Text File  Advanced Excel Output  Advanced Text Output





References
First 10 References:
 #    AUTHOR(S)    YEAR    JOURNAL    TITLE  
1  No Author Data.    1989    Geological Map Series (Portlan...    Geology and mineral resources map of the Grassy Mo...   
2  Hooper-P-R...    1985    Contributions to Mineralogy an...    A case of simple magma mixing in the Columbia Rive...   
3  Boroughs, Scott; Wolff, John; ...    2005    Geology Boulder, vol.33, no.10...    Large-volume, low-delta super 18 O rhyolites of th...   
4  No Author Data.    1992    Geological Map Series (Portlan...    Geology and mineral resources map of the Westfall ...   
5  Uppuluri-Venkata-Rao...    1974    Geological Society of America ...    Prineville Chemical Type: A New Basalt Type in the...   
6  No Author Data.    1978    n/a    Geology of the Blue River mining district, Linn an...   
7  Smith-Diane-R; Leeman-William-...    1993    Journal of Volcanology and Geo...    The origin of Mount St. Helens andesites....   
8  Goles-G-G...    1986    Journal of Petrology. 27; 2, P...    Miocene basalts of the Blue Mountains Province in ...   
9  Reiners-Peter-W; Hammond-Paul-...    2000    Contributions to Mineralogy an...    Young basalts of the central Washington Cascades, ...   
10  No Author Data.    1979    n/a    Geology and mineralization of the North Santiam mi...   

Download all references for this search.



Maps

Display all results on a dynamic map.


Display results on a simple static map suitable for downloading.




Plots














select sum(major_data_count) as smdc, sum(samp_trace_data_count) as stdc, sum(samp_isotope_data_count) as sidc, sum(samp_majtrace_data_count) as ssmtd, sum(samp_majtriso_data_count) as ssmdc, sum(samp_total_data_count) as total FROM (SELECT (case when samp.major_data = 'y' then 1 else 0 end) as major_data_count, (case when samp.trace_data = 'y' then 1 else 0 end) as samp_trace_data_count, (case when samp.isotope_data = 'y' then 1 else 0 end) as samp_isotope_data_count, (CASE when samp.major_data='y' and samp.trace_data='y' then 1 else 0 end) as samp_majtrace_data_count, (CASE when samp.major_data='y' and samp.trace_data='y' and samp.isotope_data='y' then 1 else 0 end) as samp_majtriso_data_count, (CASE WHEN samp.sample_num > 0 then 1 else 0 end) as samp_total_data_count FROM view_data_output norm, sample samp, location loc, sample_age age, batch bat, reference ref, method meth WHERE (norm.ec_level_2 = 'VOLCANIC') AND ST_Contains(st_GeomFromText('Polygon((-123.486328125 47.398349200359256,-115.751953125 47.69497434186282,-115.6640625 43.13306116240612,-122.783203125 43.70759350405294,-123.486328125 47.398349200359256))'),loc.mypoint) AND age.sample_num = samp.sample_num AND (age.calculated_age >= 0 AND age.calculated_age <= 16) AND norm.sample_num = samp.sample_num AND age.sample_num = samp.sample_num AND loc.location_num = samp.location_num AND bat.sample_num = samp.sample_num AND ref.ref_num = bat.ref_num AND meth.method_num = age.method_num ) b
go to earthchem NAVDAT Home