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


Number of rows returned = 0
Start: 1754179643.5893
End: 1754179643.5897
Elapsed time: 0.4401 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NY','Water Mill',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80270" ["State"]=> string(2) "NY" ["CityName"]=> string(10) "Water Mill" ["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) "11976" ["zip3"]=> string(3) "119" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "WATER MILL" ["zipstate"]=> string(2) "NY" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "40.92" ["iplongitude"]=> string(6) "-72.34" ["ziplocation"]=> string(19) "NA-US-NY-WATER MILL" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1247" ["zippopulation"]=> string(4) "2079" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "119" ["zipcity"]=> string(7) "SHIRLEY" ["zipstate"]=> string(2) "NY" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "38798" ["State"]=> string(2) "NY" ["CityName"]=> string(7) "Shirley" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "0" ["Population"]=> string(5) "22936" ["Latitude"]=> string(9) "40.796914" ["Longitude"]=> string(9) "-72.87102" ["PrimaryAC"]=> NULL ["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"]=> NULL ["Population2000"]=> string(5) "25395" ["FIPS"]=> string(7) "3667070" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
30 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
11967SHIRLEYNY21343Shirley
11901RIVERHEADNY18288Riverhead
11937EAST HAMPTONNY13646East Hampton260
11950MASTICNY12942Mastic
11949MANORVILLENY11993Manorville
11946HAMPTON BAYSNY11209Hampton Bays260
11961RIDGENY10813Ridge
11953MIDDLE ISLANDNY10735Middle Island
11951MASTIC BEACHNY10520Mastic Beach
11968SOUTHAMPTONNY8237Southampton18
zipcodezipcityzipstatezippopulationcitynameDMAID
11934CENTER MORICHESNY6565Center Moriches18
11963SAG HARBORNY6438Sag Harbor18
11933CALVERTONNY5527Calverton18
11971SOUTHOLDNY5443Southold260
11940EAST MORICHESNY4636East Moriches
11952MATTITUCKNY4432Mattituck
11942EAST QUOGUENY4125East Quogue
11954MONTAUKNY3976Montauk171
11980YAPHANKNY3573Yaphank
11944GREENPORTNY3484Greenport
zipcodezipcityzipstatezippopulationcitynameDMAID
11935CUTCHOGUENY3154Cutchogue
11978WESTHAMPTON BEACHNY3007Westhampton Beach
11955MORICHESNY2780Moriches
11941EASTPORTNY2190Eastport
11977WESTHAMPTONNY2110Westhampton120
11976WATER MILLNY2079Water Mill
11948LAURELNY998Laurel
11939EAST MARIONNY907East Marion
11958PECONICNY846Peconic
11957ORIENTNY803Orient
***** 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 W282CW-FX
City WATER MILL-NY

City Water Mill, NY is located in DMAID: