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 = 'SAN ANGELO' and State = 'TX'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 1
Start: 1754161276.2537
End: 1754161276.2538
Elapsed time: 0.1500 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19783TXSan Angelo02218447431.453113-100.4525023250010019783884394864472-6-1284

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "76904" ["zip3"]=> string(3) "769" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "SAN ANGELO" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "31.44" ["iplongitude"]=> string(7) "-100.45" ["ziplocation"]=> string(19) "NA-US-TX-SAN ANGELO" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "13904" ["zippopulation"]=> string(5) "24239" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "769" ["zipcity"]=> string(10) "SAN ANGELO" ["zipstate"]=> string(2) "TX" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "19783" ["State"]=> string(2) "TX" ["CityName"]=> string(10) "San Angelo" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "221" ["Population"]=> string(5) "84474" ["Latitude"]=> string(9) "31.453113" ["Longitude"]=> string(11) "-100.452502" ["PrimaryAC"]=> string(3) "325" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "19783" ["Population2000"]=> string(5) "88439" ["FIPS"]=> string(7) "4864472" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "284" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
10 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19783TXSan Angelo02218447431.453113-100.4525023250010019783884394864472-6-1284
18856TXBallinger-187397531.740907-99.953832325000001885642434805456-6-1284
18897TXBig Lake-10367231.193908-101.458834325000001889728854808212-6-1284
19634TXOzona-10318130.708972-101.204069325000001963434364854552-6-1284
19847TXSonora-158275130.568166-100.644163325000001984729244868756-6-1284
19149TXEldorado-10201930.860746-100.598329325000001914919514822960-6-1284
19745TXRobert Lee-10127631.895687-100.484912325000001974511714862564-6-1284
19533TXMertzon-1077831.259951-100.82075932500000195338394847832-6-1284
19021TXChristoval-15631.193947-100.49411532500000190214224814872-6-1284
19866TXSterling City-1031.839066-100.985871325000001986610814870232-6-1284
**** cities in zip3 **************
21 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
76904SAN ANGELOTX24239San Angelo284
76903SAN ANGELOTX23126San Angelo284
76901SAN ANGELOTX21943San Angelo284
76905SAN ANGELOTX8976San Angelo284
76950SONORATX3770Sonora284
76943OZONATX3170Ozona284
76932BIG LAKETX2780Big Lake284
76936ELDORADOTX2428Eldorado284
76945ROBERT LEETX1366Robert Lee284
76935CHRISTOVALTX1312Christoval284
zipcodezipcityzipstatezippopulationcitynameDMAID
76941MERTZONTX1174Mertzon284
76933BRONTETX1019Bronte
76951STERLING CITYTX968Sterling City284
76934CARLSBADTX818Carlsbad
76908GOODFELLOW AFBTX756
76930BARNHARTTX0Barnhart
76937EOLATX0Eola
76940MERETATX0
76949SILVERTX0
76955VANCOURTTX0
zipcodezipcityzipstatezippopulationcitynameDMAID
76957WALLTX0
Station KLRW-FM
City SAN ANGELO-TX

City , is located in DMAID: