[pgrouting-dev] Cannot create topology

[Stephanos Charalambous]

Thanks Daniel for the quick response.

The shapefile which i imported was in google web mercator, so during the import I set the SRID = 900913. The geom constraint has the same value too.

How can I do the necessary checks?

With Regards,

Stephanos Charalambous

On 17 Φεβ 2011, at 16:58, Daniel Kastl <daniel at georepublic.de> wrote:

> 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
> _______________________________________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20110217/6b8f5ea6/attachment.html