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 = 'CROSSVILLE' and State = 'TN'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const4Using where


Number of rows returned = 1
Start: 1754151749.0322
End: 1754151749.0324
Elapsed time: 0.2151 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
18538TNCrossville-131693035.954221-85.031267931000001853889814718540-6-1211

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "38555" ["zip3"]=> string(3) "385" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "CROSSVILLE" ["zipstate"]=> string(2) "TN" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "35.95" ["iplongitude"]=> string(6) "-85.03" ["ziplocation"]=> string(19) "NA-US-TN-CROSSVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "7284" ["zippopulation"]=> string(5) "13065" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "385" ["zipcity"]=> string(10) "COOKEVILLE" ["zipstate"]=> string(2) "TN" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "18529" ["State"]=> string(2) "TN" ["CityName"]=> string(10) "Cookeville" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "59" ["Population"]=> string(5) "21744" ["Latitude"]=> string(9) "36.164202" ["Longitude"]=> string(10) "-85.504295" ["PrimaryAC"]=> string(3) "931" ["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(5) "18529" ["Population2000"]=> string(5) "23923" ["FIPS"]=> string(7) "4716920" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "211" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
21 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
6896KYBowling Green01724064136.981657-86.444423270000006896492962108902-6-1211
18529TNCookeville-1592174436.164202-85.5042959310000018529239234716920-6-1211
6999KYGlasgow0811235137.000375-85.920229270000006999130192131114-6-1211
6914KYCampbellsville0101957737.345951-85.345444270000006914104982112160-5-1211
6987KYFranklin-194760736.722487-86.57756627000000698779962128918-6-1211
18538TNCrossville-131693035.954221-85.031267931000001853889814718540-6-1211
7156KYScottsville071427836.751504-86.19269227000000715643272169114-6-1211
7188KYTompkinsville093286136.699508-85.69200527000000718826602177160-5-1211
7028KYHorse Cave-10228437.17623-85.90614327000000702822522138008-5-1211
7003KYGreensburg-162199037.259665-85.49786327000000700323962132968-5-1211
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
6923KYCave City-10195337.13713-85.95695827000000692318802113492-5-1211
18609TNJamestown-10186236.429082-84.932414931000001860918394737780-1211
7103KYMunfordville-10155637.276608-85.89782227000000710315632154570-5-1211
18508TNCelina-10149336.548379-85.50198615000001850813794712100-1211
6957KYEdmonton-10147736.980191-85.62033827000000695715862123968-5-1211
6872KYAuburn-10127336.866523-86.7169127000000687214442102638-6-1211
18747TNSpencer-10112535.74374-85.458408931000001874717134770240-1211
18505TNByrdstown-1199836.572585-85.13708893100000185059034710180-1211
6902KYBrownsville-16589737.191169-86.2610982700000069029212110324-6-1211
7167KYSmiths Grove-1170337.053448-86.2075692700000071677842171454-6-1211
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
7025KYHiseville-1022037.100131-85.8151072700000070252242137234-5-1211
**** cities in zip3 **************
43 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
38501COOKEVILLETN24783Cookeville211
38506COOKEVILLETN20859Cookeville211
38583SPARTATN17899Sparta285
38555CROSSVILLETN13065Crossville211
38571CROSSVILLETN10575Crossville211
38572CROSSVILLETN8843Crossville211
38556JAMESTOWNTN8279Jamestown211
38570LIVINGSTONTN7328Livingston285
38558CROSSVILLETN6569Crossville211
38574MONTEREYTN6439Monterey285
zipcodezipcityzipstatezippopulationcitynameDMAID
38544BAXTERTN5176Baxter285
38562GAINESBOROTN4587Gainesboro
38581ROCK ISLANDTN3315Rock Island
38551CELINATN3107Celina211
38549BYRDSTOWNTN2871Byrdstown211
38585SPENCERTN2835Spencer211
38563GORDONSVILLETN1967Gordonsville
38553CLARKRANGETN1724Clarkrange
38573MONROETN1702
38547BRUSH CREEKTN1586
zipcodezipcityzipstatezippopulationcitynameDMAID
38580RICKMANTN1475Rickman
38568HILHAMTN1463
38541ALLONSTN1282
38504ALLARDTTN1138Allardt
38545BLOOMINGTON SPRINGSTN1064
38582SILVER POINTTN1051
38560ELMWOODTN1047
38559DOYLETN1002Doyle
38565GRIMSLEYTN965
38587WALLINGTN954
zipcodezipcityzipstatezippopulationcitynameDMAID
38575MOSSTN898Moss
38577PALL MALLTN821
38579QUEBECKTN782
38588WHITLEYVILLETN706Whitleyville
38567HICKMANTN656
38548BUFFALO VALLEYTN640
38554CRAWFORDTN588Crawford
38542ALLREDTN0
38543ALPINETN0
38552CHESTNUT MOUNDTN0Chestnut Mound
zipcodezipcityzipstatezippopulationcitynameDMAID
38564GRANVILLETN0Granville
38569LANCASTERTN0
38589WILDERTN0
Station W270BI-FX
City CROSSVILLE-TN

City , is located in DMAID: