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


Number of rows returned = 1
Start: 1754185158.1914
End: 1754185158.1916
Elapsed time: 0.1719 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
79862KYFort Campbell-10

*** city ***************
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 *************
18 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
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
***** 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 WCVQ-FM
City FORT CAMPBELL-KY

City , is located in DMAID: