Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix KOWI FM Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2009-06-13 09:56:14" ["dmarank"]=> string(1) "0" ["dmaID"]=> string(1) "0" ["dmaType"]=> string(1) "C" ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(13) "United States" ["Population25up"]=> string(9) "300000000" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(2) "WW" }
Database: media
SQL: select * from cities where CityName = 'OATMAN' and State = 'AZ'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754167661.0666
End: 1754167661.0668
Elapsed time: 0.1671 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('AZ','Oatman',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79981" ["State"]=> string(2) "AZ" ["CityName"]=> string(6) "Oatman" ["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) "86433" ["zip3"]=> string(3) "864" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(6) "OATMAN" ["zipstate"]=> string(2) "AZ" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "35.01" ["iplongitude"]=> string(7) "-114.44" ["ziplocation"]=> string(15) "NA-US-AZ-OATMAN" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "864" ["zipcity"]=> string(16) "LAKE HAVASU CITY" ["zipstate"]=> string(2) "AZ" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "1314" ["State"]=> string(2) "AZ" ["CityName"]=> string(16) "Lake Havasu City" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "66" ["Population"]=> string(5) "24363" ["Latitude"]=> string(9) "34.489969" ["Longitude"]=> string(11) "-114.309019" ["PrimaryAC"]=> string(3) "928" ["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) "1314" ["Population2000"]=> string(5) "41938" ["FIPS"]=> string(6) "439370" ["cTZoffset"]=> string(2) "-7" ["DST"]=> string(1) "0" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
17 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
86442BULLHEAD CITYAZ21885Bullhead City
86401KINGMANAZ16930Kingman
86409KINGMANAZ16728Kingman
86406LAKE HAVASU CITYAZ16549Lake Havasu City
86404LAKE HAVASU CITYAZ10968Lake Havasu City
86403LAKE HAVASU CITYAZ10771Lake Havasu City
86426FORT MOHAVEAZ9583
86413GOLDEN VALLEYAZ6208Golden Valley
86429BULLHEAD CITYAZ4921Bullhead City
86440MOHAVE VALLEYAZ4524Mohave Valley
zipcodezipcityzipstatezippopulationcitynameDMAID
86436TOPOCKAZ1291
86441DOLAN SPRINGSAZ1055Dolan Springs32
86434PEACH SPRINGSAZ1042Peach Springs
86444MEADVIEWAZ726Meadview
86437VALENTINEAZ0
86443TEMPLE BAR MARINAAZ0
86445WILLOW BEACHAZ0
***** stations in DMA*************
26 records found!
stationidCallSignLicenseeServicecitynamexStatexcityid
22710BTRNWorld Wide WebWW79841
23163CRN1World Wide WebWW79841
23164CRN2World Wide WebWW79841
23165CRN3World Wide WebWW79841
23166CRN4World Wide WebWW79841
23167CRN5World Wide WebWW79841
23168CRN6World Wide WebWW79841
42585CSPAN1World Wide WebWW79841
42586CSPAN2World Wide WebWW79841
42587CSPAN3World Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
22711ESPNWorld Wide WebWW79841
58943EWTNWorld Wide WebWW79841
22652Fox NewsWorld Wide WebWW79841
22712Fox SportsWorld Wide WebWW79841
41312GCN1World Wide WebWW79841
41481GCN4World Wide WebWW79841
77684GCN5World Wide WebWW79841
32729MOYLWorld Wide WebWW79841
44298NPRWorld Wide WebWW79841
44299PRIWorld Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
22707Radio AmericaWorld Wide WebWW79841
44583SportsBylineWorld Wide WebWW79841
23558TalkStarWorld Wide WebWW79841
40372TammyRadioWorld Wide WebWW79841
44584TheBlazeWorld Wide WebWW79841
44301YSNWorld Wide WebWW79841
Station KOWI-FM
City OATMAN-AZ

City Oatman, AZ is located in DMAID: