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


Number of rows returned = 0
Start: 1754176365.4684
End: 1754176365.4685
Elapsed time: 0.1271 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('PA','Monroeville',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80118" ["State"]=> string(2) "PA" ["CityName"]=> string(11) "Monroeville" ["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) "15146" ["zip3"]=> string(3) "151" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(11) "MONROEVILLE" ["zipstate"]=> string(2) "PA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "40.42" ["iplongitude"]=> string(6) "-79.76" ["ziplocation"]=> string(20) "NA-US-PA-MONROEVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "15256" ["zippopulation"]=> string(5) "25238" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "151" ["zipcity"]=> string(10) "CORAOPOLIS" ["zipstate"]=> string(2) "PA" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "16896" ["State"]=> string(2) "PA" ["CityName"]=> string(10) "Coraopolis" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "115" ["Population"]=> string(4) "6747" ["Latitude"]=> string(9) "40.515818" ["Longitude"]=> string(10) "-80.162791" ["PrimaryAC"]=> string(3) "412" ["ZoneDesc"]=> string(16) "Pittsburgh SZ 15" ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "1" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "16896" ["Population2000"]=> string(4) "6131" ["FIPS"]=> string(7) "4216144" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
28 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
15108CORAOPOLISPA33662Coraopolis
15102BETHEL PARKPA27708Bethel Park
15146MONROEVILLEPA25238Monroeville
15101ALLISON PARKPA22275
15136MC KEES ROCKSPA18467
15122WEST MIFFLINPA17458West Mifflin
15143SEWICKLEYPA17301Sewickley
15120HOMESTEADPA15584Homestead
15106CARNEGIEPA15580Carnegie
15132MCKEESPORTPA14701McKeesport23
zipcodezipcityzipstatezippopulationcitynameDMAID
15147VERONAPA14492Verona
15116GLENSHAWPA13658Glenshaw
15129SOUTH PARKPA9928
15137NORTH VERSAILLESPA8495North Versailles
15131MCKEESPORTPA7359McKeesport23
15126IMPERIALPA6190Imperial
15104BRADDOCKPA6149Braddock23
15145TURTLE CREEKPA5751Turtle Creek
15133MCKEESPORTPA5683McKeesport23
15139OAKMONTPA5477Oakmont
zipcodezipcityzipstatezippopulationcitynameDMAID
15135MCKEESPORTPA4498McKeesport23
15144SPRINGDALEPA3641Springdale
15110DUQUESNEPA3560Duquesne
15112EAST PITTSBURGHPA2523East Pittsburgh
15140PITCAIRNPA2420Pitcairn
15148WILMERDINGPA1898Wilmerding
15142PRESTOPA1732
15123WEST MIFFLINPA0West Mifflin
***** 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 W248AR-FX
City MONROEVILLE-PA

City Monroeville, PA is located in DMAID: