<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Welcome to maritime GIS around New Zealand :-)<br><br>The standard problem!<br><br>Work in a 0-360 space instead of +-180. EPSG4326 supports both extents (according to EPSG anyway). The problem is the lack of a flag to specify which you want.<br><br>Improvements in the geography datatype will help in this area. <br><br>There are a few workarounds, but the only real solution is a mod 360 approach, as used in GMT & in the geography datatype (sort of)<br><br>Brent Wood<br><br><br>--- On <b>Fri, 9/9/11, Sarah Berke <i><skberke@uchicago.edu></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Sarah Berke <skberke@uchicago.edu><br>Subject: Re: [postgis-users] Problem with convex hulls that cross the dateline<br>To: postgis-users@postgis.refractions.net<br>Date: Friday, September
9, 2011, 7:22 AM<br><br><div id="yiv1142239772">Thanks very much, Regina, Paul, and Ben for the responses. I don't think my hacking skills are quite up to following Paul's suggestion, but I can try to find an equal area projection for the Pacific Ocean. It seems like that would work. I also rather like the idea of translating the points--if I did that, would it then be easy to just translate the entire hull back into position?<br>
<br>Thanks,<br>Sarah<br clear="all">_________________________________<br>Sarah K Berke<br>Postdoctoral Scholar<br>Department of the Geophysical Sciences<br>University of Chicago<br>5734 S. Ellis Ave<br>Chicago, IL 60637<br>
<br><br><div class="yiv1142239772gmail_quote"><br><blockquote class="yiv1142239772gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 7 Sep 2011 01:18:51 -0400<br>
From: "Paragon Corporation" <<a rel="nofollow" ymailto="mailto:lr@pcorp.us" target="_blank" href="/mc/compose?to=lr@pcorp.us">lr@pcorp.us</a>><br>
Subject: Re: [postgis-users] Problem with convex hulls that cross the<br>
dateline<br>
To: "'PostGIS Users Discussion'"<br>
<<a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank" href="/mc/compose?to=postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>
Message-ID: <F8675FD4BB254CD09D2359CF11685DEA@D><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
Sarah,<br>
> I'm having trouble making convex hulls that cross the international<br>
dateline. Imagine 4 points making a square with the international dateline<br>
running down the middle--I would like the convex hull to be that square, but<br>
instead I get a giant rectangle that goes across the entire planet. I've<br>
done some reading, and it sounds like GEOS generally has a hard time dealing<br>
with the dateline--is that accurate?<br>
Yes GEOS only deals with planar coordinates. Geography is the only<br>
geodetic aware type and there is no ConvexHull function for it.<br>
<br>
> Does anyone know of a way to get around this? I was thinking that it<br>
might work if I use an SRID that is just like 4326 but with a central<br>
meridian of 180, does that sound like a good plan?<br>
No. You should use a planar projection of some sort. 4326 squashed on a<br>
map is no good. Paul Ramsey might have some thoughts on the matter.<br>
<br>
> I'm pretty new to postGIS and I'm not sure how to either find such an<br>
SRID or how to define it--I've been trying to find an explanation of SRID<br>
syntax and so far coming up empty. If anyone has advice for solving this<br>
problem, or for places where I can learn more about defining custom SRIDs,<br>
I'd be really grateful!<br>
<br>
You might want to check out <a rel="nofollow" target="_blank" href="http://spatialreference.org">http://spatialreference.org</a><br>
<br>
> Here's an example--if you make this table and then look at it in QGIS<br>
(or whatever) along with a world map, you'll see a big rectangle spanning<br>
the entire map. On a map with<br>
> central meridian of zero, I'd want to see half the polygon on the left<br>
side of the map and the other half on the right side.<br>
<br>
> CREATE TABLE example AS<br>
> SELECT ST_ConvexHull(<br>
> ST_Collect(ST_GeomFromText('MULTIPOINT(175 5, 175 30, -175 5, -175<br>
30)') ))::geography(Polygon, 4326) ;<br>
<br>
My guess is you'll have to cut your area into pieces. Still then its not<br>
that pretty when you try to rejoin.<br>
<br>
Sorry couldn't be more help,<br>
Regina<br>
<a rel="nofollow" target="_blank" href="http://www.postgis.us">http://www.postgis.us</a><br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a rel="nofollow" target="_blank" href="http://postgis.refractions.net/pipermail/postgis-users/attachments/20110907/dca69b0a/attachment-0001.html">http://postgis.refractions.net/pipermail/postgis-users/attachments/20110907/dca69b0a/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Tue, 6 Sep 2011 22:21:48 -0700<br>
From: Paul Ramsey <<a rel="nofollow" ymailto="mailto:pramsey@opengeo.org" target="_blank" href="/mc/compose?to=pramsey@opengeo.org">pramsey@opengeo.org</a>><br>
Subject: Re: [postgis-users] Problem with convex hulls that cross the<br>
dateline<br>
To: PostGIS Users Discussion <<a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank" href="/mc/compose?to=postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>
Message-ID:<br>
<CACowWR0YVqT5_wasbLoscmCnqNFAqVT2ioA=<a rel="nofollow" ymailto="mailto:yJQ6Uv_yX9Cv0A@mail.gmail.com" target="_blank" href="/mc/compose?to=yJQ6Uv_yX9Cv0A@mail.gmail.com">yJQ6Uv_yX9Cv0A@mail.gmail.com</a>><br>
Content-Type: text/plain; charset=ISO-8859-1<br>
<br>
On Tue, Sep 6, 2011 at 10:18 PM, Paragon Corporation <<a rel="nofollow" ymailto="mailto:lr@pcorp.us" target="_blank" href="/mc/compose?to=lr@pcorp.us">lr@pcorp.us</a>> wrote:<br>
> ?Sarah,<br>
> ?> ?I'm having trouble making convex hulls that cross the international<br>
> dateline. Imagine 4 points making a square with the international dateline<br>
> running down the middle--I would like the convex hull to be that square, but<br>
> instead I get a giant rectangle that goes across the entire planet. I've<br>
> done some reading, and it sounds like GEOS generally has a hard time dealing<br>
> with the dateline--is that accurate?<br>
> Yes GEOS? only deals with planar coordinates.? Geography is the only<br>
> geodetic aware type and there is no ConvexHull function for it.<br>
<br>
Although you could hack one up easily enough by copying the ideas in<br>
ST_Buffer(geography)<br>
<br>
P<br>
<br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Wed, 7 Sep 2011 13:43:52 +0800<br>
From: Ben Madin <<a rel="nofollow" ymailto="mailto:lists@remoteinformation.com.au" target="_blank" href="/mc/compose?to=lists@remoteinformation.com.au">lists@remoteinformation.com.au</a>><br>
Subject: Re: [postgis-users] Problem with convex hulls that cross the<br>
dateline<br>
To: PostGIS Users Discussion <<a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank" href="/mc/compose?to=postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>
Message-ID:<br>
<<a rel="nofollow" ymailto="mailto:6AFE8509-2218-4CB2-956A-1269AB5CDB4B@remoteinformation.com.au" target="_blank" href="/mc/compose?to=6AFE8509-2218-4CB2-956A-1269AB5CDB4B@remoteinformation.com.au">6AFE8509-2218-4CB2-956A-1269AB5CDB4B@remoteinformation.com.au</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
Sarah,<br>
<br>
I'm sure that there are good reasons not to do this, but could you translate your points left or right, create your convex hull then translate the polygon back...?<br>
<br>
Otherwise you could project it onto a custom projection that covers your area of interest? As an example look for an equal area proj string (I know there is one for Australia GDA94 Albers - <a rel="nofollow" target="_blank" href="http://www.spatialreference.org/ref/epsg/3577">http://www.spatialreference.org/ref/epsg/3577</a>) and shift the lat and lon parameters...<br>
<br>
cheers<br>
<br>
Ben<br>
<br>
<br>
On 07/09/2011, at 1:13 AM, Sarah Berke wrote:<br>
<br>
> Hello,<br>
><br>
> I'm having trouble making convex hulls that cross the international dateline. Imagine 4 points making a square with the international dateline running down the middle--I would like the convex hull to be that square, but instead I get a giant rectangle that goes across the entire planet. I've done some reading, and it sounds like GEOS generally has a hard time dealing with the dateline--is that accurate? Does anyone know of a way to get around this? I was thinking that it might work if I use an SRID that is just like 4326 but with a central meridian of 180, does that sound like a good plan? I'm pretty new to postGIS and I'm not sure how to either find such an SRID or how to define it--I've been trying to find an explanation of SRID syntax and so far coming up empty. If anyone has advice for solving this problem, or for places where I can learn more about defining custom SRIDs, I'd be really grateful!<br>
><br>
> Here's an example--if you make this table and then look at it in QGIS (or whatever) along with a world map, you'll see a big rectangle spanning the entire map. On a map with central meridian of zero, I'd want to see half the polygon on the left side of the map and the other half on the right side.<br>
><br>
> CREATE TABLE example AS<br>
> SELECT ST_ConvexHull(<br>
> ST_Collect(ST_GeomFromText('MULTIPOINT(175 5, 175 30, -175 5, -175 30)') ))::geography(Polygon, 4326) ;<br>
><br>
><br>
> Thanks very much,<br>
> Sarah<br>
><br>
> _________________________________<br>
> Sarah K Berke<br>
> Postdoctoral Scholar<br>
> Department of the Geophysical Sciences<br>
> University of Chicago<br>
> 5734 S. Ellis Ave<br>
> Chicago, IL 60637<br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank" href="/mc/compose?to=postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> <a rel="nofollow" target="_blank" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
<br>
<br>
------------------------------<br><br></blockquote></div>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<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>