oracle.spatial.util
Class Adapters

java.lang.Object
  oracle.spatial.util.Adapters

public class Adapters
extends java.lang.Object

Field Summary

protected static java.sql.Connection	m_conn
protected static WKB	m_wkbAdapter
protected static WKT	m_wktAdapter

Constructor Summary

Adapters()

Method Summary

static oracle.sql.STRUCT	affineTransforms(oracle.sql.STRUCT geom, java.lang.String translation, oracle.sql.NUMBER tx, oracle.sql.NUMBER ty, oracle.sql.NUMBER tz, java.lang.String scaling, oracle.sql.STRUCT Psc1, oracle.sql.NUMBER sx, oracle.sql.NUMBER sy, oracle.sql.NUMBER sz, java.lang.String rotation, oracle.sql.STRUCT P1, oracle.sql.STRUCT line1, oracle.sql.NUMBER angle, oracle.sql.NUMBER dir, java.lang.String shearing, oracle.sql.NUMBER SHxy, oracle.sql.NUMBER SHyx, oracle.sql.NUMBER SHxz, oracle.sql.NUMBER SHzx, oracle.sql.NUMBER SHyz, oracle.sql.NUMBER SHzy, java.lang.String reflection, oracle.sql.STRUCT Pref, oracle.sql.STRUCT lineR, oracle.sql.NUMBER dirR, java.lang.String planeR, oracle.spatial.type.SdoNumberArray n, oracle.spatial.type.SdoNumberArray bigD)
static java.lang.String	anyInteract(oracle.sql.STRUCT geom1, oracle.sql.STRUCT geom2, java.lang.String is_g3d, oracle.sql.NUMBER tolerance)
static oracle.sql.NUMBER	area(oracle.sql.STRUCT geom, oracle.sql.NUMBER tolerance)
static oracle.sql.STRUCT	buffer(oracle.sql.STRUCT geom, oracle.sql.NUMBER bufferWidth, oracle.sql.NUMBER sma, oracle.sql.NUMBER iflat, oracle.sql.NUMBER arcT)
static oracle.sql.STRUCT	centroid_3d(oracle.sql.STRUCT geom, oracle.sql.NUMBER tolerance)
static oracle.sql.STRUCT	closestPoints(oracle.sql.STRUCT geom1, oracle.sql.STRUCT geom2, oracle.sql.NUMBER tolerance)
static oracle.sql.NUMBER	distance(oracle.sql.STRUCT geom1, oracle.sql.STRUCT geom2, oracle.sql.NUMBER tolerance)
static oracle.sql.STRUCT	expandG3Dgeoms(oracle.sql.STRUCT geom)
static oracle.sql.STRUCT	extract3d(oracle.sql.STRUCT geom, java.lang.String label)
static oracle.sql.STRUCT	extrusion2(oracle.sql.STRUCT polygon, oracle.spatial.type.SdoNumberArray grdHeight, oracle.spatial.type.SdoNumberArray height, oracle.sql.NUMBER tolerance, oracle.sql.NUMBER optional3dSrid)
static java.lang.String	getlabelbyelement(oracle.sql.STRUCT source_Geom, oracle.sql.STRUCT qry_Element, oracle.sql.NUMBER tolerance)
static oracle.sql.STRUCT	gml311ToSTRUCT(oracle.sql.CLOB gml)
static oracle.sql.STRUCT	gml311ToSTRUCT(oracle.sql.CLOB gml, java.lang.String srsNameSpace)
static oracle.sql.STRUCT	gml311ToSTRUCT(java.lang.String gml)
static oracle.sql.STRUCT	gml311ToSTRUCT(java.lang.String gml, java.sql.Connection conn)
static oracle.sql.STRUCT	gml311ToSTRUCT(java.lang.String gml, java.lang.String srsNameSpace)
static oracle.sql.STRUCT	gmlToSTRUCT(oracle.sql.CLOB gml)
static oracle.sql.STRUCT	gmlToSTRUCT(oracle.sql.CLOB gml, java.lang.String srsNameSpace)
static oracle.sql.STRUCT	gmlToSTRUCT(java.lang.String gml)
static oracle.sql.STRUCT	gmlToSTRUCT(java.lang.String gml, java.sql.Connection conn)
static oracle.sql.STRUCT	gmlToSTRUCT(java.lang.String gml, java.lang.String srsNameSpace)
static java.lang.String	inside3d(oracle.sql.STRUCT geom1, oracle.sql.STRUCT geom2, java.lang.String is_g3d, oracle.sql.NUMBER tolerance)
static oracle.sql.STRUCT	kmlToSTRUCT(oracle.sql.CLOB kml)
static oracle.sql.STRUCT	kmlToSTRUCT(java.lang.String kml)
static oracle.sql.STRUCT	kmlToSTRUCT(java.lang.String kml, java.sql.Connection conn)
static oracle.sql.NUMBER	length(oracle.sql.STRUCT geom, oracle.sql.NUMBER count_shared_edges, oracle.sql.NUMBER tolerance)
static oracle.sql.BLOB	pctrclip(oracle.sql.STRUCT qry, oracle.sql.STRUCT attr_qry, oracle.sql.BLOB pts, oracle.sql.NUMBER npts, oracle.sql.NUMBER numdim, oracle.sql.BLOB trs, oracle.sql.NUMBER ntrs, oracle.sql.NUMBER tolerance)
static void	readpts(oracle.sql.BLOB ptlob, int numpts, int ndim, oracle.spatial.util.Adapters.Ptclass[] ptarr)
protected static oracle.spatial.geometry.JGeometry	ringUnion(oracle.spatial.geometry.JGeometry g, double tol)
static oracle.sql.STRUCT	ringUnionApprox(oracle.sql.STRUCT polygon, oracle.sql.NUMBER tolerance)
static oracle.sql.BLOB	structToWkb(oracle.sql.STRUCT geom)
static oracle.sql.BLOB	structToWkb(oracle.sql.STRUCT geom, java.sql.Connection conn)
protected static oracle.sql.BLOB	structToWkb2(oracle.sql.STRUCT geom, java.sql.Connection conn)
static oracle.sql.CLOB	structToWkt(oracle.sql.STRUCT geom)
static oracle.sql.CLOB	structToWkt(oracle.sql.STRUCT geom, java.sql.Connection conn)
protected static oracle.sql.CLOB	structToWkt2(oracle.sql.STRUCT geom, java.sql.Connection conn)
static java.lang.String	structToWktString(oracle.sql.STRUCT geom)
protected static java.lang.String	structToWktString2(oracle.sql.STRUCT geom)
static oracle.sql.NUMBER	validate_layer_with_context_3D(java.lang.String geomTableName, java.lang.String geomColumnName, java.lang.String resultTableName, oracle.sql.NUMBER commit_interval, java.lang.String conditional, oracle.sql.NUMBER chck3dsrid, oracle.sql.NUMBER tolerance)
static java.lang.String	validateGeom(oracle.sql.STRUCT geom, java.lang.String conditional, oracle.sql.NUMBER chck3dsrid, oracle.sql.NUMBER tolerance)
static java.lang.String	validateWkb(oracle.sql.BLOB wkb)
static java.lang.String	validateWkb(oracle.sql.BLOB wkb, java.sql.Connection conn)
static java.lang.String	validateWkt(oracle.sql.CLOB wkt)
static java.lang.String	validateWkt(oracle.sql.CLOB wkt, java.sql.Connection conn)
static java.lang.String	validateWkt(java.lang.String wkt)
static java.lang.String	validateWkt(java.lang.String wkt, java.sql.Connection conn)
static oracle.sql.NUMBER	volume(oracle.sql.STRUCT geom, oracle.sql.NUMBER tolerance)
static oracle.sql.STRUCT	wkbToSTRUCT(oracle.sql.BLOB wkb)
static oracle.sql.STRUCT	wkbToSTRUCT(oracle.sql.BLOB wkb, java.sql.Connection conn)
protected static oracle.sql.STRUCT	wkbToSTRUCT2(oracle.sql.BLOB wkb, java.sql.Connection conn)
static oracle.sql.STRUCT	wktToSTRUCT(oracle.sql.CLOB wkt)
static oracle.sql.STRUCT	wktToSTRUCT(oracle.sql.CLOB wkt, java.sql.Connection conn)
static oracle.sql.STRUCT	wktToSTRUCT(java.lang.String wkt)
static oracle.sql.STRUCT	wktToSTRUCT(java.lang.String wkt, java.sql.Connection conn)
protected static oracle.sql.STRUCT	wktToSTRUCT2(oracle.sql.CLOB wkt, java.sql.Connection conn)
protected static oracle.sql.STRUCT	wktToSTRUCT2(java.lang.String wkt, java.sql.Connection conn)
static void	writepts(oracle.sql.BLOB ptlob, int numpts, int ndim, oracle.spatial.util.Adapters.Ptclass[] ptarr)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

m_conn

protected static final java.sql.Connection m_conn

m_wkbAdapter

protected static final WKB m_wkbAdapter

m_wktAdapter

protected static final WKT m_wktAdapter

Constructor Detail

Adapters

public Adapters()

Method Detail

wkbToSTRUCT

public static oracle.sql.STRUCT wkbToSTRUCT(oracle.sql.BLOB wkb)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

wkbToSTRUCT

public static oracle.sql.STRUCT wkbToSTRUCT(oracle.sql.BLOB wkb,
                                            java.sql.Connection conn)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

wkbToSTRUCT2

protected static oracle.sql.STRUCT wkbToSTRUCT2(oracle.sql.BLOB wkb,
                                                java.sql.Connection conn)
                                         throws java.sql.SQLException,
                                                GeometryExceptionWithContext

Throws:

java.sql.SQLException

GeometryExceptionWithContext

wktToSTRUCT

public static oracle.sql.STRUCT wktToSTRUCT(oracle.sql.CLOB wkt)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

wktToSTRUCT

public static oracle.sql.STRUCT wktToSTRUCT(oracle.sql.CLOB wkt,
                                            java.sql.Connection conn)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

wktToSTRUCT2

protected static oracle.sql.STRUCT wktToSTRUCT2(oracle.sql.CLOB wkt,
                                                java.sql.Connection conn)
                                         throws java.sql.SQLException,
                                                GeometryExceptionWithContext

Throws:

java.sql.SQLException

GeometryExceptionWithContext

wktToSTRUCT

public static oracle.sql.STRUCT wktToSTRUCT(java.lang.String wkt)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

wktToSTRUCT

public static oracle.sql.STRUCT wktToSTRUCT(java.lang.String wkt,
                                            java.sql.Connection conn)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

wktToSTRUCT2

protected static oracle.sql.STRUCT wktToSTRUCT2(java.lang.String wkt,
                                                java.sql.Connection conn)
                                         throws java.sql.SQLException,
                                                GeometryExceptionWithContext

Throws:

java.sql.SQLException

GeometryExceptionWithContext

gmlToSTRUCT

public static oracle.sql.STRUCT gmlToSTRUCT(java.lang.String gml)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

gml311ToSTRUCT

public static oracle.sql.STRUCT gml311ToSTRUCT(java.lang.String gml)
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

kmlToSTRUCT

public static oracle.sql.STRUCT kmlToSTRUCT(java.lang.String kml)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

buffer

public static oracle.sql.STRUCT buffer(oracle.sql.STRUCT geom,
                                       oracle.sql.NUMBER bufferWidth,
                                       oracle.sql.NUMBER sma,
                                       oracle.sql.NUMBER iflat,
                                       oracle.sql.NUMBER arcT)
                                throws java.sql.SQLException,
                                       java.lang.Exception

Throws:

java.sql.SQLException

java.lang.Exception

anyInteract

public static java.lang.String anyInteract(oracle.sql.STRUCT geom1,
                                           oracle.sql.STRUCT geom2,
                                           java.lang.String is_g3d,
                                           oracle.sql.NUMBER tolerance)
                                    throws java.lang.Exception

Throws:

java.lang.Exception

distance

public static oracle.sql.NUMBER distance(oracle.sql.STRUCT geom1,
                                         oracle.sql.STRUCT geom2,
                                         oracle.sql.NUMBER tolerance)
                                  throws java.lang.Exception

Throws:

java.lang.Exception

length

public static oracle.sql.NUMBER length(oracle.sql.STRUCT geom,
                                       oracle.sql.NUMBER count_shared_edges,
                                       oracle.sql.NUMBER tolerance)
                                throws java.lang.Exception

Throws:

java.lang.Exception

area

public static oracle.sql.NUMBER area(oracle.sql.STRUCT geom,
                                     oracle.sql.NUMBER tolerance)
                              throws java.lang.Exception

Throws:

java.lang.Exception

volume

public static oracle.sql.NUMBER volume(oracle.sql.STRUCT geom,
                                       oracle.sql.NUMBER tolerance)
                                throws java.lang.Exception

Throws:

java.lang.Exception

validateGeom

public static java.lang.String validateGeom(oracle.sql.STRUCT geom,
                                            java.lang.String conditional,
                                            oracle.sql.NUMBER chck3dsrid,
                                            oracle.sql.NUMBER tolerance)
                                     throws java.lang.Exception

Throws:

java.lang.Exception

closestPoints

public static oracle.sql.STRUCT closestPoints(oracle.sql.STRUCT geom1,
                                              oracle.sql.STRUCT geom2,
                                              oracle.sql.NUMBER tolerance)
                                       throws java.lang.Exception

Throws:

java.lang.Exception

affineTransforms

public static oracle.sql.STRUCT affineTransforms(oracle.sql.STRUCT geom,
                                                 java.lang.String translation,
                                                 oracle.sql.NUMBER tx,
                                                 oracle.sql.NUMBER ty,
                                                 oracle.sql.NUMBER tz,
                                                 java.lang.String scaling,
                                                 oracle.sql.STRUCT Psc1,
                                                 oracle.sql.NUMBER sx,
                                                 oracle.sql.NUMBER sy,
                                                 oracle.sql.NUMBER sz,
                                                 java.lang.String rotation,
                                                 oracle.sql.STRUCT P1,
                                                 oracle.sql.STRUCT line1,
                                                 oracle.sql.NUMBER angle,
                                                 oracle.sql.NUMBER dir,
                                                 java.lang.String shearing,
                                                 oracle.sql.NUMBER SHxy,
                                                 oracle.sql.NUMBER SHyx,
                                                 oracle.sql.NUMBER SHxz,
                                                 oracle.sql.NUMBER SHzx,
                                                 oracle.sql.NUMBER SHyz,
                                                 oracle.sql.NUMBER SHzy,
                                                 java.lang.String reflection,
                                                 oracle.sql.STRUCT Pref,
                                                 oracle.sql.STRUCT lineR,
                                                 oracle.sql.NUMBER dirR,
                                                 java.lang.String planeR,
                                                 oracle.spatial.type.SdoNumberArray n,
                                                 oracle.spatial.type.SdoNumberArray bigD)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

gmlToSTRUCT

public static oracle.sql.STRUCT gmlToSTRUCT(java.lang.String gml,
                                            java.lang.String srsNameSpace)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

gmlToSTRUCT

public static oracle.sql.STRUCT gmlToSTRUCT(java.lang.String gml,
                                            java.sql.Connection conn)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

gmlToSTRUCT

public static oracle.sql.STRUCT gmlToSTRUCT(oracle.sql.CLOB gml)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

gmlToSTRUCT

public static oracle.sql.STRUCT gmlToSTRUCT(oracle.sql.CLOB gml,
                                            java.lang.String srsNameSpace)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

gml311ToSTRUCT

public static oracle.sql.STRUCT gml311ToSTRUCT(java.lang.String gml,
                                               java.lang.String srsNameSpace)
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

gml311ToSTRUCT

public static oracle.sql.STRUCT gml311ToSTRUCT(java.lang.String gml,
                                               java.sql.Connection conn)
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

gml311ToSTRUCT

public static oracle.sql.STRUCT gml311ToSTRUCT(oracle.sql.CLOB gml)
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

gml311ToSTRUCT

public static oracle.sql.STRUCT gml311ToSTRUCT(oracle.sql.CLOB gml,
                                               java.lang.String srsNameSpace)
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

kmlToSTRUCT

public static oracle.sql.STRUCT kmlToSTRUCT(java.lang.String kml,
                                            java.sql.Connection conn)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

kmlToSTRUCT

public static oracle.sql.STRUCT kmlToSTRUCT(oracle.sql.CLOB kml)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

structToWkb

public static oracle.sql.BLOB structToWkb(oracle.sql.STRUCT geom)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

structToWkb

public static oracle.sql.BLOB structToWkb(oracle.sql.STRUCT geom,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

structToWkb2

protected static oracle.sql.BLOB structToWkb2(oracle.sql.STRUCT geom,
                                              java.sql.Connection conn)
                                       throws java.sql.SQLException,
                                              GeometryExceptionWithContext

Throws:

java.sql.SQLException

GeometryExceptionWithContext

structToWkt

public static oracle.sql.CLOB structToWkt(oracle.sql.STRUCT geom)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

structToWktString

public static java.lang.String structToWktString(oracle.sql.STRUCT geom)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

structToWkt

public static oracle.sql.CLOB structToWkt(oracle.sql.STRUCT geom,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

structToWkt2

protected static oracle.sql.CLOB structToWkt2(oracle.sql.STRUCT geom,
                                              java.sql.Connection conn)
                                       throws java.sql.SQLException,
                                              GeometryExceptionWithContext

Throws:

java.sql.SQLException

GeometryExceptionWithContext

structToWktString2

protected static java.lang.String structToWktString2(oracle.sql.STRUCT geom)
                                              throws java.sql.SQLException,
                                                     GeometryExceptionWithContext

Throws:

java.sql.SQLException

GeometryExceptionWithContext

validateWkt

public static java.lang.String validateWkt(oracle.sql.CLOB wkt)

validateWkt

public static java.lang.String validateWkt(oracle.sql.CLOB wkt,
                                           java.sql.Connection conn)

validateWkt

public static java.lang.String validateWkt(java.lang.String wkt)

validateWkt

public static java.lang.String validateWkt(java.lang.String wkt,
                                           java.sql.Connection conn)

validateWkb

public static java.lang.String validateWkb(oracle.sql.BLOB wkb)

validateWkb

public static java.lang.String validateWkb(oracle.sql.BLOB wkb,
                                           java.sql.Connection conn)

validate_layer_with_context_3D

public static oracle.sql.NUMBER validate_layer_with_context_3D(java.lang.String geomTableName,
                                                               java.lang.String geomColumnName,
                                                               java.lang.String resultTableName,
                                                               oracle.sql.NUMBER commit_interval,
                                                               java.lang.String conditional,
                                                               oracle.sql.NUMBER chck3dsrid,
                                                               oracle.sql.NUMBER tolerance)
                                                        throws java.sql.SQLException,
                                                               java.lang.Exception

Throws:

java.sql.SQLException

java.lang.Exception

centroid_3d

public static oracle.sql.STRUCT centroid_3d(oracle.sql.STRUCT geom,
                                            oracle.sql.NUMBER tolerance)
                                     throws java.lang.Exception,
                                            java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

extrusion2

public static oracle.sql.STRUCT extrusion2(oracle.sql.STRUCT polygon,
                                           oracle.spatial.type.SdoNumberArray grdHeight,
                                           oracle.spatial.type.SdoNumberArray height,
                                           oracle.sql.NUMBER tolerance,
                                           oracle.sql.NUMBER optional3dSrid)
                                    throws java.lang.Exception,
                                           java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

ringUnionApprox

public static oracle.sql.STRUCT ringUnionApprox(oracle.sql.STRUCT polygon,
                                                oracle.sql.NUMBER tolerance)
                                         throws java.lang.Exception,
                                                java.sql.SQLException

Throws:

java.lang.Exception

java.sql.SQLException

ringUnion

protected static oracle.spatial.geometry.JGeometry ringUnion(oracle.spatial.geometry.JGeometry g,
                                                             double tol)

extract3d

public static oracle.sql.STRUCT extract3d(oracle.sql.STRUCT geom,
                                          java.lang.String label)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

getlabelbyelement

public static java.lang.String getlabelbyelement(oracle.sql.STRUCT source_Geom,
                                                 oracle.sql.STRUCT qry_Element,
                                                 oracle.sql.NUMBER tolerance)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

inside3d

public static java.lang.String inside3d(oracle.sql.STRUCT geom1,
                                        oracle.sql.STRUCT geom2,
                                        java.lang.String is_g3d,
                                        oracle.sql.NUMBER tolerance)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

readpts

public static void readpts(oracle.sql.BLOB ptlob,
                           int numpts,
                           int ndim,
                           oracle.spatial.util.Adapters.Ptclass[] ptarr)
                    throws java.sql.SQLException,
                           java.io.IOException

Throws:

java.sql.SQLException

java.io.IOException

writepts

public static void writepts(oracle.sql.BLOB ptlob,
                            int numpts,
                            int ndim,
                            oracle.spatial.util.Adapters.Ptclass[] ptarr)
                     throws java.sql.SQLException,
                            java.io.IOException

Throws:

java.sql.SQLException

java.io.IOException

pctrclip

public static oracle.sql.BLOB pctrclip(oracle.sql.STRUCT qry,
                                       oracle.sql.STRUCT attr_qry,
                                       oracle.sql.BLOB pts,
                                       oracle.sql.NUMBER npts,
                                       oracle.sql.NUMBER numdim,
                                       oracle.sql.BLOB trs,
                                       oracle.sql.NUMBER ntrs,
                                       oracle.sql.NUMBER tolerance)
                                throws java.sql.SQLException,
                                       java.io.IOException,
                                       java.lang.Exception

Throws:

java.sql.SQLException

java.io.IOException

java.lang.Exception

expandG3Dgeoms

public static oracle.sql.STRUCT expandG3Dgeoms(oracle.sql.STRUCT geom)
                                        throws java.lang.Exception

Throws:

java.lang.Exception