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


Number of rows returned = 0
Start: 1754172482.7647
End: 1754172482.7648
Elapsed time: 0.1709 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('ME','Trevett',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80094" ["State"]=> string(2) "ME" ["CityName"]=> string(7) "Trevett" ["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) "04571" ["zip3"]=> string(3) "045" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(7) "TREVETT" ["zipstate"]=> string(2) "ME" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "43.89" ["iplongitude"]=> string(6) "-69.67" ["ziplocation"]=> string(16) "NA-US-ME-TREVETT" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "045" ["zipcity"]=> string(4) "BATH" ["zipstate"]=> string(2) "ME" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "8193" ["State"]=> string(2) "ME" ["CityName"]=> string(4) "Bath" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(1) "4" ["Population"]=> string(4) "9799" ["Latitude"]=> string(9) "43.916293" ["Longitude"]=> string(10) "-69.822565" ["PrimaryAC"]=> string(3) "207" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "8193" ["Population2000"]=> string(4) "9266" ["FIPS"]=> string(7) "2303355" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "167" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
9 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
8348MEPortland02336435843.665116-70.269086207001008348642492360545-5-1167
36277MEAuburn-102430944.089173-70.24143700000232032302060-5-1167
8415MEWestbrook-141612143.685348-70.357116207001008415161422382105-5-1167
8207MEBrunswick0631468343.913035-69.953589207001008207148162308395-5-1167
8193MEBath04979943.916293-69.82256520700100819392662303355-5-1167
8373MESkowhegan-14699044.770308-69.71508720700000837366962368875-5-1167
8260MEGorham-14361843.68064-70.44148920700000826041642328205-5-1167
8367MEScarborough-115258643.59258-70.33360820700100836738672366110-5-1167
12467NHNorth Conway0159203244.051534-71.122752603000001246720693353860-5-1167
**** cities in zip3 **************
28 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
04530BATHME9208Bath167
04572WALDOBOROME4157Waldoboro
04578WISCASSETME3806Wiscasset
04579WOOLWICHME2830
04543DAMARISCOTTAME1996Damariscotta
04537BOOTHBAYME1894
04562PHIPPSBURGME1772
04538BOOTHBAY HARBORME1709Boothbay Harbor267
04553NEWCASTLEME1700
04555NOBLEBOROME1468
zipcodezipcityzipstatezippopulationcitynameDMAID
04574WASHINGTONME1240Washington
04563CUSHINGME1132
04556EDGECOMBME1099
04547FRIENDSHIPME940
04539BRISTOLME909
04548GEORGETOWNME896
04544EAST BOOTHBAYME702
04554NEW HARBORME688New Harbor
04535ALNAME660Alna
04551BREMENME604Bremen
zipcodezipcityzipstatezippopulationcitynameDMAID
04576SOUTHPORTME556
04564ROUND PONDME422Round Pond
04549ISLE OF SPRINGSME0
04541CHAMBERLAINME0
04558PEMAQUIDME0
04568SOUTH BRISTOLME0South Bristol
04571TREVETTME0Trevett
04573WALPOLEME0
***** 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 WGWM-FM
City TREVETT-ME

City Trevett, ME is located in DMAID: