[pgrouting-dev] Cannot create topology

[Daniel Kastl]

I think SRID = 900913 is not in the spatial_ref_sys table, if you're using
an older version of PostGIS.
You can take it from here:
http://trac.openstreetmap.org/browser/applications/utils/export/osm2pgsql/900913.sql

<http://trac.openstreetmap.org/browser/applications/utils/export/osm2pgsql/900913.sql>
Daniel


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

> 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>
> 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>pgrouting-dev at lists.osgeo.org
>>  <http://lists.osgeo.org/mailman/listinfo/pgrouting-dev>
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>>
>
>
>
> --
> Georepublic UG & Georepublic Japan
> eMail:  <daniel.kastl at georepublic.de>daniel.kastl at georepublic.de
> Web:  <http://georepublic.de/>http://georepublic.de
>
> _______________________________________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>
>
> _______________________________________________
> 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/20110218/0a0fb565/attachment.html