Timeline for How to polygonize using GeoDjango and PostGIS?
Current License: CC BY-SA 3.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 31, 2016 at 6:37 | comment | added | QwiglyDee | in fact, with openstreetmap database, I had to use following sql: UPDATE relations as r set geometry=( SELECT st_multi(st_union(geom)) FROM ( SELECT (st_dump(ST_Polygonize(w.linestring))).geom FROM ways as w JOIN relation_members as m ON m.member_id = w.id WHERE m.member_type='W' and m.relation_id = r.id ) as nest ) WHERE r.id=%(id)s and execute it as raw sql, using cursor.execute | |
| Mar 29, 2016 at 8:22 | history | answered | yellowcap | CC BY-SA 3.0 |