Using information from here, I am trying to load a result of a SQL Python selection into a Geopandas geodataframe. I know pyspatialite is not longer maintained, so have tried using the dbapi2 module from sqlite3. When I run the line:
df = gpd.GeoDataFrame.from_postgis("SELECT name, Hex(ST_AsBinary(geometry, 27700)) as geom FROM table;", conn, geom_col='geom')
I get an error:
no such function: ST_AsBinary. I thought that that was a basic Python command. Am I missing something?