Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix KSPB FM Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9999" ["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 = 'PEBBLE BEACH' and State = 'CA'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754185237.1964
End: 1754185237.1965
Elapsed time: 0.1259 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80300" ["State"]=> string(2) "CA" ["CityName"]=> string(12) "Pebble Beach" ["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) "93953" ["zip3"]=> string(3) "939" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(12) "PEBBLE BEACH" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "36.58" ["iplongitude"]=> string(7) "-121.94" ["ziplocation"]=> string(21) "NA-US-CA-PEBBLE BEACH" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "2303" ["zippopulation"]=> string(4) "3861" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "939" ["zipcity"]=> string(7) "SALINAS" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2388" ["State"]=> string(2) "CA" ["CityName"]=> string(7) "Salinas" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "421" ["Population"]=> string(6) "108777" ["Latitude"]=> string(9) "36.683859" ["Longitude"]=> string(11) "-121.643128" ["PrimaryAC"]=> string(3) "831" ["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"]=> string(4) "2388" ["Population2000"]=> string(6) "151060" ["FIPS"]=> string(6) "664224" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "79" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
17 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
2388CASalinas042110877736.683859-121.643128831000002388151060664224-8-179
2434CASanta Cruz05174904036.97205-122.02625283101010243454593669112-8-179
2450CASeaside-103890136.61581-121.8339578310000031696670742-8-179
2206CAMonterey03973195436.60001-121.89060583110000220629674648872-8-179
2168CAMarina-102643636.678155-121.7972468310000025101645778-8-179
2009CAHollister03451921236.847108-121.39830883100000200934413634120-8-179
33125CAPacific Grove-101611736.619065-121.9210250000015522654848-8-179
33011CAFreedom-10836136.940452-121.789376000006000625576-8-179
1975CAGreenfield0331746436.323156-121.24471883100000197512583630994-8-179
2475CASoledad0343714636.433199-121.32982883100000247511263672520-8-179
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
1971CAGonzales0321466036.508713-121.4426448310000019717525630392-8-179
1808CACarmel Valley0333440736.486245-121.722892831000001808-8-179
1807CACarmel034336.615248-121.79501831000001807-8-179
2056CAKing City034536.211251-121.12790783100000205611094638520-8-179
2416CASan Lucas032536.12955-121.019641831000002416419668140-8-179
1825CAChualar032636.570034-121.5155118310000018251444613364-8-179
1759CABig Sur032936.054105-121.607774831000001759-8-179
**** cities in zip3 **************
19 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
93905SALINASCA49791Salinas79
93906SALINASCA42006Salinas79
93955SEASIDECA24162Seaside79
93940MONTEREYCA22581Monterey79
93901SALINASCA19097Salinas79
93907SALINASCA16466Salinas79
93933MARINACA16444Marina79
93927GREENFIELDCA12788Greenfield79
93960SOLEDADCA12698Soledad79
93950PACIFIC GROVECA12550Pacific Grove79
zipcodezipcityzipstatezippopulationcitynameDMAID
93930KING CITYCA12376King City79
93908SALINASCA11306Salinas79
93923CARMELCA8358Carmel79
93926GONZALESCA8139Gonzales79
93924CARMEL VALLEYCA5275Carmel Valley79
93953PEBBLE BEACHCA3861Pebble Beach
93925CHUALARCA1743Chualar79
93920BIG SURCA1072Big Sur79
93943MONTEREYCA0Monterey79
Station KSPB-FM
City PEBBLE BEACH-CA

City Pebble Beach, CA is located in DMAID: