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


Number of rows returned = 0
Start: 1754183041.6308
End: 1754183041.6309
Elapsed time: 0.1159 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80281" ["State"]=> string(2) "CA" ["CityName"]=> string(6) "Camino" ["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) "95709" ["zip3"]=> string(3) "957" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "CAMINO" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "38.74" ["iplongitude"]=> string(7) "-120.68" ["ziplocation"]=> string(15) "NA-US-CA-CAMINO" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "2318" ["zippopulation"]=> string(4) "4150" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "957" ["zipcity"]=> string(9) "ELK GROVE" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "1919" ["State"]=> string(2) "CA" ["CityName"]=> string(9) "Elk Grove" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "279" ["Population"]=> string(5) "17483" ["Latitude"]=> string(9) "38.438222" ["Longitude"]=> string(11) "-121.381925" ["PrimaryAC"]=> string(3) "916" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "1" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "1919" ["Population2000"]=> string(5) "59984" ["FIPS"]=> string(6) "622020" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
15 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
95758ELK GROVECA48267Elk Grove
95747ROSEVILLECA41545Roseville26
95762EL DORADO HILLSCA33316El Dorado Hills
95757ELK GROVECA27886Elk Grove
95765ROCKLINCA25874Rocklin
95746GRANITE BAYCA19407Granite Bay
95776WOODLANDCA18163Woodland4
95726POLLOCK PINESCA6965Pollock Pines
95742RANCHO CORDOVACA6511Rancho Cordova26
95713COLFAXCA6066Colfax
zipcodezipcityzipstatezippopulationcitynameDMAID
95722MEADOW VISTACA4202Meadow Vista
95709CAMINOCA4150Camino
95703APPLEGATECA1447
95720KYBURZCA0
95735TWIN BRIDGESCA0
Station KCPC-FM
City CAMINO-CA

City Camino, CA is located in DMAID: