Fix W235BC 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 = 'BOWMANSVILLE' and State = 'NY'

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: 1754152170.7599
End: 1754152170.7601
Elapsed time: 0.2620 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NY','Bowmansville',-1)

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

array(22) { ["id"]=> string(5) "79928" ["State"]=> string(2) "NY" ["CityName"]=> string(12) "Bowmansville" ["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) "14026" ["zip3"]=> string(3) "140" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(12) "BOWMANSVILLE" ["zipstate"]=> string(2) "NY" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "42.94" ["iplongitude"]=> string(6) "-78.68" ["ziplocation"]=> string(21) "NA-US-NY-BOWMANSVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "417" ["zippopulation"]=> string(3) "701" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "140" ["zipcity"]=> string(8) "LOCKPORT" ["zipstate"]=> string(2) "NY" }

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

array(22) { ["id"]=> string(5) "13568" ["State"]=> string(2) "NY" ["CityName"]=> string(8) "Lockport" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "173" ["Population"]=> string(5) "24426" ["Latitude"]=> string(9) "43.169757" ["Longitude"]=> string(10) "-78.690987" ["PrimaryAC"]=> string(3) "716" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "13568" ["Population2000"]=> string(5) "22279" ["FIPS"]=> string(7) "3643082" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "52" }

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

No Rows in Recordset!

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

11 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
13694	NY	Niagara Falls	0	199	61840	43.094305	-79.017339	716		0		0	1	0	0	13694	55593	3651055	-5	-1	52
13568	NY	Lockport	0	173	24426	43.169757	-78.690987	716		0		0	1	0	0	13568	22279	3643082	-5	-1	52
38501	NY	Depew	-1	0	17673	42.911758	-78.7016			0		0	0	0	0		16629	3620313	-5	-1	52
13372	NY	Dunkirk	0	170	13989	42.482959	-79.329818	716		0		0	1	0	0	13372	13131	3621105	-5	-1	52
13548	NY	Lancaster	-1	84	11940	42.900408	-78.67303	716		0		0	1	0	0	13548	11188	3641135	-5	-1	52
13426	NY	Fredonia	-1	1	10436	42.440845	-79.333813	716		0		0	0	0	0	13426	10706	3627419	-5	-1	52
13206	NY	Attica	-1	49	2630	42.865138	-78.276885	585		0		0	0	0	0	13206	2597	3603001	-5	-1	52
13180	NY	Alden	-1	47	2457	42.900959	-78.493266	585		0		0	0	0	0	13180	2666	3601088	-5	-1	52
13197	NY	Arcade	-1	72	2081	42.533257	-78.428894	585		0		0	0	0	0	13197	2026	3602407	-5	-1	52
13340	NY	Corfu	-1	0	755	42.958662	-78.403938	585		0		0	0	0	0	13340	795	3618201	-5	-1	52
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
13451	NY	Grand Island	-1	75				716		0		0	0	0	0	13451			-5	-1	52

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

56 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
14094	LOCKPORT	NY	41705	Lockport	52
14075	HAMBURG	NY	37102	Hamburg
14086	LANCASTER	NY	28598	Lancaster	52
14043	DEPEW	NY	21518	Depew	52
14072	GRAND ISLAND	NY	18204	Grand Island	52
14051	EAST AMHERST	NY	18084
14020	BATAVIA	NY	17176	Batavia	54
14052	EAST AURORA	NY	15612	East Aurora
14048	DUNKIRK	NY	11192	Dunkirk	52
14092	LEWISTON	NY	9643	Lewiston
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
14004	ALDEN	NY	9396	Alden	52
14063	FREDONIA	NY	9209	Fredonia	52
14031	CLARENCE	NY	8352	Clarence
14006	ANGOLA	NY	8348	Angola
14059	ELMA	NY	8299
14001	AKRON	NY	8276	Akron
14057	EDEN	NY	7171	Eden
14032	CLARENCE CENTER	NY	6906	Clarence Center
14085	LAKE VIEW	NY	6645
14068	GETZVILLE	NY	6245
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
14047	DERBY	NY	5577	Derby
14011	ATTICA	NY	5024	Attica	52
14009	ARCADE	NY	4463	Arcade	52
14067	GASPORT	NY	4368	Gasport
14036	CORFU	NY	4216	Corfu	52
14070	GOWANDA	NY	4008	Gowanda
14080	HOLLAND	NY	3863	Holland
14042	DELEVAN	NY	3060	Delevan
14062	FORESTVILLE	NY	2791	Forestville
14025	BOSTON	NY	2713	Boston
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
14098	LYNDONVILLE	NY	2495	Lyndonville
14081	IRVING	NY	2123
14033	COLDEN	NY	2051
14058	ELBA	NY	1966	Elba
14012	BARKER	NY	1965	Barker
14040	DARIEN CENTER	NY	1945
14005	ALEXANDER	NY	1640	Alexander
14034	COLLINS	NY	1554
14065	FREEDOM	NY	1467
14013	BASOM	NY	1367
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
14030	CHAFFEE	NY	1342	Chaffee
14028	BURT	NY	1315
14008	APPLETON	NY	1312
14024	BLISS	NY	1309	Bliss
14055	EAST CONCORD	NY	1229
14054	EAST BETHANY	NY	1165
14091	LAWTONS	NY	1071
14037	COWLESVILLE	NY	1059
14066	GAINESVILLE	NY	881	Gainesville
14069	GLENWOOD	NY	755
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
14026	BOWMANSVILLE	NY	701	Bowmansville
14082	JAVA CENTER	NY	442
14039	DALE	NY	0
14041	DAYTON	NY	0
14060	FARMERSVILLE STATION	NY	0
14083	JAVA VILLAGE	NY	0

Station W235BC-FX

City BOWMANSVILLE-NY

City Bowmansville, NY is located in DMAID: