[GRASS-user] Network analysis: Linear reference system (LRS) - on windows

GRASS GRASS user
,
1

hi,

i'm trying the example for Network analysis: Linear reference system (LRS)
from
http://www.grassbook.org/examples3rd_chapter6.php

for the step

# add column to link the route with the bus stop

v.db.addtable route1 col="lid integer" (just copied from the website above)

and i get the following error message:
                                                     
       v.db.addtable route1 col="lid integer"
       Sorry <integer"> is not a valid option
       Description: [...]

the output of

      db.connect -p
           driver:sqlite
           database:$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db
           schema:
           group:

and

    db.tables -p
         XP_PROC
         route1
        stopsall

shows that the db-connection seems to be ok.

best regards
helli

osgeo4w (2008/02/08):

    grass64rc3-2

        GDAL 1.5.4, released 2009/01/07

data

    nc_spm_08

windows vista

____________________________________________________________________
Psssst! Schon vom neuen WEB.DE MultiMessenger gehört?
Der kann`s mit allen: http://www.produkte.web.de/messenger/?did=3123

2

Helmut:

i'm trying the example for Network analysis: Linear reference system
(LRS)
from http://www.grassbook.org/examples3rd_chapter6.php for the step

# add column to link the route with the bus stop
v.db.addtable route1 col="lid integer" (just copied from the website
above)

Most likely a small mistake in the website. Use "v.db.addcol" instead.
Regards, Nikos

3

Helmut Kudrnovsky ha scritto:

hi,

i'm trying the example for Network analysis: Linear reference system (LRS)

Please note: there is also a new LRS plugin for QGIS+PostGIS:
http://faunalia.it/qgis/plugins.xml
If you try it, please let us know.
All the best.
--
Paolo Cavallini: http://www.faunalia.it/pc

4

On Fri, Mar 13, 2009 at 1:36 AM, Nikos Alexandris
<nikos.alexandris@felis.uni-freiburg.de> wrote:

Helmut:

i'm trying the example for Network analysis: Linear reference system
(LRS)
from http://www.grassbook.org/examples3rd_chapter6.php for the step

# add column to link the route with the bus stop
v.db.addtable route1 col="lid integer" (just copied from the website
above)

Most likely a small mistake in the website.

No. If you look two lines above you'll see that v.category
does not copy the the table.

Use "v.db.addcol" instead.

Please don't. It is v.db.addtable.
The example works perfectly.

I suspect an issue on Windows indeed.

Markus

PS: I have added some screenshots to
http://www.grassbook.org/examples3rd_chapter6.php

5

On Fri, 2009-03-13 at 08:12 +0100, Markus Neteler wrote:

On Fri, Mar 13, 2009 at 1:36 AM, Nikos Alexandris
<nikos.alexandris@felis.uni-freiburg.de> wrote:
>
> Helmut:
>> i'm trying the example for Network analysis: Linear reference system
>> (LRS)
>> from http://www.grassbook.org/examples3rd_chapter6.php for the step
>>
>> # add column to link the route with the bus stop
>> v.db.addtable route1 col="lid integer" (just copied from the website
>> above)
>
> Most likely a small mistake in the website.

No. If you look two lines above you'll see that v.category
does not copy the the table.

> Use "v.db.addcol" instead.

Please don't. It is v.db.addtable.
The example works perfectly.

I suspect an issue on Windows indeed.

Markus

PS: I have added some screenshots to
http://www.grassbook.org/examples3rd_chapter6.php

Ahh.. :-O. Sorry, my mistake. Thanks for the clarification Markus.

6

On 13/03/09 01:20, Helmut Kudrnovsky wrote:

hi,

i'm trying the example for Network analysis: Linear reference system (LRS) from
http://www.grassbook.org/examples3rd_chapter6.php

for the step

# add column to link the route with the bus stop

v.db.addtable route1 col="lid integer" (just copied from the website above)

Could you tell us how/where you enter this command ?
Have you tried using the GUI window via the menu ?

Moritz