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


Number of rows returned = 0
Start: 1754204421.7428
End: 1754204421.7434
Elapsed time: 0.5820 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('CT','Southport',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80395" ["State"]=> string(2) "CT" ["CityName"]=> string(9) "Southport" ["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) "06890" ["zip3"]=> string(3) "068" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "SOUTHPORT" ["zipstate"]=> string(2) "CT" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "41.14" ["iplongitude"]=> string(6) "-73.28" ["ziplocation"]=> string(18) "NA-US-CT-SOUTHPORT" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "2205" ["zippopulation"]=> string(4) "3874" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "068" ["zipcity"]=> string(7) "NORWALK" ["zipstate"]=> string(2) "CT" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2928" ["State"]=> string(2) "CT" ["CityName"]=> string(7) "Norwalk" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "316" ["Population"]=> string(5) "78331" ["Latitude"]=> string(9) "41.110079" ["Longitude"]=> string(10) "-73.421902" ["PrimaryAC"]=> string(3) "203" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "2928" ["Population2000"]=> string(5) "82951" ["FIPS"]=> string(6) "955990" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "142" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
4 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
2928CTNorwalk03167833141.110079-73.42190220301000292882951955990-5-1142
38457NYBriarcliff Manor-10707041.144033-73.841340000076963608103-5-1142
2889CTGreenwich-114941.308873-73.363661203011102889-5-1142
2917CTNew Canaan013541.147096-73.495366203010002917-5-1142
**** cities in zip3 **************
25 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
06810DANBURYCT35694Danbury196
06824FAIRFIELDCT26855Fairfield120
06811DANBURYCT24956Danbury196
06880WESTPORTCT23735Westport107
06851NORWALKCT22550Norwalk142
06877RIDGEFIELDCT21748Ridgefield196
06854NORWALKCT21479Norwalk142
06830GREENWICHCT19812Greenwich142
06820DARIENCT18239Darien
06840NEW CANAANCT17448New Canaan142
zipcodezipcityzipstatezippopulationcitynameDMAID
06825FAIRFIELDCT16768Fairfield120
06897WILTONCT16501Wilton
06801BETHELCT16312Bethel
06850NORWALKCT15241Norwalk142
06804BROOKFIELDCT14886Brookfield196
06831GREENWICHCT12950Greenwich142
06812NEW FAIRFIELDCT12686New Fairfield
06883WESTONCT9143
06896REDDINGCT7867Redding
06878RIVERSIDECT7019
zipcodezipcityzipstatezippopulationcitynameDMAID
06870OLD GREENWICHCT6308Old Greenwich
06855NORWALKCT6256Norwalk142
06807COS COBCT6107
06890SOUTHPORTCT3874Southport
06853NORWALKCT3224Norwalk142
***** 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 W287AZ-FX
City SOUTHPORT-CT

City Southport, CT is located in DMAID: