Re: [postgis-users] How to install Postgresql + Postgis 2.0 on Ubuntu 12-04 LTS
Hi Jose, In case you want to use Ubuntu packages you can add the UbuntuGIS-unstable repository: https://launchpad.net/~ubuntugis/+archive/ubuntugis-unstable Like this it's very easy to install PostGIS 2.0 Daniel On Thu, Oct 4, 2012 at 4:41 PM, José María jmamu...@gmail.com wrote: Vince. That is the matter, I don't know where I installed theses libraries exactily. Anyway if I try to look for then in the usr directory they are not. I wrote geos-config --version 3.3.4 and gdal-config --version: 1.9.1, but I don't know where they are installed. Would you mind say me how you did it exactily? I mean if you could indicate me step to step the full installation process. Thankl you! Jose 2012/10/2 Vince Miller vincentpmil...@yahoo.com Jose, Be sure to install geos and postgis in the usr directory on your Ubuntu box, and make sure that libxml2 is there too. I spent all day yesterday trying to do exactly what you're trying to do. The wiki link procedure sent by the previous poster worked for me. Vince --- On *Tue, 10/2/12, José María jmamu...@gmail.com* wrote: From: José María jmamu...@gmail.com Subject: Re: [postgis-users] How to install Postgresql + Postgis 2.0 on Ubuntu 12-04 LTS To: PostGIS Users Discussion postgis-users@postgis.refractions.net Date: Tuesday, October 2, 2012, 6:07 AM Thanks Stefano, But when I try to follow the steps I get errors. If you could to install everything without problems Could you help me? Please. Thanks again, José María 2012/10/2 Stefano Iacovella stefano.iacove...@gmail.comhttp://mc/compose?to=stefano.iacove...@gmail.com Hi José if you are willing to compile source code have a look at this page: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204src Stefano --- 41.95581N 12.52854E http://www.linkedin.com/in/stefanoiacovella http://twitter.com/#!/Iacovellas 2012/10/2 José María jmamu...@gmail.comhttp://mc/compose?to=jmamu...@gmail.com Hi guys!! I'm trying to install Postgresql and PostGis 2.0 on my Ubuntu, so I have doubts and I have been looking for information with google but I didn't find clear information. Someone could help me with this? Thanks, José María ___ postgis-users mailing list postgis-users@postgis.refractions.nethttp://mc/compose?to=postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.nethttp://mc/compose?to=postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -Inline Attachment Follows- ___ postgis-users mailing list postgis-users@postgis.refractions.nethttp://mc/compose?to=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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Georepublic UG Georepublic Japan eMail: daniel.ka...@georepublic.de Web: http://georepublic.de ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Diagram of Voronoï to Squelettis ation of polygon
Hi Jérôme, As you said the idea would be to add a function that calculates a skeleton from a polygon. Currently pgRouting contains a couple of functions ( http://www.pgrouting.org/docs/1.x/index.html), but all of them require network data with at least information about start and end ID of a linestring. If the information about start and end ID doesn't exist yet, you can run a function called assign_vertex_id. But what you need is network data. Your skeleton function now would allow users to add one more step before and retrieve a network from polygon data. So one could first run the skeleton function, then the assign_vertex_id function and finally have all the routing functions available even if the original data was of polygon shape. pgRouting has it's source code on GitHub (https://github.com/pgRouting/). The assign_vertex_id function is here: https://github.com/pgRouting/pgrouting/blob/master/core/sql/routing_topology.sql. Though I'm not sure it wouldn't be a good idea to reorganize this a bit. Well, I think we might better discuss details on the pgRouting list: http://lists.osgeo.org/mailman/listinfo/pgrouting-dev Best regards, Daniel 2010/12/11 j.rolland jrmroll...@aol.com Hi Daniel, Of course that I am interested, say me how I can contribute my share. As I indicate it in my blog, I can develop a function which turns over the skeleton from a polygon. Give me your specifications and I would study them. cordially, Jérôme Daniel Kastl-3 wrote: Salut Jérôme, Thank you for sharing your blog article! I tried to recall my French from high school and thanks to nice screenshots and code samples I think I could mostly understand. Well, I thought your functions might be an interesting contribution to pgRouting project (http://www.pgrouting.org). We're trying to collect various routing and network analysis related functionality. Some voronoi and skeleton addition would for sure suite well. That way users could build some routable network out of river polygons for example. It might also help to build a routable graph for maritime navigation. Probably there are a lot more use cases. Let me know if you're interested. Daniel 2010/12/9 j.rolland jrmroll...@aol.com hi, I have just set up on my blog at the following address http://ageoguy.blogspot.com/2010/12/squ… ation.html http://ageoguy.blogspot.com/2010/12/squ… ation.html a tutorial (in french) which presents an algorithm of surface squelettisation of waterway (POLYGON). I provide an example like all the necessary functions and requests which will enable you to obtain the skeleton of the waterway as you can see it in the capture below : http://old.nabble.com/file/p30413623/skeleton5.jpg regards, Jérôme -- View this message in context: http://old.nabble.com/Diagram-of-Vorono%C3%AF-to-Squelettisation-of-polygon-tp30413623p30413623.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Georepublic UG Georepublic Japan eMail: daniel.ka...@georepublic.de Web: http://georepublic.de ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- View this message in context: http://old.nabble.com/Diagram-of-Vorono%C3%AF-to-Squelettisation-of-polygon-tp30413623p30428747.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Georepublic UG Georepublic Japan eMail: daniel.ka...@georepublic.de Web: http://georepublic.de ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Diagram of Voronoï to Squelettis ation of polygon
Salut Jérôme, Thank you for sharing your blog article! I tried to recall my French from high school and thanks to nice screenshots and code samples I think I could mostly understand. Well, I thought your functions might be an interesting contribution to pgRouting project (http://www.pgrouting.org). We're trying to collect various routing and network analysis related functionality. Some voronoi and skeleton addition would for sure suite well. That way users could build some routable network out of river polygons for example. It might also help to build a routable graph for maritime navigation. Probably there are a lot more use cases. Let me know if you're interested. Daniel 2010/12/9 j.rolland jrmroll...@aol.com hi, I have just set up on my blog at the following address http://ageoguy.blogspot.com/2010/12/squ… ation.html http://ageoguy.blogspot.com/2010/12/squ… ation.html a tutorial (in french) which presents an algorithm of surface squelettisation of waterway (POLYGON). I provide an example like all the necessary functions and requests which will enable you to obtain the skeleton of the waterway as you can see it in the capture below : http://old.nabble.com/file/p30413623/skeleton5.jpg regards, Jérôme -- View this message in context: http://old.nabble.com/Diagram-of-Vorono%C3%AF-to-Squelettisation-of-polygon-tp30413623p30413623.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Georepublic UG Georepublic Japan eMail: daniel.ka...@georepublic.de Web: http://georepublic.de ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Routing with POSTGIS question
For pgrouting you need to have a suitable road network and so you have to use osm2pgrouting for example to split your long OSM roads. If you want to know how cloudmade does, you probably need to ask them. But I don't think they take a raw OSM file as it is either. Daniel PS: you probably better ask on the pgRouting mailing list if you have pgRouting related questions -- Georepublic UG Georepublic Japan eMail: daniel.ka...@georepublic.de Web: http://georepublic.de 2010/8/16 bdair2002 bdair2...@gmail.com Hello Guys, I have used pgrouting with postgis, but I have noticed, when I downloaded the maps from openstreemaps, I have noticed they don't use segments for the street meaning, the street has the same name in each intersection, and no start and end for the street. My question is there a way to calculate the route when the table do not have start/ end point for each edge in the street? or should I convert it using pgrouting to make a road network? and how does cloudmade calculate their routes if they don't have Edge points? Thanks in advance. -- View this message in context: http://old.nabble.com/Routing-with-POSTGIS-question-tp29444252p29444252.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ 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] Routing with POSTGIS question
I haven't heard about shp2pgrouting. I think you need to download the .osm file from cloudmade servers instead. Another way to import OSM data is osm2po (osm2po.de). It can handle larger amount of data and works also on Windows. Daniel 2010/8/16 bdair2002 bdair2...@gmail.com Thank you very much, the reason I didn't ask in Pgrouting forum is that I wanted another way to calculate route, when I downloaded the maps from cloudmade, the roads wasn't in network shape, so I was thinking how do they do their route, probably their road network is private. on another topic, I see that osm2pgrouting works on linux (tested), and I prefer to work with shp files since I did all the steps before, can you point me to shp2pgrouting, I know it is possible using ARCGIS it self, but I heard there is a tool called shp2pgrouting, if you can point me to it, it would be great. Sorry I am asking in routing, I should ask this in pgrouting. Thanks in advance. Daniel Kastl-3 wrote: For pgrouting you need to have a suitable road network and so you have to use osm2pgrouting for example to split your long OSM roads. If you want to know how cloudmade does, you probably need to ask them. But I don't think they take a raw OSM file as it is either. Daniel PS: you probably better ask on the pgRouting mailing list if you have pgRouting related questions -- Georepublic UG Georepublic Japan eMail: daniel.ka...@georepublic.de Web: http://georepublic.de 2010/8/16 bdair2002 bdair2...@gmail.com Hello Guys, I have used pgrouting with postgis, but I have noticed, when I downloaded the maps from openstreemaps, I have noticed they don't use segments for the street meaning, the street has the same name in each intersection, and no start and end for the street. My question is there a way to calculate the route when the table do not have start/ end point for each edge in the street? or should I convert it using pgrouting to make a road network? and how does cloudmade calculate their routes if they don't have Edge points? Thanks in advance. -- View this message in context: http://old.nabble.com/Routing-with-POSTGIS-question-tp29444252p29444252.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ 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 -- View this message in context: http://old.nabble.com/Routing-with-POSTGIS-question-tp29444252p29445618.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ 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] pgrouting Installation
Hi Rakesh, I think for Windows you should try to install some binary version of pgRouting. http://pgrouting.postlbs.org/wiki/pgRoutingDownload#WindowsBinaries: Best regards, Daniel 2010/4/13 rakesh modi rakesh.modi1...@gmail.com Hi, I am newer to use postgres and pgrouting. I am going to install pgrouting on windows machine but when i install CMake it ask for Source code i don't know what it should be. Thanking you in anticipation. Looking forward for reply. Rakesh ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Georepublic UG Georepublic Japan eMail: daniel.ka...@georepublic.de Web: http://georepublic.de ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] New project for driving directions using postgis / pgrouting
Hi Olivier, Stephen used pgRouting and implemented driving directions. You can see his demo here: http://gis.imaptools.com/routing/leaddog/?zoom=10lat=33.85667lon=35.52978layers=B0TTTFstart=35.492313%2033.826188stop=35.595811%2033.906827method=STSlang=eng The problem with driving directions is, that its implementation depends very much on the data you have. For Japanese data for example road names are usually missing, so you need to think about a different way how to describe the route. Also some data sets provides more some data sets have less attributes. pgRouting is only the library to provide shortest path search functions. Here is a wiki page about driving directions of the OpenStreetMap project. http://wiki.openstreetmap.org/wiki/Sample_driving_instructions If you're going to use OSM data, this might be helpful. I must admit that some instructions on the pgRouting wiki regarding driving directions with different data sets would be nice. Daniel 2010/2/24 Martin Fafard martin.faf...@geoprojection.com Hi Snowmobile trails, Quebec: http://www.fcmq.qc.ca/cartes/en/ Martin F Olivier Kouame a écrit : Hi all, Sorry if this has been brought up before but I've been looking for a project that provides driving directions on top of postgis/pgrouting. I've found quite a few discussions about it and sites that have implemented it but couldn't find anything actually production-ready. I'm thinking of starting a new project to provide this functionality and would really appreciate any suggestions / advice / code examples that would help get this started. Or if anyone knows of an existing project that provides this, even better! Thanks ___ postgis-users mailing listpostgis-us...@postgis.refractions.nethttp://postgis.refractions.net/mailman/listinfo/postgis-users -- Ce message entrant est certifie sans virus connu. Analyse effectuee par AVG - www.avg.fr Version: 9.0.733 / Base de donnees virale: 271.1.1/2705 - Date: 02/23/10 02:34:00 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Georepublic UG (haftungsbeschränkt) Salzmannstraße 44, 81739 München, Germany eMail: daniel.ka...@georepublic.de Web: http://georepublic.de Tel: +49 (089) 4161 7698-1 Fax: +49 (089) 4161 7698-9 Commercial register: Amtsgericht München, HRB 181428 CEO: Daniel Kastl ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Shortest Path Dijkstra
How about looking at pgrouting.postlbs.org? And if you still have a question then you better aks the pgRouting mailing list or the forum there. Daniel Ravi schrieb: Hi, pl help me install Pgrouting (Shortest Path Dijkstra) on a working PostGIS. Any document or pointers for the process.. cheers Ravi Kumar Looking for local information? Find it on Yahoo! Local http://in.local.yahoo.com/ ___ 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] Road Network Graph creation
Hi Jaak, If you need to get the network graph of OSM data you can use osm2pgrouting: http://pgrouting.postlbs.org/wiki/tools/osm2pgrouting Currently it doesn't work with large amount of data. Contributions are always welcome ;-) Daniel Jaak Laineste schrieb: Hi, This function assumes that the road network is already segmented. If I have otherwise topologically good network, but without properly segmented streets (e.g. like in OSM Shapefiles), then it does not work. Best solution would be to have similar extended postgis or pgrouting function to do it. Or is there any other good (and free) tool to do it? /Jaak Re: [postgis-users] Road Network Graph creation Daniel Kastl Sun, 28 Jun 2009 17:17:33 -0700 You need to look for the assign_vertex_id function of pgRouting. This function creates a network topology. Daniel Ben Madin schrieb: Short Answer - Yes - but of course it depends on the quality of your shapefile as to how useful it is. Have a look at : http://pgrouting.postlbs.org/ cheers Ben On 28/06/2009, at 11:09 PM, Sandeep Kumar Jakkaraju wrote: Hello All Is there any way I can create a road network graph (nodes,edges) from a road shapefile ? -- Thanks Regards Sandeep Kumar Jakkaraju ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users /Jaak Laineste j...@nutiteq.com www.nutiteq.com Phone: +372 777 8800 Mobile: +372 509 2586 Skype: nutiteq ___ 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] Road Network Graph creation
You need to look for the assign_vertex_id function of pgRouting. This function creates a network topology. Daniel Ben Madin schrieb: Short Answer - Yes - but of course it depends on the quality of your shapefile as to how useful it is. Have a look at : http://pgrouting.postlbs.org/ cheers Ben On 28/06/2009, at 11:09 PM, Sandeep Kumar Jakkaraju wrote: Hello All Is there any way I can create a road network graph (nodes,edges) from a road shapefile ? -- Thanks Regards Sandeep Kumar Jakkaraju ___ 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] Shortest path around polygons
Hi, First I agree with Ralf and would also use pgRouting for this. I think you have a network table and a polygon table, right? When you search for the shortest path from A to B with pgRouting, you usually won't load the complete data but a bounding box area that includes A and B. You could then further exclude network links that are within your polygons and search the shortest path through your reduced network. Daniel tommy408 schrieb: Thank you for your help. If my polygon table is huge, it would have to consider all the polygon in space? Is there a way I can narrow down only polygons are that in the way between point A and B? Suhr, Ralf wrote: Solving your problem is not realy hard but time expensive. - install pgRouting - create one table for the polygons - create one table for holding linestrings - write a function that: - build all possible lines in one polygon (makeline from cross join points from polygon) - remove lines wich are outside the polygon - write lines with extra attribute polygon_id in the linestring table - run add_vertices (pgRouting function) - create temporary table for your two points (linestring geometry) - rerun the function for creating linstrings with the two points and all polygon points - finaly run shortest_path( join two tables ) -Ursprüngliche Nachricht- Von: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] Im Auftrag von tommy408 Gesendet: Donnerstag, 25. Juni 2009 15:35 An: postgis-users@postgis.refractions.net Betreff: [postgis-users] Shortest path around polygons I'm really new to PostGIS. I need to solve this problem. Find the shortest path around polygons from point A to point B. Here is a better description: http://alienryderflex.com/shortest_path/ How can I do it with PostGIS. Or if you can give me some hints to narrow my search. Thank you. -- View this message in context: http://www.nabble.com/Shortest-path-around-polygons-tp24203378p24203378.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ 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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] identfying a nearest point
Hi, This is the SQL I tried with: select v.*, c.gid from vertices_tmp v, customer_location c where c.gid=1 and st_expand(setsrid(((select the_geom from customer_location where gid=1)),4326), 1000) setsrid(v.the_geom,4326) order by distance(setsrid((select the_geom from customer_location where gid=1),4326),setsrid(v.the_geom,4326)) asc limit 1; Without having tested this 1 looks very suspicious. This value is in the same projection as your geometry is set: 4326 4326 is in degree, so you could try it with 0.1 for example. Daniel ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PgRouting schema qualified tables etc.
Hi Horst, Thank you for this comment with code! If you agree then I will move it to the pgRouting TRACK and create a ticket. Or do you like to do this yourself? Daniel Düster Horst schrieb: Hi I played a little bit with pgrouting to build a routing plugin client for QGIS. In principle it works fine but I found out some annoyances: 1. The functions like shortest_path, dijkstra etc. don't respect schema qualified tables. 2. always it is supposed and hard coded that GID is the primary key column of the table. 3. always it is supposed and hard coded that the_geom is the column name of the geometry column. I have attached a modified version of the dijkstra_sp function to make this function more generic. Perhaps you can modify all other dependencies of the pgRouting functions in this way. Regards Horst Dr. Horst Düster GIS-Koordinator, Stv. Amtschef Kanton Solothurn Bau- und Justizdepartement Amt für Geoinformation SO!GIS Koordination Rötistrasse 4 CH-4501 Solothurn Telefon ++41(0)32 627 25 32 Telefax ++41(0)32 627 22 14 mailto:[EMAIL PROTECTED] http://www.agi.so.ch ___ 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] PgRouting schema qualified tables etc.
Oh, good point! ... and I already thought this questions sounds familiar. Thank you for the hint. Daniel Pedro Doria Meunier schrieb: Hi, Please see: http://pgrouting.postlbs.org/ticket/133 BR, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Thursday 11 December 2008 10:17:24 am Düster Horst wrote: Hi I played a little bit with pgrouting to build a routing plugin client for QGIS. In principle it works fine but I found out some annoyances: 1. The functions like shortest_path, dijkstra etc. don't respect schema qualified tables. 2. always it is supposed and hard coded that GID is the primary key column of the table. 3. always it is supposed and hard coded that the_geom is the column name of the geometry column. I have attached a modified version of the dijkstra_sp function to make this function more generic. Perhaps you can modify all other dependencies of the pgRouting functions in this way. Regards Horst Dr. Horst Düster GIS-Koordinator, Stv. Amtschef Kanton Solothurn Bau- und Justizdepartement Amt für Geoinformation SO!GIS Koordination Rötistrasse 4 CH-4501 Solothurn Telefon ++41(0)32 627 25 32 Telefax ++41(0)32 627 22 14 mailto:[EMAIL PROTECTED] http://www.agi.so.ch ___ 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 topology
Nandorov schrieb: Hi, How can i make a topology in PostGIS? Best regards Hi, Not sure whether this is exactly what you're looking for, but pgRouting has a function to create a network topology for routing. The function is called name is assign_vertex_id. (http://pgrouting.postlbs.org/wiki/Workshop-PrepareDikstra) Daniel ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] pgrouting
Hi, If you have no idea what to start with I recommend you to take a look at the tutorial: http://pgrouting.postlbs.org/wiki/WorkshopFOSS4G2007 Daniel searchelite schrieb: Hi all..can anyone tell me about the pgrouting.. I have roads table, vehicle point table and emergency point table.. I want to calculate shortest route where vehicle point as the source and emergency point as a target.. Thank you ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] CGAL and PostGIS
João Gonçalves schrieb: Hi! Is there a way to use CGAL's algorithm library with PostgrSQL/PostGIS data? Is there any project, ideas or other stuff attempting to do it? What would this require in terms of programming skills? I'm particularly interested in binding CGAL straight skeleton algorithm with PostGIS but I lack the knowledge to do this! Any constructive solution to this question? Thanks in advance ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Hi João, pgRouting (http://pgrouting.postlbs.org/) uses the alpha-shape algorithm of the CGAL library for its driving distance calculation. This is not the perfect solution, because this part of CGAL is released under QPL, which is in general incompatible with GPL ... except you are the copyright owner and add an exception. http://www.cgal.org/license.html -- see GPL-QPL Incompatibility Note If possible I would avoid using CGAL. It can be also annoying to install (my personal experience). Daniel -- Daniel Kastl Orkney, Inc. MM Park Building 13F 3-6-3 Minatomirai, Nishi, Yokohama, Japan TEL +81-45-228-3320 FAX +81-45-228-3321 [EMAIL PROTECTED] www.orkney.co.jp ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Routing
Hi Andrea, Maybe the pgRouting Forum is a better place to ask this question: http://pgrouting.postlbs.org/discussion (For sure I would have answered you there, too) Kanagawa table provided as example app, but I was guessing what makes a table suitable for being routed. For routing with Dijkstra algorithm you only need a valid road network with information about source (start) and target (end) of each link. That's all, and you even don't need something like a geometry column. Kanagawa has a gid, a source and a target fields, a length field. source and target represents the nodes, while gid represents the branches (obviously there's a geometry column). Btw, in the tables I found of my town, Padova, I have found no one of these fields or similar, even if who provided it said it was topologically correct. At this point I am missing what exactly this means, if not that the rapresented geometry is a network of branches and nodes. If you already have data that has source/target information in the road link table, then you already have a valid network topology and don't need to create it. To be able to use heuristic Algorithm like Astar for example, you need geometry information as well. Did this explanation help? Daniel Thanks Andrea Maschio http://www.superandrew.it http://www.superandrew.it/ ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Daniel Kastl Orkney, Inc. MM Park Building 13F 3-6-3 Minatomirai, Nishi, Yokohama, Japan TEL +81-45-228-3320 FAX +81-45-228-3321 [EMAIL PROTECTED] www.orkney.co.jp ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users