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 JUAN' and State = 'PR'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const6Using where


Number of rows returned = 1
Start: 1754169909.431
End: 1754169909.4311
Elapsed time: 0.1659 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
79959PRSan Juan-10

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "00931" ["zip3"]=> string(3) "009" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(8) "SAN JUAN" ["zipstate"]=> string(2) "PR" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(4) "18.4" ["iplongitude"]=> string(6) "-66.06" ["ziplocation"]=> string(17) "NA-US-PR-SAN JUAN" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "009" ["zipcity"]=> string(8) "TOA BAJA" ["zipstate"]=> string(2) "PR" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "17282" ["State"]=> string(2) "PR" ["CityName"]=> string(8) "Toa Baja" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "0" ["Population"]=> NULL ["Latitude"]=> string(9) "18.457761" ["Longitude"]=> string(10) "-66.196503" ["PrimaryAC"]=> string(3) "787" ["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"]=> string(5) "17282" ["Population2000"]=> NULL ["FIPS"]=> NULL ["cTZoffset"]=> string(2) "-4" ["DST"]=> string(1) "0" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
36 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
00979CAROLINAPR0Carolina13
00982CAROLINAPR0Carolina13
00983CAROLINAPR0Carolina13
00985CAROLINAPR0Carolina13
00987CAROLINAPR0Carolina13
00965GUAYNABOPR0Guaynabo
00966GUAYNABOPR0Guaynabo
00968GUAYNABOPR0Guaynabo
00969GUAYNABOPR0Guaynabo
00971GUAYNABOPR0Guaynabo
zipcodezipcityzipstatezippopulationcitynameDMAID
00934FORT BUCHANANPR0
00952SABANA SECAPR0Sabana Seca
00901SAN JUANPR0San Juan
00907SAN JUANPR0San Juan
00909SAN JUANPR0San Juan
00911SAN JUANPR0San Juan
00912SAN JUANPR0San Juan
00913SAN JUANPR0San Juan
00915SAN JUANPR0San Juan
00917SAN JUANPR0San Juan
zipcodezipcityzipstatezippopulationcitynameDMAID
00918SAN JUANPR0San Juan
00920SAN JUANPR0San Juan
00921SAN JUANPR0San Juan
00923SAN JUANPR0San Juan
00924SAN JUANPR0San Juan
00925SAN JUANPR0San Juan
00926SAN JUANPR0San Juan
00927SAN JUANPR0San Juan
00956BAYAMONPR0Bayamon
00957BAYAMONPR0Bayamon
zipcodezipcityzipstatezippopulationcitynameDMAID
00959BAYAMONPR0Bayamon
00961BAYAMONPR0Bayamon
00962CATANOPR0Catano
00976TRUJILLO ALTOPR0Trujillo Alto
00953TOA ALTAPR0Toa Alta
00949TOA BAJAPR0Toa Baja
Station WTOK-FM
City SAN JUAN-PR

City , is located in DMAID: