[postgis-users] Query to select features that are parallel and perpendicular

[Sandro Santilli]

On Mon, Feb 06, 2012 at 01:45:27PM +0200, Sindile Bidla wrote:
> Anyone who can offer advice on on building a query to accomplish the
> following within the same line feature - roads:
> 
> 1. create a new table or view of all line features that are parallel to a
> selected line feature within the same line feature
> 
> 2. create a new table or view of all line features that
> are perpendicular to a selected line feature within the same line feature

Check out ST_Azimuth 

--strk;

  ,------o-. 
  |   __/  |    Thank you for PostGIS-2.0 Topology !
  |  / 2.0 |    http://www.pledgebank.com/postgistopology
  `-o------'