|
Output Data
|
|
1242 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. References First 10 References:
|
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((-107.1826171875 38.42777351132902,-107.73193359375 38.39333888832238,-108.17138671875 38.30718056188315,-108.56689453125 38.13455657705411,-108.6767578125 37.78808138412046,-108.47900390625 37.33522435930639,-107.81982421875 37.107765071185135,-106.94091796875 36.98500309285596,-106.3916015625 36.52729481454624,-106.0400390625 36.914764288955936,-106.4794921875 38.46219172306828,-106.85302734375 38.496593518947556,-107.1826171875 38.42777351132902))'),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