Fix K220EU 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 = 'ERWINVILLE' and State = 'LA'

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: 1754173813.7773
End: 1754173813.7777
Elapsed time: 0.4110 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('LA','Erwinville',-1)

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

array(22) { ["id"]=> string(5) "80100" ["State"]=> string(2) "LA" ["CityName"]=> string(10) "Erwinville" ["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) "70729" ["zip3"]=> string(3) "707" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "ERWINVILLE" ["zipstate"]=> string(2) "LA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "30.53" ["iplongitude"]=> string(5) "-91.4" ["ziplocation"]=> string(19) "NA-US-LA-ERWINVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "543" ["zippopulation"]=> string(3) "997" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "707" ["zipcity"]=> string(14) "DENHAM SPRINGS" ["zipstate"]=> string(2) "LA" }

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

array(22) { ["id"]=> string(4) "7281" ["State"]=> string(2) "LA" ["CityName"]=> string(14) "Denham Springs" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(3) "113" ["Population"]=> string(4) "8381" ["Latitude"]=> string(9) "30.479739" ["Longitude"]=> string(10) "-90.954105" ["PrimaryAC"]=> string(3) "225" ["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) "7281" ["Population2000"]=> string(4) "8757" ["FIPS"]=> string(7) "2220435" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "83" }

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

No Rows in Recordset!

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

26 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
7233	LA	Baton Rouge	0	301	219531	30.45809	-91.140229	985		0		0	0	0	0	7233	227818	2205000	-6	-1	83
7409	LA	New Iberia	0	207	31828	30.003577	-91.818454	337		0		0	0	0	0	7409	32623	2254035	-6	-1	83
7336	LA	Houma	0	153	30495	29.587614	-90.716108	985		0		0	0	0	0	7336	32393	2236255	-6	-1	83
7326	LA	Hammond	0	141	15871	30.504446	-90.465616	985		0		0	0	0	0	7326	17639	2232755	-6	-1	83
7403	LA	Morgan City	0	152	14531	29.700828	-91.197314	985		0		0	0	0	0	7403	12703	2252040	-6	-1	83
7480	LA	Thibodaux	0	100	14035	29.792204	-90.820095	985		0		0	0	0	0	7480	14431	2275425	-6	-1	83
35824	LA	Baker	-1	0	13233	30.585637	-91.157096			0		0	0	0	0		13793	2203985	-6	-1	83
7281	LA	Denham Springs	-1	113	8381	30.479739	-90.954105	225		0		0	0	0	0	7281	8757	2220435	-6	-1	83
7283	LA	Donaldsonville	0	135	7949	30.099947	-90.994046	225		0		0	0	0	0	7283	7605	2221240	-6	-1	83
7432	LA	Plaquemine	-1	32	7186	30.284044	-91.240485	225		0		0	0	0	0	7432	7064	2260880	-6	-1	83
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
7317	LA	Gonzales	-1	1	7003	30.227128	-90.919771	225		0		0	0	0	0	7317	8156	2229850	-6	-1	83
35937	LA	Port Allen	-1	0	6277	30.45374	-91.209957			0		0	0	0	0		5278	2261790	-6	-1	83
7366	LA	Larose	-1	0	5772	29.567328	-90.376074	985		0		0	0	0	0	7366	7306	2242135	-6	-1	83
7411	LA	New Roads	-1	36	5303	30.696305	-91.43898	225		0		0	0	0	0	7411	4966	2255105	-6	-1	83
35830	LA	Berwick	-1	0	4375	29.698148	-91.227052			0		0	0	0	0		4418	2207100	-6	-1	83
35881	LA	Gray	-1	0	4260	29.680993	-90.781414			0		0	0	0	0		4958	2231180	-6	-1	83
7341	LA	Jackson	-1	0	3891	30.837588	-91.214436	225		0		0	0	0	0	7341	4130	2237830	-6	-1	83
7287	LA	Dulac	-1	50	3273	29.384672	-90.696891	985		0		0	0	0	0	7287	2458	2221940	-6	-1	83
7353	LA	Kentwood	-1	0	2468	30.936116	-90.515389	985		0		0	0	0	0	7353	2205	2239545	-6	-1	83
7294	LA	Erath	-1	0	2428	29.959939	-92.03522	337		0		0	0	0	0	7294	2187	2224180	-6	-1	83
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
7493	LA	White Castle	-1	1	2102	30.168503	-91.146708	225		0		0	0	0	0	7493	1946	2281375	-6	-1	83
7316	LA	Golden Meadow	-1	0	2049	29.388192	-90.269457	985		0		0	0	0	0	7316	2193	2229640	-6	-1	83
7262	LA	Clinton	-1	56	1904	30.86305	-91.015789	225		0		0	0	0	0	7262	1998	2215990	-6	-1	83
7245	LA	Brusly	0	0	1824	30.39047	-91.241797	225		0		0	0	0	0		2020	2210600	-6	-1	83
35816	LA	Addis	-1	0	1222	30.354585	-91.264672			0		0	0	0	0		2238	2200415	-6	-1	83
68739	LA	Belle Rose		0	0	30.036834	-91.054039			0	0	0	0	0	0	0	1944	2206260	-6	-1	83

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

52 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
70726	DENHAM SPRINGS	LA	37331	Denham Springs	83
70769	PRAIRIEVILLE	LA	29593
70737	GONZALES	LA	27923	Gonzales	83
70791	ZACHARY	LA	20591	Zachary
70785	WALKER	LA	16008	Walker
70706	DENHAM SPRINGS	LA	15282	Denham Springs	83
70714	BAKER	LA	15207	Baker	83
70764	PLAQUEMINE	LA	13072	Plaquemine	83
70767	PORT ALLEN	LA	11802	Port Allen	83
70739	GREENWELL SPRINGS	LA	10194
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
70774	SAINT AMANT	LA	8129
70754	LIVINGSTON	LA	7489	Livingston
70775	SAINT FRANCISVILLE	LA	7015	Saint Francisville
70734	GEISMAR	LA	5522	Geismar
70760	NEW ROADS	LA	5511	New Roads	83
70722	CLINTON	LA	5392	Clinton	83
70711	ALBANY	LA	4417	Albany
70744	HOLDEN	LA	3946
70748	JACKSON	LA	3908	Jackson	83
70719	BRUSLY	LA	3639	Brusly	83
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
70777	SLAUGHTER	LA	3458	Slaughter
70788	WHITE CASTLE	LA	3354	White Castle	83
70770	PRIDE	LA	3175
70710	ADDIS	LA	2994	Addis	83
70763	PAULINA	LA	2974
70730	ETHEL	LA	2958
70757	MARINGOUIN	LA	2405	Maringouin
70776	SAINT GABRIEL	LA	2125
70783	VENTRESS	LA	2084
70778	SORRENTO	LA	1848	Sorrento
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
70755	LIVONIA	LA	1801	Livonia
70750	KROTZ SPRINGS	LA	1498	Krotz Springs
70733	FRENCH SETTLEMENT	LA	1436	French Settlement
70725	DARROW	LA	1411
70723	CONVENT	LA	1292	Convent
70759	MORGANZA	LA	1195	Morganza
70740	GROSSE TETE	LA	1098	Grosse Tete
70749	JARREAU	LA	1087
70729	ERWINVILLE	LA	997	Erwinville
70732	FORDOCHE	LA	949	Fordoche
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
70715	BATCHELOR	LA	947	Batchelor
70780	SUNSHINE	LA	801
70762	OSCAR	LA	731
70752	LAKELAND	LA	724
70772	ROSEDALE	LA	688	Rosedale
70753	LETTSWORTH	LA	686
70761	NORWOOD	LA	678	Norwood
70789	WILSON	LA	639	Wilson
70721	CARVILLE	LA	456	Carville
70736	GLYNN	LA	0
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
70756	LOTTIE	LA	0
70773	ROUGON	LA	0	Rougon

Station K220EU-FX

City ERWINVILLE-LA

City Erwinville, LA is located in DMAID: