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 = 'CHESTER' and State = 'CA'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const21Using where


Number of rows returned = 1
Start: 1754171884.0574
End: 1754171884.0578
Elapsed time: 0.3929 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
1821CAChester-11208240.302395-121.2346725300000018212316612930-8-1226

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "96020" ["zip3"]=> string(3) "960" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(7) "CHESTER" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "40.27" ["iplongitude"]=> string(7) "-121.24" ["ziplocation"]=> string(16) "NA-US-CA-CHESTER" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1303" ["zippopulation"]=> string(4) "2304" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "960" ["zipcity"]=> string(7) "REDDING" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2358" ["State"]=> string(2) "CA" ["CityName"]=> string(7) "Redding" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "403" ["Population"]=> string(5) "66462" ["Latitude"]=> string(9) "40.576606" ["Longitude"]=> string(11) "-122.370325" ["PrimaryAC"]=> string(3) "530" ["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) "2358" ["Population2000"]=> string(5) "80865" ["FIPS"]=> string(6) "659920" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "226" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
25 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
2358CARedding04036646240.576606-122.37032553000000235880865659920-8-1226
1700CAAnderson0296829940.452092-122.296565300000017009022602042-8-1226
2612CAYreka0316694841.726617-122.6375685300000026127290686944-8-1226
2217CAMount Shasta0316346041.314542-122.311515300000022173621649852-8-1226
1785CABurney-11342340.880655-121.666755300000017853217609122-8-1226
2581CAWeaverville-1235337040.736687-122.9362085300000025813554683794-8-1226
2582CAWeed-1280306241.424298-122.3844175300000025822978683850-8-1226
1993CAHayfork0231260540.571406-123.1466195300000019932315632562-8-1226
1899CADunsmuir0229212941.221542-122.2730115300000018991923620242-8-1226
1821CAChester-11208240.302395-121.2346725300000018212316612930-8-1226
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
1860CACottonwood0314174740.388953-122.2818235300000018602960616630-8-1226
2174CAMcCloud-17155541.254682-122.1363215300000021741343644784-8-1226
2106CALewiston0317118740.699213-122.8106845300000021061305641278-8-1226
1889CADorris-1189241.965075-121.918967530000001889886619584-8-1226
1926CAEtna-1083541.45735-122.896875530000001926781622972-8-1226
1950CAFort Jones-1163941.607303-122.841817530000001950660625128-8-1226
68262CAManton0040.41902-121.8635190000000372645512-8-1226
68299CARound Mountain0040.799633-121.9430580000000122663134-8-1226
2015CAHornbrook023141.909594-122.557628530000002015286634694-8-1226
2461CAShingletown-1140.496033-121.8636575300000024612222671568-8-1226
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
1977CAGrenada023341.644438-122.522768530000001977351631246-8-1226
1965CAGerber023940.049209-122.209437530000001965-8-1226
1932CAFall River Mills-1041.00576-121.440946530000001932648623532-8-1226
1741CABella Vista-1040.715565-122.1193953000000-8-1226
1990CAHappy Camp-1141.666514-123.421603530000001990-8-1226
**** cities in zip3 **************
60 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
96003REDDINGCA30950Redding226
96001REDDINGCA23744Redding226
96002REDDINGCA23604Redding226
96080RED BLUFFCA21073Red Bluff199
96007ANDERSONCA16199Anderson226
96022COTTONWOODCA11976Cottonwood226
96021CORNINGCA11110Corning199
96097YREKACA7554Yreka226
96019SHASTA LAKECA6917Shasta Lake
96067MOUNT SHASTACA6226Mount Shasta226
zipcodezipcityzipstatezippopulationcitynameDMAID
96094WEEDCA4766Weed226
96073PALO CEDROCA4146Palo Cedro
96088SHINGLETOWNCA3513Shingletown226
96064MONTAGUECA3209Montague
96013BURNEYCA3131Burney226
96055LOS MOLINOSCA2732Los Molinos199
96020CHESTERCA2304Chester226
96035GERBERCA2202Gerber226
96032FORT JONESCA1733Fort Jones226
96027ETNACA1656Etna226
zipcodezipcityzipstatezippopulationcitynameDMAID
96025DUNSMUIRCA1644Dunsmuir226
96041HAYFORKCA1501Hayfork226
96008BELLA VISTACA1500Bella Vista226
96028FALL RIVER MILLSCA1223Fall River Mills226
96056MCARTHURCA1210McArthur
96057MCCLOUDCA1037McCloud226
96062MILLVILLECA977Millville
96052LEWISTONCA947Lewiston226
96051LAKEHEADCA902Lakehead
96023DORRISCA858Dorris226
zipcodezipcityzipstatezippopulationcitynameDMAID
96039HAPPY CAMPCA798Happy Camp226
96047IGOCA708Igo
96069OAK RUNCA667Oak Run
96044HORNBROOKCA643Hornbrook226
96024DOUGLAS CITYCA632
96096WHITMORECA568
96038GRENADACA551Grenada226
96091TRINITY CENTERCA501Trinity Center
96048JUNCTION CITYCA494
96058MACDOELCA489Macdoel
zipcodezipcityzipstatezippopulationcitynameDMAID
96006ADINCA0Adin
96010BIG BARCA0
96014CALLAHANCA0Callahan
96015CANBYCA0
96016CASSELCA0
96017CASTELLACA0
96029FLOURNOYCA0Flournoy
96031FORKS OF SALMONCA0
96033FRENCH GULCHCA0French Gulch
96034GAZELLECA0Gazelle
zipcodezipcityzipstatezippopulationcitynameDMAID
96040HAT CREEKCA0
96050KLAMATH RIVERCA0Klamath River
96059MANTONCA0Manton226
96061MILL CREEKCA0
96065MONTGOMERY CREEKCA0Montgomery Creek
96071OLD STATIONCA0
96076PLATINACA0Platina
96075PAYNES CREEKCA0Paynes Creek
96085SCOTT BARCA0Scott Bar
96086SEIAD VALLEYCA0
Station K265AA-FX
City CHESTER-CA

City , is located in DMAID: