Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WJMM FM 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) "" }
Database: media
SQL: select * from cities where CityName = 'KEENE' and State = 'KY'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const10Using where


Number of rows returned = 0
Start: 1754168159.0935
End: 1754168159.0936
Elapsed time: 0.1590 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('KY','Keene',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79997" ["State"]=> string(2) "KY" ["CityName"]=> string(5) "Keene" ["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) "40339" ["zip3"]=> string(3) "403" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(5) "KEENE" ["zipstate"]=> string(2) "KY" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "37.93" ["iplongitude"]=> string(6) "-84.63" ["ziplocation"]=> string(14) "NA-US-KY-KEENE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "403" ["zipcity"]=> string(10) "GEORGETOWN" ["zipstate"]=> string(2) "KY" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "6995" ["State"]=> string(2) "KY" ["CityName"]=> string(10) "Georgetown" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "115" ["Population"]=> string(5) "11414" ["Latitude"]=> string(9) "38.214542" ["Longitude"]=> string(10) "-84.555496" ["PrimaryAC"]=> string(3) "502" ["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) "6995" ["Population2000"]=> string(5) "18080" ["FIPS"]=> string(7) "2130700" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "104" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
29 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
7057KYLexington024222536638.042746-84.45946859101007057-5-1104
7139KYRichmond0972115537.74472-84.293562859000007139271522165226-5-1104
7217KYWinchester0961579937.994774-84.184289859000007217167242183676-5-1104
7111KYNicholasville-1731360337.88267-84.576585859001007111196802156136-5-1104
6947KYDanville-11471242037.645527-84.774992859000006947154772119882-5-1104
6995KYGeorgetown01151141438.214542-84.555496502000006995180802130700-5-1104
6888KYBerea097912637.576844-84.29355585900100688898512105842-5-1104
7123KYParis-181873038.206476-84.2576785900000712391832159196-5-1104
7093KYMorehead-135835738.1835-83.44114460600000709359142153418-5-1104
7013KYHarrodsburg-182733537.764019-84.84597485900000701380142134966-5-1104
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
7194KYVersailles-150726938.054651-84.73090985900100719475112179482-5-1104
7050KYLawrenceburg-190591138.0313-84.89604150200000705090142144146-5-1104
7099KYMount Sterling-1127536238.056613-83.944585900000709958762154084-5-1104
7216KYWilmore00421537.863042-84.65772685900100721659052183550-5-1104
7049KYLancaster-130342137.618625-84.57943385900000704937342143840-5-1104
7033KYIrvine-133283637.696835-83.96689560600000703328432139646-5-1104
7178KYStanton-158279537.84761-83.8592560600000717830292173164-5-1104
7176KYStanford-1107268637.532302-84.66035860600000717634302173110-5-1104
7100KYMount Vernon0109265437.367018-84.33740960600000710025922154174-5-1104
7042KYJunction City-10198337.585375-84.78865285900000704221842141338-5-1104
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
6920KYCarlisle-160163938.31587-84.03181385900000692019172112898-5-1104
7119KYOwingsville-132149138.142694-83.76613560600000711914882158710-5-1104
7087KYMidway00129038.150484-84.68301485900000708716202152140-5-1104
6906KYBurgin00100937.754961-84.7656818590000069068742111044-5-1104
6939KYCrab Orchard-1082537.462286-84.5079226060000069398422117956-5-1104
7127KYPerryville-1081537.649974-84.9501768590000071277632160258-5-1104
7175KYStamping Ground-1069838.271772-84.6844025020000071755662173038-5-1104
6869KYAnnville-1047037.319178-83.9624776060000068695892101648-5-1104
7150KYSalt Lick-1034238.119555-83.6160696060000071503422168160-5-1104
**** cities in zip3 **************
35 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
40324GEORGETOWNKY32541Georgetown104
40356NICHOLASVILLEKY31017Nicholasville104
40391WINCHESTERKY27600Winchester104
40383VERSAILLESKY19344Versailles104
40342LAWRENCEBURGKY18325Lawrenceburg104
40353MOUNT STERLINGKY16521Mount Sterling104
40330HARRODSBURGKY15164Harrodsburg104
40361PARISKY13921Paris104
40351MOREHEADKY13422Morehead104
40336IRVINEKY9697Irvine104
zipcodezipcityzipstatezippopulationcitynameDMAID
40359OWENTONKY5472Owenton
40311CARLISLEKY5403Carlisle104
40380STANTONKY5219Stanton104
40360OWINGSVILLEKY4962Owingsville104
40390WILMOREKY4629Wilmore104
40312CLAY CITYKY4490Clay City
40337JEFFERSONVILLEKY3916Jeffersonville
40379STAMPING GROUNDKY2860Stamping Ground104
40347MIDWAYKY2539Midway104
40385WACOKY2533Waco
zipcodezipcityzipstatezippopulationcitynameDMAID
40370SADIEVILLEKY2433Sadieville
40322FRENCHBURGKY2297Frenchburg
40372SALVISAKY1993Salvisa
40371SALT LICKKY1966Salt Lick104
40313CLEARFIELDKY1692
40387WELLINGTONKY1311Wellington
40374SHARPSBURGKY1280Sharpsburg
40328GRAVEL SWITCHKY864
40346MEANSKY590
40358OLYMPIAKY558
zipcodezipcityzipstatezippopulationcitynameDMAID
40376SLADEKY0
40350MOOREFIELDKY0
40316DENNISTONKY0
40334HOPEKY0
40355NEW LIBERTYKY0New Liberty
Station WJMM-FM
City KEENE-KY

City Keene, KY is located in DMAID: