Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WGTX FM Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9998" ["dmaType"]=> NULL ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(7) "Unrated" ["Population25up"]=> string(1) "0" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(0) "" }
Database: media
SQL: select * from cities where CityName = 'TRURO' and State = 'MA'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754171185.4259
End: 1754171185.4261
Elapsed time: 0.1521 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('MA','Truro',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80075" ["State"]=> string(2) "MA" ["CityName"]=> string(5) "Truro" ["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) "02666" ["zip3"]=> string(3) "026" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(5) "TRURO" ["zipstate"]=> string(2) "MA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(2) "42" ["iplongitude"]=> string(6) "-70.06" ["ziplocation"]=> string(14) "NA-US-MA-TRURO" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "700" ["zippopulation"]=> string(4) "1015" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "026" ["zipcity"]=> string(7) "MASHPEE" ["zipstate"]=> string(2) "MA" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "79986" ["State"]=> string(2) "MA" ["CityName"]=> string(7) "Mashpee" ["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 }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
28 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
02649MASHPEEMA12354Mashpee
02601HYANNISMA10685Hyannis185
02632CENTERVILLEMA9476Centerville
02631BREWSTERMA8575Brewster
02645HARWICHMA8325Harwich
02664SOUTH YARMOUTHMA8289South Yarmouth185
02673WEST YARMOUTHMA6986West Yarmouth174
02648MARSTONS MILLSMA6749Marstons Mills
02675YARMOUTH PORTMA5862Yarmouth Port
02660SOUTH DENNISMA5219South Dennis
zipcodezipcityzipstatezippopulationcitynameDMAID
02653ORLEANSMA4418Orleans185
02644FORESTDALEMA3812Forestdale
02633CHATHAMMA3482Chatham185
02642EASTHAMMA3336
02655OSTERVILLEMA3222Osterville
02635COTUITMA3159Cotuit
02657PROVINCETOWNMA3084Provincetown185
02668WEST BARNSTABLEMA2937West Barnstable
02638DENNISMA2894Dennis
02639DENNIS PORTMA2683Dennis Port
zipcodezipcityzipstatezippopulationcitynameDMAID
02667WELLFLEETMA2145Wellfleet185
02630BARNSTABLEMA1895Barnstable174
02646HARWICH PORTMA1742Harwich Port175
02670WEST DENNISMA1294West Dennis
02659SOUTH CHATHAMMA985
02671WEST HARWICHMA971
02650NORTH CHATHAMMA861
02636CENTERVILLEMA0Centerville
Station WGTX-FM
City TRURO-MA

City Truro, MA is located in DMAID: