From: | Newperson <useintowngas(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Problem of creating geometry column (linestring) |
Date: | 2009-09-18 03:31:34 |
Message-ID: | 25502605.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Dear all,
I have a problem on creating geometry column about linestring.
In my table (name is pipe), it has 4 coordinates (x1 y1 x2 y2 x3 y3 x4
y4). I want to use them to form lines in geometry column (name is
pipe_geom).
In sql I type:
SELECT AddGeometryColumn( 'public', 'pipe', 'pipe_geom', 4269, 'LINESTRING',
2 );
UPDATE pipe
SET pipe_geom = GeomertyFromText('LINESTRING(' ||x1 ,y1 || ', '|| x2 ,
y2||',' || x3 , y3||',' || x4 ,y4|| ')', 4269)
But error occurs:
ERROR: function geomertyfromtext(text, text, text, text, text, integer)
does not exist
LINE 3: SET pipe_geom = GeomertyFromText('LINESTRING(' ||sdo_x1 ,sdo...
I also try:
SELECT AddGeometryColumn( 'public', 'pipe', 'pipe_geom', 4269, 'LINESTRING',
2 );
UPDATE pipe
SET pipe_geom = LineFromText('LINESTRING(x1 y1, x2 y2, x3 y3,x4 ,y4 )',
4269)
which error also appears:
ERROR: parse error - invalid geometry
HINT: "LINESTRING(" <-- parse error at position 11 within geometry
I just find example of creating POINT geometry field but have no idea
about how to generate geometry column of linestrings. I hope someone could
help me.
Regards,
Newperson
--
View this message in context: http://www.nabble.com/Problem-of-creating-geometry-column-%28linestring%29-tp25502605p25502605.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Melanie Hofmann | 2009-09-18 06:34:39 | shp2pgsql in java |
Previous Message | Stephan Szabo | 2009-09-17 22:28:19 | Re: sizing storage for 100 M files |