[GRASS-user] problem in v.out.ogr postgis

temiz temiz at deprem.gov.tr
Thu Sep 20 11:32:46 EDT 2007


hello

I want to transfer grass vector (line) to postgis by this command:

v.out.ogr input=hey_el86 type=line dsn="PG:host=localhost dbname=bzk2 
user=postgres" olayer=shey_el86 format=PostgreSQL

at postgis side:

SELECT cat, isclosed(wkb_geometry) from shey_el86;

cat | isclosed
-----+----------
   1 | t
   1 | t
...

all closed ring. It shouldn't happen.
They shoud be all line with different starting and end coord points.

select cat,astext(pointn(wkb_geometry,1)) as first_pt 
,astext(pointn(wkb_geometry,npoints(wkb_geometry))) as last_pt from 
shey_el86 ;
gives :
 cat |                 first_pt                        |                 
last_pt
-----+------------------------------------------+------------------------------------------
   1 | POINT(468597.760453644 4630916.47967991) | POINT(468597.760453644 
4630916.47967991)

you see first point and last point are the same.

I checked the view from the grass monitor. They should not be closed ring.

how can I solve the problem ?

regards






-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




More information about the grass-user mailing list