Reputation
11,302
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
18 34
Newest
 Nice Answer
Impact
~214k people reached

2d
awarded  Nice Answer
Apr
24
comment Error on ST_UNION: SSL SYSCALL error: EOF detected
Try doing it a county at a time. Out of memory should fail w/ an out of memory error though, not a crash.
Apr
20
awarded  Guru
Apr
17
revised Counting points within range using CartoDB?
added 21 characters in body
Apr
14
answered Counting points within range using CartoDB?
Apr
13
answered Clustering markers using quadtree
Apr
7
answered Postgis bounding box intersect vs polygon intersect
Mar
16
answered Find polygons that does not contain (any) polygons with PostGIS
Mar
16
answered Duplicate entries in table list when adding PostGIS layer in QGIS
Mar
15
awarded  Nice Answer
Mar
14
answered How to make Great Circle Arcs which look good on a Web Mercator map?
Mar
6
comment Unexpected results when using ST_Intersection for polygon features
Dimensional collapse during overlay could be causing slight overlaps to turn into boundary touches. Dunno, guessing. Perfection is not available :)
Mar
4
answered Unexpected results when using ST_Intersection for polygon features
Feb
27
answered PostGIS - st_intersects using polygons that cross antimeridan/equator
Feb
24
answered PostGIS, no use of gist for geometry column in a query
Feb
19
answered Error in transforming SRID in PostGIS 9.3
Feb
18
comment PostGIS Geography Query not working
If your data is already projected, then a simple: SELECT * FROM mytable WHERE ST_DWithin('...', geom, 5000) will work.
Feb
17
answered PostGIS Geography Query not working
Feb
5
answered Inconsistent results in ST_Distance
Feb
5
comment Inconsistent results in ST_Distance
Damn. Well, looking forward to the ticket.