[postgis-users] select point in linestring
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
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