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


Number of rows returned = 0
Start: 1754144262.5209
End: 1754144262.5211
Elapsed time: 0.1738 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('WV','Saint Marys',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79871" ["State"]=> string(2) "WV" ["CityName"]=> string(11) "Saint Marys" ["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) "26170" ["zip3"]=> string(3) "261" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(11) "SAINT MARYS" ["zipstate"]=> string(2) "WV" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(4) "39.4" ["iplongitude"]=> string(6) "-81.19" ["ziplocation"]=> string(20) "NA-US-WV-SAINT MARYS" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "2441" ["zippopulation"]=> string(4) "4566" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "261" ["zipcity"]=> string(11) "PARKERSBURG" ["zipstate"]=> string(2) "WV" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "21784" ["State"]=> string(2) "WV" ["CityName"]=> string(11) "Parkersburg" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(1) "0" ["Population"]=> string(5) "33862" ["Latitude"]=> string(9) "39.266175" ["Longitude"]=> string(10) "-81.542139" ["PrimaryAC"]=> string(3) "304" ["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"]=> NULL ["Population2000"]=> string(5) "33099" ["FIPS"]=> string(7) "5462140" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "251" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
14 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
21784WVParkersburg003386239.266175-81.54213930400000330995462140-5-1251
14018OHAthens01432126539.329427-82.0962377400000014018213423902736-5-1251
14391OHMarietta01241502639.420824-81.4505067400000014391145153947628-5-1251
14690OHVan Wert0911089140.867863-84.5834614190000014690106903979562-5-1251
42313WVVienna-101086239.325324-81.54284500000108615483500-5-1251
14049OHBelpre-165679639.280175-81.585072740000001404966603905424-5-1251
21775WVNew Martinsville-151670539.657465-80.859504304000002177559845458684-5-1251
14461OHNelsonville-110456339.455167-82.22565740000001446152303953886-5-1251
21798WVRavenswood-157418938.952922-81.761357304000002179840315467108-5-1251
21855WVWilliamstown-10277439.399574-81.4505583040000029965487556-5-1251
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
21763WVMiddlebourne-1092239.493966-80.90575130400000217638705453572-5-1251
21695WVElizabeth-1090039.062852-81.39552930400000216959945424364-5-1251
39203OHRacine-1072938.969465-81.915296000007463965256-5-1251
38936OHBuchtel-1064039.461269-82.182017000005743909834-5-1251
**** cities in zip3 **************
33 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
26101PARKERSBURGWV21506Parkersburg251
26104PARKERSBURGWV13319Parkersburg251
26105VIENNAWV10329Vienna251
26155NEW MARTINSVILLEWV7052New Martinsville251
26164RAVENSWOODWV6261Ravenswood251
26181WASHINGTONWV5489Washington
26150MINERAL WELLSWV5176Mineral Wells
26187WILLIAMSTOWNWV5122Williamstown251
26170SAINT MARYSWV4566Saint Marys
26143ELIZABETHWV3442Elizabeth251
zipcodezipcityzipstatezippopulationcitynameDMAID
26175SISTERSVILLEWV2371Sistersville
26159PADEN CITYWV2162Paden City
26142DAVISVILLEWV2160
26149MIDDLEBOURNEWV1992Middlebourne251
26184WAVERLYWV1905
26180WALKERWV1790
26147GRANTSVILLEWV1513Grantsville
26133BELLEVILLEWV1159
26146FRIENDLYWV960Friendly
26134BELMONTWV770Belmont
zipcodezipcityzipstatezippopulationcitynameDMAID
26167READERWV724Reader
26169ROCKPORTWV701Rockport
26160PALESTINEWV682
26137BIG SPRINGSWV558
26178SMITHVILLEWV487Smithville
26136BIG BENDWV0
26141CRESTONWV0
26161PETROLEUMWV0
26138BROHARDWV0
26148MACFARLANWV0
zipcodezipcityzipstatezippopulationcitynameDMAID
26152MUNDAYWV0
26151MOUNT ZIONWV0
26162PORTERS FALLSWV0
***** stations in DMA*************
29 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
22706GCN2World Wide WebWW79841
41480GCN3World Wide WebWW79841
41481GCN4World Wide WebWW79841
77684GCN5World Wide WebWW79841
32729MOYLWorld Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
44298NPRWorld Wide WebWW79841
44299PRIWorld Wide WebWW79841
22707Radio AmericaWorld Wide WebWW79841
44583SportsBylineWorld Wide WebWW79841
23558TalkStarWorld Wide WebWW79841
40372TammyRadioWorld Wide WebWW79841
44584TheBlazeWorld Wide WebWW79841
22714USA/IRN3World Wide WebWW79841
44301YSNWorld Wide WebWW79841
Station W300AQ-FX
City SAINT MARYS-WV

City Saint Marys, WV is located in DMAID: