[Cartoweb-users] issues with the demoPlugins installation

[zze-SIGALE PORTANERI F ext RD-BIZZ-SOP]

Hi Werner,

You're right about the demo_routing.sql file: it builds the whole database correctly. Thanks.

Anyway, I have another problem now: The resulted "graph" layer is not displayed on the top of the map. 
When I submit a route search between two towns, no error occurs, the routing_results table is well filled with the corresponding roads, the current view is well recenter arround the two towns, but no specific graph layer is added to the map to "hilight" the route.

It should be a missing config step, but if someone has an idea...

Regards
Franck 


-----Message d'origine-----
De : werner.meyer7 at bluewin.ch [mailto:werner.meyer7 at bluewin.ch] 
Envoyé : mercredi 22 février 2006 08:57
À : zze-SIGALE PORTANERI F ext RD-BIZZ-SOP; cartoweb-users at lists.maptools.org
Objet : RE: [Cartoweb-users] issues with the demoPlugins installation

Hello,

have you noticed that the installation instruction contains redundant and confilicting steps ?

When you execute this in 1.2.3 ...:

"
l Import Europe road geodata in PostGIS, create its graph structure and configure plugin routing database. To do so, simply execute the demo_routing.sql file, located in the <CARTOWEB_HOME>/projects/ demoPlugins/server_conf/sql directory."

... the demo_routing.sql file creates the Table roads_europe including data and does the things that are described later in 1.2.4.2.2 (for manual execution ???):

"
1.2.4.2.2. Graph Importation
The first step is to delete unneeded columns of the table roads_europe_tmp.
To do so, you can type:
$ CREATE TABLE roads_europe (gid int UNIQUE, source_id int, target_id int); $ SELECT AddGeometryColumn('roads_europe', 'the_geom', -1, 'MULTILINESTRING',
2 );
$ INSERT INTO roads_europe (gid, the_geom) (SELECT gid, the_geom FROM roads_europe); The resulting table is so roads_europ..."


So We have to choose. I tried to do both in sequence and created quite a mess.
Dropping everything and executing only demo_routing.sql  gave a functioning demo.

Werner Meyer


Original Message:
-----------------
From: PORTANERI Franck fportaneri.ext at rd.francetelecom.com
Date: Tue, 21 Feb 2006 16:09:45 +0100
To: cartoweb-users at lists.maptools.org
Subject: [Cartoweb-users] issues with the demoPlugins installation


Hi all,

I tried to follow the installation notes for the demoPlugin add-on :

First I think it may have few typo in the manual section "1.2.4.2.2. Graph Importation", first step:

    You wrote:

$ CREATE TABLE roads_europe (gid int UNIQUE, source_id int, target_id int); $ SELECT AddGeometryColumn('roads_europe', 'the_geom', -1, 'MULTILINESTRING', 2 ); $ INSERT INTO roads_europe (gid, the_geom) (SELECT gid, the_geom FROM roads_europe);


    To avoid some errors during the nexts steps, I had to launch:

$ CREATE TABLE roads_europe (gid int UNIQUE, source_id int, target_id int); $ SELECT AddGeometryColumn('roads_europe', 'the_geom', -1, 'MULTILINESTRING', 2 ); $ INSERT INTO roads_europe (gid, the_geom) (SELECT gid, the_geom FROM roads_europe*_tmp*); <<
*$ ALTER TABLE roads_europe ADD COLUMN edge_id int;                        
<<*
  


But after the whole process, I have the following failure message under
CartoWeb:

    Userinfo: SELECT txt, geom_id FROM roads_europe_vertices WHERE txt
    != '' ORDER BY txt [nativecode=ERROR: column "txt" does not exist]


It seems that the  create_graph_tables creates the table roads_europe_vertices with no txt column...!!!

    demo_plugins=# \d roads_europe_vertices;
                                    Table "public.roads_europe_vertices"
     Column  |       Type        |                              
    Modifiers                              
    ---------+-------------------+------------------------------------------
-----------------------------
     id      | integer           | not null default
    nextval('public.roads_europe_vertices_id_seq'::text)
     geom_id | integer           | not null
     txt     | character varying |
    Indexes:
        "roads_europe_vertices_geom_id_key" UNIQUE, btree (geom_id)
        "roads_europe_vertices_id_idx" btree (id)


Any idea?

Thanks in advance.

--
Franck



--------------------------------------------------------------------
mail2web - Check your email from the web at http://mail2web.com/ .