Fix KKRI 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 = 'POCOLA' and State = 'OK'

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

Number of rows returned = 1
Start: 1754152150.0473
End: 1754152150.0476
Elapsed time: 0.2601 ms 1 records found!
id State CityName RuralArea PopCount Population Latitude Longitude PrimaryAC ZoneDesc EartlinkDSL ISPCount CovadDSL VerizonDSL allegiance SBC RateCenterCityid Population2000 FIPS cTZoffset DST DMAID
15115 OK Pocola -1 0 3664 35.257983 -94.473959 918 0 0 0 0 0 15115 3994 4059750 -6 -1

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

NULL

****** zip code ************

array(13) { ["zipcode"]=> string(5) "74902" ["zip3"]=> string(3) "749" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "POCOLA" ["zipstate"]=> string(2) "OK" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "35.24" ["iplongitude"]=> string(6) "-94.47" ["ziplocation"]=> string(15) "NA-US-OK-POCOLA" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1825" ["zippopulation"]=> string(4) "3395" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "749" ["zipcity"]=> string(8) "SALLISAW" ["zipstate"]=> string(2) "OK" }

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

array(22) { ["id"]=> string(5) "15147" ["State"]=> string(2) "OK" ["CityName"]=> string(8) "Sallisaw" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "44" ["Population"]=> string(4) "7122" ["Latitude"]=> string(9) "35.457978" ["Longitude"]=> string(10) "-94.794421" ["PrimaryAC"]=> string(3) "918" ["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) "15147" ["Population2000"]=> string(4) "7989" ["FIPS"]=> string(7) "4065000" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "177" }

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

No Rows in Recordset!

***** cities in DMA by city *************

17 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
983	AR	Fort Smith	0	163	72798	35.368691	-94.398737	479		0		0	0	0	0	983	80268	524550	-6	-1	177
1217	AR	Van Buren	-1	82	14979	35.444339	-94.346737	479		0		0	0	0	0	1217	18986	571480	-6	-1	177
15120	OK	Poteau	-1	10	7210	35.05856	-94.630116	918		0		0	0	0	0	15120	7939	4060350	-6	-1	177
15147	OK	Sallisaw	-1	44	7122	35.457978	-94.794421	918		0		0	0	0	0	15147	7989	4065000	-6	-1	177
1097	AR	Mena	-1	80	5475	34.582208	-94.239039	479		0		0	0	0	0	1097	5637	545170	-6	-1	177
32526	AR	Barling	-1	0	4078	35.322728	-94.300663			0		0	0	0	0		4176	503640	-6	-1	177
1004	AR	Greenwood	-1	2	3984	35.215534	-94.253351	479		0		0	0	0	0	1004	7112	528780	-6	-1	177
902	AR	Booneville	-1	1	3804	35.13965	-93.921272	479		0		0	0	0	0	902	4117	507720	-6	-1	177
1141	AR	Paris	-1	1	3674	35.291665	-93.726156	479		0		0	0	0	0	1141	3707	553480	-6	-1	177
1136	AR	Ozark	-1	3	3330	35.492713	-93.837096	479		0		0	0	0	0	1136	3525	552970	-6	-1	177
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
1223	AR	Waldron	-1	1	3024	34.899191	-94.091483	479		0		0	0	0	0	1223	3508	572380	-6	-1	177
15073	OK	Muldrow	-1	14	2889	35.404336	-94.601073	918		0		0	0	0	0	15073	3104	4049850	-6	-1	177
14978	OK	Heavener	-1	2	2601	34.889108	-94.604217	918		0		0	0	0	0	14978	3201	4033400	-6	-1	177
39469	OK	Roland	-1	0	2481	35.418013	-94.514815			0		0	0	0	0		2842	4063800	-6	-1	177
15249	OK	Wister	-1	2	956	34.968411	-94.723191	918		0		0	0	0	0	15249	1002	4081750	-6	-1	177
68062	AR	Cedarville		0	0	35.582296	-94.360812			0	0	0	0	0	0	0	1133	512520	-6	-1	177
17221	PR	Canóvanas	-1	0				787		0		0	0	0	0				-4	0	177

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

25 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
74955	SALLISAW	OK	11017	Sallisaw	177
74960	STILWELL	OK	9727	Stilwell
74953	POTEAU	OK	8890	Poteau	177
74948	MULDROW	OK	8651	Muldrow	177
74959	SPIRO	OK	4769	Spiro
74937	HEAVENER	OK	4030	Heavener	177
74954	ROLAND	OK	3856	Roland	177
74965	WESTVILLE	OK	3821	Westville
74962	VIAN	OK	3500	Vian
74902	POCOLA	OK	3395	Pocola
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
74966	WISTER	OK	2772	Wister	177
74964	WATTS	OK	1929	Watts
74941	KEOTA	OK	1881	Keota
74932	CAMERON	OK	1693	Cameron
74940	HOWE	OK	1680	Howe
74956	SHADY POINT	OK	1423	Shady Point
74901	ARKOMA	OK	1344	Arkoma
74930	BOKOSHE	OK	1291	Bokoshe
74931	BUNCH	OK	924
74936	GANS	OK	835	Gans
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
74944	MCCURTAIN	OK	814	McCurtain
74957	SMITHVILLE	OK	799	Smithville
74939	HODGEN	OK	516
74949	MUSE	OK	0	Muse
74963	WATSON	OK	0

Station KKRI-FM

City POCOLA-OK

City , is located in DMAID: