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


Number of rows returned = 0
Start: 1754168881.879
End: 1754168881.8796
Elapsed time: 0.5860 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80027" ["State"]=> string(2) "MA" ["CityName"]=> string(15) "North Dartmouth" ["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) "02747" ["zip3"]=> string(3) "027" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(15) "NORTH DARTMOUTH" ["zipstate"]=> string(2) "MA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "41.64" ["iplongitude"]=> string(3) "-71" ["ziplocation"]=> string(24) "NA-US-MA-NORTH DARTMOUTH" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "8861" ["zippopulation"]=> string(5) "15533" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "027" ["zipcity"]=> string(11) "NEW BEDFORD" ["zipstate"]=> string(2) "MA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "7664" ["State"]=> string(2) "MA" ["CityName"]=> string(11) "New Bedford" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "140" ["Population"]=> string(5) "99922" ["Latitude"]=> string(9) "41.651803" ["Longitude"]=> string(10) "-70.933705" ["PrimaryAC"]=> string(3) "508" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "7664" ["Population2000"]=> string(5) "93768" ["FIPS"]=> string(7) "2545000" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "174" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
7 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
7664MANew Bedford01409992241.651803-70.933705508001007664937682545000-5-1174
7513MAAttleboro01073838341.928099-71.314564508001107513420682502690-5-1174
17949RIWest Warwick-102926841.70375-71.51857940100000295814478260-5-1174
36051MASomerset-101765541.748502-71.15318800000182342562465-5-1174
36071MAWest Yarmouth-10540941.649547-70.2463850000064602578795-5-1174
7516MABarnstable0184279041.701418-70.300061508001007516-5-1174
79950MAFairhaven-10174
**** cities in zip3 **************
34 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
02780TAUNTONMA39589Taunton11
02703ATTLEBOROMA36164Attleboro174
02740NEW BEDFORDMA28944New Bedford174
02760NORTH ATTLEBOROMA22964North Attleboro
02720FALL RIVERMA22304Fall River36
02745NEW BEDFORDMA19536New Bedford174
02721FALL RIVERMA18264Fall River36
02747NORTH DARTMOUTHMA15533North Dartmouth
02766NORTONMA15129Norton
02777SWANSEAMA14102Swansea
zipcodezipcityzipstatezippopulationcitynameDMAID
02790WESTPORTMA13765Westport
02726SOMERSETMA13724Somerset174
02719FAIRHAVENMA13392Fairhaven174
02771SEEKONKMA12579Seekonk
02724FALL RIVERMA11903Fall River36
02767RAYNHAMMA11607
02769REHOBOTHMA10452Rehoboth
02723FALL RIVERMA10441Fall River36
02748SOUTH DARTMOUTHMA10032
02743ACUSHNETMA9079
zipcodezipcityzipstatezippopulationcitynameDMAID
02746NEW BEDFORDMA8919New Bedford174
02744NEW BEDFORDMA8050New Bedford174
02762PLAINVILLEMA7456
02718EAST TAUNTONMA5968
02739MATTAPOISETTMA5697Mattapoisett
02779BERKLEYMA5580
02770ROCHESTERMA4715Rochester
02717EAST FREETOWNMA4357
02738MARIONMA4357Marion
02702ASSONETMA3833Assonet
zipcodezipcityzipstatezippopulationcitynameDMAID
02764NORTH DIGHTONMA3638
02715DIGHTONMA2622Dighton
02725SOMERSETMA2190Somerset174
02763ATTLEBORO FALLSMA1856
Station WTKL-FM
City NORTH DARTMOUTH-MA

City North Dartmouth, MA is located in DMAID: