Changes between Version 2 and Version 3 of UsersWikiSimplifyWithTopologyExt

Timestamp:

Apr 10, 2012, 9:48:07 AM (12 years ago)

Author:

nicolasribotosgeo

Comment:

—

UsersWikiSimplifyWithTopologyExt

@@ -25 +25 @@
 #!sh
 shp2pgsql -IiD -g geom -s 2154 DEPARTEMENT.SHP departement | psql
+
 }}}
 
@@ -48 +49 @@
 -- adds the new geom column that will contain simplified geoms
 alter table new_dept add column simple_geom geometry(POLYGON, 2154);
+
 }}} 
 
@@ -73 +75 @@
        from topo1.edge_data
 ) as foo;
+
 }}}
 
@@ -87 +90 @@
 where st_intersects(d.geom, sf.geom)
 and st_area(st_intersection(sf.geom, d.geom))/st_area(sf.geom) > 0.5;
+
 }}}