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


Number of rows returned = 0
Start: 1754167967.5546
End: 1754167967.5549
Elapsed time: 0.2880 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "79991" ["State"]=> string(2) "ME" ["CityName"]=> string(10) "Monticello" ["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) "04760" ["zip3"]=> string(3) "047" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "MONTICELLO" ["zipstate"]=> string(2) "ME" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(4) "46.3" ["iplongitude"]=> string(6) "-67.84" ["ziplocation"]=> string(19) "NA-US-ME-MONTICELLO" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "344" ["zippopulation"]=> string(3) "624" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "047" ["zipcity"]=> string(7) "CARIBOU" ["zipstate"]=> string(2) "ME" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "8215" ["State"]=> string(2) "ME" ["CityName"]=> string(7) "Caribou" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(2) "33" ["Population"]=> string(4) "9415" ["Latitude"]=> string(9) "46.863559" ["Longitude"]=> string(10) "-67.997992" ["PrimaryAC"]=> string(3) "207" ["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(4) "8215" ["Population2000"]=> string(4) "8312" ["FIPS"]=> string(7) "2310565" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
37 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
04736CARIBOUME7868Caribou
04769PRESQUE ISLEME7779Presque Isle
04730HOULTONME7648Houlton
04743FORT KENTME3621Fort Kent
04756MADAWASKAME3053Madawaska
04742FORT FAIRFIELDME2739Fort Fairfield
04757MAPLETONME2246
04785VAN BURENME1796Van Buren
04750LIMESTONEME1634Limestone
04732ASHLANDME1375Ashland
zipcodezipcityzipstatezippopulationcitynameDMAID
04786WASHBURNME1370Washburn
04758MARS HILLME1323Mars Hill
04740EASTONME1028Easton
04765PATTENME987Patten
04747ISLAND FALLSME934Island Falls
04745FRENCHVILLEME882
04739EAGLE LAKEME737Eagle Lake
04776SHERMANME719
04763OAKFIELDME639
04772SAINT AGATHAME639
zipcodezipcityzipstatezippopulationcitynameDMAID
04760MONTICELLOME624Monticello
04773SAINT DAVIDME581
04780SMYRNA MILLSME573Smyrna Mills
04774SAINT FRANCISME519
04762NEW SWEDENME480New Sweden
04735BRIDGEWATERME463
04781WALLAGRASSME451
04733BENEDICTAME0
04737CLAYTON LAKEME0
04746GRAND ISLEME0Grand Isle
zipcodezipcityzipstatezippopulationcitynameDMAID
04764OXBOWME0
04766PERHAMME0
04768PORTAGEME0
04777STACYVILLEME0
04779SINCLAIRME0
04783STOCKHOLMME0
04787WESTFIELDME0
***** 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 W252DW-FX
City MONTICELLO-ME

City Monticello, ME is located in DMAID: