[postgis-users] PostGIS and 3D, what are the results?
Johan de Koning
johan.de.koning at geodan.nl
Sun Apr 10 23:57:02 PDT 2005
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
More information about the postgis-users
mailing list