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 = 'ACRA' and State = 'NY'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754177325.3963
End: 1754177325.3965
Elapsed time: 0.1540 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NY','Acra',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80174" ["State"]=> string(2) "NY" ["CityName"]=> string(4) "Acra" ["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) "12405" ["zip3"]=> string(3) "124" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(4) "ACRA" ["zipstate"]=> string(2) "NY" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "42.33" ["iplongitude"]=> string(6) "-74.09" ["ziplocation"]=> string(13) "NA-US-NY-ACRA" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "310" ["zippopulation"]=> string(3) "548" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "124" ["zipcity"]=> string(8) "KINGSTON" ["zipstate"]=> string(2) "NY" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "13537" ["State"]=> string(2) "NY" ["CityName"]=> string(8) "Kingston" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "199" ["Population"]=> string(5) "23095" ["Latitude"]=> string(9) "41.928877" ["Longitude"]=> string(10) "-74.004088" ["PrimaryAC"]=> string(3) "845" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "13537" ["Population2000"]=> string(5) "23456" ["FIPS"]=> string(7) "3639727" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "162" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
13 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
13775NYPoughkeepsie02792884441.700093-73.9229058450010013775298713659641-5-1162
13537NYKingston01992309541.928877-74.0040888450010013537234563639727-5-1162
7669MANorth Adams0161679742.693899-73.115096413001007669146812546225-5-1162
13223NYBeacon-11151324341.504243-73.9655768450010013223138083605100-5-1162
13287NYCatskill0155469042.218704-73.86679518000001328743923613002-5-1162
13828NYSaugerties-153391542.076282-73.950219845000001382849553665288-5-1162
13806NYRosendale041128441.849303-74.0761988450000013806-5-1162
13811NYRoxbury-106070000013811-5-1162
13739NYPatterson-1488450010013739-5-1162
13734NYPalenville-14442.169858-74.01911518000001373411203656132-5-1162
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
13510NYHyde Park01028450000013510-5-1162
13450NYGrand Gorge-116070000013450-5-1162
13972NYWindham-1442.311591-74.24711651800000139723593682469-5-1162
**** cities in zip3 **************
66 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
12401KINGSTONNY25786Kingston162
12477SAUGERTIESNY14990Saugerties162
12414CATSKILLNY7717Catskill162
12428ELLENVILLENY4494Ellenville137
12498WOODSTOCKNY4117Woodstock137
12446KERHONKSONNY3920Kerhonkson
12443HURLEYNY3582Hurley
12449LAKE KATRINENY2895Lake Katrine
12404ACCORDNY2879Accord
12466PORT EWENNY2628Port Ewen
zipcodezipcityzipstatezippopulationcitynameDMAID
12484STONE RIDGENY2600Stone Ridge
12413CAIRONY2425Cairo
12487ULSTER PARKNY2415
12458NAPANOCHNY1907Napanoch
12491WEST HURLEYNY1770West Hurley
12440HIGH FALLSNY1589High Falls
12451LEEDSNY1419Leeds
12472ROSENDALENY1409Rosendale162
12455MARGARETVILLENY1398Margaretville
12461OLIVEBRIDGENY1374Olivebridge
zipcodezipcityzipstatezippopulationcitynameDMAID
12486TILLSONNY1336Tillson
12463PALENVILLENY1231Palenville162
12481SHOKANNY1200Shokan
12431FREEHOLDNY1188Freehold
12496WINDHAMNY1153Windham162
12474ROXBURYNY985Roxbury162
12468PRATTSVILLENY881Prattsville
12423EAST DURHAMNY849
12409BEARSVILLENY836
12464PHOENICIANY816Phoenicia
zipcodezipcityzipstatezippopulationcitynameDMAID
12485TANNERSVILLENY811Tannersville
12442HUNTERNY772Hunter
12430FLEISCHMANNSNY765Fleischmanns
12473ROUND TOPNY741
12456MOUNT MARIONNY734
12482SOUTH CAIRONY691
12419COTTEKILLNY621
12494WEST SHOKANNY600
12457MOUNT TREMPERNY564
12412BOICEVILLENY551
zipcodezipcityzipstatezippopulationcitynameDMAID
12405ACRANY548Acra
12434GRAND GORGENY547Grand Gorge162
12469PRESTON HOLLOWNY526
12406ARKVILLENY519
12480SHANDAKENNY458
12411BLOOMINGTONNY455
12407ASHLANDNY0
12410BIG INDIANNY0
12470PURLINGNY0
12416CHICHESTERNY0
zipcodezipcityzipstatezippopulationcitynameDMAID
12418CORNWALLVILLENY0
12421DENVERNY0
12427ELKA PARKNY0
12433GLENFORDNY0
12435GREENFIELD PARKNY0
12439HENSONVILLENY0
12444JEWETTNY0
12448LAKE HILLNY0
12450LANESVILLENY0
12454MAPLECRESTNY0
zipcodezipcityzipstatezippopulationcitynameDMAID
12422DURHAMNY0Durham
12460OAK HILLNY0Oak Hill
12465PINE HILLNY0Pine Hill
12424EAST JEWETTNY0
12492WEST KILLNY0
12495WILLOWNY0
Station WGXC-FM
City ACRA-NY

City Acra, NY is located in DMAID: