Fix K212AQ 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 = 'RILEY' and State = 'OR'

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

Number of rows returned = 0
Start: 1754177903.5658
End: 1754177903.566
Elapsed time: 0.1981 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('OR','Riley',-1)

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

array(22) { ["id"]=> string(5) "80216" ["State"]=> string(2) "OR" ["CityName"]=> string(5) "Riley" ["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) "97758" ["zip3"]=> string(3) "977" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(5) "RILEY" ["zipstate"]=> string(2) "OR" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "43.58" ["iplongitude"]=> string(7) "-119.57" ["ziplocation"]=> string(14) "NA-US-OR-RILEY" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }

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

array(3) { ["zip3"]=> string(3) "977" ["zipcity"]=> string(4) "BEND" ["zipstate"]=> string(2) "OR" }

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

array(22) { ["id"]=> string(5) "16018" ["State"]=> string(2) "OR" ["CityName"]=> string(4) "Bend" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "244" ["Population"]=> string(5) "20469" ["Latitude"]=> string(9) "44.056434" ["Longitude"]=> string(11) "-121.308085" ["PrimaryAC"]=> string(3) "541" ["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) "16018" ["Population2000"]=> string(5) "52029" ["FIPS"]=> string(7) "4105800" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "224" }

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

No Rows in Recordset!

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

10 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ISPCount	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
16018	OR	Bend	0	244	20469	44.056434	-121.308085	541		16018	52029	4105800	-8	-1	224
16206	OR	Redmond	-1	112	7163	44.268978	-121.183487	541		16206	13481	4161200	-8	-1	224
16140	OR	Madras	-1	23	3443	44.630536	-121.129128	541		16140	5078	4145250	-8	-1	224
16028	OR	Burns	-1	2	2913	43.586827	-119.057114	541		16028	3064	4109800	-8	-1	224
16267	OR	Warm Springs	-1	0	2287	44.760168	-121.268233	541			2431	4178600	-8	-1	224
39549	OR	Hines	-1	0	1452	43.559163	-119.083441				1623	4134250	-8	-1	224
39603	OR	Terrebonne	-1	0	1143	44.349266	-121.180106				1469	4172800	-8	-1	224
16234	OR	Sisters	-1	21	679	44.290828	-121.549024	541		16234	959	4167950	-8	-1	224
69432	OR	La Pine		0	0	43.719068	-121.528163		0	0	5799	4141050	-8	-1	224
16041	OR	Chemult	-1	0		42.804981	-121.584833	541		16041			-8	-1	224

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

27 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
97701	BEND	OR	45428	Bend	224
97702	BEND	OR	31666	Bend	224
97756	REDMOND	OR	26318	Redmond	224
97754	PRINEVILLE	OR	14336	Prineville
97739	LA PINE	OR	8679	La Pine	224
97741	MADRAS	OR	8373	Madras	224
97759	SISTERS	OR	5901	Sisters	224
97760	TERREBONNE	OR	5621	Terrebonne	224
97707	BEND	OR	4839	Bend	224
97720	BURNS	OR	3288	Burns	224
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
97734	CULVER	OR	2182	Culver
97753	POWELL BUTTE	OR	1748
97738	HINES	OR	1618	Hines	224
97733	CRESCENT	OR	517
97711	ASHWOOD	OR	0
97712	BROTHERS	OR	0
97710	FIELDS	OR	0
97721	PRINCETON	OR	0
97722	DIAMOND	OR	0
97736	FRENCHGLEN	OR	0
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
97730	CAMP SHERMAN	OR	0
97731	CHEMULT	OR	0	Chemult	224
97737	GILCHRIST	OR	0	Gilchrist
97750	MITCHELL	OR	0	Mitchell
97751	PAULINA	OR	0	Paulina
97752	POST	OR	0
97758	RILEY	OR	0	Riley

Station K212AQ-FX

City RILEY-OR

City Riley, OR is located in DMAID: