Coordinates: N 43.045-43.055, W 76.146-76.156 Maps:[Google][Bing]
Could not run query:
SELECT lc.name, f.facility_id, f.display_channel, f.callsign AS fac_callsign, f.community_served_city AS comm_city, f.community_served_state AS comm_state, ng.active_ind AS atsc3_active_ind, ng.facility_type_ind, IF(l.erp_fix, l.erp_fix, q.aafq_power_erp_kw) AS effective_erp, IF(l.asrn_fix, l.asrn_fix, l.aloc_asrn) AS asrn, IF(l.ant_type IS NULL OR l.ant_type = '', n.aant_antenna_type_code, l.ant_type) AS antenna_type, IF(l.ant_rotation, l.ant_rotation, n.aant_rotation_deg) AS ant_rotation, IF(l.ant_pattern IS NULL OR l.ant_pattern = '', n.aant_antenna_record_id, l.ant_pattern) AS antenna_id, a.aapp_application_id, a.priority, a.aapp_receipt_date, IF(a.channel_fix, a.channel_fix, af.afac_channel) AS station_channel, v.*, af.station_class_code, IF(l.hagl_fix, l.hagl_fix, n.aant_rc_hag) AS hag_rc_mtr, IF(n.aant_rc_haat = 0 OR l.haat_invalid = 'Y', l.calc_haat, n.aant_rc_haat) AS haat_rc_mtr, IF(a.svc_code_fix IS NULL OR a.svc_code_fix = '', v.service_code, a.svc_code_fix) AS vsd_service, IF(l.ant_pattern IS NULL OR l.ant_pattern = '', n.aant_make, l.ant_make) AS lic_ant_make, IF(l.ant_pattern IS NULL OR l.ant_pattern = '', n.aant_model, l.ant_model) AS lic_ant_model_num, l.aloc_lat_dir AS lat_dir, l.aloc_lat_deg AS lat_deg, l.aloc_lat_mm AS lat_min, l.aloc_lat_ss AS lat_sec, l.aloc_long_dir AS lon_dir, l.aloc_long_deg AS lon_deg, l.aloc_long_mm AS lon_min, l.aloc_long_ss AS lon_sec FROM facility_lms f INNER JOIN application_facility af ON f.facility_id = af.afac_facility_id INNER JOIN application_lms a ON af.afac_application_id = a.aapp_application_id INNER JOIN app_location l ON a.aapp_application_id = l.aloc_aapp_application_id INNER JOIN app_antenna n ON l.aloc_loc_record_id = n.aant_aloc_loc_record_id INNER JOIN app_antenna_frequency q ON n.aant_antenna_record_id = q.aafq_aant_antenna_record_id INNER JOIN license_filing_version v ON a.aapp_application_id = v.filing_version_id INNER JOIN location lc ON l.biased_long <= lc.left AND l.biased_long >= lc.right AND l.biased_lat <= lc.top AND l.biased_lat >= lc.bottom AND lc.name = 'Downtown Syracuse (NY)' LEFT JOIN dma_rel r ON r.facility_id = f.facility_id LEFT JOIN atsc3_facility ng ON a.aapp_application_id = ng.application_id AND (ng.facility_type_ind = 'H1' OR ng.facility_type_ind = 'H3') WHERE (l.cf_ind IS NULL OR l.cf_ind = '' OR l.cf_ind = 'N') AND (v.purpose_code IN('L2C','CP','RUL','MOD','STA','EXT') OR v.original_purpose_code IN('L2C','CP','RUL','MOD','STA','EXT')) AND v.sub_purpose_code NOT IN('LEG','SIL','SSL') AND (CASE WHEN (a.svc_code_fix IS NULL OR a.svc_code_fix = '') THEN v.service_code IN('DTV','DTS','DTX','DCA','LPD','LPT','DRT','LDTS','CDTS','FM','FS','FL','FB','FX') ELSE a.svc_code_fix IN('DTV','DTS','DTX','DCA','LPD','LPT','DRT','LDTS','CDTS','FM','FS','FL','FB','FX') END) AND (r.dma_id <> '275' OR r.dma_id IS NULL) AND (CASE WHEN af.afac_channel < 195 THEN r.dma_id <> '0' ELSE 1 END) AND (v.active_ind = 'Y' OR a.active_record = 'V') AND (a.active_record <> 'N' OR a.active_record IS NULL) UNION SELECT lc.name, f.facility_id, f.display_channel, f.callsign AS fac_callsign, f.community_served_city AS comm_city, f.community_served_state AS comm_state, ng.active_ind AS atsc3_active_ind, ng.facility_type_ind, IF(l.erp_fix, l.erp_fix, q.aafq_power_erp_kw) AS effective_erp, IF(l.asrn_fix, l.asrn_fix, l.aloc_asrn) AS asrn, IF(l.ant_type IS NULL OR l.ant_type = '', n.aant_antenna_type_code, l.ant_type) AS antenna_type, IF(l.ant_rotation, l.ant_rotation, n.aant_rotation_deg) AS ant_rotation, IF(l.ant_pattern IS NULL OR l.ant_pattern = '', n.aant_antenna_record_id, l.ant_pattern) AS antenna_id, a.aapp_application_id, a.priority, a.aapp_receipt_date, IF(a.channel_fix, a.channel_fix, af.afac_channel) AS station_channel, v.*, af.station_class_code, IF(l.hagl_fix, l.hagl_fix, n.aant_rc_hag) AS hag_rc_mtr, IF(n.aant_rc_haat = 0 OR l.haat_invalid = 'Y', l.calc_haat, n.aant_rc_haat) AS haat_rc_mtr, IF(a.svc_code_fix IS NULL OR a.svc_code_fix = '', v.service_code, a.svc_code_fix) AS vsd_service, IF(l.ant_pattern IS NULL OR l.ant_pattern = '', n.aant_make, l.ant_make) AS lic_ant_make, IF(l.ant_pattern IS NULL OR l.ant_pattern = '', n.aant_model, l.ant_model) AS lic_ant_model_num, l.cf_lat_dir AS lat_dir, l.cf_lat_deg AS lat_deg, l.cf_lat_mm AS lat_min, l.cf_lat_ss AS lat_sec, l.cf_lon_dir AS lon_dir, l.cf_lon_deg AS lon_deg, l.cf_lon_mm AS lon_min, l.cf_lon_ss AS lon_sec FROM facility_lms f INNER JOIN application_facility af ON f.facility_id = af.afac_facility_id INNER JOIN application_lms a ON af.afac_application_id = a.aapp_application_id INNER JOIN app_location l ON a.aapp_application_id = l.aloc_aapp_application_id INNER JOIN app_antenna n ON l.aloc_loc_record_id = n.aant_aloc_loc_record_id INNER JOIN app_antenna_frequency q ON n.aant_antenna_record_id = q.aafq_aant_antenna_record_id INNER JOIN license_filing_version v ON a.aapp_application_id = v.filing_version_id INNER JOIN location lc ON l.cf_biased_long <= lc.left AND l.cf_biased_long >= lc.right AND l.cf_biased_lat <= lc.top AND l.cf_biased_lat >= lc.bottom AND lc.name = 'Downtown Syracuse (NY)' LEFT JOIN dma_rel r ON r.facility_id = f.facility_id LEFT JOIN atsc3_facility ng ON a.aapp_application_id = ng.application_id AND (ng.facility_type_ind = 'H1' OR ng.facility_type_ind = 'H3') WHERE l.cf_ind = 'Y' AND (v.purpose_code IN('L2C','CP','RUL','MOD','STA','EXT') OR v.original_purpose_code IN('L2C','CP','RUL','MOD','STA','EXT')) AND v.sub_purpose_code NOT IN('LEG','SIL','SSL') AND (CASE WHEN (a.svc_code_fix IS NULL OR a.svc_code_fix = '') THEN v.service_code IN('DTV','DTS','DTX','DCA','LPD','LPT','DRT','LDTS','CDTS','FM','FS','FL','FB','FX') ELSE a.svc_code_fix IN('DTV','DTS','DTX','DCA','LPD','LPT','DRT','LDTS','CDTS','FM','FS','FL','FB','FX') END) AND (r.dma_id <> '275' OR r.dma_id IS NULL) AND (CASE WHEN af.afac_channel < 195 THEN r.dma_id <> '0' ELSE 1 END) AND (v.active_ind = 'Y' OR a.active_record = 'V') AND (a.active_record <> 'N' OR a.active_record IS NULL) ORDER BY display_channel = 0, display_channel ASC, facility_id ASC, priority ASC, aapp_receipt_date
Channel
Call Sign
City of License
ASRN
AGL
Record Type
HAAT
Power
Could not run query:
SELECT l.name, f.facility_id, f.display_channel, f.fac_callsign, a.comm_city, a.comm_state, t.* FROM tv_eng_data t INNER JOIN facility f ON t.facility_id = f.facility_id INNER JOIN application a ON t.application_id = a.application_id INNER JOIN location l ON t.biased_long <= l.left AND t.biased_long >= l.right AND t.biased_lat <= l.top AND t.biased_lat >= l.bottom LEFT JOIN dma_rel r ON f.facility_id = r.facility_id AND r.priority = 1 WHERE l.name = 'Downtown Syracuse (NY)' AND r.dma_id <> '275' AND t.eng_record_type <> 'A' AND t.active_record <> 'N' AND r.dma_id <> '0' AND t.vsd_service NOT IN ('DT', 'LD', 'DC', 'DX', 'DD') ORDER BY t.station_channel ASC, t.facility_id ASC, t.priority ASC, t.application_id ASC
Disclaimer: Though every attempt is made, accuracy cannot be guaranteed. RabbitEars reserves the right to delist
any station, ownership group, network, or other entity noted on RabbitEars at any time and for any reason.
"Everybody got to deviate from the norm..." - Rush "Vital Signs"
