array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9999" ["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 ANTONIO' and State = 'TX'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const6Using where


Number of rows returned = 1
Start: 1754167266.2429
End: 1754167266.2435
Elapsed time: 0.5119 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19784TXSan Antonio047293593329.451532-98.512682210110101978411446464865000-6-130

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "78250" ["zip3"]=> string(3) "782" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(11) "SAN ANTONIO" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "29.45" ["iplongitude"]=> string(5) "-98.5" ["ziplocation"]=> string(20) "NA-US-TX-SAN ANTONIO" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "24990" ["zippopulation"]=> string(5) "45011" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "782" ["zipcity"]=> string(11) "SAN ANTONIO" ["zipstate"]=> string(2) "TX" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "19784" ["State"]=> string(2) "TX" ["CityName"]=> string(11) "San Antonio" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "472" ["Population"]=> string(6) "935933" ["Latitude"]=> string(9) "29.451532" ["Longitude"]=> string(10) "-98.512682" ["PrimaryAC"]=> string(3) "210" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "1" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "1" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "19784" ["Population2000"]=> string(7) "1144646" ["FIPS"]=> string(7) "4865000" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "30" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
20 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19784TXSan Antonio047293593329.451532-98.512682210110101978411446464865000-6-130
19790TXSan Marcos0592874329.879387-97.9388295120000019790347334865600-6-130
19591TXNew Braunfels02152733429.701724-98.1235598300101019591364944850820-6-130
19814TXSeguin-12441885329.574329-97.9653328300001019814220114866644-6-130
18880TXBeeville-1361354728.405498-97.7507573610000018880131294807192-6-130
41387TXSchertz-101055529.566728-98.26433900000186944866128-6-130
41096TXConverse-10888729.51728-98.31380400000115084816468-6-130
19653TXPearsall-1103692428.891458-99.094873830000001965371574856384-6-130
19188TXFloresville-181524729.136255-98.157908830000101918858684826160-6-130
19108TXDevine0120392829.143908-98.906174830000101910841404820152-6-130
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19379TXKenedy-1120376328.814263-97.849582830000001937934874838860-6-130
19365TXJourdanton-126322028.92153-98.54644830000101936537324838116-6-130
20022TXYorktown-123220728.983196-97.502415361000002002222714880584-6-130
19294TXHelotes-10153529.565328-98.6892512100000042854833146-6-130
19042TXComfort-11147729.969566-98.907087830000001904223584816228-6-130
19869TXStockdale-123126829.233371-97.961987830000001986913984870376-6-130
19845TXSomerset-123114429.226954-98.657533830000101984515504868708-6-130
19492TXMarion-16298429.571879-98.139243830000001949210994846692-6-130
19837TXSmiley-12446329.269402-97.6368583000000198374534868300-6-130
70098TXUniversal City0029.552148-98.3032280000000148494874408-6-130
**** cities in zip3 **************
66 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
78250SAN ANTONIOTX45011San Antonio30
78228SAN ANTONIOTX43510San Antonio30
78245SAN ANTONIOTX43391San Antonio30
78247SAN ANTONIOTX41124San Antonio30
78240SAN ANTONIOTX38085San Antonio30
78251SAN ANTONIOTX37672San Antonio30
78223SAN ANTONIOTX36315San Antonio30
78254SAN ANTONIOTX34903San Antonio30
78233SAN ANTONIOTX34631San Antonio30
78249SAN ANTONIOTX34588San Antonio30
zipcodezipcityzipstatezippopulationcitynameDMAID
78227SAN ANTONIOTX34553San Antonio30
78258SAN ANTONIOTX34168San Antonio30
78201SAN ANTONIOTX32633San Antonio30
78207SAN ANTONIOTX32629San Antonio30
78230SAN ANTONIOTX30808San Antonio30
78213SAN ANTONIOTX30456San Antonio30
78209SAN ANTONIOTX30337San Antonio30
78232SAN ANTONIOTX29612San Antonio30
78216SAN ANTONIOTX29493San Antonio30
78237SAN ANTONIOTX27055San Antonio30
zipcodezipcityzipstatezippopulationcitynameDMAID
78210SAN ANTONIOTX26813San Antonio30
78221SAN ANTONIOTX26597San Antonio30
78217SAN ANTONIOTX25218San Antonio30
78253SAN ANTONIOTX23911San Antonio30
78211SAN ANTONIOTX23554San Antonio30
78218SAN ANTONIOTX23041San Antonio30
78239SAN ANTONIOTX22176San Antonio30
78244SAN ANTONIOTX22146San Antonio30
78242SAN ANTONIOTX21605San Antonio30
78212SAN ANTONIOTX19934San Antonio30
zipcodezipcityzipstatezippopulationcitynameDMAID
78229SAN ANTONIOTX19044San Antonio30
78259SAN ANTONIOTX18765San Antonio30
78260SAN ANTONIOTX18350San Antonio30
78238SAN ANTONIOTX17634San Antonio30
78214SAN ANTONIOTX17201San Antonio30
78222SAN ANTONIOTX13709San Antonio30
78224SAN ANTONIOTX13598San Antonio30
78248SAN ANTONIOTX12500San Antonio30
78220SAN ANTONIOTX12159San Antonio30
78219SAN ANTONIOTX11105San Antonio30
zipcodezipcityzipstatezippopulationcitynameDMAID
78261SAN ANTONIOTX10441San Antonio30
78225SAN ANTONIOTX10231San Antonio30
78202SAN ANTONIOTX9378San Antonio30
78264SAN ANTONIOTX8786San Antonio30
78204SAN ANTONIOTX8275San Antonio30
78255SAN ANTONIOTX8037San Antonio30
78231SAN ANTONIOTX7193San Antonio30
78266SAN ANTONIOTX5406San Antonio30
78226SAN ANTONIOTX4586San Antonio30
78256SAN ANTONIOTX4383San Antonio30
zipcodezipcityzipstatezippopulationcitynameDMAID
78203SAN ANTONIOTX4104San Antonio30
78252SAN ANTONIOTX3728San Antonio30
78263SAN ANTONIOTX3708San Antonio30
78234SAN ANTONIOTX3432San Antonio30
78257SAN ANTONIOTX3255San Antonio30
78208SAN ANTONIOTX2648San Antonio30
78236LACKLAND A F BTX1539
78205SAN ANTONIOTX1014San Antonio30
78215SAN ANTONIOTX798San Antonio30
78206SAN ANTONIOTX0San Antonio30
zipcodezipcityzipstatezippopulationcitynameDMAID
78235SAN ANTONIOTX0San Antonio30
78241SAN ANTONIOTX0San Antonio30
78243SAN ANTONIOTX0San Antonio30
78284SAN ANTONIOTX0San Antonio30
78285SAN ANTONIOTX0San Antonio30
78262SAN ANTONIOTX0San Antonio30
Station K277CX-FX
City SAN ANTONIO-TX

City , is located in DMAID: