Changes between Version 3 and Version 4 of BluePrintGIStools

Timestamp:

01/26/11 05:40:19 (14 years ago)

Author:

Nico Presto

Comment:

--

BluePrintGIStools

@@ -2 +2 @@
 
 * Centroid
+{{{
 select name, asText(Centroid(the_geom)) from table where name='location';
+}}}
 
 * Bounding boxes
+{{{
 select name, asText(Envelope(the_geom) from table where name='location';
 select name, extent(the_geom) from table where name = 'location' group by name;
-
+}}}
+ 
 * buffer calculations
 
 * Distance measurements
+{{{
 select distance(
 (transform(GeomFromText('Point(lon lat)'), 900913), 26915), 
 (transform(GeomFromText('Point(lon lat)'), 900913), 26915);
+}}} 
 
 * intersections
+{{{
 select name from location where
 GeomFromText('Point(lon lat)',900913)
 && the_geom AND
 within (GeomFromText('Point(lon lat)', 900913), the_geom);
+}}}
 
 * Point within polygon
+{{{
 select name from location where
 GeomFromText('Point(lon lat)', 900913)
 && the_geom;
+}}}
 
 * Spherical distance
+{{{
 select distance_sphere(
 (transform(GeomFromText('Point(lon lat)'), 900913), 
 (transform(GeomFromText('Point(lon lat)'), 900913);
+}}}
 
 * Spheroid distance
+{{{
 select distance_spheroid(
 (GeomFromText('Point(lon lat)'), 900913), 
 (GeomFromText('Point(lon lat)'), 900913),
 'SPHEROID["GRS 1980", 6378137, 298.257222101]');
-
+}}}