2,387 reputation
530
bio website
location Berlin, Germany
age
visits member for 2 years
seen 3 hours ago

GIS Developer at allryder


Mar
19
comment How to select distinct geometries and ids with PostGIS?
Thanks for sharing. However only their geometry is unique. In my case it is only point features. So the bounding box should be fine.
Mar
17
accepted ST_LineMerge doesn't return LineString
Mar
17
comment ST_LineMerge doesn't return LineString
Interesting! Is there a way that I can remove/ignore the last decimal?
Mar
17
revised ST_LineMerge doesn't return LineString
added 24 characters in body
Mar
17
asked ST_LineMerge doesn't return LineString
Mar
16
accepted How to select distinct geometries and ids with PostGIS?
Mar
16
asked How to select distinct geometries and ids with PostGIS?
Mar
15
answered problem in PostGIS Name of the system used for Points and how to get distance between to point?
Mar
13
accepted How to order points along a line?
Mar
12
comment How to order points along a line?
@dassouki I updated my question and added software. However I also appreciate general ideas/algorithms on how to solve it that are software independent.
Mar
12
revised How to order points along a line?
added 107 characters in body; edited tags
Mar
12
revised How to order points along a line?
added 877 characters in body
Mar
12
asked How to order points along a line?
Mar
12
accepted How to check if line goes through point with PostGIS
Mar
12
comment How to check if line goes through point with PostGIS
@JohnBarça I added some sample data. Your question made me realise that it is not possible. I zoomed really far into the sample data, and the point actually is not on the line. So a workaround is necessary.
Mar
12
revised How to check if line goes through point with PostGIS
added 523 characters in body
Mar
12
revised How to check if line goes through point with PostGIS
deleted 4 characters in body
Mar
12
comment How to check if line goes through point with PostGIS
I am using POSTGIS="2.1.5 r13152" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24" LIBXML="2.9.2" LIBJSON="UNKNOWN" RASTER
Mar
12
comment How to check if line goes through point with PostGIS
Thanks @zimmi for the answer. Though I am looking for a solution without buffer, since this might cause wrong intersections.
Mar
12
revised How to check if line goes through point with PostGIS
added 94 characters in body