Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WMWX FM 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 = 'MIAMITOWN' and State = 'OH'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754168199.2606
End: 1754168199.2607
Elapsed time: 0.1688 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('OH','Miamitown',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80003" ["State"]=> string(2) "OH" ["CityName"]=> string(9) "Miamitown" ["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) "45041" ["zip3"]=> string(3) "450" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(9) "MIAMITOWN" ["zipstate"]=> string(2) "OH" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(4) "39.2" ["iplongitude"]=> string(6) "-84.58" ["ziplocation"]=> string(18) "NA-US-OH-MIAMITOWN" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "450" ["zipcity"]=> string(8) "HAMILTON" ["zipstate"]=> string(2) "OH" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "14275" ["State"]=> string(2) "OH" ["CityName"]=> string(8) "Hamilton" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "155" ["Population"]=> string(5) "61368" ["Latitude"]=> string(9) "39.395806" ["Longitude"]=> string(9) "-84.56492" ["PrimaryAC"]=> string(3) "513" ["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(5) "14275" ["Population2000"]=> string(5) "60690" ["FIPS"]=> string(7) "3933012" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "28" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
23 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
14128OHCincinnati035436404039.13616-84.50308851300000141283312853915000-5-128
14275OHHamilton01556136839.395806-84.564925130000014275606903933012-5-128
14424OHMiddletown02344602239.506007-84.3758855130000014424516053949840-5-128
6938KYCovington01544326439.065111-84.509594859000006938433702117848-5-128
14205OHFairfield-103972939.331156-84.54284251300000420973925970-5-128
14532OHOxford01141893739.507452-84.7465525130000014532219433959234-5-128
35720KYNewport-101887139.088661-84.49020600000170482155884-5-128
35645KYFlorence-101862438.993225-84.64260200000235512127982-5-128
14420OHMiamisburg001783439.638525-84.2752893700000194893949434-5-128
35649KYFort Thomas-101603239.076011-84.45127300000164952128594-5-128
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
35635KYErlanger-101597939.013511-84.59404200000166762125300-5-128
14344OHLebanon-1801045339.426724-84.2126315130000014344169623942364-5-128
14193OHEaton-150739639.747603-84.633818937000001419381333924234-5-128
7081KYMaysville-157716938.64392-83.7758960600000708189932151024-5-128
6946KYCynthiana-158649738.388292-84.29684185900000694662582119432-5-128
14426OHMilford-10566039.174883-84.2843835130000062843950176-5-128
6921KYCarrollton-190371538.677329-85.17150450200000692138462113024-5-128
6980KYFlemingsburg-135307138.420541-83.73758160600000698030102127856-5-128
7214KYWilliamstown0103302338.641184-84.5609285900000721432272183406-5-128
6971KYFalmouth081237838.67386-84.33421385900000697120582126434-5-128
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
14716OHWaynesville-10194939.532037-84.08646513000001471625583982418-5-128
35625KYCrittenden-1073138.782248-84.6057940000024012118568-5-128
14721OHWest Chester-1039.440956-84.57574651300000-5-128
**** cities in zip3 **************
26 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
45011HAMILTONOH53645Hamilton28
45040MASONOH44080Mason
45069WEST CHESTEROH43697West Chester28
45013HAMILTONOH43290Hamilton28
45044MIDDLETOWNOH40206Middletown28
45014FAIRFIELDOH37746Fairfield28
45036LEBANONOH27844Lebanon28
45005FRANKLINOH24974Franklin
45042MIDDLETOWNOH22364Middletown28
45066SPRINGBOROOH20638Springboro
zipcodezipcityzipstatezippopulationcitynameDMAID
45039MAINEVILLEOH20577Maineville
45030HARRISONOH15450Harrison
45056OXFORDOH12167Oxford28
45067TRENTONOH11430Trenton
45002CLEVESOH10875Cleves
45068WAYNESVILLEOH9240Waynesville28
45015HAMILTONOH9206Hamilton28
45050MONROEOH7958Monroe
45052NORTH BENDOH3845North Bend
45065SOUTH LEBANONOH3521South Lebanon
zipcodezipcityzipstatezippopulationcitynameDMAID
45053OKEANAOH3078
45064SOMERVILLEOH2527Somerville
45054OREGONIAOH2050
45034KINGS MILLSOH1077
45003COLLEGE CORNEROH737College Corner
45051MOUNT SAINT JOSEPHOH0
Station WMWX-FM
City MIAMITOWN-OH

City Miamitown, OH is located in DMAID: