350 reputation
115
bio website jordanarseno.com
location Vancouver, BC, Canada
age 26
visits member for 3 years, 5 months
seen Aug 28 at 20:19

#!/bin/jordanarseno

I make resider.ca & other PHP + CodeIgniter web apps -- circle me on G+

⚫ east coast (maratimer)
⚫ engineer
⚫ ISTP
⚫ entrepreneur
⚫ horticulture
⚫ skate & snow
⚫ music ♫
⚫ ☮
⚫ science

(╮°-°)╮┳━┳      (╯°□°)╯┻━┻


May
7
answered Snapping start- and end nodes of lines to other lines in PostGIS
May
6
asked javascript WKB to WKT 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. ;)
Apr
12
comment Force dimensionality with shp2pgsql
man shp2pgsql makes no mention of this parameter, whereas shp2pgsql --help does. Thanks. The output from the console is still PolygonZ... which is confusing -- nevertheless, Postgres doesn't complain. Cheers.
Apr
12
accepted Force dimensionality with shp2pgsql
Apr
12
asked Force dimensionality with shp2pgsql