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


Number of rows returned = 0
Start: 1754195036.3431
End: 1754195036.3432
Elapsed time: 0.1140 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80367" ["State"]=> string(2) "CA" ["CityName"]=> string(12) "San Gregorio" ["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) "94074" ["zip3"]=> string(3) "940" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(12) "SAN GREGORIO" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "37.33" ["iplongitude"]=> string(7) "-122.34" ["ziplocation"]=> string(21) "NA-US-CA-SAN GREGORIO" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "940" ["zipcity"]=> string(9) "SUNNYVALE" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2507" ["State"]=> string(2) "CA" ["CityName"]=> string(9) "Sunnyvale" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "412" ["Population"]=> string(6) "117229" ["Latitude"]=> string(9) "37.371991" ["Longitude"]=> string(10) "-122.02602" ["PrimaryAC"]=> string(3) "408" ["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) "2507" ["Population2000"]=> string(6) "131760" ["FIPS"]=> string(6) "677000" ["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 **************
32 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
94080SOUTH SAN FRANCISCOCA53242South San Francisco
94015DALY CITYCA49650Daly City
94087SUNNYVALECA46300Sunnyvale4
94086SUNNYVALECA37637Sunnyvale4
94014DALY CITYCA36989Daly City
94010BURLINGAMECA35172Burlingame
94066SAN BRUNOCA35122San Bruno
94025MENLO PARKCA32613Menlo Park
94044PACIFICACA32334Pacifica
94061REDWOOD CITYCA27970Redwood City
zipcodezipcityzipstatezippopulationcitynameDMAID
94070SAN CARLOSCA26469San Carlos
94040MOUNTAIN VIEWCA26205Mountain View4
94002BELMONTCA23092Belmont
94043MOUNTAIN VIEWCA22824Mountain View4
94062REDWOOD CITYCA22552Redwood City
94063REDWOOD CITYCA21866Redwood City
94024LOS ALTOSCA20665Los Altos
94030MILLBRAECA18869Millbrae
94022LOS ALTOSCA17620Los Altos
94085SUNNYVALECA16831Sunnyvale4
zipcodezipcityzipstatezippopulationcitynameDMAID
94089SUNNYVALECA16628Sunnyvale4
94019HALF MOON BAYCA12963Half Moon Bay
94041MOUNTAIN VIEWCA10999Mountain View4
94065REDWOOD CITYCA10134Redwood City
94028PORTOLA VALLEYCA6281Portola Valley
94027ATHERTONCA6145Atherton4
94005BRISBANECA4345Brisbane
94038MOSS BEACHCA2425Moss Beach4
94060PESCADEROCA1410Pescadero4
94020LA HONDACA1307La Honda
zipcodezipcityzipstatezippopulationcitynameDMAID
94021LOMA MARCA0
94074SAN GREGORIOCA0San Gregorio
***** 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 KZSG-FM
City SAN GREGORIO-CA

City San Gregorio, CA is located in DMAID: