Fix KSMS 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 = 'POINT LOOKOUT' and State = 'MO'

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: 1754151758.3624
End: 1754151758.3626
Elapsed time: 0.1271 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('MO','Point Lookout',-1)

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

array(22) { ["id"]=> string(5) "79911" ["State"]=> string(2) "MO" ["CityName"]=> string(13) "Point Lookout" ["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) "65726" ["zip3"]=> string(3) "657" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(13) "POINT LOOKOUT" ["zipstate"]=> string(2) "MO" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "36.58" ["iplongitude"]=> string(6) "-93.23" ["ziplocation"]=> string(22) "NA-US-MO-POINT LOOKOUT" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }

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

array(3) { ["zip3"]=> string(3) "657" ["zipcity"]=> string(4) "NIXA" ["zipstate"]=> string(2) "MO" }

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

array(22) { ["id"]=> string(5) "10153" ["State"]=> string(2) "MO" ["CityName"]=> string(4) "Nixa" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "67" ["Population"]=> string(4) "4707" ["Latitude"]=> string(9) "37.045253" ["Longitude"]=> string(10) "-93.298755" ["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(5) "10153" ["Population2000"]=> string(5) "12124" ["FIPS"]=> string(7) "2952616" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "145" }

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

No Rows in Recordset!

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

21 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
10301	MO	Springfield	0	263	140494	37.195098	-93.286213	417		0		0	0	0	0	10301	151580	2970000	-6	-1	145
10385	MO	West Plains	-1	39	8913	36.737355	-91.864991	417		0		0	0	0	0	10385	10866	2978928	-6	-1	145
10113	MO	Monett	-1	43	6529	36.923725	-93.922332	417		0		0	0	0	0	10113	7396	2949196	-6	-1	145
9708	MO	Aurora	-1	5	6459	36.969956	-93.720574	417		0		0	0	0	0	9708	7014	2902548	-6	-1	145
10234	MO	Republic	-1	33	6292	37.121652	-93.47144	417		0		0	0	0	0	10234	8438	2961238	-6	-1	145
10153	MO	Nixa	-1	67	4707	37.045253	-93.298755	417		0		0	0	0	0	10153	12124	2952616	-6	-1	145
10083	MO	Marshfield	-1	3	4374	37.339599	-92.90723	417		0		0	0	0	0	10083	5720	2946388	-6	-1	145
10180	MO	Ozark	-1	3	4243	37.027111	-93.209572	417		0		0	0	0	0	10180	9665	2955766	-6	-1	145
10128	MO	Mountain Grove	-1	6	4182	37.132243	-92.263849	417		0		0	0	0	0	10128	4574	2950402	-6	-1	145
10127	MO	Mount Vernon	0	17	3726	37.100017	-93.81815	417		0		0	0	0	0	10127	4017	2950672	-6	-1	145
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
10394	MO	Willard	-1	0	2177	37.294429	-93.423218	417		0		0	0	0	0	10394	3193	2979882	-6	-1	145
10398	MO	Willow Springs	0	3	2038	36.991164	-91.96736	417		0		0	0	0	0	10398	2147	2980098	-6	-1	145
10335	MO	Thayer	-1	4	1996	36.524275	-91.543895	417		0		0	0	0	0	10335	2201	2972826	-6	-1	145
10077	MO	Mansfield	-1	4	1429	37.106458	-92.581135	417		0		0	0	0	0	10077	1349	2945740	-6	-1	145
10251	MO	Rogersville	-1	0	995	37.117382	-93.058181	417		0		0	0	0	0	10251	1508	2962894	-6	-1	145
10297	MO	Sparta	-1	1	751	37.00032	-93.083407	417		0		0	0	0	0	10297	1144	2969302	-6	-1	145
10233	MO	Reeds Spring	-1	2	411	36.745692	-93.382727	417		0		0	0	0	0	10233	465	2961112	-6	-1	145
10205	MO	Pleasant Hope	-1	0	360	37.462737	-93.273492	417		0		0	0	0	0	10205	548	2958448	-6	-1	145
36890	MO	Brookline	-1	0	283	37.179117	-93.417279			0		0	0	0	0		326	2908722	-6	-1	145
10249	MO	Rockaway Beach	-1	2	275	36.70082	-93.161177	417		0		0	0	0	0	10249	577	2962570	-6	-1	145
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
10284	MO	Shell Knob	-1	4		36.602494	-93.598707	417		0		0	0	0	0	10284	1393	2967232	-6	-1	145

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

74 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
65714	NIXA	MO	24610	Nixa	145
65721	OZARK	MO	22596	Ozark	145
65775	WEST PLAINS	MO	18146	West Plains	145
65738	REPUBLIC	MO	13596	Republic	145
65706	MARSHFIELD	MO	11534	Marshfield	145
65708	MONETT	MO	9595	Monett	145
65742	ROGERSVILLE	MO	9333	Rogersville	145
65781	WILLARD	MO	7060	Willard	145
65711	MOUNTAIN GROVE	MO	7045	Mountain Grove	145
65737	REEDS SPRING	MO	6567	Reeds Spring	145
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
65712	MOUNT VERNON	MO	6219	Mount Vernon	145
65757	STRAFFORD	MO	5818	Strafford
65746	SEYMOUR	MO	5400	Seymour
65793	WILLOW SPRINGS	MO	4622	Willow Springs	145
65785	STOCKTON	MO	3984	Stockton	240
65753	SPARTA	MO	3764	Sparta	145
65791	THAYER	MO	3079	Thayer	145
65705	MARIONVILLE	MO	2945	Marionville
65723	PIERCE CITY	MO	2885	Pierce City
65747	SHELL KNOB	MO	2843	Shell Knob	145
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
65704	MANSFIELD	MO	2763	Mansfield	145
65734	PURDY	MO	2559	Purdy
65770	WALNUT GROVE	MO	2475	Walnut Grove
65740	ROCKAWAY BEACH	MO	2385	Rockaway Beach	145
65769	VERONA	MO	2268	Verona
65725	PLEASANT HOPE	MO	1961	Pleasant Hope	145
65745	SELIGMAN	MO	1847	Seligman	237
65717	NORWOOD	MO	1833	Norwood
65713	NIANGUA	MO	1808	Niangua
65707	MILLER	MO	1770	Miller
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
65772	WASHBURN	MO	1638	Washburn
65786	MACKS CREEK	MO	1587	Macks Creek
65779	WHEATLAND	MO	1552	Wheatland
65767	URBANA	MO	1527	Urbana
65722	PHILLIPSBURG	MO	1493	Phillipsburg
65789	POMONA	MO	1451
65787	ROACH	MO	1301
65739	RIDGEDALE	MO	1185
65771	WALNUT SHADE	MO	999
65761	THEODOSIA	MO	961	Theodosia
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
65724	PITTSBURG	MO	960	Pittsburg
65710	MORRISVILLE	MO	947	Morrisville
65759	TANEYVILLE	MO	918	Taneyville
65764	TUNAS	MO	878
65754	SPOKANE	MO	803	Spokane
65774	WEAUBLEAU	MO	709	Weaubleau
65732	PRESTON	MO	701	Preston
65790	POTTERSVILLE	MO	604
65720	OLDFIELD	MO	536
65756	STOTTS CITY	MO	529	Stotts City
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
65760	TECUMSEH	MO	491
65701	MC CLURG	MO	0
65715	NOBLE	MO	0
65766	UDALL	MO	0
65727	POLK	MO	0	Polk
65783	WINDYVILLE	MO	0
65702	MACOMB	MO	0
65777	MOODY	MO	0
65768	VANZANT	MO	0	Vanzant
65778	MYRTLE	MO	0	Myrtle
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
65788	PEACE VALLEY	MO	0	Peace Valley
65728	PONCE DE LEON	MO	0
65729	PONTIAC	MO	0
65730	POWELL	MO	0	Powell
65731	POWERSITE	MO	0
65733	PROTEM	MO	0	Protem
65735	QUINCY	MO	0
65744	RUETER	MO	0
65752	SOUTH GREENFIELD	MO	0	South Greenfield
65755	SQUIRES	MO	0
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
65762	THORNFIELD	MO	0
65773	WASOLA	MO	0	Wasola
65776	SOUTH FORK	MO	0
65784	ZANONI	MO	0

Station KSMS-FM

City POINT LOOKOUT-MO

City Point Lookout, MO is located in DMAID: