<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE>.hmmessage P {
PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px
}
BODY.hmmessage {
FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
}
</STYLE>
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY class=hmmessage>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff>Eehab,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff>Unfortunately I don't think there is. If you are just
talking about points, then one work around that comes to mind is to use
ST_Length3D - something like below</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff>SELECT ST_length3d(ST_MakeLine('POINT(1 2 3)', 'POINT(4 5 6)') )As
d3, <BR>ST_Length2d(ST_MakeLine('POINT(1 2)', 'POINT(4 5)')) as
d2;</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff>So in your case </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008>SELECT
asKml("FireFighterO".the_geom) FROM "FireFighterO" , igfplan </SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008>WHERE igfplan.id=2 AND
ST_DWithin("FireFighterO".the_geom, igfplan.the_geom, 120) AND<BR>AND
ST_Length3d(ST_MakeLine("FireFighterO".the_geom, igfplan.the_geom)) <
120;</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff>The ST_DWithin is to force the use of indexes because your current
query as it was written will not use indexes. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff>True ST_DWithin will only use the 2d distance, but its my
assumption that if the 2D distance is not within 120, then the 3D definitely
will not be either.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=509154412-12082008><FONT face=Arial
color=#0000ff>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>eehab
hamzeh<BR><B>Sent:</B> Tuesday, August 12, 2008 8:35 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] Select
Distance in 3d<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV style="TEXT-ALIGN: left">Hello, <BR><BR>I need to select the points that
are within 3d distance not just only in 2d distance. is there is anything for 3d
distance like 3d extent or 3d box.<BR>below is my query.<BR><BR></DIV>SELECT
asKml("FireFighterO".the_geom) FROM "FireFighterO" , igfplan WHERE
igfplan.id=2<BR>AND distance("FireFighterO".the_geom, igfplan.the_geom) <
120<BR><BR>Thanks<BR><BR><BR><BR>
<HR id=stopSpelling>
> From: postgis-users-request@postgis.refractions.net<BR>> Subject:
postgis-users Digest, Vol 70, Issue 9<BR>> To:
postgis-users@postgis.refractions.net<BR>> Date: Mon, 11 Aug 2008 12:01:19
-0700<BR>> <BR>> Send postgis-users mailing list submissions to<BR>>
postgis-users@postgis.refractions.net<BR>> <BR>> To subscribe or
unsubscribe via the World Wide Web, visit<BR>>
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> or, via
email, send a message with subject or body 'help' to<BR>>
postgis-users-request@postgis.refractions.net<BR>> <BR>> You can reach the
person managing the list at<BR>>
postgis-users-owner@postgis.refractions.net<BR>> <BR>> When replying,
please edit your Subject line so it is more specific<BR>> than "Re: Contents
of postgis-users digest..."<BR>> <BR>> <BR>> Today's Topics:<BR>>
<BR>> 1. How to add spatial functions to a custom schema (gimbrogno)<BR>>
2. RE: How to add spatial functions to a custom schema<BR>> (Mark
Lidstone)<BR>> 3. RE: How to add spatial functions to a custom schema
(gimbrogno)<BR>> 4. RE: How to add spatial functions to a custom schema (Obe,
Regina)<BR>> 5. RE: How to add spatial functions to a custom schema
(gimbrogno)<BR>> 6. PostGIS 1.3.3 on Windows XP Unstable (Bresnahan,
Mike)<BR>> 7. RE: PostGIS 1.3.3 on Windows XP Unstable (Obe, Regina)<BR>>
8. Re: PostGIS 1.3.3 on Windows XP Unstable (Paul Ramsey)<BR>> <BR>>
<BR>>
----------------------------------------------------------------------<BR>>
<BR>> Message: 1<BR>> Date: Mon, 11 Aug 2008 04:34:08 -0700 (PDT)<BR>>
From: gimbrogno <magnitudo9@email.it><BR>> Subject: [postgis-users] How
to add spatial functions to a custom<BR>> schema<BR>> To:
postgis-users@postgis.refractions.net<BR>> Message-ID:
<18923897.post@talk.nabble.com><BR>> Content-Type: text/plain;
charset=us-ascii<BR>> <BR>> <BR>> Hi all,<BR>> <BR>> I have a
problem with spatial functions to a new custom schema.<BR>> <BR>> I made a
db, and following the PostGIS documentation I have created the<BR>> spatial
extensions on it, but under the 'public' schema... How can I create<BR>> the
spatial extensions on a custom schema?<BR>> <BR>> Thanks a lot in
advance<BR>> <BR>> PS: English is not my native language, so excuse me for
errors...<BR>> -- <BR>> View this message in context:
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp18923897p18923897.html<BR>>
Sent from the PostGIS - User mailing list archive at Nabble.com.<BR>>
<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>>
Message: 2<BR>> Date: Mon, 11 Aug 2008 12:39:36 +0100<BR>> From: "Mark
Lidstone" <Mark.Lidstone@bmtcordah.com><BR>> Subject: RE:
[postgis-users] How to add spatial functions to a custom<BR>> schema<BR>>
To: "PostGIS Users Discussion"
<postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>>
<355510E97AD99D4181D67084193C0DAF3241F9@so-ex-02.bmt.cordah.com><BR>>
Content-Type: text/plain; charset="us-ascii"<BR>> <BR>> Hi
Gimborgno,<BR>> <BR>> I think all you need to do is add the schema name as
the first argument<BR>> to the AddGeometryColumn procedure. E.g.
replace:<BR>> <BR>> SELECT AddGeometryColumn('table', 'field', 4326,
'POINT', 2);<BR>> <BR>> with:<BR>> <BR>> SELECT
AddGeometryColumn('new_schema', 'table', 'field', 4326, 'POINT',<BR>>
2);<BR>> <BR>> Thanks,<BR>> <BR>> Mark Lidstone<BR>> Tel: +44
(0)23 80232222; Fax: +44 (0)23 80232891<BR>> <BR>> BMT Cordah Ltd <BR>>
Grove House<BR>> 7 Ocean Way<BR>> Ocean Village<BR>>
Southampton<BR>> SO14 3TJ<BR>> <BR>> <BR>> -----Original
Message-----<BR>> From: postgis-users-bounces@postgis.refractions.net<BR>>
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of<BR>>
gimbrogno<BR>> Sent: 11 August 2008 12:34<BR>> To:
postgis-users@postgis.refractions.net<BR>> Subject: [postgis-users] How to
add spatial functions to a custom schema<BR>> <BR>> <BR>> Hi
all,<BR>> <BR>> I have a problem with spatial functions to a new custom
schema.<BR>> <BR>> I made a db, and following the PostGIS documentation I
have created the<BR>> spatial extensions on it, but under the 'public'
schema... How can I<BR>> create the spatial extensions on a custom
schema?<BR>> <BR>> Thanks a lot in advance<BR>> <BR>> PS: English is
not my native language, so excuse me for errors...<BR>> --<BR>> View this
message in context:<BR>>
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp<BR>>
18923897p18923897.html<BR>> Sent from the PostGIS - User mailing list archive
at Nabble.com.<BR>> <BR>>
_______________________________________________<BR>> postgis-users mailing
list<BR>> postgis-users@postgis.refractions.net<BR>>
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> <BR>>
<BR>> BMT Cordah Ltd.<BR>> A member of the BMT group of companies<BR>>
Registered Office: Investment House, 6 Union Row, Aberdeen AB10 1DQ<BR>>
Registered in Scotland No. 163413<BR>> http://www.bmtcordah.com/<BR>>
http://www.bmt.org/<BR>> <BR>> The contents of this e-mail and any
attachments are intended only for the use of the e-mail addressee(s) shown. If
you are not that person, or one of those persons, you are not allowed to take
any action based upon it or to copy it, forward, distribute or disclose the
contents of it and you should please delete it from your system. BMT Cordah
Limited does not accept liability for any errors or omissions in the context of
this e-mail or its attachments, which arise as a result of Internet
transmission, nor accept liability for statements which are those of the author
and not clearly made on behalf of BMT Cordah Limited.<BR>> <BR>> <BR>>
<BR>> ------------------------------<BR>> <BR>> Message: 3<BR>>
Date: Mon, 11 Aug 2008 04:50:44 -0700 (PDT)<BR>> From: gimbrogno
<magnitudo9@email.it><BR>> Subject: RE: [postgis-users] How to add
spatial functions to a custom<BR>> schema<BR>> To:
postgis-users@postgis.refractions.net<BR>> Message-ID:
<18924157.post@talk.nabble.com><BR>> Content-Type: text/plain;
charset=us-ascii<BR>> <BR>> <BR>> Hi, thanks for your answer but it is
not my problem...<BR>> <BR>> I have to create spatial functions under a
schema called 'info', and If I<BR>> use psql -d myDb -f lwpostgis.sql, the
spatial functions are created under<BR>> the schema 'public'!<BR>>
<BR>> How Can I make spatial function under schema 'info' ?<BR>> <BR>>
Thanks a lot in advance...<BR>> <BR>> Mark Lidstone wrote:<BR>> >
<BR>> > Hi Gimborgno,<BR>> > <BR>> > I think all you need to
do is add the schema name as the first argument<BR>> > to the
AddGeometryColumn procedure. E.g. replace:<BR>> > <BR>> > SELECT
AddGeometryColumn('table', 'field', 4326, 'POINT', 2);<BR>> > <BR>>
> with:<BR>> > <BR>> > SELECT AddGeometryColumn('new_schema',
'table', 'field', 4326, 'POINT',<BR>> > 2);<BR>> > <BR>> >
Thanks,<BR>> > <BR>> > Mark Lidstone<BR>> > Tel: +44 (0)23
80232222; Fax: +44 (0)23 80232891<BR>> > <BR>> > BMT Cordah Ltd
<BR>> > Grove House<BR>> > 7 Ocean Way<BR>> > Ocean
Village<BR>> > Southampton<BR>> > SO14 3TJ<BR>> > <BR>>
> <BR>> > -----Original Message-----<BR>> > From:
postgis-users-bounces@postgis.refractions.net<BR>> >
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of<BR>> >
gimbrogno<BR>> > Sent: 11 August 2008 12:34<BR>> > To:
postgis-users@postgis.refractions.net<BR>> > Subject: [postgis-users] How
to add spatial functions to a custom schema<BR>> > <BR>> > <BR>>
> Hi all,<BR>> > <BR>> > I have a problem with spatial functions
to a new custom schema.<BR>> > <BR>> > I made a db, and following
the PostGIS documentation I have created the<BR>> > spatial extensions on
it, but under the 'public' schema... How can I<BR>> > create the spatial
extensions on a custom schema?<BR>> > <BR>> > Thanks a lot in
advance<BR>> > <BR>> > PS: English is not my native language, so
excuse me for errors...<BR>> > --<BR>> > View this message in
context:<BR>> >
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp<BR>>
> 18923897p18923897.html<BR>> > Sent from the PostGIS - User mailing
list archive at Nabble.com.<BR>> > <BR>> >
_______________________________________________<BR>> > postgis-users
mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> >
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> >
<BR>> > <BR>> > BMT Cordah Ltd.<BR>> > A member of the BMT
group of companies<BR>> > Registered Office: Investment House, 6 Union
Row, Aberdeen AB10 1DQ<BR>> > Registered in Scotland No. 163413<BR>>
> http://www.bmtcordah.com/<BR>> > http://www.bmt.org/<BR>> >
<BR>> > The contents of this e-mail and any attachments are intended only
for the<BR>> > use of the e-mail addressee(s) shown. If you are not that
person, or one<BR>> > of those persons, you are not allowed to take any
action based upon it or<BR>> > to copy it, forward, distribute or disclose
the contents of it and you<BR>> > should please delete it from your
system. BMT Cordah Limited does not<BR>> > accept liability for any errors
or omissions in the context of this e-mail<BR>> > or its attachments,
which arise as a result of Internet transmission, nor<BR>> > accept
liability for statements which are those of the author and not<BR>> >
clearly made on behalf of BMT Cordah Limited.<BR>> > <BR>> >
_______________________________________________<BR>> > postgis-users
mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> >
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> >
<BR>> > <BR>> <BR>> -- <BR>> View this message in context:
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp18923897p18924157.html<BR>>
Sent from the PostGIS - User mailing list archive at Nabble.com.<BR>>
<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>>
Message: 4<BR>> Date: Mon, 11 Aug 2008 08:16:23 -0400<BR>> From: "Obe,
Regina" <robe.dnd@cityofboston.gov><BR>> Subject: RE: [postgis-users]
How to add spatial functions to a custom<BR>> schema<BR>> To: "PostGIS
Users Discussion" <postgis-users@postgis.refractions.net><BR>>
Message-ID:<BR>>
<53F9CF533E1AA14EA1F8C5C08ABC08D204889D3A@ZDND.DND.boston.cob><BR>>
Content-Type: text/plain; charset="us-ascii"<BR>> <BR>> Gimbrogno,<BR>>
Do the following before running the .sql files.<BR>> <BR>> SET search_path
= info;<BR>> <BR>> Keep in mind that you should really only have those
functions and table<BR>> loaded in one schema not all of them even if you
have your tables in<BR>> different schemas. The functions and tables should
exist only once per<BR>> database.<BR>> <BR>> You will also want to add
the info schema to your database search path,<BR>> otherwise many things and
software that works with PostGIS will not work<BR>> since they don't prefix
the schema name.<BR>> <BR>> So to do that you would do something like
this<BR>> <BR>> ALTER DATABASE your_database_name_here SET
search_path="$user", public,<BR>> info;<BR>> <BR>> <BR>> Hope that
helps,<BR>> Regina<BR>> <BR>> <BR>> -----Original
Message-----<BR>> From: postgis-users-bounces@postgis.refractions.net<BR>>
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of<BR>>
gimbrogno<BR>> Sent: Monday, August 11, 2008 7:51 AM<BR>> To:
postgis-users@postgis.refractions.net<BR>> Subject: RE: [postgis-users] How
to add spatial functions to a custom<BR>> schema<BR>> <BR>> <BR>>
Hi, thanks for your answer but it is not my problem...<BR>> <BR>> I have
to create spatial functions under a schema called 'info', and If<BR>>
I<BR>> use psql -d myDb -f lwpostgis.sql, the spatial functions are
created<BR>> under<BR>> the schema 'public'!<BR>> <BR>> How Can I
make spatial function under schema 'info' ?<BR>> <BR>> Thanks a lot in
advance...<BR>> <BR>> Mark Lidstone wrote:<BR>> > <BR>> > Hi
Gimborgno,<BR>> > <BR>> > I think all you need to do is add the
schema name as the first<BR>> argument<BR>> > to the AddGeometryColumn
procedure. E.g. replace:<BR>> > <BR>> > SELECT
AddGeometryColumn('table', 'field', 4326, 'POINT', 2);<BR>> > <BR>>
> with:<BR>> > <BR>> > SELECT AddGeometryColumn('new_schema',
'table', 'field', 4326,<BR>> 'POINT',<BR>> > 2);<BR>> > <BR>>
> Thanks,<BR>> > <BR>> > Mark Lidstone<BR>> > Tel: +44
(0)23 80232222; Fax: +44 (0)23 80232891<BR>> > <BR>> > BMT Cordah
Ltd <BR>> > Grove House<BR>> > 7 Ocean Way<BR>> > Ocean
Village<BR>> > Southampton<BR>> > SO14 3TJ<BR>> > <BR>>
> <BR>> > -----Original Message-----<BR>> > From:
postgis-users-bounces@postgis.refractions.net<BR>> >
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of<BR>> >
gimbrogno<BR>> > Sent: 11 August 2008 12:34<BR>> > To:
postgis-users@postgis.refractions.net<BR>> > Subject: [postgis-users] How
to add spatial functions to a custom<BR>> schema<BR>> > <BR>> >
<BR>> > Hi all,<BR>> > <BR>> > I have a problem with spatial
functions to a new custom schema.<BR>> > <BR>> > I made a db, and
following the PostGIS documentation I have created<BR>> the<BR>> >
spatial extensions on it, but under the 'public' schema... How can I<BR>>
> create the spatial extensions on a custom schema?<BR>> > <BR>>
> Thanks a lot in advance<BR>> > <BR>> > PS: English is not my
native language, so excuse me for errors...<BR>> > --<BR>> > View
this message in context:<BR>> ><BR>>
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp<BR>>
> 18923897p18923897.html<BR>> > Sent from the PostGIS - User mailing
list archive at Nabble.com.<BR>> > <BR>> >
_______________________________________________<BR>> > postgis-users
mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> >
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> >
<BR>> > <BR>> > BMT Cordah Ltd.<BR>> > A member of the BMT
group of companies<BR>> > Registered Office: Investment House, 6 Union
Row, Aberdeen AB10 1DQ<BR>> > Registered in Scotland No. 163413<BR>>
> http://www.bmtcordah.com/<BR>> > http://www.bmt.org/<BR>> >
<BR>> > The contents of this e-mail and any attachments are intended only
for<BR>> the<BR>> > use of the e-mail addressee(s) shown. If you are
not that person, or<BR>> one<BR>> > of those persons, you are not
allowed to take any action based upon it<BR>> or<BR>> > to copy it,
forward, distribute or disclose the contents of it and you<BR>> > should
please delete it from your system. BMT Cordah Limited does not<BR>> >
accept liability for any errors or omissions in the context of this<BR>>
e-mail<BR>> > or its attachments, which arise as a result of Internet
transmission,<BR>> nor<BR>> > accept liability for statements which are
those of the author and not<BR>> > clearly made on behalf of BMT Cordah
Limited.<BR>> > <BR>> >
_______________________________________________<BR>> > postgis-users
mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> >
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> >
<BR>> > <BR>> <BR>> -- <BR>> View this message in
context:<BR>>
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp<BR>>
18923897p18924157.html<BR>> Sent from the PostGIS - User mailing list archive
at Nabble.com.<BR>> <BR>>
_______________________________________________<BR>> postgis-users mailing
list<BR>> postgis-users@postgis.refractions.net<BR>>
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>>
-----------------------------------------<BR>> The substance of this message,
including any attachments, may be<BR>> confidential, legally privileged
and/or exempt from disclosure<BR>> pursuant to Massachusetts law. It is
intended<BR>> solely for the addressee. If you received this in error,
please<BR>> contact the sender and delete the material from any
computer.<BR>> <BR>> <BR>> <BR>>
------------------------------<BR>> <BR>> Message: 5<BR>> Date: Mon, 11
Aug 2008 06:24:20 -0700 (PDT)<BR>> From: gimbrogno
<magnitudo9@email.it><BR>> Subject: RE: [postgis-users] How to add
spatial functions to a custom<BR>> schema<BR>> To:
postgis-users@postgis.refractions.net<BR>> Message-ID:
<18925804.post@talk.nabble.com><BR>> Content-Type: text/plain;
charset=us-ascii<BR>> <BR>> <BR>> Thanks a lot... now it goes!<BR>>
<BR>> <BR>> <BR>> Obe, Regina DND\MIS wrote:<BR>> > <BR>> >
Gimbrogno,<BR>> > Do the following before running the .sql files.<BR>>
> <BR>> > SET search_path = info;<BR>> > <BR>> > Keep in
mind that you should really only have those functions and table<BR>> >
loaded in one schema not all of them even if you have your tables in<BR>>
> different schemas. The functions and tables should exist only once
per<BR>> > database.<BR>> > <BR>> > You will also want to add
the info schema to your database search path,<BR>> > otherwise many things
and software that works with PostGIS will not work<BR>> > since they don't
prefix the schema name.<BR>> > <BR>> > So to do that you would do
something like this<BR>> > <BR>> > ALTER DATABASE
your_database_name_here SET search_path="$user", public,<BR>> >
info;<BR>> > <BR>> > <BR>> > Hope that helps,<BR>> >
Regina<BR>> > <BR>> > <BR>> > -----Original
Message-----<BR>> > From:
postgis-users-bounces@postgis.refractions.net<BR>> >
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of<BR>> >
gimbrogno<BR>> > Sent: Monday, August 11, 2008 7:51 AM<BR>> > To:
postgis-users@postgis.refractions.net<BR>> > Subject: RE: [postgis-users]
How to add spatial functions to a custom<BR>> > schema<BR>> >
<BR>> > <BR>> > Hi, thanks for your answer but it is not my
problem...<BR>> > <BR>> > I have to create spatial functions under a
schema called 'info', and If<BR>> > I<BR>> > use psql -d myDb -f
lwpostgis.sql, the spatial functions are created<BR>> > under<BR>> >
the schema 'public'!<BR>> > <BR>> > How Can I make spatial function
under schema 'info' ?<BR>> > <BR>> > Thanks a lot in
advance...<BR>> > <BR>> > Mark Lidstone wrote:<BR>> >>
<BR>> >> Hi Gimborgno,<BR>> >> <BR>> >> I think all
you need to do is add the schema name as the first<BR>> > argument<BR>>
>> to the AddGeometryColumn procedure. E.g. replace:<BR>> >>
<BR>> >> SELECT AddGeometryColumn('table', 'field', 4326, 'POINT',
2);<BR>> >> <BR>> >> with:<BR>> >> <BR>> >>
SELECT AddGeometryColumn('new_schema', 'table', 'field', 4326,<BR>> >
'POINT',<BR>> >> 2);<BR>> >> <BR>> >> Thanks,<BR>>
>> <BR>> >> Mark Lidstone<BR>> >> Tel: +44 (0)23
80232222; Fax: +44 (0)23 80232891<BR>> >> <BR>> >> BMT Cordah
Ltd <BR>> >> Grove House<BR>> >> 7 Ocean Way<BR>> >>
Ocean Village<BR>> >> Southampton<BR>> >> SO14 3TJ<BR>>
>> <BR>> >> <BR>> >> -----Original Message-----<BR>>
>> From: postgis-users-bounces@postgis.refractions.net<BR>> >>
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of<BR>>
>> gimbrogno<BR>> >> Sent: 11 August 2008 12:34<BR>> >>
To: postgis-users@postgis.refractions.net<BR>> >> Subject:
[postgis-users] How to add spatial functions to a custom<BR>> >
schema<BR>> >> <BR>> >> <BR>> >> Hi all,<BR>>
>> <BR>> >> I have a problem with spatial functions to a new
custom schema.<BR>> >> <BR>> >> I made a db, and following the
PostGIS documentation I have created<BR>> > the<BR>> >> spatial
extensions on it, but under the 'public' schema... How can I<BR>> >>
create the spatial extensions on a custom schema?<BR>> >> <BR>>
>> Thanks a lot in advance<BR>> >> <BR>> >> PS: English
is not my native language, so excuse me for errors...<BR>> >>
--<BR>> >> View this message in context:<BR>> >><BR>> >
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp<BR>>
>> 18923897p18923897.html<BR>> >> Sent from the PostGIS - User
mailing list archive at Nabble.com.<BR>> >> <BR>> >>
_______________________________________________<BR>> >> postgis-users
mailing list<BR>> >> postgis-users@postgis.refractions.net<BR>>
>> http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>>
>> <BR>> >> <BR>> >> BMT Cordah Ltd.<BR>> >> A
member of the BMT group of companies<BR>> >> Registered Office:
Investment House, 6 Union Row, Aberdeen AB10 1DQ<BR>> >> Registered in
Scotland No. 163413<BR>> >> http://www.bmtcordah.com/<BR>> >>
http://www.bmt.org/<BR>> >> <BR>> >> The contents of this
e-mail and any attachments are intended only for<BR>> > the<BR>>
>> use of the e-mail addressee(s) shown. If you are not that person,
or<BR>> > one<BR>> >> of those persons, you are not allowed to
take any action based upon it<BR>> > or<BR>> >> to copy it,
forward, distribute or disclose the contents of it and you<BR>> >>
should please delete it from your system. BMT Cordah Limited does not<BR>>
>> accept liability for any errors or omissions in the context of
this<BR>> > e-mail<BR>> >> or its attachments, which arise as a
result of Internet transmission,<BR>> > nor<BR>> >> accept
liability for statements which are those of the author and not<BR>> >>
clearly made on behalf of BMT Cordah Limited.<BR>> >> <BR>> >>
_______________________________________________<BR>> >> postgis-users
mailing list<BR>> >> postgis-users@postgis.refractions.net<BR>>
>> http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>>
>> <BR>> >> <BR>> > <BR>> > -- <BR>> > View
this message in context:<BR>> >
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp<BR>>
> 18923897p18924157.html<BR>> > Sent from the PostGIS - User mailing
list archive at Nabble.com.<BR>> > <BR>> >
_______________________________________________<BR>> > postgis-users
mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> >
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> >
-----------------------------------------<BR>> > The substance of this
message, including any attachments, may be<BR>> > confidential, legally
privileged and/or exempt from disclosure<BR>> > pursuant to Massachusetts
law. It is intended<BR>> > solely for the addressee. If you received this
in error, please<BR>> > contact the sender and delete the material from
any computer.<BR>> > <BR>> >
_______________________________________________<BR>> > postgis-users
mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> >
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> >
<BR>> > <BR>> <BR>> -- <BR>> View this message in context:
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp18923897p18925804.html<BR>>
Sent from the PostGIS - User mailing list archive at Nabble.com.<BR>>
<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>>
Message: 6<BR>> Date: Mon, 11 Aug 2008 12:02:27 -0500<BR>> From:
"Bresnahan, Mike" <Mike.Bresnahan@bestbuy.com><BR>> Subject:
[postgis-users] PostGIS 1.3.3 on Windows XP Unstable<BR>> To:
<postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>>
<C8BE5909BAD8A043BC47D6BB886E1384019EA76C@dsp66mail.na.bestbuy.com><BR>>
Content-Type: text/plain; charset="us-ascii"<BR>> <BR>> -----BEGIN PGP
SIGNED MESSAGE-----<BR>> Hash: SHA256<BR>> <BR>> I am trying to use
PostGIS 1.3.3 with PostgreSQL 8.3 on Windows XP SP2<BR>> and I am having
stability problems. <BR>> <BR>> The first problem I ran into is that
calling buffer(the_geom,0) on an<BR>> invalid geometry causes the server to
crash with a blown assertion<BR>> ("pts->size() > 1"). This problem was
reported here:<BR>> <BR>> http://trac.osgeo.org/geos/ticket/187<BR>>
<BR>> The second problem I ran into is a crash when I call st_disjoint()
on<BR>> certain geometries. I have been unable to get any further
information<BR>> about this crash because the Visual Studio 2008 debugger
refuses to<BR>> attach to the crashing process with the message "Invalid
security<BR>> context". I tried running postgres.exe as a non-service under
my own<BR>> user ID, but I still received the same error. <BR>> <BR>>
Is PostGIS 1.3.3 known to be very unstable on Windows XP? Might I have<BR>>
better luck on Linux? I don't have a Linux box available to me atm, so<BR>>
it would take some effort to test this question.<BR>> <BR>> -----BEGIN PGP
SIGNATURE-----<BR>> Version: PGP Universal 2.8.3<BR>> Charset:
us-ascii<BR>> <BR>>
wsBVAwUBSKBv9B6WPRoYuvd0AQjRHQf/YeFoMx+KXqAfLUmgc9W6gnAGGLcu6P9s<BR>>
NW1/ApatAFD/ezb/rT4Jz6BM3i+yowJk/sSW6y5TepQSWKN5qkQ/nfyqg2UtJoRn<BR>>
RJlrsnmmpsYsg5LyhGhJTWfry1BpVqSjWCGinTMKp0tmB0sDXgM7KTQ55jVIYU5q<BR>>
ctWcEK4RvpYd0yi1P2W5nIRBkBC60nMXsOS40y0BweM2D7JnGIA+qhwrgGubelQA<BR>>
xAqJkVJTF3qSWfngUKNuBfJKpwna8mIWmlRi9yEQ19iUxNy0SYSfcWOSOt+4O26S<BR>>
u6fWsY4zfxDhypzZ8wbR3j8NvOKMUD+24KUA1xr2HvrhwvmZm0Ag9w==<BR>> =pPq1<BR>>
-----END PGP SIGNATURE-----<BR>> <BR>> <BR>>
------------------------------<BR>> <BR>> Message: 7<BR>> Date: Mon, 11
Aug 2008 14:19:29 -0400<BR>> From: "Obe, Regina"
<robe.dnd@cityofboston.gov><BR>> Subject: RE: [postgis-users] PostGIS
1.3.3 on Windows XP Unstable<BR>> To: "PostGIS Users Discussion"
<postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>>
<53F9CF533E1AA14EA1F8C5C08ABC08D20197A17A@ZDND.DND.boston.cob><BR>>
Content-Type: text/plain; charset="iso-8859-1"<BR>> <BR>> Mike,<BR>>
<BR>> PostGIS 1.3.3 has been pretty stable for me on Windows XP, Windows 2003
and Red Hat EL Linux.<BR>> <BR>> 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
and haven't run into any issues. Though I have had some issues when using -
values for buffer.<BR>> <BR>> Which version of Geos are you running? I
suppose you could be running an unstable version of Geos. The latest stable
release of geos is 3.0.0 which you can determine if you are running or not with
the command.<BR>> <BR>> select postgis_full_version();<BR>> <BR>>
<BR>> 3.1 and 3.0.0 rc 3 and before I believe are somewhat unstable. I think
3.0.0 rcs might have a bug with start point and end_point which was fixed in
3.0.0<BR>> <BR>> Hope that helps,<BR>> Regina<BR>> <BR>> <BR>>
-----Original Message-----<BR>> From:
postgis-users-bounces@postgis.refractions.net on behalf of Bresnahan,
Mike<BR>> Sent: Mon 8/11/2008 1:02 PM<BR>> To:
postgis-users@postgis.refractions.net<BR>> Subject: [postgis-users] PostGIS
1.3.3 on Windows XP Unstable<BR>> <BR>> -----BEGIN PGP SIGNED
MESSAGE-----<BR>> Hash: SHA256<BR>> <BR>> I am trying to use PostGIS
1.3.3 with PostgreSQL 8.3 on Windows XP SP2<BR>> and I am having stability
problems. <BR>> <BR>> The first problem I ran into is that calling
buffer(the_geom,0) on an<BR>> invalid geometry causes the server to crash
with a blown assertion<BR>> ("pts->size() > 1"). This problem was
reported here:<BR>> <BR>> http://trac.osgeo.org/geos/ticket/187<BR>>
<BR>> The second problem I ran into is a crash when I call st_disjoint()
on<BR>> certain geometries. I have been unable to get any further
information<BR>> about this crash because the Visual Studio 2008 debugger
refuses to<BR>> attach to the crashing process with the message "Invalid
security<BR>> context". I tried running postgres.exe as a non-service under
my own<BR>> user ID, but I still received the same error. <BR>> <BR>>
Is PostGIS 1.3.3 known to be very unstable on Windows XP? Might I have<BR>>
better luck on Linux? I don't have a Linux box available to me atm, so<BR>>
it would take some effort to test this question.<BR>> <BR>> -----BEGIN PGP
SIGNATURE-----<BR>> Version: PGP Universal 2.8.3<BR>> Charset:
us-ascii<BR>> <BR>>
wsBVAwUBSKBv9B6WPRoYuvd0AQjRHQf/YeFoMx+KXqAfLUmgc9W6gnAGGLcu6P9s<BR>>
NW1/ApatAFD/ezb/rT4Jz6BM3i+yowJk/sSW6y5TepQSWKN5qkQ/nfyqg2UtJoRn<BR>>
RJlrsnmmpsYsg5LyhGhJTWfry1BpVqSjWCGinTMKp0tmB0sDXgM7KTQ55jVIYU5q<BR>>
ctWcEK4RvpYd0yi1P2W5nIRBkBC60nMXsOS40y0BweM2D7JnGIA+qhwrgGubelQA<BR>>
xAqJkVJTF3qSWfngUKNuBfJKpwna8mIWmlRi9yEQ19iUxNy0SYSfcWOSOt+4O26S<BR>>
u6fWsY4zfxDhypzZ8wbR3j8NvOKMUD+24KUA1xr2HvrhwvmZm0Ag9w==<BR>> =pPq1<BR>>
-----END PGP SIGNATURE-----<BR>>
_______________________________________________<BR>> postgis-users mailing
list<BR>> postgis-users@postgis.refractions.net<BR>>
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> <BR>>
<BR>> <BR>> -----------------------------------------<BR>> The
substance of this message, including any attachments, may be<BR>>
confidential, legally privileged and/or exempt from disclosure<BR>> pursuant
to Massachusetts law. It is intended<BR>> solely for the addressee. If you
received this in error, please<BR>> contact the sender and delete the
material from any computer.<BR>> -------------- next part
--------------<BR>> An HTML attachment was scrubbed...<BR>> URL:
http://lists.refractions.net/pipermail/postgis-users/attachments/20080811/dfe6f6ed/attachment-0001.html<BR>>
<BR>> ------------------------------<BR>> <BR>> Message: 8<BR>>
Date: Mon, 11 Aug 2008 11:44:24 -0700<BR>> From: "Paul Ramsey"
<pramsey@cleverelephant.ca><BR>> Subject: Re: [postgis-users] PostGIS
1.3.3 on Windows XP Unstable<BR>> To: "PostGIS Users Discussion"
<postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>>
<30fe546d0808111144j5cacf7f9qd0fad0f107ab75d3@mail.gmail.com><BR>>
Content-Type: text/plain; charset=ISO-8859-1<BR>> <BR>> Mike,<BR>>
<BR>> If it was in general unstable, we would be hearing a lot more noise
on<BR>> the list. I think you've just lucked into a couple
bad/difficult<BR>> geometry cases. Your buffer case sounds like the one
here:<BR>> http://trac.osgeo.org/geos/ticket/188 so hopefully it'll be
patched up<BR>> in the next release. Your disjoint case is new, perhaps you
can find a<BR>> pair of geometries that you know exercise it and attach them
to an<BR>> issue report?<BR>> <BR>> Paul<BR>> <BR>> On Mon, Aug
11, 2008 at 10:02 AM, Bresnahan, Mike<BR>> <Mike.Bresnahan@bestbuy.com>
wrote:<BR>> > -----BEGIN PGP SIGNED MESSAGE-----<BR>> > Hash:
SHA256<BR>> ><BR>> > I am trying to use PostGIS 1.3.3 with
PostgreSQL 8.3 on Windows XP SP2<BR>> > and I am having stability
problems.<BR>> ><BR>> > The first problem I ran into is that calling
buffer(the_geom,0) on an<BR>> > invalid geometry causes the server to
crash with a blown assertion<BR>> > ("pts->size() > 1"). This
problem was reported here:<BR>> ><BR>> >
http://trac.osgeo.org/geos/ticket/187<BR>> ><BR>> > The second
problem I ran into is a crash when I call st_disjoint() on<BR>> > certain
geometries. I have been unable to get any further information<BR>> > about
this crash because the Visual Studio 2008 debugger refuses to<BR>> >
attach to the crashing process with the message "Invalid security<BR>> >
context". I tried running postgres.exe as a non-service under my own<BR>>
> user ID, but I still received the same error.<BR>> ><BR>> > Is
PostGIS 1.3.3 known to be very unstable on Windows XP? Might I have<BR>> >
better luck on Linux? I don't have a Linux box available to me atm, so<BR>>
> it would take some effort to test this question.<BR>> ><BR>> >
-----BEGIN PGP SIGNATURE-----<BR>> > Version: PGP Universal 2.8.3<BR>>
> Charset: us-ascii<BR>> ><BR>> >
wsBVAwUBSKBv9B6WPRoYuvd0AQjRHQf/YeFoMx+KXqAfLUmgc9W6gnAGGLcu6P9s<BR>> >
NW1/ApatAFD/ezb/rT4Jz6BM3i+yowJk/sSW6y5TepQSWKN5qkQ/nfyqg2UtJoRn<BR>> >
RJlrsnmmpsYsg5LyhGhJTWfry1BpVqSjWCGinTMKp0tmB0sDXgM7KTQ55jVIYU5q<BR>> >
ctWcEK4RvpYd0yi1P2W5nIRBkBC60nMXsOS40y0BweM2D7JnGIA+qhwrgGubelQA<BR>> >
xAqJkVJTF3qSWfngUKNuBfJKpwna8mIWmlRi9yEQ19iUxNy0SYSfcWOSOt+4O26S<BR>> >
u6fWsY4zfxDhypzZ8wbR3j8NvOKMUD+24KUA1xr2HvrhwvmZm0Ag9w==<BR>> >
=pPq1<BR>> > -----END PGP SIGNATURE-----<BR>> >
_______________________________________________<BR>> > postgis-users
mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> >
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>>
><BR>> <BR>> <BR>> ------------------------------<BR>> <BR>>
_______________________________________________<BR>> postgis-users mailing
list<BR>> postgis-users@postgis.refractions.net<BR>>
http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> <BR>>
<BR>> End of postgis-users Digest, Vol 70, Issue 9<BR>>
********************************************<BR><BR>
<HR>
Invite your mail contacts to join your friends list with Windows Live Spaces.
It's easy! <A
href="http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us"
target=_new>Try it!</A> </BODY></HTML>