Fix W276BC 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 = 'ELLISON BAY' 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: 1754177830.6419
End: 1754177830.6424
Elapsed time: 0.5229 ms No Rows in Recordset!

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

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

array(22) { ["id"]=> string(5) "80204" ["State"]=> string(2) "WI" ["CityName"]=> string(11) "Ellison Bay" ["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) "54210" ["zip3"]=> string(3) "542" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(11) "ELLISON BAY" ["zipstate"]=> string(2) "WI" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "45.25" ["iplongitude"]=> string(6) "-87.06" ["ziplocation"]=> string(20) "NA-US-WI-ELLISON BAY" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "514" ["zippopulation"]=> string(3) "876" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "542" ["zipcity"]=> string(9) "MANITOWOC" ["zipstate"]=> string(2) "WI" }

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

array(22) { ["id"]=> string(5) "21337" ["State"]=> string(2) "WI" ["CityName"]=> string(9) "Manitowoc" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "171" ["Population"]=> string(5) "32520" ["Latitude"]=> string(9) "44.096461" ["Longitude"]=> string(10) "-87.675002" ["PrimaryAC"]=> string(3) "920" ["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) "21337" ["Population2000"]=> string(5) "34053" ["FIPS"]=> string(7) "5548500" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "277" }

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

No Rows in Recordset!

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

31 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
21515	WI	Sheboygan	0	201	49676	43.749694	-87.725013	920		0		0	0	0	0	21515	50792	5572975	-6	-1	277
8288	ME	Lewiston	0	143	39757	44.097473	-70.192416	207		0		0	1	0	0	8288	35690	2338740	-5	-1	277
21337	WI	Manitowoc	0	171	32520	44.096461	-87.675002	920		0		0	0	0	0	21337	34053	5548500	-6	-1	277
21136	WI	Cedarburg	-1	223	9895	43.29896	-87.987209	262		0		1	0	0	0	21136	10908	5513375	-6	-1	277
21464	WI	Port Washington	0	90	9338	43.39325	-87.881053	262		0		0	0	0	0	21464	10467	5564450	-6	-1	277
20605	VT	Brattleboro	-1	106	8612	42.856099	-72.564186	802		0		0	0	0	0	20605	8289	5007975	-5	-1	277
21460	WI	Plymouth	0	128	6769	43.749277	-87.976799	920		0		0	0	0	0	21460	7781	5563700	-6	-1	277
21516	WI	Sheboygan Falls	-1	34	5823	43.730444	-87.821078	920		0		0	0	0	0	21516	6772	5573025	-6	-1	277
21178	WI	Delafield	-1	1	5347	43.075629	-88.3953	262		0		0	0	0	0	21178	6472	5519400	-6	-1	277
21559	WI	Sussex	-1	45	5039	43.135072	-88.220346	262		0		0	0	0	0	21559	8828	5578750	-6	-1	277
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
21449	WI	Pewaukee	-1	87	4941	43.082659	-88.252842	262		0		0	0	0	0	21449	8170	5562250	-6	-1	277
21350	WI	Mayville	0	83	4374	43.497044	-88.547871	920		0		0	0	0	0	21350	4902	5550200	-6	-1	277
21041	WI	Algoma	-1	43	3353	44.608226	-87.442342	920		0		0	0	0	0	21041	3357	5501000	-6	-1	277
21406	WI	New Holstein	-1	78	3342	43.948185	-88.090931	920		0		0	0	0	0	21406	3301	5556800	-6	-1	277
21142	WI	Chilton	0	106	3240	44.030745	-88.158704	920		0		0	0	0	0	21142	3708	5514475	-6	-1	277
21299	WI	Kiel	0	95	2910	43.914718	-88.031812	920		0		0	0	0	0	21299	3450	5539525	-6	-1	277
21298	WI	Kewaunee	-1	3	2750	44.458758	-87.509496	920		0		0	0	0	0	21298	2806	5539350	-6	-1	277
36299	ME	South Paris	-1	0	2320	44.221609	-70.514603			0		0	0	0	0		2237	2371780	-5	-1	277
36292	ME	Mexico	-1	0	2302	44.557153	-70.540252			0		0	0	0	0		1946	2345250	-5	-1	277
21326	WI	Lomira	-1	6	1542	43.595089	-88.444602	920		0		0	0	0	0	21326	2233	5545475	-6	-1	277
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
21147	WI	Cleveland	-1	1	1398	43.917829	-87.74625	920		0		0	0	0	0	21147	1361	5515400	-6	-1	277
21524	WI	Sister Bay	-1	1	675	45.187192	-87.123852	920		0		0	0	0	0	21524	886	5574225	-6	-1	277
21222	WI	Forestville	-1	0	470	44.689462	-87.480758	920		0		0	0	0	0	21222	429	5526625	-6	-1	277
42078	WI	Ephraim	-1	0	261	45.156509	-87.171047			0		0	0	0	0		353	5524150	-6	-1	277
70304	WI	Ixonia		0	0	43.144787	-88.598207			0	0	0	0	0	0	0	642	5537575	-6	-1	277
21064	WI	Baileys Harbor	-1	33		45.077002	-87.14603	920		0		0	0	0	0	21064			-6	-1	277
20733	VT	Wilmington	-1	98		42.944039	-72.727518	802		0		0	0	0	0	20733			-5	-1	277
20687	VT	Putney	-1	107		43.016096	-72.534025	802		0		0	0	0	0	20687			-5	-1	277
20648	VT	Jamaica	-1	84		43.012776	-72.767275	802		0		0	0	0	0	20648			-5	-1	277
8396	ME	Turner	-1	1		44.265473	-70.254155	207		0		0	0	0	0	8396			-5	-1	277
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8197	ME	Bethel	-1	2		44.428414	-70.770035	207		0		0	0	0	0	8197			-5	-1	277

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

22 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
54220	MANITOWOC	WI	33528	Manitowoc	277
54235	STURGEON BAY	WI	15527	Sturgeon Bay	186
54241	TWO RIVERS	WI	12935	Two Rivers
54217	LUXEMBURG	WI	6559	Luxemburg
54208	DENMARK	WI	5462	Denmark	134
54216	KEWAUNEE	WI	5308	Kewaunee	277
54201	ALGOMA	WI	4577	Algoma	277
54230	REEDSVILLE	WI	4030	Reedsville
54229	NEW FRANKEN	WI	3837	New Franken
54228	MISHICOT	WI	2500	Mishicot	134
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
54245	VALDERS	WI	2127	Valders
54247	WHITELAW	WI	2110	Whitelaw
54205	CASCO	WI	1910	Casco
54204	BRUSSELS	WI	1689	Brussels
54234	SISTER BAY	WI	1671	Sister Bay	277
54227	MARIBEL	WI	1519	Maribel
54209	EGG HARBOR	WI	1270	Egg Harbor
54202	BAILEYS HARBOR	WI	1232	Baileys Harbor	277
54213	FORESTVILLE	WI	1230	Forestville	277
54212	FISH CREEK	WI	1020
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
54210	ELLISON BAY	WI	876	Ellison Bay
54246	WASHINGTON ISLAND	WI	685	Washington Island

Station W276BC-FX

City ELLISON BAY-WI

City Ellison Bay, WI is located in DMAID: