Sorry if the problem was unclear. I would like to:<br>1) use the first 3
columns to create the 3D point geometry, but not put XYZ values into the table<br>2) use the 4th column to add a "code" attribute to the table, and populate with values from the 4th column of the ascii file<br>
3) have the
"cat" field automagically populated. <br>4) the desired end result is a 3D point file, with only "cat" and "code" attributes in the table.<br><br>Perhaps what I'm trying to accomplish is not necessary, but I'm trying to keep the DB table small due to the volume of points. For now I'm just working with 10 of the 5 million.<br>
<br>Here's the file head, there's no header (although it is X,Y,Z,<some int number>)<br>480354.49,1539756.39,16.59,196<br><br>the v.in.ascii was:<br>v.in.ascii -z -n input=57697.txt output=lidar57697 format=point fs=, skip=0 {columns=code int} x=1 y=2 z=3 cat=0<br>
<br>which yeilds:<br>maximum input row length: 43<br>maximum number of columns: 4<br>minimum number of columns: 4<br>column: 1 type: double<br>column: 2 type: double<br>column: 3 type: double<br>column: 4 type: integer<br>
<br><ERROR> number of columns defined (1) does not match number of columns (4) in input.<br><br><br>Mark<br><br><div class="gmail_quote">On Wed, Apr 9, 2008 at 10:21 AM, Moritz Lennert <<a href="mailto:mlennert@club.worldonline.be">mlennert@club.worldonline.be</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">On 09/04/08 14:55, M S wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I would like to import the XYZ to build the geometry for 3D points, and have only "Cat" and "Code" in the attribute table. ("Code" being a column name for the 4th column in the input ASCII). I cant seem to find the combination of column definitions and other parameters to achieve this. One option seems to import them all as "x double, y double, z double, code int", and then after the import, drop the x,y,z columns. Is it possible to put the first 3 ASCII column values to the geometry, and use only the last column as an attribute?<br>
</blockquote>
<br></div>
I'm not sure I really understand your problem. Maybe you could send us the layout of your file (head -2) and the v.in.ascii command you tried.<br>
<br>
You need to specify the _column number_ of your X,Y and Z columns with the x=, y= and z= parameters, the _column number_ of you cat column with the cat= parameter, and the attribute columns with the columns= parameter.<br>
<br>
So if I understand your file correctly it would be something like this:<br>
<br>
v.in.ascii -z [...] x=1 y=2 z=3 cat=4 columns="code int"<br>
<br>
You might also want to use the -b flag, as topology building can lead to overload if the input data file is too large.<br><font color="#888888">
<br>
Moritz<br>
</font></blockquote></div><br>