[postgis-users] select point in linestring

searchelite searchelite at gmail.com
Fri Jan 30 01:34:32 PST 2009


Sorry if my question is confusing. Yes, my problem is almost the same as the
case 1). 

Thank you very much for your help, i really appreciate it 




Paragon Corporation-2 wrote:
> 
> Oops correction.
> 
> For 1) ST_Dump doesn't work.  We need an ST_DumpPoints for that which
> doesn't exist.
> 
> So instead 
> 
> SELECT P.gid,  P.geom As pclosest
> FROM (SELECT gid, ST_PointN(the_geom, generate_series(1,
> ST_NPoints(the_geom))) As geom
> 		FROM point_table) As P
> WHERE ST_Dwithin(P.geom, ST_SetSRID(ST_MakePoint(lon,lat),somesrid), 0.01)
> 
> 

-- 
View this message in context: http://www.nabble.com/select-point-in-linestring-tp21741396p21743834.html
Sent from the PostGIS - User mailing list archive at Nabble.com.




More information about the postgis-users mailing list