[pgrouting-users] assign_vertex_id error

pgRouting pgrouting-users
1

No sir. I just ran the query and it returned the following result.

VSDelhidb=# SELECT count(*) FROM roads_line where the_geom is NULL;
count

11
(1 row)

What do I do sir?

2

You database has 11 entries which do not have a correct geometry column,
I suspect that this may be causing you some problems.

select * from roads_line where the_geom is NULL will list all the problems

delete from roads_line where the_geom is null

will permanently remove these data items from your database.

I can not say that this is the root cause of your problem but I suspect
that its not helping you.

Annu Anurag wrote:

No sir. I just ran the query and it returned the following result.

VSDelhidb=# SELECT count(*) FROM roads_line where the_geom is NULL;
count
-------
    11
(1 row)

What do I do sir?
_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

--