Reputation
2,916
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
8 16
Impact
~138k people reached

2d
comment Converting shapefile to postgis without giving bounding box
small correction. Shapefiles supports 2d,3d (z or m ) and 4d ( z and m) geoms.
Apr
15
reviewed Approve Draw raster on top of a Leaflet map
Apr
11
revised What is the fastest way to iterate through a list of features?
spelling
Apr
8
comment Finding the shortest path between points to LineString PostGIS
could traveling salesman solver be the answer? You need graph-table where you have all line combinations between points...
Apr
3
awarded  Notable Question
Mar
21
reviewed Approve How to set the visibility range of layers on CartoDB using CartoCSS?
Mar
21
reviewed Approve Accessing layer's visibility presets?
Mar
21
reviewed Approve Is there a way to turn a data frame off in ArcMap 10.2?
Mar
21
reviewed Approve How to display street names from OS StreetAny layer?
Mar
21
reviewed Approve QGIS tiff image loaded but not visible
Mar
21
reviewed Approve OpenLayers 3 Layer Visibility Checkbox
Mar
21
reviewed Approve Leaflet geoJSON point layer with divIcons (SVGs) how to toggle visiblity?
Mar
14
awarded  Yearling
Feb
26
reviewed Approve Compile QGIS / Can't find Qt Cryptographic Architecture
Feb
26
reviewed Approve transformations from a sphere using R for raster and polygon data
Feb
26
reviewed Approve Using Quality Control process for MODIS Leaf Area Index?
Feb
26
reviewed Approve What can I use to have aerial imaging delivered via slippy URL format
Feb
26
reviewed Approve How can you align two shapefile layers in QGIS
Feb
11
comment How to snap lines to points automatically?
select p1.id id , ST_Snap(p1.geom, p2.geom, 2) as geom into newpipes from pipes p1, pipes p2 where p1.id != p2.id . that probably wont work, but if you have manhole centerpoints then i would test something like this : select p1.id, ST_Snap(p1.geom,m.geom,2.2 ) FROM pipes p1, manholes m , trying to decrease tested area using " p1.geom && m.geom " (boundingbox test) may or may not help ( it might need st_extend + st_buffer . i havent touched postgis for while
Feb
11
comment snapping line nodes to points
Are you doing select in qgis or postgis , if in postgis you just select data, you do not update it, so add select .. into snapped_table... code