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


Number of rows returned = 0
Start: 1754161394.5378
End: 1754161394.5384
Elapsed time: 0.6049 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('MA','Fairhaven',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79950" ["State"]=> string(2) "MA" ["CityName"]=> string(9) "Fairhaven" ["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) "02719" ["zip3"]=> string(3) "027" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "FAIRHAVEN" ["zipstate"]=> string(2) "MA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "41.63" ["iplongitude"]=> string(5) "-70.9" ["ziplocation"]=> string(18) "NA-US-MA-FAIRHAVEN" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "8024" ["zippopulation"]=> string(5) "13392" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "027" ["zipcity"]=> string(11) "NEW BEDFORD" ["zipstate"]=> string(2) "MA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "7664" ["State"]=> string(2) "MA" ["CityName"]=> string(11) "New Bedford" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "140" ["Population"]=> string(5) "99922" ["Latitude"]=> string(9) "41.651803" ["Longitude"]=> string(10) "-70.933705" ["PrimaryAC"]=> string(3) "508" ["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) "7664" ["Population2000"]=> string(5) "93768" ["FIPS"]=> string(7) "2545000" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "174" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
6 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
7664MANew Bedford01409992241.651803-70.933705508001007664937682545000-5-1174
7513MAAttleboro01073838341.928099-71.314564508001107513420682502690-5-1174
17949RIWest Warwick-102926841.70375-71.51857940100000295814478260-5-1174
36051MASomerset-101765541.748502-71.15318800000182342562465-5-1174
36071MAWest Yarmouth-10540941.649547-70.2463850000064602578795-5-1174
7516MABarnstable0184279041.701418-70.300061508001007516-5-1174
**** cities in zip3 **************
34 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
02780TAUNTONMA39589Taunton11
02703ATTLEBOROMA36164Attleboro174
02740NEW BEDFORDMA28944New Bedford174
02760NORTH ATTLEBOROMA22964North Attleboro
02720FALL RIVERMA22304Fall River36
02745NEW BEDFORDMA19536New Bedford174
02721FALL RIVERMA18264Fall River36
02747NORTH DARTMOUTHMA15533
02766NORTONMA15129Norton
02777SWANSEAMA14102Swansea
zipcodezipcityzipstatezippopulationcitynameDMAID
02790WESTPORTMA13765Westport
02726SOMERSETMA13724Somerset174
02719FAIRHAVENMA13392Fairhaven
02771SEEKONKMA12579Seekonk
02724FALL RIVERMA11903Fall River36
02767RAYNHAMMA11607
02769REHOBOTHMA10452Rehoboth
02723FALL RIVERMA10441Fall River36
02748SOUTH DARTMOUTHMA10032
02743ACUSHNETMA9079
zipcodezipcityzipstatezippopulationcitynameDMAID
02746NEW BEDFORDMA8919New Bedford174
02744NEW BEDFORDMA8050New Bedford174
02762PLAINVILLEMA7456
02718EAST TAUNTONMA5968
02739MATTAPOISETTMA5697Mattapoisett
02779BERKLEYMA5580
02770ROCHESTERMA4715Rochester
02717EAST FREETOWNMA4357
02738MARIONMA4357Marion
02702ASSONETMA3833Assonet
zipcodezipcityzipstatezippopulationcitynameDMAID
02764NORTH DIGHTONMA3638
02715DIGHTONMA2622Dighton
02725SOMERSETMA2190Somerset174
02763ATTLEBORO FALLSMA1856
***** 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 WFHN-FM
City FAIRHAVEN-MA

City Fairhaven, MA is located in DMAID: