Reputation
370
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 17
Impact
~7k people reached

  • 0 posts edited
  • 3 helpful flags
  • 79 votes cast
May
18
accepted Geometry has incorrect latitude-longitudes
May
18
asked Geometry has incorrect latitude-longitudes
May
7
awarded  Citizen Patrol
May
7
answered Snapping start- and end nodes of lines to other lines in PostGIS
May
6
asked WKB to WKT JavaScript function
May
5
awarded  Tumbleweed
May
1
comment How to minimize the number of nodes in a polygon?
I should add that PostGIS has ST_SimplifyPreserveTopology which implements the Douglas-Peucker algo. Thx!
Apr
29
accepted Finding polygon parents
Apr
29
comment Finding polygon parents
Got it with update my_table a set parent = b.id from my_table b where ST_Contains(b.the_geom, a.the_geom) AND a.id != b.id;
Apr
29
comment Finding polygon parents
This is nearly perfect. Thanks! I'd also like to store this. How can I modify it to update the parent column?
Apr
29
revised Finding polygon parents
added 12 characters in body
Apr
29
revised Finding polygon parents
edited title
Apr
29
asked Finding polygon parents
Apr
28
comment How to combine stacked polygons within a shapefile?
Are all of these polygons contained in a single vector layer?
Apr
28
awarded  Critic
Apr
23
awarded  Caucus
Apr
18
accepted How to minimize the number of nodes in a polygon?
Apr
13
asked How to minimize the number of nodes in a polygon?
Apr
12
awarded  Commentator
Apr
12
comment Force dimensionality with shp2pgsql
Nevermind, the PolygonZ indicates the Shapefile type... which makes sense. ;)