<html><body bgcolor="#FFFFFF"><div>Thanks Daniel for the quick response.</div><div><br></div><div>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.</div><div><br></div><div>How can I do the necessary checks?<br><br>With Regards,<div><br></div><div>Stephanos Charalambous</div></div><div><br>On 17 Φεβ 2011, at 16:58, Daniel Kastl <<a href="mailto:daniel@georepublic.de">daniel@georepublic.de</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div>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"><a href="mailto:stephanos_ch@yahoo.gr">stephanos_ch@yahoo.gr</a></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"><a href="mailto:pgrouting-dev@lists.osgeo.org">pgrouting-dev@lists.osgeo.org</a></a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank"><a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev">http://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a></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"><a href="mailto:daniel.kastl@georepublic.de">daniel.kastl@georepublic.de</a></a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66, 99, 171)" target="_blank"><a href="http://georepublic.de">http://georepublic.de</a></a></span><br>
</div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>pgrouting-dev mailing list</span><br><span><a href="mailto:pgrouting-dev@lists.osgeo.org">pgrouting-dev@lists.osgeo.org</a></span><br><span><a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev">http://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a></span><br></div></blockquote></body></html>