Application: gvSIG desktop

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Within extends Functions.AbstractFunction {

    public ST_Within(SQLiteConnection conn) {

        super("ST_Within", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            byte[] bytes2 = value_blob(1);

            if (bytes2 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            Geometry geom2 = parser.parseToGeometry(conn, bytes2);

            if (geom2 == null) {

                this.result();

                return;

            }

            this.result(geom1.within(geom2) ? 1 : 0);

        } catch (Throwable ex) {

            throw new SQLException("Can't evaluate if the first geometry is within the second", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Area extends Functions.AbstractFunction {

    public ST_Area(SQLiteConnection conn) {

        super("ST_Area", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            this.result(geom1.area());

        } catch (Throwable ex) {

            throw new SQLException("Can't get geometry's area", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_AsText extends Functions.AbstractFunction {

    public ST_AsText(SQLiteConnection conn) {

        super("ST_AsText", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            this.result(geom1.convertToWKTQuietly());

        } catch (Throwable ex) {

            throw new SQLException("Can't get geometry's WKT", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.primitive.Point;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Y extends Functions.AbstractFunction {

    public ST_Y(SQLiteConnection conn) {

        super("ST_Y", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            this.result(((Point)geom1).getY());

        } catch (Throwable ex) {

            throw new SQLException("Can't get the coordinate Y of the geometry", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.primitive.Primitive;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_GeometryN extends Functions.AbstractFunction {

    public ST_GeometryN(SQLiteConnection conn) {

        super("ST_GeometryN", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            int n = value_int(1);

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();

            if( geom1 instanceof org.gvsig.fmap.geom.aggregate.Aggregate ) {

                Primitive p = ((org.gvsig.fmap.geom.aggregate.Aggregate) geom1).getPrimitiveAt(n);

                builder.setGeometry(conn, p);

            }

            byte[] bytes = builder.build();

            if (bytes == null) {

                this.result();

            } else {

                this.result(bytes);

            }

        } catch (Throwable ex) {

            throw new SQLException("Can't get the N component from the geometry", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.cresques.cts.ICoordTrans;

import org.cresques.cts.IProjection;

import org.gvsig.expressionevaluator.ExpressionRuntimeException;

import org.gvsig.fmap.crs.CRSFactory;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Transform extends Functions.AbstractFunction {

    public ST_Transform(SQLiteConnection conn) {

        super("ST_Transform", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom = parser.parseToGeometry(conn,bytes1);

            if (geom == null) {

                this.result();

                return;

            }

            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();

            IProjection  to_proj = null;

            IProjection from_proj = null;

            Integer to_srid = null;

            Integer from_srid = null;

            switch (args()) {

                case 2:

                    to_srid = value_int(1);

//                    to_srid = (Integer) DataTypeUtils.coerce(DataTypes.INT, getObject(args, 1), null);

//                    if (to_srid == null) {

//                        to_proj = CRSFactory.getCRS(value_text(1));

//                    } else {

//                        to_proj = CRSFactory.getCRS("EPSG:" + to_srid);

//                    }

                    to_proj = CRSFactory.getCRS("EPSG:" + to_srid);

                    from_proj = geom.getProjection();

                    break;

                case 3:

                    to_srid = value_int(2);

                    from_srid = value_int(1);

//                    to_srid = (Integer) DataTypeUtils.coerce(DataTypes.INT, getObject(args, 2), null);

//                    if (to_srid == null) {

//                        to_proj = CRSFactory.getCRS(getStr(args, 2));

//                    } else {

//                        to_proj = CRSFactory.getCRS("EPSG:" + to_srid);

//                    }

////                    from_proj = CRSFactory.getCRS(getStr(args, 1));

                    to_proj = CRSFactory.getCRS("EPSG:" + to_srid);

                    from_proj = CRSFactory.getCRS("EPSG:" + from_srid);

                    break;

                default:

                    throw new ExpressionRuntimeException("Incorrect number of arguments.");

            }

            ICoordTrans ct = from_proj.getCT(to_proj);

            Geometry reprojectedGeom = geom.cloneGeometry();

            reprojectedGeom.reProject(ct);

            builder.setGeometry(conn, reprojectedGeom);

            byte[] bytes = builder.build();

            if (bytes == null) {

                this.result();

            } else {

                this.result(bytes);

            }

        } catch (Throwable ex) {

            throw new SQLException("Can't transform the geometry", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Envelope extends Functions.AbstractFunction {

    public ST_Envelope(SQLiteConnection conn) {

        super("ST_Envelope", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes = value_blob(0);

            if (bytes == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom = parser.parseToGeometry(conn,bytes);

            if (geom == null) {

                this.result();

                return;

            }

            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();

            builder.setGeometry(conn, geom.getEnvelope().getGeometry());

            bytes = builder.build();

            if (bytes == null) {

                this.result();

            } else {

                this.result(bytes);

            }

        } catch (Throwable ex) {

            throw new SQLException("Can't get geometry's envelope", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.cresques.cts.IProjection;

import org.gvsig.expressionevaluator.ExpressionRuntimeException;

import org.gvsig.fmap.crs.CRSFactory;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.primitive.Primitive;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_SetSRID extends Functions.AbstractFunction {

    public ST_SetSRID(SQLiteConnection conn) {

        super("ST_SetSRID", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            String srid = value_text(1);

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom = parser.parseToGeometry(conn,bytes1);

            if (geom == null) {

                this.result();

                return;

            }

            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();

            IProjection proj = CRSFactory.getCRS("EPSG:" + srid);

            if (proj == null) {

                throw new ExpressionRuntimeException("Invalid SRID '" + srid + "'.");

            }

            geom.setProjection(proj);

            builder.setGeometry(conn, geom);

            byte[] bytes = builder.build();

            if (bytes == null) {

                this.result();

            } else {

                this.result(bytes);

            }

        } catch (Throwable ex) {

            throw new SQLException("Can't assign the projection to the geometry", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Contains extends Functions.AbstractFunction {

    public ST_Contains(SQLiteConnection conn) {

        super("ST_Contains", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            byte[] bytes2 = value_blob(1);

            if (bytes2 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            Geometry geom2 = parser.parseToGeometry(conn, bytes2);

            if (geom2 == null) {

                this.result();

                return;

            }

            this.result(geom1.contains(geom2) ? 1 : 0);

        } catch (Throwable ex) {

            throw new SQLException("I can't evaluate if the first geometry contains the second", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_CoveredBy extends Functions.AbstractFunction {

    public ST_CoveredBy(SQLiteConnection conn) {

        super("ST_CoveredBy", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            byte[] bytes2 = value_blob(1);

            if (bytes2 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            Geometry geom2 = parser.parseToGeometry(conn, bytes2);

            if (geom2 == null) {

                this.result();

                return;

            }

            this.result(geom1.coveredBy(geom2) ? 1 : 0);

        } catch (Throwable ex) {

            throw new SQLException("I can't evaluate if the first geometry is covered by the second", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Boundary extends Functions.AbstractFunction {

    public ST_Boundary(SQLiteConnection conn) {

        super("ST_Boundary", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes = value_blob(0);

            if (bytes == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom = parser.parseToGeometry(conn,bytes);

            if (geom == null) {

                this.result();

                return;

            }

            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();

            builder.setGeometry(conn, geom.boundary());

            bytes = builder.build();

            if (bytes == null) {

                this.result();

            } else {

                this.result(bytes);

            }

        } catch (Throwable ex) {

            throw new SQLException("Can't get geometry's boundary", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Force2D extends Functions.AbstractFunction {

    public ST_Force2D(SQLiteConnection conn) {

        super("ST_Force2D", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes = value_blob(0);

            if (bytes == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom = parser.parseToGeometry(conn,bytes);

            if (geom == null) {

                this.result();

                return;

            }

            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();

            builder.setGeometry(conn, geom.forceSubtype(Geometry.SUBTYPES.GEOM2D));

            bytes = builder.build();

            if (bytes == null) {

                this.result();

            } else {

                this.result(bytes);

            }

        } catch (Throwable ex) {

            throw new SQLException("Can't force to 2D the geometry", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Union extends Functions.AbstractFunction {

    public ST_Union(SQLiteConnection conn) {

        super("ST_Union", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            byte[] bytes2 = value_blob(1);

            if (bytes2 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            Geometry geom2 = parser.parseToGeometry(conn, bytes2);

            if (geom2 == null) {

                this.result();

                return;

            }

            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();

            builder.setGeometry(conn, geom1.union(geom2));

            byte[] bytes = builder.build();

            if (bytes == null) {

                this.result();

            } else {

                this.result(bytes);

            }

        } catch (Throwable ex) {

            throw new SQLException("Can't build the geometries' union", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Difference extends Functions.AbstractFunction {

    public ST_Difference(SQLiteConnection conn) {

        super("ST_Difference", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            byte[] bytes2 = value_blob(1);

            if (bytes2 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            Geometry geom2 = parser.parseToGeometry(conn, bytes2);

            if (geom2 == null) {

                this.result();

                return;

            }

            GeopackageGeometryBuilder builder = GeopackageUtils.createGeometryBuilder();

            builder.setGeometry(conn, geom1.difference(geom2));

            byte[] bytes = builder.build();

            if (bytes == null) {

                this.result();

            } else {

                this.result(bytes);

            }

        } catch (Throwable ex) {

            throw new SQLException("Can't build the difference of the geometries", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_IsValid extends Functions.AbstractFunction {

    public ST_IsValid(SQLiteConnection conn) {

        super("ST_IsValid", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes = value_blob(0);

            if (bytes == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom = parser.parseToGeometry(conn,bytes);

            if (geom == null) {

                this.result();

                return;

            }

            this.result(geom.isValid() ? 1 : 0);

        } catch (Throwable ex) {

            throw new SQLException("Can't evaluate if the geometry is valid", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.primitive.OrientablePrimitive;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_NumPoints extends Functions.AbstractFunction {

    public ST_NumPoints(SQLiteConnection conn) {

        super("ST_NumPoints", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            if( geom1 instanceof OrientablePrimitive ) {

                this.result(((OrientablePrimitive) geom1).getNumVertices());

            }

            //FIXME: null or 0 ???

            this.result();

        } catch (Throwable ex) {

            throw new SQLException("I can't get the number of point of the geometry", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Perimeter extends Functions.AbstractFunction {

    public ST_Perimeter(SQLiteConnection conn) {

        super("ST_Perimeter", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            this.result(geom1.perimeter());

        } catch (Throwable ex) {

            throw new SQLException("Can't get geometry's perimeter", ex);

        }

    }

}

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.cresques.cts.IProjection;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_SRID extends Functions.AbstractFunction {

    public ST_SRID(SQLiteConnection conn) {

        super("ST_SRID", conn);

    }

    @Override

    protected void xFunc() throws SQLException {

        try {

            byte[] bytes1 = value_blob(0);

            if (bytes1 == null) {

                this.result();

                return;

            }

            SQLiteConnection conn = this.getConnection();

            GeopackageGeometryParser parser = GeopackageUtils.createGeometryParser();

            Geometry geom1 = parser.parseToGeometry(conn,bytes1);

            if (geom1 == null) {

                this.result();

                return;

            }

            IProjection projection = geom1.getProjection();

            if (projection == null) {

                this.result(0);

                return;

            }

            String[] x = projection.getAbrev().split(":");

            try {

                int code = Integer.parseInt(x[1]);

                this.result(code);

            } catch (Exception ex) {

                this.result(-1);

            }

        } catch (Throwable ex) {

            throw new SQLException("Can't get the geometry's projection", ex);

        }

    }

}

            new ST_ExtentAggregate(conn),

            new ST_Area(conn),

            new ST_AsText(conn),

            new ST_Boundary(conn),

            new ST_Buffer(conn),

            new ST_Centroid(conn),

            new ST_Contains(conn),

            new ST_ConvexHull(conn),

            new ST_CoveredBy(conn),

            new ST_Covers(conn),

            new ST_Crosses(conn),

            new ST_Difference(conn),

            new ST_Dimension(conn),

            new ST_Disjoint(conn),

            new ST_EndPoint(conn),

            new ST_Envelope(conn),

            new ST_Force2D(conn),

            new ST_GeometryN(conn),

            new ST_GeomFromText(conn),

            new ST_Intersection(conn),

            new ST_IsSimple(conn),

            new ST_IsValid(conn),

            new ST_MakePoint(conn),

            new ST_NumGeometries(conn),

            new ST_NumPoints(conn),

            new ST_Overlaps(conn),

            new ST_Perimeter(conn),

            new ST_Point(conn),

            new ST_PointN(conn),

            new ST_SetSRID(conn),

            new ST_SRID(conn),

            new ST_StartPoint(conn),

            new ST_Touches(conn),

            new ST_Transform(conn),

            new ST_Union(conn),

            new ST_Within(conn),

            new ST_X(conn),

            new ST_Y(conn),

            new ST_Z(conn)

/*

 * gvSIG. Desktop Geographic Information System.

 * 

 * Copyright (C) 2007-2020 gvSIG Association.

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 * 

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License 

 * along with this program. If not, see <https://www.gnu.org/licenses/>. 

 * 

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.sqlite.dal.functions;

import java.sql.SQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryBuilder;

import org.gvsig.sqlite.dal.geopackage.GeopackageGeometryParser;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class ST_Intersection extends Functions.AbstractFunction {

    public ST_Intersection(SQLiteConnection conn) {

        super("ST_Intersection", conn);