[postgis-users] postgis-users Digest, Vol 111, Issue 4
tom at aktalita.com
tom at aktalita.com
Mon Jul 4 15:10:23 PDT 2011
Ya voy de salida.
Sent from my BlackBerry® from Iusacell wireless device from Iusacell
-----Original Message-----
From: postgis-users-request at postgis.refractions.net
Sender: postgis-users-bounces at postgis.refractions.net
Date: Mon, 04 Jul 2011 12:00:02
To: <postgis-users at postgis.refractions.net>
Reply-To: postgis-users at postgis.refractions.net
Subject: postgis-users Digest, Vol 111, Issue 4
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. Re: PostGIS 2.0 installation error (Mark Cave-Ayland)
2. Re: PostGIS 2.0 installation error (Denis Rykov)
3. Re: PG Routing (Maria Arias de Reyna)
4. Re: PostGIS 2.0 installation error (Mark Cave-Ayland)
5. Re: PostGIS 2.0 installation error (Denis Rykov)
6. Re: PostGIS 2.0 installation error (Martin Spott)
7. Re: PostGIS 2.0 installation error (Mark Cave-Ayland)
8. Re: PG Routing (James David Smith)
----------------------------------------------------------------------
Message: 1
Date: Sun, 03 Jul 2011 20:20:39 +0100
From: Mark Cave-Ayland <mark.cave-ayland at siriusit.co.uk>
Subject: Re: [postgis-users] PostGIS 2.0 installation error
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <4E10C107.5030109 at siriusit.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
On 03/07/11 16:41, Denis Rykov wrote:
> |ERROR: could not load library"/usr/lib/postgresql/9.0/lib/postgis-2.0.so <http://postgis-2.0.so>": /usr/lib/postgresql/9.0/lib/postgis-2.0.so <http://postgis-2.0.so>: undefined symbol: DirectFunctionCall3Coll
>
> |
>
> More detailed information at :
> http://gis.stackexchange.com/questions/11759/postgis-installation-error
That's a strange error - it almost implies that a PostgreSQL 9.0-only
macro has been used somewhere in the source code. Which version of
PostgreSQL are you building against?
ATB,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
------------------------------
Message: 2
Date: Mon, 4 Jul 2011 05:12:33 +0700
From: Denis Rykov <rykovd at gmail.com>
Subject: Re: [postgis-users] PostGIS 2.0 installation error
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID:
<CAJbvKNo32txtSmpid2nx9DY0jV6HB5DKbYKW7hvmmuqz+PNdfw at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
I'm using "PostgreSQL 9.0.4 on i686-pc-linux-gnu, compiled by GCC
gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 32-bit"
On Mon, Jul 4, 2011 at 2:20 AM, Mark Cave-Ayland <
mark.cave-ayland at siriusit.co.uk> wrote:
> On 03/07/11 16:41, Denis Rykov wrote:
>
> |ERROR: could not load library"/usr/lib/postgresql/9.**0/lib/
>> postgis-2.0.so <http://postgis-2.0.so>": /usr/lib/postgresql/9.0/lib/po*
>> *stgis-2.0.so <http://postgis-2.0.so> <http://postgis-2.0.so>: undefined
>> symbol: DirectFunctionCall3Coll
>>
>>
>> |
>>
>> More detailed information at :
>> http://gis.stackexchange.com/**questions/11759/postgis-**
>> installation-error<http://gis.stackexchange.com/questions/11759/postgis-installation-error>
>>
>
> That's a strange error - it almost implies that a PostgreSQL 9.0-only macro
> has been used somewhere in the source code. Which version of PostgreSQL are
> you building against?
>
>
> ATB,
>
> Mark.
>
> --
> Mark Cave-Ayland - Senior Technical Architect
> PostgreSQL - PostGIS
> Sirius Corporation plc - control through freedom
> http://www.siriusit.co.uk
> t: +44 870 608 0063
>
> Sirius Labs: http://www.siriusit.co.uk/labs
> ______________________________**_________________
> postgis-users mailing list
> postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
> http://postgis.refractions.**net/mailman/listinfo/postgis-**users<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20110704/1435e227/attachment-0001.html>
------------------------------
Message: 3
Date: Mon, 4 Jul 2011 08:49:08 +0200
From: Maria Arias de Reyna <marias at emergya.es>
Subject: Re: [postgis-users] PG Routing
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <201107040849.08612.marias at emergya.es>
Content-Type: Text/Plain; charset="iso-8859-1"
El Domingo 03 Julio 2011, James David Smith escribi?:
> Dear all,
>
> I have a table of GPS points which are the locations of vehicles every
> 15 seconds. Each journey that a car makes has an ID. For example a
> taxi is on 'job 1' and has 50 points while it does this job, and then
> another 50 or 60 when it is on 'job 2' etc. What I would like to do
> however is investigate whether the car took the most effecient route
> between the two points. To this end I think that I can use the
> PGROUTING extension of PostGIS...? Does this sound possible?
You can calculate the shortest path with pgRouting and then compare it with
the length of the linestring formed with this GPS points. Probably you will
have a longer path with the GPS points (because the GPS is never exact) but if
you add a percent of error to the shortest path calculated by pgRouting you
will know if the vehicle did a good or a bad path.
> I have
> found the PGROUTING website, and download the ZIP file for Windows
> installation, however I am not sure how to install it. Could somebody
> please tell me how or provide a link to a good place to read about how
> to install and use PGROUTING?
Why are you using Windows (for any serious work)? There is a PPA for Ubuntu[1]
which has a direct install while pgRouting binaries for Windows are old and
strongly dependent of a postgresql version. And remember that you must install
postgis first.
Anyway, if you are thinking of having a real-time server with several vehicles
sending positions every 15 seconds, forget Windows. It will be insane. If it
is insane if you do it on a non-strongly-optimized database on Linux I don't
want to know how hard it will be on Windows. Believe me, I have made a few of
this real-time systems.
[1]https://launchpad.net/~georepublic/+archive/pgrouting
--
Mar?a Arias de Reyna Dom?nguez
?rea de Operaciones
Emergya Consultor?a
Tfno: +34 954 51 75 77 / +34 607 43 74 27
Fax: +34 954 51 64 73
www.emergya.es
------------------------------
Message: 4
Date: Mon, 04 Jul 2011 09:17:22 +0100
From: Mark Cave-Ayland <mark.cave-ayland at siriusit.co.uk>
Subject: Re: [postgis-users] PostGIS 2.0 installation error
To: postgis-users at postgis.refractions.net
Message-ID: <4E117712.4050902 at siriusit.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
On 03/07/11 23:12, Denis Rykov wrote:
> I'm using "PostgreSQL 9.0.4 on i686-pc-linux-gnu, compiled by GCC
> gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 32-bit"
Hmmm. And no copies of 9.1 beta anywhere on that box either?
ATB,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
------------------------------
Message: 5
Date: Mon, 4 Jul 2011 15:49:05 +0700
From: Denis Rykov <rykovd at gmail.com>
Subject: Re: [postgis-users] PostGIS 2.0 installation error
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID:
<CAJbvKNo7qN_smzx8_fK85dMVk=cMAR+pmBVXzFQ3JFfu5Pwe5A at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
In the beginning I tried to install 2.0 in PostgreSQL 9.1 and got an error
message, then I uninstalled it, installed 9.0 and got the same error
message.
Is PostGIS 2.0 incompatible with PostgreSQL 9.1 server?
On Mon, Jul 4, 2011 at 3:17 PM, Mark Cave-Ayland <
mark.cave-ayland at siriusit.co.uk> wrote:
> On 03/07/11 23:12, Denis Rykov wrote:
>
> I'm using "PostgreSQL 9.0.4 on i686-pc-linux-gnu, compiled by GCC
>> gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 32-bit"
>>
>
> Hmmm. And no copies of 9.1 beta anywhere on that box either?
>
>
>
> ATB,
>
> Mark.
>
> --
> Mark Cave-Ayland - Senior Technical Architect
> PostgreSQL - PostGIS
> Sirius Corporation plc - control through freedom
> http://www.siriusit.co.uk
> t: +44 870 608 0063
>
> Sirius Labs: http://www.siriusit.co.uk/labs
> ______________________________**_________________
> postgis-users mailing list
> postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
> http://postgis.refractions.**net/mailman/listinfo/postgis-**users<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20110704/aa2d7e14/attachment-0001.html>
------------------------------
Message: 6
Date: Mon, 4 Jul 2011 08:55:29 +0000 (UTC)
From: Martin Spott <Martin.Spott at mgras.net>
Subject: Re: [postgis-users] PostGIS 2.0 installation error
To: postgis-users at postgis.refractions.net
Message-ID: <iurv61$nk7e$1 at osprey.mgras.de>
Denis Rykov wrote:
> Is PostGIS 2.0 incompatible with PostgreSQL 9.1 server?
No ;-)
Recent PostGIS SVN works nicely here, at least on a test-scenario I'm
running with PostgreSQL 9.1beta2,
Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------
------------------------------
Message: 7
Date: Mon, 04 Jul 2011 10:05:56 +0100
From: Mark Cave-Ayland <mark.cave-ayland at siriusit.co.uk>
Subject: Re: [postgis-users] PostGIS 2.0 installation error
To: postgis-users at postgis.refractions.net
Message-ID: <4E118274.3010903 at siriusit.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
On 04/07/11 09:55, Martin Spott wrote:
>> Is PostGIS 2.0 incompatible with PostgreSQL 9.1 server?
>
> No ;-)
> Recent PostGIS SVN works nicely here, at least on a test-scenario I'm
> running with PostgreSQL 9.1beta2,
I'm fairly sure that newer versions work with PostgreSQL 9.1 - perhaps
you just need to "svn up" to a newer version (although there are still
some outstanding regression errors here that need Paul's attention).
The output of configure should show you exactly which versions of
various components have been detected if that helps at all?
ATB,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
------------------------------
Message: 8
Date: Mon, 4 Jul 2011 13:37:37 +0100
From: James David Smith <james.david.smith at gmail.com>
Subject: Re: [postgis-users] PG Routing
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID:
<CAMu32ACkONH9nQBtUfOgnEmBnKTusMn=oUyOw0dx8CvHQC=sGQ at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Dear Maria,
Thank you for your reply. I already have PostgreSQL + PostGIS database
running which contains all of my information. The data is not a live system,
it is data from March 2010. I am doing some research on the data. I have
discovere that as I am using PostgreSQL 9.0 I cannot use pgRouting
unfortunately. So I now have two questions please?
1) If I uninstall PostgreSQL 9.0, and then install PostgreSQL 8.3 (so I can
use pgRouting), will my databases still be intact? Or will I lose all of my
tables and data?
2) Maybe an easier solution would be for me to create an OS GEO bootable USB
drive, and then do the work in Ubuntu? If I did this, will my existing
PostgreSQL databases be accesible through the Ubuntu version of PostgreSQL?
http://live.osgeo.org/en/quickstart/usb_quickstart.html
Thank you for your help
James
On 4 July 2011 07:49, Maria Arias de Reyna <marias at emergya.es> wrote:
> El Domingo 03 Julio 2011, James David Smith escribi?:
> > Dear all,
> >
> > I have a table of GPS points which are the locations of vehicles every
> > 15 seconds. Each journey that a car makes has an ID. For example a
> > taxi is on 'job 1' and has 50 points while it does this job, and then
> > another 50 or 60 when it is on 'job 2' etc. What I would like to do
> > however is investigate whether the car took the most effecient route
> > between the two points. To this end I think that I can use the
> > PGROUTING extension of PostGIS...? Does this sound possible?
>
> You can calculate the shortest path with pgRouting and then compare it with
> the length of the linestring formed with this GPS points. Probably you will
> have a longer path with the GPS points (because the GPS is never exact) but
> if
> you add a percent of error to the shortest path calculated by pgRouting you
> will know if the vehicle did a good or a bad path.
>
> > I have
> > found the PGROUTING website, and download the ZIP file for Windows
> > installation, however I am not sure how to install it. Could somebody
> > please tell me how or provide a link to a good place to read about how
> > to install and use PGROUTING?
>
> Why are you using Windows (for any serious work)? There is a PPA for
> Ubuntu[1]
> which has a direct install while pgRouting binaries for Windows are old and
> strongly dependent of a postgresql version. And remember that you must
> install
> postgis first.
>
> Anyway, if you are thinking of having a real-time server with several
> vehicles
> sending positions every 15 seconds, forget Windows. It will be insane. If
> it
> is insane if you do it on a non-strongly-optimized database on Linux I
> don't
> want to know how hard it will be on Windows. Believe me, I have made a few
> of
> this real-time systems.
>
>
> [1]https://launchpad.net/~georepublic/+archive/pgrouting<https://launchpad.net/%7Egeorepublic/+archive/pgrouting>
> --
> Mar?a Arias de Reyna Dom?nguez
> ?rea de Operaciones
>
> Emergya Consultor?a
> Tfno: +34 954 51 75 77 / +34 607 43 74 27
> Fax: +34 954 51 64 73
> www.emergya.es
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20110704/0c5844dc/attachment-0001.html>
------------------------------
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
End of postgis-users Digest, Vol 111, Issue 4
*********************************************
More information about the postgis-users
mailing list