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


Number of rows returned = 0
Start: 1754171652.4691
End: 1754171652.4697
Elapsed time: 0.6521 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80081" ["State"]=> string(2) "CT" ["CityName"]=> string(9) "Montville" ["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) "06353" ["zip3"]=> string(3) "063" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "MONTVILLE" ["zipstate"]=> string(2) "CT" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "41.44" ["iplongitude"]=> string(6) "-72.12" ["ziplocation"]=> string(18) "NA-US-CT-MONTVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "260" ["zippopulation"]=> string(3) "407" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "063" ["zipcity"]=> string(7) "NORWICH" ["zipstate"]=> string(2) "CT" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2929" ["State"]=> string(2) "CT" ["CityName"]=> string(7) "Norwich" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "310" ["Population"]=> string(5) "37391" ["Latitude"]=> string(9) "41.539748" ["Longitude"]=> string(10) "-72.082088" ["PrimaryAC"]=> string(3) "860" ["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) "2929" ["Population2000"]=> string(5) "36117" ["FIPS"]=> string(6) "956200" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "171" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
9 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
2929CTNorwich03103739141.539748-72.08208886000000292936117956200-5-1171
2920CTNew London01802854041.352498-72.10338986000000292025671952280-5-1171
2890CTGroton00983741.345231-72.073448600000010010934180-5-1171
2933CTPawcatuck-10528941.37458-71.8448518600000029335474959140-5-1171
33427CTMoosup-10328941.715942-71.881241000003237949180-5-1171
13625NYMontauk040300141.03831-71.950608631001001362538513648054-5-1171
33448CTStonington-10110041.334532-71.904514000001032973700-5-1171
2903CTLedyard03141.492843-71.965554860000002903-5-1171
17918RIBlock Island013541.188888-71.5776964010000017918-5-1171
**** cities in zip3 **************
27 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
06360NORWICHCT29516Norwich171
06340GROTONCT22778Groton171
06320NEW LONDONCT19438New London171
06385WATERFORDCT14516
06351JEWETT CITYCT13771Jewett City
06355MYSTICCT11444Mystic
06357NIANTICCT9545Niantic
06382UNCASVILLECT8952
06371OLD LYMECT8646
06379PAWCATUCKCT7620Pawcatuck171
zipcodezipcityzipstatezippopulationcitynameDMAID
06339LEDYARDCT7346Ledyard171
06370OAKDALECT6678
06374PLAINFIELDCT6454
06333EAST LYMECT6255
06335GALES FERRYCT6197
06378STONINGTONCT4885Stonington171
06359NORTH STONINGTONCT4802
06354MOOSUPCT4561Moosup171
06331CANTERBURYCT4503Canterbury
06365PRESTONCT4233
zipcodezipcityzipstatezippopulationcitynameDMAID
06375QUAKER HILLCT3297
06384VOLUNTOWNCT2429
06330BALTICCT2420Baltic
06377STERLINGCT2279
06380TAFTVILLECT2072
06353MONTVILLECT407Montville
06336GILMANCT0
***** 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 W269ED-FX
City MONTVILLE-CT

City Montville, CT is located in DMAID: