Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WGJC FM 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 = 'UNIVERSITY PARK' and State = 'PA'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const5Using where


Number of rows returned = 0
Start: 1754176544.7145
End: 1754176544.7146
Elapsed time: 0.1299 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('PA','University Park',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80126" ["State"]=> string(2) "PA" ["CityName"]=> string(15) "University Park" ["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) "16802" ["zip3"]=> string(3) "168" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(15) "UNIVERSITY PARK" ["zipstate"]=> string(2) "PA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(4) "40.8" ["iplongitude"]=> string(6) "-77.85" ["ziplocation"]=> string(24) "NA-US-PA-UNIVERSITY PARK" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "355" ["zippopulation"]=> string(3) "458" ["zipincome"]=> string(7) "5873461" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "168" ["zipcity"]=> string(13) "STATE COLLEGE" ["zipstate"]=> string(2) "PA" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "17023" ["State"]=> string(2) "PA" ["CityName"]=> string(13) "State College" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "181" ["Population"]=> string(5) "38923" ["Latitude"]=> string(9) "40.791261" ["Longitude"]=> string(9) "-77.85874" ["PrimaryAC"]=> string(3) "814" ["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) "17023" ["Population2000"]=> string(5) "38420" ["FIPS"]=> string(7) "4273808" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "254" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
15 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
17023PAState College01813892340.791261-77.858748140010017023384204273808-5-1254
16670PALewistown-194934140.597385-77.573238717001001667089984243000-5-1254
16679PALock Haven-174923041.134388-77.450347570000001667991494244128-5-1254
16403PAClearfield-1109663341.022555-78.440233814001001640366314214064-5-1254
16319PABellefonte-176635840.914684-77.774756814000001631963954205256-5-1254
16618PAJersey Shore-122435341.202587-77.266715570000001661844824238128-5-1254
16885PAPhilipsburg-176304840.897315-78.21895814000001688530564260008-5-1254
16438PACurwensville-179292440.973408-78.522318814000001643826504217840-5-1254
16769PAMount Union-138287840.384845-77.88329814000001676925044251984-5-1254
16344PABoalsburg-158220640.78267-77.786899814000001634435784207368-5-1254
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
16839PAPatton-113220640.634466-78.650812814000001683920234258432-5-1254
16301PAAvis018150641.185234-77.316455570000001630114924203632-5-1254
16387PACentre Hall-173120340.844287-77.684615814000001638710794212376-5-1254
16922PAPort Matilda-1066940.800056-78.051119814000006384262280-5-1254
80034PAAllport-10254
**** cities in zip3 **************
42 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
16801STATE COLLEGEPA21293State College254
16823BELLEFONTEPA19473Bellefonte254
16803STATE COLLEGEPA15132State College254
16830CLEARFIELDPA10880Clearfield254
16866PHILIPSBURGPA6561Philipsburg254
16870PORT MATILDAPA6289Port Matilda254
16841HOWARDPA4357Howard
16833CURWENSVILLEPA4315Curwensville254
16827BOALSBURGPA3952Boalsburg254
16828CENTRE HALLPA3930Centre Hall254
zipcodezipcityzipstatezippopulationcitynameDMAID
16875SPRING MILLSPA3258Spring Mills
16858MORRISDALEPA2991
16844JULIANPA2236Julian
16822BEECH CREEKPA1958Beech Creek
16881WOODLANDPA1828
16838GRAMPIANPA1628Grampian
16865PENNSYLVANIA FURNACEPA1593
16878WEST DECATURPA1583
16877WARRIORS MARKPA1474Warriors Mark
16874SNOW SHOEPA1099Snow Shoe
zipcodezipcityzipstatezippopulationcitynameDMAID
16872REBERSBURGPA1026Rebersburg
16836FRENCHVILLEPA944Frenchville
16820AARONSBURGPA867Aaronsburg
16854MILLHEIMPA848Millheim
16863OLANTAPA651
16829CLARENCEPA597Clarence
16845KARTHAUSPA593
16802UNIVERSITY PARKPA458University Park
16859MOSHANNONPA431
16821ALLPORTPA0Allport254
zipcodezipcityzipstatezippopulationcitynameDMAID
16864ORVISTONPA0
16832COBURNPA0Coburn
16850LECONTES MILLSPA0
16840HAWK RUNPA0
16871POTTERSDALEPA0
16852MADISONBURGPA0Madisonburg
16839GRASSFLATPA0
16861NEW MILLPORTPA0
16837GLEN RICHEYPA0
16860MUNSONPA0
zipcodezipcityzipstatezippopulationcitynameDMAID
16879WINBURNEPA0Winburne
16882WOODWARDPA0Woodward
***** 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 WGJC-FM
City UNIVERSITY PARK-PA

City University Park, PA is located in DMAID: