Good day, I have a line table (id, the_geom, elevation) (around 500mb) with contour lines in it. Some of the contour lines are really big (lots of vertices and large area) which results in a very big bbox so they are always fetched when I make a query of a specific region which increases select time dramatically.
a) Is there a way to split a linestrings into smaller segments with N length and keeping the elevation value ? b) If "a" is a very complicated SQL query can someone help with spliting the linestring at each node into new row keeping the elevation attribute ? -- http://iap.md, The future is open
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
