[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] [postgis-devel] Oddity in _ST_Expand(geography)	?
From:       "Regina Obe" <lr () pcorp ! us>
Date:       2018-07-03 20:17:49
Message-ID: 002c01d4130a$ea7c91a0$bf75b4e0$ () pcorp ! us
[Download RAW message or body]

> 
> I start to think that perhaps the existing behavior is broken, and geography
> expand should rewrite the object so that it becomes something that has the
> 3-space bounds we want. Maybe an appropriately chosen multipoint, for
> example. It will be very confusing to people, though, since they tend to think
> rectangularly about bounds, even when working with spherical coordinates,
> which are very decidedly not rectangular.
> 
> Interested in thoughts,
> 
> P
> 

A  polyhedral surface.  When you cast box3d to geometry now it gives you a polyhedral \
surface.

SELECT ST_AsText('BOX3D(1 2 3,5 6 5)'::box3d::geometry)

POLYHEDRALSURFACE Z (((1 2 3,1 6 3,5 6 3,5 2 3,1 2 3)),((1 2 5,5 2 5,5 6 5,1 6 5,1 2 \
5)),((1 2 3,1 2 5,1 6 5,1 6 3,1 2 3)),((5 2 3,5 6 3,5 6 5,5 2 5,5 2 3)),((1 2 3,5 2 \
3,5 2 5,1 2 5,1 2 3)),((1 6 3,1 6 5,5 6 5,5 6 3,1 6 3)))

Though I guess we don't support polyhedral surfaces in geography so perhaps that's a \
pipe dream.

 Regina hops away before Paul has a chance to say

"That's the stupidest idea I ever heard."





_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]