public static void updatePassableToT() { var pg = new PostGIS(); string strSQL = "update ch10.realtimeroad set passable=1"; pg.SQLExcute(strSQL); }
public static void updatePassable(int source ,int target,int passable) { PostGIS pg = new PostGIS(); string strSQL = string.Format(@" update ch10.realtimeroad set passable={2} WHERE realtimeroad.source={0} and realtimeroad.target={1}", source, target, passable); pg.SQLExcute(strSQL); }
public static void updateLength() { var pg = new PostGIS(); string strSQL = "update ch10.realtimeroad set length1=random()*40"; pg.SQLExcute(strSQL); }
public static List<string> GetRealRoads(string layer,string leve) { var pg = new PostGIS(); string sql = " set search_path = public, ch10;" + "select sroadid,st_astext(the_geom) as geom,accessleve from fourleveroads"; var records = pg.QueryRealRoads(layer, sql); return records; }
public static List<string> GetClosetRoad(double lg, double lt, double ditMini) { var records = new List<string>(); var pg = new PostGIS(); string strSQL = string.Format(@"select source ,target,st_astext(pointgeom) as pointgeom from ch10.realroad WHERE ST_DWithin(the_geom ,GeometryFromText('point({0} {1})',4326), {2}) order by ST_Distance(the_geom,GeometryFromText('point({0} {1})',4326)) limit 1", lt, lg, ditMini); records = pg.QueryAdd("mini", strSQL); return records; }
public static List<string> GetAllTableFeatures(string layer,int begin,int last) { var pg = new PostGIS(); string sql = " set search_path = public, ch10;"+ "SELECT NAME,source,target,st_astext(pointgeom) as pointgeom, st_astext(the_geom) as geom FROM shortest_path('select st_astext(the_geom),gid as id,source::int4,target::int4,length::double precision as cost " + "from realtimeroad where passable <>0 '," + begin + "," + last + ",false,false) as sp ,realtimeroad as tc " +"where sp.edge_id=tc.gid; "; var records = pg.Query(layer, sql); return records; }