| 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 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.gvsig.crs.EpsgConnection;

import org.gvsig.crs.Query;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

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

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

						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 medidas: " + units.size());

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

		} catch (SQLException e1) {

			// TODO Auto-generated catch block

			e1.printStackTrace();

		}	

	}

}

import javax.units.Unit;

import org.geotools.referencing.crs.DefaultGeographicCRS;

import org.geotools.referencing.crs.DefaultProjectedCRS;

import org.geotools.referencing.datum.DefaultGeodeticDatum;

import org.opengis.referencing.crs.GeographicCRS;

	        ArrayList units = new ArrayList();

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

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

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

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

	        }

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