Changes between Version 2 and Version 3 of UsersWikiSimplifyWithTopologyExt
- Timestamp:
- 04/10/12 09:48:07 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TabularUnified UsersWikiSimplifyWithTopologyExt
v2 v3 25 25 #!sh 26 26 shp2pgsql -IiD -g geom -s 2154 DEPARTEMENT.SHP departement | psql 27 27 28 }}} 28 29 … … 48 49 -- adds the new geom column that will contain simplified geoms 49 50 alter table new_dept add column simple_geom geometry(POLYGON, 2154); 51 50 52 }}} 51 53 … … 73 75 from topo1.edge_data 74 76 ) as foo; 77 75 78 }}} 76 79 … … 87 90 where st_intersects(d.geom, sf.geom) 88 91 and st_area(st_intersection(sf.geom, d.geom))/st_area(sf.geom) > 0.5; 92 89 93 }}} 90 94