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');
 find_srid 
-----------
      4326
(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

 
discard

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

Browse other questions tagged or ask your own question.