Skip site navigation (1) Skip section navigation (2)

Re: beginner postgis question lat/lon

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: shadrack <shadkeene(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: beginner postgis question lat/lon
Date: 2008-02-28 15:04:11
Message-ID: 20080228150411.GA37966@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-general
On Wed, Feb 27, 2008 at 04:59:07PM -0800, shadrack wrote:
> This may seem like a very simple question...it is...but I can't find
> documentation on it to help. I've seen some posts about lat/long but
> none that give simple solutions on how to insert lat/long in tables.

See the PostGIS documentation, in particular Chapter 4 "Using PostGIS":

http://postgis.refractions.net/docs/ch04.html

(The site isn't responding right now; hopefully it'll be available
soon.)

> postgis=# insert into routes_geom values(1, 'J084',
> GeomFromText('LINESTRING(38.20 -121.00, 38.20, -118.00)', 4326));
> 
> I receive this error:
> ERROR:  parse error - invalid geometry
> CONTEXT:  SQL function "geomfromtext" statement 1

There are two problems with the geometry string: the syntax error is
due an extra comma in the second pair of coordinates, and coordinates
should be (X Y) therefore (lon lat) instead of (lat lon).  Try this:

insert into routes_geom values(1, 'J084', GeomFromText('LINESTRING(-121.00 38.20, -118.00 38.20)', 4326));

You might wish to subscribe to the postgis-users mailing list if you
have additional questions.

-- 
Michael Fuhr

In response to

Responses

pgsql-general by date

Next:From: Michael FuhrDate: 2008-02-28 15:13:08
Subject: Re: what happens if something goes wrong in transaction?
Previous:From: Alvaro HerreraDate: 2008-02-28 14:51:42
Subject: Re: what happens if something goes wrong in transaction?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group