Re: [GENERAL] beginner postgis question lat/lon

2008-03-03 Thread shadrack
Thanks for the help! Stupid error, Shad On Feb 28, 7:04 am, [EMAIL PROTECTED] (Michael Fuhr) wrote: > 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/

Re: [GENERAL] beginner postgis question lat/lon

2008-02-28 Thread Michael Fuhr
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 documentati

Re: [GENERAL] beginner postgis question lat/lon

2008-02-28 Thread Martijn van Oosterhout
On Wed, Feb 27, 2008 at 04:59:07PM -0800, shadrack wrote: > 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

[GENERAL] beginner postgis question lat/lon

2008-02-27 Thread shadrack
Hi, 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. I'm a new user to postgis...I've been using mysql for a while but needed the spatial fun