[pgrouting-dev] Cannot create topology

[Stephen Woodbridge]

You might also need to add it to:

/usr/share/proj/epsg

# Spherical Mercator projection
<900913> +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 
+x_0=0.0 +y_0=0 +k=1.0 +units=m +over +nadgrids=@null +no_defs  <>

Also, when you ran assign_vetrix_id() your tolerance was something like 
0.000001 which is appropriate if your data is in degrees, but this 
Mercator projection is in meters so your tolerance should be something 
in a range like 5.0 - 0.5, maybe start with 1.0 and see how that works. 
if you rebuild you table and try different values for tolerance, you can 
look at the number of unique node numbers. When the number suddenly gets 
smaller you probably have it too large.

-Steve

On 2/17/2011 1:14 PM, Daniel Kastl wrote:
> 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
> <mailto: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
>     <mailto: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
>>     <<mailto:stephanos_ch at yahoo.gr>stephanos_ch at yahoo.gr
>>     <mailto: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
>>         <http://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
>>         <mailto:pgrouting-dev at lists.osgeo.org>pgrouting-dev at lists.osgeo.org
>>         <mailto: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:
>>     <mailto:daniel.kastl at georepublic.de>daniel.kastl at georepublic.de
>>     <mailto:daniel.kastl at georepublic.de>
>>     Web: <http://georepublic.de/>http://georepublic.de
>>     _______________________________________________
>>     pgrouting-dev mailing list
>>     pgrouting-dev at lists.osgeo.org <mailto:pgrouting-dev at lists.osgeo.org>
>>     http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>
>     _______________________________________________
>     pgrouting-dev mailing list
>     pgrouting-dev at lists.osgeo.org <mailto:pgrouting-dev at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>
>
>
>
> --
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de <mailto: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