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


Number of rows returned = 0
Start: 1754204292.6157
End: 1754204292.616
Elapsed time: 0.2482 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80392" ["State"]=> string(2) "PA" ["CityName"]=> string(7) "Rockton" ["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) "15856" ["zip3"]=> string(3) "158" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(7) "ROCKTON" ["zipstate"]=> string(2) "PA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "41.08" ["iplongitude"]=> string(6) "-78.66" ["ziplocation"]=> string(16) "NA-US-PA-ROCKTON" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "447" ["zippopulation"]=> string(3) "794" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "158" ["zipcity"]=> string(7) "DU BOIS" ["zipstate"]=> string(2) "PA" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "16463" ["State"]=> string(2) "PA" ["CityName"]=> string(7) "Du Bois" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "0" ["Population"]=> string(4) "8286" ["Latitude"]=> string(9) "41.122304" ["Longitude"]=> string(10) "-78.755786" ["PrimaryAC"]=> string(3) "814" ["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"]=> NULL ["FIPS"]=> NULL ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
27 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
15801DU BOISPA16630Du Bois
15857SAINT MARYSPA12039
15825BROOKVILLEPA8168Brookville210
15853RIDGWAYPA5800Ridgway
15851REYNOLDSVILLEPA5665Reynoldsville
15824BROCKWAYPA4522Brockway
15834EMPORIUMPA3962Emporium
15846KERSEYPA2950Kersey
15845JOHNSONBURGPA2861Johnsonburg210
15840FALLS CREEKPA1691Falls Creek
zipcodezipcityzipstatezippopulationcitynameDMAID
15864SUMMERVILLEPA1615Summerville
15823BROCKPORTPA1310
15868WEEDVILLEPA1254Weedville
15849PENFIELDPA1195Penfield
15870WILCOXPA1150Wilcox
15829CORSICAPA1115Corsica
15860SIGELPA999Sigel
15865SYKESVILLEPA976Sykesville
15848LUTHERSBURGPA904Luthersburg
15856ROCKTONPA794Rockton
zipcodezipcityzipstatezippopulationcitynameDMAID
15821BENEZETTPA0
15828CLARINGTONPA0
15827BYRNEDALEPA0
15832DRIFTWOODPA0Driftwood
15866TROUTVILLEPA0Troutville
15822BRANDY CAMPPA0
15861SINNAMAHONINGPA0
***** 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 W244CH-FX
City ROCKTON-PA

City Rockton, PA is located in DMAID: