Application: gvSIG desktop » gvSIG projections

package org.gvsig.geotools.proj.catalog;

import java.io.File;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.text.ParseException;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.Collections;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import java.util.Set;

import javax.sql.DataSource;

import org.geotools.factory.FactoryFinder;

import org.geotools.factory.FactoryNotFoundException;

import org.geotools.referencing.CRS;

import org.geotools.referencing.ReferencingFactoryFinder;

import org.geotools.referencing.factory.BufferedAuthorityFactory;

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

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

import org.geotools.resources.i18n.ErrorKeys;

import org.geotools.resources.i18n.Errors;

import org.gvsig.proj.catalog.CRSCatalogManager;

import org.gvsig.proj.catalog.CRSDefinition;

import org.gvsig.proj.catalog.TextSerialization;

import org.gvsig.proj.catalog.TextSerialization.Format;

import org.gvsig.proj.catalog.TransformationDefinition;

import org.gvsig.proj.catalog.exception.CoordinateReferenceSystemException;

import org.gvsig.proj.catalog.exception.UnsupportedCoordinateReferenceSystemException;

import org.gvsig.proj.catalog.exception.UnsupportedTransformationException;

import org.opengis.referencing.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CRSAuthorityFactory;

import org.opengis.referencing.crs.CRSFactory;

import org.opengis.referencing.crs.CompoundCRS;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

import org.opengis.referencing.crs.GeocentricCRS;

import org.opengis.referencing.crs.GeographicCRS;

import org.opengis.referencing.cs.CartesianCS;

import org.opengis.referencing.cs.CoordinateSystem;

import org.opengis.referencing.cs.EllipsoidalCS;

import org.opengis.referencing.cs.SphericalCS;

import org.opengis.referencing.cs.VerticalCS;

import org.opengis.referencing.datum.EngineeringDatum;

import org.opengis.referencing.datum.GeodeticDatum;

import org.opengis.referencing.datum.VerticalDatum;

import org.opengis.referencing.operation.Conversion;

import org.opengis.referencing.operation.CoordinateOperation;

import org.opengis.referencing.operation.CoordinateOperationFactory;

import org.opengis.referencing.operation.MathTransform;

import org.opengis.referencing.operation.Projection;

public class GtCRSCatalogManager implements CRSCatalogManager {

        private static final String EPSG_DB_SUBFOLDER = "epsg";        

        private static final List<TextSerialization.Format> SUPPORTED_FORMATS = Arrays.asList(TextSerialization.Format.WKT1);

        private static final List<String> supportedAuthorities = Collections.unmodifiableList(Arrays.asList("EPSG", "ESRI", "USER"));

        public GtCRSCatalogManager() {

        }

        @Override

        public List<String> getAuthorityNames() {

                return supportedAuthorities;

                //return new ArrayList<String>(CRS.getSupportedAuthorities(true));

        }

        protected String toCode(String authorityName, String relCode) {

                return authorityName + ":" + relCode;

        }

        @Override

        public List<String> getCodes() {

                ArrayList<String> codes = new ArrayList<String>();

                Set<String> authorities = CRS.getSupportedAuthorities(true);

                for (String auth: authorities) {

                        CRSAuthorityFactory factory = ReferencingFactoryFinder.getCRSAuthorityFactory(auth, null);

                        try {

                                for (String code: factory.getAuthorityCodes(CoordinateReferenceSystem.class)) {

                                        codes.add(toCode(auth, code));

                                }

                        } catch (FactoryException | FactoryNotFoundException e) {

                                // TODO Auto-generated catch block

                                e.printStackTrace();

                        }

                }

                return codes;

        }

        @Override

        public List<String> getCodes(String authorityName) {

                // FIXME handle other authorities

                ArrayList<String> codes = new ArrayList<String>();

                if ("EPSG".equals(authorityName)) {

                        try {

                                CRSAuthorityFactory factory = ReferencingFactoryFinder.getCRSAuthorityFactory(authorityName, null);

                                for (String code: factory.getAuthorityCodes(CoordinateReferenceSystem.class)) {

                                        codes.add(toCode(authorityName, code));

                                }

                        } catch (FactoryException | FactoryNotFoundException e) {

                                // TODO Auto-generated catch block

                                e.printStackTrace();

                        }

                }

                return codes;

        }

        @Override

        public List<String> search(String searchString) {

                // FIXME handle other authorities

                return searchEpsg(searchString);

        }

        @Override

        public List<String> search(String authority, String searchString) {

                // FIXME handle other authorities

                if (authority.equals("EPSG")) {

                        return searchEpsg(searchString);

                }

                return Collections.emptyList();

        }

        protected List<String> searchEpsg(String searchString) {

                // FIXME handle other authorities

                CRSAuthorityFactory factory = ReferencingFactoryFinder.getCRSAuthorityFactory("EPSG", null);

                if (factory instanceof ThreadedEpsgFactory) {

                        ThreadedEpsgFactory epsgFactory = (ThreadedEpsgFactory) factory;

                        try {

                                DataSource ds = epsgFactory.getDataSource();

                                Connection c = ds.getConnection();

                                return searchEpsg(searchString, c);

                        } catch (SQLException e) {

                                // TODO Auto-generated catch block

                                e.printStackTrace();

                        }

                }

                return Collections.EMPTY_LIST;

        }

    public synchronized List<String> searchEpsg(String searchString, Connection conn) throws SQLException

    {

            ArrayList<String> codes = new ArrayList<String>();

            if (searchString.startsWith("EPSG:")) {

                    searchString = searchString.substring(5);

            }

            searchString = "%" + searchString.toLowerCase() + "%";

        try {

            // FIXME: JOIN query with area of use. Maybe also with  COORD_SYS_CODE to search for coord sys name

            final PreparedStatement stmt;

            stmt = conn.prepareStatement("SELECT COORD_REF_SYS_CODE,"

                  +       " COORD_REF_SYS_NAME,"

                  +       " AREA_OF_USE_CODE,"

                  +       " CRS_SCOPE,"

                  +       " REMARKS,"

                  +       " COORD_REF_SYS_KIND,"

                  +       " COORD_SYS_CODE,"       // Null for CompoundCRS

                  +       " DATUM_CODE,"           // Null for ProjectedCRS

                  +       " SOURCE_GEOGCRS_CODE,"  // For ProjectedCRS

                  +       " PROJECTION_CONV_CODE," // For ProjectedCRS

                  +       " CMPD_HORIZCRS_CODE,"   // For CompoundCRS only

                  +       " CMPD_VERTCRS_CODE"     // For CompoundCRS only

                  + " FROM epsg_coordinatereferencesystem"

                  + " WHERE COORD_REF_SYS_CODE LIKE ? OR LCASE(COORD_REF_SYS_NAME) LIKE ?"

                  + " OR LCASE(REMARKS) LIKE ?"

                  + " OR LCASE(CRS_SCOPE) LIKE ?");

            stmt.setString(1, searchString);

            stmt.setString(2, searchString);

            stmt.setString(3, searchString);

            stmt.setString(4, searchString);

            ResultSet result = stmt.executeQuery();

            while (result.next()) {

                final String epsg    = result.getString(1);//getString(result, 1, code);

                final String name    = result.getString(2);//getString(result, 2, code);

                final String area    = result.getString(3);

                final String scope   = result.getString(4);

                final String remarks = result.getString(5);

                final String csCode  = result.getString(7);

                final String dmCode    = result.getString( 8); // geographic

                final String geoCode = result.getString(9);

                final String opCode  = result.getString(10);

                // vertical:

                final String code1 = result.getString(11);

                final String code2 = result.getString(12);

                codes.add(epsg);

            }

            result.close();

        } catch (SQLException exception) {

            throw exception;

        }

        conn.close();

        System.out.println(codes.size());

        return codes;

    }

        @Override

        public CRSDefinition getCRSDefinition(String code) throws UnsupportedCoordinateReferenceSystemException {

                CoordinateReferenceSystem crs;

                try {

                        crs = CRS.decode(code);

                } catch (NoSuchAuthorityCodeException e) {

                        throw new UnsupportedCoordinateReferenceSystemException(code, e);

                } catch (FactoryException e) {

                        throw new UnsupportedCoordinateReferenceSystemException(code, e);

                }

                return new DefaultCRS(crs);

        }

        public CRSDefinition getCRSDefinition(CoordinateReferenceSystem crs) throws UnsupportedCoordinateReferenceSystemException {

                return new DefaultCRS(crs);

        }

        @Override

        public CRSDefinition getCompoundCRS(CRSDefinition... crsList) throws UnsupportedCoordinateReferenceSystemException {

                DefaultCRS[] defs = (DefaultCRS[]) crsList;

                ArrayList<CoordinateReferenceSystem> components = new ArrayList<CoordinateReferenceSystem>();

                for (CRSDefinition def: defs) {

                        if (def instanceof DefaultCRS) {

                                components.add(((DefaultCRS)def).getInternalCRS());        

                        }

                        else {

                                def = new DefaultCRS(def.toWKT());

                        }

                }

            CRSFactory crsFactory = ReferencingFactoryFinder.getCRSFactory(null);

                CoordinateReferenceSystem compoundCRS;

                try {

                    Map<String, String> properties = new HashMap<String, String>();

                    crsFactory.createCompoundCRS(properties, components.toArray(new CoordinateReferenceSystem[components.size()]));

                        compoundCRS = crsFactory.createCompoundCRS(properties, components.toArray(new CoordinateReferenceSystem[components.size()]));;

                        return new DefaultCRS(compoundCRS);

                } catch (FactoryException e) {

                        throw new UnsupportedCoordinateReferenceSystemException(e);

                }

        }

        @Override

        public CRSDefinition parseCRSDefinition(String def) throws UnsupportedCoordinateReferenceSystemException {

                CoordinateReferenceSystem crs;

                try {

                        crs = CRS.parseWKT(def);

                } catch (NoSuchAuthorityCodeException e) {

                        throw new UnsupportedCoordinateReferenceSystemException(def, e);

                } catch (FactoryException e) {

                        throw new UnsupportedCoordinateReferenceSystemException(def, e);

                }

                return new DefaultCRS(crs);

        }

        @Override

        public CRSDefinition parseCRSDefinition(String def, Format format)

                        throws UnsupportedCoordinateReferenceSystemException {

                if (SUPPORTED_FORMATS.contains(format)) {

                        parseCRSDefinition(def);

                }

                throw new UnsupportedOperationException("Format not supported");

        }

        @Override

        public DefaultTransformation parseTransformationDefinition(String def) throws ParseException {

                return new DefaultTransformation(def);

        }

        @Override

        public DefaultTransformation parseTransformationDefinition(String def, Format format)

                        throws UnsupportedCoordinateReferenceSystemException, ParseException {

                if (SUPPORTED_FORMATS.contains(format)) {

                        return new DefaultTransformation(def);

                }

                throw new UnsupportedOperationException("Format not supported");

        }

        @Override

        public TransformationDefinition getTransformationDefinition(String code) {

                // TODO Auto-generated method stub

                return null;

        }

        public TransformationDefinition getTransformationDefinition(CoordinateOperation operation, boolean inverse) {

                // TODO Auto-generated method stub

                return null;

        }

        @Override

        public String registerCoordinateReferenceSystem(String wktDefinition, String description) {

                // TODO Auto-generated method stub

                return null;

        }

        @Override

        public String registerTransformation(String wktDefinition, String description) {

                // TODO Auto-generated method stub

                return null;

        }

        @Override

        public String registerCoordinateTransformationPVT(String sourceCRS, String targetCRS, String description,

                        float xTraslation, float yTraslation, float zTraslation, float xRotation, float yRotation, float zRotation,

                        float scaleDifference) {

                // TODO Auto-generated method stub

                return null;

        }

        @Override

        public String registerCoordinateTransformationCFR(String sourceCRS, String targetCRS, String description,

                        float xTraslation, float yTraslation, float zTraslation, float xRotation, float yRotation, float zRotation,

                        float scaleDifference) {

                // TODO Auto-generated method stub

                return null;

        }

        @Override

        public String registerCoordinateTransformation(String sourceCRS, String targetCRS, String description,

                        File ntv2Grid) {

                // TODO Auto-generated method stub

                return null;

        }

        @Override

        public List<TransformationDefinition> getCoordinateTransformations(CRSDefinition source, CRSDefinition target) throws CoordinateReferenceSystemException {

                ArrayList<TransformationDefinition> transforms = new ArrayList<TransformationDefinition>();

                try {

                        CoordinateReferenceSystem sourceCRS = ((DefaultCRS)source).getInternalCRS();

                        CoordinateReferenceSystem targetCRS = ((DefaultCRS)target).getInternalCRS();

                CoordinateOperationFactory operationFactory = CRS.getCoordinateOperationFactory(false);

                Set<CoordinateOperation> ops = operationFactory.findOperations(sourceCRS, targetCRS);

                for (CoordinateOperation op: ops) {

                        DefaultTransformation def = new DefaultTransformation(op);

                        transforms.add(def);

                }

                } catch (FactoryException | ClassCastException e) {

                        throw new UnsupportedTransformationException(e);

                }

                return transforms;

        }

        @Override

        public List<TransformationDefinition> getCoordinateTransformations(String source, String target) throws UnsupportedTransformationException {

                ArrayList<TransformationDefinition> transforms = new ArrayList<TransformationDefinition>();

                try {

                        CoordinateReferenceSystem sourceCRS = CRS.decode(source);

                        CoordinateReferenceSystem targetCRS = CRS.decode(target);

                CoordinateOperationFactory operationFactory = CRS.getCoordinateOperationFactory(false);

                Set<CoordinateOperation> ops = operationFactory.findOperations(sourceCRS, targetCRS);

                for (CoordinateOperation op: ops) {

                        DefaultTransformation def = new DefaultTransformation(op);

                        transforms.add(def);

                }

                } catch (FactoryException e) {

                        throw new UnsupportedTransformationException(e);

                }

                return transforms;

        }

        /**

         * Sets the path to the folder to be used by the library to load the CRS and

         * transformation definitions. The specified path must contain one or more subfolders,

         * containg the CRS and transformation database in the appropriate format:

         * <ul><li>for EPSG database: a "epsg" subfolder must exist, which contains a HSQL database

         * called "EPSG". The structure of this database must be the same used by Geotools,

         * which is essentially based in the EPSG data model.</li>

         * </ul>

         * 

         * This method only has effect when it is called before any other method in the manager

         * (before instantiating any CRS, transformation, etc). 

         * 

         * @param path The path to the folder containing the system CRS and transformation

         * definitions

         */

        @Override

        public void setSystemDataPath(File path) {

                System.setProperty(HsqlEpsgDatabase.DIRECTORY_KEY, path.getAbsolutePath() + "/" + EPSG_DB_SUBFOLDER);

        }

        @Override

        public void setUserDataPath(File path) {

                // TODO Auto-generated method stub

        }

        @Override

        public List<TextSerialization.Format> getSupportedFormats() {

                // TODO Auto-generated method stub

                return SUPPORTED_FORMATS;

        }

}