Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix W224AV Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9998" ["dmaType"]=> NULL ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(7) "Unrated" ["Population25up"]=> string(1) "0" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(0) "" }
Database: media
SQL: select * from cities where CityName = 'COVINGTON' and State = 'MI'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const9Using where


Number of rows returned = 0
Start: 1754176597.9105
End: 1754176597.9107
Elapsed time: 0.2201 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('MI','Covington',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80130" ["State"]=> string(2) "MI" ["CityName"]=> string(9) "Covington" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> NULL ["Population"]=> NULL ["Latitude"]=> NULL ["Longitude"]=> NULL ["PrimaryAC"]=> NULL ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> NULL ["ISPCount"]=> NULL ["CovadDSL"]=> NULL ["VerizonDSL"]=> NULL ["allegiance"]=> NULL ["SBC"]=> NULL ["RateCenterCityid"]=> NULL ["Population2000"]=> NULL ["FIPS"]=> NULL ["cTZoffset"]=> NULL ["DST"]=> string(1) "0" ["DMAID"]=> NULL }
****** zip code ************
array(13) { ["zipcode"]=> string(5) "49919" ["zip3"]=> string(3) "499" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "COVINGTON" ["zipstate"]=> string(2) "MI" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "46.51" ["iplongitude"]=> string(6) "-88.44" ["ziplocation"]=> string(18) "NA-US-MI-COVINGTON" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "499" ["zipcity"]=> string(8) "IRONWOOD" ["zipstate"]=> string(2) "MI" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "8717" ["State"]=> string(2) "MI" ["CityName"]=> string(8) "Ironwood" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "81" ["Population"]=> string(4) "6849" ["Latitude"]=> string(9) "46.455931" ["Longitude"]=> string(10) "-90.159378" ["PrimaryAC"]=> string(3) "906" ["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(4) "8717" ["Population2000"]=> string(4) "6293" ["FIPS"]=> string(7) "2641060" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
30 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
49938IRONWOODMI6211Ironwood
49913CALUMETMI5571Calumet
49930HANCOCKMI4781Hancock
49931HOUGHTONMI4735Houghton
49935IRON RIVERMI4637Iron River
49946LANSEMI3309
49920CRYSTAL FALLSMI3287Crystal Falls
49953ONTONAGONMI2388Ontonagon
49916CHASSELLMI2315Chassell
49911BESSEMERMI2196Bessemer
zipcodezipcityzipstatezippopulationcitynameDMAID
49945LAKE LINDENMI2085Lake Linden
49908BARAGAMI1981Baraga
49968WAKEFIELDMI1622Wakefield
49905ATLANTIC MINEMI1458
49958PELKIEMI1014Pelkie
49950MOHAWKMI985
49969WATERSMEETMI924Watersmeet
49912BRUCE CROSSINGMI769Bruce Crossing
49947MARENISCOMI548Marenisco
49925EWENMI501Ewen
zipcodezipcityzipstatezippopulationcitynameDMAID
49910BERGLANDMI0Bergland
49919COVINGTONMI0Covington
49927GAASTRAMI0Gaastra
49921DODGEVILLEMI0Dodgeville
49948MASS CITYMI0Mass City
49952NISULAMI0
49962SKANEEMI0
49965TOIVOLAMI0Toivola
49967TROUT CREEKMI0Trout Creek
49970WATTONMI0Watton
Station W224AV-FX
City COVINGTON-MI

City Covington, MI is located in DMAID: