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. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
