I would like to dump data from my survey software to a geopackage file through an ODBC connection but I need a minimum of spatial functions to execute my requests: ST_IsEmpty(geom), ST_MinX(geom), ST_MaxX(geom), ST_MinY(geom), ST_MaxY(geom), GeomFromEwkt, St_Multi.
Here's a exemple of my PostGIS request through ODBC:
| INSERT INTO myTab | ( name, | date_cmp, | geom) | VALUES | ([myPoint], | to_timestamp([[myPoint]:DT]), | ST_SetSRID(GeomFromEwkt('JS_WKT([myPoint],P3)'),3163) | );
JS_WKT(component,type) is producing an EWKT.
My gpkg is a template file made by qgis 2.18.17 my software will copy an fill with Insert requests.
My question is a little similar to geopackage-update-query-generates-an-error-no-such-function-st-isempty