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 = 'RICHMOND' and State = 'VA'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const27Using where


Number of rows returned = 1
Start: 1754168306.0515
End: 1754168306.0517
Elapsed time: 0.2220 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20498VARichmond028820305637.538346-77.46150743411100204981977905167000-5-1

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "23223" ["zip3"]=> string(3) "232" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(8) "RICHMOND" ["zipstate"]=> string(2) "VA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "37.55" ["iplongitude"]=> string(6) "-77.46" ["ziplocation"]=> string(17) "NA-US-VA-RICHMOND" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "20701" ["zippopulation"]=> string(5) "32635" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "232" ["zipcity"]=> string(8) "RICHMOND" ["zipstate"]=> string(2) "VA" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "20498" ["State"]=> string(2) "VA" ["CityName"]=> string(8) "Richmond" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "288" ["Population"]=> string(6) "203056" ["Latitude"]=> string(9) "37.538346" ["Longitude"]=> string(10) "-77.461507" ["PrimaryAC"]=> string(3) "434" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "1" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "20498" ["Population2000"]=> string(6) "197790" ["FIPS"]=> string(7) "5167000" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
24 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
23223RICHMONDVA32635Richmond
23234RICHMONDVA31921Richmond
23225RICHMONDVA29120Richmond
23231HENRICOVA28091
23229HENRICOVA27780
23235RICHMONDVA26806Richmond
23228HENRICOVA26502
23233HENRICOVA25562
23236RICHMONDVA23959Richmond
23224RICHMONDVA22615Richmond
zipcodezipcityzipstatezippopulationcitynameDMAID
23238HENRICOVA21203
23227RICHMONDVA19421Richmond
23237RICHMONDVA17931Richmond
23222RICHMONDVA17607Richmond
23220RICHMONDVA16861Richmond
23226RICHMONDVA13674Richmond
23294HENRICOVA13518
23221RICHMONDVA10957Richmond
23230RICHMONDVA4678Richmond
23219RICHMONDVA1508Richmond
zipcodezipcityzipstatezippopulationcitynameDMAID
23232RICHMONDVA0Richmond
23250RICHMONDVA0Richmond
23298RICHMONDVA0Richmond
23240RICHMONDVA0Richmond
Station W219CX-FX
City RICHMOND-VA

City , is located in DMAID: