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


Number of rows returned = 0
Start: 1754144044.8287
End: 1754144044.8289
Elapsed time: 0.1690 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "79862" ["State"]=> string(2) "KY" ["CityName"]=> string(13) "Fort Campbell" ["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) "42223" ["zip3"]=> string(3) "422" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(13) "FORT CAMPBELL" ["zipstate"]=> string(2) "KY" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "36.65" ["iplongitude"]=> string(6) "-87.54" ["ziplocation"]=> string(22) "NA-US-KY-FORT CAMPBELL" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "6776" ["zippopulation"]=> string(5) "13815" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "422" ["zipcity"]=> string(12) "HOPKINSVILLE" ["zipstate"]=> string(2) "KY" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "7027" ["State"]=> string(2) "KY" ["CityName"]=> string(12) "Hopkinsville" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "115" ["Population"]=> string(5) "29809" ["Latitude"]=> string(9) "36.854712" ["Longitude"]=> string(10) "-87.488872" ["PrimaryAC"]=> string(3) "270" ["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) "7027" ["Population2000"]=> string(5) "30089" ["FIPS"]=> string(7) "2137918" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "206" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
19 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
18517TNClarksville02057549436.559383-87.35826193100000185171034554715160-6-1206
7027KYHopkinsville01152980936.854712-87.488872270000007027300892137918-6-1206
35647KYFort Campbell North-101886136.653631-87.45971600000143382128486-6-1206
18498TNBrentwood001639235.998194-86.79261961500000234454708280-1206
7104KYMurray01461443936.609494-88.315656270000007104149502154642-6-1206
18631TNLewisburg-167987935.449034-86.7931129310000018631104134741860-1206
18623TNLafayette-10364136.525595-86.026246615000001862338854740160-1206
18509TNCenterville-156361635.788218-87.45589931000001850937934712420-1206
7114KYOak Grove-150286336.658374-87.41956527000000711470642157090-6-1206
18480TNAshland City063255236.267954-87.054877615000001848036414702180-1206
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
18507TNCarthage-196238636.25496-85.949211615000001850722514711280-1206
7095KYMorgantown-163228437.219465-86.69251327000000709525442153490-6-1206
18596TNHartsville-176218836.391617-86.160172615000001859623954732720-1206
6910KYCadiz-173214836.867781-87.81737427000000691023732111692-6-1206
6962KYElkton03178936.808926-87.15637727000000696219842124400-6-1206
18618TNKingston Springs063152936.087195-87.108267615000001861827734739660-1206
18634TNLinden-14109935.612168-87.841601931000001863410154742720-1206
18636TNLobelville-1483035.751119-87.79308593100000186369154743160-1206
18531TNCornersville-1068335.358152-86.84168161500000185319624717180-1206
**** cities in zip3 **************
32 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
42240HOPKINSVILLEKY30637Hopkinsville206
42223FORT CAMPBELLKY13815Fort Campbell
42276RUSSELLVILLEKY11223Russellville44
42211CADIZKY10064Cadiz206
42261MORGANTOWNKY7684Morgantown206
42262OAK GROVEKY6300Oak Grove206
42220ELKTONKY4909Elkton206
42206AUBURNKY4340Auburn211
42256LEWISBURGKY3774Lewisburg
42210BROWNSVILLEKY3173Brownsville211
zipcodezipcityzipstatezippopulationcitynameDMAID
42217CROFTONKY3005Crofton
42274ROCKFIELDKY1951
42202ADAIRVILLEKY1809Adairville
42266PEMBROKEKY1723Pembroke
42234GUTHRIEKY1602Guthrie
42286TRENTONKY1140Trenton
42207BEE SPRINGKY943Bee Spring
42215CERULEANKY929
42259MAMMOTH CAVEKY767Mammoth Cave
42265OLMSTEADKY739
zipcodezipcityzipstatezippopulationcitynameDMAID
42232GRACEYKY729Gracey
42236HERNDONKY685
42275ROUNDHILLKY662
42204ALLENSVILLEKY548Allensville
42214CENTERKY518Center
42219DUNBARKY0
42280SHARON GROVEKY0Sharon Grove
42252JETSONKY0
42254LA FAYETTEKY0La Fayette
42273ROCHESTERKY0Rochester
zipcodezipcityzipstatezippopulationcitynameDMAID
42285SWEEDENKY0
42287WELCHS CREEKKY0
Station WQEZ-AM
City FORT CAMPBELL-KY

City Fort Campbell, KY is located in DMAID: