[Cartoweb-users] Pgdijkstra and PostGIS problems

[Fay Du]

Looks for me, assign_vertex_id should read srid of input tale and use it
when creating vertices_tmp table. Currently, it is hard coded to use -1.

And hard code to 4258 can solve the specific problem. When you have some
other tables with different srid, the same error will come again.

Fay 

-----Original Message-----
From: cartoweb-users-bounces at lists.maptools.org
[mailto:cartoweb-users-bounces at lists.maptools.org] On Behalf Of Ville
Antti Ensio Leinonen
Sent: Thursday, July 13, 2006 3:28 AM
To: cartoweb-users at lists.maptools.org
Subject: RE: [Cartoweb-users] Pgdijkstra and PostGIS problems 

I can confirm that closing and opening works with OID error.

I have got also following errors.
cartoweb-users at lists.maptools.org
ERROR:  new row for relation "vertices_tmp" violates check constraint 
"enforce_dims_the_geom"

ERROR:  new row for relation "vertices_tmp" violates check constraint 
"enforce_srid_the_geom"

To fix these you need to change assign_vertex_id. There is line
EXECUTE $q$ SELECT addGeometryColumn('vertices_tmp', 'the_geom', -1,
'POINT', 2) $q$;
I had to change it to
EXECUTE $q$ SELECT addGeometryColumn('vertices_tmp', 'the_geom',
4258,'POINT', 4) $q$;.

Where -1 to 4258 is srid of data and 2 to 4 is if ihave understand right
4 
dimension geometry. When i used  shp2psql, i noticed that it sayd 
MULTILINE[4]. This seems to work with my data.

Is my solution right?
  if it is, I hope this helps someone




--          Ville Leinonen		--

On Wed, 12 Jul 2006, Fay Du wrote:

> I got similar error before.
> My solution is close connection to database and connection to database
> again. The call assign_vertex_id. I don't know if it works for you.
You
> can try it.
>
> Fay
>
> -----Original Message-----
> From: cartoweb-users-bounces at lists.maptools.org
> [mailto:cartoweb-users-bounces at lists.maptools.org] On Behalf Of Ville
> Antti Ensio Leinonen
> Sent: Wednesday, July 12, 2006 4:10 AM
> To: cartoweb-users at lists.maptools.org
> Subject: [Cartoweb-users] Pgdijkstra and PostGIS problems
>
> 	Hi all. I have problem with PostgreSQL, PostGIS and Pgdijkstra.
> I
> have shapefile wich i have shp2sql and insert it to postgis database
and
>
> it's working. The Problem comes when i try to use Pgdijkstra. I follow
> instruction to point where i need use assign_vertex_id('elements',
0.1):
> I get following error messages, depending luck.
>
>
> ERROR:  relation with OID 159110 does not exist
> CONTEXT:  SQL statement "SELECT  id, the_geom FROM vertices_tmp WHERE
> distance(the_geom,  $1 ) <  $2 "
> PL/pgSQL function "point_to_id" line 7 at select into variables
> PL/pgSQL function "assign_vertex_id" line 14 at assignment
>
> above with modified assign_vertex_id and orginal
>
> some times with orginal i get even whine about
> constrains enforce_dims_the_geom problem.
>
> my modified assign_vertex_id build vertices_tmp table out from
> assign_vertex_id function and it worked few times with windows
> installation. Now with linux installation i keep getting those
"relation
>
> with ..." errors.
>
> with windows installation i get to point where dijkstra.README told me
> to
> use create_graph_table() wich didn't work too.
>
> Any idea howto get pgdijkstra to work. Wrong version from postgres or
> postgis ?
>
> Win: postgres 8.1, postgis 1.1.3, pgdijkstra from cartoweb win install
> link
> linux gentoo: postgres 8.0.8, postgis 1.1.2 and pgdijkstra from latest
> stable cartoweb source packakge
>
> --          Ville Leinonen		--
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>
>
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users