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


Number of rows returned = 0
Start: 1754161299.975
End: 1754161299.9756
Elapsed time: 0.5660 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('CA','Edison',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79948" ["State"]=> string(2) "CA" ["CityName"]=> string(6) "Edison" ["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) "93220" ["zip3"]=> string(3) "932" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(6) "EDISON" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "35.32" ["iplongitude"]=> string(7) "-118.85" ["ziplocation"]=> string(15) "NA-US-CA-EDISON" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "932" ["zipcity"]=> string(7) "VISALIA" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2568" ["State"]=> string(2) "CA" ["CityName"]=> string(7) "Visalia" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "365" ["Population"]=> string(5) "75636" ["Latitude"]=> string(7) "36.3241" ["Longitude"]=> string(11) "-119.307347" ["PrimaryAC"]=> string(3) "559" ["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) "2568" ["Population2000"]=> string(5) "91565" ["FIPS"]=> string(6) "682954" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "101" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
19 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
2568CAVisalia03657563636.3241-119.30734755900000256891565682954-8-1101
2543CATulare03063324936.206601-119.34240455900000254343994680644-8-1101
1988CAHanford03393089736.333273-119.64688955900000198841686631960-8-1101
2339CAPorterville03412956336.06855-119.02753655900000233939615658240-8-1101
2103CALemoore03321362236.303874-119.78644955900000210319712641152-8-1101
1853CACorcoran02551336436.096018-119.5644855900000185314458616224-8-1101
33069CALamont-101151735.261102-118.913320000013296640088-8-1101
1721CAAvenal0329977036.025086-120.12060555900000172114674603302-8-1101
2110CALindsay0234833836.207172-119.0888155900000211010297641712-8-1101
1928CAExeter0277727636.294213-119.1427465590000019289168623126-8-1101
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
1902CAEarlimart0350588135.882551-119.2698666610000019026583620438-8-1101
2023CAHuron0323476636.203054-120.0997435590000020236306636084-8-1101
33259CAWofford Heights-10227035.709182-118.463835000002276686174-8-1101
33010CAFrazier Park-10220134.822242-118.948251000002348625534-8-1101
2529CATipton0302138336.059115-119.3104095590000025291790678750-8-1101
1788CAButtonwillow0292130135.40906-119.442916610000017881266609332-8-1101
2153CALost Hills-1275121235.614199-119.6892476610000021531938644280-8-1101
2167CAMaricopa-10119335.058276-119.401164661000001111645736-8-1101
68243CAKettleman City0036.00865-119.96288500000001499638394-8-1101
**** cities in zip3 **************
54 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
93257PORTERVILLECA46960Porterville101
93274TULARECA46216Tulare101
93230HANFORDCA45031Hanford101
93277VISALIACA36340Visalia101
93291VISALIACA33290Visalia101
93215DELANOCA29597Delano81
93292VISALIACA26810Visalia101
93245LEMOORECA26596Lemoore101
93203ARVINCA14589Arvin81
93280WASCOCA14256Wasco81
zipcodezipcityzipstatezippopulationcitynameDMAID
93263SHAFTERCA12989Shafter81
93247LINDSAYCA11680Lindsay101
93241LAMONTCA11327Lamont101
93221EXETERCA10596Exeter101
93268TAFTCA10210Taft81
93210COALINGACA9762Coalinga
93212CORCORANCA9472Corcoran101
93250MC FARLANDCA8129
93219EARLIMARTCA6744Earlimart101
93223FARMERSVILLECA6716Farmersville
zipcodezipcityzipstatezippopulationcitynameDMAID
93204AVENALCA6674Avenal101
93286WOODLAKECA6406Woodlake66
93270TERRA BELLACA4678Terra Bella
93234HURONCA4538Huron101
93267STRATHMORECA4456Strathmore
93240LAKE ISABELLACA4066Lake Isabella81
93225FRAZIER PARKCA3778Frazier Park101
93256PIXLEYCA3390Pixley
93235IVANHOECA3130Ivanhoe
93202ARMONACA3054Armona
zipcodezipcityzipstatezippopulationcitynameDMAID
93265SPRINGVILLECA3031Springville
93272TIPTONCA2780Tipton101
93242LATONCA2736Laton
93249LOST HILLSCA2120Lost Hills101
93271THREE RIVERSCA1879Three Rivers
93206BUTTONWILLOWCA1766Buttonwillow101
93285WOFFORD HEIGHTSCA1528Wofford Heights101
93238KERNVILLECA1354Kernville81
93205BODFISHCA1286Bodfish
93266STRATFORDCA1255Stratford
zipcodezipcityzipstatezippopulationcitynameDMAID
93239KETTLEMAN CITYCA1229Kettleman City101
93283WELDONCA1178Weldon
93243LEBECCA1151Lebec
93252MARICOPACA1110Maricopa101
93254NEW CUYAMACA626
93207CALIFORNIA HOT SPRINGSCA0California Hot Springs
93224FELLOWSCA0Fellows
93226GLENNVILLECA0Glennville
93244LEMON COVECA0Lemon Cove
93251MC KITTRICKCA0
zipcodezipcityzipstatezippopulationcitynameDMAID
93255ONYXCA0Onyx
93260POSEYCA0
93262SEQUOIA NATIONAL PARKCA0
93287WOODYCA0
***** 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 K285GG-FX
City EDISON-CA

City Edison, CA is located in DMAID: