Skip to Content
This question has been flagged
postgresqlpostgis
1 Reply
3251 Views
Avatar
pawan

Hi,I want to insert and retrieve some geographical data in my database.I am using PostGIS to do that.currently, I am using self._cr.execute() to run my commands. but I want to know if there is a way to do this without executing the raw query.Query I am using write now'''select ST_AsGeoJSON(geom),
farmid from geojson where ST_Distance_Sphere(
ST_Point(ST_X(ST_Centroid(geom)), ST_Y(ST_Centroid(geom))),
(ST_MakePoint({lati}, {longi}))) <= {radius}'''.format(
lati=lati, longi=longi, radius=radius)

Avatar
Discard
Avatar
Devendra Kavthekar
Best Answer

You can import the geojson data and create the shapes with coordinates, coordinates should follow same standard, otherwise the coordinates location you expect might land nowhere in sea!

You can also use oca/geospatial, QGIS and xmlrpc.

Avatar
Discard
Related Posts Replies Views Activity
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied
postgresql
Avatar
Avatar
1
Jul 24
3499
Odoo backend to Google Data Studio Solved
postgresql
Avatar
Avatar
2
Jan 24
10135
Reason why Odoo being slow when there is huge data inside the database
postgresql
Avatar
Avatar
Avatar
Avatar
7
Jan 24
45459
Postgresql db connection failing often and causing http 500 error Odoo v11
postgresql
Avatar
0
Mar 23
1038
postgresql user and password
postgresql
Avatar
Avatar
5
Apr 24
45315