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