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
Hi Steve,
I added further necessary packages to Application:Geo:Postgres9PostGIS1:
libgeos, postgresql-libs and proj. This should fix all dependency
problems. Please test again and note that the repo provides packages for
SLE_11 and for SLE_11_SP1.
Regards
Otto
Am Wed, 4 Jan 2012 15:05:08 -0500
Short answer: not in SQL.
Longer answer: if your objects are sufficiently small you could use
the _ST_BestSRID approach (see the geography.sql definition for
ST_Buffer for example) and flip the geographies into planar space for
the test. It's still brute force, but with far simpler calculations.
Hello Otto,
I've installed from the packages for sles_11_sp1 and everything is fine
now.
Thank you so much for your support and quick answers
Best regards,
Steve
Otto Dassau @postgis.refractions.net
Envoyé par : postgis-users-boun...@postgis.refractions.net
2012-01-05 11:08
Veuillez répondre
Hello, I would like to create a custom projection which is essentially a
variation on the geographic coordinate system EPSG 4326, i have created
one and the srtext is "GEOGCS["Geographic Coordinate
System",DATUM["WGS84",SPHEROID["WGS84",6378137,298.257223560493]],PRIMEM["Greenwich",0],UNIT["degr