Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

When I try to launch osm2pgrouting

osm2pgrouting -file ~/Téléchargements/mayotte-latest.osm -conf /usr/share/osm2pgrouting/mapconfig.xml -dbname routing -user gisuser -passwd fred1490 -clean

I get this error

Create Topology failed: ERROR:  We can not determine the srid of "ways.the_geom"!

Though I have a defined srid in my db

routing=# SELECT Find_SRID('public', 'ways', 'the_geom');
(1 row)

routing=# select * from geometry_columns;
 f_table_catalog | f_table_schema | f_table_name | f_geometry_column | coord_dimension | srid |    type    
 routing         | public         | ways         | the_geom          |               2 | 4326 | LINESTRING
(1 row)

Maybe it's because geometry_column is a view and not a table? Thanks

share|improve this question
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.