<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><br>Hi Peter, <br><br>It sounds like you are wanting to tile your polygons. Not really ideal, as each polygon is rendered via tiles, so you need to render them without borders to hide the tiles, then often plot the border as well, which still has all the vertices. Lots more work.<br><br>You might look at simplifying your polygons to reduce the number of vertices in each. If you
manage your data topologically, this process will work better at
retaining shared boundaries.<br><br>If you can use Google to provide vector zoom layers, then as you zoom in you can get less & less simplified versions... just like pyramid'ed rasters. Zoomed out you can't see so don't provide the unnecessary detail.<br><br>I don't use Google myself, the licence terms are too restrictive for much of the data I work with, so can't say how well this works in a Google environment.<br><br>Brent Wood<br><br><br>--- On <b>Fri, 3/4/11, Peter N. Schweitzer <i><pschweitzer@usgs.gov></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Peter N. Schweitzer <pschweitzer@usgs.gov><br>Subject: [postgis-users] A way to split polygons?<br>To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><br>Date: Friday, March 4, 2011, 9:44 AM<br><br><div class="plainMail">At <a href="http://tin.er.usgs.gov/geology/state/"
target="_blank">http://tin.er.usgs.gov/geology/state/</a> and pages below it, I provide<br>geologic map units for US states in KML for use within Google Earth.<br>These are stored in PostgreSQL (9.0.2) with PostGIS (1.5.2). My problem<br>is that many of the larger geologic units are represented as polygons that<br>have a large number of vertices, often with many interior rings. Google Earth<br>doesn't want to display polygons that have 100,000 vertices (I think the<br>actual limit is lower, but I don't know what it is.) So my geologic maps<br>have large irregular holes in them when viewed in Google Earth.<br><br>Is there a way, using PostGIS functions, to split these polygons so that<br>the resulting polygons have fewer vertices and thus would appear as expected<br>in Google Earth? It seems to me one possibility would be to intersect<br>these large polygons with Box2D's whose vertical dimensions were, say,<br>one or two
degrees. But I don't yet see how to carry this operation out.<br><br>Can anyone offer suggestions as to how this might be done?<br><br>Here are some of the characteristics of the data. The principal table<br>containing the polygons is named geol_poly; the field unit_link is a<br>relational key to other, more interesting data, and the_geom comes through<br>shp2pgsql.<br><br>select unit_link,ST_NPoints(the_geom) npt,ST_NumGeometries(the_geom) ng, ST_NumInteriorRings(the_geom) ni from geol_poly order by npt desc;<br> unit_link | npt | ng | ni<br>-----------------+--------+----+------<br> FLwater;0 | 451759 | 1 | 8945<br> PAPAa;6 | 319192 | 1 | 1235<br> PAPAcg;6 | 216653 | 1 | 925<br> ALwater;0 | 205251 | 1 | 108<br> OHPAc;0
| 201310 | 1 | 842<br> OHPAm;0 | 200763 | 1 | 895<br> OHPAap;0 | 196422 | 1 | 1207<br> MNOl;0 | 188753 | 1 | 107<br> MNCu;0 | 165061 | 1 | 86<br> TNObh;6 | 152421 | 1 | 825<br> PAPAp;6 | 144889 | 1 | 324<br> MOOjc;0 | 144721 | 1 | 144<br> MOMk;0 | 128731 | 1 | 290<br> WVPAk;0 | 128402 | 1 | 934<br> TXKed;0 | 124666 | 1 | 720<br> TNMfp;10 | 122021 | 1 | 117<br> OHMlc;0
| 116993 | 1 | 731<br> TNMfp;10 | 113034 | 1 | 406<br> MOOr;0 | 109195 | 1 | 136<br> PAPAm;6 | 105906 | 1 | 395<br> PAPAcc;6 | 105798 | 1 | 447<br> WVPAm;0 | 99944 | 1 | 474<br> CAQ;0 | 97086 | 1 | 455<br> WVPAc;0 | 94277 | 1 | 455<br> MNOm;0 | 93054 | 1 | 53<br> PAPPAw;0 | 89974 | 1 | 218<br> TNOca;6 | 89292 | 1 | 564<br> WVPAa;0 | 89182 | 1 | 504<br> MOOr;0
| 87103 | 1 | 171<br> MOOg;0 | 85660 | 1 | 277<br><br>Peter<br>-- Peter N. Schweitzer (MS 954, U.S. Geological Survey, Reston, VA 20192)<br>(703) 648-6533 FAX: (703) 648-6252 email: <a ymailto="mailto:pschweitzer@usgs.gov" href="/mc/compose?to=pschweitzer@usgs.gov">pschweitzer@usgs.gov</a><br><<a href="http://geology.usgs.gov/peter/" target="_blank">http://geology.usgs.gov/peter/</a>><br>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@postgis.refractions.net" href="/mc/compose?to=postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></div></blockquote></td></tr></table>