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


Number of rows returned = 0
Start: 1754177192.8407
End: 1754177192.8409
Elapsed time: 0.1390 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80161" ["State"]=> string(2) "PR" ["CityName"]=> string(8) "Patillas" ["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) "00723" ["zip3"]=> string(3) "007" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(8) "PATILLAS" ["zipstate"]=> string(2) "PR" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(2) "18" ["iplongitude"]=> string(6) "-66.01" ["ziplocation"]=> string(17) "NA-US-PR-PATILLAS" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "007" ["zipcity"]=> string(7) "AGUIRRE" ["zipstate"]=> string(2) "PR" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "17207" ["State"]=> string(2) "PR" ["CityName"]=> string(7) "Aguirre" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "0" ["Population"]=> NULL ["Latitude"]=> string(8) "17.99229" ["Longitude"]=> string(10) "-66.139253" ["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) "17207" ["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 **************
46 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
00705AIBONITOPR0Aibonito
00703AGUAS BUENASPR0Aguas Buenas
00704AGUIRREPR0Aguirre
00714ARROYOPR0Arroyo
00794BARRANQUITASPR0Barranquitas
00729CANOVANASPR0Canovanas
00729CANOVANASPR0Canóvanas177
00736CAYEYPR0Cayey13
00739CIDRAPR0Cidra13
00769COAMOPR0Coamo
zipcodezipcityzipstatezippopulationcitynameDMAID
00782COMERIOPR0Comerio
00783COROZALPR0Corozal13
00791HUMACAOPR0Humacao195
00795JUANA DIAZPR0Juana Diaz
00795JUANA DIAZPR0Juana Díaz
00777JUNCOSPR0Juncos
00728PONCEPR0Ponce13
00725CAGUASPR0Caguas13
00727CAGUASPR0Caguas13
00735CEIBAPR0Ceiba
zipcodezipcityzipstatezippopulationcitynameDMAID
00780COTO LAURELPR0Coto Laurel
00738FAJARDOPR0Fajardo
00784GUAYAMAPR0Guayama13
00778GURABOPR0Gurabo
00771LAS PIEDRASPR0Las Piedras
00772LOIZAPR0
00773LUQUILLOPR0Luquillo13
00707MAUNABOPR0Maunabo
00715MERCEDITAPR0
00718NAGUABOPR0Naguabo
zipcodezipcityzipstatezippopulationcitynameDMAID
00719NARANJITOPR0Naranjito
00720OROCOVISPR0Orocovis85
00723PATILLASPR0Patillas
00716PONCEPR0Ponce13
00717PONCEPR0Ponce13
00730PONCEPR0Ponce13
00731PONCEPR0Ponce13
00740PUERTO REALPR0Puerto Real
00741PUNTA SANTIAGOPR0Punta Santiago
00745RIO GRANDEPR0Rio Grande
zipcodezipcityzipstatezippopulationcitynameDMAID
00751SALINASPR0Salinas13
00754SAN LORENZOPR0San Lorenzo
00757SANTA ISABELPR0Santa Isabel
00765VIEQUESPR0Vieques
00766VILLALBAPR0Villalba
00767YABUCOAPR0Yabucoa13
***** 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 W232DR-FX
City PATILLAS-PR

City Patillas, PR is located in DMAID: