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


Number of rows returned = 0
Start: 1754173823.7226
End: 1754173823.7227
Elapsed time: 0.1671 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80104" ["State"]=> string(2) "CO" ["CityName"]=> string(8) "Hesperus" ["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) "81326" ["zip3"]=> string(3) "813" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(8) "HESPERUS" ["zipstate"]=> string(2) "CO" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "37.28" ["iplongitude"]=> string(7) "-108.03" ["ziplocation"]=> string(17) "NA-US-CO-HESPERUS" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "949" ["zippopulation"]=> string(4) "1702" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "813" ["zipcity"]=> string(7) "DURANGO" ["zipstate"]=> string(2) "CO" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2681" ["State"]=> string(2) "CO" ["CityName"]=> string(7) "Durango" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "232" ["Population"]=> string(5) "12430" ["Latitude"]=> string(9) "37.278666" ["Longitude"]=> string(11) "-107.871293" ["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) "2681" ["Population2000"]=> string(5) "13922" ["FIPS"]=> string(6) "822035" ["cTZoffset"]=> string(2) "-7" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
12 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
81301DURANGOCO19639Durango
81321CORTEZCO11209Cortez
81303DURANGOCO5722Durango
81323DOLORESCO3741Dolores
81328MANCOSCO2998Mancos
81326HESPERUSCO1702Hesperus
81324DOVE CREEKCO1155Dove Creek
81327LEWISCO547
81320CAHONECO0
81325EGNARCO0
zipcodezipcityzipstatezippopulationcitynameDMAID
81331PLEASANT VIEWCO0Pleasant View
81335YELLOW JACKETCO0
Station K237CR-FX
City HESPERUS-CO

City Hesperus, CO is located in DMAID: