Convert 2D to 3D geometry (Z=0) in Oracle Spatial 8.1.7

From: Steve Van Ausdall <svanausdall_at_geoit.com>
Date: Tue, 26 Feb 2002 17:46:35 GMT
Message-ID: <%RPe8.31834$vP.122116_at_rwcrnsc51.ops.asp.att.net>


I have a table containing 2D object-relational geometries migrated from a relational spatial schema
using SDO_MIGRATE.TO_81X - they look like this.

SDO_GEOMETRY(1, NULL, SDO_POINT_TYPE(2210633.78, 387061.732, NULL), NULL, NULL)
SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(2224432.27, 390604.128, 2224107.25, 390600.734)) Is there a procedure or function to convert to 3D points (All 0 Zs) so I can combine these geometries with a table
having existing 3D geometries and rebuild the spatial index? My 3D geometries look like this.

SDO_GEOMETRY(3001, NULL, SDO_POINT_TYPE(1880228.3, 687409.4, 0), NULL, NULL)
SDO_GEOMETRY(3002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1),
SDO_ORDINATE_ARRAY(1883801.1, 685705.9, 0, 1883771, 685751.7, 0))

thanks,
steve Received on Tue Feb 26 2002 - 18:46:35 CET

Original text of this message