Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1 Rispondi
4506 Visualizzazioni

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
Abbandona
Risposta migliore

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
Abbandona
Post correlati Risposte Visualizzazioni Attività
0
feb 25
2263
2
gen 25
9118
2
gen 24
10138
7
gen 24
49996
0
mar 23
2502