I need to report back to ArcGIS what the bounds of the data is. The way zigGIS works is it parses all geometry data returned from PostGIS as WKB. We're extending zigGIS to handle ZM coordinates. I'll be happy to put in a special case for the extents query where if I have to parse things manually I will. But I'm not even sure how to get a ST_Extent3d query into a from that I can consume (note that going through Npgsql has its own challenges with working with non-standard types). I'd parse binary if ST_AsEWKB worked, I'd parse text if ST_AsEWKT worked.
Regina, I'm a bit confused how you started your last response. If I broke list etiquette then I apologize. I did the work to boil down my initial question into an easily reproducible test case which I thought was exercising a bug. My apologies for not getting to the point immediately. Thanks. On Mon, Jan 11, 2010 at 12:14 PM, Paragon Corporation <[email protected]> wrote: > Abe, > One thought that comes to mind is store it as a multipolygon with each > polygon being a different edge of the box, but I'm not sure that would be > terribly useful for your use-case. > > Leo > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Abram > Gillespie > Sent: Monday, January 11, 2010 11:38 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] Bug dropping the Z coordinate? > > OK, I'll ask this then. What's the best way to get this: > > select ST_Extent3d(geometry_column) from my_table; > > Into EWKB w/o losing the Z (or M) coordinate? > > Doing: > > select ST_AsEWKB(ST_Extent3D(geometry_column)) from my_table; > > unfortunately falls prey to the issue we're discussing. > > Thanks. > -Abe > > On Sun, Jan 10, 2010 at 10:53 PM, Paragon Corporation <[email protected]> wrote: >> As a side note. ST_Zmax doesn't exist for geometries. It works >> because geometries can be autocast to boxes. >> >> See matrix >> http://www.postgis.org/documentation/manual-svn/ch08.html#PostGIS_Type >> Functi >> onMatrix >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of >> Paragon Corporation >> Sent: Sunday, January 10, 2010 10:50 PM >> To: 'PostGIS Users Discussion' >> Subject: Re: [postgis-users] Bug dropping the Z coordinate? >> >> Abe, >> >> It seems we are flattening the box3d geometry in to a 2D polygon >> always instead of as a 3D/2.5D polygon. >> I'm not sure it's a bug though, because I think a box3d is an invalid >> 2.5/3D polygon if you were to construct it. >> >> Can you envision it? >> >> Paul, Mark or Kevin might have a better clue, but I think it's at best >> an ambiguous 3D polygon and that is the problem. A box3d isn't really >> a 3D box, its more just a coordinate bounding thing. >> >> Hope that helps, >> Regina >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of >> Abram Gillespie >> Sent: Sunday, January 10, 2010 4:31 PM >> To: PostGIS Users Discussion >> Subject: [postgis-users] Bug dropping the Z coordinate? >> >> Is this a bug? >> >> select ST_ZMax('BOX3D(0 0 0,0 0 1)'::box3d); >> >> versus >> >> select ST_ZMax(ST_GeomFromEWKB(ST_AsEWKB('BOX3D(0 0 0,0 0 >> 1)'::box3d))); >> >> The first query returns "1" as expected but the second returns "0" as >> unexpected. >> >> I'm trying to add Z/M support to zigGIS and this is show-stopping me. >> Any work-arounds if this is a bug? Also, I'll be happy to report the >> bug if so. >> >> Thanks. >> -Abe >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
