Class SDO


  • public final class SDO
    extends Object
    Oracle Spatial Data Object utilities functions.

    Provide utility functions for working with JTS Geometries in terms Oracle Spatial Data Objects

    This class can be used for normal JTS Geometry persistence with little fuss and bother - please see GeometryConverter for an example of this.

    With a little fuss and bother LRS information can also be handled. Although it is very rare that JTS makes use of such things.

    Author:
    Jody Garnett, Refractions Reasearch Inc.
    See Also:
    Spatial User's Guide (10.1), net.refractions.jspatial.jts
    • Field Summary

      Fields 
      Modifier and Type Field Description
      static int SRID_NULL  
    • Constructor Summary

      Constructors 
      Constructor Description
      SDO()  
    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static Coordinate[] asCoordinates​(double[] ordinates)
      Coordinates from (x,y,x2,y2,...) ordinates.
      static Coordinate[] asCoordinates​(double[] ordinates, int d)
      Coordinates from a (x,y,i3..
      static CoordinateSequence coordiantes​(CoordinateSequenceFactory f, AttributeList x, AttributeList y, AttributeList z)
      Construct CoordinateSequence with no LRS measures.
      static CoordinateSequence coordiantes​(CoordinateSequenceFactory f, OrdinateList x, OrdinateList y, OrdinateList z)
      Construct CoordinateSequence with no LRS measures.
      static CoordinateSequence coordiantes​(CoordinateSequenceFactory f, OrdinateList x, OrdinateList y, OrdinateList z, OrdinateList m)
      bugfix 20121231-BK: added: TODO org.geotools.geometry.jts.CoordinateSequenceFactory does not support 4 dimensions!
      static void coordinates​(List<double[]> list, Geometry geom)
      Encode Geometry as described by GTYPE and ELEM_INFO
      static CoordinateSequence coordinates​(CoordinateSequenceFactory f, int GTYPE, double[] ordinates)
      Construct CoordinateList as described by GTYPE.
      static CoordinateSequence counterClockWise​(CoordinateSequenceFactory factory, CoordinateSequence ring)
      Ensure Ring of Coordinates are in a counter Orientationwise order.
      static Geometry create​(GeometryFactory gf, int GTYPE, int SRID, double[] point, int[] elemInfo, double[] ordinates)
      Decode geometry from provided SDO encoded information.
      static Geometry create​(GeometryFactory gf, int GTYPE, int SRID, int[] elemInfo, int triplet, CoordinateSequence coords, int N)
      Consturct geometry with SDO encoded information over a CoordinateList.
      static int D​(int GTYPE)
      Access D (for dimension) as encoded in GTYPE
      static int D​(Geometry geom)
      Return D as defined by SDO_GTYPE (either 2,3 or 4).
      static int[] elemInfo​(Geometry geom)
      Return SDO_ELEM_INFO array for geometry
      static int[] elemInfo​(Geometry geom, int GTYPE)  
      protected static int elemInfoEType​(Geometry geom)
      Produce SDO_ETYPE for geometry description as stored in the SDO_ELEM_INFO .
      static int elemInfoInterpretation​(Geometry geom)
      Produce SDO_INTERPRETATION for geometry description as stored in the SDO_ELEM_INFO.
      static int elemInfoInterpretation​(Geometry geom, int etype)
      Allows specification of INTERPRETATION used to interpret geom.
      static int elemInfoStartingOffset​(Geometry geom)
      Starting offset used by SDO_ORDINATES as stored in the SDO_ELEM_INFO array.
      static CoordinateSequence getCS​(Geometry geom)  
      static int gType​(Geometry geom)
      Produce SDO_GTYPE representing provided Geometry.
      static int L​(int GTYPE)
      Access L (for LRS) as encoded in GTYPE
      static int L​(Geometry geom)
      Return L as defined by SDO_GTYPE (either 3,4 or 0).
      static double[] ordinateArray​(List list, int ordinate)  
      static double[] ordinateArray​(Coordinate[] array, int ordinate)
      Ordinate access.
      static double[] ordinateArray​(CoordinateSequence coords, int ordinate)
      Package up array of requested ordinate, regardless of geometry
      static double[] ordinates​(List list, Geometry geom)
      Package up array in correct manner for geom.
      static double[] ordinates​(Geometry geom)
      Produce SDO_ORDINATES for geometry.
      static double[] ordinates2d​(List list)
      Ordinates (x,y,x1,y1,...) from coordiante list.
      static double[] ordinates2d​(List list, int L)
      Ordinates (x,y,...id,x2,y2,...) from coordiante[] List.
      static double[] ordinates3d​(List list)
      Ordinates (x,y,z,x2,y2,z2...) from coordiante[] array.
      static double[] ordinates3d​(List list, int L)
      Ordinates (x,y,z,...id,x2,y2,z2...) from coordiante[] array.
      static double[] point​(Geometry geom)
      Return SDO_POINT_TYPE for geometry
      static int SRID​(Geometry geom)
      Returns geometry SRID.
      static int TT​(int GTYPE)
      Access TT (for geometry type) as encoded in GTYPE
      static int TT​(Geometry geom)
      Return TT as defined by SDO_GTYPE (represents geometry type).
      • Methods inherited from class Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Constructor Detail

      • SDO

        public SDO()
    • Method Detail

      • gType

        public static int gType​(Geometry geom)
        Produce SDO_GTYPE representing provided Geometry.

        Encoding of Geometry type and dimension.

        SDO_GTYPE defined as for digits [d][l][tt]:

        • d: number of dimensions (limited to 2,3, or 4)
        • l: measure representation (ordinate 3 or 4) or 0 to represent none/last
        • tt: See the TT. constants defined in this class

        Definition provided by Oracle Spatial User�s Guide and Reference.

      • D

        public static int D​(Geometry geom)
        Return D as defined by SDO_GTYPE (either 2,3 or 4).

        For normal JTS Geometry this will be 2 or 3 depending if geom.getCoordinate.z is Double.NaN.

        Subclasses may override as required.

        Returns:
        3
      • L

        public static int L​(Geometry geom)
        Return L as defined by SDO_GTYPE (either 3,4 or 0).

        L represents support for LRS (Liniar Referencing System?). JTS Geometry objects do not support LRS so this will be 0.

        Subclasses may override as required.

        Returns:
        0
      • TT

        public static int TT​(Geometry geom)
        Return TT as defined by SDO_GTYPE (represents geometry type).

        TT is used to represent the type of the JTS Geometry:

        
         Value Geometry Type    JTS Geometry
         00    UNKNOWN_GEOMETRY null
         01    POINT            Point
         02    LINE             LineString
               CURVE            not supported
         03    POLYGON          Polygon
         04    COLLECTION       GeometryCollection
         05    MULTIPOINT       MultiPoint
         06    MULTILINE        MultiLineString
               MULTICURVE       not supported
         07    MULTIPOLYGON     MultiPolygon
         
        Returns:
        TT representing geom
        Throws:
        IllegalArgumentException - If SDO_GTYPE can not be represetned by JTS
      • SRID

        public static int SRID​(Geometry geom)
        Returns geometry SRID.

        SRID code representing Spatial Reference System. SRID number used must be defined in the Oracle MDSYS.CS_SRS table.

        SRID_NULLrepresents lack of coordinate system.

        Parameters:
        geom - Geometry SRID Number (JTS14 uses GeometryFactor.getSRID() )
        Returns:
        SRID for provided geom
      • point

        public static double[] point​(Geometry geom)
        Return SDO_POINT_TYPE for geometry

        Will return non null for Point objects. null is returned for all non point objects.

        You cannot use this with LRS Coordinates

        Subclasses may wish to repress this method and force Points to be represented using SDO_ORDINATES.

      • elemInfo

        public static int[] elemInfo​(Geometry geom)
        Return SDO_ELEM_INFO array for geometry

        Describes how to use Ordinates to represent Geometry.

        
         # Name                Meaning
         0 SDO_STARTING_OFFSET Offsets start at one
         1 SDO_ETYPE           Describes how ordinates are ordered
         2 SDO_INTERPRETATION  SDO_ETYPE: 4, 1005, or 2005
                               Number of triplets involved in compound geometry
        
                               SDO_ETYPE: 1, 2, 1003, or 2003
                               Describes ordering of ordinates in geometry
         

        For compound elements (SDO_ETYPE values 4 and 5) the last element of one is the first element of the next.

        Parameters:
        geom - Geometry being represented
        Returns:
        Descriptionof Ordinates representation
      • elemInfo

        public static int[] elemInfo​(Geometry geom,
                                     int GTYPE)
      • elemInfoStartingOffset

        public static int elemInfoStartingOffset​(Geometry geom)
        Starting offset used by SDO_ORDINATES as stored in the SDO_ELEM_INFO array.

        Starting offsets start from one.

        Describes ordinates as part of SDO_ELEM_INFO data type.

        Returns:
        1 for non nested geom
      • elemInfoEType

        protected static int elemInfoEType​(Geometry geom)
        Produce SDO_ETYPE for geometry description as stored in the SDO_ELEM_INFO .

        Describes how Ordinates are ordered:

        
         Value Elements Meaning
            0           Custom Geometry (like spline)
            1  simple   Point (or Points)
            2  simple   Line (or Lines)
            3           polygon ring of unknown order (discouraged update to 1003 or 2003)
         1003  simple   polygon ring (1 exterior counterOrientationwise order)
         2003  simple   polygon ring (2 interior Orientationwise order)
            4  compound series defines a linestring
            5  compound series defines a polygon ring of unknown order (discouraged)
         1005  compound series defines exterior polygon ring (counterOrientationwise order)
         2005  compound series defines interior polygon ring (Orientationwise order)
         

        Keep in mind:

        • simple elements are defined by a single triplet entry in the SDO_ELEM_INFO array
        • compound elements are defined by a header triplet, and a series of triplets for the parts. Elements in a compound element share first and last points.
        • We are not allowed to mix 1 digit and 4 digit values for ETYPE and GTYPE in a single geometry

        This whole mess describes ordinates as part of SDO_ELEM_INFO array. data type.

        Parameters:
        geom - Geometry being represented
        Returns:
        Descriptionof Ordinates representation
      • elemInfoInterpretation

        public static int elemInfoInterpretation​(Geometry geom)
        Produce SDO_INTERPRETATION for geometry description as stored in the SDO_ELEM_INFO.

        Describes ordinates as part of SDO_ELEM_INFO array.

        • compound element:(SDO_ETYPE 4, 1005, or 2005)
          Number of subsequent triplets are part of compound element
        • simple element:(SDE_ELEM 1, 2, 1003, or 2003)
          Code defines how ordinates are interpreted (lines or curves)

        SDO_INTERPRETAION Values: (from Table 2-2 in reference docs)

        
         SDO_ETYPE Value    Meaning
         0         anything Custom Geometry
         1         1        Point
         1         N > 1    N points
         2         1        LineString of straight lines
         2         2        LineString connected by circ arcs (start,any,end pt)
         1003/2003 1        Polygon Edged with straight lines
         1003/2003 2        Polygon Edged with circ arcs (start, any, end pt)
         1003/2003 3        Non SRID rectangle defined by (bottomleft,topright pt)
         1003/2003 4        Circle defined by three points on circumference
         4         N > 1    Compound Line String made of N (ETYPE=2) lines and arcs
         1005/2005 N > 1    Polygon defined by (ETYPE=2) lines and arcs
        
        
         

        When playing with circular arcs (SDO_INTERPRETATION==2) arcs are defined by three points. A start point, any point on the arc and the end point. The last point of an arc is the start point of the next. When used to describe a polygon (SDO_ETYPE==1003 or 2003) the first and last point must be the same.

      • elemInfoInterpretation

        public static int elemInfoInterpretation​(Geometry geom,
                                                 int etype)
        Allows specification of INTERPRETATION used to interpret geom.

        Provides the INTERPRETATION value for the ELEM_INFO triplet of (STARTING_OFFSET, ETYPE, INTERPRETATION).

        Parameters:
        geom - Geometry to encode
        etype - ETYPE value requiring an INTERPREATION
        Returns:
        INTERPRETATION ELEM_INFO entry for geom given etype
        Throws:
        IllegalArgumentException - If asked to encode a curve
      • ordinates

        public static double[] ordinates​(Geometry geom)
        Produce SDO_ORDINATES for geometry.

        Please see SDO_ETYPE, SDO_INTERPRETATION and SDO_GTYPE for description of how these ordinates are to be interpreted.

        Ordinates are ordered by Dimension are non null:

        • Two Dimensional: {x1,y1,x2,y2,...}

        • Three Dimensional: {x1,y1,z1,x2,y2,z2,...}

        Spatial will siliently detect and ignore the following:

        • d001 point/d005 multipoint elements that are not SDO_ETYPE==1 points
        • d002 lines or curve/d006 multilines or multicurve elements that are not SDO_ETYPE==2 lines or SDO_ETYPE==4 arcs
        • d003 polygon/d007 multipolygon elements that are not SDO_ETYPE==3 unordered polygon lines or SDO_ETYPE==5 unorderd compound polygon ring are ignored

        While Oracle is silient on these errors - all other errors will not be detected!

      • getCS

        public static CoordinateSequence getCS​(Geometry geom)
      • coordinates

        public static void coordinates​(List<double[]> list,
                                       Geometry geom)
        Encode Geometry as described by GTYPE and ELEM_INFO

        CoordinateSequence & CoordinateAccess wil be used to determine the dimension, and the number of ordinates added.

        Parameters:
        list - Flat list of Double
        geom - Geometry
        Throws:
        IllegalArgumentException - If geometry cannot be encoded
      • ordinateArray

        public static double[] ordinateArray​(CoordinateSequence coords,
                                             int ordinate)
        Package up array of requested ordinate, regardless of geometry

        Example numbering: for (x y g m) dimension==2, measure==2

        • 0: x ordinate array
        • 1: y ordinate array
        • 2: g ordinate array
        • 3: m ordinate array
      • ordinateArray

        public static double[] ordinateArray​(Coordinate[] array,
                                             int ordinate)
        Ordinate access.

        CoordinateAccess is required for additional ordinates.

        Ordinate limitied to:

        • 0: x ordinate array
        • 1: y ordinate array
        • 2: z ordinate array
        • 3: empty ordinate array
      • ordinateArray

        public static double[] ordinateArray​(List list,
                                             int ordinate)
      • ordinates

        public static double[] ordinates​(List list,
                                         Geometry geom)
        Package up array in correct manner for geom.

        Ordinates are placed into an array based on:

        • geometryGTypeD - chooses between 2d and 3d representation
        • geometryGTypeL - number of LRS measures
      • ordinates2d

        public static double[] ordinates2d​(List list)
        Ordinates (x,y,x1,y1,...) from coordiante list.

        No assumptions are made about the order

        Parameters:
        list - coordinate list
        Returns:
        ordinate array
      • ordinates3d

        public static double[] ordinates3d​(List list)
        Ordinates (x,y,z,x2,y2,z2...) from coordiante[] array.
        Parameters:
        list - List of coordiante
        Returns:
        ordinate array
      • ordinates2d

        public static double[] ordinates2d​(List list,
                                           int L)
        Ordinates (x,y,...id,x2,y2,...) from coordiante[] List.
        Parameters:
        list - coordiante list
        L - Dimension of ordinates required for representation
        Returns:
        ordinate array
      • ordinates3d

        public static double[] ordinates3d​(List list,
                                           int L)
        Ordinates (x,y,z,...id,x2,y2,z2...) from coordiante[] array.
        Parameters:
        list - coordinate array to be represented as ordinates
        L - Dimension of ordinates required for representation
        Returns:
        ordinate array
      • counterClockWise

        public static CoordinateSequence counterClockWise​(CoordinateSequenceFactory factory,
                                                          CoordinateSequence ring)
        Ensure Ring of Coordinates are in a counter Orientationwise order.

        If the Coordinate need to be reversed a copy will be returned.

        Parameters:
        factory - Factory to used to reverse CoordinateSequence
        ring - Ring of Coordinates
        Returns:
        coords in a CCW order
      • D

        public static int D​(int GTYPE)
        Access D (for dimension) as encoded in GTYPE
      • L

        public static int L​(int GTYPE)
        Access L (for LRS) as encoded in GTYPE
      • TT

        public static int TT​(int GTYPE)
        Access TT (for geometry type) as encoded in GTYPE
      • asCoordinates

        public static Coordinate[] asCoordinates​(double[] ordinates)
        Coordinates from (x,y,x2,y2,...) ordinates.
      • asCoordinates

        public static Coordinate[] asCoordinates​(double[] ordinates,
                                                 int d)
        Coordinates from a (x,y,i3..,id,x2,y2...) ordinates.
      • coordinates

        public static CoordinateSequence coordinates​(CoordinateSequenceFactory f,
                                                     int GTYPE,
                                                     double[] ordinates)
        Construct CoordinateList as described by GTYPE.

        GTYPE encodes the following information:

        • D: Dimension of ordinates
        • L: Ordinate that represents the LRS measure

        The number of ordinates per coordinate are taken to be D, and the number of ordinates should be a multiple of this value.

        In the Special case of GTYPE 2001 and a three ordinates are interpreted as a single Coordinate rather than an error.

        For 3-dimensional coordinates we assume z to be the third ordinate. If the LRS measure value is stored in the third ordinate (L=3) we assume a 2-dimensional coordinate.

        Parameters:
        f - CoordinateSequenceFactory used to encode ordiantes for JTS
        GTYPE - Encoding of Dimension, LRS and TType
      • coordiantes

        public static CoordinateSequence coordiantes​(CoordinateSequenceFactory f,
                                                     OrdinateList x,
                                                     OrdinateList y,
                                                     OrdinateList z)
        Construct CoordinateSequence with no LRS measures.

        To produce two dimension Coordinates pass in null for z

      • coordiantes

        public static CoordinateSequence coordiantes​(CoordinateSequenceFactory f,
                                                     AttributeList x,
                                                     AttributeList y,
                                                     AttributeList z)
        Construct CoordinateSequence with no LRS measures.

        To produce two dimension Coordinates pass in null for z

      • coordiantes

        public static CoordinateSequence coordiantes​(CoordinateSequenceFactory f,
                                                     OrdinateList x,
                                                     OrdinateList y,
                                                     OrdinateList z,
                                                     OrdinateList m)
        bugfix 20121231-BK: added: TODO org.geotools.geometry.jts.CoordinateSequenceFactory does not support 4 dimensions! Construct CoordinateSequence with LRS measures.

        To produce three dimension Coordinates pass in null for z

        Parameters:
        f - CoordinateSequenceFactory
        x - x-ordinates
        y - y-ordinates
        z - z-ordinates, null for 2D
        m - m-ordinates
        Returns:
        CoordinateSequence
      • create

        public static Geometry create​(GeometryFactory gf,
                                      int GTYPE,
                                      int SRID,
                                      double[] point,
                                      int[] elemInfo,
                                      double[] ordinates)
        Decode geometry from provided SDO encoded information.

        Parameters:
        gf - Used to construct returned Geometry
        GTYPE - SDO_GTYPE represents dimension, LRS, and geometry type
        SRID - SDO_SRID represents Spatial Reference System
        Returns:
        Geometry as encoded
      • create

        public static Geometry create​(GeometryFactory gf,
                                      int GTYPE,
                                      int SRID,
                                      int[] elemInfo,
                                      int triplet,
                                      CoordinateSequence coords,
                                      int N)
        Consturct geometry with SDO encoded information over a CoordinateList.

        Helpful when dealing construction Geometries with your own Coordinate Types. The dimensionality specified in GTYPE will be used to interpret the offsets in elemInfo.

        Parameters:
        GTYPE - Encoding of Dimension, LRS and TType
        N - Number of triplets (-1 for unknown/don't care)
        Returns:
        Geometry as encoded, or null w/ log if it cannot be represented via JTS