[pgrouting-users] assign_vertex_id error

pgRouting pgrouting-users
1

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?

2

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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

3

select getsrid(the_geom) from xxx_table;

will tell you what the srid id is set to for a geometry column in a table
xxx_table;

update xxx_table set the_geom=setsrid(the_geom,4326)

Will set the srid value for a column called the_geom in a table called
xxx_table

You can use qgis to checked your datavalues, just ask it to import a
postgis table and will will draw information.
D.

Annu Anurag 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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

--