Fix W236AN 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 = 'LOUISVILLE' and State = 'KY'

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

Number of rows returned = 1
Start: 1754162969.4877
End: 1754162969.4879
Elapsed time: 0.1931 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
7066 KY Louisville 0 360 269063 38.22887 -85.749534 502 1 1 0 0 0 7066 256231 2148000 -5 -1 55

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

NULL

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

array(13) { ["zipcode"]=> string(5) "40214" ["zip3"]=> string(3) "402" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "LOUISVILLE" ["zipstate"]=> string(2) "KY" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "38.22" ["iplongitude"]=> string(6) "-85.74" ["ziplocation"]=> string(19) "NA-US-KY-LOUISVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "20839" ["zippopulation"]=> string(5) "35096" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "402" ["zipcity"]=> string(10) "LOUISVILLE" ["zipstate"]=> string(2) "KY" }

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

array(22) { ["id"]=> string(4) "7066" ["State"]=> string(2) "KY" ["CityName"]=> string(10) "Louisville" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "360" ["Population"]=> string(6) "269063" ["Latitude"]=> string(8) "38.22887" ["Longitude"]=> string(10) "-85.749534" ["PrimaryAC"]=> string(3) "502" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "1" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "7066" ["Population2000"]=> string(6) "256231" ["FIPS"]=> string(7) "2148000" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "55" }

**** 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
7066	KY	Louisville	0	360	269063	38.22887	-85.749534	502		1		1	0	0	0	7066	256231	2148000	-5	-1	55
5975	IN	Jeffersonville	-1	0	21841	38.295669	-85.731485	812		0		0	0	0	0		27362	1838358	-5	-1	55
6984	KY	Fort Knox	-1	0	21495	37.892809	-85.974709	502		0		0	0	0	0		12377	2128540	-5	-1	55
35260	IN	Clarksville	-1	0	19833	38.311885	-85.767265			0		0	0	0	0		21400	1812934	-5	-1	55
7137	KY	Radcliff	-1	2	19772	37.829918	-85.945541	270		0		0	0	0	0	7137	21961	2163912	-5	-1	55
6959	KY	Elizabethtown	0	115	18167	37.702674	-85.866173	270		0		0	0	0	0	6959	22542	2124274	-5	-1	55
7161	KY	Shelbyville	-1	89	6238	38.21216	-85.225847	502		0		0	0	0	0	7161	10085	2170050	-5	-1	55
5821	IN	Charlestown	-1	45	5889	38.451984	-85.667224	812		0		0	0	0	0	5821	5993	1812124	-5	-1	55
6184	IN	Sellersburg	-1	8	5745	38.386823	-85.757543	812		0		0	0	0	0	6184	6071	1868670	-5	-1	55
6177	IN	Salem	0	142	5619	38.604124	-86.098801	812		0		0	0	0	0	6177	6172	1867464	-5	-1	55
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
6182	IN	Scottsburg	0	121	5334	38.685166	-85.776682	812		0		0	0	0	0	6182	6040	1868526	-5	-1	55
6107	IN	North Vernon	0	156	5311	39.004991	-85.627758	812		0		0	0	0	0	6107	6515	1855116	-5	-1	55
7054	KY	Leitchfield	-1	62	4965	37.48369	-86.29384	270		0		0	0	0	0	7054	6139	2144686	-6	-1	55
7162	KY	Shepherdsville	-1	60	4805	37.988169	-85.713965	502		0		0	0	0	0	7162	8334	2170086	-5	-1	55
5769	IN	Austin	-1	80	4310	38.742754	-85.809383	812		0		0	0	0	0	5769	4724	1802800	-5	-1	55
6933	KY	Columbia	-1	63	3845	37.100652	-85.306056	270		0		0	0	0	0	6933	4014	2116750	-5	-1	55
7196	KY	Vine Grove	-1	1	3586	37.811971	-85.980006	270		0		0	0	0	0	7196	4169	2179734	-5	-1	55
7026	KY	Hodgenville	-1	0	2721	37.571015	-85.738512	270		0		0	0	0	0	7026	2874	2137396	-5	-1	55
5842	IN	Corydon	0	84	2661	38.212724	-86.125318	812		0		0	0	0	0	5842	2715	1815256	-5	-1	55
7010	KY	Hardinsburg	-1	61	1906	37.776336	-86.45501	270		0		0	0	0	0	7010	2345	2134552	-6	-1	55
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
6898	KY	Brandenburg	-1	0	1857	37.992664	-86.174657	270		0		0	0	0	0	6898	2049	2109226	-6	-1	55
6907	KY	Burkesville	0	81	1815	36.792787	-85.369578	270		0		0	0	0	0	6907	1756	2111098	-5	-1	55
7053	KY	Lebanon Junction	-1	91	1741	37.836197	-85.727127	502		0		0	0	0	0	7053	1801	2144362	-5	-1	55
6000	IN	Lanesville	0	57	512	38.238668	-85.985468	812		0		0	0	0	0	6000	614	1842048	-5	-1	55
35296	IN	Hardinsburg	-1	0	322	38.460588	-86.278006			0		0	0	0	0		244	1831396	-5	-1	55
6098	IN	New Washington	-1	6		38.562575	-85.541524	812		0		0	0	0	0	6098	547	1853820	-5	-1	55

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

31 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
40214	LOUISVILLE	KY	35096	Louisville	55
40299	LOUISVILLE	KY	33001	Louisville	55
40216	LOUISVILLE	KY	32430	Louisville	55
40291	LOUISVILLE	KY	30658	Louisville	55
40272	LOUISVILLE	KY	29272	Louisville	55
40229	LOUISVILLE	KY	29263	Louisville	55
40219	LOUISVILLE	KY	28999	Louisville	55
40220	LOUISVILLE	KY	27667	Louisville	55
40207	LOUISVILLE	KY	25912	Louisville	55
40245	LOUISVILLE	KY	25413	Louisville	55
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
40241	LOUISVILLE	KY	24957	Louisville	55
40218	LOUISVILLE	KY	23129	Louisville	55
40258	LOUISVILLE	KY	21374	Louisville	55
40223	LOUISVILLE	KY	19666	Louisville	55
40205	LOUISVILLE	KY	19237	Louisville	55
40222	LOUISVILLE	KY	17818	Louisville	55
40211	LOUISVILLE	KY	15183	Louisville	55
40215	LOUISVILLE	KY	14970	Louisville	55
40206	LOUISVILLE	KY	14856	Louisville	55
40228	LOUISVILLE	KY	14166	Louisville	55
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
40213	LOUISVILLE	KY	13424	Louisville	55
40212	LOUISVILLE	KY	11586	Louisville	55
40204	LOUISVILLE	KY	10668	Louisville	55
40203	LOUISVILLE	KY	10142	Louisville	55
40210	LOUISVILLE	KY	9539	Louisville	55
40217	LOUISVILLE	KY	9266	Louisville	55
40242	LOUISVILLE	KY	9022	Louisville	55
40243	LOUISVILLE	KY	8686	Louisville	55
40208	LOUISVILLE	KY	6835	Louisville	55
40202	LOUISVILLE	KY	2821	Louisville	55
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
40209	LOUISVILLE	KY	475	Louisville	55

Station W236AN-FX

City LOUISVILLE-KY

City , is located in DMAID: