Re: [postgis-users] PG Routing
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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2.0 installation error
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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2.0 installation error
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-ayl...@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@postgis.**refractions.netpostgis-users@postgis.refractions.net http://postgis.refractions.**net/mailman/listinfo/postgis-**usershttp://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2.0 installation error
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 ! -- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PG Routing
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 mar...@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/pgroutinghttps://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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] postgis-users Digest, Vol 111, Issue 4
Ya voy de salida. Sent from my BlackBerry® from Iusacell wireless device from Iusacell -Original Message- From: postgis-users-requ...@postgis.refractions.net Sender: postgis-users-boun...@postgis.refractions.net Date: Mon, 04 Jul 2011 12:00:02 To: postgis-users@postgis.refractions.net Reply-To: postgis-users@postgis.refractions.net Subject: postgis-users Digest, Vol 111, Issue 4 Send postgis-users mailing list submissions to postgis-users@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-requ...@postgis.refractions.net You can reach the person managing the list at postgis-users-ow...@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-ayl...@siriusit.co.uk Subject: Re: [postgis-users] PostGIS 2.0 installation error To: PostGIS Users Discussion postgis-users@postgis.refractions.net Message-ID: 4e10c107.5030...@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 ryk...@gmail.com Subject: Re: [postgis-users] PostGIS 2.0 installation error To: PostGIS Users Discussion postgis-users@postgis.refractions.net Message-ID: cajbvkno32txtsmpid2nx9dy0jv6hb5dkbykw7hvmmuqz+pn...@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-ayl...@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-errorhttp://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@postgis.**refractions.netpostgis-users@postgis.refractions.net http://postgis.refractions.**net/mailman/listinfo/postgis-**usershttp://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 mar...@emergya.es Subject: Re: [postgis-users] PG Routing To: PostGIS Users Discussion postgis-users@postgis.refractions.net Message-ID: 201107040849.08612.mar...@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