Hi,
hny, my name is Peter. I'm new to the list, but working with PostGIS a
while.
Allow me to post you 2 functions, i wrote recently. These might be
useful to you or at least worth to integrate in postgis.sql at all.
The first calculate a point starting from a start point perpendicular to
a di
On Wed, Jan 04, 2012 at 07:07:16PM +0100, Peter Korduan wrote:
> Allow me to post you 2 functions, i wrote recently. These might be
> useful to you or at least worth to integrate in postgis.sql at all.
Peter, I suggest you write them to the postgis wiki
which contain other contributed functions.
Hi Peter,
you can enhance your functions with features from postgresql >=8.4:
+ overloading in one function
+ named parameter
SELECT transrotate( ordinate := 1, start_point := 'POINT( 11 52)' );
CREATE OR REPLACE FUNCTION transrotate
(
IN start_point geometry,
IN azimuth double
Also another comment for your transrotate function: you can use 1 call
to ST_Affine, rather than 3 indirect calls with
"st_rotate(st_translate(st_rotate(". You just need to wrangle the
trigonometry in the affine transformation matrix correctly.
I have an enhancement for a st_rotate with a point of
Am 09.01.2012 21:12, schrieb Mike Toews:
Also another comment for your transrotate function: you can use 1 call
to ST_Affine, rather than 3 indirect calls with
"st_rotate(st_translate(st_rotate(". You just need to wrangle the
trigonometry in the affine transformation matrix correctly.
I have an