[postgis-users] PostGIS and 3D, what are the results?

[strk at refractions.net]

Johan, postgis has no 3d indexing, and no 3d predicates.
Your best bet would be using {x,y,z}{min,max}(box3d) and
geometry::box3d cast.

--strk;

On Mon, Apr 11, 2005 at 08:57:02AM +0200, Johan de Koning wrote:
> Hi all,
> 
> Last week i send an email with some questions about 3d and postgis. Box3d 
> is now working within a query but the results looks not correct. I want to 
> know if other people has already done something with 3d and postgis. Maybe 
> they can send me there results they got?
> 
> With regards,
> 
> Johan de Koning
> 
> >Date: Fri, 08 Apr 2005 14:39:40 +0200
> >To: postgis-users at postgis.refractions.net
> >From: Johan de Koning <johan.de.koning at geodan.nl>
> >Subject: Storing and querying 3d objects from PostGIS
> >
> >Hi all,
> >
> >I am looking at the possibilities in PostGIS with 3D data. I want to store 
> >3D data and query it using a box boundary. I was looking at the Box3D 
> >functionality but i get no results. How can i do a query on the data that 
> >is stored like 3d polygons?
> >
> >I was using the next sql statements for inserting the data
> >
> >create table buildings (BUILDING_ID int4, BUILDING_NAME varchar(128));
> >select AddGeometryColumn('buildings','building_shape',-1,'GEOMETRY',3);
> >
> >insert into buildings(BUILDING_ID, BUILDING_NAME, BUILDING_SHAPE) values 
> >(0, 'Building 0', GeomFromEWKT('POLYGON((0 0 0, 0 5 0, 5 5 0, 5 0 0, 0 0 
> >0),(0 0 0, 0 5 0, 0 5 5, 0 0 5, 0 0 0),(5 5 0, 5 5 5, 0 5 5, 0 5 0, 5 5 
> >0),(5 0 0, 5 0 5, 5 5 5, 5 5 0, 5 0 0),(5 0 0, 5 0 5, 0 0 5, 0 0 0, 5 0 
> >0), (0 0 5, 0 5 5, 5 5 5, 5 0 5, 0 0 5))'));
> >
> >BTW Are there other ways to store 3d data. I know i can separate all faces 
> >and use two tables like body and face with relations between it.
> >
> >Hope somebody can help me
> >
> >Thanx
> >
> >Johan
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users