org.gvsig.fmap.dal.store.oracle

Class OracleUtils

java.lang.Object

org.gvsig.fmap.dal.store.oracle.OracleUtils

public class OracleUtils
extends java.lang.Object

Utility class with static methods.

Author:

jldominguez, vsanjaime

Field Summary

Fields

Modifier and Type	Field and Description
static java.awt.geom.Rectangle2D	DEFAULT_BBOX
static java.awt.geom.Rectangle2D	DEFAULT_BBOX_DEGREE
static java.awt.geom.Rectangle2D	DEFAULT_BBOX_METER
static java.lang.String	DIMENSIONS_ID
static java.lang.String	ENVELOPE_ID
static java.lang.String	EXPONENTIAL_INDICES_CONDITION

Constructor Summary

Constructors

Constructor and Description
OracleUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static oracle.sql.Datum[]	appendDatArrays(oracle.sql.Datum[] head, oracle.sql.Datum[] tail)
static oracle.sql.STRUCT	appendGeometriesInStruct(org.gvsig.fmap.geom.Geometry[] geoms, int _forced_type, java.sql.Connection conn, java.lang.String osrid, boolean withSrid, boolean agu_bien, boolean _isGeoCS) This method appends the geometries from a geometries array in one STRUCT.
static int[]	appendIntArrays(int[] head, int[] tail)
static java.lang.String	binaryUnionEnvs(org.gvsig.fmap.geom.primitive.Envelope[] enves, java.lang.String ora_srid, boolean is_geo, java.lang.String tol, java.sql.Connection conn, int depth)
static oracle.sql.STRUCT	buildSTRUCT(org.gvsig.fmap.geom.Geometry geom, int _forced_type, java.sql.Connection conn, java.lang.String osrid, boolean withSrid, boolean agu_bien, boolean _isGeoCS) Converts Geometry to STRUCT
static void	copyFeatureTypeToOracleStoreParams(org.gvsig.fmap.dal.feature.EditableFeatureType efType, OracleStoreParameters params)
static org.gvsig.fmap.geom.Geometry	createNullGeometry(int stype)
static oracle.sql.STRUCT	createStruct(oracle.sql.NUMBER type, oracle.sql.NUMBER srid, oracle.sql.Datum[] info, oracle.sql.Datum[] ords, java.sql.Connection conn) Utility method to create a struct with the given data.
static double	determinant(double[][] a, int n) Utility method to compute a matrix determinant
static int	dimensionsFromSubtype(int subtype)
static java.awt.geom.Rectangle2D	doIntersect(java.awt.geom.Rectangle2D r1, java.awt.geom.Rectangle2D r2)
static org.gvsig.fmap.geom.Geometry	envelopesToGeometry(java.util.ArrayList accum)
static java.awt.geom.Rectangle2D	envelopeToRectangle2D(org.gvsig.fmap.geom.primitive.Envelope envelope)
static java.lang.String	epsgToOracleSrid(java.lang.String epsg) Get oracle srid from srs code(EPSG code)
static oracle.sql.STRUCT	geometryToSTRUCT(org.gvsig.fmap.geom.Geometry geom, java.sql.Connection conn, int osrid, boolean agu_b, boolean hasSrid) Utility method to convert a gvSIG Geometry into a oracle STRUCT
static java.lang.Object[]	getCenterAndRadiousOfCirc(java.awt.geom.Point2D[] points) Utility method to compute a circle's center and radius from three given points.
static java.lang.String	getCodeNumber(org.cresques.cts.IProjection p) Gets the numeric code of a projection: EPSG:4326 returns 4326 ESRI:1234 returns 1234
static java.lang.String	getDerivedName(java.lang.String tname, java.lang.String suffix)
static oracle.sql.ARRAY	getDevelopedInfoArray(oracle.sql.ARRAY info) Utility method to deal with oracle info arrays.
static oracle.sql.ARRAY	getDevelopedOrdsArray(oracle.sql.ARRAY ords, int dim) Utility method to deal with oracle coordinate arrays.
static java.lang.String	getDimInfoAsString(oracle.sql.ARRAY dim_info)
static org.gvsig.fmap.geom.primitive.Envelope	getEarthEnvelope()
static org.gvsig.fmap.geom.Geometry	getFMapGeometryCollection(oracle.sql.Datum[] the_data, int dim, boolean tableHasSrid, java.lang.String table_srid, java.sql.Connection _conn)
static org.gvsig.fmap.geom.Geometry	getFMapGeometryMultiLineString(oracle.sql.Datum[] the_data, int dim)
static org.gvsig.fmap.geom.Geometry	getFMapGeometryMultipolygon(oracle.sql.Datum[] the_data, int dim)
static org.gvsig.fmap.geom.Geometry	getFMapGeometryPoint(oracle.sql.Datum[] the_data, int dim)
static org.gvsig.fmap.geom.Geometry	getFMapGeometrySdoPoint(oracle.sql.Datum[] the_data, int d)
static java.lang.String	getFormattedInteger(int n) Utility method to get an ineteger as a formatted string.
static org.gvsig.fmap.geom.Geometry	getGeometry(oracle.sql.STRUCT st, boolean complex, boolean __tablehassrid, java.lang.String __tablesrid, java.sql.Connection _conn) Utility method to transform a struct into a IGeometry.
static int[]	getGeoTypeSubTypeOfOracleCode(int code)
static int[]	getGeoTypeSubTypeOfStruct(oracle.sql.STRUCT sample)
static int[]	getGoodMergeCoupe(org.gvsig.fmap.geom.primitive.Envelope[] envs)
static java.lang.Object[]	getHolesForShells(java.util.List<LineString3D> all_ls) This method tries to guess who is a shell and who is a hole from a set of linestrings.
static java.lang.Object	getId(org.gvsig.fmap.dal.feature.spi.FeatureReferenceProviderServices ref, org.gvsig.fmap.dal.feature.FeatureType ft)
static java.lang.String	getIntersectsEnvelopeSelect(java.lang.String geo_col_name, org.gvsig.fmap.geom.primitive.Envelope enve, java.lang.String ora_srid, boolean is_geo)
static java.lang.String	getIntersectsMultiRectSelect(java.lang.String geo_col_name, org.gvsig.fmap.geom.Geometry geome, java.lang.String ora_srid, boolean is_geo, java.sql.Connection conn)
static boolean	getIsGCS(java.lang.String oracleSRID2, boolean thas) Utility method to find out if a coordinate system is geodetic or not.
static oracle.sql.Datum[]	getNthGroupOfThree(oracle.sql.Datum[] list, int n)
static int[]	getNthGroupOfThree(int[] list, int n)
static java.lang.Object[]	getOrdOfGroups(oracle.sql.Datum[] all, java.lang.Object[] groups)
static java.lang.Object[]	getOrdOfGroups(double[] all, java.lang.Object[] groups)
static double[]	getOrds(oracle.sql.Datum[] the_data) Gets a struct's coordinates array.
static org.gvsig.fmap.geom.primitive.Primitive	getPrimitive(oracle.sql.STRUCT st, boolean complex) Utility method to transform a struct into a IGeometry.
static java.lang.String	getSdoConstructor(org.gvsig.fmap.geom.primitive.Envelope _enve, java.lang.String ora_srid, boolean is_geo)
static java.lang.String	getSdoConstructor(org.gvsig.fmap.geom.Geometry geome, java.lang.String ora_srid, boolean is_geo, java.sql.Connection conn)
static int	getShapeTypeFromArray(java.util.ArrayList arrlist)
static int	getStructDimensions(oracle.sql.STRUCT st) Gets the struct's dimension size.
static int	getStructSRID(oracle.sql.Datum[] the_data) Utility method to get struct's SRID.
static int	getStructType(oracle.sql.Datum[] the_data) Utility method to get struct's type.
static oracle.sql.Datum[]	getSubSet(oracle.sql.Datum[] all, int first_inc, int last_inc)
static double[]	getSubSet(double[] all, int first_inc, int last_inc)
static java.lang.Object[]	groupByElement(oracle.sql.Datum[] all_elem)
static java.lang.Object[]	groupByElement(int[] all_elem)
static boolean	hasSeveralGeometryTypes(java.util.List tt, boolean are_dims)
static org.gvsig.fmap.geom.primitive.Envelope	intersectEnvs(org.gvsig.fmap.geom.primitive.Envelope a, org.gvsig.fmap.geom.primitive.Envelope b)
static boolean	isActuallyACollection(oracle.sql.Datum[] the_data)
static boolean	isCircle(oracle.sql.Datum[] the_data) Utility method to find out if a struct is a circle.
static boolean	isSimpleCollectionOfLines(oracle.sql.Datum[] all_elem)
static int	maxSizeForFieldType(int _type)
static int	oracleGTypeToFShapeType(int otype, boolean complex) Utility method.
static int	oracleGTypeToGvsigGeometryType(int otype) Utility method.
static java.lang.Integer	oracleSridToEpsg(java.lang.String oraSRID) Get EPSG SRS from Oracle SRS
static boolean	polStructIsRectStruct(oracle.sql.ARRAY info, oracle.sql.ARRAY ords) Tells whether these arrays belong to a rectangle polygon.
static java.lang.String	printArray(oracle.sql.NUMBER[] array)
static void	printStruct(oracle.sql.STRUCT st)
static java.lang.String	projectionToOracleSrid(org.cresques.cts.IProjection proj) Get Oracle SRS from gvSIG projection
static org.gvsig.fmap.geom.Geometry	readGeometry3D(java.net.URL filepath, boolean polygon) COnstructs a geometry from a file that contains a vertex per line: x1 y1 z1 x2 y2 z2 ...
static oracle.sql.STRUCT	rectangleToStruct(java.awt.geom.Rectangle2D r, boolean hasSrid, boolean isView, boolean _isGeogCS, java.lang.String osrid, java.sql.Connection __conn)
static oracle.sql.Datum[]	removeThreeFirst(oracle.sql.Datum[] elem)
static oracle.sql.STRUCT	reprojectGeometry(java.sql.Connection conn, oracle.sql.STRUCT fromStruct, java.lang.String toSrid)
static double[]	reverseArray(double[] _z) Utility method to reverse an array of doubles.
static com.vividsolutions.jts.geom.Coordinate[]	reverseCoordinateArray(com.vividsolutions.jts.geom.Coordinate[] _z) Utility method to reverse an array of coordinates
static org.gvsig.fmap.geom.Geometry	roughIntersection(org.gvsig.fmap.geom.Geometry geom, org.gvsig.fmap.geom.primitive.Envelope env)
static void	showMemory()
static org.gvsig.fmap.geom.primitive.GeneralPathX	structToGPX(oracle.sql.Datum[] aux) utility method to convert a STRUCT into a GeneralPathX
static java.lang.String	structToString(oracle.sql.STRUCT st)
static oracle.sql.Datum[]	updateIndexes(oracle.sql.Datum[] info)
static int[]	updateIndexes(int[] info)

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_BBOX

public static final java.awt.geom.Rectangle2D DEFAULT_BBOX

DEFAULT_BBOX_DEGREE

public static final java.awt.geom.Rectangle2D DEFAULT_BBOX_DEGREE

DEFAULT_BBOX_METER

public static final java.awt.geom.Rectangle2D DEFAULT_BBOX_METER

DIMENSIONS_ID

public static final java.lang.String DIMENSIONS_ID

See Also:

Constant Field Values

ENVELOPE_ID

public static final java.lang.String ENVELOPE_ID

See Also:

Constant Field Values

EXPONENTIAL_INDICES_CONDITION

public static java.lang.String EXPONENTIAL_INDICES_CONDITION

Constructor Detail

OracleUtils

public OracleUtils()

Method Detail

appendDatArrays

public static oracle.sql.Datum[] appendDatArrays(oracle.sql.Datum[] head,
                                 oracle.sql.Datum[] tail)

Parameters:

head -

tail -

Returns:

appendGeometriesInStruct

public static oracle.sql.STRUCT appendGeometriesInStruct(org.gvsig.fmap.geom.Geometry[] geoms,
                                         int _forced_type,
                                         java.sql.Connection conn,
                                         java.lang.String osrid,
                                         boolean withSrid,
                                         boolean agu_bien,
                                         boolean _isGeoCS)
                                                  throws java.sql.SQLException

This method appends the geometries from a geometries array in one STRUCT.

Parameters:

co - the geometry collection

_forced_type - a type that has to be used as the struct's main type

_conn - the connection

_o_srid - the geometry's SRS (oracle code)

withSrid - whether the SRS is non-NULL

agu_bien - whether to check holes' validity

_isGeoCS - whether the SRS is geodetic

Returns:

the STRUCT with the appended geometries

Throws:

java.sql.SQLException

appendIntArrays

public static int[] appendIntArrays(int[] head,
                    int[] tail)

Parameters:

head -

tail -

Returns:

binaryUnionEnvs

public static java.lang.String binaryUnionEnvs(org.gvsig.fmap.geom.primitive.Envelope[] enves,
                               java.lang.String ora_srid,
                               boolean is_geo,
                               java.lang.String tol,
                               java.sql.Connection conn,
                               int depth)
                                        throws java.lang.Exception

Parameters:

envs -

ora_srid -

is_geo -

geomDefaultTol -

Returns:

Throws:

java.lang.Exception

buildSTRUCT

public static oracle.sql.STRUCT buildSTRUCT(org.gvsig.fmap.geom.Geometry geom,
                            int _forced_type,
                            java.sql.Connection conn,
                            java.lang.String osrid,
                            boolean withSrid,
                            boolean agu_bien,
                            boolean _isGeoCS)

Converts Geometry to STRUCT

Parameters:

geom - the geometry to convert

_forced_type - forced type to use

_conn - connection

_o_srid - SRS (oracle code)

withSrid - whether this STRUCT has a non-NULL SRS

agu_bien - whether or not to check the correctness of the holes

_isGeoCS - whether the SRS is geodetic or not

Returns:

the generated STRUCT

Throws:

java.sql.SQLException

copyFeatureTypeToOracleStoreParams

public static void copyFeatureTypeToOracleStoreParams(org.gvsig.fmap.dal.feature.EditableFeatureType efType,
                                      OracleStoreParameters params)

createNullGeometry

public static org.gvsig.fmap.geom.Geometry createNullGeometry(int stype)

createStruct

public static oracle.sql.STRUCT createStruct(oracle.sql.NUMBER type,
                             oracle.sql.NUMBER srid,
                             oracle.sql.Datum[] info,
                             oracle.sql.Datum[] ords,
                             java.sql.Connection conn)

Utility method to create a struct with the given data.

Parameters:

type - struct type

srid - coordinate system

info - element info array

ords - coordinates array

conn - connection

Returns:

the created struct

determinant

public static double determinant(double[][] a,
                 int n)

Utility method to compute a matrix determinant

Parameters:

a - the matrix

n - matrix size

Returns:

the matrix's determinant

dimensionsFromSubtype

public static int dimensionsFromSubtype(int subtype)

doIntersect

public static java.awt.geom.Rectangle2D doIntersect(java.awt.geom.Rectangle2D r1,
                                    java.awt.geom.Rectangle2D r2)

Parameters:

r1 -

r2 -

Returns:

envelopesToGeometry

public static org.gvsig.fmap.geom.Geometry envelopesToGeometry(java.util.ArrayList accum)
                                                        throws java.lang.Exception

Parameters:

accum -

Returns:

Throws:

java.lang.Exception

envelopeToRectangle2D

public static java.awt.geom.Rectangle2D envelopeToRectangle2D(org.gvsig.fmap.geom.primitive.Envelope envelope)

epsgToOracleSrid

public static java.lang.String epsgToOracleSrid(java.lang.String epsg)

Get oracle srid from srs code(EPSG code)

Parameters:

epsg -

Returns:

oraSRID

geometryToSTRUCT

public static oracle.sql.STRUCT geometryToSTRUCT(org.gvsig.fmap.geom.Geometry geom,
                                 java.sql.Connection conn,
                                 int osrid,
                                 boolean agu_b,
                                 boolean hasSrid)
                                          throws java.sql.SQLException

Utility method to convert a gvSIG Geometry into a oracle STRUCT

Parameters:

geom - the FShape object

c - the connection

srid - the SRS (oracle code)

agu_b - whether to check holes validity

hasSrid - whether the SRS is non-NULL

Returns:

a oracle struct representing the geometry

Throws:

java.sql.SQLException

getCenterAndRadiousOfCirc

public static java.lang.Object[] getCenterAndRadiousOfCirc(java.awt.geom.Point2D[] points)

Utility method to compute a circle's center and radius from three given points.

Parameters:

points - three points of a circumference

Returns:

a 2-item array with the circumference's center (Point2D) and radius (Double)

getCodeNumber

public static java.lang.String getCodeNumber(org.cresques.cts.IProjection p)

Gets the numeric code of a projection: EPSG:4326 returns 4326 ESRI:1234 returns 1234

Parameters:

p -

Returns:

getDerivedName

public static java.lang.String getDerivedName(java.lang.String tname,
                              java.lang.String suffix)

Parameters:

tname -

suffix -

Returns:

getDevelopedInfoArray

public static oracle.sql.ARRAY getDevelopedInfoArray(oracle.sql.ARRAY info)

Utility method to deal with oracle info arrays.

getDevelopedOrdsArray

public static oracle.sql.ARRAY getDevelopedOrdsArray(oracle.sql.ARRAY ords,
                                     int dim)

Utility method to deal with oracle coordinate arrays.

getDimInfoAsString

public static java.lang.String getDimInfoAsString(oracle.sql.ARRAY dim_info)

Parameters:

dim_info -

Returns:

getEarthEnvelope

public static org.gvsig.fmap.geom.primitive.Envelope getEarthEnvelope()

getFMapGeometryCollection

public static org.gvsig.fmap.geom.Geometry getFMapGeometryCollection(oracle.sql.Datum[] the_data,
                                                     int dim,
                                                     boolean tableHasSrid,
                                                     java.lang.String table_srid,
                                                     java.sql.Connection _conn)

getFMapGeometryMultiLineString

public static org.gvsig.fmap.geom.Geometry getFMapGeometryMultiLineString(oracle.sql.Datum[] the_data,
                                                          int dim)
                                                                   throws org.gvsig.fmap.geom.exception.CreateGeometryException

Parameters:

the_data -

dim -

Returns:

Throws:

org.gvsig.fmap.geom.exception.CreateGeometryException

getFMapGeometryMultipolygon

public static org.gvsig.fmap.geom.Geometry getFMapGeometryMultipolygon(oracle.sql.Datum[] the_data,
                                                       int dim)
                                                                throws org.gvsig.fmap.geom.exception.CreateGeometryException

Parameters:

the_data -

dim -

Returns:

Throws:

org.gvsig.fmap.geom.exception.CreateGeometryException

getFMapGeometryPoint

public static org.gvsig.fmap.geom.Geometry getFMapGeometryPoint(oracle.sql.Datum[] the_data,
                                                int dim)
                                                         throws org.gvsig.fmap.geom.exception.CreateGeometryException

Parameters:

the_data -

dim -

Returns:

Throws:

org.gvsig.fmap.geom.exception.CreateGeometryException

getFMapGeometrySdoPoint

public static org.gvsig.fmap.geom.Geometry getFMapGeometrySdoPoint(oracle.sql.Datum[] the_data,
                                                   int d)
                                                            throws org.gvsig.fmap.geom.exception.CreateGeometryException

Parameters:

the_data -

d -

Returns:

Throws:

org.gvsig.fmap.geom.exception.CreateGeometryException

getFormattedInteger

public static java.lang.String getFormattedInteger(int n)

Utility method to get an ineteger as a formatted string.

Parameters:

n - the integer

Returns:

the formatted string

getGeometry

public static org.gvsig.fmap.geom.Geometry getGeometry(oracle.sql.STRUCT st,
                                       boolean complex,
                                       boolean __tablehassrid,
                                       java.lang.String __tablesrid,
                                       java.sql.Connection _conn)

Utility method to transform a struct into a IGeometry.

Parameters:

st - the struct to be converted

complex - comes from a complex sdo geometry

Returns:

the IGeometry

getGeoTypeSubTypeOfOracleCode

public static int[] getGeoTypeSubTypeOfOracleCode(int code)

getGeoTypeSubTypeOfStruct

public static int[] getGeoTypeSubTypeOfStruct(oracle.sql.STRUCT sample)
                                       throws java.sql.SQLException

Parameters:

sample - input STRUCT

Returns:

type and subtype of geometry

Throws:

java.sql.SQLException

getGoodMergeCoupe

public static int[] getGoodMergeCoupe(org.gvsig.fmap.geom.primitive.Envelope[] envs)

getHolesForShells

public static java.lang.Object[] getHolesForShells(java.util.List<LineString3D> all_ls)

This method tries to guess who is a shell and who is a hole from a set of linestrings.

Parameters:

all_ls - a set of linestrings to be checked.

Returns:

a 2-item array. the first is an arraylist of linestrings thought to be shells. the second is an array of arraylists containing the holes of each shell found in the first item

getId

public static java.lang.Object getId(org.gvsig.fmap.dal.feature.spi.FeatureReferenceProviderServices ref,
                     org.gvsig.fmap.dal.feature.FeatureType ft)

getIntersectsEnvelopeSelect

public static java.lang.String getIntersectsEnvelopeSelect(java.lang.String geo_col_name,
                                           org.gvsig.fmap.geom.primitive.Envelope enve,
                                           java.lang.String ora_srid,
                                           boolean is_geo)

getIntersectsMultiRectSelect

public static java.lang.String getIntersectsMultiRectSelect(java.lang.String geo_col_name,
                                            org.gvsig.fmap.geom.Geometry geome,
                                            java.lang.String ora_srid,
                                            boolean is_geo,
                                            java.sql.Connection conn)

getIsGCS

public static boolean getIsGCS(java.lang.String oracleSRID2,
               boolean thas)

Utility method to find out if a coordinate system is geodetic or not.

Parameters:

oracleSRID2 - the coordinate system's oracle code

thas - whether the table has a coordinate system set. if not, the method returns false.

Returns:

whether the coordinate system is geodetic or not.

getNthGroupOfThree

public static oracle.sql.Datum[] getNthGroupOfThree(oracle.sql.Datum[] list,
                                    int n)

Parameters:

list -

n -

Returns:

getNthGroupOfThree

public static int[] getNthGroupOfThree(int[] list,
                       int n)

Parameters:

list -

n -

Returns:

getOrdOfGroups

public static java.lang.Object[] getOrdOfGroups(oracle.sql.Datum[] all,
                                java.lang.Object[] groups)
                                         throws java.sql.SQLException

Parameters:

all -

groups -

Returns:

Throws:

java.sql.SQLException

getOrdOfGroups

public static java.lang.Object[] getOrdOfGroups(double[] all,
                                java.lang.Object[] groups)

Parameters:

all -

groups -

Returns:

getOrds

public static double[] getOrds(oracle.sql.Datum[] the_data)

Gets a struct's coordinates array.

Parameters:

the_data - the struct's datum array

Returns:

the coordinates array

getPrimitive

public static org.gvsig.fmap.geom.primitive.Primitive getPrimitive(oracle.sql.STRUCT st,
                                                   boolean complex)

Utility method to transform a struct into a IGeometry.

Parameters:

st - the struct to be converted

complex - comes from a complex sdo geometry

Returns:

the IGeometry

getSdoConstructor

public static java.lang.String getSdoConstructor(org.gvsig.fmap.geom.primitive.Envelope _enve,
                                 java.lang.String ora_srid,
                                 boolean is_geo)

getSdoConstructor

public static java.lang.String getSdoConstructor(org.gvsig.fmap.geom.Geometry geome,
                                 java.lang.String ora_srid,
                                 boolean is_geo,
                                 java.sql.Connection conn)

getShapeTypeFromArray

public static int getShapeTypeFromArray(java.util.ArrayList arrlist)

getStructDimensions

public static int getStructDimensions(oracle.sql.STRUCT st)

Gets the struct's dimension size.

Parameters:

st - the struct

Returns:

the structs dimension

getStructSRID

public static int getStructSRID(oracle.sql.Datum[] the_data)

Utility method to get struct's SRID.

Parameters:

the_data - the struct's datum array

Returns:

the struct0's SRID

getStructType

public static int getStructType(oracle.sql.Datum[] the_data)

Utility method to get struct's type.

Parameters:

the_data - the struct's datum array

Returns:

the struct type

getSubSet

public static oracle.sql.Datum[] getSubSet(oracle.sql.Datum[] all,
                           int first_inc,
                           int last_inc)

Parameters:

all -

first_inc -

last_inc -

Returns:

getSubSet

public static double[] getSubSet(double[] all,
                 int first_inc,
                 int last_inc)

Parameters:

all -

first_inc -

last_inc -

Returns:

groupByElement

public static java.lang.Object[] groupByElement(oracle.sql.Datum[] all_elem)

Parameters:

all_elem -

Returns:

groupByElement

public static java.lang.Object[] groupByElement(int[] all_elem)

Parameters:

all_elem -

Returns:

hasSeveralGeometryTypes

public static boolean hasSeveralGeometryTypes(java.util.List tt,
                              boolean are_dims)

Parameters:

tt -

are_dims -

Returns:

intersectEnvs

public static org.gvsig.fmap.geom.primitive.Envelope intersectEnvs(org.gvsig.fmap.geom.primitive.Envelope a,
                                                   org.gvsig.fmap.geom.primitive.Envelope b)
                                                            throws java.lang.Exception

Throws:

java.lang.Exception

isActuallyACollection

public static boolean isActuallyACollection(oracle.sql.Datum[] the_data)

Parameters:

the_data -

Returns:

isCircle

public static boolean isCircle(oracle.sql.Datum[] the_data)

Utility method to find out if a struct is a circle.

Parameters:

the_data - the struct's datum array

Returns:

whether it is a circle

isSimpleCollectionOfLines

public static boolean isSimpleCollectionOfLines(oracle.sql.Datum[] all_elem)

Parameters:

all_elem -

Returns:

maxSizeForFieldType

public static int maxSizeForFieldType(int _type)

Parameters:

_type -

Returns:

oracleGTypeToFShapeType

public static int oracleGTypeToFShapeType(int otype,
                          boolean complex)

Utility method. Gets FShape type from oracle geometry type.

Parameters:

otype -

Returns:

FShape type

oracleGTypeToGvsigGeometryType

public static int oracleGTypeToGvsigGeometryType(int otype)

Utility method. Gets FShape type from oracle geometry type.

Parameters:

otype -

Returns:

FShape type

oracleSridToEpsg

public static java.lang.Integer oracleSridToEpsg(java.lang.String oraSRID)

Get EPSG SRS from Oracle SRS

Parameters:

oraSRID -

Returns:

polStructIsRectStruct

public static boolean polStructIsRectStruct(oracle.sql.ARRAY info,
                            oracle.sql.ARRAY ords)

Tells whether these arrays belong to a rectangle polygon.

Parameters:

info - the struct's element info array

ords - the struct's coordinate array

Returns:

true if it is a rectangle polygon. false otherwise.

printArray

public static java.lang.String printArray(oracle.sql.NUMBER[] array)

Parameters:

array -

Returns:

printStruct

public static void printStruct(oracle.sql.STRUCT st)

Parameters:

st -

projectionToOracleSrid

public static java.lang.String projectionToOracleSrid(org.cresques.cts.IProjection proj)

Get Oracle SRS from gvSIG projection

Parameters:

proj -

Returns:

readGeometry3D

public static org.gvsig.fmap.geom.Geometry readGeometry3D(java.net.URL filepath,
                                          boolean polygon)
                                                   throws org.gvsig.fmap.geom.exception.CreateGeometryException

COnstructs a geometry from a file that contains a vertex per line: x1 y1 z1 x2 y2 z2 ...

Parameters:

filepath - vertices text file path

polygon - whether it is a polygon or not

Returns:

the created geometry

Throws:

org.gvsig.fmap.geom.exception.CreateGeometryException

rectangleToStruct

public static oracle.sql.STRUCT rectangleToStruct(java.awt.geom.Rectangle2D r,
                                  boolean hasSrid,
                                  boolean isView,
                                  boolean _isGeogCS,
                                  java.lang.String osrid,
                                  java.sql.Connection __conn)

Parameters:

r -

hasSrid -

isView -

_isGeogCS -

_oracleSRID -

__conn -

Returns:

removeThreeFirst

public static oracle.sql.Datum[] removeThreeFirst(oracle.sql.Datum[] elem)

Parameters:

elem -

Returns:

reprojectGeometry

public static oracle.sql.STRUCT reprojectGeometry(java.sql.Connection conn,
                                  oracle.sql.STRUCT fromStruct,
                                  java.lang.String toSrid)

Parameters:

conn -

fromStruct -

toSrid -

Returns:

reverseArray

public static double[] reverseArray(double[] _z)

Utility method to reverse an array of doubles.

Parameters:

_z - an array of doubles to be reversed.

Returns:

the reversed array of doubles

reverseCoordinateArray

public static com.vividsolutions.jts.geom.Coordinate[] reverseCoordinateArray(com.vividsolutions.jts.geom.Coordinate[] _z)

Utility method to reverse an array of coordinates

Parameters:

_z - an array of coordinaes to be reversed.

Returns:

the reversed array of coordinates

roughIntersection

public static org.gvsig.fmap.geom.Geometry roughIntersection(org.gvsig.fmap.geom.Geometry geom,
                                             org.gvsig.fmap.geom.primitive.Envelope env)
                                                      throws java.lang.Exception

Throws:

java.lang.Exception

showMemory

public static void showMemory()

structToGPX

public static org.gvsig.fmap.geom.primitive.GeneralPathX structToGPX(oracle.sql.Datum[] aux)

utility method to convert a STRUCT into a GeneralPathX

Parameters:

aux - the struct's datum array

Returns:

the GeneralPathX instance created

structToString

public static java.lang.String structToString(oracle.sql.STRUCT st)
                                       throws java.lang.Exception

Throws:

java.lang.Exception

updateIndexes

public static oracle.sql.Datum[] updateIndexes(oracle.sql.Datum[] info)

Parameters:

info -

Returns:

updateIndexes

public static int[] updateIndexes(int[] info)

Parameters:

info -

Returns: