<!DOCTYPE html><html><head>
<style type="text/css">"body { font-family:'Times New Roman'; font-size:13px"}</style>
</head>
<body><div>> Chopping polygons is pretty simple, with a grid & st_intersection()</div><div>
<div><br></div><div>Just for interest, I posted a method for gridding/chopping polygons the other day in a set of comparative posting with SQL Server and Oracle.</div><div><br></div><div>http://www.spatialdbadvisor.com/postgis_tips_tricks/258/gridding-a-geometric-object</div></div><div>There may be faster ways of doing this, but my attempt was about functionality not speed. Also, the approach here is not optimized for a single<br></div><div>polygon: it is designed to use the same grid no matter how many polygons etc are put into the chopper.</div><div><br></div><div>regards</div><div>Simon</div><div id="M2Signature"><div>-- </div><div>Holder of "2011 Oracle Spatial Excellence Award for Education and Research."<br>SpatialDB Advice and Design, Solutions Architecture and Programming,<br>Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional<br>Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.<br>39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.<br>Website: www.spatialdbadvisor.com<br> Email: simon@spatialdbadvisor.com<br> Voice: +61 362 396397<br>Mobile: +61 418 396391<br>Skype: sggreener<br>Longitude: 147.20515 (147° 12' 18" E)<br>Latitude: -43.01530 (43° 00' 55" S)<br>GeoHash: r22em9r98wg<br>NAC:W80CK 7SWP3</div></div></body></html>