Fix KSHQ FM Station DMA

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2008-06-09 18:15:12" ["dmarank"]=> string(3) "243" ["dmaID"]=> string(3) "240" ["dmaType"]=> string(1) "C" ["Minority"]=> string(1) "-" ["QualType"]=> string(2) "QD" ["DMAName"]=> string(32) "Pittsburg, KS (Southeast Kansas)" ["Population25up"]=> string(6) "136700" ["scanned"]=> NULL ["AvgLatitude"]=> string(7) "37.5138" ["AvgLongitude"]=> string(8) "-95.2349" ["State"]=> string(2) "s)" }

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

array(22) { ["id"]=> string(4) "9845" ["State"]=> string(2) "MO" ["CityName"]=> string(9) "Deerfield" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "0" ["Population"]=> string(2) "85" ["Latitude"]=> string(9) "37.839003" ["Longitude"]=> string(10) "-94.506819" ["PrimaryAC"]=> string(3) "417" ["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) "9845" ["Population2000"]=> string(2) "75" ["FIPS"]=> string(7) "2918802" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "240" }

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

array(13) { ["zipcode"]=> string(5) "64741" ["zip3"]=> string(3) "647" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "DEERFIELD" ["zipstate"]=> string(2) "MO" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "37.83" ["iplongitude"]=> string(5) "-94.5" ["ziplocation"]=> string(18) "NA-US-MO-DEERFIELD" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }

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

array(3) { ["zip3"]=> string(3) "647" ["zipcity"]=> string(13) "HARRISONVILLE" ["zipstate"]=> string(2) "MO" }

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

array(22) { ["id"]=> string(4) "9956" ["State"]=> string(2) "MO" ["CityName"]=> string(13) "Harrisonville" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "82" ["Population"]=> string(4) "7683" ["Latitude"]=> string(9) "38.653592" ["Longitude"]=> string(10) "-94.346915" ["PrimaryAC"]=> string(3) "816" ["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) "9956" ["Population2000"]=> string(4) "8946" ["FIPS"]=> string(7) "2930610" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "29" }

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

13 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
6388	KS	Coffeyville	-1	86	12917	37.037708	-95.626438	620		0		0	0	0	0	6388	11021	2014600	-6	-1	240
6700	KS	Parsons	-1	38	11924	37.33907	-95.269747	620		0		0	0	0	0	6700	11514	2054675	-6	-1	240
6544	KS	Independence	-1	90	9942	37.228251	-95.711392	620		0		0	0	0	0	6544	9846	2033875	-6	-1	240
6371	KS	Chanute	-1	82	9488	37.67707	-95.456468	620		0		0	0	0	0	6371	9411	2012500	-6	-1	240
6547	KS	Iola	-1	34	6351	37.922651	-95.400367	620		0		0	0	0	0	6547	6302	2034300	-6	-1	240
6482	KS	Girard	-1	0	2794	37.510204	-94.844157	620		0		0	0	0	0	6482	2773	2026300	-6	-1	240
6468	KS	Fredonia	-1	81	2599	37.532972	-95.825834	620		0		0	0	0	0	6468	2600	2024575	-6	-1	240
6540	KS	Humboldt	-1	55	2178	37.810738	-95.437418	620		0		0	0	0	0	6540	1999	2033450	-6	-1	240
6363	KS	Caney	-1	100	2062	37.013537	-95.933739	620		0		0	0	0	0	6363	2092	2010375	-6	-1	240
10319	MO	Stockton	-1	30	1579	37.696552	-93.7952	417		0		0	0	0	0	10319	1960	2970828	-6	-1	240
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
35456	KS	Dearing	-1	0	428	37.058083	-95.709824	620		0		0	0	0	0		415	2017150	-6	-1	240
6440	KS	Elk City	-1	0	334	37.290235	-95.910244	620		0		0	0	0	0	6440	305	2020250	-6	-1	240
9845	MO	Deerfield	-1	0	85	37.839003	-94.506819	417		0		0	0	0	0	9845	75	2918802	-6	-1	240

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

22 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
6558	KS	Kansas City	-1	79	149767	39.10678	-94.67647	913		1		1	0	0	0	6558	146866	2036000	-6	-1	29
6679	KS	Olathe	-1	94	63352	38.880788	-94.803184	913		0		1	0	0	0	6679	92962	2052575	-6	-1	29
6582	KS	Leavenworth	0	120	38495	39.308248	-94.92274	913		0		1	0	0	0	6582	35420	2039000	-6	-1	29
6587	KS	Lenexa	0	0	34034	38.964689	-94.759535	620		0		0	0	0	0		40238	2039350	-6	-1	29
10053	MO	Liberty	-1	78	20459	39.240852	-94.426502	816		0		1	0	0	0	10053	26232	2942032	-6	-1	29
6308	KS	Atchison	-1	85	10656	39.562499	-95.128257	913		0		0	0	0	0	6308	10232	2002900	-6	-1	29
9816	MO	Clinton	-1	47	8703	38.370067	-93.771689	660		0		0	0	0	0	9816	9311	2914986	-6	-1	29
10137	MO	Nevada	-1	74	8597	37.84093	-94.355576	417		0		0	0	0	0	10137	8607	2951644	-6	-1	29
9956	MO	Harrisonville	-1	82	7683	38.653592	-94.346915	816		0		0	0	0	0	9956	8946	2930610	-6	-1	29
6342	KS	Bonner Springs	-1	69	6413	39.066707	-94.879132	913		0		0	0	0	0	6342	6768	2007975	-6	-1	29
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
10051	MO	Lexington	-1	50	4860	39.18306	-93.87507	660		0		0	0	0	0	10051	4453	2941870	-6	-1	29
6697	KS	Paola	-1	86	4698	38.573599	-94.873456	913		0		0	0	0	0	6697	5011	2054250	-6	-1	29
9786	MO	Carrollton	-1	55	4406	39.358892	-93.49556	660		0		0	0	0	0	9786	4122	2911566	-6	-1	29
9770	MO	Butler	-1	71	4099	38.258715	-94.334982	660		0		0	0	0	0	9770	4209	2910054	-6	-1	29
9868	MO	El Dorado Springs	-1	5	3830	37.870872	-94.021024	417		0		0	0	0	0	9868	3775	2921502	-6	-1	29
9681	MO	Adrian	-1	6	1582	38.396857	-94.352328	816		0		0	0	0	0	9681	1780	2900244	-6	-1	29
6712	KS	Pleasanton	-1	0	1231	38.176326	-94.711997	913		0		0	0	0	0	6712	1387	2056450	-6	-1	29
10175	MO	Osceola	-1	3	755	38.046427	-93.699512	417		0		0	0	0	0	10175	835	2955388	-6	-1	29
10065	MO	Lowry City	-1	3	723	38.13998	-93.727205	417		0		0	0	0	0	10065	728	2944282	-6	-1	29
6438	KS	Effingham	-1	0	540	39.522774	-95.398633	913		0		0	0	0	0	6438	588	2020025	-6	-1	29
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
9812	MO	Cleveland	-1	0	506	38.675829	-94.595229	816		0		0	0	0	0	9812	592	2914770	-6	-1	29
9922	MO	Garden City	-1	0		38.558731	-94.189231	816		0		0	0	0	0	9922	1500	2926434	-6	-1	29

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

44 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
64701	HARRISONVILLE	MO	11809	Harrisonville	29
64735	CLINTON	MO	10581	Clinton	29
64772	NEVADA	MO	10261	Nevada	29
64759	LAMAR	MO	6533	Lamar	237
64744	EL DORADO SPRINGS	MO	5807	El Dorado Springs	29
64730	BUTLER	MO	5629	Butler	29
64747	GARDEN CITY	MO	3189	Garden City	29
64720	ADRIAN	MO	3076	Adrian	29
64776	OSCEOLA	MO	2724	Osceola	29
64755	JASPER	MO	2096	Jasper
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
64779	RICH HILL	MO	1909	Rich Hill
64725	ARCHIE	MO	1894	Archie
64742	DREXEL	MO	1824	Drexel
64734	CLEVELAND	MO	1781	Cleveland	29
64724	APPLETON CITY	MO	1451	Appleton City
64740	DEEPWATER	MO	1419	Deepwater
64762	LIBERAL	MO	1309	Liberal
64746	FREEMAN	MO	1230	Freeman
64784	SHELDON	MO	1187	Sheldon
64748	GOLDEN CITY	MO	1169	Golden City
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
64761	LEETON	MO	1136	Leeton
64788	URICH	MO	1119	Urich
64763	LOWRY CITY	MO	1093	Lowry City	29
64733	CHILHOWEE	MO	890	Chilhowee
64770	MONTROSE	MO	867	Montrose
64739	CREIGHTON	MO	863	Creighton
64738	COLLINS	MO	849	Collins
64790	WALKER	MO	651	Walker
64767	MILO	MO	641	Milo
64752	HUME	MO	617	Hume
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
64783	SCHELL CITY	MO	597	Schell City
64723	AMSTERDAM	MO	531	Amsterdam
64780	ROCKVILLE	MO	529	Rockville
64728	BRONAUGH	MO	497	Bronaugh
64756	JERICO SPRINGS	MO	484	Jerico Springs
64722	AMORET	MO	0	Amoret
64726	BLAIRSTOWN	MO	0	Blairstown
64741	DEERFIELD	MO	0	Deerfield	240
64745	FOSTER	MO	0	Foster
64750	HARWOOD	MO	0	Harwood
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
64769	MINDENMINES	MO	0	Mindenmines
64771	MOUNDVILLE	MO	0	Moundville
64778	RICHARDS	MO	0	Richards
64789	OSCEOLA	MO	0	Osceola	29

***** stations in DMA*************

33 records found!

stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
5430	KEOJ	KXOJ, INC.	FM	Caney	KS	6363
64282	K216GA	FAMILY FIRST	FX	Chanute	KS	6371
25196	KFEX-LP	FIRE ESCAPE YOUTH MINISTRIES, INC.	FL	Chanute	KS	6371
784	KKOY	MY TOWN MEDIA INC	AM	Chanute	KS	6371
6135	KKOY	MY TOWN MEDIA INC	FM	Chanute	KS	6371
123766	K260DF	MY TOWN MEDIA, INC.	FX	Chanute	KS	6371
73083	K253BF	OUR LADY OF MT. CARMEL EDUCATION AND EVANGELIZATION SOCIETY	FX	Chanute	KS	6371
57945	K239BJ	PEARL COMMUNICATIONS GROUP, INC.	FX	Chanute	KS	6371
53036	KANQ	UNIVERSITY OF KANSAS	FM	Chanute	KS	6371
95765	K224FQ	SEK MEDIA, LLC	FX	Coffeyville	KS	6388
stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
529	KGGF	SEK MEDIA, LLC	AM	Coffeyville	KS	6388
6150	KQQF	SEK MEDIA, LLC	FM	Coffeyville	KS	6388
43289	KIND	MY TOWN MEDIA, INC	FM	Elk City	KS	6440
5618	KGGF	SEK MEDIA, LLC	FM	Fredonia	KS	6468
7332	KSEK	AMERICAN MEDIA INVESTMENTS, INC.	FM	Girard	KS	6482
5865	KINZ	MY TOWN MEDIA INC	FM	Humboldt	KS	6540
5009	KBQC	AMERICAN FAMILY ASSOCIATION	FM	Independence	KS	6544
4766	KARF	COMMUNITY BROADCASTING, INC.	FM	Independence	KS	6544
140952	KBIK	MY TOWN MEDIA, INC	FM	Independence	KS	6544
658	KIND	MY TOWN MEDIA, INC	AM	Independence	KS	6544
stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
123895	K270CQ	MY TOWN MEDIA, INC.	FX	Independence	KS	6544
123726	K257GM	AD ASTRA PER ASPERA BROADCASTING, INC.	FX	Iola	KS	6547
5840	KIKS	AD ASTRA PER ASPERA BROADCASTING, INC.	FM	Iola	KS	6547
23347	KIOL	AD ASTRA PER ASPERA BROADCASTING, INC.	AM	Iola	KS	6547
64585	K242BM	COMMUNITY BROADCASTING, INC.	FX	Iola	KS	6547
64134	K208EK	CSN INTERNATIONAL	FX	Parsons	KS	6700
132910	K294DE	PARSONS MEDIA GROUP, LLC	FX	Parsons	KS	6700
855	KLKC	PARSONS MEDIA GROUP, LLC	AM	Parsons	KS	6700
6271	KLKC	PARSONS MEDIA GROUP, LLC	FM	Parsons	KS	6700
59635	KSHQ	MY TOWN MEDIA INC.	FM	Deerfield	MO	9845
stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
64663	K252EF	COMMUNITY BROADCASTING, INC.	FX	Stockton	MO	10319
136783	KIRS	VCY AMERICA, INC.	FM	Stockton	MO	10319
7760	KUSN	SEK MEDIA, LLC	FM	Dearing	KS	35456

Station KSHQ-FM

City Deerfield-MO

City Deerfield, MO is located in DMAID: