/    Sign up×
Community /Pin to ProfileBookmark

Hi,
I downloaded a zip-code data base yesterday. It’s over 3 megabytes and 42,000 lines of code including the zipcode, lat/long. and city or town. Here’s a sample-
[SIZE=”1″]
“00501”,”+40.922326″,”-072.637078″,”HOLTSVILLE”,”NY”,”SUFFOLK”,”UNIQUE”
“00544”,”+40.922326″,”-072.637078″,”HOLTSVILLE”,”NY”,”SUFFOLK”,”UNIQUE”
“00601”,”+18.165273″,”-066.722583″,”ADJUNTAS”,”PR”,”ADJUNTAS”,”STANDARD”
“00602”,”+18.393103″,”-067.180953″,”AGUADA”,”PR”,”AGUADA”,”STANDARD”
“00603”,”+18.455913″,”-067.145780″,”AGUADILLA”,”PR”,”AGUADILLA”,”STANDARD”
“00604”,”+18.493520″,”-067.135883″,”AGUADILLA”,”PR”,”AGUADILLA”,”STANDARD”
“00605”,”+18.465162″,”-067.141486″,”AGUADILLA”,”PR”,”AGUADILLA”,”STANDARD”
“00606”,”+18.172947″,”-066.944111″,”MARICAO”,”PR”,”MARICAO”,”STANDARD”
“00610”,”+18.288685″,”-067.139696″,”ANASCO”,”PR”,”ANASCO”,”STANDARD”
“00611”,”+18.279531″,”-066.802170″,”ANGELES”,”PR”,”UTUADO”,”PO BOX ONLY”
[/SIZE]

All I know is javascript and arrays. Obviously, I’m not about to edit all that for javascript.
But, what language or methods can I learn to access the data?

to post a comment
JavaScript

3 Comments(s)

Copy linkTweet thisAlerts:
@gil_davisJan 26.2007 — You will never be able to do anything with it using javascript, it is just too big. It wasn't meant to handle that much data. Not to mention that you'd have to load the whole 3m on the client to run it.

Server side technology is the way to go, something like IIS if you use MS Windows O/S. Most Windows versions will host IIS for you to be able to learn.
Copy linkTweet thisAlerts:
@ChikaraJan 26.2007 — You could probably implement more effectively using SQL (Or Access) combined with ASP or PHP.


What exactly are you trying to accomplish with this database?
Copy linkTweet thisAlerts:
@justinbarneskinauthorJan 27.2007 — Well, it's just too much when I think about it.

First, have a U.S. area map that would then link to a state map or somehow slice the areas down to a size where I can mouseover spots and get the zip.

Or simply enter a text input and retrieve the rest of the line.

Some web sites offer to enter a zip code to get your local news. A random generator fails half the time and, I never know where I'm going.

The way I work with it now since it is a .txt file, I have to search the zip code or city and collect them on a separate html/javascript array. Many zip codes are redundant. I'm sure I will eventual accumulate enough zip codes or, get interested in another project.
×

Success!

Help @justinbarneskin spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 6.16,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...