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


Number of rows returned = 0
Start: 1754188089.847
End: 1754188089.8478
Elapsed time: 0.8359 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('TX','Ben Bolt',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80320" ["State"]=> string(2) "TX" ["CityName"]=> string(8) "Ben Bolt" ["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) "78342" ["zip3"]=> string(3) "783" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(8) "BEN BOLT" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "27.63" ["iplongitude"]=> string(6) "-98.08" ["ziplocation"]=> string(17) "NA-US-TX-BEN BOLT" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "268" ["zippopulation"]=> string(3) "477" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "783" ["zipcity"]=> string(5) "ALICE" ["zipstate"]=> string(2) "TX" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "18803" ["State"]=> string(2) "TX" ["CityName"]=> string(5) "Alice" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(2) "60" ["Population"]=> string(5) "19788" ["Latitude"]=> string(9) "27.750652" ["Longitude"]=> string(9) "-98.07046" ["PrimaryAC"]=> string(3) "512" ["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) "18803" ["Population2000"]=> string(5) "19010" ["FIPS"]=> string(7) "4801852" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "139" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
24 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19052TXCorpus Christi030825745327.742857-97.40192736100000190522774544817000-6-1139
19389TXKingsville01022527627.515024-97.8655073610000019389255754839352-6-1139
18803TXAlice0601978827.750652-98.070465120000018803190104801852-6-1139
19746TXRobstown01061284927.792615-97.6693863610000019746127274862600-6-1139
41342TXPortland-101222427.883117-97.32046600000148274858904-6-1139
18827TXAransas Pass-152718027.901917-97.139462361000001882781384803600-6-1139
19173TXFalfurrias-123578827.226529-98.144922361000001917352974825368-6-1139
19338TXIngleside-1154569627.87407-97.208379361000001933893884836008-6-1139
19830TXSinton-179554928.034824-97.508942361000001983056764868036-6-1139
19787TXSan Diego-123498327.762559-98.238771361000001978747534865180-6-1139
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19751TXRockport-135475328.031032-97.04999361000001975173854862804-6-1139
19291TXHebbronville-134446527.311259-98.680998361000001929144984833008-6-1139
18902TXBishop-124333727.585178-97.799437361000001890233054808392-6-1139
19207TXFreer-123327127.879156-98.616237361000001920732414827432-6-1139
19888TXTaft-124322227.978584-97.39432361000001988833964871684-6-1139
19726TXRefugio-121315828.305812-97.274594361000001972629414861436-6-1139
19700TXPremont-123291427.358064-98.125766361000001970027724859384-6-1139
41168TXGregory-10245827.920604-97.292480000023184831064-6-1139
18889TXBenavides-134178827.596677-98.411884361000001888916864807528-6-1139
41617UTWellington-10163239.539476-110.7296670000016664982510-7-1139
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
18799TXAgua Dulce-12679427.783077-97.91003336100000187997374801396-6-1139
41155TXFulton-1076328.067733-97.0401030000015534827888-6-1139
41124TXDriscoll-1068827.672549-97.751059000008254821436-6-1139
19158TXEncino-12526.941838-98.11066336100000191581774824252-6-1139
**** cities in zip3 **************
33 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
78363KINGSVILLETX19820Kingsville139
78332ALICETX19637Alice139
78380ROBSTOWNTX16768Robstown139
78374PORTLANDTX13984Portland139
78382ROCKPORTTX11633Rockport139
78362INGLESIDETX7800Ingleside139
78336ARANSAS PASSTX7775Aransas Pass139
78387SINTONTX7566Sinton139
78368MATHISTX7154Mathis
78355FALFURRIASTX5377Falfurrias139
zipcodezipcityzipstatezippopulationcitynameDMAID
78390TAFTTX4709Taft139
78372ORANGE GROVETX4375Orange Grove
78384SAN DIEGOTX4355San Diego139
78370ODEMTX3979Odem
78361HEBBRONVILLETX3859Hebbronville139
78343BISHOPTX3432Bishop139
78373PORT ARANSASTX3227Port Aransas
78377REFUGIOTX3003Refugio139
78357FREERTX2762Freer139
78383SANDIATX2740Sandia
zipcodezipcityzipstatezippopulationcitynameDMAID
78375PREMONTTX2517Premont139
78393WOODSBOROTX2004Woodsboro
78379RIVIERATX1432Riviera
78389SKIDMORETX1280Skidmore
78330AGUA DULCETX927Agua Dulce139
78340BAYSIDETX0Bayside
78344BRUNITX0Bruni
78349CONCEPCIONTX0Concepcion
78353ENCINOTX0Encino139
78360GUERRATX0Guerra
zipcodezipcityzipstatezippopulationcitynameDMAID
78369MIRANDO CITYTX0Mirando City208
78376REALITOSTX0Realitos
78391TYNANTX0Tynan
***** 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 KABV-FM
City BEN BOLT-TX

City Ben Bolt, TX is located in DMAID: