[postgis-users] Select Distance in 3d
Obe, Regina
robe.dnd at cityofboston.gov
Tue Aug 12 06:09:57 PDT 2008
Eehab,
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
SELECT ST_length3d(ST_MakeLine('POINT(1 2 3)', 'POINT(4 5 6)') )As d3,
ST_Length2d(ST_MakeLine('POINT(1 2)', 'POINT(4 5)')) as d2;
So in your case
SELECT asKml("FireFighterO".the_geom) FROM "FireFighterO" , igfplan
WHERE igfplan.id=2 AND ST_DWithin("FireFighterO".the_geom,
igfplan.the_geom, 120) AND
AND ST_Length3d(ST_MakeLine("FireFighterO".the_geom, igfplan.the_geom))
< 120;
The ST_DWithin is to force the use of indexes because your current query
as it was written will not use indexes.
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.
Hope that helps,
Regina
________________________________
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
eehab hamzeh
Sent: Tuesday, August 12, 2008 8:35 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Select Distance in 3d
Hello,
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.
below is my query.
SELECT asKml("FireFighterO".the_geom) FROM "FireFighterO" , igfplan
WHERE igfplan.id=2
AND distance("FireFighterO".the_geom, igfplan.the_geom) < 120
Thanks
________________________________
> From: postgis-users-request at postgis.refractions.net
> Subject: postgis-users Digest, Vol 70, Issue 9
> To: postgis-users at postgis.refractions.net
> Date: Mon, 11 Aug 2008 12:01:19 -0700
>
> Send postgis-users mailing list submissions to
> postgis-users at postgis.refractions.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> or, via email, send a message with subject or body 'help' to
> postgis-users-request at postgis.refractions.net
>
> You can reach the person managing the list at
> postgis-users-owner at postgis.refractions.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of postgis-users digest..."
>
>
> Today's Topics:
>
> 1. How to add spatial functions to a custom schema (gimbrogno)
> 2. RE: How to add spatial functions to a custom schema
> (Mark Lidstone)
> 3. RE: How to add spatial functions to a custom schema (gimbrogno)
> 4. RE: How to add spatial functions to a custom schema (Obe, Regina)
> 5. RE: How to add spatial functions to a custom schema (gimbrogno)
> 6. PostGIS 1.3.3 on Windows XP Unstable (Bresnahan, Mike)
> 7. RE: PostGIS 1.3.3 on Windows XP Unstable (Obe, Regina)
> 8. Re: PostGIS 1.3.3 on Windows XP Unstable (Paul Ramsey)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 11 Aug 2008 04:34:08 -0700 (PDT)
> From: gimbrogno <magnitudo9 at email.it>
> Subject: [postgis-users] How to add spatial functions to a custom
> schema
> To: postgis-users at postgis.refractions.net
> Message-ID: <18923897.post at talk.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
>
> 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: English is not my native language, so excuse me for errors...
> --
> View this message in context:
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp
18923897p18923897.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 11 Aug 2008 12:39:36 +0100
> From: "Mark Lidstone" <Mark.Lidstone at bmtcordah.com>
> Subject: RE: [postgis-users] How to add spatial functions to a custom
> schema
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
> <355510E97AD99D4181D67084193C0DAF3241F9 at so-ex-02.bmt.cordah.com>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi Gimborgno,
>
> I think all you need to do is add the schema name as the first
argument
> to the AddGeometryColumn procedure. E.g. replace:
>
> SELECT AddGeometryColumn('table', 'field', 4326, 'POINT', 2);
>
> with:
>
> SELECT AddGeometryColumn('new_schema', 'table', 'field', 4326,
'POINT',
> 2);
>
> Thanks,
>
> Mark Lidstone
> Tel: +44 (0)23 80232222; Fax: +44 (0)23 80232891
>
> BMT Cordah Ltd
> Grove House
> 7 Ocean Way
> Ocean Village
> Southampton
> SO14 3TJ
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> gimbrogno
> Sent: 11 August 2008 12:34
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] How to add spatial functions to a custom
schema
>
>
> 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: English is not my native language, so excuse me for errors...
> --
> View this message in context:
>
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp
> 18923897p18923897.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> BMT Cordah Ltd.
> A member of the BMT group of companies
> Registered Office: Investment House, 6 Union Row, Aberdeen AB10 1DQ
> Registered in Scotland No. 163413
> http://www.bmtcordah.com/
> http://www.bmt.org/
>
> 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.
>
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 11 Aug 2008 04:50:44 -0700 (PDT)
> From: gimbrogno <magnitudo9 at email.it>
> Subject: RE: [postgis-users] How to add spatial functions to a custom
> schema
> To: postgis-users at postgis.refractions.net
> Message-ID: <18924157.post at talk.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
>
> 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 advance...
>
> Mark Lidstone wrote:
> >
> > Hi Gimborgno,
> >
> > I think all you need to do is add the schema name as the first
argument
> > to the AddGeometryColumn procedure. E.g. replace:
> >
> > SELECT AddGeometryColumn('table', 'field', 4326, 'POINT', 2);
> >
> > with:
> >
> > SELECT AddGeometryColumn('new_schema', 'table', 'field', 4326,
'POINT',
> > 2);
> >
> > Thanks,
> >
> > Mark Lidstone
> > Tel: +44 (0)23 80232222; Fax: +44 (0)23 80232891
> >
> > BMT Cordah Ltd
> > Grove House
> > 7 Ocean Way
> > Ocean Village
> > Southampton
> > SO14 3TJ
> >
> >
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> > gimbrogno
> > Sent: 11 August 2008 12:34
> > To: postgis-users at postgis.refractions.net
> > Subject: [postgis-users] How to add spatial functions to a custom
schema
> >
> >
> > 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: English is not my native language, so excuse me for errors...
> > --
> > View this message in context:
> >
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp
> > 18923897p18923897.html
> > Sent from the PostGIS - User mailing list archive at Nabble.com.
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> > BMT Cordah Ltd.
> > A member of the BMT group of companies
> > Registered Office: Investment House, 6 Union Row, Aberdeen AB10 1DQ
> > Registered in Scotland No. 163413
> > http://www.bmtcordah.com/
> > http://www.bmt.org/
> >
> > 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.
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
>
> --
> View this message in context:
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp
18923897p18924157.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> Message: 4
> Date: Mon, 11 Aug 2008 08:16:23 -0400
> From: "Obe, Regina" <robe.dnd at cityofboston.gov>
> Subject: RE: [postgis-users] How to add spatial functions to a custom
> schema
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
> <53F9CF533E1AA14EA1F8C5C08ABC08D204889D3A at ZDND.DND.boston.cob>
> Content-Type: text/plain; charset="us-ascii"
>
> Gimbrogno,
> Do the following before running the .sql files.
>
> SET search_path = info;
>
> Keep in mind that you should really only have those functions and
table
> loaded in one schema not all of them even if you have your tables in
> different schemas. The functions and tables should exist only once per
> database.
>
> You will also want to add the info schema to your database search
path,
> otherwise many things and software that works with PostGIS will not
work
> since they don't prefix the schema name.
>
> So to do that you would do something like this
>
> ALTER DATABASE your_database_name_here SET search_path="$user",
public,
> info;
>
>
> Hope that helps,
> Regina
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> gimbrogno
> Sent: Monday, August 11, 2008 7:51 AM
> To: postgis-users at postgis.refractions.net
> Subject: RE: [postgis-users] How to add spatial functions to a custom
> schema
>
>
> 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 advance...
>
> Mark Lidstone wrote:
> >
> > Hi Gimborgno,
> >
> > I think all you need to do is add the schema name as the first
> argument
> > to the AddGeometryColumn procedure. E.g. replace:
> >
> > SELECT AddGeometryColumn('table', 'field', 4326, 'POINT', 2);
> >
> > with:
> >
> > SELECT AddGeometryColumn('new_schema', 'table', 'field', 4326,
> 'POINT',
> > 2);
> >
> > Thanks,
> >
> > Mark Lidstone
> > Tel: +44 (0)23 80232222; Fax: +44 (0)23 80232891
> >
> > BMT Cordah Ltd
> > Grove House
> > 7 Ocean Way
> > Ocean Village
> > Southampton
> > SO14 3TJ
> >
> >
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> > gimbrogno
> > Sent: 11 August 2008 12:34
> > To: postgis-users at postgis.refractions.net
> > Subject: [postgis-users] How to add spatial functions to a custom
> schema
> >
> >
> > 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: English is not my native language, so excuse me for errors...
> > --
> > View this message in context:
> >
>
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp
> > 18923897p18923897.html
> > Sent from the PostGIS - User mailing list archive at Nabble.com.
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> > BMT Cordah Ltd.
> > A member of the BMT group of companies
> > Registered Office: Investment House, 6 Union Row, Aberdeen AB10 1DQ
> > Registered in Scotland No. 163413
> > http://www.bmtcordah.com/
> > http://www.bmt.org/
> >
> > 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.
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
>
> --
> View this message in context:
>
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp
> 18923897p18924157.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> -----------------------------------------
> The substance of this message, including any attachments, may be
> confidential, legally privileged and/or exempt from disclosure
> pursuant to Massachusetts law. It is intended
> solely for the addressee. If you received this in error, please
> contact the sender and delete the material from any computer.
>
>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 11 Aug 2008 06:24:20 -0700 (PDT)
> From: gimbrogno <magnitudo9 at email.it>
> Subject: RE: [postgis-users] How to add spatial functions to a custom
> schema
> To: postgis-users at postgis.refractions.net
> Message-ID: <18925804.post at talk.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
>
> Thanks a lot... now it goes!
>
>
>
> Obe, Regina DND\MIS wrote:
> >
> > Gimbrogno,
> > Do the following before running the .sql files.
> >
> > SET search_path = info;
> >
> > Keep in mind that you should really only have those functions and
table
> > loaded in one schema not all of them even if you have your tables in
> > different schemas. The functions and tables should exist only once
per
> > database.
> >
> > You will also want to add the info schema to your database search
path,
> > otherwise many things and software that works with PostGIS will not
work
> > since they don't prefix the schema name.
> >
> > So to do that you would do something like this
> >
> > ALTER DATABASE your_database_name_here SET search_path="$user",
public,
> > info;
> >
> >
> > Hope that helps,
> > Regina
> >
> >
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> > gimbrogno
> > Sent: Monday, August 11, 2008 7:51 AM
> > To: postgis-users at postgis.refractions.net
> > Subject: RE: [postgis-users] How to add spatial functions to a
custom
> > schema
> >
> >
> > 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 advance...
> >
> > Mark Lidstone wrote:
> >>
> >> Hi Gimborgno,
> >>
> >> I think all you need to do is add the schema name as the first
> > argument
> >> to the AddGeometryColumn procedure. E.g. replace:
> >>
> >> SELECT AddGeometryColumn('table', 'field', 4326, 'POINT', 2);
> >>
> >> with:
> >>
> >> SELECT AddGeometryColumn('new_schema', 'table', 'field', 4326,
> > 'POINT',
> >> 2);
> >>
> >> Thanks,
> >>
> >> Mark Lidstone
> >> Tel: +44 (0)23 80232222; Fax: +44 (0)23 80232891
> >>
> >> BMT Cordah Ltd
> >> Grove House
> >> 7 Ocean Way
> >> Ocean Village
> >> Southampton
> >> SO14 3TJ
> >>
> >>
> >> -----Original Message-----
> >> From: postgis-users-bounces at postgis.refractions.net
> >> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> >> gimbrogno
> >> Sent: 11 August 2008 12:34
> >> To: postgis-users at postgis.refractions.net
> >> Subject: [postgis-users] How to add spatial functions to a custom
> > schema
> >>
> >>
> >> 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: English is not my native language, so excuse me for errors...
> >> --
> >> View this message in context:
> >>
> >
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp
> >> 18923897p18923897.html
> >> Sent from the PostGIS - User mailing list archive at Nabble.com.
> >>
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >>
> >> BMT Cordah Ltd.
> >> A member of the BMT group of companies
> >> Registered Office: Investment House, 6 Union Row, Aberdeen AB10 1DQ
> >> Registered in Scotland No. 163413
> >> http://www.bmtcordah.com/
> >> http://www.bmt.org/
> >>
> >> 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.
> >>
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >>
> >
> > --
> > View this message in context:
> >
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp
> > 18923897p18924157.html
> > Sent from the PostGIS - User mailing list archive at Nabble.com.
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > -----------------------------------------
> > The substance of this message, including any attachments, may be
> > confidential, legally privileged and/or exempt from disclosure
> > pursuant to Massachusetts law. It is intended
> > solely for the addressee. If you received this in error, please
> > contact the sender and delete the material from any computer.
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
>
> --
> View this message in context:
http://www.nabble.com/How-to-add-spatial-functions-to-a-custom-schema-tp
18923897p18925804.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> Message: 6
> Date: Mon, 11 Aug 2008 12:02:27 -0500
> From: "Bresnahan, Mike" <Mike.Bresnahan at bestbuy.com>
> Subject: [postgis-users] PostGIS 1.3.3 on Windows XP Unstable
> To: <postgis-users at postgis.refractions.net>
> Message-ID:
> <C8BE5909BAD8A043BC47D6BB886E1384019EA76C at dsp66mail.na.bestbuy.com>
> Content-Type: text/plain; charset="us-ascii"
>
> -----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
> ("pts->size() > 1"). This problem was reported here:
>
> http://trac.osgeo.org/geos/ticket/187
>
> The second problem I ran into is a crash when I call st_disjoint() on
> certain geometries. I have been unable to get any further information
> about this crash because the Visual Studio 2008 debugger refuses to
> attach to the crashing process with the message "Invalid security
> context". I tried running postgres.exe as a non-service under my own
> user ID, but I still received the same error.
>
> Is PostGIS 1.3.3 known to be very unstable on Windows XP? Might I have
> better luck on Linux? I don't have a Linux box available to me atm, so
> it would take some effort to test this question.
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP Universal 2.8.3
> Charset: us-ascii
>
> wsBVAwUBSKBv9B6WPRoYuvd0AQjRHQf/YeFoMx+KXqAfLUmgc9W6gnAGGLcu6P9s
> NW1/ApatAFD/ezb/rT4Jz6BM3i+yowJk/sSW6y5TepQSWKN5qkQ/nfyqg2UtJoRn
> RJlrsnmmpsYsg5LyhGhJTWfry1BpVqSjWCGinTMKp0tmB0sDXgM7KTQ55jVIYU5q
> ctWcEK4RvpYd0yi1P2W5nIRBkBC60nMXsOS40y0BweM2D7JnGIA+qhwrgGubelQA
> xAqJkVJTF3qSWfngUKNuBfJKpwna8mIWmlRi9yEQ19iUxNy0SYSfcWOSOt+4O26S
> u6fWsY4zfxDhypzZ8wbR3j8NvOKMUD+24KUA1xr2HvrhwvmZm0Ag9w==
> =pPq1
> -----END PGP SIGNATURE-----
>
>
> ------------------------------
>
> Message: 7
> Date: Mon, 11 Aug 2008 14:19:29 -0400
> From: "Obe, Regina" <robe.dnd at cityofboston.gov>
> Subject: RE: [postgis-users] PostGIS 1.3.3 on Windows XP Unstable
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
> <53F9CF533E1AA14EA1F8C5C08ABC08D20197A17A at ZDND.DND.boston.cob>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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 and haven't run
into any issues. Though I have had some issues when using - values for
buffer.
>
> 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.
>
> select postgis_full_version();
>
>
> 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
>
> Hope that helps,
> Regina
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net on behalf of
Bresnahan, Mike
> Sent: Mon 8/11/2008 1:02 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] PostGIS 1.3.3 on Windows XP Unstable
>
> -----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
> ("pts->size() > 1"). This problem was reported here:
>
> http://trac.osgeo.org/geos/ticket/187
>
> The second problem I ran into is a crash when I call st_disjoint() on
> certain geometries. I have been unable to get any further information
> about this crash because the Visual Studio 2008 debugger refuses to
> attach to the crashing process with the message "Invalid security
> context". I tried running postgres.exe as a non-service under my own
> user ID, but I still received the same error.
>
> Is PostGIS 1.3.3 known to be very unstable on Windows XP? Might I have
> better luck on Linux? I don't have a Linux box available to me atm, so
> it would take some effort to test this question.
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP Universal 2.8.3
> Charset: us-ascii
>
> wsBVAwUBSKBv9B6WPRoYuvd0AQjRHQf/YeFoMx+KXqAfLUmgc9W6gnAGGLcu6P9s
> NW1/ApatAFD/ezb/rT4Jz6BM3i+yowJk/sSW6y5TepQSWKN5qkQ/nfyqg2UtJoRn
> RJlrsnmmpsYsg5LyhGhJTWfry1BpVqSjWCGinTMKp0tmB0sDXgM7KTQ55jVIYU5q
> ctWcEK4RvpYd0yi1P2W5nIRBkBC60nMXsOS40y0BweM2D7JnGIA+qhwrgGubelQA
> xAqJkVJTF3qSWfngUKNuBfJKpwna8mIWmlRi9yEQ19iUxNy0SYSfcWOSOt+4O26S
> u6fWsY4zfxDhypzZ8wbR3j8NvOKMUD+24KUA1xr2HvrhwvmZm0Ag9w==
> =pPq1
> -----END PGP SIGNATURE-----
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> -----------------------------------------
> The substance of this message, including any attachments, may be
> confidential, legally privileged and/or exempt from disclosure
> pursuant to Massachusetts law. It is intended
> solely for the addressee. If you received this in error, please
> contact the sender and delete the material from any computer.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
http://lists.refractions.net/pipermail/postgis-users/attachments/2008081
1/dfe6f6ed/attachment-0001.html
>
> ------------------------------
>
> Message: 8
> Date: Mon, 11 Aug 2008 11:44:24 -0700
> From: "Paul Ramsey" <pramsey at cleverelephant.ca>
> Subject: Re: [postgis-users] PostGIS 1.3.3 on Windows XP Unstable
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
> <30fe546d0808111144j5cacf7f9qd0fad0f107ab75d3 at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Mike,
>
> If it was in general unstable, we would be hearing a lot more noise on
> the list. I think you've just lucked into a couple bad/difficult
> geometry cases. Your buffer case sounds like the one here:
> http://trac.osgeo.org/geos/ticket/188 so hopefully it'll be patched up
> in the next release. Your disjoint case is new, perhaps you can find a
> pair of geometries that you know exercise it and attach them to an
> issue report?
>
> Paul
>
> On Mon, Aug 11, 2008 at 10:02 AM, Bresnahan, Mike
> <Mike.Bresnahan at bestbuy.com> wrote:
> > -----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
> > ("pts->size() > 1"). This problem was reported here:
> >
> > http://trac.osgeo.org/geos/ticket/187
> >
> > The second problem I ran into is a crash when I call st_disjoint()
on
> > certain geometries. I have been unable to get any further
information
> > about this crash because the Visual Studio 2008 debugger refuses to
> > attach to the crashing process with the message "Invalid security
> > context". I tried running postgres.exe as a non-service under my own
> > user ID, but I still received the same error.
> >
> > Is PostGIS 1.3.3 known to be very unstable on Windows XP? Might I
have
> > better luck on Linux? I don't have a Linux box available to me atm,
so
> > it would take some effort to test this question.
> >
> > -----BEGIN PGP SIGNATURE-----
> > Version: PGP Universal 2.8.3
> > Charset: us-ascii
> >
> > wsBVAwUBSKBv9B6WPRoYuvd0AQjRHQf/YeFoMx+KXqAfLUmgc9W6gnAGGLcu6P9s
> > NW1/ApatAFD/ezb/rT4Jz6BM3i+yowJk/sSW6y5TepQSWKN5qkQ/nfyqg2UtJoRn
> > RJlrsnmmpsYsg5LyhGhJTWfry1BpVqSjWCGinTMKp0tmB0sDXgM7KTQ55jVIYU5q
> > ctWcEK4RvpYd0yi1P2W5nIRBkBC60nMXsOS40y0BweM2D7JnGIA+qhwrgGubelQA
> > xAqJkVJTF3qSWfngUKNuBfJKpwna8mIWmlRi9yEQ19iUxNy0SYSfcWOSOt+4O26S
> > u6fWsY4zfxDhypzZ8wbR3j8NvOKMUD+24KUA1xr2HvrhwvmZm0Ag9w==
> > =pPq1
> > -----END PGP SIGNATURE-----
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
>
> ------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> End of postgis-users Digest, Vol 70, Issue 9
> ********************************************
________________________________
Invite your mail contacts to join your friends list with Windows Live
Spaces. It's easy! Try it!
<http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.
aspx&mkt=en-us>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080812/bdb6a4f5/attachment.html>
More information about the postgis-users
mailing list