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 = 'TAMUNING' and State = 'GU'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 1
Start: 1754168796.7027
End: 1754168796.7029
Elapsed time: 0.1550 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
34331GUTamuning-10953413.493618144.776709000000

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "96931" ["zip3"]=> string(3) "969" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(8) "TAMUNING" ["zipstate"]=> string(2) "GU" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "13.48" ["iplongitude"]=> string(6) "144.77" ["ziplocation"]=> string(17) "NA-US-GU-TAMUNING" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "969" ["zipcity"]=> string(10) "SANTA RITA" ["zipstate"]=> string(2) "GU" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "34327" ["State"]=> string(2) "GU" ["CityName"]=> string(10) "Santa Rita" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "0" ["Population"]=> string(4) "1243" ["Latitude"]=> string(9) "13.387268" ["Longitude"]=> string(10) "144.669309" ["PrimaryAC"]=> NULL ["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"]=> NULL ["Population2000"]=> NULL ["FIPS"]=> NULL ["cTZoffset"]=> NULL ["DST"]=> string(1) "0" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
5 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
96910HAGATNAGU0
96913BARRIGADAGU0Barrigada
96915SANTA RITAGU0Santa Rita
96919AGANA HEIGHTSGU0Agana Heights
96929YIGOGU0Yigo
Station KNUT-FM
City TAMUNING-GU

City , is located in DMAID: