370 reputation
117
bio website jordanarseno.com
location Vancouver, BC, Canada
age 27
visits member for 4 years
seen May 2 at 21:26

#!/bin/jordanarseno

I make Resider & play engineer @ SemiosBIO Technologies Inc.

We're always looking for talent. Send resumes to web [at] semios.com

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

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


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. ;)