I have a GeoPackage that is downloaded to client devices for a mobile app. I need the clients to query the GeoPackage to retrieve a GeoJSON representation of the
geom column. I'm familiar with
ST_AsGeoJSON(geom) available in PostGIS, but I cannot find a similar solution using a GeoPackage.
How can I transform the
geom column into GeoJSON? Ideally it would be in a query, but if that's not available I'd like to know how to convert the
geom binary myself programmatically.