[postgis-users] Example queries - a compendium

Paul Ramsey pramsey at refractions.net
Wed Jul 11 16:36:00 PDT 2007

Shaun Kolomeitz wrote:
> Dear PostGIS'ers,
> Has anyone got a reference for, or created for themselves a compendium
> of useful examples of SQL GIS type queries ?
> I'm looking for a good smattering of examples covering a range of
> feature types (points, lines, poly's) and the sorts of spatial
> operations one is likely to require (from basic/simple to intermediate
> and advanced involving complex joins). It would be nice if this could
> cover simple reading of features, creation, through to advanced updating
> techniques for features.
> I've seen a few examples included with the PostGIS Manual as well as
> some HTML type help that comes with PostGresQL's install of PostGIS.
> These help, but don't seem to go far enough.
> Any pointers most appreciated.
> As a quid-pro-quo I'd re-distribute back to the group a summary.
> Kind regards,
> Shaun
> ___________________________
> Disclaimer
> WARNING: This e-mail (including any attachments) has originated from a Queensland Government department and may contain information that is confidential, private, or covered by legal professional privilege, and may be protected by copyright.  
> You may use this e-mail only if you are the person(s) it was intended to be sent to and if you use it in an authorised way.  No one is allowed to use, review, alter, transmit, disclose, distribute, print or copy this e-mail without appropriate authority.  If you have received this e-mail in error, please inform the sender immediately by phone or e-mail and delete this e-mail, including any copies, from your computer system network and destroy any hardcopies.
> Unless otherwise stated, this e-mail represents the views of the sender and not the views of the Environmental Protection Agency.
> Although this e-mail has been checked for the presence of computer viruses, the Environmental Protection Agency provides no warranty that all viruses have been detected and cleaned. Any use of this e-mail could harm your computer system.  It is your responsibility to ensure that this e-mail does not contain and is not affected by computer viruses, defects or interference by third parties or replication problems (including incompatibility with your computer system).
> E-mails sent to and from the Environmental Protection Agency will be electronically stored, managed and may be audited, in accordance with the law and Queensland Government Information Standards (IS31, IS38, IS40, IS41 and IS42) to the extent they are consistent with the law.
> ___________________________
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


   Paul Ramsey
   Refractions Research
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: PostGIS.txt
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070711/b3ccc857/attachment.txt>

More information about the postgis-users mailing list