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

                }*/