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

12 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.

Major Element 5 samples
Trace Element 3 samples
Isotopes 2 samples
Major, Trace Elements 3 samples
Major, Trace, Isotopes 2 samples
All Data 12 samples

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

First 10 References:
Reheis, M C; Sawyer, T L; Slat...    1993    Miscellaneous Investigations S...    Geologic map of late Cenozoic deposits and faults ...   
Macdonald, Ray; Smith, Robert ...    1992    U. S. Geological Survey Profes...    Chemistry of the subalkalic silicic obsidians...   
Bateman, Paul C; Dodge, Frankl...    1984    Open-File Report - U. S. Geolo...    Major oxide analyses, CIPW norms, modes, and bulk ...   
Silberman-Miles-L; McKee-Edwin...    1972    Isochron/West. 4; Pages 7-28. ...    A summary of radiometric age determinations on Ter...   
No Author Data.    1988    n/a    Late- to post-subduction magmatic transitions in ...   
Ormerod, David S; Hawkesworth,...    1988    Nature London, vol.333, no.617...    Tectonic and magmatic transitions in the western G...   

Download all references for this search.


Display all results on a dynamic map.

Display results on a simple static map suitable for downloading.


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 ST_Contains(st_GeomFromText('Polygon((-117.938232421875 37.8791893148165,-118.02886962890625 37.85100126460795,-118.10028076171875 37.88786039168385,-118.15521240234375 37.88352498087131,-118.1964111328125 37.792422407988575,-118.16619873046875 37.71424496764924,-118.092041015625 37.640334898059486,-117.9986572265625 37.568528265476075,-117.916259765625 37.642509774448754,-117.78717041015625 37.67947293019486,-117.74871826171875 37.792422407988575,-117.8118896484375 37.86401247373357,-117.938232421875 37.8791893148165))'),loc.mypoint) 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