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


Number of rows returned = 0
Start: 1754150223.2384
End: 1754150223.2387
Elapsed time: 0.2189 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "79885" ["State"]=> string(2) "RI" ["CityName"]=> string(10) "Smithfield" ["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) "02917" ["zip3"]=> string(3) "029" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "SMITHFIELD" ["zipstate"]=> string(2) "RI" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(4) "41.9" ["iplongitude"]=> string(6) "-71.53" ["ziplocation"]=> string(19) "NA-US-RI-SMITHFIELD" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "5944" ["zippopulation"]=> string(5) "10133" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "029" ["zipcity"]=> string(10) "PROVIDENCE" ["zipstate"]=> string(2) "RI" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "17940" ["State"]=> string(2) "RI" ["CityName"]=> string(10) "Providence" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "284" ["Population"]=> string(6) "160728" ["Latitude"]=> string(8) "41.82355" ["Longitude"]=> string(10) "-71.422132" ["PrimaryAC"]=> string(3) "401" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "1" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "17940" ["Population2000"]=> string(6) "173618" ["FIPS"]=> string(7) "4459000" ["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 *************
13 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
17940RIProvidence028416072841.82355-71.42213240111100179401736184459000-5-136
7579MAFall River02849270341.698102-71.146994508001007579919382523000-5-136
17947RIWarwick01718542741.718114-71.4152274010110017947858084474300-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
40584RIBradford-10160441.400657-71.7476070000014974408020-5-136
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
17929RIHope Valley0191144641.511877-71.715411401000001792916494434660-5-136
17932RINarragansett018741.377185-71.4977934010010017932-5-136
17923RICoventry013741.694251-71.6367864010000017923-5-136
**** cities in zip3 **************
16 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
02920CRANSTONRI28279Cranston
02909PROVIDENCERI27797Providence36
02908PROVIDENCERI24468Providence36
02919JOHNSTONRI23966
02904PROVIDENCERI22164Providence36
02907PROVIDENCERI20468Providence36
02905PROVIDENCERI19006Providence36
02910CRANSTONRI18350Cranston
02906PROVIDENCERI17860Providence36
02914EAST PROVIDENCERI17218East Providence36
zipcodezipcityzipstatezippopulationcitynameDMAID
02915RIVERSIDERI14348Riverside
02911NORTH PROVIDENCERI12324North Providence
02921CRANSTONRI10886Cranston
02917SMITHFIELDRI10133Smithfield
02916RUMFORDRI7268
02903PROVIDENCERI5160Providence36
Station WJMF-FM
City SMITHFIELD-RI

City Smithfield, RI is located in DMAID: