36 reputation
6
bio website
location Quebec
age
visits member for 2 years, 4 months
seen Nov 21 '13 at 18:35

Studying in Geomatic applied to Environnement, Sherbrooke, Qc.

I'm new to GIS and programming, but I learn fast and I'm an hard worker ;)


Sep
24
awarded  Autobiographer
Oct
8
awarded  Scholar
Oct
8
accepted Improve performances on distance coverage routing - PostgreSQL
Jul
18
awarded  Teacher
Jul
17
awarded  Supporter
Jul
17
answered Improve performances on distance coverage routing - PostgreSQL
Jul
17
comment Improve performances on distance coverage routing - PostgreSQL
Well... the result I want will look almost exactly as your map, but I would use other criteras. The problem here though is to build the algorithm to do so on a postgreSQL DB, using pgRouting (I already got a license of arcGIS which does exactly this, but we want to go opensource)
Jul
16
comment Improve performances on distance coverage routing - PostgreSQL
Hum, no, I really need to know every routes that can be reached, and to what length, from the startpoint over the given distance. Shortest path would only give one, and needs a endpoint... Sorry for my ignorance, but... RW?
Jul
16
comment Improve performances on distance coverage routing - PostgreSQL
Oh, and a problem that brings Driving_distance is that it stops on the fartest vertex it can on the network... while the real distance is very often not on a vertex, but on the line itself! (I hope I'm not just missing something here though!)
Jul
16
comment Improve performances on distance coverage routing - PostgreSQL
Well, it looks like it yes. I have to be able to point a fire station (for example) and get it's coverage for a given distance (let say, 10k, 15k...). So if we could switch the driving time of this to an effective distance, it would make it! Could you tell me more? (And I have to give that note: The problem is not the idea of the how to do it, but how to do it in a relatively fast way :) )
Jul
16
awarded  Editor
Jul
16
comment Improve performances on distance coverage routing - PostgreSQL
I added a case in the question (3rd picture) that shows a problem I think isochrones will give me. Am I wrong to think that in this case (above), the answer won't be precise?
Jul
16
comment Improve performances on distance coverage routing - PostgreSQL
I just added a comment in the question above answering the thing about Driving_distance, though it gave me an idea I'll put to the test tomorrow...
Jul
16
revised Improve performances on distance coverage routing - PostgreSQL
I lacked precision in my question!
Jul
14
awarded  Student
Jul
13
asked Improve performances on distance coverage routing - PostgreSQL