« previous next »
Pages: [1] 2

Author Topic: Zip code Lat/Lng DB  (Read 4148 times)

Steve

  • This 49%er supports Romney
  • Just a Jackass
  • *
  • Posts: 16120
  • Karma: +31/-410
  • Mr. Mom
Zip code Lat/Lng DB
« on: July 21, 2008, 07:16:52 PM »
Anyone know of a free DB with a list of the US zip codes with their lat and lng coords? I have one in csv but it refuses to import and typing out my own is going to blow.
Logged
Quote from: ober on September 18, 2012, 10:27:09 PM
hey ethic if you and i were both courting lily allen..... oh wait, which one of us has a relationship that lasted more than the bus ride home?

ober

  • Ashton Shagger
  • Ass Wipe
  • Posts: 14310
  • Karma: +73/-790
  • mini-ober is taking over
    • Windy Hill Web Solutions
Re: Zip code Lat/Lng DB
« Reply #1 on: July 21, 2008, 08:04:29 PM »
Logged

webwhy

  • Jackass IV
  • Posts: 608
  • Karma: +15/-10
Re: Zip code Lat/Lng DB
« Reply #2 on: July 21, 2008, 08:46:04 PM »
Logged

Steve

  • This 49%er supports Romney
  • Just a Jackass
  • *
  • Posts: 16120
  • Karma: +31/-410
  • Mr. Mom
Re: Zip code Lat/Lng DB
« Reply #3 on: July 21, 2008, 10:06:57 PM »
Quote from: webwhy on July 21, 2008, 08:46:04 PM
http://sourceforge.net/projects/zips/

thats the .csv that wont load.

Thnx ober  ill be bookmarking that one
Logged
Quote from: ober on September 18, 2012, 10:27:09 PM
hey ethic if you and i were both courting lily allen..... oh wait, which one of us has a relationship that lasted more than the bus ride home?

Steve

  • This 49%er supports Romney
  • Just a Jackass
  • *
  • Posts: 16120
  • Karma: +31/-410
  • Mr. Mom
Re: Zip code Lat/Lng DB
« Reply #4 on: July 22, 2008, 12:50:34 PM »
Quote
No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

Are you guys splitting them up when you upload them?
Logged
Quote from: ober on September 18, 2012, 10:27:09 PM
hey ethic if you and i were both courting lily allen..... oh wait, which one of us has a relationship that lasted more than the bus ride home?

webwhy

  • Jackass IV
  • Posts: 608
  • Karma: +15/-10
Re: Zip code Lat/Lng DB
« Reply #5 on: July 22, 2008, 02:07:59 PM »
Quote
thats the .csv that wont load.

i've used it for several projects without a problem :dunno:
Logged

Steve

  • This 49%er supports Romney
  • Just a Jackass
  • *
  • Posts: 16120
  • Karma: +31/-410
  • Mr. Mom
Re: Zip code Lat/Lng DB
« Reply #6 on: July 22, 2008, 02:21:37 PM »
It's the same error with both of them (see last post). Then i try and create multiple csv files and i get "Invalid field count in CSV input on line 1.".

Logged
Quote from: ober on September 18, 2012, 10:27:09 PM
hey ethic if you and i were both courting lily allen..... oh wait, which one of us has a relationship that lasted more than the bus ride home?

Mike

  • Jackass In Charge
  • Posts: 11257
  • Karma: +168/-32
  • Ex Asshole - a better and more caring person.
Re: Zip code Lat/Lng DB
« Reply #7 on: July 22, 2008, 02:27:39 PM »
Dude, if you can't get the CVS file to upload just open it up and use a text editor to setup the database inserts.  CSV files are easy to edit.
Logged

Steve

  • This 49%er supports Romney
  • Just a Jackass
  • *
  • Posts: 16120
  • Karma: +31/-410
  • Mr. Mom
Re: Zip code Lat/Lng DB
« Reply #8 on: July 22, 2008, 02:32:08 PM »
Yea but theres like, 40,000 rows
Logged
Quote from: ober on September 18, 2012, 10:27:09 PM
hey ethic if you and i were both courting lily allen..... oh wait, which one of us has a relationship that lasted more than the bus ride home?

Mike

  • Jackass In Charge
  • Posts: 11257
  • Karma: +168/-32
  • Ex Asshole - a better and more caring person.
Re: Zip code Lat/Lng DB
« Reply #9 on: July 22, 2008, 02:41:59 PM »
That's it?  Learn how to use your editor.  Hell, import it into excel, add columns to put it repeated characters (like ', ' between data).  Copy and paste the text down the column.  Then copy the sheet to a text editor and then do a find/replace on tabs.  Copy and paste into phpMyAdmin.  Done.

Done that more times then I care to think of.
Logged

Steve

  • This 49%er supports Romney
  • Just a Jackass
  • *
  • Posts: 16120
  • Karma: +31/-410
  • Mr. Mom
Re: Zip code Lat/Lng DB
« Reply #10 on: July 22, 2008, 02:56:33 PM »
thats a good idea. my brain has given up any hope of functioning this week. I think i may need to hire some cute girl to handle the customers/phones/emails because between them, the repairs, the websites, etc i have more then i can handle on my own and my braisn eating itsself
Logged
Quote from: ober on September 18, 2012, 10:27:09 PM
hey ethic if you and i were both courting lily allen..... oh wait, which one of us has a relationship that lasted more than the bus ride home?

ober

  • Ashton Shagger
  • Ass Wipe
  • Posts: 14310
  • Karma: +73/-790
  • mini-ober is taking over
    • Windy Hill Web Solutions
Re: Zip code Lat/Lng DB
« Reply #11 on: July 22, 2008, 03:13:59 PM »
phpMyAdmin handled that file quite well for me actually.
Logged

Steve

  • This 49%er supports Romney
  • Just a Jackass
  • *
  • Posts: 16120
  • Karma: +31/-410
  • Mr. Mom
Re: Zip code Lat/Lng DB
« Reply #12 on: July 22, 2008, 03:19:02 PM »
I think its the limit setting for the file size. And since its shared hosting i dont think i can change it. I had to set php settings and it required an ini in every single folder under the directory for that to even work right.

" (Max: 2,048KiB)"
Logged
Quote from: ober on September 18, 2012, 10:27:09 PM
hey ethic if you and i were both courting lily allen..... oh wait, which one of us has a relationship that lasted more than the bus ride home?

Steve

  • This 49%er supports Romney
  • Just a Jackass
  • *
  • Posts: 16120
  • Karma: +31/-410
  • Mr. Mom
Re: Zip code Lat/Lng DB
« Reply #13 on: July 22, 2008, 04:03:00 PM »
how the heck do i move columns in excel? I can make a new one, but i cant "drag and drop" it between another.

Example:

CA CB CC

to

CB CA CC
Logged
Quote from: ober on September 18, 2012, 10:27:09 PM
hey ethic if you and i were both courting lily allen..... oh wait, which one of us has a relationship that lasted more than the bus ride home?

Perspective

  • badfish
  • Jackass In Charge
  • Posts: 4635
  • Karma: +64/-22
    • http://jeff.bagu.org
Re: Zip code Lat/Lng DB
« Reply #14 on: July 22, 2008, 04:03:58 PM »
cut and paste? or
select, copy, delete, insert, paste
Logged
Pages: [1] 2
« previous next »