Skip to Content
Dette spørgsmål er blevet anmeldt
postgresqlpostgis
1 Svar
4873 Visninger
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
Kassér
Avatar
Devendra Kavthekar
Bedste svar

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
Kassér
Related Posts Besvarelser Visninger Aktivitet
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released
postgresql
Avatar
0
feb. 25
2891
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied
postgresql
Avatar
Avatar
Avatar
2
jan. 25
10065
Odoo backend to Google Data Studio Løst
postgresql
Avatar
Avatar
2
jan. 24
10139
Reason why Odoo being slow when there is huge data inside the database
postgresql
Avatar
Avatar
Avatar
Avatar
7
jan. 24
50902
Postgresql db connection failing often and causing http 500 error Odoo v11
postgresql
Avatar
0
mar. 23
2871