Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix KTGW FM Station DMA
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 = 'FRUITLAND' and State = 'NM'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const3Using where


Number of rows returned = 0
Start: 1754171137.925
End: 1754171137.9253
Elapsed time: 0.3610 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NM','Fruitland',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80074" ["State"]=> string(2) "NM" ["CityName"]=> string(9) "Fruitland" ["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) "87416" ["zip3"]=> string(3) "874" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "FRUITLAND" ["zipstate"]=> string(2) "NM" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "36.73" ["iplongitude"]=> string(7) "-108.39" ["ziplocation"]=> string(18) "NA-US-NM-FRUITLAND" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1006" ["zippopulation"]=> string(4) "1734" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "874" ["zipcity"]=> string(10) "FARMINGTON" ["zipstate"]=> string(2) "NM" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "12812" ["State"]=> string(2) "NM" ["CityName"]=> string(10) "Farmington" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "138" ["Population"]=> string(5) "33997" ["Latitude"]=> string(9) "36.751549" ["Longitude"]=> string(11) "-108.189768" ["PrimaryAC"]=> string(3) "505" ["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) "12812" ["Population2000"]=> string(5) "37844" ["FIPS"]=> string(7) "3525800" ["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
87401FARMINGTONNM30882Farmington
87410AZTECNM11695Aztec
87413BLOOMFIELDNM10596Bloomfield
87402FARMINGTONNM8137Farmington
87420SHIPROCKNM5236Shiprock
87417KIRTLANDNM5126Kirtland
87415FLORA VISTANM2179Flora Vista
87416FRUITLANDNM1734Fruitland
87421WATERFLOWNM1141
87418LA PLATANM790
zipcodezipcityzipstatezippopulationcitynameDMAID
87412BLANCONM579
87419NAVAJO DAMNM0
Station KTGW-FM
City FRUITLAND-NM

City Fruitland, NM is located in DMAID: