756 reputation
215
bio website http://-
location Switzerland
age 26
visits member for 2 years, 5 months
seen Apr 15 at 12:37

Jan
10
answered How to calculate Polyline length in kilometres without changing projection from WGS84 (using ArcObjects)?
Jan
3
comment Mapnik TextSymbolizer not randomly missing out text
Didn't test with any other version and I didn't ask on the mapnik mailing list. But if I don't get an answer here, I'll drop a mail...
Jan
3
asked Mapnik TextSymbolizer not randomly missing out text
Nov
24
awarded  Self-Learner
Nov
24
comment Is Postgres and Disk IO limiting pgRoutings performance?
I can do that. But my problem is how to monitor and push to a file all the relevant data on ubuntu. If you have a particular command in mind, I'll make the test...
Nov
24
comment Is Postgres and Disk IO limiting pgRoutings performance?
pgRouting is based on boostlib. And it is a single core implementation. So no gain with more cores, checked this out as well...
Nov
24
revised Is Postgres and Disk IO limiting pgRoutings performance?
Screenshots added...
Nov
24
comment Is Postgres and Disk IO limiting pgRoutings performance?
Yeap! Good points here! I did that last night, and checked the source code as well, the shared_mem and work_mem parameters are crucial. But as soon as the dataset can be kept in ram, there is no more performance gain by swapping to ramdrive! Did that as well, with removing caches etc. And then the depending parameters become truely visible...
Nov
23
asked Is Postgres and Disk IO limiting pgRoutings performance?
Nov
23
answered Is Postgres and Disk IO limiting pgRoutings performance?
Nov
17
awarded  Yearling
Jul
5
asked 'For each' type loop in postgres
Jul
5
answered How to calculate x, y, z, m in Postgis
Jul
2
comment How to calculate x, y, z, m in Postgis
Your problem is, that st_x() works with a single point. Your current geometry object is a MultiLineStringZM. What is the 'idea', 'target' of using the function..., please elaborate.
Jun
19
awarded  Nice Answer
Jun
10
accepted math related sum distance problem (TSP content)
Jun
7
asked math related sum distance problem (TSP content)
Apr
19
awarded  Caucus
Feb
11
accepted How do I compare two maps to determine which is better?
Feb
4
comment How do I compare two maps to determine which is better?
Unfortunatly, I started to make this comparison based on the fact, that OSM and other OpenSource maps are really not as accurate as we seem to think. But the input on using satellite images is a lead to follow!