You can modify the function in anyway you see fit for your uses. That is reason you can create functions. The one I posted is very generic for any use while yours is very specific to your needs and the projection of your data.
I am glad the ellipse function was a help in your applications. Bruce Rindahl _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of franco califano Sent: Friday, June 15, 2007 11:45 AM To: [email protected] Subject: [postgis-users] Problem with ellipse function Thank you. This is the solution!! But, i think, the function ellipse is wrong. I modified it in this way: Ellipse (x,y,rx,ry,rotation,#of segments in 1/4 of ellipse) CREATE OR REPLACE FUNCTION Ellipse(double precision, double precision, double precision, double precision, double precision, integer) RETURNS geometry AS ' SELECT transform(translate(rotate(scale(buffer(transform(setsrid(makepoint(0,0),432 6),3395),1,$6),$3,$4),$5),x(transform(setsrid(makepoint($1,$2),4326),3395)), y(transform(setsrid(makepoint($1,$2),4326),3395))),4326) ' LANGUAGE 'sql'; where rx and ry are the (minor axis length)/2 and the (major axis length)/2 (in meters). What do you think about this? Thanks...... _____ _____ L'email della prossima generazione? Puoi averla con la nuova <http://us.rd.yahoo.com/mail/it/taglines/hotmail/nowyoucan/nextgen/*http:/it .docs.yahoo.com/nowyoucan.html> Yahoo! Mail
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
