Changes between Version 3 and Version 4 of BluePrintGIStools


Ignore:
Timestamp:
01/26/11 05:40:19 (11 years ago)
Author:
Nico Presto
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • BluePrintGIStools

    v3 v4  
    22
    33* Centroid
     4{{{
    45select name, asText(Centroid(the_geom)) from table where name='location';
     6}}}
    57
    68* Bounding boxes
     9{{{
    710select name, asText(Envelope(the_geom) from table where name='location';
    811select name, extent(the_geom) from table where name = 'location' group by name;
    9 
     12}}}
     13 
    1014* buffer calculations
    1115
    1216* Distance measurements
     17{{{
    1318select distance(
    1419(transform(GeomFromText('Point(lon lat)'), 900913), 26915),
    1520(transform(GeomFromText('Point(lon lat)'), 900913), 26915);
     21}}}
    1622
    1723* intersections
     24{{{
    1825select name from location where
    1926GeomFromText('Point(lon lat)',900913)
    2027&& the_geom AND
    2128within (GeomFromText('Point(lon lat)', 900913), the_geom);
     29}}}
    2230
    2331* Point within polygon
     32{{{
    2433select name from location where
    2534GeomFromText('Point(lon lat)', 900913)
    2635&& the_geom;
     36}}}
    2737
    2838* Spherical distance
     39{{{
    2940select distance_sphere(
    3041(transform(GeomFromText('Point(lon lat)'), 900913),
    3142(transform(GeomFromText('Point(lon lat)'), 900913);
     43}}}
    3244
    3345* Spheroid distance
     46{{{
    3447select distance_spheroid(
    3548(GeomFromText('Point(lon lat)'), 900913),
    3649(GeomFromText('Point(lon lat)'), 900913),
    3750'SPHEROID["GRS 1980", 6378137, 298.257222101]');
    38 
     51}}}