345 reputation
114
bio website jordanarseno.com
location Vancouver, BC, Canada
age 26
visits member for 3 years, 2 months
seen Jul 20 at 18:31

#!/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
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
Apr
2
comment OpenStreetMap Neighborhood Boundaries
FYI -- their footer states: These data are freely available for academic and other non-commercial use. Redistribution, or commercial use, is not allowed without prior permission.
Jan
24
awarded  Nice Question