Application: gvSIG desktop

package es.idr.projection.test;

import org.gvsig.crs.CrsException;

import org.gvsig.crs.CrsFactory;

import org.gvsig.crs.ICrs;

import org.gvsig.crs.Proj4;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

public class TestGeotools21 {

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		try {	        	

    		String strEpsgCode;

			// Notas:

			// - transverse mercator south orientated no esta soportada por Proj4

    		// - Buscar ejemplo de la CylindricalEqualArea

    		// - Buscar ejemplo de la AzimuthalEquidistant

    		// - Buscar ejemplo de la Gnomonic

    		// - Buscar ejemplo de la Bonne

    		// - Buscar ejemplo de la Equirectangular

    		// - Buscar ejemplo de la EquidistantConic

    		// - Buscar ejemplo de la MillerCylindrical

    		// - Buscar ejemplo de la Mollweide

    		// - Buscar ejemplo de la EckertIV

    		// - Buscar ejemplo de la EckertVI

    		// - Buscar ejemplo de la Robinson

    		// - Buscar ejemplo de la VanDerGrinten

    		// - Buscar ejemplo de la Sinusoidal

    		// - Buscar ejemplo de la GallStereographic

    		// - Buscar ejemplo de la Goode

			//strEpsgCode="EPSG:2065"; // Krovak

    		//strEpsgCode="EPSG:2052";  // tm south orientated No en mi Proj4

    		//strEpsgCode="EPSG:2084";  // tm south orientated

    		//strEpsgCode="EPSG:32662";  // Plate Carree  -> Funciona, problema elipsoide

    											// Tomara como radio el semieje mayor del elipsoide

    		//strEpsgCode="EPSG:27200";  // NewZealandMapGrid -> Mirar lo de +datum

    		// He tenido que incluir un mecanismo para valores concretos de parametros

    		strEpsgCode="EPSG:32761";  // CassiniSoldner -> Falla +to_meter=..

    		//strEpsgCode="EPSG:2099";

    		//strEpsgCode="EPSG:2200";  // en lugar de stere pone sterea,igual 2171

    									// 2036 - falla, 32661

    		//strEpsgCode="EPSG:2163";    // Laea esferica, funciona

    		//strEpsgCode="EPSG:3035";    // ETRS-LAEA, funciona

    		//strEpsgCode="EPSG:29100";	// Polyconic, falla en geotools

    		//strEpsgCode="EPSG:2964";	// Albers-conic-equal-area

    		                            // debería fallar por cambio de unidad

    		//strEpsgCode="EPSG:24571";    // Oblicua de mercator, rf mas decimales

    		                               // quitar segundo alpha

    		//strEpsgCode="EPSG:29700";    // Oblicua de mercator, rf mas decimales

    		//strEpsgCode="EPSG:21780";		//somer, sin alpha

    		ICrs crs=null;

    		//CoordinateReferenceSystem source;

    		//source = CRS.decode(strEpsgCode);

        	crs = new CrsFactory().getCRS(strEpsgCode); 

        	System.out.println(crs.getWKT());        	

			System.out.println(crs.getProj4String()); //proj4.exportToProj4(crs));

		} catch (CrsException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

}

package es.idr.test;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import javax.units.Unit;

import org.geotools.referencing.CRS;

import org.geotools.referencing.crs.DefaultGeographicCRS;

import org.geotools.referencing.crs.DefaultProjectedCRS;

import org.geotools.referencing.datum.DefaultGeodeticDatum;

import org.gvsig.crs.Crs;

import org.gvsig.crs.CrsException;

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

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

import org.opengis.referencing.crs.GeographicCRS;

public class ValidateEpsgCRSs {

	public ValidateEpsgCRSs() {

	}

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		HSQLDataSource ds = new HSQLDataSource();

		Connection conn;

		try {

			conn = ds.getConnection();

			final PreparedStatement stmt;

	        stmt = conn.prepareStatement("SELECT COORD_REF_SYS_CODE"

	                                      + " FROM epsg_coordinatereferencesystem");

	        ResultSet result;

			result = stmt.executeQuery();

	        ArrayList res = new ArrayList();

	        ArrayList units = new ArrayList();

	        ArrayList validos = new ArrayList();

	        while (result.next()) {

	        	int cod = result.getInt("COORD_REF_SYS_CODE");

        		String strEpsgCode="EPSG:"+cod;		

        		CoordinateReferenceSystem source;

        			try {

						source = CRS.decode(strEpsgCode);

						validos.add(String.valueOf(cod));

						if (source instanceof DefaultProjectedCRS) {

							String str;

							boolean esta = false;

							DefaultProjectedCRS sour = (DefaultProjectedCRS) source;

							Unit u = ((DefaultGeodeticDatum) sour.getDatum()).getPrimeMeridian().getAngularUnit();

							units.add(u.toString());

							/*for (int j = 0; j< units.size(); j++) {

					        	if (units.get(j).equals(u.toString())){

					        		esta = true;

					        		break;

					        	}						        	

					        }

							if (!esta){

								units.add(u.toString());

								esta = false;

							}*/

							for (int i=0; i< sour.getConversionFromBase().getParameterValues().values().size();i++) {

								str = sour.getConversionFromBase().getParameterValues().values().get(i).toString();

								u = sour.getConversionFromBase().getParameterValues().parameter(str.split("=")[0]).getUnit();

								units.add(u.toString());

							}

						}

						if (source instanceof DefaultGeographicCRS) {

							DefaultGeographicCRS sour = (DefaultGeographicCRS) source;

							boolean esta = false;

							Unit u = ((DefaultGeodeticDatum) sour.getDatum()).getPrimeMeridian().getAngularUnit();

							units.add(u.toString());							

						}

					} catch (NoSuchAuthorityCodeException e) {						

						res.add(String.valueOf(cod)+" --> "+e);

						// TODO Auto-generated catch block

						//e.printStackTrace();

					} catch (FactoryException e) {

						res.add(String.valueOf(cod)+" --> "+e);

						// TODO Auto-generated catch block

						//e.printStackTrace();

					}

	        }

	        for (int i = 0; i< res.size(); i++) {

	        	System.out.println(res.get(i));	        	

	        }	       

	        for (int i = 0; i< units.size(); i++) {

	        	System.out.println(units.get(i));

	        }

	        System.out.println("Numero CRSs validos: " + validos.size());

	        System.out.println("Numero CRSs fallidos: " + res.size());

	        System.out.println("Numero medidas: " + units.size());

		} catch (SQLException e1) {

			// TODO Auto-generated catch block

			e1.printStackTrace();

		}	

	}

}

			/*CoordinateReferenceSystem sourceCRS = CRS.decode("EPSG:4326");

			CoordinateReferenceSystem targetCRS = CRS.decode("EPSG:23032");

			MathTransform transform = CRS.findMathTransform(sourceCRS, targetCRS);

			System.out.println("Dimensiones: "+transform.getSourceDimensions());

			double points[] = {2.5,3.0};

			System.out.println("Puntos fuente: "+ points[0]+"  "+points[1]);

			transform.transform(points, 0, points, 0, 1);

			System.out.println("Puntos destino: "+ points[0]+"  "+points[1]);

			int epsgCount = 0;

			System.out.println("CRSs Disponibles en EPSG: \n");

			Set codes = CRS.getSupportedCodes("EPSG");

			for (Iterator iter = codes.iterator(); iter.hasNext();) {

			String code = (String) iter.next();

			System.out.println("EPSG:"+code);

			epsgCount++;

			}

			System.out.println("N�mero de CRSs en EPSG: "+epsgCount);

			try {

			System.out.println("Descripci�n de EPSG:23030:  \n"+CRS.getAuthorityFactory(false).getDescriptionText("EPSG:23030"));

			} catch (FactoryRegistryException e) {

//			 TODO Auto-generated catch block

			e.printStackTrace();

			} catch (FactoryException e) {

//			 TODO Auto-generated catch block

			e.printStackTrace();

			}

		} catch (NoSuchAuthorityCodeException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (FactoryException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}*/  

package es.idr.test;

import java.sql.SQLException;

import es.idr.teledeteccion.connection.EpsgConnection;

public class InsertUserDataCrs {

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		// TODO Auto-generated method stub

		EpsgConnection conn = new EpsgConnection();

		conn.setConnectionUsr();

		String sentence = "INSERT INTO USR VALUES(2000,'PROJCS[\"Anguilla_1957_British_West_Indies_Grid\",GEOGCS[\"GCS_Anguilla_1957\",DATUM[\"D_Anguilla_1957\",SPHEROID[\"Clarke_1880_RGS\",6378249.145,293.465]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",400000.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-62.0],PARAMETER[\"Scale_Factor\",0.9995],PARAMETER[\"Latitude_Of_Origin\",0.0],UNIT[\"Meter\",1.0]]','Anguilla_1957_British_West_Indies_Grid','GCS_Anguilla_1957','D_Anguilla_1957')";

		try {

			conn.update(sentence);

			conn.shutdown();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

}

package es.idr.test;

import java.io.BufferedWriter;

import java.io.FileWriter;

import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import javax.units.ConversionException;

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

import org.geotools.referencing.wkt.UnformattableObjectException;

import org.gvsig.crs.Crs;

import org.gvsig.crs.CrsException;

import org.gvsig.crs.CrsFactory;

import org.gvsig.crs.CrsGT;

import org.gvsig.crs.ICrs;

import org.gvsig.crs.Proj4;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

public class TestWKTandProj4Epsg {

	public static void main(String[] args) {

		HSQLDataSource ds = new HSQLDataSource();

		Connection conn;

		try {

			conn = ds.getConnection();

			int indice = 0;

			int fallo = 0;

			final PreparedStatement stmt;

	        stmt = conn.prepareStatement("SELECT COORD_REF_SYS_CODE, COORD_REF_SYS_NAME"

	        		          				+" FROM epsg_coordinatereferencesystem ");

	        		          				//+" WHERE COORD_REF_SYS_CODE>29372");

	        ResultSet result;

			result = stmt.executeQuery();

	        String filename = "salida.txt";

	        BufferedWriter bw =  new BufferedWriter(new FileWriter(filename));

	        while (result.next()) {

	        	ICrs crs = null;

	        	int cod = result.getInt("COORD_REF_SYS_CODE");

	        	try {

					crs = new CrsFactory().getCRS("EPSG:"+cod);

					if (crs instanceof CrsGT) {

//						//continue;

						if (crs.getProj4String() == null){

							bw.write("C?digo: "+cod+"\tNombre: "+result.getString("COORD_REF_SYS_NAME")+"\n");

				        	bw.write("Cadena WKT: "+crs.getWKT()+"\n");

				        	bw.write("Cadena Proj4: No cadena proj4 \n");

				        	bw.write("Fallo: Fallo generando en cadena proj4 \n");		        	

				        	bw.write("\n\n");

						}

					}						

					else {

						if (crs != null) {

							bw.write("C?digo: "+cod+"\tNombre: "+result.getString("COORD_REF_SYS_NAME")+"\n");

				        	bw.write("Cadena WKT: "+crs.getWKT()+"\n");

				        	bw.write("Cadena Proj4: "+crs.getProj4String()+"\n");

				        	bw.write("Fallo: Creado con crs antiguo \n");		        	

				        	bw.write("\n\n");

						}

						else {

							bw.write("C?digo: "+cod+"\tNombre: "+result.getString("COORD_REF_SYS_NAME")+"\n");

							bw.write("Fallo: Falla tanto geotools como crs antiguo \n");		        	

				        	bw.write("\n\n");

						}

					}

				} catch (CrsException e) {

					bw.write("C?digo: "+cod+"\tNombre: "+result.getString("COORD_REF_SYS_NAME")+"\n");

		        	bw.write("Cadena WKT: No cadena wkt \n");

		        	bw.write("Cadena Proj4: No cadena proj4\n");

		        	bw.write("Fallo: "+e+" \n");		        	

		        	bw.write("\n\n");

				} catch (NumberFormatException e) {

					bw.write("C?digo: "+cod+"\tNombre: "+result.getString("COORD_REF_SYS_NAME")+"\n");

		        	bw.write("Cadena WKT: No cadena wkt \n");

		        	bw.write("Cadena Proj4: No cadena proj4\n");

		        	bw.write("Fallo: "+e+" \n");		        	

		        	bw.write("\n\n");

				} catch (ConversionException e) {

					bw.write("C?digo: "+cod+"\tNombre: "+result.getString("COORD_REF_SYS_NAME")+"\n");

		        	bw.write("Cadena WKT: No cadena wkt \n");

		        	bw.write("Cadena Proj4: No cadena proj4\n");

		        	bw.write("Fallo: "+e+" \n");		        	

		        	bw.write("\n\n");

				}catch (UnformattableObjectException e) {					

				}				

	        }

	        bw.flush();

	        bw.close();

		} catch (SQLException e1) {

			// TODO Auto-generated catch block

			e1.printStackTrace();

		} catch (IOException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}	

	}

}

package es.idr.test;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import javax.units.Unit;

import org.geotools.referencing.CRS;

import org.geotools.referencing.crs.DefaultGeographicCRS;

import org.geotools.referencing.crs.DefaultProjectedCRS;

import org.geotools.referencing.datum.DefaultGeodeticDatum;

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

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

import es.idr.teledeteccion.connection.EpsgConnection;

import es.idr.teledeteccion.connection.Query;

public class ValidateEsriCRSs {

	public ValidateEsriCRSs() {

	}

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		//HSQLDataSource ds = new HSQLDataSource();

		EpsgConnection conn = new EpsgConnection();

		//Connection conn;

		conn.setConnectionEsri();

		try {

			//conn = ds.getConnection();

			//final PreparedStatement stmt;

	        /*stmt = conn.prepareStatement("SELECT esri_code"

	                                      + " FROM esri");

	        */

	        String sentence = "SELECT esri_code,esri_wkt " +							 

								  "FROM ESRI";

	        ResultSet result;

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

			//result = stmt.executeQuery();

	        ArrayList res = new ArrayList();

	        ArrayList units = new ArrayList();

	        ArrayList validos = new ArrayList();

	        while (result.next()) {

	        	int cod = result.getInt("esri_code");

	        	String wkt = result.getString("esri_wkt");

        		//String strEpsgCode="ESRI:"+cod;		

        		CoordinateReferenceSystem source;

        			/*try {

						source = CRS.parseWKT(wkt);

						validos.add(String.valueOf(cod));

						if (source instanceof DefaultProjectedCRS) {

							String str;

							boolean esta = false;

							DefaultProjectedCRS sour = (DefaultProjectedCRS) source;

							Unit u = ((DefaultGeodeticDatum) sour.getDatum()).getPrimeMeridian().getAngularUnit();

							units.add(u.toString());

							for (int j = 0; j< units.size(); j++) {

					        	if (units.get(j).equals(u.toString())){

					        		esta = true;

					        		break;

					        	}						        	

					        }

							if (!esta){

								units.add(u.toString());

								esta = false;

							}

							for (int i=0; i< sour.getConversionFromBase().getParameterValues().values().size();i++) {

								str = sour.getConversionFromBase().getParameterValues().values().get(i).toString();

								u = sour.getConversionFromBase().getParameterValues().parameter(str.split("=")[0]).getUnit();

								units.add(u.toString());

							}

						}

						if (source instanceof DefaultGeographicCRS) {

							DefaultGeographicCRS sour = (DefaultGeographicCRS) source;

							boolean esta = false;

							Unit u = ((DefaultGeodeticDatum) sour.getDatum()).getPrimeMeridian().getAngularUnit();

							units.add(u.toString());							

						}

					} catch (NoSuchAuthorityCodeException e) {

						res.add(String.valueOf(cod)+" --> "+e);

						// TODO Auto-generated catch block

						//e.printStackTrace();

					} catch (FactoryException e) {

						res.add(String.valueOf(cod)+" --> "+e);

						// TODO Auto-generated catch block

						//e.printStackTrace();

					}*/

	        }

	        /*for (int i = 0; i< res.size(); i++) {

	        	System.out.println(res.get(i));

	        }*/	

	        for (int i = 0; i< units.size(); i++) {

	        	System.out.println(units.get(i));

	        }

	        System.out.println("Numero CRSs validos: " + validos.size());

	        System.out.println("Numero medidas: " + units.size());

	        System.out.println("Numero CRSs fallidos: " + res.size());

		} catch (SQLException e1) {

			// TODO Auto-generated catch block

			e1.printStackTrace();

		}	

	}

}

package es.idr.test;

import org.geotools.referencing.CRS;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

public class TestGeotools21 {

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		try {	        	

    		String strEpsgCode="EPSG:27572";

    		CoordinateReferenceSystem source;

    		source = CRS.decode(strEpsgCode);

        	System.out.println(source.toWKT());

		} catch (NoSuchAuthorityCodeException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (FactoryException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

}

package es.idr.test.connection;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

public class UsrConnection {

	Connection connect;

	public UsrConnection() {

		try {

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

		} catch (ClassNotFoundException e) {

			e.printStackTrace();

		}

		try {			

			connect =  DriverManager.getConnection("jdbc:hsqldb:file:/home/jlgomez/gvSIGF2/gt2-usr-hsql/src/org/geotools/referencing/factory/usr/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

    }

	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();

    }    

}

package es.idr.test.connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import es.idr.teledeteccion.connection.EpsgConnection;

import es.idr.teledeteccion.connection.Query;

public class TestConnection {

	public TestConnection () {

		testEpsgDataBase();

		testEsriDataBase();

		testIau2000DataBase();

	}

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		// TODO Auto-generated method stub

		TestConnection tc = new TestConnection();

	}

	private void testEpsgDataBase() {

		EpsgConnection connect = new EpsgConnection();

		connect.setConnectionEPSG();

		String sentence = "SELECT coord_ref_sys_name " +

							"FROM epsg_coordinatereferencesystem " +	                              

							"WHERE coord_ref_sys_code = 23030";

		ResultSet result;

        try {			

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

			result.next();

			System.out.println(result.getString("coord_ref_sys_name"));

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

	private void testEsriDataBase (){

		EpsgConnection connect = new EpsgConnection();

		connect.setConnectionEsri();

		String sentence = "SELECT esri_proj " +							 

						  "FROM ESRI " +	                              

						  "WHERE esri_code = 23030";

		ResultSet result = null;

    	try {

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

			result.next();

			System.out.println(result.getString("esri_proj"));

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

	private void testIau2000DataBase() {

		EpsgConnection connect = new EpsgConnection();

		connect.setConnectionIAU2000();

		String sentence = "SELECT iau_geog " +							 

						  "FROM IAU2000 " +	                              

						  "WHERE iau_code = 19900";

		ResultSet result = null;    	

		try {

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

			result.next();

			System.out.println(result.getString("iau_geog"));

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

}

package es.idr.crs.crsGT;

import java.util.Arrays;

import java.util.Iterator;

import org.geotools.factory.FactoryRegistry;

import org.geotools.referencing.operation.MathTransformProvider;

public class ProvidersTest {

	public static void main(String[] args) {

		final Class[] categories = {org.geotools.referencing.operation.MathTransformProvider.class};

		FactoryRegistry registry = new FactoryRegistry(Arrays.asList(categories));

		Iterator providers = registry.getServiceProviders(MathTransformProvider.class);

		Iterator providers2 = null;

		MathTransformProvider provider = null;

		MathTransformProvider provider2 = null;

		while (providers.hasNext()){

			provider = (MathTransformProvider) providers.next(); 

			if(provider.nameMatches("IDR")){

				providers2 = registry.getServiceProviders(MathTransformProvider.class);

				while (providers2.hasNext()){

					provider2 = (MathTransformProvider) providers2.next();

					if(provider2.nameMatches(provider.getName().toString()) && !provider2.nameMatches("IDR"))

						registry.deregisterServiceProvider(provider2, categories[0]);

				}

			}

		}

		providers = registry.getServiceProviders(MathTransformProvider.class);

		while (providers.hasNext()) {

            provider = (MathTransformProvider) providers.next();

            if (provider.nameMatches("IDR"))

            	System.out.println("-IDR-"+provider.toString());

            else

            	System.out.println(provider.toString());

		}

	}

}

package es.idr.crs.crsGT;

import org.cresques.cts.IProjection;

import org.gvsig.crs.CrsException;

import org.gvsig.crs.CrsGT;

import org.gvsig.crs.ICrs;

import org.gvsig.crs.Proj4;

import org.gvsig.crs.repository.EpsgRepositoryGT;

import org.gvsig.crs.repository.EsriRepositoryGT;

import org.gvsig.crs.repository.Iau2000RepositoryGT;

import org.gvsig.crs.repository.UsrRepositoryGT;

public class CrsGTTest {

	public CrsGTTest() {

		epsgTest();

		esriTest();

		iau2000Test();

		usrTest();

	}

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		CrsGTTest g = new CrsGTTest();

	}

	public void epsgTest() {

		EpsgRepositoryGT repo = new EpsgRepositoryGT();

		IProjection crs=null;

		crs = repo.getCrs("23030");

		if (crs!=null){

			System.out.println(crs.getAbrev());

			System.out.println(((ICrs)crs).getCode());

			System.out.println(((ICrs)crs).getWKT());

			System.out.println(((ICrs)crs).getDatum().getEIFlattening());

			System.out.println(((ICrs)crs).getDatum().getESemiMajorAxis());

			System.out.println(((ICrs)crs).isProjected()+"\n\n");

			System.out.println("----------- CrsWkt:--------------");

			System.out.println(((ICrs)crs).getCrsWkt().getAuthority()[0]+":"+((ICrs)crs).getCrsWkt().getAuthority()[1]);

			System.out.println(((ICrs)crs).getCrsWkt().getName());

			System.out.println(((ICrs)crs).getCrsWkt().getDatumName());

			System.out.println(((ICrs)crs).getCrsWkt().getGeogcs());

			System.out.println(((ICrs)crs).getCrsWkt().getProjcs());

			System.out.println(((ICrs)crs).getCrsWkt().getProjection());

			System.out.println(((ICrs)crs).getCrsWkt().getPrimen()[0]+" -- "+ ((ICrs)crs).getCrsWkt().getPrimen()[1]+"\n\n");

			try {

				Proj4 proj4 = new Proj4();

				System.out.println(proj4.exportToProj4(((CrsGT)crs).getCrsGT()));

			} catch (CrsException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}

		}

	}

	public void esriTest() {

		EsriRepositoryGT repo = new EsriRepositoryGT();

		IProjection crs=null;

		crs = repo.getCrs("23030");

		if (crs!=null){

			System.out.println(crs.getAbrev());

			System.out.println(((ICrs)crs).getCode());

			System.out.println(((ICrs)crs).getWKT());

			System.out.println(((ICrs)crs).getDatum().getEIFlattening());

			System.out.println(((ICrs)crs).getDatum().getESemiMajorAxis());

			System.out.println(((ICrs)crs).isProjected()+"\n\n");

			System.out.println("----------- CrsWkt:--------------");

			System.out.println(((ICrs)crs).getCrsWkt().getAuthority()[0]+":"+((ICrs)crs).getCrsWkt().getAuthority()[1]);

			System.out.println(((ICrs)crs).getCrsWkt().getName());

			System.out.println(((ICrs)crs).getCrsWkt().getDatumName());

			System.out.println(((ICrs)crs).getCrsWkt().getGeogcs());

			System.out.println(((ICrs)crs).getCrsWkt().getProjcs());

			System.out.println(((ICrs)crs).getCrsWkt().getProjection());

			System.out.println(((ICrs)crs).getCrsWkt().getPrimen()[0]+" -- "+ ((ICrs)crs).getCrsWkt().getPrimen()[1]+"\n\n");

			try {

				Proj4 proj4 = new Proj4();

				System.out.println(proj4.exportToProj4(((CrsGT)crs).getCrsGT()));

			} catch (CrsException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}

		}

	}

	public void iau2000Test() {

		Iau2000RepositoryGT repo = new Iau2000RepositoryGT();

		IProjection crs=null;

		crs = repo.getCrs("19900");

		if (crs!=null){

			System.out.println(crs.getAbrev());

			System.out.println(((ICrs)crs).getCode());

			System.out.println(((ICrs)crs).getWKT());

			System.out.println(((ICrs)crs).getDatum().getEIFlattening());

			System.out.println(((ICrs)crs).getDatum().getESemiMajorAxis());

			System.out.println(((ICrs)crs).isProjected()+"\n\n");

			System.out.println("----------- CrsWkt:--------------");

			System.out.println(((ICrs)crs).getCrsWkt().getAuthority()[0]+":"+((ICrs)crs).getCrsWkt().getAuthority()[1]);

			System.out.println(((ICrs)crs).getCrsWkt().getName());

			System.out.println(((ICrs)crs).getCrsWkt().getDatumName());

			System.out.println(((ICrs)crs).getCrsWkt().getGeogcs());

			System.out.println(((ICrs)crs).getCrsWkt().getProjcs());

			System.out.println(((ICrs)crs).getCrsWkt().getProjection());

			System.out.println(((ICrs)crs).getCrsWkt().getPrimen()[0]+" -- "+ ((ICrs)crs).getCrsWkt().getPrimen()[1]+"\n\n");

			try {

				Proj4 proj4 = new Proj4();

				System.out.println(proj4.exportToProj4(((CrsGT)crs).getCrsGT()));

			} catch (CrsException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}

		}

	}

	public void usrTest() {

		UsrRepositoryGT repo = new UsrRepositoryGT();

		IProjection crs=null;

		crs = repo.getCrs("2000");

		if (crs!=null){

			System.out.println(crs.getAbrev());

			System.out.println(((ICrs)crs).getCode());

			System.out.println(((ICrs)crs).getWKT());

			System.out.println(((ICrs)crs).getDatum().getEIFlattening());

			System.out.println(((ICrs)crs).getDatum().getESemiMajorAxis());

			System.out.println(((ICrs)crs).isProjected()+"\n\n");

			System.out.println("----------- CrsWkt:--------------");

			System.out.println(((ICrs)crs).getCrsWkt().getAuthority()[0]+":"+((ICrs)crs).getCrsWkt().getAuthority()[1]);

			System.out.println(((ICrs)crs).getCrsWkt().getName());

			System.out.println(((ICrs)crs).getCrsWkt().getDatumName());

			System.out.println(((ICrs)crs).getCrsWkt().getGeogcs());

			System.out.println(((ICrs)crs).getCrsWkt().getProjcs());

			System.out.println(((ICrs)crs).getCrsWkt().getProjection());

			System.out.println(((ICrs)crs).getCrsWkt().getPrimen()[0]+" -- "+ ((ICrs)crs).getCrsWkt().getPrimen()[1]+"\n\n");

			try {

				Proj4 proj4 = new Proj4();

				System.out.println(proj4.exportToProj4(((CrsGT)crs).getCrsGT()));

			} catch (CrsException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}

		}

	}

}

package org.gvsig.crs.jscrollpanel;

import java.awt.Dimension;

import javax.swing.BorderFactory;

import javax.swing.JFrame;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.table.DefaultTableModel;

import javax.swing.table.TableColumn;

public class ScrollPanelTest {

	JTable jTable = null;

	JScrollPane jScrollPane = null;

	public ScrollPanelTest() {

		super();

		JFrame jFrame = new JFrame();

		jFrame.getContentPane().add(getJScrollPane());	

		jFrame.setSize(500, 150);

		jFrame.setVisible(true);

		// TODO Auto-generated constructor stub

	}

	public JTable getJTable() {

		if (jTable == null) {

			String[] columnNames= {"UNA COLUMNA", "DOS COLUMNAS"};

			Object[][]data = {};			

			DefaultTableModel dtm = new DefaultTableModel(data, columnNames);

			jTable = new JTable(dtm);

			jTable.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

			TableColumn column = null;

			   for (int i = 0; i < 2; i++) {

			       column = jTable.getColumnModel().getColumn(i);

			       if (i == 0) {

			           column.setPreferredWidth(600);

			       }

			   }

			//jTable.setPreferredSize(new Dimension(800, 100));			

		}

		return jTable;

	}

	private JScrollPane getJScrollPane() {

		if (jScrollPane == null) {

			jScrollPane = new JScrollPane(getJTable(),JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED, JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);

			jScrollPane.setPreferredSize(new Dimension(500,150));

			jScrollPane.setBorder(

				    BorderFactory.createCompoundBorder(

					BorderFactory.createCompoundBorder(

							BorderFactory.createTitledBorder("TABLA GEN?RICA DE 2 CAMPOS"),

							BorderFactory.createEmptyBorder(5,5,5,5)),

							jScrollPane.getBorder()));

			jScrollPane.setViewportView(getJTable());

		}

		return jScrollPane;

	}

	public static void main(String[] args){

		ScrollPanelTest al = new ScrollPanelTest();

	}

}

package org.gvsig.crs.repository;

import org.gvsig.crs.Crs;

public class RepositoryTest {

	public static void main(String[] args){

		EpsgRepository epsgRep= new EpsgRepository();

		Crs crs = (Crs)epsgRep.getCrs("23030");

		if (crs != null){

			String abrev = crs.getAbrev();

			System.out.println(abrev);

		}

		else

			System.out.println("el c?digo no existe en el repositorio.");

	}

}

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

import java.io.File;

import java.io.IOException;

import java.io.InputStreamReader;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.logging.Logger;

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

import org.geotools.referencing.factory.iau2000.FactoryUsingHSQL;

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;

	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.extension/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.extension/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("jdbc:hsqldb:file:gvSIG/extensiones/org.gvsig.crs.extension/usr");

		setUser("sa");

		try {

			connect = super.getConnection();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.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

    }

	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.extension/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.extension/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.extension/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.extension/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;

	}	

}

package org.geotools.referencing.operation.projection;

import java.awt.geom.Point2D;

import java.util.Collection;

import javax.units.NonSI;

import org.opengis.parameter.ParameterDescriptorGroup;

import org.opengis.parameter.ParameterNotFoundException;

import org.opengis.parameter.ParameterValueGroup;

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

import org.geotools.referencing.NamedIdentifier;

import org.geotools.resources.XMath;

import org.geotools.resources.cts.ResourceKeys;

import org.geotools.resources.cts.Resources;

import org.opengis.parameter.ParameterDescriptor;

import org.opengis.referencing.operation.Projection;

import org.opengis.referencing.operation.MathTransform;

public class IdrGoode extends MapProjection {

    protected IdrGoode(ParameterValueGroup parameters) throws ParameterNotFoundException {

		super(parameters);

        final Collection expected = getParameterDescriptors().descriptors();

	}

	public ParameterDescriptorGroup getParameterDescriptors() {