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


Number of rows returned = 0
Start: 1754176449.8239
End: 1754176449.8241
Elapsed time: 0.2201 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80121" ["State"]=> string(2) "TX" ["CityName"]=> string(6) "Tarzan" ["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) "79783" ["zip3"]=> string(3) "797" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "TARZAN" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "32.31" ["iplongitude"]=> string(7) "-101.98" ["ziplocation"]=> string(15) "NA-US-TX-TARZAN" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "797" ["zipcity"]=> string(7) "MIDLAND" ["zipstate"]=> string(2) "TX" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "19538" ["State"]=> string(2) "TX" ["CityName"]=> string(7) "Midland" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "144" ["Population"]=> string(5) "89443" ["Latitude"]=> string(9) "32.005072" ["Longitude"]=> string(11) "-102.099239" ["PrimaryAC"]=> string(3) "432" ["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) "19538" ["Population2000"]=> string(5) "94996" ["FIPS"]=> string(7) "4848072" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "188" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
20 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19619TXOdessa-11708969931.863294-102.365494320000019619909434853388-6-1188
19538TXMidland01448944332.005072-102.0992394320000019538949964848072-6-1188
18899TXBig Spring-1292309332.243198-101.4752314320000018899252334808236-6-1188
19844TXSnyder-1781219532.715537-100.9143193250000019844107834868624-6-1188
19655TXPecos-1201206931.415417-103.499955432000001965595014856516-6-1188
19886TXSweetwater-1251196732.468147-100.4071253250000019886114154871540-6-1188
19419TXLamesa-1231080932.734439-101.95819806000001941999524841164-6-1188
18817TXAndrews-101067832.321401-102.551733432000001881796524803216-6-1188
19198TXFort Stockton-193852430.891383-102.885032432000001919878464826808-6-1188
19553TXMonahans-11810131.589605-102.908272432000001955368214848936-6-1188
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19383TXKermit-10687531.855762-103.094173432000001938357144839004-6-1188
19062TXCrane-135353331.392949-102.350751432000001906231914817516-6-1188
19863TXStanton-11257632.13074-101.792072432000001986325564870040-6-1188
41159TXGardendale-10110332.022499-102.3783360000011974828200-6-1188
19718TXRankin-10101131.224412-101.94086643200000197188004860668-6-1188
19289TXHawley-1060632.612023-99.81331532500000192896464832840-6-1188
18959TXBuffalo Gap-1049932.281044-99.82926532500000189594634811128-6-1188
19922TXTrent-1031932.487508-100.12363932500000199223184873580-6-1188
19240TXGoldsmith-1029731.982441-102.61571443200000192402534830044-6-1188
19038TXColorado City0032.396163-100.862137325000001903842814816120-6-1188
**** cities in zip3 **************
32 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
79762ODESSATX30037Odessa188
79707MIDLANDTX25826Midland188
79705MIDLANDTX25476Midland188
79763ODESSATX25472Odessa188
79761ODESSATX23182Odessa188
79701MIDLANDTX21513Midland188
79720BIG SPRINGTX20058Big Spring188
79703MIDLANDTX16563Midland188
79764ODESSATX15827Odessa188
79706MIDLANDTX13665Midland188
zipcodezipcityzipstatezippopulationcitynameDMAID
79714ANDREWSTX11912Andrews188
79735FORT STOCKTONTX9052Fort Stockton188
79772PECOSTX7403Pecos188
79756MONAHANSTX7210Monahans188
79765ODESSATX5651Odessa188
79745KERMITTX4819Kermit188
79766ODESSATX3980Odessa188
79731CRANETX3357Crane188
79782STANTONTX3267Stanton188
79758GARDENDALETX1773Gardendale188
zipcodezipcityzipstatezippopulationcitynameDMAID
79752MC CAMEYTX1750
79734FORT DAVISTX1649Fort Davis
79739GARDEN CITYTX839Garden City
79718BALMORHEATX516Balmorhea
79713ACKERLYTX488Ackerly
79738GAILTX0Gail
79741GOLDSMITHTX0Goldsmith188
79748KNOTTTX0Knott
79749LENORAHTX0Lenorah
79740GIRVINTX0
zipcodezipcityzipstatezippopulationcitynameDMAID
79755MIDKIFFTX0Midkiff
79783TARZANTX0Tarzan
***** 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 KVLM-FM
City TARZAN-TX

City Tarzan, TX is located in DMAID: