Re: Spatial: Make line out of (many) points

From: Benjamin Hell <bhell_at_spamfence.net>
Date: Fri, 01 Sep 2006 18:42:58 +0200
Message-ID: <4lr691F3a9vvU1@individual.net>

Hello again!

I forgot something. Minor update...

Benjamin Hell wrote:
> (2) First
> inserting all the point geometries and then merging them with
> SDO_AGGR_UNION(). This is the closest I could get:
>
> UPDATE DATASET
> SET LINEGEOMETRY = (
> SELECT SDO_AGGR_UNION(SDOAGGRTYPE(GEOMETRY, 0.0001))
> FROM (
> SELECT GEOMETRY
> FROM SOUNDING
> WHERE DATASETID = 'NGDCA2075L01'
> ORDER BY PID
> )
> )
> WHERE DATASETID = 'NGDCA2075L01';
To get a line geometry instead of a multipoint something, I manually change SDO_GTYPE and SDO_ELEM_INFO afterwards:

UPDATE DATASET D
    SET D.SIMPLEGEOMETRY.SDO_GTYPE = 3002,

        D.SIMPLEGEOMETRY.SDO_ELEM_INFO =
            SDO_ELEM_INFO_ARRAY(1, 2, 1)

    WHERE D.DATASETID = 'NGDCA2075L01'; Regards,

Benjamin Received on Fri Sep 01 2006 - 11:42:58 CDT