[pgrouting-dev] Cannot create topology

[Daniel Kastl]

Hello Stephanos,

As the error says, there seems to be something wrong with your SRID. You
should check if the constraint on "the_geom" and the entry in the
"geometry_columns" table are OK? Does it have an SRID or is it set -1?

Daniel


2011/2/17 Stephanos Charalambous <stephanos_ch at yahoo.gr>

> Hello,
>
> I am kind of new in using pgrouting and I would really like your help.
>
> I have imported a road network, called "testNic" (from shapefile) into a
> PostgreSQL database using QGIS and pgAdmin. Then, I added the necessary
> columns, source, target and cost, and created the geom_idx. The problem that
> I am facing is that I cannot create the topology using the query:
>
> SELECT assign_vertex_id('testNic', 0.00001, 'the_geom', 'gid');
>
> I get the following error, and i can't locate where the mistake is.
>
> NOTICE:  CREATE TABLE will create implicit sequence "vertices_tmp_id_seq"
> for serial column "vertices_tmp.id"
> CONTEXT:  SQL statement "CREATE TABLE vertices_tmp (id serial)"
> PL/pgSQL function "assign_vertex_id" line 14 at EXECUTE statement
> ERROR:  find_srid() - couldnt find the corresponding SRID - is the geometry
> registered in the GEOMETRY_COLUMNS table?  Is there an uppercase/lowercase
> missmatch?
> CONTEXT:  PL/pgSQL function "assign_vertex_id" line 20 at assignment
>
> ********** Error **********
>
> ERROR: find_srid() - couldnt find the corresponding SRID - is the geometry
> registered in the GEOMETRY_COLUMNS table?  Is there an uppercase/lowercase
> missmatch?
> SQL state: P0001
> Context: PL/pgSQL function "assign_vertex_id" line 20 at assignment
>
> Any help would be really appreciated.
>
> Regards
> Stephanos Charalambous
>
>
> _______________________________________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>



-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20110217/93ebd857/attachment-0001.html