Fix K225CA 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 = 'DEL VALLE' and State = 'TX'

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: 1754176557.2782
End: 1754176557.2784
Elapsed time: 0.1931 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('TX','Del Valle',-1)

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

array(22) { ["id"]=> string(5) "80127" ["State"]=> string(2) "TX" ["CityName"]=> string(9) "Del Valle" ["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) "78617" ["zip3"]=> string(3) "786" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "DEL VALLE" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "30.16" ["iplongitude"]=> string(5) "-97.6" ["ziplocation"]=> string(18) "NA-US-TX-DEL VALLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "6898" ["zippopulation"]=> string(5) "13088" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "786" ["zipcity"]=> string(10) "ROUND ROCK" ["zipstate"]=> string(2) "TX" }

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

array(22) { ["id"]=> string(5) "19768" ["State"]=> string(2) "TX" ["CityName"]=> string(10) "Round Rock" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(1) "0" ["Population"]=> string(5) "30923" ["Latitude"]=> string(9) "30.514865" ["Longitude"]=> string(10) "-97.672561" ["PrimaryAC"]=> string(3) "512" ["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"]=> NULL ["Population2000"]=> string(5) "61136" ["FIPS"]=> string(7) "4863500" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "42" }

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

No Rows in Recordset!

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

24 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
18841	TX	Austin	0	440	465622	30.300474	-97.747247	512		1		1	0	1	0	18841	656562	4805000	-6	-1	42
19768	TX	Round Rock	0	0	30923	30.514865	-97.672561	512		0		0	0	0	0		61136	4863500	-6	-1	42
19229	TX	Georgetown	0	166	14842	30.651187	-97.681333	512		0		1	1	1	0	19229	28339	4829336	-6	-1	42
19893	TX	Taylor	-1	81	11472	30.572371	-97.416546	512		0		0	0	0	0	19893	13575	4871948	-6	-1	42
19452	TX	Lockhart	-1	105	9205	29.88187	-97.67604	512		0		0	0	1	0	19452	11615	4843240	-6	-1	42
19204	TX	Fredericksburg	-1	1	6934	30.274058	-98.871822	830		0		0	0	0	0	19204	8911	4827348	-6	-1	42
19243	TX	Gonzales	-1	57	6527	29.508801	-97.447709	830		0		0	0	1	0	19243	7202	4830116	-6	-1	42
41082	TX	Cedar Park	-1	0	5161	30.50662	-97.830317			0		0	0	0	0		26049	4813552	-6	-1	42
19151	TX	Elgin	-1	64	4846	30.348527	-97.372384	512		0		0	0	1	0	19151	5700	4823044	-6	-1	42
19475	TX	Luling	-1	27	4661	29.680499	-97.645439	830		0		0	0	0	0	19475	5080	4845096	-6	-1	42
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
41331	TX	Pflugerville	-1	0	4444	30.446122	-97.623989			0		0	0	0	0		16335	4857176	-6	-1	42
18868	TX	Bastrop	0	226	4044	30.112057	-97.316838	512		0		0	0	1	0	18868	5340	4805864	-6	-1	42
19489	TX	Marble Falls	-1	91	4007	30.574135	-98.27818	830		0		0	0	0	0	19489	4959	4846584	-6	-1	42
18969	TX	Burnet	-1	83	3423	30.758991	-98.226254	512		0		0	0	1	0	18969	4735	4811464	-6	-1	42
19432	TX	Leander	-1	66	3398	30.561108	-97.860301	512		0		0	0	1	0	19432	7596	4842016	-6	-1	42
19388	TX	Kingsland	-1	1	2725	30.667102	-98.444627	325		0		0	0	0	0	19388	4584	4839304	-6	-1	42
20003	TX	Wimberley	-1	12	2403	29.995474	-98.100832	512		0		0	0	1	0	20003	3797	4879624	-6	-1	42
18957	TX	Buda	-1	5	1795	30.084229	-97.839081	512		0		0	0	1	0	18957	2404	4811080	-6	-1	42
19484	TX	Manor	-1	0	1041	30.343071	-97.55671	512		0		0	0	0	0		1204	4846440	-6	-1	42
19126	TX	Dripping Springs	-1	15	1033	30.191998	-98.085382	512		0		0	0	1	0	19126	1548	4821424	-6	-1	42
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
19333	TX	Hutto	0	0	630	30.544517	-97.545198	512		0		0	0	1	0	19333	1250	4835624	-6	-1	42
19123	TX	Doss	-1	26		30.373945	-99.096213	830		0		0	0	0	0	19123			-6	-1	42
19282	TX	Harper	-1	0		30.301009	-99.243326	830		0		0	0	0	0	19282	1006	4832456	-6	-1	42
19359	TX	Johnson City	-1	45		30.276427	-98.408105	830		0		0	0	0	0	19359	1191	4837780	-6	-1	42

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

59 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
78660	PFLUGERVILLE	TX	53788	Pflugerville	42
78613	CEDAR PARK	TX	52383	Cedar Park	42
78664	ROUND ROCK	TX	42720	Round Rock	42
78681	ROUND ROCK	TX	40542	Round Rock	42
78666	SAN MARCOS	TX	35271	San Marcos	30
78641	LEANDER	TX	33858	Leander	42
78640	KYLE	TX	32070	Kyle
78665	ROUND ROCK	TX	24821	Round Rock	42
78628	GEORGETOWN	TX	22495	Georgetown	42
78610	BUDA	TX	19063	Buda	42
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
78602	BASTROP	TX	18734	Bastrop	42
78624	FREDERICKSBURG	TX	18164	Fredericksburg	42
78634	HUTTO	TX	17690	Hutto	42
78626	GEORGETOWN	TX	17253	Georgetown	42
78621	ELGIN	TX	16211	Elgin	42
78633	GEORGETOWN	TX	15079	Georgetown	42
78654	MARBLE FALLS	TX	14340	Marble Falls	42
78617	DEL VALLE	TX	13088	Del Valle
78644	LOCKHART	TX	12604	Lockhart	42
78653	MANOR	TX	12596	Manor	42
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
78620	DRIPPING SPRINGS	TX	12581	Dripping Springs	42
78676	WIMBERLEY	TX	10689	Wimberley	42
78611	BURNET	TX	10045	Burnet	42
78612	CEDAR CREEK	TX	9367
78629	GONZALES	TX	9049	Gonzales	42
78645	LEANDER	TX	8465	Leander	42
78642	LIBERTY HILL	TX	7808	Liberty Hill
78669	SPICEWOOD	TX	7063
78648	LULING	TX	5660	Luling	42
78639	KINGSLAND	TX	5456	Kingsland	42
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
78643	LLANO	TX	5102	Llano
78616	DALE	TX	4715	Dale
78657	HORSESHOE BAY	TX	4394	Horseshoe Bay
78606	BLANCO	TX	4315	Blanco
78652	MANCHACA	TX	3720	Manchaca
78605	BERTRAM	TX	3706	Bertram
78636	JOHNSON CITY	TX	2970	Johnson City	42
78619	DRIFTWOOD	TX	2577
78659	PAIGE	TX	2142	Paige
78655	MARTINDALE	TX	2140	Martindale
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
78631	HARPER	TX	2088	Harper	42
78662	RED ROCK	TX	1788
78656	MAXWELL	TX	1736
78609	BUCHANAN DAM	TX	1611	Buchanan Dam
78638	KINGSBURY	TX	1603	Kingsbury
78650	MC DADE	TX	1248
78615	COUPLAND	TX	999	Coupland
78623	FISCHER	TX	800	Fischer
78632	HARWOOD	TX	756	Harwood
78672	TOW	TX	725	Tow
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
78671	STONEWALL	TX	678	Stonewall
78663	ROUND MOUNTAIN	TX	485	Round Mountain
78608	BRIGGS	TX	471	Briggs
78607	BLUFFTON	TX	0
78614	COST	TX	0	Cost
78618	DOSS	TX	0	Doss	42
78635	HYE	TX	0
78675	WILLOW CITY	TX	0	Willow City
78677	WRIGHTSBORO	TX	0

Station K225CA-FX

City DEL VALLE-TX

City Del Valle, TX is located in DMAID: