<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.3">
</HEAD>
<BODY>
On Tue, 2011-10-04 at 17:52 -0700, kungphil wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
Hi
I am trying to import an xyz table from PostgreSQL db...
I can connect to the db and select/view rows using;
echo "select in.x, in.y, in.val from in" | db.select
x|y|val
2776480|2547420|12
2776510|2547420|12
2776540|2547420|12
2776570|2547420|12
2776600|2547420|12
2776420|2547390|12
2776450|2547390|12
2776480|2547390|12
2776510|2547390|12
2776540|2547390|12
But when I pipe the output to;
r.in.xyz -i input=- output=test fs="|"
I get an error "Bad y-coordinate line 1 column2. <y>"
</PRE>
</BLOCKQUOTE>
<BR>
You need to get rid of the column names (the first row of output is "x y val" instead of numbers).<BR>
Use the -c option to db.select to display without the column headers.<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
<PRE>
Can anyone help please!
Thanks, Phil
--
View this message in context: <A HREF="http://osgeo-org.1803224.n2.nabble.com/r-in-xyz-and-postrgresql-tp6860616p6860616.html">http://osgeo-org.1803224.n2.nabble.com/r-in-xyz-and-postrgresql-tp6860616p6860616.html</A>
Sent from the Grass - Users mailing list archive at Nabble.com.
_______________________________________________
grass-user mailing list
<A HREF="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</A>
<A HREF="http://lists.osgeo.org/mailman/listinfo/grass-user">http://lists.osgeo.org/mailman/listinfo/grass-user</A>
This mail was received via Mail-SeCure System.
</PRE>
</BLOCKQUOTE>
<BR>
</BODY>
</HTML>