[postgis-users] Antipodal issues in upgrade

Paul Ramsey pramsey at cleverelephant.ca
Thu Aug 21 05:41:05 PDT 2014

No, there's nothing in 1.5 to find anti-podal edges. I'm willing to
guess though that yours involve pole-to-pole lines, so you could look
for objects with an ymax-ymin of ~180.
Alternately, is the hgc_bbox column real data, or is it derived from
other data? (ie, there's real lines or polygons elsewhere in the
table?) If so, you could drop the bbox column in 1.5 and regenerate it
in 2.1 after load.

On Wed, Aug 20, 2014 at 8:16 PM, Timmons, Ryan P
<ryan.p.timmons at lmco.com> wrote:
> I'm having some trouble with an upgrade, following http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade
> Specifically I am going from Postgres 8.3.10, postgis "1.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"   (given by select postgis_version())
> to Postgres 9.3.5, postgis "2.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"
> When restoring I got this error:
> ERROR:  Antipodal (180 degrees long) edge detected!
> CONTEXT:  COPY voevents_general, line 15242, column hgc_bbox: "0103000020E610000001000000050000007ADFF8DA330165C000000000008056C05B087250C2EC274000000000008056C05B..."
> Appears the entire table is unpopulated after that error.  From http://trac.osgeo.org/postgis/ticket/1046 it seems the antipodal check was added between the versions I'm transitioning between
> Is there a function to find all rows in my old 1.5 version that will fail this check?  I don't see anything obvious in http://postgis.net/docs/manual-1.5/ch08.html#PostGIS_GeographyFunctions .
> Or, is there a way to have the upgrade script fail only the rows violating this condition?  ( I suspect it is a small portion of the data, and not a useful field for the rows having this problem) .
> Thanks,
> Ryan
> Ryan Timmons
> Research Scientist, O/A014S
> Control Systems & Information Sciences
> Lockheed Martin SSC
> Cell: 248-895-1935
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

More information about the postgis-users mailing list