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 = 'CHURCHVILLE' and State = 'VA'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const3Using where


Number of rows returned = 0
Start: 1754192165.4652
End: 1754192165.4655
Elapsed time: 0.3150 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80330" ["State"]=> string(2) "VA" ["CityName"]=> string(11) "Churchville" ["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) "24421" ["zip3"]=> string(3) "244" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(11) "CHURCHVILLE" ["zipstate"]=> string(2) "VA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "38.22" ["iplongitude"]=> string(6) "-79.16" ["ziplocation"]=> string(20) "NA-US-VA-CHURCHVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1767" ["zippopulation"]=> string(4) "3224" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "244" ["zipcity"]=> string(8) "STAUNTON" ["zipstate"]=> string(2) "VA" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "20530" ["State"]=> string(2) "VA" ["CityName"]=> string(8) "Staunton" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "139" ["Population"]=> string(5) "24461" ["Latitude"]=> string(8) "38.15792" ["Longitude"]=> string(9) "-79.07645" ["PrimaryAC"]=> string(3) "540" ["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) "20530" ["Population2000"]=> string(5) "23853" ["FIPS"]=> string(7) "5175216" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "276" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
16 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20358VAHarrisonburg01173070738.443279-78.8727592760000020358404685135624-5-1276
20530VAStaunton01392446138.15792-79.076455400000020530238535175216-5-1276
20279VACovington04699137.786225-79.988817276000002027963035119728-5-1276
20397VALexington-181695937.782938-79.445198540000002039768675145512-5-1276
20239VABuena Vista-150640637.732184-79.353325540000002023963495111032-5-1276
20268VAClifton Forge-10467937.819801-79.823584540000002026842895117440-5-1276
20404VALuray-157458738.664097-78.454531540000002040448715147528-5-1276
20230VABridgewater-13391838.386748-78.969678540000002023052035109656-5-1276
20519VAShenandoah-10221338.488225-78.621217540000002051918785171776-5-1276
20433VAMount Jackson-10158338.74995-78.637638540000002043316645153992-5-1276
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20443VANew Market-10143538.644472-78.673403540000002044316375155848-5-1276
20315VAEdinburg-1486038.822558-78.56536254000000203158135125008-5-1276
41699VAIron Gate-1041737.798484-79.791219000004045140024-5-1276
20428VAMonterey-1122238.411888-79.58046854000000204281585152680-5-1276
70166VAGreenville0038.004412-79.15796400000008865132944-5-1276
20371VAHot Springs-1437.994443-79.8315935400000020371-5-1276
**** cities in zip3 **************
37 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
24401STAUNTONVA27407Staunton276
24426COVINGTONVA11647Covington276
24450LEXINGTONVA11305Lexington276
24477STUARTS DRAFTVA8956Stuarts Draft
24416BUENA VISTAVA6616Buena Vista276
24441GROTTOESVA5011Grottoes
24422CLIFTON FORGEVA4821Clifton Forge276
24482VERONAVA4032Verona
24421CHURCHVILLEVA3224Churchville
24486WEYERS CAVEVA2989Weyers Cave
zipcodezipcityzipstatezippopulationcitynameDMAID
24431CRIMORAVA2321Crimora
24445HOT SPRINGSVA2211Hot Springs276
24440GREENVILLEVA2186Greenville276
24467MOUNT SIDNEYVA1897
24472RAPHINEVA1812Raphine
24435FAIRFIELDVA1631
24479SWOOPEVA1344
24460MILLBOROVA1291
24430CRAIGSVILLEVA1243Craigsville
24471PORT REPUBLICVA1190
zipcodezipcityzipstatezippopulationcitynameDMAID
24465MONTEREYVA1144Monterey276
24439GOSHENVA917Goshen
24473ROCKBRIDGE BATHSVA735
24459MIDDLEBROOKVA716
24484WARM SPRINGSVA709
24437FORT DEFIANCEVA671
24483VESUVIUSVA576
24413BLUE GRASSVA0Blue Grass
24432DEERFIELDVA0Deerfield
24433DOE HILLVA0
zipcodezipcityzipstatezippopulationcitynameDMAID
24442HEAD WATERSVA0
24458MC DOWELLVA0
24464MONTEBELLOVA0
24468MUSTOEVA0
24476STEELES TAVERNVA0
24485WEST AUGUSTAVA0
24487WILLIAMSVILLEVA0Williamsville
Station WNLR-AM
City CHURCHVILLE-VA

City Churchville, VA is located in DMAID: