| gvSIG desktop 1

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 org.geotools.referencing.CRS;

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

import org.gvsig.crs.Crs;

import org.gvsig.crs.CrsException;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

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

	        while (result.next()) {

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

        		String strEpsgCode="EPSG:"+cod;		

        		CoordinateReferenceSystem source;

        			try {

						source = CRS.decode(strEpsgCode);

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

	        }	       

	        System.out.println("Numero CRSs fallidos: " + res.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();

		}*/