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


Number of rows returned = 0
Start: 1754171333.4034
End: 1754171333.4039
Elapsed time: 0.5009 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('PA','Colmar',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80077" ["State"]=> string(2) "PA" ["CityName"]=> string(6) "Colmar" ["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) "18915" ["zip3"]=> string(3) "189" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "COLMAR" ["zipstate"]=> string(2) "PA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "40.27" ["iplongitude"]=> string(6) "-75.26" ["ziplocation"]=> string(15) "NA-US-PA-COLMAR" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "707" ["zippopulation"]=> string(4) "1256" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "189" ["zipcity"]=> string(10) "DOYLESTOWN" ["zipstate"]=> string(2) "PA" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "16458" ["State"]=> string(2) "PA" ["CityName"]=> string(10) "Doylestown" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "326" ["Population"]=> string(4) "8575" ["Latitude"]=> string(9) "40.312756" ["Longitude"]=> string(10) "-75.128799" ["PrimaryAC"]=> string(3) "267" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "1" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "16458" ["Population2000"]=> string(4) "8227" ["FIPS"]=> string(7) "4219784" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
32 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
18974WARMINSTERPA37329
18966SOUTHAMPTONPA36515
18951QUAKERTOWNPA29756Quakertown
18940NEWTOWNPA27529Newtown
18901DOYLESTOWNPA25185Doylestown
18944PERKASIEPA20771Perkasie
18976WARRINGTONPA18088Warrington
18914CHALFONTPA18039Chalfont
18902DOYLESTOWNPA16495Doylestown
18969TELFORDPA13427Telford
zipcodezipcityzipstatezippopulationcitynameDMAID
18964SOUDERTONPA12365Souderton
18938NEW HOPEPA11903New Hope
18960SELLERSVILLEPA11241Sellersville
18954RICHBOROPA9580Richboro
18929JAMISONPA8215
18947PIPERSVILLEPA5133
18925FURLONGPA4806
18977WASHINGTON CROSSINGPA4027
18972UPPER BLACK EDDYPA2643Upper Black Eddy
18942OTTSVILLEPA2561
zipcodezipcityzipstatezippopulationcitynameDMAID
18930KINTNERSVILLEPA2220
18917DUBLINPA1831Dublin
18955RICHLANDTOWNPA1308Richlandtown
18915COLMARPA1256Colmar
18923FOUNTAINVILLEPA993
18920ERWINNAPA612Erwinna
18932LINE LEXINGTONPA502Line Lexington
18913CARVERSVILLEPA421Carversville
18933LUMBERVILLEPA0
18927HILLTOWNPA0
zipcodezipcityzipstatezippopulationcitynameDMAID
18934MECHANICSVILLEPA0Mechanicsville
18936MONTGOMERYVILLEPA0Montgomeryville
***** 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 W246CN-FX
City COLMAR-PA

City Colmar, PA is located in DMAID: