Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix W278CI Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2009-06-13 09:56:14" ["dmarank"]=> string(1) "0" ["dmaID"]=> string(1) "0" ["dmaType"]=> string(1) "C" ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(13) "United States" ["Population25up"]=> string(9) "300000000" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(2) "WW" }
Database: media
SQL: select * from cities where CityName = 'OXFORD' and State = 'FL'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const14Using where


Number of rows returned = 0
Start: 1754192970.8826
End: 1754192970.8835
Elapsed time: 0.9730 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('FL','Oxford',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80353" ["State"]=> string(2) "FL" ["CityName"]=> string(6) "Oxford" ["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) "34484" ["zip3"]=> string(3) "344" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "OXFORD" ["zipstate"]=> string(2) "FL" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "28.92" ["iplongitude"]=> string(6) "-82.04" ["ziplocation"]=> string(15) "NA-US-FL-OXFORD" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1510" ["zippopulation"]=> string(4) "2720" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "344" ["zipcity"]=> string(5) "OCALA" ["zipstate"]=> string(2) "FL" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "3231" ["State"]=> string(2) "FL" ["CityName"]=> string(5) "Ocala" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "388" ["Population"]=> string(5) "42045" ["Latitude"]=> string(9) "29.187704" ["Longitude"]=> string(10) "-82.130613" ["PrimaryAC"]=> string(3) "352" ["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) "3231" ["Population2000"]=> string(5) "45943" ["FIPS"]=> string(7) "1250750" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "86" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
27 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
3125FLGainesville02608477029.665245-82.336097352000003125954471225175-5-186
3231FLOcala03884204529.187704-82.130613352000003231459431250750-5-186
3148FLHomosassa Springs-181627128.807216-82.550012352000003148124581232400-5-186
3156FLInverness-182579728.839076-82.34035335200000315667891233950-5-186
3030FLAlachua-10452929.779286-82.47984938600000303060981200375-5-186
3090FLCrystal River-1270404428.90067-82.59369935200000309034851215775-5-186
3324FLWildwood-199342128.85861-82.03849935200000332439241277675-5-186
3142FLHigh Springs-10314429.824471-82.59526838600000314238631230525-5-186
3044FLBelleview-1110266629.061488-82.05494135200000304434781205375-5-186
3325FLWilliston-10217929.386811-82.44670635200000332522971277825-5-186
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
33710FLHomosassa-10211328.783307-82.6172380000022941232375-5-186
33692FLHernando-10210328.929498-82.374340000082531229425-5-186
3076FLChiefland-190191729.481801-82.86209735200000307619931211925-5-186
3222FLNewberry-159164429.639605-82.60871535200000322233161248200-5-186
3103FLDunnellon-173162429.050045-82.45554635200000310318981218675-5-186
3036FLArcher-160137229.531527-82.51963335200000303612891201775-5-186
3302FLTrenton-179128729.615081-82.81773235200000330216171272350-5-186
33722FLInglis-10124129.032878-82.6667310000014911233800-5-186
3059FLBronson-111087529.448784-82.6363143520000030599641208700-5-186
3071FLCedar Key-1066829.145558-83.041544352000007901211225-5-186
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
3330FLYankeetown-15563529.031155-82.7201043520000033306291278925-5-186
3207FLMicanopy-16061229.506489-82.2820133520000032076531245225-5-186
33711FLHorseshoe Beach-1025229.440547-83.288776000002061232650-5-186
33859FLOtter Creek-1013629.323435-82.772708000001211253500-5-186
33745FLLa Crosse-1012229.844171-82.403993000001431237300-5-186
3283FLSilver Springs-16229.215153-82.097163352000003283-5-186
3089FLCross City-17829.635279-83.12470735200000308917751215575-5-186
**** cities in zip3 **************
32 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
34491SUMMERFIELDFL21799
34472OCALAFL19741Ocala86
34471OCALAFL19283Ocala86
34476OCALAFL17468Ocala86
34481OCALAFL14319Ocala86
34480OCALAFL14240Ocala86
34482OCALAFL13801Ocala86
34470OCALAFL13536Ocala86
34446HOMOSASSAFL12854Homosassa86
34465BEVERLY HILLSFL12110Beverly Hills
zipcodezipcityzipstatezippopulationcitynameDMAID
34473OCALAFL12043Ocala86
34442HERNANDOFL11565Hernando86
34420BELLEVIEWFL11066Belleview86
34474OCALAFL10878Ocala86
34479OCALAFL10039Ocala86
34432DUNNELLONFL9351Dunnellon86
34452INVERNESSFL8910Inverness86
34450INVERNESSFL7645Inverness86
34475OCALAFL7532Ocala86
34453INVERNESSFL7259Inverness86
zipcodezipcityzipstatezippopulationcitynameDMAID
34461LECANTOFL7130Lecanto
34488SILVER SPRINGSFL7087Silver Springs86
34448HOMOSASSAFL7045Homosassa86
34429CRYSTAL RIVERFL6519Crystal River86
34428CRYSTAL RIVERFL6428Crystal River86
34434DUNNELLONFL6076Dunnellon86
34436FLORAL CITYFL5715Floral City
34431DUNNELLONFL5669Dunnellon86
34433DUNNELLONFL5014Dunnellon86
34484OXFORDFL2720Oxford
zipcodezipcityzipstatezippopulationcitynameDMAID
34449INGLISFL2173Inglis86
34498YANKEETOWNFL427Yankeetown86
***** stations in DMA*************
26 records found!
stationidCallSignLicenseeServicecitynamexStatexcityid
22710BTRNWorld Wide WebWW79841
23163CRN1World Wide WebWW79841
23164CRN2World Wide WebWW79841
23165CRN3World Wide WebWW79841
23166CRN4World Wide WebWW79841
23167CRN5World Wide WebWW79841
23168CRN6World Wide WebWW79841
42585CSPAN1World Wide WebWW79841
42586CSPAN2World Wide WebWW79841
42587CSPAN3World Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
22711ESPNWorld Wide WebWW79841
58943EWTNWorld Wide WebWW79841
22652Fox NewsWorld Wide WebWW79841
22712Fox SportsWorld Wide WebWW79841
41312GCN1World Wide WebWW79841
41481GCN4World Wide WebWW79841
77684GCN5World Wide WebWW79841
32729MOYLWorld Wide WebWW79841
44298NPRWorld Wide WebWW79841
44299PRIWorld Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
22707Radio AmericaWorld Wide WebWW79841
44583SportsBylineWorld Wide WebWW79841
23558TalkStarWorld Wide WebWW79841
40372TammyRadioWorld Wide WebWW79841
44584TheBlazeWorld Wide WebWW79841
44301YSNWorld Wide WebWW79841
Station W278CI-FX
City OXFORD-FL

City Oxford, FL is located in DMAID: