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


Number of rows returned = 0
Start: 1754170244.2484
End: 1754170244.2486
Elapsed time: 0.1760 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80062" ["State"]=> string(2) "CA" ["CityName"]=> string(6) "Scotia" ["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) "95565" ["zip3"]=> string(3) "955" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "SCOTIA" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "40.42" ["iplongitude"]=> string(7) "-124.01" ["ziplocation"]=> string(15) "NA-US-CA-SCOTIA" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "447" ["zippopulation"]=> string(3) "853" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "955" ["zipcity"]=> string(6) "EUREKA" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "1927" ["State"]=> string(2) "CA" ["CityName"]=> string(6) "Eureka" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "384" ["Population"]=> string(5) "27025" ["Latitude"]=> string(9) "40.790022" ["Longitude"]=> string(11) "-124.162752" ["PrimaryAC"]=> string(3) "707" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "1" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "1927" ["Population2000"]=> string(5) "26128" ["FIPS"]=> string(6) "623042" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
39 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
95503EUREKACA16695Eureka
95501EUREKACA14321Eureka
95531CRESCENT CITYCA14062Crescent City
95519MCKINLEYVILLECA12766McKinleyville
95521ARCATACA10982Arcata
95540FORTUNACA9910Fortuna
95536FERNDALECA2338Ferndale
95562RIO DELLCA2147Rio Dell
95570TRINIDADCA1922Trinidad
95546HOOPACA1777Hoopa
zipcodezipcityzipstatezippopulationcitynameDMAID
95524BAYSIDECA1740
95560REDWAYCA1680Redway
95567SMITH RIVERCA1663Smith River
95542GARBERVILLECA1468Garberville
95525BLUE LAKECA1405Blue Lake
95573WILLOW CREEKCA1299Willow Creek
95551LOLETACA1088Loleta
95547HYDESVILLECA1029Hydesville
95565SCOTIACA853Scotia
95528CARLOTTACA754
zipcodezipcityzipstatezippopulationcitynameDMAID
95548KLAMATHCA716Klamath
95589WHITETHORNCA712Whitethorn
95549KNEELANDCA635
95543GASQUETCA494
95511ALDERPOINTCA0
95514BLOCKSBURGCA0
95526BRIDGEVILLECA0Bridgeville
95527BURNT RANCHCA0
95550KORBELCA0
95585LEGGETTCA0Leggett
zipcodezipcityzipstatezippopulationcitynameDMAID
95552MAD RIVERCA0Mad River
95554MYERS FLATCA0
95555ORICKCA0Orick
95568SOMES BARCA0Somes Bar
95558PETROLIACA0Petrolia
95587PIERCYCA0Piercy
95569REDCRESTCA0
95564SAMOACA0
95595ZENIACA0
***** 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 K295CU-FX
City SCOTIA-CA

City Scotia, CA is located in DMAID: