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


Number of rows returned = 0
Start: 1754143931.0594
End: 1754143931.06
Elapsed time: 0.5920 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('TN','Madison',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79859" ["State"]=> string(2) "TN" ["CityName"]=> string(7) "Madison" ["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) "37115" ["zip3"]=> string(3) "371" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(7) "MADISON" ["zipstate"]=> string(2) "TN" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "36.25" ["iplongitude"]=> string(6) "-86.69" ["ziplocation"]=> string(16) "NA-US-TN-MADISON" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "16747" ["zippopulation"]=> string(5) "27744" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "371" ["zipcity"]=> string(12) "MURFREESBORO" ["zipstate"]=> string(2) "TN" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "18675" ["State"]=> string(2) "TN" ["CityName"]=> string(12) "Murfreesboro" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(3) "112" ["Population"]=> string(5) "44922" ["Latitude"]=> string(7) "35.8577" ["Longitude"]=> string(10) "-86.394725" ["PrimaryAC"]=> string(3) "615" ["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(5) "18675" ["Population2000"]=> string(5) "68816" ["FIPS"]=> string(7) "4751560" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "44" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
23 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
18676TNNashville040648837436.17155-86.78482961511000186765455244752006-6-144
18675TNMurfreesboro-11124492235.8577-86.3947256150100018675688164751560-6-144
18598TNHendersonville0783218836.300084-86.6061096150100018598406204733280-144
18576TNFranklin01592009835.929074-86.8574026150100018576418424727740-144
18580TNGallatin0881879436.38137-86.4513156150100018580232304728540-144
18628TNLebanon-1651520836.207991-86.32636150100018628202354741520-144
18734TNShelbyville01351404935.488988-86.4523539310000018734161054767760-6-144
18736TNSmyrna-1991364735.979574-86.5211086150100018736255694769420-144
18751TNSpringfield0731122736.499508-86.8787176150000018751143294770500-144
18584TNGoodlettsville0771121936.326968-86.7042856150100018584137804729920-144
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
18654TNMcMinnville-1491119435.686708-85.7793099310000018654127494745100-144
18549TNDickson-162879136.071485-87.3745396150000018549122444720620-144
18643TNManchester-153770935.473337-86.085512931000001864382944745500-6-144
18621TNLa Vergne-10749936.01333-86.56268261500000186874741200-144
7146KYRussellville-1106745436.842601-86.89266127000000714671492167512-6-144
18705TNPortland-160516536.582482-86.515707615000001870584584760280-144
18780TNWaverly-191392536.085847-87.786917931000001878040284778560-144
18735TNSmithville-11379135.957191-85.820756615000001873539944769320-144
41024TNWoodbury-10228735.823644-86.0702680000024284781560-144
18783TNWhite Bluff064198836.107971-87.2203615000001878321424779980-144
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
18677TNNew Johnsonville-125164336.019087-87.967619931000001867719054752820-144
18750TNSpring Hill-153146435.752556-86.914021931000001875077154770580-144
40982TNPegram-10137136.101626-87.0516640000021464757480-144
**** cities in zip3 **************
45 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
37167SMYRNATN40372Smyrna44
37129MURFREESBOROTN39668Murfreesboro44
37122MOUNT JULIETTN39644Mount Juliet
37130MURFREESBOROTN34702Murfreesboro44
37128MURFREESBOROTN33173Murfreesboro44
37115MADISONTN27744Madison
37160SHELBYVILLETN25170Shelbyville44
37172SPRINGFIELDTN23898Springfield44
37110MCMINNVILLETN23490McMinnville44
37174SPRING HILLTN22942Spring Hill44
zipcodezipcityzipstatezippopulationcitynameDMAID
37138OLD HICKORYTN19305Old Hickory
37148PORTLANDTN18152Portland44
37127MURFREESBOROTN13028Murfreesboro44
37188WHITE HOUSETN11999White House
37166SMITHVILLETN10335Smithville44
37179THOMPSONS STATIONTN9353
37135NOLENSVILLETN7720Nolensville
37186WESTMORELANDTN7280Westmoreland
37190WOODBURYTN6711Woodbury44
37185WAVERLYTN6660Waverly44
zipcodezipcityzipstatezippopulationcitynameDMAID
37146PLEASANT VIEWTN6155Pleasant View
37187WHITE BLUFFTN5633White Bluff44
37101MC EWENTN5110
37184WATERTOWNTN4610Watertown
37153ROCKVALETN4334
37150RED BOILING SPRINGSTN3646Red Boiling Springs
37143PEGRAMTN3423Pegram44
37191WOODLAWNTN3386
37189WHITES CREEKTN2745
37144PETERSBURGTN2674Petersburg
zipcodezipcityzipstatezippopulationcitynameDMAID
37134NEW JOHNSONVILLETN2664New Johnsonville44
37183WARTRACETN2544Wartrace
37180UNIONVILLETN2506Unionville
37137NUNNELLYTN2055
37145PLEASANT SHADETN1853Pleasant Shade
37149READYVILLETN1819
37178TENNESSEE RIDGETN1636Tennessee Ridge
37142PALMYRATN1428Palmyra
37181VANLEERTN1127Vanleer
37118MILTONTN1040
zipcodezipcityzipstatezippopulationcitynameDMAID
37141ORLINDATN918Orlinda
37171SOUTHSIDETN817
37175STEWARTTN737
37140ONLYTN0
37151RIDDLETONTN0
***** stations in DMA*************
29 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
22706GCN2World Wide WebWW79841
41480GCN3World Wide WebWW79841
41481GCN4World Wide WebWW79841
77684GCN5World Wide WebWW79841
32729MOYLWorld Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
44298NPRWorld Wide WebWW79841
44299PRIWorld Wide WebWW79841
22707Radio AmericaWorld Wide WebWW79841
44583SportsBylineWorld Wide WebWW79841
23558TalkStarWorld Wide WebWW79841
40372TammyRadioWorld Wide WebWW79841
44584TheBlazeWorld Wide WebWW79841
22714USA/IRN3World Wide WebWW79841
44301YSNWorld Wide WebWW79841
Station WYGI-AM
City MADISON-TN

City Madison, TN is located in DMAID: