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


Number of rows returned = 0
Start: 1754144735.6365
End: 1754144735.6407
Elapsed time: 4.1740 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "79880" ["State"]=> string(2) "CA" ["CityName"]=> string(9) "Glenhaven" ["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) "95443" ["zip3"]=> string(3) "954" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "GLENHAVEN" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "39.04" ["iplongitude"]=> string(7) "-122.74" ["ziplocation"]=> string(18) "NA-US-CA-GLENHAVEN" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "954" ["zipcity"]=> string(10) "SANTA ROSA" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2439" ["State"]=> string(2) "CA" ["CityName"]=> string(10) "Santa Rosa" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "499" ["Population"]=> string(6) "113313" ["Latitude"]=> string(9) "38.448611" ["Longitude"]=> string(11) "-122.704646" ["PrimaryAC"]=> string(3) "707" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "1" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "2439" ["Population2000"]=> string(6) "147595" ["FIPS"]=> string(6) "670098" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
60 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
95403SANTA ROSACA33257Santa Rosa
95404SANTA ROSACA29799Santa Rosa
95407SANTA ROSACA26764Santa Rosa
95401SANTA ROSACA26704Santa Rosa
95476SONOMACA24893Sonoma118
95492WINDSORCA23814Windsor118
95482UKIAHCA21879Ukiah118
95409SANTA ROSACA21790Santa Rosa
95472SEBASTOPOLCA21680Sebastopol118
95405SANTA ROSACA18155Santa Rosa
zipcodezipcityzipstatezippopulationcitynameDMAID
95448HEALDSBURGCA14838Healdsburg118
95437FORT BRAGGCA11000Fort Bragg
95490WILLITSCA9434Willits118
95425CLOVERDALECA8841Cloverdale118
95451KELSEYVILLECA8100Kelseyville
95453LAKEPORTCA7976Lakeport118
95422CLEARLAKECA7530Clearlake
95470REDWOOD VALLEYCA4791
95436FORESTVILLECA4585Forestville
95467HIDDEN VALLEY LAKECA3858Hidden Valley Lake
zipcodezipcityzipstatezippopulationcitynameDMAID
95446GUERNEVILLECA3558Guerneville118
95461MIDDLETOWNCA2984Middletown118
95442GLEN ELLENCA2862Glen Ellen
95457LOWER LAKECA2786Lower Lake
95423CLEARLAKE OAKSCA2370Clearlake Oaks
95441GEYSERVILLECA2362Geyserville
95460MENDOCINOCA2343Mendocino118
95445GUALALACA2247Gualala118
95485UPPER LAKECA1933Upper Lake
95465OCCIDENTALCA1774Occidental
zipcodezipcityzipstatezippopulationcitynameDMAID
95454LAYTONVILLECA1687Laytonville118
95458LUCERNECA1687Lucerne
95452KENWOODCA1581Kenwood
95464NICECA1536Nice
95469POTTER VALLEYCA1399Potter Valley
95449HOPLANDCA1330Hopland
95428COVELOCA1328Covelo118
95415BOONVILLECA1236Boonville
95444GRATONCA1154Graton
95466PHILOCA1058
zipcodezipcityzipstatezippopulationcitynameDMAID
95421CAZADEROCA1034Cazadero118
95468POINT ARENACA978Point Arena
95439FULTONCA838
95462MONTE RIOCA836Monte Rio4
95410ALBIONCA676
95456LITTLE RIVERCA540
95412ANNAPOLISCA0Annapolis
95427COMPTCHECA0
95432ELKCA0Elk
95420CASPARCA0
zipcodezipcityzipstatezippopulationcitynameDMAID
95488WESTPORTCA0
95443GLENHAVENCA0Glenhaven
95450JENNERCA0
95417BRANSCOMBCA0
95459MANCHESTERCA0
95463NAVARROCA0
95480STEWARTS POINTCA0
95493WITTER SPRINGSCA0
95429DOS RIOSCA0
95494YORKVILLECA0
***** 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 KEDR-FM
City GLENHAVEN-CA

City Glenhaven, CA is located in DMAID: