Changeset 27

Timestamp:

08/17/07 16:00:22 (1 year ago)

Author:

anton

Message:

assign_vertex_id: source_id changed to source, target_id changed to target

Files:

• trunk/routing_wrappers.sql (modified) (4 diffs)

trunk/routing_wrappers.sql

@@ -26 +26 @@
--- Geometry schema description:
--- gid
-_id
-_id
+
+
--- edge_id
-
@@ -57 +57 @@
-                ' SET the_geom = startPoint(geometryn(m.the_geom, 1)) FROM ' ||
-                 quote_ident(geom_table) || 
-_id
+
-
-        EXECUTE 'UPDATE ' || quote_ident(vertices_table) || 
-                ' set the_geom = endPoint(geometryn(m.the_geom, 1)) FROM ' || 
-                quote_ident(geom_table) || 
-_id
+
-                quote_ident(vertices_table) || 
-                '.the_geom IS NULL';
@@ -106 +106 @@
-
------------------------------------------------------------------------
-_id and target_id
+ and target
---  with a distance less than tolerance, are assigned the same id
------------------------------------------------------------------------
@@ -164 +164 @@
-                                                                                                                                                                                                                                        
-                                EXECUTE 'update ' || quote_ident(geom_table) || 
-_id
-_id
+
+
-                                    ' WHERE ' || quote_ident(gid_cname) || ' =  ' || points.id;
-                END LOOP;