Hi all,
I have a problem with spatial functions to a new custom schema.
I made a db, and following the PostGIS documentation I have created the
spatial extensions on it, but under the 'public' schema... How can I create
the spatial extensions on a custom schema?
Thanks a lot in advance
PS:
Hi, thanks for your answer but it is not my problem...
I have to create spatial functions under a schema called 'info', and If I
use psql -d myDb -f lwpostgis.sql, the spatial functions are created under
the schema 'public'!
How Can I make spatial function under schema 'info' ?
Thanks a lot in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
I am trying to use PostGIS 1.3.3 with PostgreSQL 8.3 on Windows XP SP2
and I am having stability problems.
The first problem I ran into is that calling buffer(the_geom,0) on an
invalid geometry causes the server to crash with a blown assertion
Mike,
PostGIS 1.3.3 has been pretty stable for me on Windows XP, Windows 2003 and Red
Hat EL Linux.
Though I can't say I have ever tried using disjoint since there are much more
efficient ways of checking for disjointedness than using disjoint. Buffer(..0)
I have used a fair amount though
OK, that's interesting, as Buffer is usually pretty tolerant of
invalidity... but not completely tolerant. Perhaps you can extract
just one case for us, since if it's happening on all your cases it's
probably the same issue every time.
P.
On Mon, Aug 11, 2008 at 1:46 PM, Bresnahan, Mike
[EMAIL
Hi List,
I need to convert geometry information to the GPS format:
0101202D61E81559FA0BD62541DA82728C04776241
to
lat: -2.9033 long:-79.138
Using PostGis functions like GeometryfromText thanks
___
postgis-users mailing list
David you can to use:
SELECT ASEWKT(the_geom)
or use:
SELECT x(the_geom), x(the_geom) ...
x is long and y is lat
2008/8/11 David Calle [EMAIL PROTECTED]
Hi List,
I need to convert geometry information to the GPS format:
0101202D61E81559FA0BD62541DA82728C04776241
to
lat:
Hi David,
Try this:
SELECT
'lat: ' || ST_Y(a.geometry) as Latitude,
'long: ' || ST_X(a.geometry) as Longitude
FROM (
SELECT ST_Transform(geometry,4326) AS geometry
FROM YOUR_TABLE
);
Dane
On Aug 11, 2008, at 2:24 PM, David Calle wrote:
Hi List,
I need to convert geometry
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
For any and all geometries, or do you have cases? (we love cases...)
I appended a test case to http://trac.osgeo.org/geos/ticket/187.
-BEGIN PGP SIGNATURE-
Version: PGP Universal 2.8.3
Charset: us-ascii