Changes between Version 23 and Version 24 of CookBook Postgis

Timestamp:

Feb 9, 2010 2:22:34 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook Postgis

@@ -46 +46 @@
  * Min()
  * Distance()
+
+Reprojecting / snapping point-geometries onto a given line-geometry using PostGIS
+http://62.160.92.241:8066/trac/wiki/CookBook%20Postgis?action=edit
+{{{
+SELECT ST_Line_Interpolate_Point(
+                line_to_project_onto.the_geom,
+                ST_Line_Locate_Point(
+                        line_to_project_onto.the_geom,
+                        points_to_project_onto_line.the_geom
+                )
+        )
+FROM line_to_project_onto, points_to_project_onto_line;
+}}}
+which translates into
+{{{
+{{{
+SELECT ST_Line_Interpolate_Point(
+                line_to_project_onto.the_geom,
+                ST_Line_Locate_Point(
+                        line_to_project_onto.the_geom,
+                        points_to_project_onto_line.the_geom
+                )
+        )
+FROM line_to_project_onto, points_to_project_onto_line;
+}}}
+}}}