[postgis-users] Select Distance in 3d
eehab hamzeh
eehab40 at hotmail.com
Tue Aug 12 05:35:23 PDT 2008
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-tp18923897p18923897.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-tp18923897p18924157.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-tp18923897p18925804.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/20080811/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!
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/26f7b754/attachment.html>
More information about the postgis-users
mailing list