Skip to Content
This question has been flagged
geospatialgeoengineodoo
1 Respondre
5179 Vistes
Avatar
josemi

Looking google maps have located 4 points and have created a polygon with them in this way

insert into dummy_zip values (4,'prueba_directa','2016-04-13 08:08:15.973731','prueba_directa',1,1,100,'2016-04-13 08:08:15.973731',(SELECT ST_Transform(ST_GeomFromText('MULTIPOLYGON(((37.986504 -1.121951,37.986741 -1.121243,37.985794 -1.120792,37.985608 -1.121479,37.986504 -1.121951)))',4326),900913)));

but when displayed on the map in a completely different location that should be, because it can be?


Avatar
Descartar
Avatar
josemi
Autor Best Answer

Solved, i'm stupid.  I mistook  longitude and latitude, the correct sentence is

insert into dummy_zip values (4,'prueba_directa','2016-04-13 08:08:15.973731','prueba_directa',1,1,100,'2016-04-13 08:08:15.973731',(SELECT ST_Transform(ST_GeomFromText('MULTIPOLYGON(((-1.121951 37.986504,-1.121243 37.986741,-1.120792 37.985794,-1.121479 37.985608,-1.121951 37.986504)))',4326),900913)));

Avatar
Descartar
Related Posts Respostes Vistes Activitat
GeoEngine install error in Odoo 10
geospatial geoengine odoo10
Avatar
0
de jul. 17
3957
GeoSpatial View Definition
view geospatial geo geoengine
Avatar
0
de març 15
4849
How do I go about this error? I am trying to uninstall a module
odoo
Avatar
0
de nov. 25
3368
How to import product variants with my own external id when using dynamic creation mode Solved
odoo
Avatar
Avatar
2
d’ag. 25
3948
How to import Bulk Image in Product your local database not any cloud, odoo.sh Solved
odoo
Avatar
Avatar
1
de jul. 25
1943