Hi,
Not a question but a tip. How to draw faster faces in a box:.
The first methode (very slow):
SELECT st_AsBinary(st_GetFaceGeometry('topocommune',element_id)) AS
poly, topogeo_id FROM topocommune.relation WHERE ((layer_id=:lid) AND
(st_GetFaceGeometry('topocommune',element_id) && st_LineFromText(:rg," &
SRID & ")));
The second way, faster
SELECT st_AsBinary(st_GetFaceGeometry('topocommune',face_id)) FROM
topocommune.face,topocommune.relation WHERE mbr && st_linefromtext(:rg,"
& SRID & ") AND layer_id=:lid AND face_id=element_id;
Hope it will help
Christophe
:
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users