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 = 'WOODY CREEK' and State = 'CO'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754144285.186
End: 1754144285.1864
Elapsed time: 0.4010 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('CO','Woody Creek',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79873" ["State"]=> string(2) "CO" ["CityName"]=> string(11) "Woody Creek" ["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) "81656" ["zip3"]=> string(3) "816" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(11) "WOODY CREEK" ["zipstate"]=> string(2) "CO" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "39.28" ["iplongitude"]=> string(7) "-106.88" ["ziplocation"]=> string(20) "NA-US-CO-WOODY CREEK" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "269" ["zippopulation"]=> string(3) "412" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "816" ["zipcity"]=> string(16) "GLENWOOD SPRINGS" ["zipstate"]=> string(2) "CO" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2708" ["State"]=> string(2) "CO" ["CityName"]=> string(16) "Glenwood Springs" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "153" ["Population"]=> string(4) "6561" ["Latitude"]=> string(9) "39.539575" ["Longitude"]=> string(11) "-107.329449" ["PrimaryAC"]=> string(3) "970" ["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(4) "2708" ["Population2000"]=> string(4) "7736" ["FIPS"]=> string(6) "830780" ["cTZoffset"]=> string(2) "-7" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
25 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
81623CARBONDALECO11557Carbondale
81601GLENWOOD SPRINGSCO10418Glenwood Springs
81650RIFLECO10027Rifle264
81625CRAIGCO9057Craig
81632EDWARDSCO6273Edwards
81647NEW CASTLECO5351New Castle
81621BASALTCO5321Basalt
81611ASPENCO5266Aspen
81635PARACHUTECO4862Parachute
81637GYPSUMCO4489Gypsum
zipcodezipcityzipstatezippopulationcitynameDMAID
81652SILTCO4113Silt
81641MEEKERCO3184Meeker
81657VAILCO3068Vail
81648RANGELYCO2189Rangely
81639HAYDENCO1897Hayden
81624COLLBRANCO1009Collbran
81654SNOWMASSCO978Snowmass
81630DE BEQUECO831De Beque
81643MESACO689Mesa
81610DINOSAURCO0Dinosaur
zipcodezipcityzipstatezippopulationcitynameDMAID
81633DINOSAURCO0Dinosaur
81638HAMILTONCO0
81640MAYBELLCO0Maybell
81642MEREDITHCO0
81653SLATERCO0Slater
Station K234BJ-FX
City WOODY CREEK-CO

City Woody Creek, CO is located in DMAID: