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


Number of rows returned = 1
Start: 1754170012.8344
End: 1754170012.835
Elapsed time: 0.5698 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
68282CAOakland0037.795227-122.2281110000000399484653000-8-14

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "94601" ["zip3"]=> string(3) "946" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(7) "OAKLAND" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "37.77" ["iplongitude"]=> string(7) "-122.21" ["ziplocation"]=> string(16) "NA-US-CA-OAKLAND" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "18572" ["zippopulation"]=> string(5) "33456" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "946" ["zipcity"]=> string(7) "OAKLAND" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "68282" ["State"]=> string(2) "CA" ["CityName"]=> string(7) "Oakland" ["RuralArea"]=> NULL ["PopCount"]=> string(1) "0" ["Population"]=> string(1) "0" ["Latitude"]=> string(9) "37.795227" ["Longitude"]=> string(11) "-122.228111" ["PrimaryAC"]=> NULL ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> string(1) "0" ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(1) "0" ["Population2000"]=> string(6) "399484" ["FIPS"]=> string(6) "653000" ["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 *************
28 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
**** cities in zip3 **************
16 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
94601OAKLANDCA33456Oakland4
94611OAKLANDCA32155Oakland4
94605OAKLANDCA28141Oakland4
94606OAKLANDCA25875Oakland4
94610OAKLANDCA24162Oakland4
94602OAKLANDCA22480Oakland4
94603OAKLANDCA21407Oakland4
94619OAKLANDCA18775Oakland4
94621OAKLANDCA18680Oakland4
94608EMERYVILLECA18425Emeryville
zipcodezipcityzipstatezippopulationcitynameDMAID
94607OAKLANDCA14897Oakland4
94609OAKLANDCA14227Oakland4
94618OAKLANDCA13888Oakland4
94612OAKLANDCA8710Oakland4
94615OAKLANDCA0Oakland4
94617OAKLANDCA0Oakland4
Station K205BM-FX
City OAKLAND-CA

City , is located in DMAID: