<html style="direction: ltr;">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;" bidimailui-charset-is-forced="true"
smarttemplateinserted="true" bgcolor="#FFFFFF" text="#000000">
<font size="+1"><font face="Arial">I am trying to export line
vectors to PostGIS with either v.out.ogr or v.out.postgis. <br>
<br>
I find that v.out.ogr sets the wrong SRID in the PostGIS geometry_columns.
I get SRID 900914 instead of the SRID of the GRASS Location.<br>
<br>
Using v.out.postgis, on the other hand, I call
option="SRID=2039" and the SRID is correct in the PostGIS table,
but no attributes. I tried with both without the flag '-t' and
with the flag. No difference.<br>
<br>
Here are the commands:<br>
<br>
</font></font><font size="+1"><tt>GRASS 7.0.4 (ITM):> g.version</tt><tt><br>
</tt><tt>GRASS 7.0.4 (2016)</tt><tt><br>
</tt><tt>GRASS 7.0.4 (ITM):> g.proj -p</tt><tt><br>
</tt><tt>-PROJ_INFO-------------------------------------------------</tt><tt><br>
</tt><tt>name : Transverse Mercator</tt><tt><br>
</tt><tt>proj : tmerc</tt><tt><br>
</tt><tt>ellps : grs80</tt><tt><br>
</tt><tt>lat_0 : 31.73439361111111</tt><tt><br>
</tt><tt>lon_0 : 35.20451694444445</tt><tt><br>
</tt><tt>k : 1.0000067</tt><tt><br>
</tt><tt>x_0 : 219529.584</tt><tt><br>
</tt><tt>y_0 : 626907.39</tt><tt><br>
</tt><tt>towgs84 : -48,55,52,0,0,0,0</tt><tt><br>
</tt><tt>no_defs : defined</tt><tt><br>
</tt><tt>-PROJ_UNITS------------------------------------------------</tt><tt><br>
</tt><tt>unit : metre</tt><tt><br>
</tt><tt>units : metres</tt><tt><br>
</tt><tt>meters : 1</tt><tt><br>
</tt><tt><br>
</tt><tt>GRASS 7.0.4 (ITM):> v.out.postgis -c --overwrite
input=${STREAMS} type=line output="PG:host=nekarot
dbname=geodata user=geodba" output_layer=nikuz.${STREAMS}
options="SRID=2039,GEOMETRY_NAME=geom,FID=gid"</tt><tt><br>
</tt><tt># I get correct SRID, but no attributes ??</tt><tt><br>
</tt><tt><br>
</tt><tt>GRASS 7.0.4 (ITM):> v.out.ogr -s --overwrite
input=${STREAMS} format=PostgreSQL type=line
output="PG:host=nekarot dbname=geodata user=geodba"
lco="FID=gid,GEOMETRY_NAME=geom" output_layer=nikuz.${STREAMS}</tt><tt><br>
</tt><tt># Full set of attributes b</tt><tt>ut SRID=900914 ??</tt></font><font
size="+1"><font face="Arial"><br>
<br>
Any help is appreciated,<br>
Micha<br>
</font></font>
<pre class="moz-signature" cols="72">--
Micha Silver
Arava Drainage Authority
+972-523-665918</pre>
</body>
</html>