Fix WSFP 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 = 'HARRISVILLE' and State = 'MI'

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

Number of rows returned = 1
Start: 1754192199.6394
End: 1754192199.6396
Elapsed time: 0.1481 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
8678 MI Harrisville -1 13 470 44.657765 -83.293173 989 0 0 0 0 0 8678 514 2636860 -5 -1

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

NULL

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

array(13) { ["zipcode"]=> string(5) "48740" ["zip3"]=> string(3) "487" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(11) "HARRISVILLE" ["zipstate"]=> string(2) "MI" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "44.65" ["iplongitude"]=> string(6) "-83.29" ["ziplocation"]=> string(20) "NA-US-MI-HARRISVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1130" ["zippopulation"]=> string(4) "1991" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "487" ["zipcity"]=> string(8) "BAY CITY" ["zipstate"]=> string(2) "MI" }

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

array(22) { ["id"]=> string(4) "8470" ["State"]=> string(2) "MI" ["CityName"]=> string(8) "Bay City" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "200" ["Population"]=> string(5) "38936" ["Latitude"]=> string(9) "43.591973" ["Longitude"]=> string(8) "-83.8895" ["PrimaryAC"]=> string(3) "989" ["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) "8470" ["Population2000"]=> string(5) "36817" ["FIPS"]=> string(7) "2606020" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "125" }

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

No Rows in Recordset!

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

38 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8629	MI	Flint	0	399	140761	43.027577	-83.693996	810		0		0	0	1	0	8629	124943	2629000	-5	-1	125
8926	MI	Saginaw	0	257	69512	43.420926	-83.950829	989		0		0	0	0	0	8926	61799	2670520	-5	-1	125
8470	MI	Bay City	0	200	38936	43.591973	-83.8895	989		0		0	0	0	0	8470	36817	2606020	-5	-1	125
8506	MI	Burton	0	0	27617	42.991027	-83.635402	810		0		0	0	0	0		30308	2612060	-5	-1	125
8677	MI	Harrison	-1	12	24685	42.583655	-82.829242	989		0		0	0	0	0	8677	24461	2636810	-5	-1	125
8822	MI	Mount Pleasant	0	168	23285	43.600947	-84.774951	989		0		0	0	0	0	8822	25946	2656020	-5	-1	125
8849	MI	Okemos	-1	0	20216	42.710684	-84.422575	517		0		0	0	0	0		22805	2660340	-5	-1	125
8867	MI	Owosso	0	178	16322	42.996124	-84.174491	989		0		0	0	0	0	8867	15713	2661940	-5	-1	125
8684	MI	Haslett	-1	0	10230	42.752734	-84.406998	517		0		0	0	0	0		11283	2637100	-5	-1	125
8441	MI	Alma	0	169	9034	43.3784	-84.659378	989		0		0	0	0	0	8441	9275	2601540	-5	-1	125
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8624	MI	Fenton	0	161	8444	42.798872	-83.712132	810		0		0	0	0	0	8624	10582	2627760	-5	-1	125
8703	MI	Howell	0	323	8184	42.609674	-83.932889	517		0		1	0	0	0	8703	9232	2639540	-5	-1	125
8747	MI	Lapeer	0	360	7759	43.051844	-83.316332	810		0		0	0	0	0	8747	9072	2646040	-5	-1	125
8786	MI	Mason	0	70	6768	42.580453	-84.446143	517		0		0	0	0	0	8786	6714	2652180	-5	-1	125
36336	MI	Carrollton	-1	0	6521	43.459475	-83.93953			0		0	0	0	0		6602	2613560	-5	-1	125
8474	MI	Belding	0	22	5969	43.096533	-85.230543	269		0		0	0	0	0	8474	5877	2606900	-5	-1	125
8713	MI	Ionia	0	90	5935	42.981932	-85.066792	269		0		0	0	0	0	8713	10569	2640860	-5	-1	125
36374	MI	Frankenmuth	-1	53	4408	43.332219	-83.742063			0		0	0	0	0	36374	4838	2630200	-5	-1	125
8516	MI	Caro	0	15	4054	43.490364	-83.397735	989		0		0	0	0	0	8516	4145	2613420	-5	-1	125
8599	MI	East Tawas	0	13	2887	44.285435	-83.48905	989		0		0	0	0	0	8599	2951	2624420	-5	-1	125
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8522	MI	Cass City	0	51	2276	43.599343	-83.176367	989		0		0	0	0	0	8522	2643	2613880	-5	-1	125
9020	MI	West Branch	0	185	1914	44.275461	-84.237893	989		0		0	0	0	0	9020	1926	2685580	-5	-1	125
8811	MI	Mio	0	12	1886	44.654574	-84.131993	989		0		0	0	0	0	8811	2016	2654660	-5	-1	125
9016	MI	Webberville	-1	26	1698	42.668784	-84.175962	517		0		0	0	0	0	9016	1503	2685080	-5	-1	125
8948	MI	Shepherd	0	84	1413	43.524609	-84.692019	989		0		0	0	0	0	8948	1536	2672960	-5	-1	125
8968	MI	Standish	0	91	1377	43.982075	-83.959298	989		0		0	0	0	0	8968	1581	2676120	-5	-1	125
8585	MI	Dimondale	-1	50	1247	42.645985	-84.647729	517		0		0	0	0	0	8585	1342	2622380	-5	-1	125
36343	MI	Coleman	-1	56	1237	43.757474	-84.586124			0		0	0	0	0	36343	1296	2617100	-5	-1	125
8881	MI	Pigeon	-1	1	1207	43.829786	-83.271838	989		0		0	0	0	0	8881	1207	2664060	-5	-1	125
36318	MI	Beaverton	-1	0	1150	43.881722	-84.487567			0		0	0	0	0	36318	1106	2606660	-5	-1	125
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8744	MI	Lakeview	0	83	1108	43.443015	-85.278106	989		0		0	0	0	0	8744	1112	2645240	-5	-1	125
8859	MI	Oscoda	0	191	1061	44.420947	-83.331203	989		0		0	0	0	0	8859	992	2661320	-5	-1	125
8921	MI	Roscommon	0	79	858	44.495299	-84.589816	989		0		0	0	0	0	8921	1133	2669540	-5	-1	125
8451	MI	Ashley	0	81	518	43.187002	-84.477053	989		0		0	0	0	0	8451	526	2603740	-5	-1	125
8706	MI	Hubbardston	0	85	404	43.093311	-84.840171	989		0		0	0	0	0	8706	394	2639660	-5	-1	125
36379	MI	Gagetown	-1	0	337	43.657472	-83.243848			0		0	0	0	0	36379	389	2631180	-5	-1	125
36355	MI	Eagle	-1	0	120	42.808898	-84.790522			0		0	0	0	0		130	2623560	-5	-1	125
63700	MI	Linwood		52						0	0	0	0	0	0	63700			-5	-1	125

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

49 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
48706	BAY CITY	MI	34564	Bay City	125
48708	BAY CITY	MI	21270	Bay City	125
48723	CARO	MI	9750	Caro	125
48732	ESSEXVILLE	MI	9540	Essexville	130
48768	VASSAR	MI	8519	Vassar
48746	MILLINGTON	MI	7519	Millington
48750	OSCODA	MI	7173	Oscoda	125
48734	FRANKENMUTH	MI	6822	Frankenmuth	125
48726	CASS CITY	MI	5034	Cass City	125
48763	TAWAS CITY	MI	3972	Tawas City
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
48730	EAST TAWAS	MI	3876	East Tawas	125
48744	MAYVILLE	MI	3842	Mayville
48757	REESE	MI	3444	Reese
48739	HALE	MI	3168	Hale
48756	PRESCOTT	MI	3059	Prescott
48722	BRIDGEPORT	MI	3016	Bridgeport	130
48759	SEBEWAING	MI	2983	Sebewaing
48755	PIGEON	MI	2936	Pigeon	125
48703	AU GRES	MI	2759	Au Gres
48725	CASEVILLE	MI	2057	Caseville
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
48740	HARRISVILLE	MI	1991	Harrisville
48767	UNIONVILLE	MI	1896	Unionville
48741	KINGSTON	MI	1709	Kingston
48733	FAIRGROVE	MI	1518	Fairgrove
48742	LINCOLN	MI	1502	Lincoln
48731	ELKTON	MI	1476	Elkton
48748	NATIONAL CITY	MI	1460
48770	WHITTEMORE	MI	1435	Whittemore
48747	MUNGER	MI	1397	Munger
48729	DEFORD	MI	1251
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
48701	AKRON	MI	1130	Akron
48766	TWINING	MI	1067	Twining
48745	MIKADO	MI	1056
48760	SILVERWOOD	MI	1040
48738	GREENBUSH	MI	1033
48762	SPRUCE	MI	1015
48727	CLIFFORD	MI	1009	Clifford
48720	BAY PORT	MI	970	Bay Port
48749	OMER	MI	952	Omer
48737	GLENNIE	MI	941
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
48754	OWENDALE	MI	820	Owendale
48735	GAGETOWN	MI	784	Gagetown	125
48761	SOUTH BRANCH	MI	747
48765	TURNER	MI	584	Turner
48705	BARTON CITY	MI	420
48728	CURRAN	MI	0
48743	LONG LAKE	MI	0	Long Lake
48721	BLACK RIVER	MI	0
48769	VASSAR	MI	0	Vassar

Station WSFP-FM

City HARRISVILLE-MI

City , is located in DMAID: