Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix W241DE 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 = 'BAYAMON' and State = 'PR'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754144347.9623
End: 1754144347.9625
Elapsed time: 0.2029 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('PR','Bayamon',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79879" ["State"]=> string(2) "PR" ["CityName"]=> string(7) "Bayamon" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> NULL ["Population"]=> NULL ["Latitude"]=> NULL ["Longitude"]=> NULL ["PrimaryAC"]=> NULL ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> NULL ["ISPCount"]=> NULL ["CovadDSL"]=> NULL ["VerizonDSL"]=> NULL ["allegiance"]=> NULL ["SBC"]=> NULL ["RateCenterCityid"]=> NULL ["Population2000"]=> NULL ["FIPS"]=> NULL ["cTZoffset"]=> NULL ["DST"]=> string(1) "0" ["DMAID"]=> NULL }
****** zip code ************
array(13) { ["zipcode"]=> string(5) "00956" ["zip3"]=> string(3) "009" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(7) "BAYAMON" ["zipstate"]=> string(2) "PR" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "18.28" ["iplongitude"]=> string(6) "-66.13" ["ziplocation"]=> string(16) "NA-US-PR-BAYAMON" ["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 JUANPR0
00907SAN JUANPR0
00909SAN JUANPR0
00911SAN JUANPR0
00912SAN JUANPR0
00913SAN JUANPR0
00915SAN JUANPR0
00917SAN JUANPR0
zipcodezipcityzipstatezippopulationcitynameDMAID
00918SAN JUANPR0
00920SAN JUANPR0
00921SAN JUANPR0
00923SAN JUANPR0
00924SAN JUANPR0
00925SAN JUANPR0
00926SAN JUANPR0
00927SAN JUANPR0
00956BAYAMONPR0Bayamon
00957BAYAMONPR0Bayamon
zipcodezipcityzipstatezippopulationcitynameDMAID
00959BAYAMONPR0Bayamon
00961BAYAMONPR0Bayamon
00962CATANOPR0Catano
00976TRUJILLO ALTOPR0Trujillo Alto
00953TOA ALTAPR0Toa Alta
00949TOA BAJAPR0Toa Baja
***** stations in DMA*************
29 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
22706GCN2World Wide WebWW79841
41480GCN3World Wide WebWW79841
41481GCN4World Wide WebWW79841
77684GCN5World Wide WebWW79841
32729MOYLWorld Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
44298NPRWorld Wide WebWW79841
44299PRIWorld Wide WebWW79841
22707Radio AmericaWorld Wide WebWW79841
44583SportsBylineWorld Wide WebWW79841
23558TalkStarWorld Wide WebWW79841
40372TammyRadioWorld Wide WebWW79841
44584TheBlazeWorld Wide WebWW79841
22714USA/IRN3World Wide WebWW79841
44301YSNWorld Wide WebWW79841
Station W241DE-FX
City BAYAMON-PR

City Bayamon, PR is located in DMAID: