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 = 'NEW GRETNA' and State = 'NJ'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754170355.6907
End: 1754170355.6911
Elapsed time: 0.3822 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NJ','New Gretna',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80065" ["State"]=> string(2) "NJ" ["CityName"]=> string(10) "New Gretna" ["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) "08224" ["zip3"]=> string(3) "082" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(10) "NEW GRETNA" ["zipstate"]=> string(2) "NJ" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "39.71" ["iplongitude"]=> string(6) "-74.52" ["ziplocation"]=> string(19) "NA-US-NJ-NEW GRETNA" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "358" ["zippopulation"]=> string(3) "606" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "082" ["zipcity"]=> string(19) "EGG HARBOR TOWNSHIP" ["zipstate"]=> string(2) "NJ" }
**** zip3 city**************
NULL
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
22 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
08234EGG HARBOR TOWNSHIPNJ37623
08205ABSECONNJ24427Absecon
08232PLEASANTVILLENJ16127Pleasantville
08204CAPE MAYNJ15523Cape May
08210CAPE MAY COURT HOUSENJ13739Cape May Court House
08260WILDWOODNJ11807Wildwood135
08215EGG HARBOR CITYNJ11254Egg Harbor City135
08226OCEAN CITYNJ10270Ocean City
08244SOMERS POINTNJ9358Somers Point
08201ABSECONNJ9186Absecon
zipcodezipcityzipstatezippopulationcitynameDMAID
08203BRIGANTINENJ8255Brigantine
08251VILLASNJ8038Villas135
08225NORTHFIELDNJ7758Northfield
08221LINWOODNJ6768Linwood
08270WOODBINENJ6102Woodbine
08230OCEAN VIEWNJ5385
08223MARMORANJ3924
08242RIO GRANDENJ2795Rio Grande
08243SEA ISLE CITYNJ2047Sea Isle City
08202AVALONNJ1508Avalon135
zipcodezipcityzipstatezippopulationcitynameDMAID
08241PORT REPUBLICNJ1125Port Republic
08247STONE HARBORNJ915Stone Harbor
Station W272BH-FX
City NEW GRETNA-NJ

City New Gretna, NJ is located in DMAID: