postgres-----pgrouting

shp2pgsql -s  4326 -d -W GBK C:\Users\benda\Desktop\fsdownload\路网.shp public.roadDetail | "E:\Program Files\PostgreSQL\9.2\bin\psql" -h localhost -U postgres -d runoobdb -p 5432

UPDATE roaddetail SET length= ST_Length(geom), rev_length = -1
WHERE oneway = 'F';

UPDATE roaddetail
SET rev_length  = ST_Length(geom), length= -1
WHERE oneway = 'T';

UPDATE roaddetail
SET length= ST_Length(geom), rev_length  = ST_Length(geom)
WHERE oneway = 'B';

shp2pgsql -s  4326 -d -W GBK C:\Users\benda\Desktop\fsdownload\路网.shp public.roadList | "E:\Program Files\PostgreSQL\9.2\bin\psql" -h localhost -U postgres -d geoserver -p 5432

SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra('SELECT  gid AS id,source::integer,target::integer,length::double precision AS cost FROM roaddetail where length is not null',1, 2, false, false);

SELECT * FROM roaddetail_vertices_pgr ORDER BY the_geom <-> ST_GeomFromText ( 'POINT(120.3178 26.93760)', 4326 )  LIMIT 10;

SELECT pgr_createTopology(
	'street', 
	0.001,
	'geom',
	'gid',
	'source',
	'target'
); 

alter table street add column source int;
alter table street add column target int;
alter table street add column length double precision;
alter table street add column rev_length double precision;

create index source_idx on road ("source");
create index target_idx on road ("target");

update street set length=ST_Length(ST_TransForm(the_geom,4326),true),rev_length=ST_Length(ST_TransForm(the_geom,4326),true);

SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra('SELECT gid AS id,source::integer,target::integer,length::double precision AS cost from harbin',1,60,false,false) as dijkstra LEFT JOIN harbin_vertices_pgr as etvg ON (dijkstra.id1 = etvg.id) ORDER BY seq;