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


Number of rows returned = 0
Start: 1754167271.2448
End: 1754167271.245
Elapsed time: 0.1361 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('VA','Earlysville',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79966" ["State"]=> string(2) "VA" ["CityName"]=> string(11) "Earlysville" ["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) "22936" ["zip3"]=> string(3) "229" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(11) "EARLYSVILLE" ["zipstate"]=> string(2) "VA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "38.15" ["iplongitude"]=> string(6) "-78.48" ["ziplocation"]=> string(20) "NA-US-VA-EARLYSVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "2606" ["zippopulation"]=> string(4) "4714" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "229" ["zipcity"]=> string(15) "CHARLOTTESVILLE" ["zipstate"]=> string(2) "VA" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "20256" ["State"]=> string(2) "VA" ["CityName"]=> string(15) "Charlottesville" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "171" ["Population"]=> string(5) "40341" ["Latitude"]=> string(9) "38.034506" ["Longitude"]=> string(10) "-78.486474" ["PrimaryAC"]=> string(3) "434" ["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"]=> string(5) "20256" ["Population2000"]=> string(5) "45049" ["FIPS"]=> string(7) "5114968" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "231" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
21 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20256VACharlottesville01714034138.034506-78.4864744340000020256450495114968-5-1231
20475VAPetersburg01923838637.21295-77.4004178040110020475337405161832-5-1231
20216VABlacksburg01263459037.229874-80.4176945400000020216395735107784-5-1231
20370VAHopewell-1922310137.290399-77.3033718040110020370223545138424-5-1231
20572VAWaynesboro071854938.069874-78.8945175400000020572195205183680-5-1231
20490VARadford0661594037.127585-80.5695232760000020490158595165392-5-1231
20264VAChristiansburg-1671500437.141164-80.40775400000020264169475116608-5-1231
20261VAChester01061498637.353449-77.4357678040110020261178905116096-5-1231
21655WVBluefield-1271275637.262219-81.2186743040000021655114515408524-5-1231
20486VAPulaski097998537.050094-80.772193540000002048694735164880-5-1231
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20333VAFranklin098786436.674954-76.930799757000002033383465129600-5-1231
20318VAEmporia0141530636.693018-77.53809434000002031856655125808-5-1231
20217VABlackstone-171349737.076661-78.001302434000002021736755107832-5-1231
20465VAOrange-12258238.245894-78.109786540000002046541235159496-5-1231
20286VACrozet-10225638.069922-78.701576434000002028628205120560-5-1231
20393VALawrenceville0152148636.75843-77.850424434000002039312755144520-5-1231
20402VALouisa0110108838.024057-78.001584276000002040214015147144-5-1231
20506VARural Retreat-14697236.898872-81.276061540000002050613505169456-5-1231
20301VADillwyn-1045837.541658-78.45886980400000203014475122560-5-1231
20183VAAlberta014733736.863589-77.88145543400000201833065100724-5-1231
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20403VALovingston-11337.753-78.8591534340000020403-5-1231
**** cities in zip3 **************
37 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
22901CHARLOTTESVILLEVA26610Charlottesville231
22980WAYNESBOROVA26271Waynesboro231
22903CHARLOTTESVILLEVA22192Charlottesville231
22902CHARLOTTESVILLEVA16159Charlottesville231
22911CHARLOTTESVILLEVA13319Charlottesville231
22963PALMYRAVA13052Palmyra
22968RUCKERSVILLEVA8084
22960ORANGEVA7992Orange231
22942GORDONSVILLEVA6217Gordonsville
22932CROZETVA5914Crozet231
zipcodezipcityzipstatezippopulationcitynameDMAID
22973STANARDSVILLEVA4838Stanardsville
22936EARLYSVILLEVA4714Earlysville
22939FISHERSVILLEVA4474Fishersville
22923BARBOURSVILLEVA4284
22947KESWICKVA4203
22974TROYVA3443
22920AFTONVA3352
22952LYNDHURSTVA1834Lyndhurst
22967ROSELANDVA1703
22958NELLYSFORDVA1698Nellysford
zipcodezipcityzipstatezippopulationcitynameDMAID
22959NORTH GARDENVA1457
22922ARRINGTONVA1431
22971SHIPMANVA1291
22949LOVINGSTONVA1242Lovingston231
22940FREE UNIONVA1131
22938FABERVA1067
22969SCHUYLERVA1037Schuyler
22937ESMONTVA1030
22935DYKEVA779
22943GREENWOODVA544Greenwood
zipcodezipcityzipstatezippopulationcitynameDMAID
22904CHARLOTTESVILLEVA0Charlottesville231
22931COVESVILLEVA0
22946KEENEVA0
22948LOCUST DALEVA0
22964PINEY RIVERVA0Piney River
22976TYROVA0
22972SOMERSETVA0
Station WKTR-AM
City EARLYSVILLE-VA

City Earlysville, VA is located in DMAID: