Application: gvSIG desktop » gvSIG projections

- COpetation.getInverted() no est? teniendo en cuenta si hay par?metros de transformaci?n -HECHO-

- Resolver el tema del cacheado de CRSs en los repositorios.

- Por qu? no est?n implementados  getPOrig() y getPDest() de COperation? -HECHO-

- Plantearse la necesidad de ICOperation:

	- COperation ya no la implementa. La conservo preventivamente. -HECHO-

- Crs y CrsGT: No construir los objetos CrsProj en el constructor, hacerlo la primera vez que se pidan.

- Habr?a que reducir el tiempo de arranque de la extensi?n.

- Depuraciones para detectar ineficiencias.

	- COperation.operate se llama para cada punto: optimizar su contenido (creaci?n de objetos). -HECHO-

	- Hacer que CrsGT.getCT no construya nuevos CrsProj cada vez que se llama.

- libJCrs y windows?????????????'

- ICrs: mirar qu? m?todos no tienen por qu? estar en la interfaz.

- Dependencias de gvSIG en libJCrs:

	- COperation.convert(...) utiliza: NotificationManager.addError(e) de andami;

	- Persistencia: depende de PluginServices de andami. -> subir la persistencia a la extension. -HECHO-

	- dependencia de CMS: IProjection, ICoordTrans, IDatum, ICRSFactory, org.cresques.geo.ViewPortData.

- Crs.getScale(): double invF = getDatum().getEIFlattening(); if (invF == Double.POSITIVE_INFINITY){}

	?Qu? valor da getDatum().getEIFlattening() en el caso de una esfera? geoltools da Double.POSITIVE_INFINITY.

- Busqueda IAU por zona: en mayusculas no encuentra. -HECHO-

- Persistencia de transformaciones en F2. -HECHO-

- Persistencia en el proyecto: Implementar IProyectio.getFullCode() y lo que esto implica. -HECHO-

- OGR y WINDOWS....!!!!???? 

- Revisar classpath de extJCRS (?log4j-1.2.8.jar?,etc...)

- Cuando CRS fuente y destino son iguales -> no operar, devolver el mismo punto.

BUGS:

- Cargas un shp 23030 diciendole que es 4258 con transf. EPSG (7) y salta una excepcci?n de proj4: controlar o subir estos

	errores (es un error como el que silenciamos de nadgrids).

	En este caso el error es debido a que las coordenadas se salen del rango del CRS elegido. Esta situaci?n ArcMap la maneja desavilitando

	la capa y dejando de visualizarla (algo parecedo a cuando gvSIG le pone la x de erroneo a una capa).

- Cuando hay un fallo al elegir el CRS de la vista y despu?s guardas el proyecto, parece ser que se guarda como null (o algo as?)

	y falla al abrirlo. Posibles soluciones: en esos casos guardar el CRS por defecto.

- Nomenclator: Cuando pulsas localizar, debe dibuajar el punto en la vista y hacer zoom a el. Lo dibuja pero aparece una

	excepci?n y no hace el zoom.

org.geotools.referencing.operation.projection.IdrAitoff$Provider

org.geotools.referencing.operation.projection.IdrAzimuthalEquidistant$Provider

org.geotools.referencing.operation.projection.IdrAzimuthalEquidistant$Provider_Modified

org.geotools.referencing.operation.projection.IdrAzimuthalEquidistant$Provider_Guam

org.geotools.referencing.operation.projection.IdrBonne$Provider

org.geotools.referencing.operation.projection.IdrBonne$Provider_SouthOrientated

org.geotools.referencing.operation.projection.IdrCassiniSoldner$Provider

org.geotools.referencing.operation.projection.IdrCassiniSoldner$Provider_Hyperbolic

org.geotools.referencing.operation.projection.IdrCrasterParabolic$Provider

org.geotools.referencing.operation.projection.IdrCylindricalEqualArea$Provider

org.geotools.referencing.operation.projection.IdrEckertI$Provider

org.geotools.referencing.operation.projection.IdrEckertII$Provider

org.geotools.referencing.operation.projection.IdrEckertIII$Provider

org.geotools.referencing.operation.projection.IdrEckertIV$Provider

org.geotools.referencing.operation.projection.IdrEckertV$Provider

org.geotools.referencing.operation.projection.IdrEckertVI$Provider

org.geotools.referencing.operation.projection.IdrEquidistantConic$Provider

org.geotools.referencing.operation.projection.IdrEquidistantCylindrical$Provider

org.geotools.referencing.operation.projection.IdrEquirectangular$Provider

org.geotools.referencing.operation.projection.IdrFlatPolarQuartic$Provider

org.geotools.referencing.operation.projection.IdrGallStereographic$Provider

org.geotools.referencing.operation.projection.IdrGnomonic$Provider

org.geotools.referencing.operation.projection.IdrGoode$Provider

org.geotools.referencing.operation.projection.IdrHammerAitoff$Provider

org.geotools.referencing.operation.projection.IdrKrovak$Provider

org.geotools.referencing.operation.projection.IdrLabordeMadagascar$Provider

org.geotools.referencing.operation.projection.IdrLambertAzimuthalEqualArea$Provider

org.geotools.referencing.operation.projection.IdrLambertConformalWestOrientated$Provider

org.geotools.referencing.operation.projection.IdrLambertConicNearConformal$Provider

org.geotools.referencing.operation.projection.IdrLoximuthal$Provider

org.geotools.referencing.operation.projection.IdrMercator$Provider1SP

org.geotools.referencing.operation.projection.IdrMillerCylindrical$Provider

org.geotools.referencing.operation.projection.IdrMollweide$Provider

org.geotools.referencing.operation.projection.IdrNearSidedPerspective$Provider

org.geotools.referencing.operation.projection.IdrNewZealandMapGrid$Provider

org.geotools.referencing.operation.projection.IdrObliqueMercator$Provider

org.geotools.referencing.operation.projection.IdrObliqueMercator$Provider_Hotine

org.geotools.referencing.operation.projection.IdrObliqueMercator$Provider_TwoPoint

org.geotools.referencing.operation.projection.IdrObliqueMercator$Provider_Hotine_TwoPoint

org.geotools.referencing.operation.projection.IdrOrthographic$Provider

org.geotools.referencing.operation.projection.IdrPlateCarree$Provider

org.geotools.referencing.operation.projection.IdrPolyconic$Provider

org.geotools.referencing.operation.projection.IdrQuarticAuthalic$Provider

org.geotools.referencing.operation.projection.IdrRobinson$Provider

org.geotools.referencing.operation.projection.IdrSinusoidal$Provider

org.geotools.referencing.operation.projection.IdrTransverseMercator$Provider

org.geotools.referencing.operation.projection.IdrTransverseMercator$Provider_SouthOrientated

org.geotools.referencing.operation.projection.IdrTransverseMercator$Provider_TransverseMercatorZonedGridSystem

org.geotools.referencing.operation.projection.IdrTunisiaMiningGrid$Provider

org.geotools.referencing.operation.projection.IdrVanDerGrinten$Provider

org.geotools.referencing.operation.projection.IdrWinkelI$Provider

org.geotools.referencing.operation.projection.IdrWinkelII$Provider

org.geotools.referencing.operation.projection.IdrWinkelTripel$Provider

org.gvsig.crs.JCRSLibrary

es.idr.teledeteccion.connection.esri.FactoryUsingHSQL

es.idr.teledeteccion.connection.usr.FactoryUsingHSQL

es.idr.teledeteccion.connection.iau2000.FactoryUsingHSQL

/*

 *    GeoTools - OpenSource mapping toolkit

 *    http://geotools.org

 *    (C) 2005-2006, GeoTools Project Managment Committee (PMC)

 * 

 *    This library is free software; you can redistribute it and/or

 *    modify it under the terms of the GNU Lesser General Public

 *    License as published by the Free Software Foundation;

 *    version 2.1 of the License.

 *

 *    This library is distributed in the hope that it will be useful,

 *    but WITHOUT ANY WARRANTY; without even the implied warranty of

 *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

 *    Lesser General Public License for more details.

 */

package es.idr.teledeteccion.connection.usr;

// J2SE dependencies

import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.text.ParseException;

import java.util.Hashtable;

import java.util.Set;

import org.geotools.metadata.iso.citation.CitationImpl;

import org.geotools.referencing.wkt.Parser;

import org.gvsig.crs.CrsFactory;

import org.hsqldb.jdbc.jdbcDataSource;

import org.opengis.metadata.citation.Citation;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.IdentifiedObject;

import org.opengis.referencing.crs.CRSAuthorityFactory;

import org.opengis.referencing.crs.CRSFactory;

import org.opengis.referencing.crs.CompoundCRS;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

import org.opengis.referencing.crs.DerivedCRS;

import org.opengis.referencing.crs.EngineeringCRS;

import org.opengis.referencing.crs.GeocentricCRS;

import org.opengis.referencing.crs.GeographicCRS;

import org.opengis.referencing.crs.ImageCRS;

import org.opengis.referencing.crs.ProjectedCRS;

import org.opengis.referencing.crs.TemporalCRS;

import org.opengis.referencing.crs.VerticalCRS;

import org.opengis.util.InternationalString;

public class FactoryUsingHSQL extends jdbcDataSource implements CRSAuthorityFactory {

    /**

     * The connection to the EPSG database.

     */

    protected Connection connection;

    //  object factory

    protected CRSFactory crsFactory;

    /** Cache of parsed CoordinateReferenceSystem WKT by ESRI_NUMBER */

    private Hashtable cache = new Hashtable();

    /**

     * The database name.

     *

     * @since 2.3

     */

    public static final String DATABASE_NAME = "USR";

    public FactoryUsingHSQL() {

    	 try {

             loadDefault();

         }

         catch( IOException oops ){

             System.err.println("Could not load "+ oops );

         }

    	//this(FactoryFinder.getCRSFactory(null));

    }   

	protected FactoryUsingHSQL(CRSFactory factory) {

		this.crsFactory = factory;

        try {

            loadDefault();

        }

        catch( IOException oops ){

            System.err.println("Could not load "+ oops );

        }

	}

	protected void loadDefault() throws IOException {

		String db = "jdbc:hsqldb:file:" + CrsFactory.getDataBaseFolder().getAbsolutePath() + "/usr";

		setDatabase(db);

		setUser("sa");

		try {

			connection = super.getConnection();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

    }

	public CoordinateReferenceSystem createCoordinateReferenceSystem(String code) throws FactoryException {

		// TODO Auto-generated method stub

		CoordinateReferenceSystem returnValue = null;

		String wkt = null;

		String USR_NUMBER = code.substring(code.indexOf(":")+1, code.length());

		int cod = Integer.parseInt(USR_NUMBER);

		if( cache.contains( USR_NUMBER ) ){

            Object value = cache.get( USR_NUMBER );

            if( value instanceof Throwable ){

                throw new FactoryException( "WKT for "+code+" could not be parsed", (Throwable) value );

            }

            if( value instanceof CoordinateReferenceSystem){

                return (CoordinateReferenceSystem) value;

            }            

        }

		try {        	

        	final PreparedStatement stmt;

            String sentence = "SELECT USR_WKT"

            + " FROM USR"

            + " WHERE USR_CODE = " + code.substring(code.indexOf(":")+1, code.length());

        	Statement st = null;

    		ResultSet result = null;

    		loadDefault();

        	st = connection.createStatement();			

        	result = st.executeQuery(sentence);

			st.close();

			connection.close();

        	while (result.next()) {

                wkt    = result.getString("usr_wkt"); 	

            }

            result.close();

            if( wkt.indexOf( cod ) == -1){

            	wkt = wkt.trim();

            	wkt = wkt.substring(0, wkt.length()-1 );

            	wkt += ",AUTHORITY[\"USR\",\""+cod+"\"]]";

            }

        } catch (SQLException exception) {

            System.out.println(exception);

        } catch (IOException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

        Parser parser = new Parser();

		try {

			returnValue = parser.parseCoordinateReferenceSystem(wkt);

		} catch (ParseException e) {

			// TODO Auto-generated catch block

			System.out.println("Cadena WKT no ha podido ser parseada");

			e.printStackTrace();

		}

        return returnValue;					

	}

	public CompoundCRS createCompoundCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public DerivedCRS createDerivedCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public EngineeringCRS createEngineeringCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public GeographicCRS createGeographicCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public GeocentricCRS createGeocentricCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public ImageCRS createImageCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public ProjectedCRS createProjectedCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public TemporalCRS createTemporalCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public VerticalCRS createVerticalCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public Citation getAuthority() {

		Citation citation = CitationImpl.createCitation("USR");

		citation.getIdentifiers().add("USR");

		return citation;

	}

	public Set getAuthorityCodes(Class arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public InternationalString getDescriptionText(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public IdentifiedObject createObject(String code) throws FactoryException {

		// TODO Auto-generated method stub

		return createCoordinateReferenceSystem(code);

	}

	public Citation getVendor() {

		// TODO Auto-generated method stub

		return null;

	}

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Instituto de Desarrollo Regional and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 */

package es.idr.teledeteccion.connection;

import java.sql.Connection;

import java.sql.SQLException;

import java.sql.Statement;

import org.gvsig.crs.CrsFactory;

import org.hsqldb.jdbc.jdbcDataSource;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import es.idr.teledeteccion.connection.epsg.HSQLDataSource;

/**

 * Clase para la conexi?n con la base de datos de hsqldb.

 * Establece el driver necesario, as? como la cadena de

 * conexi?n a la base de datos de la EPSG y la IAU2000

 *

 * @author Jos? Luis G?mez Mart?nez (jolugomar@gmail.com)

 *

 */

public class EpsgConnection extends jdbcDataSource {

    private static final Logger logger = LoggerFactory.getLogger(EpsgConnection.class);

    Connection connect = null;

    String connectionType = null;

    public EpsgConnection() {

        /*	try {

         Class.forName("org.hsqldb.jdbcDriver");

         } catch (ClassNotFoundException e) {

         logger.error("Can't create EpsgConnection",e); 

         }*/

    }

    private void setConnection(Connection connection, String type) {

        this.connect = connection;

        this.connectionType = type;

        logger.debug("Created connection to '"+connectionType+"'.");

    }

    public void setConnectionEPSG() {

        HSQLDataSource ds = new HSQLDataSource();

        try {

            setConnection(ds.getConnection(), "EPSG");

        } catch (SQLException e) {

            logger.warn("Cant get conection from HSQLDataSource.", e);

        }

    }

    /**

     * Establece la conexi?n con la base de datos de la IAU2000

     *

     */

    public void setConnectionIAU2000() {

        String db = "jdbc:hsqldb:file:" + CrsFactory.getDataBaseFolder().getAbsolutePath() + "/iau2000";

        setDatabase(db);

        setUser("sa");

        try {

            setConnection(super.getConnection(),"IAU2000");

        } catch (SQLException e) {

            logger.warn("Can't get conection from database '" + db + "'.", e);

        }

    }

    /**

     * Establece la conexi?n con la base de datos de ESRI

     *

     */

    public void setConnectionEsri() {

        String db = "jdbc:hsqldb:file:" + CrsFactory.getDataBaseFolder().getAbsolutePath() + "/esri";

        setDatabase(db);

        setUser("sa");

        try {

            setConnection(super.getConnection(),"Esri");

        } catch (SQLException e) {

            logger.warn("Can't get conection from database '" + db + "'.", e);

        }

    }

    /**

     * Sets connection for CRS:* coordinate reference systems

     * such as CRS:84

     *

     */

    public void setConnectionNoAuth() {

        String db = "jdbc:hsqldb:file:" + CrsFactory.getDataBaseFolder().getAbsolutePath() + "/noauth";

        setDatabase(db);

        setUser("sa");

        try {

            setConnection(super.getConnection(),"NoAuth");

        } catch (SQLException e) {

            logger.warn("Can't get conection from database '" + db + "'.", e);

        }

    }

    /**

     * Establece la conexi?n con la base de datos de USR

     *

     */

    public void setConnectionUsr() {

        String db = "jdbc:hsqldb:file:" + CrsFactory.getDataBaseFolder().getAbsolutePath() + "/usr";

        setDatabase(db);

        setUser("sa");

        try {

            setConnection(super.getConnection(),"Usr");

        } catch (SQLException e) {

            logger.warn("Can't get conection from database '" + db + "'.", e);

        }

    }

    public Connection getConnection() {

        return connect;

    }

    public void close() throws SQLException {

        try {

            connect.close();    // if there are no other open connection

            logger.debug("Shutdown connection to '" + connectionType + "' database.");

        } catch (Exception ex) {

            logger.warn("Can't shutdown the conexion.",ex);

        }

    }

    public void shutdown() throws SQLException {

        // db writes out to files and performs clean shuts down

        // otherwise there will be an unclean shutdown

        // when program ends

        try {

            Statement st = connect.createStatement();

            st.execute("SHUTDOWN");

            connect.close();    // if there are no other open connection

            logger.debug("Shutdown connection to '" + connectionType + "' database.");

        } catch (Exception ex) {

            logger.warn("Can't shutdown the conexion.",ex);

        }

    }

    public synchronized void update(String expression) throws SQLException {

        Statement st = null;

        st = connect.createStatement();

        int i = st.executeUpdate(expression);

        if ( i == -1 ) {

            logger.warn("db("+connectionType+")  error in statement: " + expression);

        }

        st.close();

    }

}

/*

 * Geotools 2 - OpenSource mapping toolkit

 * (C) 2005, Geotools Project Managment Committee (PMC)

 *

 *    This library is free software; you can redistribute it and/or

 *    modify it under the terms of the GNU Lesser General Public

 *    License as published by the Free Software Foundation; either

 *    version 2.1 of the License, or (at your option) any later version.

 *

 *    This library is distributed in the hope that it will be useful,

 *    but WITHOUT ANY WARRANTY; without even the implied warranty of

 *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

 *    Lesser General Public License for more details.

 *

 *    You should have received a copy of the GNU Lesser General Public

 *    License along with this library; if not, write to the Free Software

 *    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 */

package es.idr.teledeteccion.connection.epsg;

// J2SE dependencies

import java.io.BufferedReader;

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import java.io.InputStreamReader;

import java.lang.management.ManagementFactory;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.SQLFeatureNotSupportedException;

import java.sql.Statement;

import org.apache.commons.io.FileUtils;

import org.geotools.referencing.factory.AbstractAuthorityFactory;

import org.geotools.referencing.factory.FactoryGroup;

import org.geotools.referencing.factory.epsg.DataSource;

import org.geotools.referencing.factory.epsg.FactoryUsingSQL;

import org.gvsig.crs.CrsFactory;

// HSQL dependencies

import org.hsqldb.jdbc.jdbcDataSource;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 * Connection to the EPSG database in HSQL database engine format using JDBC.

 * The EPSG database can be downloaded from <A

 * HREF="http://www.epsg.org">http://www.epsg.org</A>. The SQL scripts (modified

 * for the HSQL syntax as <A HREF="doc-files/HSQL.html">explained here</A>) are

 * bundled into this plugin. The database version is given in the

 * {@linkplain org.opengis.metadata.citation.Citation#getEdition edition attribute}

 * of the

 * {@linkplain org.opengis.referencing.AuthorityFactory#getAuthority authority}.

 * The HSQL database is read only.

 * <P>

 * <H3>Implementation note</H3>

 * The SQL scripts are executed the first time a connection is required. The

 * database is then created as cached tables ({@code HSQL.properties} and

 * {@code HSQL.data} files) in a temporary directory. Future connections to the

 * EPSG database while reuse the cached tables, if available. Otherwise, the

 * scripts will be executed again in order to recreate them.

 *

 * @version $Id: HSQLDataSource.java 14624 2005-06-29 02:19:08Z desruisseaux $

 * @author Martin Desruisseaux

 * @author Didier Richard

 *

 * @since 2.2

 */

public class HSQLDataSource extends jdbcDataSource implements DataSource {

    // 20090518 cmartinez: Use a different tmp dir for each geotools instance

    private static File tmpDir = null;

    private static final Logger logger = LoggerFactory.getLogger(HSQLDataSource.class);

    /**

     * Creates a new instance of this data source

     */

    public HSQLDataSource() {

        File directory = getGtTmpDir();

        if ( directory.isDirectory() || directory.mkdir() ) {

            directory = new File(directory, "Cached databases");

            if ( directory.isDirectory() || directory.mkdir() ) {

                /*

                 * Constructs the full path to the HSQL database. Note: we do not use

                 * File.toURI() because HSQL doesn't seem to expect an encoded URL

                 * (e.g. "%20" instead of spaces).

                 */

                final StringBuffer url = new StringBuffer("jdbc:hsqldb:file:");

                final String path = directory.getAbsolutePath().replace(File.separatorChar, '/');

                if ( path.length() == 0 || path.charAt(0) != '/' ) {

                    url.append('/');

                }

                url.append(path);

                if ( url.charAt(url.length() - 1) != '/' ) {

                    url.append('/');

                }

                url.append("EPSG");

                setDatabase(url.toString());

            }

            /*

             * If the temporary directory do not exists or can't be created,

             * lets the 'database' attribute unset. If the user do not set it

             * explicitly (for example through JNDI), an exception will be thrown

             * when 'getConnection()' will be invoked.

             */

        }

        setUser("SA"); // System administrator. No password.

    }

    private File getGtTmpDir() {

        if ( tmpDir == null ) {

            tmpDir = new File(CrsFactory.getDataBaseFolder(), "temp-" + getProcessId());

            Runtime.getRuntime().addShutdownHook(new cleanOnShutdown(this));

        }

        return tmpDir;

    }

    private static String getProcessId() {

        String fallback = "time" + System.currentTimeMillis();

        // something like '<pid>@<hostname>', at least in SUN / Oracle JVMs

        final String jvmName = ManagementFactory.getRuntimeMXBean().getName();

        final int index = jvmName.indexOf('@');

        if ( index < 1 ) {

            // part before '@' empty (index = 0) / '@' not found (index = -1)

            return fallback;

        }

        try {

            return "pid" + Long.toString(Long.parseLong(jvmName.substring(0, index)));

        } catch (NumberFormatException e) {

            // ignore

        }

        return fallback;

    }

    public static class cleanOnShutdown extends Thread {

        private HSQLDataSource ds;

        public cleanOnShutdown(HSQLDataSource ds) {

            this.ds = ds;

        }

        public void run() {

            this.shutdown();

            this.delete();

        }

        private void delete() {

            File folder = HSQLDataSource.tmpDir;

            if ( folder == null ) {

                return;

            }

            try {

                logger.info("Deleting CRS temporary database folder (" + folder.getAbsolutePath() + ").");

                FileUtils.deleteDirectory(folder);

            } catch (IOException e) {

                logger.error("Can't delete CRS temporary database folder (" + folder + ".", e);

            }

        }

        private void shutdown() {

            try {

                logger.info("Shutdown the data-base.");

                Connection connection = this.ds.getConnection(false);

                final Statement statement = connection.createStatement();

                statement.execute("SHUTDOWN");

                statement.close();

                connection.close();

            } catch (Exception ex) {

                logger.error("Can't shutdown the database.", ex);

            }

        }

    }

    /**

     * Returns the priority for this data source. This priority is set to a

     * lower value than the {@linkplain AccessDataSource}'s one in order to give

     * the priority to the Access-backed database, if presents. Priorities are

     * set that way because:

     * <ul>

     * <li>The MS-Access format is the primary EPSG database format.</li>

     * <li>If a user downloads the MS-Access database himself, he probably wants

     * to use it.</li>

     * </ul>

     */

    public int getPriority() {

        return NORMAL_PRIORITY - 30;

    }

    /**

     * Returns {@code true} if the database contains data. This method returns

     * {@code false} if an empty EPSG database has been automatically created by

     * HSQL and not yet populated.

     */

    private static boolean dataExists(final Connection connection) throws SQLException {

        final ResultSet tables = connection.getMetaData().getTables(

                null, null, "EPSG_%", new String[]{"TABLE"});

        final boolean exists = tables.next();

        tables.close();

        return exists;

    }

    /**

     * Opens a connection to the database. If the cached tables are not

     * available, they will be created now from the SQL scripts bundled in this

     * plugin.

     */

    public Connection getConnection() throws SQLException {

        return getConnection(true);

    }

    public Connection getConnection(boolean initialize) throws SQLException {

        final String database = getDatabase();

        if ( database == null || database.trim().length() == 0 ) {

            /*

             * The 'database' attribute is unset if the constructor has been unable

             * to locate the temporary directory, or to create the subdirectory.

             */

            throw new SQLException("Can't write to the temporary directory.");

        }

        Connection connection = super.getConnection();

        if ( !initialize ) {

            return connection;

        }

        if ( !dataExists(connection) ) {

            /*

             * HSQL has created automatically an empty database. We need to populate it.

             * Executes the SQL scripts bundled in the JAR. In theory, each line contains

             * a full SQL statement. For this plugin however, we have compressed "INSERT

             * INTO" statements using Compactor class in this package.

             */

            logger.info("Creating temporary cached EPSG database in '"

                    + getGtTmpDir().getAbsolutePath()

                    + "' from '"

                    + CrsFactory.getEpsgDatabaseFile()

                    + "'."

            );

            final Statement statement = connection.createStatement();

            try {

                FileInputStream sqlInputStream = new FileInputStream(CrsFactory.getEpsgDatabaseFile());

                final BufferedReader in = new BufferedReader(new InputStreamReader(

                        sqlInputStream, "ISO-8859-1"));

                StringBuffer insertStatement = null;

                String line;

                while ( (line = in.readLine()) != null ) {

                    line = line.trim();

                    if( line.startsWith("-- " ) ) {

                        continue;

                    }

                    final int length = line.length();

                    if ( length != 0 ) {

                        if ( line.startsWith("INSERT INTO") ) {

                            /*

                             * We are about to insert many rows into a single table.

                             * The row values appear in next lines; the current line

                             * should stop right after the VALUES keyword.

                             */

                            insertStatement = new StringBuffer(line);

                            continue;

                        }

                        if ( insertStatement != null ) {

                            /*

                             * We are about to insert a row. Prepend the "INSERT INTO"

                             * statement and check if we will have more rows to insert

                             * after this one.

                             */

                            final int values = insertStatement.length();

                            insertStatement.append(line);

                            final boolean hasMore = (line.charAt(length - 1) == ',');

                            if ( hasMore ) {

                                insertStatement.setLength(insertStatement.length() - 1);

                            }

                            line = insertStatement.toString();

                            insertStatement.setLength(values);

                            if ( !hasMore ) {

                                insertStatement = null;

                            }

                        }

                        statement.execute(line);

                    }

                }

                in.close();

            } catch (IOException exception) {

                statement.close();

                SQLException e = new SQLException("Can't read the SQL script.");

                e.initCause(exception);

                throw e;

            }

            statement.close();

            connection.close();

            connection = super.getConnection();

            assert dataExists(connection);

        }

        return connection;

    }

    /**

     * Open a connection and creates an

     * {@linkplain FactoryUsingSQL EPSG factory} for it.

     *

     * @param factories The low-level factories to use for CRS creation.

     * @return The EPSG factory using HSQLDB SQL syntax.

     * @throws SQLException if connection to the database failed.

     */

    public AbstractAuthorityFactory createFactory(final FactoryGroup factories) throws SQLException {

        return new FactoryUsingHSQL(factories, getConnection());

    }

    public java.util.logging.Logger getParentLogger()

            throws SQLFeatureNotSupportedException {

        // TODO Auto-generated method stub

        return null;

    }

    public boolean isWrapperFor(Class<?> iface) throws SQLException {

        // TODO Auto-generated method stub

        return false;

    }

    public <T> T unwrap(Class<T> iface) throws SQLException {

        // TODO Auto-generated method stub

        return null;

    }

}

/*

 * Geotools 2 - OpenSource mapping toolkit

 * (C) 2005, Geotools Project Managment Committee (PMC)

 *

 *    This library is free software; you can redistribute it and/or

 *    modify it under the terms of the GNU Lesser General Public

 *    License as published by the Free Software Foundation; either

 *    version 2.1 of the License, or (at your option) any later version.

 *

 *    This library is distributed in the hope that it will be useful,

 *    but WITHOUT ANY WARRANTY; without even the implied warranty of

 *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

 *    Lesser General Public License for more details.

 *

 *    You should have received a copy of the GNU Lesser General Public

 *    License along with this library; if not, write to the Free Software

 *    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 */

package es.idr.teledeteccion.connection.epsg;

// J2SE dependencies

import java.sql.Connection;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.regex.Matcher;

import java.util.regex.Pattern;

import org.geotools.referencing.factory.FactoryGroup;

import org.geotools.referencing.factory.epsg.FactoryUsingAnsiSQL;

// Geotools dependencies

/**

 * Adapts SQL statements for HSQL. The HSQL database engine doesn't understand

 * the parenthesis in (INNER JOIN ... ON) statements for the "BursaWolfParameters"

 * query. Unfortunatly, those parenthesis are required by MS-Access. We need to

 * removes them programmatically here.

 *

 * @version $Id: FactoryUsingHSQL.java 14624 2005-06-29 02:19:08Z desruisseaux $

 * @author Martin Desruisseaux

 *

 * @since 2.2

 */

final class FactoryUsingHSQL extends FactoryUsingAnsiSQL {

    /**

     * The regular expression pattern for searching the "FROM (" clause.

     * This is the pattern for the opening parenthesis.

     */

    private static final Pattern OPENING_PATTERN =

            Pattern.compile("\\s+FROM\\s*\\(",

            Pattern.CASE_INSENSITIVE);

    /**

     * Constructs the factory for the given connection to the HSQL database.

     */

    public FactoryUsingHSQL(final FactoryGroup factories, final Connection connection) {

        super(factories, connection);

    }

    /**

     * If the query contains a "FROM (" expression, remove the parenthesis.

     */

    public String adaptSQL(String query) {

        query = super.adaptSQL(query);

        final Matcher matcher = OPENING_PATTERN.matcher(query);

        if (matcher.find()) {

            final int opening = matcher.end()-1;

            final int length  = query.length();

            int closing = opening;

            for (int count=0; ; closing++) {

                if (closing >= length) {

                    // Should never happen with well formed SQL statement.

                    // If it happen anyway, don't change anything and let

                    // the HSQL driver produces a "syntax error" message.

                    return query;

                }

                switch (query.charAt(closing)) {

                    case '(': count++; break;

                    case ')': count--; break;

                    default : continue;

                }

                if (count == 0) {

                    break;

                }

            }

            query = query.substring(0,         opening) +

                    query.substring(opening+1, closing) +

                    query.substring(closing+1);

        }

        return query;

    }

    /**

     * Shutdown the HSQL database engine.

     */

    void shutdown(final boolean active) throws SQLException {

        if (active) {

            final Statement statement = connection.createStatement();

            statement.execute("SHUTDOWN");

            statement.close();

        }

//        super.shutdown(active); // FIXME: no tiene este metodo. 

    }

}

/*

 *    GeoTools - OpenSource mapping toolkit

 *    http://geotools.org

 *    (C) 2005-2006, GeoTools Project Managment Committee (PMC)

 * 

 *    This library is free software; you can redistribute it and/or

 *    modify it under the terms of the GNU Lesser General Public

 *    License as published by the Free Software Foundation;

 *    version 2.1 of the License.

 *

 *    This library is distributed in the hope that it will be useful,

 *    but WITHOUT ANY WARRANTY; without even the implied warranty of

 *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

 *    Lesser General Public License for more details.

 */

package es.idr.teledeteccion.connection.iau2000;

// J2SE dependencies

import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.text.ParseException;

import java.util.Hashtable;

import java.util.Set;

import org.geotools.metadata.iso.citation.CitationImpl;

import org.geotools.referencing.CRS;

import org.geotools.referencing.wkt.Parser;

import org.gvsig.crs.CrsFactory;

import org.hsqldb.jdbc.jdbcDataSource;

import org.opengis.metadata.citation.Citation;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.IdentifiedObject;

import org.opengis.referencing.crs.CRSAuthorityFactory;

import org.opengis.referencing.crs.CRSFactory;

import org.opengis.referencing.crs.CompoundCRS;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

import org.opengis.referencing.crs.DerivedCRS;

import org.opengis.referencing.crs.EngineeringCRS;

import org.opengis.referencing.crs.GeocentricCRS;

import org.opengis.referencing.crs.GeographicCRS;

import org.opengis.referencing.crs.ImageCRS;

import org.opengis.referencing.crs.ProjectedCRS;

import org.opengis.referencing.crs.TemporalCRS;

import org.opengis.referencing.crs.VerticalCRS;

import org.opengis.util.InternationalString;

public class FactoryUsingHSQL extends jdbcDataSource implements CRSAuthorityFactory {

    /**

     * The connection to the EPSG database.

     */

    protected Connection connection;

    //  object factory

    protected CRSFactory crsFactory;

    /** Cache of parsed CoordinateReferenceSystem WKT by IAU2000_NUMBER */

    private Hashtable cache = new Hashtable();

    /**

     * The database name.

     *

     * @since 2.3

     */

    public static final String DATABASE_NAME = "IAU2000";

    public FactoryUsingHSQL() {

    	 try {

             loadDefault();

         }

         catch( IOException oops ){

             System.err.println("Could not load "+ oops );

         }

    	//this(FactoryFinder.getCRSFactory(null));

    }   

	protected FactoryUsingHSQL(CRSFactory factory) {

		this.crsFactory = factory;

        try {

            loadDefault();

        }

        catch( IOException oops ){

            System.err.println("Could not load "+ oops );

        }

	}

	protected void loadDefault() throws IOException {

		String db = "jdbc:hsqldb:file:" + CrsFactory.getDataBaseFolder().getAbsolutePath() + "/iau2000";

		setDatabase(db);

		setUser("sa");

		try {

			connection = super.getConnection();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

    }

	public CoordinateReferenceSystem createCoordinateReferenceSystem(String code) throws FactoryException {

		// TODO Auto-generated method stub

		CoordinateReferenceSystem returnValue = null;

		String wkt = null;

		String IAU2000_NUMBER = code.substring(code.indexOf(":")+1, code.length());

		int cod = Integer.parseInt(IAU2000_NUMBER);

		if( cache.contains( IAU2000_NUMBER ) ){

            Object value = cache.get( IAU2000_NUMBER );

            if( value instanceof Throwable ){

                throw new FactoryException( "WKT for "+code+" could not be parsed", (Throwable) value );

            }

            if( value instanceof CoordinateReferenceSystem){

                return (CoordinateReferenceSystem) value;

            }            

        }

		try {        	

        	final PreparedStatement stmt;

            /*stmt = connection.prepareStatement("SELECT IAU_WKT"

                                          + " FROM IAU2000"

                                          + " WHERE IAU_CODE = " + code.substring(code.indexOf(":")+1, code.length()));

            ResultSet result = stmt.executeQuery();

            */

            String sentence = "SELECT IAU_WKT"

            + " FROM IAU2000"

            + " WHERE IAU_CODE = " + code.substring(code.indexOf(":")+1, code.length());

        	Statement st = null;

    		ResultSet result = null;

        	st = connection.createStatement();

			result = st.executeQuery(sentence);

			st.close();        	

        	while (result.next()) {

                wkt    = result.getString("iau_wkt"); 	

            }

            result.close();

            if( wkt.indexOf( cod ) == -1){

            	wkt = wkt.trim();

            	wkt = wkt.substring(0, wkt.length()-1 );

            	wkt += ",AUTHORITY[\"IAU2000\",\""+cod+"\"]]";

            }

        } catch (SQLException exception) {

            System.out.println(exception);

        }

        Parser parser = new Parser();

		try {

			returnValue = parser.parseCoordinateReferenceSystem(wkt);

		} catch (ParseException e) {

			// TODO Auto-generated catch block

			System.out.println("Cadena WKT no ha podido ser parseada");

			e.printStackTrace();

		}

        return returnValue;		

	}

	public CompoundCRS createCompoundCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public DerivedCRS createDerivedCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public EngineeringCRS createEngineeringCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public GeographicCRS createGeographicCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public GeocentricCRS createGeocentricCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public ImageCRS createImageCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public ProjectedCRS createProjectedCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public TemporalCRS createTemporalCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public VerticalCRS createVerticalCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public Citation getAuthority() {		

		Citation citation = CitationImpl.createCitation("IAU2000");

		citation.getIdentifiers().add("IAU2000");

		return citation;

	}

	public Set getAuthorityCodes(Class arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public InternationalString getDescriptionText(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public IdentifiedObject createObject(String code) throws FactoryException {

		return createCoordinateReferenceSystem(code);

	}

	public Citation getVendor() {

		return CitationImpl.createCitation("IAU2000");

	}

}

/*

 *    GeoTools - OpenSource mapping toolkit

 *    http://geotools.org

 *    (C) 2005-2006, GeoTools Project Managment Committee (PMC)

 * 

 *    This library is free software; you can redistribute it and/or

 *    modify it under the terms of the GNU Lesser General Public

 *    License as published by the Free Software Foundation;

 *    version 2.1 of the License.

 *

 *    This library is distributed in the hope that it will be useful,

 *    but WITHOUT ANY WARRANTY; without even the implied warranty of

 *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

 *    Lesser General Public License for more details.

 */

package es.idr.teledeteccion.connection.esri;

// J2SE dependencies

import java.io.IOException;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.text.ParseException;

import java.util.Hashtable;

import java.util.Set;

import org.geotools.metadata.iso.citation.CitationImpl;

import org.geotools.referencing.CRS;

import org.geotools.referencing.wkt.Parser;

import org.gvsig.crs.CrsFactory;

import org.hsqldb.jdbc.jdbcDataSource;

import org.opengis.metadata.citation.Citation;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.IdentifiedObject;

import org.opengis.referencing.crs.CRSAuthorityFactory;

import org.opengis.referencing.crs.CRSFactory;

import org.opengis.referencing.crs.CompoundCRS;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

import org.opengis.referencing.crs.DerivedCRS;

import org.opengis.referencing.crs.EngineeringCRS;

import org.opengis.referencing.crs.GeocentricCRS;

import org.opengis.referencing.crs.GeographicCRS;

import org.opengis.referencing.crs.ImageCRS;

import org.opengis.referencing.crs.ProjectedCRS;

import org.opengis.referencing.crs.TemporalCRS;

import org.opengis.referencing.crs.VerticalCRS;

import org.opengis.util.InternationalString;

public class FactoryUsingHSQL extends jdbcDataSource implements CRSAuthorityFactory {

    /**

     * The connection to the EPSG database.

     */

    protected Connection connection;

    //  object factory

    protected CRSFactory crsFactory;

    /** Cache of parsed CoordinateReferenceSystem WKT by ESRI_NUMBER */

    private Hashtable cache = new Hashtable();

    /**

     * The database name.

     *

     * @since 2.3

     */

    public static final String DATABASE_NAME = "ESRI";

    public FactoryUsingHSQL() {

    	 try {

             loadDefault();

         }

         catch( IOException oops ){

             System.err.println("Could not load "+ oops );

         }

    	//this(FactoryFinder.getCRSFactory(null));

    }   

	protected FactoryUsingHSQL(CRSFactory factory) {

		this.crsFactory = factory;

        try {

            loadDefault();

        }

        catch( IOException oops ){

            System.err.println("Could not load "+ oops );

        }

	}

	protected void loadDefault() throws IOException {

		String db = "jdbc:hsqldb:file:" + CrsFactory.getDataBaseFolder().getAbsolutePath() + "/esri";

		setDatabase(db);

		setUser("sa");

		try {

			connection = super.getConnection();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

    }

	public CoordinateReferenceSystem createCoordinateReferenceSystem(String code) throws FactoryException {

		CoordinateReferenceSystem returnValue = null;

		String wkt = null;

		String ESRI_NUMBER = code.substring(code.indexOf(":")+1, code.length());

		int cod = Integer.parseInt(ESRI_NUMBER);

		if( cache.contains( ESRI_NUMBER ) ){

            Object value = cache.get( ESRI_NUMBER );

            if( value instanceof Throwable ){

                throw new FactoryException( "WKT for "+code+" could not be parsed", (Throwable) value );

            }

            if( value instanceof CoordinateReferenceSystem){

                return (CoordinateReferenceSystem) value;

            }

        }

		try {

            String sentence = "SELECT ESRI_WKT"

            + " FROM ESRI"

            + " WHERE ESRI_CODE = " + code.substring(code.indexOf(":")+1, code.length());

        	Statement st = null;

    		ResultSet result = null;

        	st = connection.createStatement();

			result = st.executeQuery(sentence);

			st.close();

        	while (result.next()) {

                wkt    = result.getString("esri_wkt"); 	

            }

            result.close();

            if( wkt.indexOf( cod ) == -1){

            	wkt = wkt.trim();

            	wkt = wkt.substring(0, wkt.length()-1 );

            	wkt += ",AUTHORITY[\"ESRI\",\""+cod+"\"]]";

            }

        } catch (SQLException exception) {

            System.out.println(exception);

        }

        Parser parser = new Parser();

		try {

			returnValue = parser.parseCoordinateReferenceSystem(wkt);

		} catch (ParseException e) {

			// TODO Auto-generated catch block

			System.out.println("Cadena WKT no ha podido ser parseada");

			e.printStackTrace();

		}

        return returnValue;			

	}

	public CompoundCRS createCompoundCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public DerivedCRS createDerivedCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public EngineeringCRS createEngineeringCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public GeographicCRS createGeographicCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public GeocentricCRS createGeocentricCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public ImageCRS createImageCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public ProjectedCRS createProjectedCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public TemporalCRS createTemporalCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public VerticalCRS createVerticalCRS(String arg0) throws FactoryException {

		// TODO Auto-generated method stub

		return null;

	}

	public Citation getAuthority() {