Fix KRRT FM Station DMA

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 = 'ARROYO SECO' and State = 'NM'

Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
cities	ref	CityName	CityName	53	const	1	Using where

Number of rows returned = 0
Start: 1754168963.448
End: 1754168963.4482
Elapsed time: 0.2120 ms No Rows in Recordset!

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

*** city ***************

array(22) { ["id"]=> string(5) "80029" ["State"]=> string(2) "NM" ["CityName"]=> string(11) "Arroyo Seco" ["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) "87514" ["zip3"]=> string(3) "875" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(11) "ARROYO SECO" ["zipstate"]=> string(2) "NM" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "36.51" ["iplongitude"]=> string(7) "-105.56" ["ziplocation"]=> string(20) "NA-US-NM-ARROYO SECO" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "613" ["zippopulation"]=> string(3) "970" ["zipincome"]=> string(7) "8388607" }

******* zip3 ***********

array(3) { ["zip3"]=> string(3) "875" ["zipcity"]=> string(8) "SANTA FE" ["zipstate"]=> string(2) "NM" }

**** zip3 city**************

array(22) { ["id"]=> string(5) "12889" ["State"]=> string(2) "NM" ["CityName"]=> string(8) "Santa Fe" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "182" ["Population"]=> string(5) "55859" ["Latitude"]=> string(9) "35.667231" ["Longitude"]=> string(11) "-105.964575" ["PrimaryAC"]=> string(3) "505" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "12889" ["Population2000"]=> string(5) "62203" ["FIPS"]=> string(7) "3570500" ["cTZoffset"]=> string(2) "-7" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }

**** cities in DMA per station **************

No Rows in Recordset!

**** cities in zip3 **************

38 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
87507	SANTA FE	NM	31449	Santa Fe
87505	SANTA FE	NM	23843	Santa Fe
87544	LOS ALAMOS	NM	16811	Los Alamos	70
87508	SANTA FE	NM	13360	Santa Fe
87501	SANTA FE	NM	12352	Santa Fe
87532	ESPANOLA	NM	11670	Espanola	238
87506	SANTA FE	NM	8870	Santa Fe
87571	TAOS	NM	8543	Taos	70
87557	RANCHOS DE TAOS	NM	5241	Ranchos De Taos	70
87567	SANTA CRUZ	NM	3675	Santa Cruz
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
87529	EL PRADO	NM	3356
87522	CHIMAYO	NM	2265	Chimayo
87552	PECOS	NM	2212	Pecos	238
87566	OHKAY OWINGEH	NM	2147
87556	QUESTA	NM	1823	Questa	70
87528	DULCE	NM	1678	Dulce	70
87520	CHAMA	NM	1199	Chama
87535	GLORIETA	NM	1177	Glorieta
87553	PENASCO	NM	1059	Penasco
87560	RIBERA	NM	919
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
87510	ABIQUIU	NM	887	Abiquiu
87530	EL RITO	NM	815	El Rito
87540	LAMY	NM	717	Lamy
87537	HERNANDEZ	NM	675
87549	OJO CALIENTE	NM	664	Ojo Caliente
87521	CHAMISAL	NM	637	Chamisal
87579	VADITO	NM	555	Vadito
87575	TIERRA AMARILLA	NM	507	Tierra Amarilla
87516	CANONES	NM	0
87576	TRAMPAS	NM	0
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
87531	EMBUDO	NM	0
87539	LA MADERA	NM	0
87551	LOS OJOS	NM	0
87538	ILFELD	NM	0
87565	SAN JOSE	NM	0
87580	VALDEZ	NM	0
87573	TERERRO	NM	0
87581	VALLECITOS	NM	0	Vallecitos

Station KRRT-FM

City ARROYO SECO-NM

City Arroyo Seco, NM is located in DMAID: