--these are the functions from the DAGs
DROP FUNCTION IF EXISTS collisions_replicator.refresh_mat_view_collisions_no;
DROP FUNCTION IF EXISTS collisions_replicator.refresh_mat_views;
DROP FUNCTION IF EXISTS collisions_replicator.refresh_ev_mv;
DROP FUNCTION IF EXISTS collisions_replicator.refresh_inv_mv;
DROP FUNCTION IF EXISTS collisions_replicator.refresh_norm_mv;
DROP FUNCTION IF EXISTS collisions_replicator.refresh_raw_fields_mv;
DROP FUNCTION IF EXISTS collisions_replicator.update_acc_safe_copy;
DROP FUNCTION IF EXISTS traffic.update_arc_link;
DROP FUNCTION IF EXISTS traffic.update_arterydata;
DROP FUNCTION IF EXISTS traffic.update_category;
DROP FUNCTION IF EXISTS traffic.update_cnt_det;
DROP FUNCTION IF EXISTS traffic.update_cnt_spd;
DROP FUNCTION IF EXISTS traffic.update_countinfo;
DROP FUNCTION IF EXISTS traffic.update_countinfomics;
DROP FUNCTION IF EXISTS traffic.update_det;
DROP FUNCTION IF EXISTS traffic.update_node;

--do not use views in traffic
DROP VIEW IF EXISTS traffic.artery_traffic_signals_DO_NOT_USE;
DROP VIEW IF EXISTS traffic.artery_locations_px_DO_NOT_USE; --this one is referenced by two DRs which we would have to deal with: data_requests.i0510_nycs_volume_tmc, data_requests.i0648_glencarin_tmc

--logged actions, no longer relevant with current truncate and delete paradigm. 
DROP TABLE IF EXISTS traffic.logged_actions;
DROP FUNCTION IF EXISTS traffic.if_modified_func();