154 reputation
11
bio website
location Berlin
age
visits member for 1 year, 8 months
seen Jun 29 at 15:47

Jul
2
awarded  Curious
May
6
awarded  Popular Question
Mar
19
awarded  Tumbleweed
Mar
13
awarded  Critic
Mar
13
revised pgrouting shortestpathfromAtoB multiple pairs
added 693 characters in body
Mar
12
revised pgrouting shortestpathfromAtoB multiple pairs
added 45 characters in body
Mar
12
asked pgrouting shortestpathfromAtoB multiple pairs
Feb
27
accepted Distance calculation PostGIS
Feb
26
answered Distance calculation PostGIS
Feb
26
comment Distance calculation PostGIS
Hi notkilroy, thanks for your suggestion. I actually use the following to the order as you proposed. But how do I have to write to get the first row of each h_key? The SQL: SELECT h.h_key, b.kat, b.bhfname, St_distance_sphere(h.geom, b.geom) min FROM house h, at_bhf_classified b WHERE St_distance_sphere(h.geom, b.geom) < 25000 AND b.kat IN ( 1, 2 ) ORDER BY h.h_key, b.kat, min Thanks Carsten
Feb
24
asked Distance calculation PostGIS
Feb
24
accepted How to use osm2po to solve TSP
Feb
11
comment How to use osm2po to solve TSP
Hi Brad, this post leads me to the assumption: gis.stackexchange.com/questions/29530/…
Feb
11
asked How to use osm2po to solve TSP
Jan
13
accepted Use field calculator in QGIS so get number of points in polygone and store it in attribute table
Jan
13
comment Use field calculator in QGIS so get number of points in polygone and store it in attribute table
Thanks. But this solution creates a completely new layer. There is no possibility to write it into the existing shapefile?
Jan
13
asked Use field calculator in QGIS so get number of points in polygone and store it in attribute table
Dec
11
comment Create multi-line from point in PostGIS
Well, as written above, I had to try to get some "island id" group on.
Dec
11
comment Create multi-line from point in PostGIS
Thanks. It was really hard work (I followed your advice of getting some "island ids"), had to snap the points etc. Well I managed to "rescue" most of the polygons but some are such a mess that it won't be possible to re-modell them. Thanks for your help!
Dec
11
accepted Where can I find a good Sextante Modeller tutorial?