Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix K296GT Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2009-06-13 09:56:14" ["dmarank"]=> string(1) "0" ["dmaID"]=> string(1) "0" ["dmaType"]=> string(1) "C" ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(13) "United States" ["Population25up"]=> string(9) "300000000" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(2) "WW" }
Database: media
SQL: select * from cities where CityName = 'TUCSON' and State = 'AZ'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const2Using where


Number of rows returned = 1
Start: 1754204204.2178
End: 1754204204.2186
Elapsed time: 0.7751 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
1393AZTucson025140539032.214476-110.918192520010001393486699477000-7061

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "85706" ["zip3"]=> string(3) "857" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "TUCSON" ["zipstate"]=> string(2) "AZ" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "32.07" ["iplongitude"]=> string(7) "-110.88" ["ziplocation"]=> string(15) "NA-US-AZ-TUCSON" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "22313" ["zippopulation"]=> string(5) "42504" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "857" ["zipcity"]=> string(6) "TUCSON" ["zipstate"]=> string(2) "AZ" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "1393" ["State"]=> string(2) "AZ" ["CityName"]=> string(6) "Tucson" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "251" ["Population"]=> string(6) "405390" ["Latitude"]=> string(9) "32.214476" ["Longitude"]=> string(11) "-110.918192" ["PrimaryAC"]=> string(3) "520" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "1393" ["Population2000"]=> string(6) "486699" ["FIPS"]=> string(6) "477000" ["cTZoffset"]=> string(2) "-7" ["DST"]=> string(1) "0" ["DMAID"]=> string(2) "61" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
7 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
1393AZTucson025140539032.214476-110.918192520010001393486699477000-7061
32830AZGreen Valley-101323131.855617-111.0000770000017283429710-7061
32811AZCatalina-10486432.491151-110.907652000007025411160-7061
32846AZOracle-10304332.61603-110.781854000003563451180-7061
32837AZKearny-10226233.05416-110.908857000002249437200-7061
32842AZMarana-10218732.386539-111.1254370000013556444270-7061
68132AZSahuarita0031.929245-110.98224100000003242462140-7061
**** cities in zip3 **************
31 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
85706TUCSONAZ42504Tucson61
85710TUCSONAZ41204Tucson61
85705TUCSONAZ35072Tucson61
85713TUCSONAZ31479Tucson61
85746TUCSONAZ30332Tucson61
85730TUCSONAZ30004Tucson61
85711TUCSONAZ29028Tucson61
85745TUCSONAZ26509Tucson61
85741TUCSONAZ25062Tucson61
85704TUCSONAZ24722Tucson61
zipcodezipcityzipstatezippopulationcitynameDMAID
85718TUCSONAZ23069Tucson61
85743TUCSONAZ22093Tucson61
85712TUCSONAZ21914Tucson61
85719TUCSONAZ21278Tucson61
85716TUCSONAZ21232Tucson61
85742TUCSONAZ20908Tucson61
85750TUCSONAZ20875Tucson61
85747TUCSONAZ18812Tucson61
85737TUCSONAZ18767Tucson61
85749TUCSONAZ16821Tucson61
zipcodezipcityzipstatezippopulationcitynameDMAID
85748TUCSONAZ15719Tucson61
85715TUCSONAZ15265Tucson61
85756TUCSONAZ14665Tucson61
85739TUCSONAZ14012Tucson61
85755TUCSONAZ12081Tucson61
85757TUCSONAZ11335Tucson61
85714TUCSONAZ10183Tucson61
85735TUCSONAZ7943Tucson61
85701TUCSONAZ3370Tucson61
85736TUCSONAZ2676Tucson61
zipcodezipcityzipstatezippopulationcitynameDMAID
85708TUCSONAZ2435Tucson61
***** stations in DMA*************
26 records found!
stationidCallSignLicenseeServicecitynamexStatexcityid
22710BTRNWorld Wide WebWW79841
23163CRN1World Wide WebWW79841
23164CRN2World Wide WebWW79841
23165CRN3World Wide WebWW79841
23166CRN4World Wide WebWW79841
23167CRN5World Wide WebWW79841
23168CRN6World Wide WebWW79841
42585CSPAN1World Wide WebWW79841
42586CSPAN2World Wide WebWW79841
42587CSPAN3World Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
22711ESPNWorld Wide WebWW79841
58943EWTNWorld Wide WebWW79841
22652Fox NewsWorld Wide WebWW79841
22712Fox SportsWorld Wide WebWW79841
41312GCN1World Wide WebWW79841
41481GCN4World Wide WebWW79841
77684GCN5World Wide WebWW79841
32729MOYLWorld Wide WebWW79841
44298NPRWorld Wide WebWW79841
44299PRIWorld Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
22707Radio AmericaWorld Wide WebWW79841
44583SportsBylineWorld Wide WebWW79841
23558TalkStarWorld Wide WebWW79841
40372TammyRadioWorld Wide WebWW79841
44584TheBlazeWorld Wide WebWW79841
44301YSNWorld Wide WebWW79841
Station K296GT-FX
City TUCSON-AZ

City , is located in DMAID: