i have develop a flask rest API that works with Postgres and SQl Alchemy. Now i need to do a spatial query on PostGIS. I have wrote this query:
SELECT cod, ST_AsText(ST_3DClosestPoint(
ST_AsEWKT(geom),
'SRID=4326; POINT(X_VALUE Y_VALUE)'::geometry)), ST_Distance(geom, 'SRID=4326; POINT(X_VALUE Y_VALUE)'::geometry)
FROM db.linefeature
WHERE ST_DWithin(geom, 'SRID=4326; POINT(X_VALUE Y_VALUE)'::geometry, 100)
ORDER BY cod_id, ST_DISTANCE(geom, 'SRID=4326; POINT(X_VALUE Y_VALUE)'::geometry);
How i can implement this query in a POST request using SQL Alchemy or GeoAlchemy and return the result into a JSON? Any help is great. Thanks