Fix WHSA 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 = 'BRULE' and State = 'WI'

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: 1754169204.868
End: 1754169204.8681
Elapsed time: 0.1140 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('WI','Brule',-1)

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

array(22) { ["id"]=> string(5) "80043" ["State"]=> string(2) "WI" ["CityName"]=> string(5) "Brule" ["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) "54820" ["zip3"]=> string(3) "548" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(5) "BRULE" ["zipstate"]=> string(2) "WI" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "46.55" ["iplongitude"]=> string(6) "-91.57" ["ziplocation"]=> string(14) "NA-US-WI-BRULE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "397" ["zippopulation"]=> string(3) "727" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "548" ["zipcity"]=> string(8) "SUPERIOR" ["zipstate"]=> string(2) "WI" }

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

array(22) { ["id"]=> string(5) "21557" ["State"]=> string(2) "WI" ["CityName"]=> string(8) "Superior" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "2" ["Population"]=> string(3) "481" ["Latitude"]=> string(8) "46.65614" ["Longitude"]=> string(10) "-92.103638" ["PrimaryAC"]=> string(3) "715" ["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) "21557" ["Population2000"]=> string(3) "500" ["FIPS"]=> string(7) "5578660" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "204" }

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

No Rows in Recordset!

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

15 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
9160	MN	Cloquet	-1	56	10885	46.718089	-92.465797	218		0		0	0	0	0	9160	11201	2712160	-6	-1	204
21057	WI	Ashland	-1	2	8695	46.587376	-90.880391	715		0		0	0	0	0	21057	8620	5503225	-6	-1	204
21490	WI	Rice Lake	-1	1	7998	45.498408	-91.738844	715		0		0	0	0	0	21490	8320	5567350	-6	-1	204
9619	MN	Two Harbors	-1	1	3651	47.025369	-91.673904	218		0		0	0	0	0	9619	3613	2765956	-6	-1	204
21070	WI	Barron	-1	0	2986	45.400527	-91.847948	715		0		0	0	0	0	21070	3248	5504875	-6	-1	204
21535	WI	Spooner	-1	1	2464	45.825941	-91.891116	715		0		0	0	0	0	21535	2653	5575625	-6	-1	204
21585	WI	Washburn	-1	0	2285	46.673989	-90.897674	715		0		0	0	0	0	21585	2280	5583525	-6	-1	204
21261	WI	Hayward	-1	1	1897	46.013085	-91.483874	715		0		0	0	0	0	21261	2129	5533450	-6	-1	204
21518	WI	Shell Lake	-1	0	1161	45.73359	-91.917368	715		0		0	0	0	0	21518	1309	5573200	-6	-1	204
21523	WI	Siren	-1	0	863	45.783633	-92.380161	715		0		0	0	0	0	21523	988	5574175	-6	-1	204
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
21066	WI	Balsam Lake	-1	0	792	45.45805	-92.454872	715		0		0	0	0	0	21066	950	5504475	-6	-1	204
21557	WI	Superior	-1	2	481	46.65614	-92.103638	715		0		0	0	0	0	21557	500	5578660	-6	-1	204
21505	WI	Sarona	-1	0		45.73714	-91.775875	715		0		0	0	0	0	21505			-6	-1	204
21280	WI	Iron River	-1	0		46.599552	-91.437437	715		0		0	0	0	0	21280			-6	-1	204
79860	MN	Grand Portage	-1																	0	204

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

58 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
54880	SUPERIOR	WI	23716	Superior	204
54868	RICE LAKE	WI	12887	Rice Lake	204
54843	HAYWARD	WI	10035	Hayward	204
54806	ASHLAND	WI	9183	Ashland	204
54801	SPOONER	WI	5608	Spooner	204
54848	LADYSMITH	WI	4949	Ladysmith	243
54812	BARRON	WI	4756	Barron	204
54829	CUMBERLAND	WI	4649	Cumberland
54840	GRANTSBURG	WI	4046	Grantsburg
54822	CAMERON	WI	3836	Cameron
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
54853	LUCK	WI	3266	Luck
54893	WEBSTER	WI	3218	Webster
54837	FREDERIC	WI	3103	Frederic
54874	SOUTH RANGE	WI	2947
54891	WASHBURN	WI	2834	Washburn	204
54871	SHELL LAKE	WI	2668	Shell Lake	204
54830	DANBURY	WI	2464	Danbury
54873	SOLON SPRINGS	WI	2447	Solon Springs
54889	TURTLE LAKE	WI	2388	Turtle Lake
54872	SIREN	WI	2172	Siren	204
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
54810	BALSAM LAKE	WI	2123	Balsam Lake	204
54814	BAYFIELD	WI	2122	Bayfield
54847	IRON RIVER	WI	2067	Iron River	204
54819	BRUCE	WI	2050	Bruce
54817	BIRCHWOOD	WI	2013	Birchwood
54824	CENTURIA	WI	1788	Centuria
54849	LAKE NEBAGAMON	WI	1725	Lake Nebagamon
54859	MINONG	WI	1706	Minong
54876	STONE LAKE	WI	1439	Stone Lake
54870	SARONA	WI	1339	Sarona	204
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
54856	MASON	WI	1336	Mason
54896	WINTER	WI	1313	Winter
54888	TREGO	WI	1294
54805	ALMENA	WI	1276	Almena
54864	POPLAR	WI	1266	Poplar
54821	CABLE	WI	1229	Cable
54858	MILLTOWN	WI	1224	Milltown
54838	GORDON	WI	945	Gordon
54836	FOXBORO	WI	936
54875	SPRINGBROOK	WI	876	Springbrook
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
54835	EXELAND	WI	852	Exeland
54895	WEYERHAEUSER	WI	822	Weyerhaeuser
54854	MAPLE	WI	771	Maple
54820	BRULE	WI	727	Brule
54826	COMSTOCK	WI	623
54855	MARENGO	WI	593	Marengo
54813	BARRONETT	WI	570
54828	COUDERAY	WI	511	Couderay
54846	HIGH BRIDGE	WI	470
54827	CORNUCOPIA	WI	0	Cornucopia
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
54832	DRUMMOND	WI	0	Drummond
54839	GRAND VIEW	WI	0
54841	HAUGEN	WI	0	Haugen
54844	HERBSTER	WI	0
54865	PORT WING	WI	0	Port Wing
54867	RADISSON	WI	0	Radisson
54845	HERTEL	WI	0
54862	OJIBWA	WI	0

Station WHSA-FM

City BRULE-WI

City Brule, WI is located in DMAID: