Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WKKB FM Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9999" ["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 = 'MIDDLETOWN' and State = 'RI'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const7Using where


Number of rows returned = 0
Start: 1754167830.5825
End: 1754167830.5831
Elapsed time: 0.5538 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('RI','Middletown',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79987" ["State"]=> string(2) "RI" ["CityName"]=> string(10) "Middletown" ["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) "02842" ["zip3"]=> string(3) "028" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "MIDDLETOWN" ["zipstate"]=> string(2) "RI" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "41.51" ["iplongitude"]=> string(6) "-71.27" ["ziplocation"]=> string(19) "NA-US-RI-MIDDLETOWN" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "8265" ["zippopulation"]=> string(5) "13797" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "028" ["zipcity"]=> string(7) "WARWICK" ["zipstate"]=> string(2) "RI" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "17947" ["State"]=> string(2) "RI" ["CityName"]=> string(7) "Warwick" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "171" ["Population"]=> string(5) "85427" ["Latitude"]=> string(9) "41.718114" ["Longitude"]=> string(10) "-71.415227" ["PrimaryAC"]=> string(3) "401" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "17947" ["Population2000"]=> string(5) "85808" ["FIPS"]=> string(7) "4474300" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "36" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
14 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
17940RIProvidence028416072841.82355-71.42213240111100179401736184459000-5-136
7579MAFall River02849270341.698102-71.146994508001007579919382523000-5-136
17947RIWarwick01718542741.718114-71.4152274010110017947858084474300-5-136
17938RIPawtucket01937264441.875499-71.3759814010110017938729584454640-5-136
40587RIEast Providence-105038041.8015-71.36082400000486884422960-5-136
17951RIWoonsocket02074387742.001731-71.5072234010010017951432244480780-5-136
17950RIWesterly01711647741.374807-71.818734010000017950176824476820-5-136
40588RIGreenville-10830341.876749-71.5533750000086264431600-5-136
17937RIPascoag0184501141.957401-71.705957401000001793747424454460-5-136
7580MAFalmouth050404741.548504-70.60484250800100758041152523070-5-136
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
40584RIBradford-10160441.400657-71.7476070000014974408020-5-136
17929RIHope Valley0191144641.511877-71.715411401000001792916494434660-5-136
17932RINarragansett018741.377185-71.4977934010010017932-5-136
17923RICoventry013741.694251-71.6367864010000017923-5-136
**** cities in zip3 **************
57 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
02860PAWTUCKETRI32700Pawtucket36
02895WOONSOCKETRI30278Woonsocket36
02864CUMBERLANDRI29895Cumberland
02816COVENTRYRI27787Coventry36
02886WARWICKRI25122Warwick36
02889WARWICKRI24614Warwick36
02893WEST WARWICKRI24077West Warwick174
02861PAWTUCKETRI22037Pawtucket36
02852NORTH KINGSTOWNRI20118North Kingstown
02891WESTERLYRI18883Westerly36
zipcodezipcityzipstatezippopulationcitynameDMAID
02888WARWICKRI17491Warwick36
02879WAKEFIELDRI17248
02840NEWPORTRI17022Newport170
02809BRISTOLRI16829Bristol35
02818EAST GREENWICHRI16723East Greenwich
02871PORTSMOUTHRI15498Portsmouth60
02865LINCOLNRI15355
02806BARRINGTONRI15163Barrington
02878TIVERTONRI13961Tiverton
02842MIDDLETOWNRI13797Middletown
zipcodezipcityzipstatezippopulationcitynameDMAID
02863CENTRAL FALLSRI12807Central Falls
02882NARRAGANSETTRI10236Narragansett36
02885WARRENRI8830Warren
02896NORTH SMITHFIELDRI8477
02857NORTH SCITUATERI7729
02813CHARLESTOWNRI6822
02814CHEPACHETRI6606
02828GREENVILLERI6569Greenville36
02817WEST GREENWICHRI5436
02830HARRISVILLERI5420Harrisville
zipcodezipcityzipstatezippopulationcitynameDMAID
02859PASCOAGRI5307Pascoag36
02874SAUNDERSTOWNRI5257
02822EXETERRI5183
02835JAMESTOWNRI5079Jamestown
02825FOSTERRI4719
02892WEST KINGSTONRI4536
02832HOPE VALLEYRI4094Hope Valley36
02831HOPERI3532
02837LITTLE COMPTONRI3047Little Compton
02838MANVILLERI2736
zipcodezipcityzipstatezippopulationcitynameDMAID
02804ASHAWAYRI2518Ashaway
02808BRADFORDRI2043Bradford36
02881KINGSTONRI2040Kingston161
02827GREENERI2027
02898WYOMINGRI1900
02839MAPLEVILLERI1601
02812CAROLINARI1368Carolina
02876SLATERSVILLERI1211
02894WOOD RIVER JUNCTIONRI706
02833HOPKINTONRI559
zipcodezipcityzipstatezippopulationcitynameDMAID
02836KENYONRI0
02815CLAYVILLERI0
02858OAKLANDRI0
02841NEWPORTRI0Newport170
02875SHANNOCKRI0
02877SLOCUMRI0
02854NORTH KINGSTOWNRI0North Kingstown
Station WKKB-FM
City MIDDLETOWN-RI

City Middletown, RI is located in DMAID: