GRASS-Wiki - User contributions [en]

Extracting coordinates of points and writing them to the attribute table

2011-03-27T18:57:13Z

⚠️TimNorwey:

The workflow below describes how coordinates can be extracted from points and how they can be written into the attribute table.

The example is based on a '''CSV'''-File:
<source lang="bash">
674065.18600,3367985.59300,25.83
674066.43200,3367982.46800,25.96
674065.99100,3367983.83600,40.24
674065.92600,3367985.70100,26.00

''' '''
</source>
__TOC__
=== Importing points ===
For the import of the CSV-File use {{cmd|v.in.ascii}}.

<source lang="bash">
v.in.ascii -z input=/path/to/points_map.csv output=points format=point skip=0 x=1 y=2 z=3 cat=0 fs=,
</source>

=== Add attribute table for vector ===
Through {{cmd|v.db.addtable}} an attribute table for the points is created.

<source lang="bash">
v.db.addtable map=points_map table=points_map columns="cat integer"
</source>

=== Connect the vector to the attribute table ===
Use {{cmd|v.db.connect}} to connect the vector with its corresponding table.

<source lang="bash">
v.db.connect -o map=points_map table=points_map
</source>

=== Add columns ===
Use {{cmd|v.db.addcol}} to add the columns to the attribute table.

<source lang="bash">
v.db.addcol map=points columns="x double precision, y double precision, z double precision"
</source>

=== Add coordinates ===
Use {{cmd|v.to.db}} to write the coordinates of the points into the attribute table.

<source lang="bash">
v.to.db map=points_map opt=coor columns="x,y,z"
</source>

--[[User:TimNorwey|TimNorwey]] 14:01, 26 March 2011 (PDT)

[[Category: FAQ]]

Extracting coordinates of points and writing them to the attribute table

2011-03-27T14:54:11Z

⚠️TimNorwey:

The workflow below describes how coordinates can be extracted from points and how they can be written into the attribute table.

The example is based on a '''CSV'''-File:
<source lang="bash">
674065.18600,3367985.59300,25.83
674066.43200,3367982.46800,25.96
674065.99100,3367983.83600,40.24
674065.92600,3367985.70100,26.00

</source>
__TOC__
=== Importing points ===
For the import of the CSV-File use {{cmd|v.in.ascii}}.

<source lang="bash">
v.in.ascii -z input=/path/to/points_map.csv output=points format=point skip=0 x=1 y=2 z=3 cat=0 fs=,
</source>

=== Add attribute table for vector ===
Through {{cmd|v.db.addtable}} an attribute table for the points is created.

<source lang="bash">
v.db.addtable map=points_map table=points_map columns="cat integer"
</source>

=== Connect the vector to the attribute table ===
Use {{cmd|v.db.connect}} to connect the vector with its corresponding table.

<source lang="bash">
v.db.connect -o map=points_map table=points_map
</source>

=== Add columns ===
Use {{cmd|v.db.addcol}} to add the columns to the attribute table.

<source lang="bash">
v.db.addcol map=points columns="x double precision, y double precision, z double precision"
</source>

=== Add coordinates ===
Use {{cmd|v.to.db}} to write the coordinates of the points into the attribute table.

<source lang="bash">
v.to.db map=points_map opt=coor columns="x,y,z"
</source>

--[[User:TimNorwey|TimNorwey]] 14:01, 26 March 2011 (PDT)

[[Category: FAQ]]

Extracting coordinates of points and writing them to the attribute table

2011-03-26T21:01:26Z

⚠️TimNorwey: Created page with "The workflow below describes how coordinates can be extracted from points and how they can be written into the attribute table. The example is based on a '''CSV'''-File: <sourc..."

The workflow below describes how coordinates can be extracted from points and how they can be written into the attribute table.

The example is based on a '''CSV'''-File:
<source lang="bash">
674065.18600,3367985.59300,25.83
674066.43200,3367982.46800,25.96
674065.99100,3367983.83600,40.24
674065.92600,3367985.70100,26.00
</source>

=== Importing points ===
For the import of the CSV-File use {{cmd|v.in.ascii}}.

<source lang="bash">
v.in.ascii -z input=/.../.../.../points.csv output=points format=point skip=0 x=1 y=2 z=3 cat=0
</source>

=== Add attribute table for vector ===
Through {{cmd|v.db.addtable}} an attribute table for the points is created.

<source lang="bash">
v.db.addtable map=points layer=1 table=points columns="cat integer"
</source>

=== Connect the vector to the attribute table ===
Use {{cmd|v.db.connect}} to connect the vector with its corresponding table.

<source lang="bash">
v.db.connect -o map=points driver=dbf database=$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/ table=points key=cat layer=1
</source>

=== Add columns ===
Use {{cmd|v.db.addcol}} to add the columns to the attribute table.

<source lang="bash">
v.db.addcol map=points layer=1 columns="x double precision, y double precision, z double precision"
</source>

=== Add coordinates ===
Use {{cmd|v.to.db}} to write the coordinates of the points into the attribute table.

<source lang="bash">
v.to.db map=points opt=coor columns="x,y,z"
</source>

--[[User:TimNorwey|TimNorwey]] 14:01, 26 March 2011 (PDT)