Hello Stephanos,<div><br></div><div>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? </div>
<div><br></div><div>Daniel</div><div><br><br><div class="gmail_quote">2011/2/17 Stephanos Charalambous <span dir="ltr"><<a href="mailto:stephanos_ch@yahoo.gr">stephanos_ch@yahoo.gr</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hello,<br>
<br>
I am kind of new in using pgrouting and I would really like your help.<br>
<br>
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:<br>
<br>
SELECT assign_vertex_id('testNic', 0.00001, 'the_geom', 'gid');<br>
<br>
I get the following error, and i can't locate where the mistake is.<br>
<br>
NOTICE: CREATE TABLE will create implicit sequence "vertices_tmp_id_seq" for serial column "<a href="http://vertices_tmp.id" target="_blank">vertices_tmp.id</a>"<br>
CONTEXT: SQL statement "CREATE TABLE vertices_tmp (id serial)"<br>
PL/pgSQL function "assign_vertex_id" line 14 at EXECUTE statement<br>
ERROR: find_srid() - couldnt find the corresponding SRID - is the geometry registered in the GEOMETRY_COLUMNS table? Is there an uppercase/lowercase missmatch?<br>
CONTEXT: PL/pgSQL function "assign_vertex_id" line 20 at assignment<br>
<br>
********** Error **********<br>
<br>
ERROR: find_srid() - couldnt find the corresponding SRID - is the geometry registered in the GEOMETRY_COLUMNS table? Is there an uppercase/lowercase missmatch?<br>
SQL state: P0001<br>
Context: PL/pgSQL function "assign_vertex_id" line 20 at assignment<br>
<br>
Any help would be really appreciated.<br>
<br>
Regards<br>
Stephanos Charalambous<br>
<br>
<br>
_______________________________________________<br>
pgrouting-dev mailing list<br>
<a href="mailto:pgrouting-dev@lists.osgeo.org">pgrouting-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a><br>
</blockquote></div><br><br clear="all"><br>-- <br><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66, 99, 171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66, 99, 171)" target="_blank">http://georepublic.de</a></span><br>
</div>