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


Number of rows returned = 1
Start: 1754163811.6253
End: 1754163811.6255
Elapsed time: 0.2630 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
2340CAPortola0309219339.810151-120.4698435300000023402227658352-8-1124

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "96122" ["zip3"]=> string(3) "961" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(7) "PORTOLA" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "39.79" ["iplongitude"]=> string(7) "-120.46" ["ziplocation"]=> string(16) "NA-US-CA-PORTOLA" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1762" ["zippopulation"]=> string(4) "3165" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "961" ["zipcity"]=> string(16) "SOUTH LAKE TAHOE" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2483" ["State"]=> string(2) "CA" ["CityName"]=> string(16) "South Lake Tahoe" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(1) "0" ["Population"]=> string(5) "21586" ["Latitude"]=> string(9) "38.929237" ["Longitude"]=> string(11) "-119.984347" ["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"]=> NULL ["Population2000"]=> string(5) "23609" ["FIPS"]=> string(6) "673108" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "124" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
23 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
13149NVReno023513385039.52711-119.82181277500000131491804803260600-8-1124
13091NVCarson City01874044339.148328-119.7432437750000013091-8-1124
2483CASouth Lake Tahoe002158638.929237-119.9843475300000023609673108-8-1124
2509CASusanville-127727940.417092-120.64601453000000250913541677364-8-1124
13103NVFallon-12643839.472792-118.778826775000001310375363224100-8-1124
13171NVWinnemucca-1123613440.968212-117.726662775000001317171743284800-8-1124
13104NVFernley-190516439.598706-119.21503775000001310485433224900-8-1124
13110NVHawthorne-171416238.525198-118.623053775000001311033113231300-8-1124
2542CATruckee0313348439.342163-120.20356853000010254213864680588-8-1124
1698CAAlturas-11323141.488814-120.5459355300000016982892601444-8-1124
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
33054CAKings Beach-10279639.24117-120.023295000004037638548-8-1124
13095NVDayton-10221739.251707-119.5619437750000059073217500-8-1124
2340CAPortola0309219339.810151-120.4698435300000023402227658352-8-1124
13107NVGardnerville0184217738.940932-119.743509775000001310733573226300-8-1124
13125NVLovelock-1121206940.180013-118.476597775000001312520033243000-8-1124
2590CAWestwood-11201740.305038-121.0033965300000025901998684928-8-1124
2544CATulelake-11101041.954029-121.4759065300000025441020680686-8-1124
13114NVIncline Village-1039.259103-119.95658577500000-8-1124
13141NVOrovada-1041.263287-118.1745067750000013141-8-1124
2513CATahoe City-126239.163631-120.131614530000102513-8-1124
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
13157NVSmith-1038.773292-119.30292977500000-8-1124
1818CACedarville-1141.42426-120.111396530000001818-8-1124
13132NVMina-13638.387008-118.1095857750000013132-8-1124
**** cities in zip3 **************
30 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
96130SUSANVILLECA11282Susanville124
96150SOUTH LAKE TAHOECA9905South Lake Tahoe124
96161TRUCKEECA7896Truckee124
96101ALTURASCA3969Alturas124
96122PORTOLACA3165Portola124
96137WESTWOODCA2564Westwood124
96114JANESVILLECA2530Janesville
96134TULELAKECA1711Tulelake124
96103BLAIRSDEN-GRAEAGLECA1434
96118LOYALTONCA1177Loyalton
zipcodezipcityzipstatezippopulationcitynameDMAID
96146OLYMPIC VALLEYCA1088
96107COLEVILLECA903Coleville
96120MARKLEEVILLECA676Markleeville
96104CEDARVILLECA627Cedarville124
96109DOYLECA622
96128STANDISHCA541Standish
96105CHILCOOTCA0
96108DAVIS CREEKCA0
96112FORT BIDWELLCA0Fort Bidwell
96136WENDELCA0
zipcodezipcityzipstatezippopulationcitynameDMAID
96115LAKE CITYCA0
96117LITCHFIELDCA0
96121MILFORDCA0
96129BECKWOURTHCA0Beckwourth
96123RAVENDALECA0Ravendale
96132TERMOCA0
96124CALPINECA0
96125SIERRA CITYCA0Sierra City
96126SIERRAVILLECA0Sierraville
96133TOPAZCA0
Station K209AU-FX
City PORTOLA-CA

City , is located in DMAID: