psql_copy_huc8.txt

\COPY (SELECT st.Mrbs,st.huc_08_name,st.taxon, ce.collecting_event_id FROM stats st join collection_object ce on st.catalog_number = ce.catalog_number join native_ranges nr on st.huc_08 = nr.huc_code AND st.taxon = nr.taxon WHERE st.maximum_uncertainty_estimate <= 5000 AND st.data_type = 'Vouchered Specimen' AND nr.source = 'Fishes of Texas Project' and nr.status = 'Native' and nr.status = 'Possibly native' and st.suspect = 'No') TO 'D:/Colton_Data/Species_Accumulation/Data/spaccu.csv' with csv;