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 = 'HOUSTON' and State = 'TX'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const8Using where


Number of rows returned = 1
Start: 1754176024.0654
End: 1754176024.0656
Elapsed time: 0.1431 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19316TXHouston0576163055329.762895-95.383173713110101931619536314835000-6-17

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "77084" ["zip3"]=> string(3) "770" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(7) "HOUSTON" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "29.76" ["iplongitude"]=> string(6) "-95.38" ["ziplocation"]=> string(16) "NA-US-TX-HOUSTON" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "39519" ["zippopulation"]=> string(5) "72890" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "770" ["zipcity"]=> string(7) "HOUSTON" ["zipstate"]=> string(2) "TX" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "19316" ["State"]=> string(2) "TX" ["CityName"]=> string(7) "Houston" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "576" ["Population"]=> string(7) "1630553" ["Latitude"]=> string(9) "29.762895" ["Longitude"]=> string(10) "-95.383173" ["PrimaryAC"]=> string(3) "713" ["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) "19316" ["Population2000"]=> string(7) "1953631" ["FIPS"]=> string(7) "4835000" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(1) "7" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
23 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19316TXHouston0576163055329.762895-95.383173713110101931619536314835000-6-17
41319TXPasadena-1011936329.676196-95.173845000001416744856000-6-17
18873TXBaytown02346385029.743752-94.9657672810001018873664304806128-6-17
19216TXGalveston02075907029.281137-94.8259454090001019216572474828068-6-17
19904TXTexas City004082229.399983-94.93385140900000415214872392-6-17
19408TXLa Porte01352791029.664768-95.0408242810100019408318804841440-6-17
19096TXDeer Park01692765229.692003-95.1181082810000019096285204819624-6-17
19048TXConroe01442761030.316124-95.4588019360000019048368114816432-6-17
19208TXFriendswood-11902281429.512532-95.1979332810000019208290374827648-6-17
41229TXLake Jackson-102277629.036837-95.43833900000263864840588-6-17
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
18811TXAlvin01981922029.393698-95.2715882810001018811214134802272-6-17
18818TXAngleton-11231714029.166478-95.4281229790000018818181304803264-6-17
19206TXFreeport-11831138928.959527-95.3569419790000019206127084827420-6-17
19797TXSanta Fe-10842929.380651-95.1041634090000095484865726-6-17
19027TXCleveland-1182712430.34492-95.083503281000101902776054815436-6-17
19808TXSeabrook-1135668529.568506-95.022626281010001980894434866392-6-17
19919TXTomball0171637030.098905-95.618899281010001991990894873316-6-17
18815TXAnahuac-10199329.768622-94.679067409000001881522104803144-6-17
19442TXLiberty-1112160730.057546-94.796662936000001944280334842568-6-17
19375TXKemah-1108109429.539469-95.019032281000101937523304838776-6-17
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
19278TXHardin-12056330.15017-94.73663193600000192787554832240-6-17
19690TXPorter-17230.21308-95.4000362810001019690-6-17
19550TXMissouri City-1029.582799-95.5394232810000019550529134848804-6-17
**** cities in zip3 **************
97 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
77084HOUSTONTX72890Houston7
77095HOUSTONTX56079Houston7
77083HOUSTONTX54475Houston7
77077HOUSTONTX40493Houston7
77072HOUSTONTX40152Houston7
77036HOUSTONTX39848Houston7
77015HOUSTONTX38860Houston7
77089HOUSTONTX38222Houston7
77088HOUSTONTX37706Houston7
77064HOUSTONTX36400Houston7
zipcodezipcityzipstatezippopulationcitynameDMAID
77082HOUSTONTX36323Houston7
77070HOUSTONTX36163Houston7
77040HOUSTONTX35441Houston7
77099HOUSTONTX33303Houston7
77093HOUSTONTX32205Houston7
77024HOUSTONTX30150Houston7
77041HOUSTONTX29844Houston7
77080HOUSTONTX29608Houston7
77055HOUSTONTX28009Houston7
77079HOUSTONTX27970Houston7
zipcodezipcityzipstatezippopulationcitynameDMAID
77042HOUSTONTX27841Houston7
77009HOUSTONTX27460Houston7
77057HOUSTONTX27237Houston7
77065HOUSTONTX27200Houston7
77087HOUSTONTX26541Houston7
77075HOUSTONTX26273Houston7
77081HOUSTONTX26173Houston7
77096HOUSTONTX25918Houston7
77060HOUSTONTX25102Houston7
77066HOUSTONTX24961Houston7
zipcodezipcityzipstatezippopulationcitynameDMAID
77073HOUSTONTX24816Houston7
77035HOUSTONTX24203Houston7
77074HOUSTONTX24151Houston7
77092HOUSTONTX24025Houston7
77034HOUSTONTX23939Houston7
77008HOUSTONTX23616Houston7
77007HOUSTONTX23282Houston7
77063HOUSTONTX23126Houston7
77044HOUSTONTX22673Houston7
77017HOUSTONTX22608Houston7
zipcodezipcityzipstatezippopulationcitynameDMAID
77045HOUSTONTX22459Houston7
77022HOUSTONTX22098Houston7
77062HOUSTONTX21952Houston7
77053HOUSTONTX21930Houston7
77090HOUSTONTX21910Houston7
77076HOUSTONTX21487Houston7
77049HOUSTONTX21095Houston7
77016HOUSTONTX21001Houston7
77067HOUSTONTX20865Houston7
77018HOUSTONTX20653Houston7
zipcodezipcityzipstatezippopulationcitynameDMAID
77033HOUSTONTX20575Houston7
77005HOUSTONTX20268Houston7
77023HOUSTONTX20162Houston7
77014HOUSTONTX19914Houston7
77086HOUSTONTX19891Houston7
77039HOUSTONTX19546Houston7
77071HOUSTONTX19369Houston7
77025HOUSTONTX19188Houston7
77038HOUSTONTX18155Houston7
77021HOUSTONTX17987Houston7
zipcodezipcityzipstatezippopulationcitynameDMAID
77020HOUSTONTX17899Houston7
77043HOUSTONTX17872Houston7
77004HOUSTONTX17083Houston7
77091HOUSTONTX16693Houston7
77026HOUSTONTX16377Houston7
77056HOUSTONTX16303Houston7
77061HOUSTONTX16149Houston7
77047HOUSTONTX15986Houston7
77059HOUSTONTX15555Houston7
77019HOUSTONTX15167Houston7
zipcodezipcityzipstatezippopulationcitynameDMAID
77006HOUSTONTX14422Houston7
77054HOUSTONTX13884Houston7
77069HOUSTONTX13847Houston7
77012HOUSTONTX13675Houston7
77037HOUSTONTX13468Houston7
77029HOUSTONTX13364Houston7
77011HOUSTONTX12917Houston7
77058HOUSTONTX12262Houston7
77028HOUSTONTX12237Houston7
77085HOUSTONTX11979Houston7
zipcodezipcityzipstatezippopulationcitynameDMAID
77027HOUSTONTX11716Houston7
77013HOUSTONTX11306Houston7
77048HOUSTONTX11044Houston7
77031HOUSTONTX10795Houston7
77078HOUSTONTX10560Houston7
77051HOUSTONTX10299Houston7
77098HOUSTONTX10256Houston7
77094HOUSTONTX8637Houston7
77068HOUSTONTX8056Houston7
77032HOUSTONTX7859Houston7
zipcodezipcityzipstatezippopulationcitynameDMAID
77030HOUSTONTX7819Houston7
77003HOUSTONTX6442Houston7
77002HOUSTONTX4878Houston7
77050HOUSTONTX3245Houston7
77046HOUSTONTX1181Houston7
77010HOUSTONTX396Houston7
77097HOUSTONTX0Houston7
Station K254BZ-FX
City HOUSTON-TX

City , is located in DMAID: