Reputation
2,838
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
6 16
Newest
 Yearling
Impact
~121k people reached

Feb
1
reviewed Approve How to pass polygon to query.geometry with ArcGIS API for JavaScript
Jan
28
comment QGIS 2.6 simplify a road network to obtain the intersections
One solution is to calculate number of lines which intersection points touch, when number >2 it is road intersection. code is something like (' SELECT i.id, count(l.id) cnt from lines l , points i where ST_Intersects(i.geom , l.geom) GROUP BY i.id, l.id )
Jan
28
revised Regenerate Geowebcache Tiles on PostGIS change
typo
Jan
26
reviewed Approve I want to use Google map in OpenLayers3
Jan
11
comment Removing pseudo nodes from PostGIS database using ST_ModEdgeHeal()?
ST_ModEdgeHeal() is part of PostGIS topology extension, where pgr_* is part of Pgrouting extension. more about postgis.net/docs/manual-2.2/Topology.html,
Dec
28
comment How to calculate multiple distances between set of points and vector grid in PostGIS?
so let see if i understand this right. you have hexa, road and target tables ? and you have created topology for roads.
Dec
18
comment How to calculate multiple distances between set of points and vector grid in PostGIS?
gis.stackexchange.com/questions/74564/… could that be useful in your case ?
Nov
30
reviewed Approve how to display simple arrow on the map in R using Leaflet
Nov
27
reviewed Approve Error adding row - sequence size must match size of row
Nov
19
comment pgRouting: weight routes with similar attributes higher
i think you need to have 2 cost columns in routing table , one is calculated so it prefers A attribute (CASE WHEN B=x then -1 ..) and other is calculated using B, then you need make shortest distance query twice to get best route.
Nov
18
reviewed Approve How to create a chart of elevation using points?
Nov
16
reviewed Approve Viewshed Analysis - use DSM or DTM?
Nov
12
comment Seeking GPS device for vehicle tracking?
well, you need grps/3G/4g modem there anyway, so it could be good option. You get messengers, maps , navgation there in same package
Nov
11
comment Compute visibility graph on sphere
does "iterate over all pairs" mean that you have FOR loop in procedure which test if one line intersct all polygons?. If so it is (probably) faster just create linestring table with all possible combinations and do one query where you test if line intersects polygon table
Nov
6
revised QGIS : Creating point feature from Lat, Lon SQL Server 2008R2 data import
explained QGIS only way
Nov
6
answered QGIS : Creating point feature from Lat, Lon SQL Server 2008R2 data import
Sep
16
comment How to check overlap between two sets of Linestrings using postgis
boolean ST_Overlaps(geometry A, geometry B); see postgis.org/docs/ST_Overlaps.html
Sep
8
comment Spatial correlation using QGIS?
no idea how vector grid should work, but if you change project coordinate system to something that uses meters as units and after that create vector grid. I assume that wgs84 - utm36 uses degrees as units
Aug
26
comment Sql Query in Postgresql
@John Barça , That is reason why i left comment also your answer seems to be correct
Aug
26
comment Sql Query in Postgresql
why not something like : WHERE ST_Equals(ST_Startpoint(r.geom),e.geom) OR ST.Equals(ST_Equals(r.ST_Endpoint(r.geom),e.geom) (if both geoms are in same srid)