Application: gvSIG desktop

bin

#Tue Jul 25 14:11:17 CEST 2006

eclipse.preferences.version=1

encoding/<project>=ISO-8859-1

<?xml version="1.0" encoding="UTF-8"?>

<?eclipse-cdt version="2.0"?>

<cdtproject/>

<?xml version="1.0" encoding="UTF-8"?>

<projectDescription>

	<name>libJCRS</name>

	<comment></comment>

	<projects>

	</projects>

	<buildSpec>

		<buildCommand>

			<name>org.eclipse.jdt.core.javabuilder</name>

			<arguments>

			</arguments>

		</buildCommand>

		<buildCommand>

			<name>org.eclipse.ui.externaltools.ExternalToolBuilder</name>

			<triggers>full,incremental,</triggers>

			<arguments>

				<dictionary>

					<key>LaunchConfigHandle</key>

					<value>&lt;project&gt;/.externalToolBuilders/crsgdal build.xml [Builder].launch</value>

				</dictionary>

			</arguments>

		</buildCommand>

	</buildSpec>

	<natures>

		<nature>org.eclipse.jdt.core.javanature</nature>

	</natures>

</projectDescription>

/* 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.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   Instituto de Desarrollo Regional (Universidad de Castilla La-Mancha)

 *   Campus Universitario s/n

 *   02071 Alabacete

 *   Spain

 *

 *   +34 967 599 200

 */

package es.idr.teledeteccion.connection;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

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

import org.hsqldb.jdbc.jdbcDataSource;

/**

 * 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 {

	Connection connect;

	private static String usrConnectionStr = "jdbc:hsqldb:file:gvSIG/extensiones/org.gvsig.crs/usr";

	public EpsgConnection() {	

	/*	try {

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

		} catch (ClassNotFoundException e) {

			e.printStackTrace();

		}*/

	}

	public void setConnectionEPSG() {

		HSQLDataSource ds = new HSQLDataSource();

		try {

			connect = ds.getConnection();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

	/**

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

	 *

	 */

	public void setConnectionIAU2000() {

		setDatabase("jdbc:hsqldb:file:gvSIG/extensiones/org.gvsig.crs/iau2000");

		setUser("sa");

		try {

			connect = super.getConnection();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

	/**

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

	 *

	 */

	public void setConnectionEsri() {

		setDatabase("jdbc:hsqldb:file:gvSIG/extensiones/org.gvsig.crs/esri");

		setUser("sa");

		try {

			connect = super.getConnection();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

	/**

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

	 *

	 */

	public void setConnectionUsr() {

		setDatabase(usrConnectionStr);

		setUser("sa");

		try {

			connect = super.getConnection();

		} catch (SQLException e) {

			e.printStackTrace();

			if (!usrConnectionStr.endsWith("-ro")) {

				// if the DB is already open, use a ro copy of it

				usrConnectionStr = usrConnectionStr+"-ro";

				setConnectionUsr();

			}

		}

	}

	public Connection getConnection(){

		return connect;

	}

	public void shutdown() throws SQLException {

        Statement st = connect.createStatement();

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

        // otherwise there will be an unclean shutdown

        // when program ends

        st.execute("SHUTDOWN");

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

    }

	public synchronized void update(String expression) throws SQLException {

        Statement st = null;

        st = connect.createStatement();    // statements

        int i = st.executeUpdate(expression);    // run the query

        if (i == -1) {

            System.out.println("db error : " + expression);

        }

        st.close();

    }

	/*

	*//**

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

	 *

	 *//*

	public void setConnectionEPSG() {

		try {			

			connect =  DriverManager.getConnection("jdbc:hsqldb:file:gvSIG/extensiones/org.gvsig.crs/db_epsg", "sa", "");

		} catch (SQLException e1) {

			e1.printStackTrace();

		}

	}

	*//**

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

	 *

	 *//*

	public void setConnectionIAU2000() {

		try {			

			connect =  DriverManager.getConnection("jdbc:hsqldb:file:gvSIG/extensiones/org.gvsig.crs/db_iau2000", "sa", "");			

		} catch (SQLException e1) {

			e1.printStackTrace();

		}

	}

	*//**

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

	 *

	 *//*

	public void setConnectionEsri() {

		try {			

			connect =  DriverManager.getConnection("jdbc:hsqldb:file:/home/jlgomez/gvSIGF2/_fwAndami/gvSIG/extensiones/org.gvsig.crs/db_esri", "sa", "");			

		} catch (SQLException e1) {

			e1.printStackTrace();

		}

	}

	*//**

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

	 *

	 *//*

	public void setConnectionUsr() {

		try {			

			connect =  DriverManager.getConnection("jdbc:hsqldb:file:gvSIG/extensiones/org.gvsig.crs/db_usr", "sa", "");			

		} catch (SQLException e1) {

			e1.printStackTrace();

		}

	}

	public Connection getConnection(){

		return connect;

	}

	public void shutdown() throws SQLException {

        Statement st = connect.createStatement();

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

        // otherwise there will be an unclean shutdown

        // when program ends

        st.execute("SHUTDOWN");

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

    }*/

	 /**

     * 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, "IAU2000_%", new String[] {"TABLE"});

        final boolean exists = tables.next();

        tables.close();

        return exists;

    }

}

/* 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.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   Instituto de Desarrollo Regional (Universidad de Castilla La-Mancha)

 *   Campus Universitario s/n

 *   02071 Alabacete

 *   Spain

 *

 *   +34 967 599 200

 */

package es.idr.teledeteccion.connection;

import java.io.Serializable;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

/**

 * Clase para realizar las consultas a las bases de datos utilizadas

 * 

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

 *

 */

public class Query implements Serializable{

	/**

	 * 

	 */

	private static final long serialVersionUID = 1L;

	/**

	 * Acepta la sentencia y la conexi?n a la base de datos actual,

	 * realiza una selecci?n y devuelve los datos en un ResultSet

	 * @param sentence

	 * @param conn

	 * @return

	 */

	public static synchronized ResultSet select(String sentence, Connection conn){

		Statement st = null;

		ResultSet rs = null;

		try {

			st = conn.createStatement();

			rs = st.executeQuery(sentence);

			st.close();

		} catch (SQLException e) {

			e.printStackTrace();

		}		

		return rs;

	}	

}

/* 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.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   Instituto de Desarrollo Regional (Universidad de Castilla La-Mancha)

 *   Campus Universitario s/n

 *   02071 Alabacete

 *   Spain

 *

 *   +34 967 599 200

 */

package org.gvsig.crs;

import java.util.TreeMap;

import org.cresques.cts.ICRSFactory;

import org.cresques.cts.IProjection;

import org.gvsig.crs.repository.EpsgRepository;

import org.gvsig.crs.repository.EpsgRepositoryGT;

import org.gvsig.crs.repository.EsriRepository;

import org.gvsig.crs.repository.EsriRepositoryGT;

import org.gvsig.crs.repository.ICrsRepository;

import org.gvsig.crs.repository.Iau2000Repository;

import org.gvsig.crs.repository.Iau2000RepositoryGT;

import org.gvsig.crs.repository.UsrRepository;

import org.gvsig.crs.repository.UsrRepositoryGT;

/**

 * Clase que consigue el CRS a trav?s del c?digo de la EPSG o de

 * la cadena WKT

 *

 * @author Diego Guerrero Sevilla (diego.guerrero@uclm.es)

 *

 */

public class CrsFactory implements ICRSFactory {

	static TreeMap data = new TreeMap();

	public CrsFactory() {

	}

	/**

	 * Obtiene un CRS a partir de su c?digo (p.e. EPSG:23030).

	 * @param code

	 * @return

	 * @throws CrsException

	 */

	public ICrs getCRS(String code) throws CrsException {

		/*if (data.containsKey(code))

			return (ICrs) data.get(code);*/

		String repoId = "";

		String crsCode = "";

		ICrs crs = null;

		if(code.indexOf(":", code.indexOf(":")+1)<0){

			repoId = code.substring(0, code.indexOf(":"));

			crsCode = code.substring(code.indexOf(":")+1);

			ICrsRepository repo = null;

			if(repoId.equals("EPSG")){

				repo = new EpsgRepositoryGT();

				crs = repo.getCrs(crsCode);

				if (crs==null) {

					repo = new EpsgRepository();

					crs = repo.getCrs(crsCode);

				}

			}else if (repoId.equals("IAU2000")){

				repo = new Iau2000RepositoryGT();

				crs = repo.getCrs(crsCode);

				if (crs==null) {

					repo = new Iau2000Repository();

					crs = repo.getCrs(crsCode);

				}

			}else if (repoId.equals("ESRI")){

				repo = new EsriRepositoryGT();

				crs = repo.getCrs(crsCode);

				if (crs==null) {

					repo = new EsriRepository();

					crs = repo.getCrs(crsCode);

				}

			}else if (repoId.equals("USR")){

				repo = new UsrRepositoryGT();

				crs = repo.getCrs(crsCode);

				if (crs==null) {

					repo = new UsrRepository();

					crs = repo.getCrs(crsCode);

				}

			}

		}

		else{

			String sourceParams = null;

			String targetParams = null;

			crsCode = code.substring(0,code.indexOf(":",code.indexOf(":")+1));

			if (code.indexOf("@")==-1){

				crsCode=crsCode.substring(0, crsCode.indexOf(","));

			}else{

				sourceParams = code.substring(code.indexOf("@")+1,code.lastIndexOf("@"));

				targetParams = code.substring(code.lastIndexOf("@")+1);

				if (sourceParams.equals(""))

					sourceParams = null;

				else if (targetParams.equals("1")){ // Compativilidad con versiones de libJCrs sin soporte para transf. compuestas.

					targetParams = sourceParams;

					sourceParams = "";

				}

				if (targetParams.equals("")||targetParams.equals("0")) // Compativilidad con versiones de libJCrs sin soporte para transf. compuestas.

					targetParams = null;

			}

			crs = getCRS(crsCode);

			crs.setTransformationParams(sourceParams,targetParams);

		}

		/*code = crs.getAbrev();

		data.put(code, crs);*/

		return crs;

		/*if (data.containsKey(code))

			return (Crs) data.get(code);

		Crs crs = new Crs(code);

		// LWS Esta l?nea sobra, cuando el cuadro de di?logo est?

		// mejor hecho.

		code = crs.getAbrev();

		data.put(code, crs);

		return crs;*/

	}

	/**

	 *

	 * @param epsg_code

	 * @param code

	 * @return

	 * @throws CrsException

	 */

	public ICrs getCRS(int epsg_code, String code) throws CrsException {

		/*if (data.containsKey(code))

			return (Crs) data.get(code);*/

		Crs crs = new Crs(epsg_code, code);

		// LWS Esta l?nea sobra, cuando el cuadro de di?logo est?

		// mejor hecho.

		/*code = crs.getAbrev();

		data.put(code, crs);*/

		return crs;

	}

	/**

	 *

	 * @param epsg_code

	 * @param code

	 * @param params

	 * @return

	 * @throws CrsException

	 */

	public ICrs getCRS(int epsg_code, String code, String params) throws CrsException {

		/*if (data.containsKey(code))

			return (Crs) data.get(code);*/

		Crs crs = new Crs(epsg_code, code,params);

		// LWS Esta l?nea sobra, cuando el cuadro de di?logo est?

		// mejor hecho.

		/*code = crs.getAbrev();

		data.put(code, crs);*/

		return crs;

	}

	/**

	 *

	 */

	public IProjection get(String name) {

		// TODO Auto-generated method stub

		try {

			return getCRS(name);

		} catch (CrsException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		return null;

	}

	/**

	 *

	 */

	public boolean doesRigurousTransformations() {

		return true;

	}

}

/* 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.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   Instituto de Desarrollo Regional (Universidad de Castilla La-Mancha

 *   Campus Universitario s/n

 *   02071 Alabacete

 *   Spain

 *

 *   +34 967 599 200

 */

package org.gvsig.crs.repository;

import org.geotools.referencing.CRS;

import org.gvsig.crs.CrsGT;

import org.gvsig.crs.ICrs;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

/**

 * Repositorio de CRSs de EPSG basado en Geotools.

 * 

 * @author Diego Guerrero Sevilla (diego.guerrero@uclm.es)

 *

 */

public class EpsgRepositoryGT implements ICrsRepository {

	public ICrs getCrs(String code) {

		CrsGT crsGT = null;

		try {

			CoordinateReferenceSystem crs = CRS.decode("EPSG:"+code);

			crsGT = new CrsGT(crs);

		} catch (NoSuchAuthorityCodeException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

			return null;			

		} catch (FactoryException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

			return null;

		}

		return crsGT;

	}

}

package org.gvsig.crs.repository;

import java.sql.ResultSet;

import java.sql.SQLException;

import org.gvsig.crs.Crs;

import org.gvsig.crs.CrsException;

import org.gvsig.crs.ICrs;

import es.idr.teledeteccion.connection.EpsgConnection;

import es.idr.teledeteccion.connection.Query;

public class UsrRepository implements ICrsRepository {

	EpsgConnection connection;

	public UsrRepository() {

		super();

		connection = new EpsgConnection();		

	}

	public ICrs getCrs(String code) {

		// TODO Auto-generated method stub

		String cadWKT = "";

		Crs crs = null;

		String sentence = "SELECT usr_code, usr_wkt, usr_proj, usr_geog, usr_datum " +							 

						  "FROM USR " +	                              

                          "WHERE usr_code = " + code;

		connection.setConnectionUsr();

		ResultSet result = Query.select(sentence,connection.getConnection());	

		try {

			connection.shutdown();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		try {

			if (!result.next())

				return null;		

			cadWKT = result.getString("usr_wkt");			

		} catch (SQLException e1) {

			e1.printStackTrace();

		}		

		cadWKT = cadWKT.substring(0, cadWKT.length()-1) + ", AUTHORITY[\"USR\","+ Integer.parseInt(code)+"]]";

		try {

			crs = new Crs(Integer.parseInt(code),cadWKT);

		} catch (CrsException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		return crs;		

	}

}

package org.gvsig.crs.repository;

import org.geotools.referencing.CRS;

import org.gvsig.crs.CrsGT;

import org.gvsig.crs.ICrs;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

public class Iau2000RepositoryGT implements ICrsRepository {

	public ICrs getCrs(String code) {

		CrsGT crsGT = null;

		try {

			CoordinateReferenceSystem crs = CRS.decode("IAU2000:"+code);

			crsGT = new CrsGT(crs);

		} catch (NoSuchAuthorityCodeException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

			return null;			

		} catch (FactoryException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

			return null;

		}

		return crsGT;

	}

}

package org.gvsig.crs.repository;

import org.geotools.referencing.CRS;

import org.gvsig.crs.CrsGT;

import org.gvsig.crs.ICrs;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

public class EsriRepositoryGT implements ICrsRepository {

	public ICrs getCrs(String code) {

		CrsGT crsGT = null;

		try {

			CoordinateReferenceSystem crs = CRS.decode("ESRI:"+code);

			crsGT = new CrsGT(crs);

		} catch (NoSuchAuthorityCodeException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

			return null;			

		} catch (FactoryException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

			return null;

		}

		return crsGT;

	}

}

/* 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.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   Instituto de Desarrollo Regional (Universidad de Castilla La-Mancha

 *   Campus Universitario s/n

 *   02071 Alabacete

 *   Spain

 *

 *   +34 967 599 200

 */

package org.gvsig.crs.repository;

import java.sql.ResultSet;

import java.sql.SQLException;

import org.gvsig.crs.Crs;

import org.gvsig.crs.CrsException;

import org.gvsig.crs.ICrs;

import org.gvsig.crs.ogr.Epsg2wkt;

import org.gvsig.crs.ogr.CrsEPSG;

import es.idr.teledeteccion.connection.EpsgConnection;

import es.idr.teledeteccion.connection.Query;

/**

 * Repositorio de CRSs de EPSG

 * 

 * @author Diego Guerrero Sevilla (diego.guerrero@uclm.es)

 *

 */

public class EpsgRepository implements ICrsRepository {

	public EpsgConnection connection = null;

	public EpsgRepository() {

		connection = new EpsgConnection();

	}

	/**

	 * Obtiene un CRS a partir de su c?digo EPSG.

	 * 

	 * @param code Codigo EPSG del CRS. 

	 * @return ICrs 

	 */

	public ICrs getCrs(String code) {

		int epsg_code  = Integer.parseInt(code);

		boolean source_yn = false;

		int source_cod = 0;

		int datum_code = 0;

		int projection_conv_code = 0;

		String crs_kind = null;

		Epsg2wkt wkt = null;

		Crs crs = null;

		ResultSet result = null;

		String sentence = "SELECT source_geogcrs_code, projection_conv_code, "

			+ "coord_ref_sys_kind, datum_code "

			+ "FROM epsg_coordinatereferencesystem "

			+ "WHERE coord_ref_sys_code = " + code;

		connection.setConnectionEPSG();

		result = Query.select(sentence,connection.getConnection());	

		/*try {

			connection.shutdown();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}*/

		try {

			if (!result.next())

				return null;

			source_cod = result.getInt("source_geogcrs_code");

			projection_conv_code = result.getInt("projection_conv_code");

			crs_kind = result.getString("coord_ref_sys_kind");

			datum_code = result.getInt("datum_code");

		} catch (SQLException e1) {

			e1.printStackTrace();

		}

		if (datum_code != 0){

			source_yn = true;

		}

		else if (source_cod != 0){

			source_yn = false;

		}

		else source_yn = true;

		CrsEPSG ep = new CrsEPSG(epsg_code, source_yn, source_cod, projection_conv_code, connection);

		if (crs_kind.equals("geographic 2D") || crs_kind.equals("geographic 3D")){

			wkt = new Epsg2wkt(ep , "geog");			

		}

		else if (crs_kind.equals("projected")){

			wkt = new Epsg2wkt(ep, "proj");

		}

		else if (crs_kind.equals("compound")){

			wkt = new Epsg2wkt(ep,"comp");

		}

		else if (crs_kind.equals("geocentric")){

			wkt = new Epsg2wkt(ep,"geoc");

		}

		try {

			crs = new Crs(Integer.parseInt(code),wkt.getWKT());

		} catch (CrsException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		return crs;

	}

}

<html>

	<body>Clases relacionadas con los repositorios de la extensi?n CRS.

</body>

</html>

/* 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.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   Instituto de Desarrollo Regional (Universidad de Castilla La-Mancha

 *   Campus Universitario s/n

 *   02071 Alabacete

 *   Spain

 *

 *   +34 967 599 200

 */

package org.gvsig.crs.repository;

import org.gvsig.crs.ICrs;

/**

 * Interfaz para un repositorio de Sistemas de Referencia Coordenados (CRS)

 * 

 * @author Diego Guerrero Sevilla (diego.guerrero@uclm.es)

 *

 */

public interface ICrsRepository {

	/**

	 * Obtiene un CRS a partir del c?digo que lo identifica en el repositorio.

	 * 

	 * @param code Codigo de CRS en el repositorio. 

	 * @return ICrs 

	 */

	public ICrs getCrs(String code);

}

/* 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.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   Instituto de Desarrollo Regional (Universidad de Castilla La-Mancha

 *   Campus Universitario s/n

 *   02071 Alabacete

 *   Spain

 *

 *   +34 967 599 200

 */

package org.gvsig.crs.repository;

import java.sql.ResultSet;

import java.sql.SQLException;

import org.gvsig.crs.Crs;

import org.gvsig.crs.CrsException;

import org.gvsig.crs.ICrs;

import org.gvsig.crs.ogr.Iau2wkt;

import es.idr.teledeteccion.connection.EpsgConnection;

import es.idr.teledeteccion.connection.Query;

/**

 * Repositorio de CRSs de IAU2000

 * 

 * @author Diego Guerrero Sevilla (diego.guerrero@uclm.es)

 *

 */

public class Iau2000Repository implements ICrsRepository {

	EpsgConnection connection = null;

	public Iau2000Repository() {

		connection = new EpsgConnection();	

	}

	/**

	 * Obtiene un CRS a partir de su c?digo IAU2000.

	 * 

	 * @param code Codigo IAU2000 del CRS. 

	 * @return ICrs 

	 */

	public ICrs getCrs(String code) {

		String cadWKT = "";

		Crs crs = null;

		String sentence = "SELECT iau_code, iau_wkt, iau_proj, iau_geog, iau_datum " +							 

						  "FROM IAU2000 " +	                              

                          "WHERE iau_code = " + code;

		connection.setConnectionIAU2000();

		ResultSet result = Query.select(sentence,connection.getConnection());	

		try {

			connection.shutdown();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		try {

			if (!result.next())

				return null;			

			cadWKT = result.getString("iau_wkt");			

		} catch (SQLException e1) {

			e1.printStackTrace();

		}		

		cadWKT = cadWKT.substring(0, cadWKT.length()-1) + ", AUTHORITY[\"IAU2000\","+ Integer.parseInt(code)+"]]";

		if (cadWKT.charAt(0) == 'P'){

			Iau2wkt wk = new Iau2wkt(cadWKT);

			cadWKT = wk.getWkt();

		}

		try {

			crs = new Crs(Integer.parseInt(code),cadWKT);

		} catch (CrsException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		return crs;

	}

}

/* 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.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   Instituto de Desarrollo Regional (Universidad de Castilla La-Mancha

 *   Campus Universitario s/n

 *   02071 Alabacete

 *   Spain

 *

 *   +34 967 599 200

 */

package org.gvsig.crs.repository;

import java.sql.ResultSet;

import java.sql.SQLException;

import org.gvsig.crs.Crs;

import org.gvsig.crs.CrsException;

import org.gvsig.crs.ICrs;

import org.gvsig.crs.ogr.Esri2wkt;

import es.idr.teledeteccion.connection.EpsgConnection;

import es.idr.teledeteccion.connection.Query;

/**

 * Repositorio de CRSs de EPSG

 * 

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

 *

 */

public class EsriRepository implements ICrsRepository {

	EpsgConnection connection = null;

	public EsriRepository() {

		connection = new EpsgConnection();

		connection.setConnectionEsri();		

	}

	public ICrs getCrs(String code) {

		String cadWKT = "";

		Crs crs = null;

		String sentence = "SELECT esri_code, esri_wkt, esri_proj, esri_geog, esri_datum " +							 

						  "FROM ESRI " +	                              

                          "WHERE esri_code = " + code;

		ResultSet result = Query.select(sentence,connection.getConnection());	

		/*try {

			connection.shutdown();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}*/

		try {

			if (!result.next())

				return null;	

			cadWKT = result.getString("esri_wkt");			

		} catch (SQLException e1) {

			e1.printStackTrace();

		}		

		cadWKT = cadWKT.substring(0, cadWKT.length()-1) + ", AUTHORITY[\"ESRI\","+ Integer.parseInt(code)+"]]";

		if (cadWKT.charAt(0) == 'P'){

			Esri2wkt wk = new Esri2wkt(cadWKT);

			cadWKT = wk.getWkt();

		}

		try {

			crs = new Crs(Integer.parseInt(code),cadWKT);

		} catch (CrsException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		return crs;

	}

}

package org.gvsig.crs.repository;

import org.geotools.referencing.CRS;

import org.gvsig.crs.CrsGT;

import org.gvsig.crs.ICrs;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

public class UsrRepositoryGT implements ICrsRepository {

	public ICrs getCrs(String code) {

		CrsGT crsGT = null;

		try {

			CoordinateReferenceSystem crs = CRS.decode("USR:"+code);

			crsGT = new CrsGT(crs);

		} catch (NoSuchAuthorityCodeException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

			return null;			

		} catch (FactoryException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

			return null;

		}

		return crsGT;

	}

}

/* 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