• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

Storing coordinated in Postgresql

Hi
I have got a dataset that includes Long/latitude and Easting/Northing; a few of the records look like this:
51.750365      -0.34032      514667      207044
51.563842      0.207556      553111      187305
51.69484      -0.386208      511636      200798
51.393646      -0.171873      527286      167653
51.42931      -0.500216      504362      171101
51.413846      -0.422078      509831      169495
51.660042      -0.405021      510420      196899
51.680993      0.009067      538996      199936

I have read that I should store these values as "points" in Postgresql but when I try to import from my excel spreadsheet where they are stored as "general", I get an error. I have also tried to store as a number and that didn't work either.

What is the best way to do this?
thanks
0
lz7cjc
Asked:
lz7cjc
  • 6
  • 5
1 Solution
 
als315Commented:
0
 
gheistCommented:
PostGIS has all the geo data types builtin. Sure you can define your type, though why not take what somebody did for you...
0
 
lz7cjcAuthor Commented:
thanks - I agree but I can't work out how to use PostGIS! I have installed it but I can't find it (
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
gheistCommented:
0
 
lz7cjcAuthor Commented:
ok but if I am using the visual editor, pgadmin, where do I find that option in the table builder ->add column?
0
 
gheistCommented:
It has extensions to default postgresql installation, like dll/so files.
you can also configure your own type of two floats, or plainly use 2 floats to record coordinates.
0
 
lz7cjcAuthor Commented:
Thanks for your help on this but I'm far from clear on what I'm meant to do. Please can you explain the steps, assuming I'm an idiot?
Thanks
0
 
gheistCommented:
Either
1) add extensions of postgis to postgresql server (that lets you query distances form SQL)
2) define your own type of pair of floats
3) just add 2 float columns to store coordinates
0
 
lz7cjcAuthor Commented:
ok thanks - I am going to be feeding these coords into geomapping so it sounds like the float type will work. Will try that and let you know
0
 
lz7cjcAuthor Commented:
ummm - float doesn't exist as a data type in the drop down list in pgadmin

however Latitude and longitude are appearing as data types - so that would be the answer then!
0
 
gheistCommented:
It is real or double precision.
real is accurate to 6 digits
double otherwise (like your example)
0
 
lz7cjcAuthor Commented:
The types longitude and latitude appear automatically in the drop down list if postgis is installed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now