Thanks for that info - it's something else to consider.<div><br></div><div>Conclusion: Google Earth cannot display GEOGRAPHY data that crosses that date line, without a hack such as making a table of split geographies.</div>
<div><br></div><div>Does anyone disagree? (please disagree...!)</div><div><br></div><div>Thanks, James<br><div><br><div class="gmail_quote">On 12 October 2012 17:47, Paul Ramsey-4 [via PostGIS] <span dir="ltr"><<a href="/user/SendEmail.jtp?type=node&node=5000515&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>></span> wrote:<br>
<blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Even if you split the shapes, GEarth renders polygons in a non-normal
<br>kind of way which you might find unacceptable
<br><br><a href="http://blog.opengeo.org/2010/08/10/shape-of-a-polygon/" rel="nofollow" link="external" target="_blank">http://blog.opengeo.org/2010/08/10/shape-of-a-polygon/</a><br><br>The quick fix is to render them as lines, not polygons. there's no fix
<br>to get them to fill using great circle edges, GEarth just doesn't work
<br>that way.
<br><br>P.
<br><br></div><div><div class="h5">On Fri, Oct 12, 2012 at 4:03 AM, iam_gilbey <<a href="http://user/SendEmail.jtp?type=node&node=5000464&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>> wrote:
</div></div><div><div><div class="h5"><div class='shrinkable-quote'><br>> I have many polygons, including several that cross the date line. They are
<br>> stored as GEOGRAPHY and work perfectly with PostGIS v2.0.1, PostgreSQL 9.1.3
<br>> on windows XP. I can serve this data using Geoserver (v2.1), and view it
<br>> using open layers, where the polygons crossing the date line render
<br>> correctly.
<br>>
<br>> I cannot however convert the data into KML (viewed in Google Earth 5.1), or
<br>> view it in Quantum GIS (v1.7), without the date line polygons being wrapped
<br>> around the earth.
<br>>
<br>> I appreciate that this isn't strictly a postGIS problem, however being faced
<br>> with the stark choice between splitting my data about the date line
<br>> (inelegant) or not using Google Earth (unacceptable to users), I don't know
<br>> where else to turn!
<br>>
<br>> Do you know of:
<br>> a) a way to get the data to render correctly in Google Earth; or
<br>> b) where else I should ask?
<br>>
<br>> Thanks!
<br>>
<br>>
<br>>
<br>> --
<br>> View this message in context: <a href="http://postgis.17.n6.nabble.com/Display-GEOGRAPHY-polygons-crossing-date-line-tp5000443.html" rel="nofollow" link="external" target="_blank">http://postgis.17.n6.nabble.com/Display-GEOGRAPHY-polygons-crossing-date-line-tp5000443.html</a></div>
> Sent from the PostGIS - User mailing list archive at Nabble.com.
<br>> _______________________________________________
<br>> postgis-users mailing list
<br></div></div>> <a href="http://user/SendEmail.jtp?type=node&node=5000464&i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" rel="nofollow" link="external" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a></div>_______________________________________________
<br>postgis-users mailing list
<br><a href="http://user/SendEmail.jtp?type=node&node=5000464&i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" rel="nofollow" link="external" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
<br>
<hr noshade size="1" color="#cccccc">
<div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://postgis.17.n6.nabble.com/Display-GEOGRAPHY-polygons-crossing-date-line-tp5000443p5000464.html" target="_blank" rel="nofollow" link="external">http://postgis.17.n6.nabble.com/Display-GEOGRAPHY-polygons-crossing-date-line-tp5000443p5000464.html</a>
</div>
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To unsubscribe from Display GEOGRAPHY polygons crossing date line, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.<br>
<a href="http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" rel="nofollow" style="font:9px serif" target="_blank" link="external">NAML</a>
</div></blockquote></div><br></div></div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://postgis.17.n6.nabble.com/Display-GEOGRAPHY-polygons-crossing-date-line-tp5000443p5000515.html">Re: Display GEOGRAPHY polygons crossing date line</a><br/>
Sent from the <a href="http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html">PostGIS - User mailing list archive</a> at Nabble.com.<br/>