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


Number of rows returned = 0
Start: 1754183695.2833
End: 1754183695.2836
Elapsed time: 0.2048 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80292" ["State"]=> string(2) "CA" ["CityName"]=> string(6) "Coyote" ["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) "95013" ["zip3"]=> string(3) "950" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(6) "COYOTE" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(4) "37.2" ["iplongitude"]=> string(7) "-121.72" ["ziplocation"]=> string(15) "NA-US-CA-COYOTE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "950" ["zipcity"]=> string(11) "SANTA CLARA" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2431" ["State"]=> string(2) "CA" ["CityName"]=> string(11) "Santa Clara" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(1) "0" ["Population"]=> string(5) "93613" ["Latitude"]=> string(9) "37.354441" ["Longitude"]=> string(11) "-121.969119" ["PrimaryAC"]=> string(3) "408" ["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"]=> NULL ["Population2000"]=> string(6) "102361" ["FIPS"]=> string(6) "669084" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> string(1) "4" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
29 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
2401CASan Francisco059372395937.759881-122.437392415110102401776733667000-8-14
2507CASunnyvale041211722937.371991-122.02602408010102507131760677000-8-14
2431CASanta Clara009361337.354441-121.96911940800000102361669084-8-14
2420CASan Mateo05328548637.554286-122.31304465001010242092482668252-8-14
1689CAAlameda04507645937.763971-122.2568151001010168972259600562-8-14
2555CAVacaville04617147938.35381-121.97268370700010255588625681554-8-14
2219CAMountain View04066746037.39264-122.08202365001010221970708649670-8-14
2113CALivermore04825674137.685496-121.76409692501010211373345641992-8-14
2246CANorth Highlands-104210538.673003-121.3726989160000044187651924-8-14
32958CACupertino-104026337.317492-122.0419490000050546617610-8-14
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
2605CAWoodland03423980238.674054-121.77249853000010260549151686328-8-14
1967CAGilroy03523148737.012048-121.5800840801010196741464629504-8-14
2587CAWest Sacramento002889838.571105-121.539179160000031615684816-8-14
2150CALos Gatos03612735737.236044-121.96176840801010215028592644112-8-14
33137CAPiedmont-101060237.821994-122.2314050000010952656938-8-14
2370CARio Linda0348948138.690252-121.45381491601010237010466660942-8-14
33191CASoquel-10918836.986991-121.945636000005081672688-8-14
1959CAGalt0355888938.260842-121.30312255900000195919472628112-8-14
32897CAAtherton-10716337.458615-122.200099000007194603092-8-14
1772CABoulder Creek-1320672537.131487-122.1243988310001017724081607652-8-14
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
1936CAFelton0289535037.051498-122.0557538310001019361051623826-8-14
2215CAMoss Beach0256300237.52524-122.5128116500001022151953649446-8-14
2510CASutter Creek0343183538.389652-120.8048282090000025102303677392-8-14
2419CASan Martin0348171337.087746-121.600024080001024194230668238-8-14
2204CAMonte Rio039105838.470406-123.0137537070000022041104648928-8-14
68164CABerkeley0037.871775-122.2746030000000102743606000-8-14
68282CAOakland0037.795227-122.2281110000000399484653000-8-14
2309CAPescadero040637.211194-122.343782650000102309-8-14
80076CAColoma-104
**** cities in zip3 **************
34 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
95076WATSONVILLECA63437Watsonville
95035MILPITASCA54420Milpitas
95014CUPERTINOCA51349Cupertino4
95051SANTA CLARACA45397Santa Clara4
95020GILROYCA41952Gilroy4
95008CAMPBELLCA36168Campbell
95023HOLLISTERCA35971Hollister79
95037MORGAN HILLCA35452Morgan Hill34
95060SANTA CRUZCA29968Santa Cruz79
95070SARATOGACA29525Saratoga
zipcodezipcityzipstatezippopulationcitynameDMAID
95050SANTA CLARACA26714Santa Clara4
95062SANTA CRUZCA26530Santa Cruz79
95032LOS GATOSCA21990Los Gatos4
95054SANTA CLARACA20797Santa Clara4
95003APTOSCA18954Aptos
95066SCOTTS VALLEYCA11926Scotts Valley
95030LOS GATOSCA11508Los Gatos4
95073SOQUELCA9169Soquel4
95012CASTROVILLECA8542Castroville
95010CAPITOLACA7918Capitola
zipcodezipcityzipstatezippopulationcitynameDMAID
95033LOS GATOSCA7196Los Gatos4
95006BOULDER CREEKCA7182Boulder Creek4
95019FREEDOMCA7068Freedom79
95065SANTA CRUZCA6525Santa Cruz79
95018FELTONCA6114Felton4
95046SAN MARTINCA5514San Martin4
95005BEN LOMONDCA5137Ben Lomond
95004AROMASCA3420Aromas
95045SAN JUAN BAUTISTACA3345San Juan Bautista
95039MOSS LANDINGCA1267Moss Landing
zipcodezipcityzipstatezippopulationcitynameDMAID
95064SANTA CRUZCA890Santa Cruz79
95017DAVENPORTCA718
95075TRES PINOSCA603Tres Pinos
95043PAICINESCA494
***** 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 K281BL-FX
City COYOTE-CA

City Coyote, CA is located in DMAID: