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


Number of rows returned = 1
Start: 1754177493.9899
End: 1754177493.9901
Elapsed time: 0.1590 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
2555CAVacaville04617147938.35381-121.97268370700010255588625681554-8-14

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "95687" ["zip3"]=> string(3) "956" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "VACAVILLE" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "38.35" ["iplongitude"]=> string(7) "-121.93" ["ziplocation"]=> string(18) "NA-US-CA-VACAVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "25814" ["zippopulation"]=> string(5) "45910" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "956" ["zipcity"]=> string(9) "VACAVILLE" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2555" ["State"]=> string(2) "CA" ["CityName"]=> string(9) "Vacaville" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "461" ["Population"]=> string(5) "71479" ["Latitude"]=> string(8) "38.35381" ["Longitude"]=> string(11) "-121.972683" ["PrimaryAC"]=> string(3) "707" ["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) "2555" ["Population2000"]=> string(5) "88625" ["FIPS"]=> string(6) "681554" ["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 **************
71 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
95630FOLSOMCA53688Folsom
95624ELK GROVECA48052Elk Grove
95687VACAVILLECA45910Vacaville4
95608CARMICHAELCA45450Carmichael26
95670RANCHO CORDOVACA40655Rancho Cordova26
95648LINCOLNCA38746Lincoln26
95628FAIR OAKSCA34479Fair Oaks26
95678ROSEVILLECA32889Roseville26
95610CITRUS HEIGHTSCA32886Citrus Heights
95621CITRUS HEIGHTSCA31963Citrus Heights
zipcodezipcityzipstatezippopulationcitynameDMAID
95695WOODLANDCA28392Woodland4
95667PLACERVILLECA28139Placerville26
95688VACAVILLECA28085Vacaville4
95691WEST SACRAMENTOCA26437West Sacramento4
95662ORANGEVALECA26135Orangevale
95616DAVISCA25761Davis26
95661ROSEVILLECA24647Roseville26
95682SHINGLE SPRINGSCA24623Shingle Springs26
95632GALTCA22306Galt4
95660NORTH HIGHLANDSCA21675North Highlands4
zipcodezipcityzipstatezippopulationcitynameDMAID
95603AUBURNCA20376Auburn26
95677ROCKLINCA20132Rocklin
95618DAVISCA17799Davis26
95620DIXONCA16600Dixon
95602AUBURNCA13927Auburn26
95673RIO LINDACA11504Rio Linda4
95650LOOMISCA10909Loomis
95605WEST SACRAMENTOCA9280West Sacramento4
95694WINTERSCA7665Winters
95642JACKSONCA6104Jackson26
zipcodezipcityzipstatezippopulationcitynameDMAID
95693WILTONCA5891Wilton
95640IONECA5808Ione
95683SLOUGHHOUSECA5736
95658NEWCASTLECA5562Newcastle
95631FORESTHILLCA5104Foresthill
95626ELVERTACA4879
95619DIAMOND SPRINGSCA4471Diamond Springs
95666PIONEERCA4179Pioneer
95672RESCUECA4022
95685SUTTER CREEKCA3944Sutter Creek4
zipcodezipcityzipstatezippopulationcitynameDMAID
95692WHEATLANDCA3917Wheatland
95623EL DORADOCA3901
95665PINE GROVECA3764
95614COOLCA3415
95655MATHERCA3200
95627ESPARTOCA2896Esparto26
95633GARDEN VALLEYCA2517
95634GEORGETOWNCA2459Georgetown
95684SOMERSETCA2344
95663PENRYNCA2304
zipcodezipcityzipstatezippopulationcitynameDMAID
95669PLYMOUTHCA2065Plymouth
95690WALNUT GROVECA2004Walnut Grove
95638HERALDCA1831Herald
95641ISLETONCA1486Isleton
95645KNIGHTS LANDINGCA1285Knights Landing
95612CLARKSBURGCA1189Clarksburg
95689VOLCANOCA1166Volcano
95664PILOT HILLCA1113
95635GREENWOODCA958
95681SHERIDANCA957
zipcodezipcityzipstatezippopulationcitynameDMAID
95615COURTLANDCA753Courtland
95629FIDDLETOWNCA742
95674RIO OSOCA734
95636GRIZZLY FLATSCA723
95668PLEASANT GROVECA687Pleasant Grove
95651LOTUSCA625
95659NICOLAUSCA614Nicolaus
95606BROOKSCA0
95607CAPAYCA0
95637GUINDACA0Guinda
zipcodezipcityzipstatezippopulationcitynameDMAID
95652MCCLELLANCA0
Station K220JB-FX
City VACAVILLE-CA

City , is located in DMAID: