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


Number of rows returned = 0
Start: 1754169183.8091
End: 1754169183.8094
Elapsed time: 0.3018 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('VT','Colchester',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80042" ["State"]=> string(2) "VT" ["CityName"]=> string(10) "Colchester" ["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) "05446" ["zip3"]=> string(3) "054" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "COLCHESTER" ["zipstate"]=> string(2) "VT" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "44.53" ["iplongitude"]=> string(6) "-73.15" ["ziplocation"]=> string(19) "NA-US-VT-COLCHESTER" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "8233" ["zippopulation"]=> string(5) "13766" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "054" ["zipcity"]=> string(10) "BURLINGTON" ["zipstate"]=> string(2) "VT" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "20610" ["State"]=> string(2) "VT" ["CityName"]=> string(10) "Burlington" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "225" ["Population"]=> string(5) "39127" ["Latitude"]=> string(9) "44.484748" ["Longitude"]=> string(10) "-73.223157" ["PrimaryAC"]=> string(3) "802" ["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(5) "20610" ["Population2000"]=> string(5) "38889" ["FIPS"]=> string(7) "5010675" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "136" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
12 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20610VTBurlington02253912744.484748-73.2231578020010020610388895010675-5-1136
41792VTSouth Burlington-101280944.451846-73.1817100000158145066175-5-1136
13587NYMalone047677744.850676-74.28907518000001358760753644710-5-1136
13826NYSaranac Lake0102537744.325988-74.130944518000001382650413665233-5-1136
20713VTVergennes-127257844.16564-73.252224802000002071327415074650-5-1136
13810NYRouses Point-10237744.987531-73.367634518000001381022773663979-5-1136
20708VTSwanton-182236044.919738-73.12099802000002070825485071650-5-1136
20608VTBristol-11180144.136545-73.0809348020000020608-5-1136
13770NYPort Henry-15126344.045238-73.461011518000001377011523659333-5-1136
13960NYWestport-1053944.178786-73.4360515180000013960-5-1136
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20707VTStowe-110145044.465934-72.6856818020000020707-5-1136
13969NYWillsboro-1385180000013969-5-1136
**** cities in zip3 **************
44 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
05452ESSEX JUNCTIONVT17705Essex Junction
05401BURLINGTONVT16845Burlington136
05403SOUTH BURLINGTONVT15655South Burlington136
05446COLCHESTERVT13766Colchester
05478SAINT ALBANSVT12191
05468MILTONVT11914Milton
05495WILLISTONVT9087
05408BURLINGTONVT8454Burlington136
05482SHELBURNEVT6810
05488SWANTONVT6347Swanton136
zipcodezipcityzipstatezippopulationcitynameDMAID
05443BRISTOLVT5546Bristol136
05404WINOOSKIVT5309Winooski
05465JERICHOVT5143Jericho
05491VERGENNESVT5045Vergennes136
05461HINESBURGVT4309Hinesburg
05450ENOSBURG FALLSVT4192Enosburg Falls
05454FAIRFAXVT4130Fairfax
05477RICHMONDVT4027Richmond
05445CHARLOTTEVT3516Charlotte
05489UNDERHILLVT2816Underhill
zipcodezipcityzipstatezippopulationcitynameDMAID
05464JEFFERSONVILLEVT2441Jeffersonville
05476RICHFORDVT2173Richford
05458GRAND ISLEVT1905Grand Isle180
05440ALBURGHVT1781
05462HUNTINGTONVT1733
05459HIGHGATE CENTERVT1704
05472NEW HAVENVT1669
05486SOUTH HEROVT1619
05444CAMBRIDGEVT1600Cambridge
05494WESTFORDVT1555
zipcodezipcityzipstatezippopulationcitynameDMAID
05457FRANKLINVT1336Franklin
05487STARKSBOROVT1323
05473NORTH FERRISBURGHVT1242
05483SHELDONVT1194
05456FERRISBURGHVT1108
05455FAIRFIELDVT1037
05448EAST FAIRFIELDVT962East Fairfield
05474NORTH HEROVT757
05492WATERVILLEVT688
05471MONTGOMERY CENTERVT653
zipcodezipcityzipstatezippopulationcitynameDMAID
05441BAKERSFIELDVT602
05463ISLE LA MOTTEVT452Isle La Motte
05447EAST BERKSHIREVT0
05442BELVIDERE CENTERVT0
***** 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 W242BK-FX
City COLCHESTER-VT

City Colchester, VT is located in DMAID: