Application: gvSIG desktop

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.ConversionException;

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.geotools.referencing.wkt.UnformattableObjectException;

import org.gvsig.crs.Crs;

import org.gvsig.crs.CrsException;

import org.gvsig.crs.Proj4;

import org.opengis.referencing.FactoryException;

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

                        final PreparedStatement stmt;

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

                                              + " FROM epsg_coordinatereferencesystem");

                ResultSet result;

                        result = stmt.executeQuery();

                ArrayList wkt = new ArrayList();

                ArrayList proj4 = new ArrayList();

                ArrayList name = new ArrayList();

                ArrayList codigo = new ArrayList();

                ArrayList fallos = new ArrayList();

                while (result.next()) {

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

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

                        name.add(result.getString("COORD_REF_SYS_NAME"));

                            try {

                                        Crs crs = new Crs(cod,1);

                                        wkt.add(crs.getWKT());

                                        Proj4 proj= new Proj4();

                                        proj4.add(proj.exportToProj4(crs));

                                } catch (CrsException e) {

                                        // TODO Auto-generated catch block

                                        e.printStackTrace();

                                } catch (NumberFormatException e) {

                                        // TODO Auto-generated catch block

                                        //e.printStackTrace();

                                        fallos.add(""+cod+": "+e);

                                } catch (ConversionException e) {

                                        // TODO Auto-generated catch block

                                        //e.printStackTrace();

                                        fallos.add(""+cod+": "+e);

                                }catch (UnformattableObjectException e) {

                                        // TODO Auto-generated catch block

                                        //e.printStackTrace();

                                        fallos.add(""+cod+": "+e);

                                }                        

                }

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

                        System.out.println("C?digo: "+codigo.get(i)+"\tNombre: "+name.get(i));

                        System.out.println("Cadena WKT: "+wkt.get(i));

                        System.out.println("Cadena Proj4: "+name.get(i));

                }        

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

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

                }        

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

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

                } catch (SQLException e1) {

                        // TODO Auto-generated catch block

                        e1.printStackTrace();

                }        

        }

}