Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    18

    Data type for geolocation data

    I would like to store latitude and longitude coordinates in my database. I am using PostgreSQL and am aware of PostGIS, however I do not want to use it at this stage for various reasons.

    I would however like to store lat/long coords that would be taken from Google Earth or even directly input from a user via the uploading of CSV/NMEA/GE data files.

    Can anyone tell me what the best data type to use is? I was thinking of using NUMERIC(12,9) which would give me 1.11mm accuracy, but I am not sure if that is the best way to go about doing it.

    Is anyone familiar with the data output by GPS loggers, and can offer me any insight into how best to input it into a DB? I have ordered a GPS logger, and will be poking around with its output data files to when it arrives, but any veteran knowledge would be appreciated.

    Regards,
    - Naz.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    PostgreSQL supports several geometric data types that may be of interest, including the point.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •