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
9 samples found
Create an HTML Table, Excel File, or Tab-delimited Text File for viewing data
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.
First 10 References:
No Author Data.
Late- to post-subduction magmatic transitions in ...
Walker, J D; Andrew, J E; Stoc...
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
(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.3614501953125 36.00911716117323,-117.20489501953125 35.94021206888743,-117.08404541015625 35.68853320738875,-117.0703125 35.585851593232356,-117.14447021484375 35.55457449014312,-117.29827880859375 35.556808973844596,-117.279052734375 35.71975793933433,-117.33673095703125 35.891275201659134,-117.366943359375 35.98689628443789,-117.3614501953125 36.00911716117323))'),loc.mypoint) AND age.sample_num = samp.sample_num
(age.calculated_age >= 0 AND age.calculated_age <= 20)
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