Fix W294AR Station DMA

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9999" ["dmaType"]=> NULL ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(7) "Unrated" ["Population25up"]=> string(1) "0" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(0) "" }

*** city ***************

array(22) { ["id"]=> string(3) "580" ["State"]=> string(2) "AL" ["CityName"]=> string(6) "Auburn" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "146" ["Population"]=> string(5) "33830" ["Latitude"]=> string(9) "32.597684" ["Longitude"]=> string(10) "-85.480823" ["PrimaryAC"]=> string(3) "251" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(3) "580" ["Population2000"]=> string(5) "42987" ["FIPS"]=> string(6) "103076" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }

****** zip code ************

array(13) { ["zipcode"]=> string(5) "36830" ["zip3"]=> string(3) "368" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "AUBURN" ["zipstate"]=> string(2) "AL" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "32.59" ["iplongitude"]=> string(6) "-85.48" ["ziplocation"]=> string(15) "NA-US-AL-AUBURN" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "13320" ["zippopulation"]=> string(5) "23518" ["zipincome"]=> string(7) "8388607" }

******* zip3 ***********

array(3) { ["zip3"]=> string(3) "368" ["zipcity"]=> string(11) "PHENIX CITY" ["zipstate"]=> string(2) "AL" }

**** zip3 city**************

array(22) { ["id"]=> string(3) "794" ["State"]=> string(2) "AL" ["CityName"]=> string(11) "Phenix City" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(3) "139" ["Population"]=> string(5) "25312" ["Latitude"]=> string(9) "32.472822" ["Longitude"]=> string(10) "-85.020121" ["PrimaryAC"]=> string(3) "251" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(3) "794" ["Population2000"]=> string(5) "28265" ["FIPS"]=> string(6) "159472" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }

**** cities in DMA per station **************

No Rows in Recordset!

**** cities in zip3 **************

24 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
36830	AUBURN	AL	23518	Auburn
36801	OPELIKA	AL	15849	Opelika
36867	PHENIX CITY	AL	14901	Phenix City
36869	PHENIX CITY	AL	14285	Phenix City
36804	OPELIKA	AL	13349	Opelika
36870	PHENIX CITY	AL	12839	Phenix City
36854	VALLEY	AL	11676	Valley	187
36832	AUBURN	AL	9975	Auburn
36863	LANETT	AL	9401	Lanett
36877	SMITHS STATION	AL	9021
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
36853	DADEVILLE	AL	6312	Dadeville
36874	SALEM	AL	6131
36862	LAFAYETTE	AL	4851	Lafayette
36875	SEALE	AL	3521
36866	NOTASULGA	AL	2985	Notasulga
36856	FORT MITCHELL	AL	2939
36861	JACKSONS GAP	AL	2527
36850	CAMP HILL	AL	2168	Camp Hill
36852	CUSSETA	AL	1707
36860	HURTSBORO	AL	1321	Hurtsboro
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
36879	WAVERLY	AL	1280	Waverly	187
36855	FIVE POINTS	AL	1099	Five Points
36871	PITTSVIEW	AL	849
36858	HATCHECHUBBEE	AL	0

Station W294AR-FX

City Auburn-AL

City Auburn, AL is located in DMAID: