Wasn't PostGIS 2.0 supposed to support GIN indexes?
Seems like there was talk of that many moons ago, but I don't see anything
about GIN in the 2.0 documentation.
Aren
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.r
Hi David,
Do you have a "rid" column in your table with unique values?
Pierre
> -Original Message-
> From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-
> boun...@postgis.refractions.net] On Behalf Of David B?langer
> Sent: Thursday, May 17, 2012 8:13 PM
> To: post
Hi George,
Glad I could help. I also learned a lot with this case.
The "with recursive" queries are really powerful to process data.
You could also use a plpgsql function to achieve the same result. It offers a
great amount of control to process data.
Regarding the SQL code I use, I'm wondering
Try something like this:
SELECT ST_AsEWKT(ST_PointN(ST_OffsetCurve(line1,5),ST_NPoints(line1))) as
offset_point,
ST_AsEWKT(ST_PointN(line1,ST_NPoints(line1))) as
point_10m_on_line
FROM (SELECT ST_GeometryN(ST_Split(the_line,
ST_Li
Hello,
A question: I have a linestring (polyline) for which i would like to
calculate a point which is located on the polyline but a specific distance
from the end or beggining of the polyline. Once this point is calculated i
would then like to calculate 2 points on both sides of the linestring
Hi Nicolas, this is it! it works beautifully. I even tried it with the full
set of contours and it all makes sense.
The truth is for me your help has been more than a solution, it has also
been a great tutorial on Postgis, I hope others will find it as useful.
Thanks a lot for your continuing help
