Application: gvSIG desktop » gvSIG projections

package org.gvsig.crs.spatialReferenceIdentifyStrategies;

import es.idr.teledeteccion.connection.EpsgConnection;

import es.idr.teledeteccion.connection.Query;

import java.sql.ResultSet;

import org.apache.commons.lang3.StringUtils;

import org.gdal.osr.SpatialReference;

public class IdentifyEsri extends AbstractIdentifyStrategy {

    private int best_code;

    public IdentifyEsri() {

    }

    public int getBestAccuracy() {

        if( best_code == 0 ) {

            return 1000;

        }

        return 0;

    }

    public SpatialReference getBest() {

        SpatialReference sr = createSpatialReferenceFromEPSGCode(best_code);

        return sr;

    }

    public SpatialReference identify(SpatialReference sr) {

        if (autoIdentifyEPSG(sr)) {

            return sr;

        }

        String source_proj4 = getProj4String(sr);

        String sql = "";

        if (sr.IsGeographic() == 1) {

            sql = "SELECT ESRI_CODE, ESRI_WKT FROM ESRI WHERE ESRI_WKT LIKE 'GEOGCS%'"

                    + " AND ESRI_GEOG LIKE '" + StringUtils.replace(sr.GetAttrValue("GEOGCS"), "'", "''") + "'";

        } else {

            if (sr.IsProjected() == 1) {

                sql = "SELECT ESRI_CODE, ESRI_WKT FROM ESRI WHERE ESRI_WKT LIKE 'PROJCS%'"

                        + " AND ESRI_PROJ LIKE '" + StringUtils.replace(sr.GetAttrValue("PROJCS"), "'", "''") + "'";

            }

        }

        logger.debug(sql);

        int code = 0;

        best_code = 0;

        EpsgConnection conn = null;

        try {

            conn = new EpsgConnection();

            conn.setConnectionEsri();

            ResultSet result = Query.select(sql, conn.getConnection());

            while (result.next()) {

                code = result.getInt("ESRI_CODE");

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

                logger.debug("Trying to match ESRI:{}...", code);

                try {

                    SpatialReference target_sr = new SpatialReference();

                    target_sr.ImportFromWkt(wkt);

                    target_sr.MorphFromESRI();

                    String target_proj4 = target_sr.ExportToProj4();

                    if (StringUtils.equals(source_proj4, target_proj4)) {

                        logger.debug("ESRI:{} matches!", code);

                        best_code = code;

                        return createSpatialReferenceFromESRICode(code);

                    }

                } catch (Exception e) {

                    //logger.debug("Can't identify the ESRI code...");

                }

            }

        } catch(Exception ex) {

        } finally {

            if( conn != null ) {

                try {

                    conn.close();            

                } catch(Exception ex1) {

                }

            }

        }

        logger.debug("Can't identify the ESRI code...");

        best_code = 0;

        return null;

    }

}