[pgrouting-users] assign_vertex_id error

[James David Smith]

Hey Annu,

Something like:

UPDATE table SET the_geom=ST_SetSRID(the_geom, 4326);

Though I sometimes find this troublesome and find it easier just to
create a new column, and then populate it with the data. Something
like:

SELECT AddGeometryColumn ('table_name','new_geom', 4326,'POINT',2);

Then populate it by doing:

UPDATE table_name
SET new_geom = the_geom;

Hope this helps. I'm not an expert at all - somebody else may have a
better solution.

James


On 12 June 2012 14:55, Annu Anurag <i.skidoosh at gmail.com> wrote:
> I just checked the srid field in the geometry_columns. Its -1. I think that
> is causing the problem? I'm using the dataset of Delhi. It should run on
> srid=4326. How do I change it to EPSG: 4326 in my geometry column?
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>