Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix K240CD Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9998" ["dmaType"]=> NULL ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(7) "Unrated" ["Population25up"]=> string(1) "0" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(0) "" }
Database: media
SQL: select * from cities where CityName = 'SOQUEL' and State = 'CA'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 1
Start: 1754167387.7396
End: 1754167387.7401
Elapsed time: 0.4981 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
33191CASoquel-10918836.986991-121.945636000005081672688-8-14

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "95073" ["zip3"]=> string(3) "950" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "SOQUEL" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "37.02" ["iplongitude"]=> string(7) "-121.94" ["ziplocation"]=> string(15) "NA-US-CA-SOQUEL" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "5537" ["zippopulation"]=> string(4) "9169" ["zipincome"]=> string(7) "8388607" }
******* 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
2580CAWatsonville03333109936.920054-121.76372583100010258044265683668-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
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
1772CABoulder Creek-1320672537.131487-122.1243988310001017724081607652-8-14
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
**** cities in zip3 **************
34 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
95076WATSONVILLECA63437Watsonville4
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
Station K240CD-FX
City SOQUEL-CA

City , is located in DMAID: