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 = 'BRANDY STATION' and State = 'VA'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


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

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

*** city ***************
array(22) { ["id"]=> string(5) "80131" ["State"]=> string(2) "VA" ["CityName"]=> string(14) "Brandy Station" ["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) "22714" ["zip3"]=> string(3) "227" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(14) "BRANDY STATION" ["zipstate"]=> string(2) "VA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "38.52" ["iplongitude"]=> string(6) "-77.89" ["ziplocation"]=> string(23) "NA-US-VA-BRANDY STATION" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "525" ["zippopulation"]=> string(3) "975" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "227" ["zipcity"]=> string(8) "CULPEPER" ["zipstate"]=> string(2) "VA" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "20287" ["State"]=> string(2) "VA" ["CityName"]=> string(8) "Culpeper" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "155" ["Population"]=> string(4) "8581" ["Latitude"]=> string(9) "38.471915" ["Longitude"]=> string(10) "-77.999168" ["PrimaryAC"]=> string(3) "276" ["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) "20287" ["Population2000"]=> string(4) "9664" ["FIPS"]=> string(7) "5120752" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "154" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
7 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20334VAFredericksburg02121902738.301829-77.4707782760000020334192795129744-5-1154
20287VACulpeper0155858138.471915-77.999168276000002028796645120752-5-1154
20275VAColonial Beach0107313238.25384-76.968941804000002027532285118400-5-1154
20384VAKilmarnock-1109110937.712437-76.381707804000002038412445142424-5-1154
20224VABowling Green-14572738.053428-77.34740480400000202249365108888-5-1154
20363VAHeathsville-11337.876733-76.4273348040000020363-5-1154
20525VASpotsylvania-1038.182869-77.699325400000020525-5-1154
**** cities in zip3 **************
36 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
22701CULPEPERVA25160Culpeper154
22712BEALETONVA7400
22727MADISONVA4469Madison
22737RIXEYVILLEVA2576
22734REMINGTONVA2573Remington
22728MIDLANDVA2546
22724JEFFERSONTONVA2034
22735REVAVA1686
22742SUMERDUCKVA1481
22740SPERRYVILLEVA1144Sperryville
zipcodezipcityzipstatezippopulationcitynameDMAID
22713BOSTONVA1131
22733RAPIDANVA1091
22747WASHINGTONVA1089Washington
22714BRANDY STATIONVA975Brandy Station
22715BRIGHTWOODVA948
22738ROCHELLEVA839
22720GOLDVEINVA764
22709ARODAVA728
22716CASTLETONVA679
22726LIGNUMVA635
zipcodezipcityzipstatezippopulationcitynameDMAID
22718ELKWOODVA561
22722HAYWOODVA0
22723HOODVA0
22725LEONVA0
22736RICHARDSVILLEVA0
22711BANCOVA0
22719ETLANVA0
22729MITCHELLSVA0
22730OAKPARKVA0
22731PRATTSVA0
zipcodezipcityzipstatezippopulationcitynameDMAID
22732RADIANTVA0
22746VIEWTOWNVA0
22749WOODVILLEVA0
22741STEVENSBURGVA0
22743SYRIAVA0
22721GRAVES MILLVA0
Station WPRZ-FM
City BRANDY STATION-VA

City Brandy Station, VA is located in DMAID: