I think <meta http-equiv="content-type" content="text/html; charset=utf-8">SRID = 900913 is not in the spatial_ref_sys table, if you're using an older version of PostGIS.<div>You can take it from here:</div><div><meta http-equiv="content-type" content="text/html; charset=utf-8"><a href="http://trac.openstreetmap.org/browser/applications/utils/export/osm2pgsql/900913.sql">http://trac.openstreetmap.org/browser/applications/utils/export/osm2pgsql/900913.sql</a></div>
<div><br></div><div><a href="http://trac.openstreetmap.org/browser/applications/utils/export/osm2pgsql/900913.sql"></a>Daniel<div><br><br><div class="gmail_quote">2011/2/18 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;"><div 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><font color="#888888"><div>Stephanos Charalambous</div></font></div><div><div></div><div class="h5"><div><br>On 17 Φεβ 2011, at 16:58, Daniel Kastl <<a href="mailto:daniel@georepublic.de" target="_blank">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" target="_blank"></a><a href="mailto:stephanos_ch@yahoo.gr" target="_blank">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" target="_blank"></a><a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank"></a><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"></a><a href="mailto:daniel.kastl@georepublic.de" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66, 99, 171)" target="_blank"></a><a href="http://georepublic.de" target="_blank">http://georepublic.de</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" target="_blank">pgrouting-dev@lists.osgeo.org</a></span><br>
<span><a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a></span><br></div></blockquote></div></div></div><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>
<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></div>