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


Number of rows returned = 0
Start: 1754185185.6871
End: 1754185185.6872
Elapsed time: 0.1249 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('VA','Moneta',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80299" ["State"]=> string(2) "VA" ["CityName"]=> string(6) "Moneta" ["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) "24121" ["zip3"]=> string(3) "241" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "MONETA" ["zipstate"]=> string(2) "VA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "37.18" ["iplongitude"]=> string(6) "-79.63" ["ziplocation"]=> string(15) "NA-US-VA-MONETA" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "4758" ["zippopulation"]=> string(4) "8667" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "241" ["zipcity"]=> string(5) "SALEM" ["zipstate"]=> string(2) "VA" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "20511" ["State"]=> string(2) "VA" ["CityName"]=> string(5) "Salem" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(2) "73" ["Population"]=> string(5) "23756" ["Latitude"]=> string(9) "37.286895" ["Longitude"]=> string(10) "-80.055836" ["PrimaryAC"]=> string(3) "540" ["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) "20511" ["Population2000"]=> string(5) "24747" ["FIPS"]=> string(7) "5170000" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "116" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
32 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20501VARoanoke02119639737.276895-79.9557112760000020501949115168000-5-1116
20405VALynchburg01786604937.403672-79.1702054340000020405652695147672-5-1116
20295VADanville01005305636.587238-79.4044044340000020295484115121344-5-1116
20511VASalem0732375637.286895-80.0558365400000020511247475170000-5-1116
20411VAMartinsville-11171616236.686143-79.8691715400000020411154165149784-5-1116
41711VAMadison Heights-101170037.439406-79.11725900000115845148520-5-1116
41763VAVinton-10766537.277987-79.8952480000077825181280-5-1116
20274VACollinsville-164728036.72195-79.915253540000002027477775118352-5-1116
20521VASouth Boston-162699736.707722-78.903388434000002052184915173712-5-1116
20203VABedford049607337.334591-79.522783540000002020362995105544-5-1116
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
41676VAForest-10562437.370723-79.2668010000080065128688-5-1116
20504VARocky Mount-172409836.999855-79.889673276000002050440665168496-5-1116
20185VAAltavista-12368637.117622-79.289632434000002018534255101528-5-1116
20307VADublin-1102201237.103114-80.684702540000002030722885123648-5-1116
20191VAAppomattox-149170737.358973-78.826438434000002019117615102072-5-1116
20200VABassett-10157936.759905-79.986763540000002020013385104872-5-1116
41745VAStanleytown-10156336.751657-79.9487140000015155175040-5-1116
20325VAFerrum-144151436.926381-80.011181276000002032513135127712-5-1116
20258VAChatham-10135436.82553-79.397379434000002025813385115000-5-1116
20235VABrookneal-151134437.052001-78.944958434000002023512595110296-5-1116
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20350VAGretna-12133936.95319-79.362769434000002035012575133232-5-1116
20518VAShawsville00126037.173248-80.24858540000002051810295171632-5-1116
20189VAAmherst-10106037.576899-79.050424434000002018922515101672-5-1116
20326VAFieldale-10101836.69985-79.93948254000000203269295127744-5-1116
20535VAStuart-16096536.640197-80.2739454000000205359615176256-5-1116
20354VAHalifax-13068836.764593-78.928081434000002035413895134064-5-1116
20549VATroutville0145537.415406-79.87696727600000205494325179472-5-1116
20329VAFloyd-1039636.91215-80.31840854000000203294325128544-5-1116
20223VABoones Mill-1023937.115462-79.95396654000000202232855108584-5-1116
20539VASweet Briar-1037.567427-79.0756174340000020539-5-1116
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20507VARustburg-1037.273731-79.098914434000002050712715169536-5-1116
20211VABig Island-15037.516659-79.387524340000020211-5-1116
**** cities in zip3 **************
38 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
24153SALEMVA30271Salem116
24112MARTINSVILLEVA23602Martinsville116
24179VINTONVA15844Vinton116
24151ROCKY MOUNTVA15043Rocky Mount116
24141RADFORDVA12623Radford231
24121MONETAVA8667Moneta
24175TROUTVILLEVA7123Troutville116
24148RIDGEWAYVA6323Ridgeway
24171STUARTVA6082Stuart116
24101HARDYVA5266
zipcodezipcityzipstatezippopulationcitynameDMAID
24134PEARISBURGVA4485Pearisburg
24184WIRTZVA3827
24124NARROWSVA3350Narrows
24127NEW CASTLEVA3328New Castle
24149RINERVA2989
24104HUDDLESTONVA2775
24136PEMBROKEVA2729Pembroke
24133PATRICK SPRINGSVA2130Patrick Springs
24137PENHOOKVA2069Penhook
24174THAXTONVA1987
zipcodezipcityzipstatezippopulationcitynameDMAID
24162SHAWSVILLEVA1910Shawsville116
24128NEWPORTVA1597Newport
24122MONTVALEVA1551Montvale
24165SPENCERVA1479Spencer
24120MEADOWS OF DANVA1329Meadows Of Dan
24138PILOTVA1240
24102HENRYVA1200
24176UNION HALLVA1115Union Hall
24168STANLEYTOWNVA868Stanleytown116
24185WOOLWINEVA803Woolwine
zipcodezipcityzipstatezippopulationcitynameDMAID
24147RICH CREEKVA795Rich Creek
24150RIPPLEMEADVA557
24105INDIAN VALLEYVA0
24130ORISKANYVA0Oriskany
24131PAINT BANKVA0Paint Bank
24139PITTSVILLEVA0
24161SANDY LEVELVA0Sandy Level
24167STAFFORDSVILLEVA0
***** 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 WSLK-AM
City MONETA-VA

City Moneta, VA is located in DMAID: