[postgis-users] Finding extra points

[Sandro Santilli]

On Thu, Oct 25, 2012 at 07:15:20AM -0400, Jeff Lake wrote:
> Greetings..
> Is there a function or combination of functions in postGIS-2 that
> will help calculate
> points in between 2 given.
> 
> I have imported a point shape file containing the National Hurricane
> Center's Watch/Warning breakpoints
> when they issue the warnings it contains at least 2 locations from
> this shape file.
> 
> is there a way to calculate what points from the shape file would be
> in between the 2 given??

You could draw a line between the two points and find the points which 
are within a given distance from them. See ST_MakeLine and ST_DWithin.

--strk;

 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net